CREATE TABLE cml_landed_cost_charges (
    LANDED_COST_CHARGE_ID             NUMBER(18, 0),
    MATERIAL_PC_BU_ID                 NUMBER(18, 0)    NOT NULL,
    INVENTORY_ORG_ID                  NUMBER(18, 0)    NOT NULL,
    CMR_RCV_TRANSACTION_ID            NUMBER(18, 0)    NOT NULL,
    RECEIPT_DATE                      DATE             NOT NULL,
    TRADE_OPERATION_ID                NUMBER(18, 0)    NOT NULL,
    TRANSACTION_TYPE_CODE             VARCHAR2(120)    NOT NULL,
    PROCUREMENT_BU_ID                 NUMBER(18, 0)    NOT NULL,
    TRADE_OPERATION_STATUS_CODE       VARCHAR2(120)    NOT NULL,
    TRADE_OPERATION_ROUTE_ID          NUMBER(18, 0),
    CHARGE_ID                         NUMBER(18, 0)    NOT NULL,
    TROP_CHARGE_LINE_ID               NUMBER(18, 0)    NOT NULL,
    VENDOR_ID                         NUMBER(18, 0)    NOT NULL,
    VENDOR_SITE_ID                    NUMBER(18, 0)    NOT NULL,
    CHARGE_BU_ID                      NUMBER(18, 0)    NOT NULL,
    CMR_PO_LINE_LOCATION_ID           NUMBER(18, 0)    NOT NULL,
    ORDERED_QTY                       NUMBER           NOT NULL,
    PO_UOM_CODE                       VARCHAR2(12)     NOT NULL,
    TRACKED_QTY                       NUMBER           NOT NULL,
    RECEIPT_QTY_IN_PO_UOM             NUMBER           NOT NULL,
    PRIMARY_UOM_CODE                  VARCHAR2(12)     NOT NULL,
    RECEIPT_QTY_IN_PRIMARY_UOM        NUMBER           NOT NULL,
    MATERIAL_VENDOR_ID                NUMBER(18, 0)    NOT NULL,
    MATERIAL_VENDOR_SITE_ID           NUMBER(18, 0)    NOT NULL,
    ITEM_CATEGORY_ID                  NUMBER(18, 0)    NOT NULL,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)    NOT NULL,
    PO_ITEM_PRICE                     NUMBER           NOT NULL,
    PO_NONRECOVERABLE_TAX             NUMBER       ,
    CHARGE_CURRENCY_CODE              VARCHAR2(60) ,
    MAT_PC_BU_FUNC_CURRENCY_CODE      VARCHAR2(60)     NOT NULL,
    CHARGE_BU_FUNC_CURRENCY_CODE      VARCHAR2(60)     NOT NULL,
    INVOICE_CURRENCY_CODE             VARCHAR2(60) ,
    INVOICE_ID                        NUMBER(18, 0),
    INVOICE_LINE_NUMBER               NUMBER(18, 0),
    EST_UNIT_AMT_IN_CHARGE_CURR       NUMBER       ,
    EST_UNIT_TAX_IN_CHARGE_CURR       NUMBER       ,
    EST_UNIT_AMT_IN_MAT_PC_BU_CURR    NUMBER       ,
    EST_UNIT_TAX_IN_MAT_PC_BU_CURR    NUMBER       ,
    EST_UNIT_AMT_IN_CHARGE_BU_CURR    NUMBER       ,
    EST_UNIT_TAX_IN_CHARGE_BU_CURR    NUMBER       ,
    ACT_UNIT_AMT_IN_INVOICE_CURR      NUMBER       ,
    ACT_UNIT_TAX_IN_INVOICE_CURR      NUMBER       ,
    ACT_UNIT_AMT_IN_MAT_PC_BU_CURR    NUMBER       ,
    ACT_UNIT_TAX_IN_MAT_PC_BU_CURR    NUMBER       ,
    ACT_UNIT_AMT_IN_CHARGE_BU_CURR    NUMBER       ,
    ACT_UNIT_TAX_IN_CHARGE_BU_CURR    NUMBER       ,
    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),
    RECORD_UPDATE_DATE                TIMESTAMP(6)     NOT NULL,
    VERSION_ID                        NUMBER(18, 0)    NOT NULL,
    ACTIVE_FLAG                       VARCHAR2(4)      NOT NULL,
    LANDED_COST_CHARGE_ID             NUMBER(18, 0),
    MATERIAL_PC_BU_ID                 NUMBER(18, 0)    NOT NULL,
    INVENTORY_ORG_ID                  NUMBER(18, 0)    NOT NULL,
    CMR_RCV_TRANSACTION_ID            NUMBER(18, 0)    NOT NULL,
    RECEIPT_DATE                      DATE             NOT NULL,
    TRADE_OPERATION_ID                NUMBER(18, 0)    NOT NULL,
    TRANSACTION_TYPE_CODE             VARCHAR2(120)    NOT NULL,
    PROCUREMENT_BU_ID                 NUMBER(18, 0)    NOT NULL,
    TRADE_OPERATION_STATUS_CODE       VARCHAR2(120)    NOT NULL,
    TRADE_OPERATION_ROUTE_ID          NUMBER(18, 0),
    CHARGE_ID                         NUMBER(18, 0)    NOT NULL,
    TROP_CHARGE_LINE_ID               NUMBER(18, 0)    NOT NULL,
    VENDOR_ID                         NUMBER(18, 0)    NOT NULL,
    VENDOR_SITE_ID                    NUMBER(18, 0)    NOT NULL,
    CHARGE_BU_ID                      NUMBER(18, 0)    NOT NULL,
    CMR_PO_LINE_LOCATION_ID           NUMBER(18, 0)    NOT NULL,
    ORDERED_QTY                       NUMBER           NOT NULL,
    PO_UOM_CODE                       VARCHAR2(12)     NOT NULL,
    TRACKED_QTY                       NUMBER           NOT NULL,
    RECEIPT_QTY_IN_PO_UOM             NUMBER           NOT NULL,
    PRIMARY_UOM_CODE                  VARCHAR2(12)     NOT NULL,
    RECEIPT_QTY_IN_PRIMARY_UOM        NUMBER           NOT NULL,
    MATERIAL_VENDOR_ID                NUMBER(18, 0)    NOT NULL,
    MATERIAL_VENDOR_SITE_ID           NUMBER(18, 0)    NOT NULL,
    ITEM_CATEGORY_ID                  NUMBER(18, 0)    NOT NULL,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)    NOT NULL,
    PO_ITEM_PRICE                     NUMBER           NOT NULL,
    PO_NONRECOVERABLE_TAX             NUMBER       ,
    CHARGE_CURRENCY_CODE              VARCHAR2(60) ,
    MAT_PC_BU_FUNC_CURRENCY_CODE      VARCHAR2(60)     NOT NULL,
    CHARGE_BU_FUNC_CURRENCY_DOCE      VARCHAR2(60) ,
    INVOICE_CURRENCY_CODE             VARCHAR2(60) ,
    INVOICE_ID                        NUMBER(18, 0),
    INVOICE_LINE_NUMBER               NUMBER(18, 0),
    EST_UNIT_AMT_IN_CHARGE_CURR       NUMBER       ,
    EST_UNIT_TAX_IN_CHARGE_CURR       NUMBER       ,
    EST_UNIT_AMT_IN_MAT_PC_BU_CURR    NUMBER       ,
    EST_UNIT_TAX_IN_MAT_PC_BU_CURR    NUMBER       ,
    EST_UNIT_AMT_IN_CHARGE_BU_CURR    NUMBER       ,
    EST_UNIT_TAX_IN_CHARGE_BU_CURR    NUMBER       ,
    ACT_UNIT_AMT_IN_INVOICE_CURR      NUMBER       ,
    ACT_UNIT_TAX_IN_INVOICE_CURR      NUMBER       ,
    ACT_UNIT_AMT_IN_MAT_PC_BU_CURR    NUMBER       ,
    ACT_UNIT_TAX_IN_MAT_PC_BU_CURR    NUMBER       ,
    ACT_UNIT_AMT_IN_CHARGE_BU_CURR    NUMBER       ,
    ACT_UNIT_TAX_IN_CHARGE_BU_CURR    NUMBER       ,
    CREATED_BY                        VARCHAR2(256)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    CUBE_LOAD_REQUIRED_FLAG           VARCHAR2(4)  ,
    LAST_UPDATE_DATE                  TIMESTAMP(6)     NOT NULL,
    CHARGE_BU_FUNC_CURRENCY_CODE      VARCHAR2(60)     NOT NULL,
    RECORD_UPDATE_DATE                TIMESTAMP(6)     NOT NULL,
    VERSION_ID                        NUMBER(18, 0)    NOT NULL,
    ACTIVE_FLAG                       VARCHAR2(4)      NOT NULL,
    CONSTRAINT pk_cml_landed_cost_charges PRIMARY KEY (LANDED_COST_CHARGE_ID, LANDED_COST_CHARGE_ID)
);
