CREATE TABLE cmr_accrual_summary (
    CMR_PO_DISTRIBUTION_ID      NUMBER(18, 0) ,
    PO_LINE_LOCATION_ID         NUMBER(18, 0)     NOT NULL,
    CMR_PO_LINE_LOCATION_ID     NUMBER(18, 0) ,
    BILL_TO_BUSINESS_UNIT_ID    NUMBER(18, 0) ,
    INVENTORY_ITEM_ID           NUMBER(18, 0) ,
    ORGANIZATION_ID             NUMBER(18, 0) ,
    ORGANIZATION_CODE           VARCHAR2(72)  ,
    PROFIT_CENTER_BU_ID         NUMBER(18, 0) ,
    PO_NUMBER                   VARCHAR2(160) ,
    LINE_NUMBER                 VARCHAR2(160) ,
    SHIPMENT_NUMBER             VARCHAR2(160) ,
    DISTRIBUTION_NUMBER         VARCHAR2(160) ,
    ITEM_DESCRIPTION            VARCHAR2(960) ,
    DESTINATION_TYPE_CODE       VARCHAR2(100)     NOT NULL,
    VENDOR_ID                   NUMBER(18, 0) ,
    VENDOR_SITE_ID              NUMBER(18, 0) ,
    STATUS                      VARCHAR2(160) ,
    TRANSACTION_DATE            TIMESTAMP(6)  ,
    RECEIPT_TXN_DATE            TIMESTAMP(6)  ,
    INVOICE_ACCT_DATE           TIMESTAMP(6)  ,
    ACCOUNTED_DATE              TIMESTAMP(6)  ,
    ACCOUNTING_EVENT_ID         NUMBER(18, 0) ,
    CMR_AP_INVOICE_DIST_ID      NUMBER(18, 0) ,
    UOM_CODE                    VARCHAR2(12)  ,
    RECEIVED_QTY                NUMBER        ,
    INVOICE_QTY                 NUMBER        ,
    QTY_DIFFERENCE              NUMBER        ,
    RECEIVED_AMT                NUMBER        ,
    RECEIVED_ACCRUAL_AMT        NUMBER        ,
    RECEIVED_NONRECTAX_AMT      NUMBER        ,
    RECEIVED_RECTAX_AMT         NUMBER        ,
    INVOICE_AMT                 NUMBER        ,
    INVOICE_ACCRUAL_AMT         NUMBER        ,
    INVOICE_NONRECTAX_AMT       NUMBER        ,
    INVOICE_RECTAX_AMT          NUMBER        ,
    AMT_DIFFERENCE              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) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    JOB_DEFINITION_NAME         VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE      VARCHAR2(3600),
    LEDGER_CURRENCY_CODE        VARCHAR2(60)  ,
    MARKED_FOR_REVIEW           VARCHAR2(4)   ,
    CMR_PO_DISTRIBUTION_ID      NUMBER(18, 0) ,
    PO_LINE_LOCATION_ID         NUMBER(18, 0)     NOT NULL,
    CMR_PO_LINE_LOCATION_ID     NUMBER(18, 0) ,
    BILL_TO_BUSINESS_UNIT_ID    NUMBER(18, 0) ,
    INVENTORY_ITEM_ID           NUMBER(18, 0) ,
    ORGANIZATION_ID             NUMBER(18, 0) ,
    ORGANIZATION_CODE           VARCHAR2(72)  ,
    PROFIT_CENTER_BU_ID         NUMBER(18, 0) ,
    PO_NUMBER                   VARCHAR2(160) ,
    LINE_NUMBER                 VARCHAR2(160) ,
    SHIPMENT_NUMBER             VARCHAR2(160) ,
    DISTRIBUTION_NUMBER         VARCHAR2(160) ,
    ITEM_DESCRIPTION            VARCHAR2(960) ,
    DESTINATION_TYPE_CODE       VARCHAR2(100)     NOT NULL,
    VENDOR_ID                   NUMBER(18, 0) ,
    VENDOR_SITE_ID              NUMBER(18, 0) ,
    STATUS                      VARCHAR2(160) ,
    TRANSACTION_DATE            TIMESTAMP(6)  ,
    RECEIPT_TXN_DATE            TIMESTAMP(6)  ,
    INVOICE_ACCT_DATE           TIMESTAMP(6)  ,
    ACCOUNTED_DATE              TIMESTAMP(6)  ,
    ACCOUNTING_EVENT_ID         NUMBER(18, 0) ,
    CMR_AP_INVOICE_DIST_ID      NUMBER(18, 0) ,
    UOM_CODE                    VARCHAR2(12)  ,
    RECEIVED_QTY                NUMBER        ,
    INVOICE_QTY                 NUMBER        ,
    QTY_DIFFERENCE              NUMBER        ,
    RECEIVED_AMT                NUMBER        ,
    RECEIVED_ACCRUAL_AMT        NUMBER        ,
    RECEIVED_NONRECTAX_AMT      NUMBER        ,
    RECEIVED_RECTAX_AMT         NUMBER        ,
    INVOICE_AMT                 NUMBER        ,
    INVOICE_ACCRUAL_AMT         NUMBER        ,
    INVOICE_NONRECTAX_AMT       NUMBER        ,
    INVOICE_RECTAX_AMT          NUMBER        ,
    AMT_DIFFERENCE              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) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    JOB_DEFINITION_NAME         VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE      VARCHAR2(3600),
    LEDGER_CURRENCY_CODE        VARCHAR2(60)  ,
    MARKED_FOR_REVIEW           VARCHAR2(4)   ,
    CONSTRAINT pk_cmr_accrual_summary PRIMARY KEY (CMR_PO_DISTRIBUTION_ID, CMR_PO_DISTRIBUTION_ID)
);
