CREATE TABLE cmr_rcv_charges_gt (
    CMR_RCV_TRANSACTION_ID         NUMBER(18, 0),
    TRANSACTION_ID                 NUMBER(18, 0),
    CMR_PO_LINE_LOCATION_ID        NUMBER(18, 0),
    TROP_CHARGE_LINE_ID            NUMBER(18, 0),
    CHARGE_ID                      NUMBER(18, 0),
    FISCAL_DOC_LINE_ID             NUMBER(18, 0),
    RCV_CHARGE_ALLOC_ID            NUMBER(18, 0),
    RCV_CHARGE_ACTUAL_ID           NUMBER(18, 0),
    RCV_CHARGE_ESTIMATE_ID         NUMBER(18, 0),
    EFFECTIVE_DATE                 TIMESTAMP(6) ,
    UNIT_AMOUNT                    NUMBER       ,
    UNIT_TAX                       NUMBER       ,
    TOTAL_UNIT_AMOUNT              NUMBER       ,
    PRIOR_TOTAL_UNIT_AMOUNT        NUMBER       ,
    CHARGE_BU_ID                   NUMBER(18, 0),
    REQ_BU_ID                      NUMBER(18, 0),
    CMR_SRV_PO_LINE_LOCATION_ID    NUMBER(18, 0),
    SERVICE_PO_FLAG                VARCHAR2(4)  ,
    CONSIGNED_FLAG                 VARCHAR2(4)  ,
    DESTINATION_TYPE_CODE          VARCHAR2(100),
    TRANSACTION_TYPE               VARCHAR2(160),
    CURRENCY_CODE                  VARCHAR2(60) ,
    CURRENCY_CONVERSION_TYPE       VARCHAR2(120),
    CURRENCY_CONVERSION_RATE       NUMBER       ,
    CURRENCY_CONVERSION_DATE       TIMESTAMP(6) ,
    BILL_TO_BUSINESS_UNIT_ID       NUMBER(18, 0),
    INTERCOMPANY_BILL_TO_BU_ID     NUMBER(18, 0),
    SOURCE_DOC_NUMBER              VARCHAR2(200),
    CMR_ROOT_RCPT_TXN_ID           NUMBER(18, 0),
    SOURCE_DOC_LINE_NUMBER         VARCHAR2(160),
    SOURCE_DOC_SHIPMENT_NUMBER     VARCHAR2(160),
    SOURCE_DOC_DISTRIB_NUMBER      VARCHAR2(160),
    VENDOR_ID                      NUMBER(18, 0),
    VENDOR_SITE_ID                 NUMBER(18, 0),
    SHIP_TO_LOCATION_ID            NUMBER(18, 0),
    PO_ITEM_DESCRIPTION            VARCHAR2(960),
    PO_LINE_LOCATION_ID            NUMBER(18, 0),
    SHIP_TO_ORGANIZATION_ID        NUMBER(18, 0),
    RECEIPT_TRANSACTION_DATE       DATE         ,
    TRANSACTION_STATUS             VARCHAR2(4)  ,
    CMR_RCV_TRANSACTION_ID         NUMBER(18, 0),
    TRANSACTION_ID                 NUMBER(18, 0),
    CMR_PO_LINE_LOCATION_ID        NUMBER(18, 0),
    TROP_CHARGE_LINE_ID            NUMBER(18, 0),
    CHARGE_ID                      NUMBER(18, 0),
    FISCAL_DOC_LINE_ID             NUMBER(18, 0),
    RCV_CHARGE_ALLOC_ID            NUMBER(18, 0),
    RCV_CHARGE_ACTUAL_ID           NUMBER(18, 0),
    RCV_CHARGE_ESTIMATE_ID         NUMBER(18, 0),
    EFFECTIVE_DATE                 TIMESTAMP(6) ,
    UNIT_AMOUNT                    NUMBER       ,
    UNIT_TAX                       NUMBER       ,
    TOTAL_UNIT_AMOUNT              NUMBER       ,
    PRIOR_TOTAL_UNIT_AMOUNT        NUMBER       ,
    CHARGE_BU_ID                   NUMBER(18, 0),
    REQ_BU_ID                      NUMBER(18, 0),
    CMR_SRV_PO_LINE_LOCATION_ID    NUMBER(18, 0),
    SERVICE_PO_FLAG                VARCHAR2(4)  ,
    CONSIGNED_FLAG                 VARCHAR2(4)  ,
    DESTINATION_TYPE_CODE          VARCHAR2(100),
    TRANSACTION_TYPE               VARCHAR2(160),
    CURRENCY_CODE                  VARCHAR2(60) ,
    CURRENCY_CONVERSION_TYPE       VARCHAR2(120),
    CURRENCY_CONVERSION_RATE       NUMBER       ,
    CURRENCY_CONVERSION_DATE       TIMESTAMP(6) ,
    BILL_TO_BUSINESS_UNIT_ID       NUMBER(18, 0),
    INTERCOMPANY_BILL_TO_BU_ID     NUMBER(18, 0),
    SOURCE_DOC_NUMBER              VARCHAR2(200),
    CMR_ROOT_RCPT_TXN_ID           NUMBER(18, 0),
    SOURCE_DOC_LINE_NUMBER         VARCHAR2(160),
    SOURCE_DOC_SHIPMENT_NUMBER     VARCHAR2(160),
    SOURCE_DOC_DISTRIB_NUMBER      VARCHAR2(160),
    VENDOR_ID                      NUMBER(18, 0),
    VENDOR_SITE_ID                 NUMBER(18, 0),
    SHIP_TO_LOCATION_ID            NUMBER(18, 0),
    PO_ITEM_DESCRIPTION            VARCHAR2(960),
    PO_LINE_LOCATION_ID            NUMBER(18, 0),
    SHIP_TO_ORGANIZATION_ID        NUMBER(18, 0),
    RECEIPT_TRANSACTION_DATE       DATE         ,
    TRANSACTION_STATUS             VARCHAR2(4)  
);
