CREATE TABLE cmr_accr_reconc_gt (
    SOLD_TO_BUSINESS_UNIT_ID        NUMBER(18, 0),
    BILL_TO_BUSINESS_UNIT_ID        NUMBER(18, 0),
    CMR_PO_DISTRIBUTION_ID          NUMBER(18, 0),
    ACCRUAL_ACCOUNT_ID              NUMBER(18, 0),
    CHART_OF_ACCOUNTS_ID            NUMBER(18, 0),
    EVENT_TRANSACTION_DATE          TIMESTAMP(6) ,
    EVENT_ACCOUNTED_AMT             NUMBER       ,
    EVENT_TYPE_CODE                 VARCHAR2(100),
    EVENT_ENTERED_AMT               NUMBER       ,
    EVENT_UOM_CODE                  VARCHAR2(12) ,
    CURRENCY_CODE                   VARCHAR2(60) ,
    CURRENCY_CONVERSION_TYPE        VARCHAR2(120),
    CURRENCY_CONVERSION_RATE        NUMBER       ,
    CURRENCY_CONVERSION_DATE        TIMESTAMP(6) ,
    ACCOUNTING_EVENT_ID             NUMBER(18, 0),
    EVENT_COST_ID                   NUMBER(18, 0),
    CMR_SUB_LEDGER_ID               NUMBER(18, 0),
    SLA_EVENT_ID                    NUMBER(18, 0),
    INVENTORY_ORG_ID                NUMBER(18, 0),
    INVENTORY_ITEM_ID               NUMBER(18, 0),
    DESTINATION_TYPE_CODE           VARCHAR2(100),
    EVENT_COST_SOURCE               VARCHAR2(120),
    EVENT_DISTRIBUTION_TYPE         VARCHAR2(200),
    EVENT_TRANSACTION_NUMBER        VARCHAR2(200),
    INVOICE_DISTRIBUTION_ID         NUMBER(18, 0),
    CMR_RCV_TRANSACTION_ID          NUMBER(18, 0),
    ACCRUAL_CLR_ID                  NUMBER(18, 0),
    EVENT_QTY                       NUMBER       ,
    TRADE_EVENT_ID                  NUMBER(18, 0),
    SLA_AE_HEADER_ID                NUMBER(18, 0),
    SLA_AE_LINE_NUM                 NUMBER(18, 0),
    LEDGER_CURRENCY_CODE            VARCHAR2(60) ,
    LE_TIMEZONE_TRANSACTION_DATE    TIMESTAMP(6) ,
    LE_ENABLED_FLAG                 VARCHAR2(4)  ,
    TRANSACTION_DATE_ORDER          TIMESTAMP(6) ,
    LE_TIMEZONE_CODE                VARCHAR2(200),
    TXN_AMT                         NUMBER       ,
    TXN_ACCRUAL_AMT                 NUMBER       ,
    TXN_NR_TAX_AMT                  NUMBER       ,
    TXN_REC_TAX_AMT                 NUMBER       ,
    TXN_ACCT_DATE                   TIMESTAMP(6) ,
    DISTRIBUTION_STATUS             VARCHAR2(20) ,
    SOLD_TO_BUSINESS_UNIT_ID        NUMBER(18, 0),
    BILL_TO_BUSINESS_UNIT_ID        NUMBER(18, 0),
    CMR_PO_DISTRIBUTION_ID          NUMBER(18, 0),
    ACCRUAL_ACCOUNT_ID              NUMBER(18, 0),
    CHART_OF_ACCOUNTS_ID            NUMBER(18, 0),
    EVENT_TRANSACTION_DATE          TIMESTAMP(6) ,
    EVENT_ACCOUNTED_AMT             NUMBER       ,
    EVENT_TYPE_CODE                 VARCHAR2(100),
    EVENT_ENTERED_AMT               NUMBER       ,
    EVENT_UOM_CODE                  VARCHAR2(12) ,
    CURRENCY_CODE                   VARCHAR2(60) ,
    CURRENCY_CONVERSION_TYPE        VARCHAR2(120),
    CURRENCY_CONVERSION_RATE        NUMBER       ,
    CURRENCY_CONVERSION_DATE        TIMESTAMP(6) ,
    ACCOUNTING_EVENT_ID             NUMBER(18, 0),
    EVENT_COST_ID                   NUMBER(18, 0),
    CMR_SUB_LEDGER_ID               NUMBER(18, 0),
    SLA_EVENT_ID                    NUMBER(18, 0),
    INVENTORY_ORG_ID                NUMBER(18, 0),
    INVENTORY_ITEM_ID               NUMBER(18, 0),
    DESTINATION_TYPE_CODE           VARCHAR2(100),
    EVENT_COST_SOURCE               VARCHAR2(120),
    EVENT_DISTRIBUTION_TYPE         VARCHAR2(200),
    EVENT_TRANSACTION_NUMBER        VARCHAR2(200),
    INVOICE_DISTRIBUTION_ID         NUMBER(18, 0),
    CMR_RCV_TRANSACTION_ID          NUMBER(18, 0),
    ACCRUAL_CLR_ID                  NUMBER(18, 0),
    EVENT_QTY                       NUMBER       ,
    TRADE_EVENT_ID                  NUMBER(18, 0),
    SLA_AE_HEADER_ID                NUMBER(18, 0),
    SLA_AE_LINE_NUM                 NUMBER(18, 0),
    LEDGER_CURRENCY_CODE            VARCHAR2(60) ,
    LE_TIMEZONE_TRANSACTION_DATE    TIMESTAMP(6) ,
    LE_ENABLED_FLAG                 VARCHAR2(4)  ,
    TRANSACTION_DATE_ORDER          TIMESTAMP(6) ,
    LE_TIMEZONE_CODE                VARCHAR2(200),
    TXN_AMT                         NUMBER       ,
    TXN_ACCRUAL_AMT                 NUMBER       ,
    TXN_NR_TAX_AMT                  NUMBER       ,
    TXN_REC_TAX_AMT                 NUMBER       ,
    TXN_ACCT_DATE                   TIMESTAMP(6) ,
    DISTRIBUTION_STATUS             VARCHAR2(20) 
);
