CREATE TABLE fnd_rra_supplier_inventory (
    SUPPLIER_INVENTORY_ID    NUMBER(18, 0) ,
    SUPPLIER_ID              NUMBER(18, 0)     NOT NULL,
    PRODUCT_NUMBER           NUMBER(18, 0)     NOT NULL,
    PRODUCT_NAME             VARCHAR2(4000)    NOT NULL,
    PRODUCT_DESCRIPTION      VARCHAR2(4000),
    IMAGE_URL                VARCHAR2(4000),
    COLOR                    VARCHAR2(120) ,
    AVAILABLE_QTY            NUMBER(18, 0)     NOT NULL,
    MSRP_UNIT_PRICE          NUMBER(7, 2)  ,
    SUPPLIER_UNIT_PRICE      NUMBER(7, 2)  ,
    WEIGHT                   VARCHAR2(1600),
    DIMENSIONS               VARCHAR2(1600),
    MIN_ORDER_QUANTITY       NUMBER            NOT NULL,
    CREATED_BY               VARCHAR2(256)     NOT NULL,
    CREATION_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    SUPPLIER_INVENTORY_ID    NUMBER(18, 0) ,
    SUPPLIER_ID              NUMBER(18, 0)     NOT NULL,
    PRODUCT_NUMBER           NUMBER(18, 0)     NOT NULL,
    PRODUCT_NAME             VARCHAR2(4000)    NOT NULL,
    PRODUCT_DESCRIPTION      VARCHAR2(4000),
    IMAGE_URL                VARCHAR2(4000),
    COLOR                    VARCHAR2(120) ,
    AVAILABLE_QTY            NUMBER(18, 0)     NOT NULL,
    MSRP_UNIT_PRICE          NUMBER(7, 2)  ,
    SUPPLIER_UNIT_PRICE      NUMBER(7, 2)  ,
    WEIGHT                   VARCHAR2(1600),
    DIMENSIONS               VARCHAR2(1600),
    MIN_ORDER_QUANTITY       NUMBER            NOT NULL,
    CREATED_BY               VARCHAR2(256)     NOT NULL,
    CREATION_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    CONSTRAINT pk_fnd_rra_supplier_inventory PRIMARY KEY (SUPPLIER_INVENTORY_ID, SUPPLIER_INVENTORY_ID)
);
