CREATE TABLE inv_cst_sales_order_details_gt (
    BILL_TO_CUSTOMER_ID               NUMBER(18, 0) ,
    RMA_REFERENCE_DOO_FLINE_ID        NUMBER(18, 0) ,
    CONVERSION_DATE                   DATE          ,
    CONVERSION_RATE                   VARCHAR2(40)  ,
    CONVERSION_TYPE_CODE              VARCHAR2(120) ,
    CUSTOMER_ID                       NUMBER(18, 0) ,
    DOO_LINE_ID                       NUMBER(18, 0) ,
    DOO_LINE_NUMBER                   NUMBER(9, 0)  ,
    DOO_ORDER_CURRENCY                VARCHAR2(60)  ,
    DOO_ORDER_HEADER_ID               NUMBER(18, 0) ,
    DOO_ORDER_NUMBER                  VARCHAR2(600) ,
    DOO_ORDERED_DATE                  TIMESTAMP(6)  ,
    DOO_UNIT_SELLING_PRICE            NUMBER        ,
    EXTERNAL_SYSTEM_REF_ID            VARCHAR2(1800)    NOT NULL,
    EXTERNAL_SYSTEM_REFERENCE         VARCHAR2(240)     NOT NULL,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)     NOT NULL,
    INVENTORY_ORGANIZATION_ID         NUMBER(18, 0)     NOT NULL,
    INV_TRANSACTION_ID                NUMBER(18, 0)     NOT NULL,
    PARENT_FULFILL_LINE_ID            NUMBER(18, 0) ,
    REFERENCED_DOO_FULFILL_LINE_ID    NUMBER(18, 0) ,
    ROOT_PARENT_FULFILL_LINE_ID       NUMBER(18, 0) ,
    SALES_REP_ID                      NUMBER(18, 0) ,
    SELLING_LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    SELLING_ORG_ID                    NUMBER(18, 0)     NOT NULL,
    SHIP_TO_CUSTOMER_ID               NUMBER(18, 0) ,
    SALES_ORDER_SHIPMENT_NUMBER       VARCHAR2(600) ,
    CUSTOMER_ACCOUNT_ID               NUMBER(18, 0) ,
    INVENTORY_INTERFACED_FLAG         VARCHAR2(4)   ,
    BILL_TO_SITE_USE_ID               NUMBER(18, 0) ,
    SHIP_TO_PARTY_ID                  NUMBER(18, 0) ,
    SHIP_TO_PARTY_SITE_ID             NUMBER(18, 0) ,
    SOLD_TO_PARTY_ID                  NUMBER(18, 0) ,
    CURRENCY_CONVERSION_RATE          NUMBER        ,
    BILL_TO_CUSTOMER_ID               NUMBER(18, 0) ,
    RMA_REFERENCE_DOO_FLINE_ID        NUMBER(18, 0) ,
    CONVERSION_DATE                   DATE          ,
    CONVERSION_RATE                   VARCHAR2(40)  ,
    CONVERSION_TYPE_CODE              VARCHAR2(120) ,
    CUSTOMER_ID                       NUMBER(18, 0) ,
    DOO_LINE_ID                       NUMBER(18, 0) ,
    DOO_LINE_NUMBER                   NUMBER(9, 0)  ,
    DOO_ORDER_CURRENCY                VARCHAR2(60)  ,
    DOO_ORDER_HEADER_ID               NUMBER(18, 0) ,
    DOO_ORDER_NUMBER                  VARCHAR2(600) ,
    DOO_ORDERED_DATE                  TIMESTAMP(6)  ,
    DOO_UNIT_SELLING_PRICE            NUMBER        ,
    EXTERNAL_SYSTEM_REF_ID            VARCHAR2(1800)    NOT NULL,
    EXTERNAL_SYSTEM_REFERENCE         VARCHAR2(240)     NOT NULL,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)     NOT NULL,
    INVENTORY_ORGANIZATION_ID         NUMBER(18, 0)     NOT NULL,
    INV_TRANSACTION_ID                NUMBER(18, 0)     NOT NULL,
    PARENT_FULFILL_LINE_ID            NUMBER(18, 0) ,
    REFERENCED_DOO_FULFILL_LINE_ID    NUMBER(18, 0) ,
    ROOT_PARENT_FULFILL_LINE_ID       NUMBER(18, 0) ,
    SALES_REP_ID                      NUMBER(18, 0) ,
    SELLING_LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    SELLING_ORG_ID                    NUMBER(18, 0)     NOT NULL,
    SHIP_TO_CUSTOMER_ID               NUMBER(18, 0) ,
    SALES_ORDER_SHIPMENT_NUMBER       VARCHAR2(600) ,
    CUSTOMER_ACCOUNT_ID               NUMBER(18, 0) ,
    INVENTORY_INTERFACED_FLAG         VARCHAR2(4)   ,
    BILL_TO_SITE_USE_ID               NUMBER(18, 0) ,
    SHIP_TO_PARTY_ID                  NUMBER(18, 0) ,
    SHIP_TO_PARTY_SITE_ID             NUMBER(18, 0) ,
    SOLD_TO_PARTY_ID                  NUMBER(18, 0) ,
    CURRENCY_CONVERSION_RATE          NUMBER        
);
