CREATE TABLE cst_rcl_rev_rec_txns (
    REV_REC_TXN_ID                NUMBER(18, 0) ,
    EXTERNAL_SYSTEM_REFERENCE     VARCHAR2(240)     NOT NULL,
    SR_NUMBER                     VARCHAR2(120) ,
    DEBRIEF_NUMBER                VARCHAR2(120) ,
    DEBRIEF_HEADER_ID             NUMBER(18, 0) ,
    DEBRIEF_LINE_ID               NUMBER(18, 0)     NOT NULL,
    SUBSCRIPTION_ID               NUMBER(18, 0) ,
    SUBSCRIPTION_NUMBER           VARCHAR2(480) ,
    LINE_TYPE                     VARCHAR2(120) ,
    BUSINESS_UNIT_ID              NUMBER(18, 0) ,
    INVENTORY_ORG_ID              NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID             NUMBER(18, 0)     NOT NULL,
    QUANTITY                      NUMBER        ,
    UOM_CODE                      VARCHAR2(12)  ,
    SUBINVENTORY_CODE             VARCHAR2(40)  ,
    CHARGE_POSTING_DATE           TIMESTAMP(6)      NOT NULL,
    RECOGNITION_PERCENTAGE        NUMBER            NOT NULL,
    BILL_TO_PARTY_ID              NUMBER(18, 0) ,
    PARTY_ID                      NUMBER(18, 0) ,
    CUST_ACCOUNT_ID               NUMBER(18, 0) ,
    BILL_TO_PARTY_SITE_ID         NUMBER(18, 0) ,
    SHIP_TO_PARTY_SITE_ID         NUMBER(18, 0) ,
    TECHNICIAN_PARTY_ID           NUMBER(18, 0) ,
    WORK_ORDER_NUMBER             VARCHAR2(480) ,
    WIE_WO_ID                     NUMBER(18, 0) ,
    WO_RESOURCE_TRANSACTION_ID    NUMBER(18, 0) ,
    INV_TRANSACTION_ID            NUMBER(18, 0) ,
    DOO_ORDER_NUMBER              VARCHAR2(200) ,
    DOO_LINE_ID                   NUMBER(18, 0) ,
    SUBSCRIPTION_TYPE             VARCHAR2(960) ,
    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),
    REV_REC_TXN_ID                NUMBER(18, 0) ,
    EXTERNAL_SYSTEM_REFERENCE     VARCHAR2(240)     NOT NULL,
    SR_NUMBER                     VARCHAR2(120) ,
    DEBRIEF_NUMBER                VARCHAR2(120) ,
    DEBRIEF_HEADER_ID             NUMBER(18, 0) ,
    DEBRIEF_LINE_ID               NUMBER(18, 0)     NOT NULL,
    SUBSCRIPTION_ID               NUMBER(18, 0) ,
    LINE_TYPE                     VARCHAR2(120) ,
    BUSINESS_UNIT_ID              NUMBER(18, 0) ,
    INVENTORY_ORG_ID              NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID             NUMBER(18, 0)     NOT NULL,
    QUANTITY                      NUMBER        ,
    UOM_CODE                      VARCHAR2(12)  ,
    SUBINVENTORY_CODE             VARCHAR2(40)  ,
    CHARGE_POSTING_DATE           TIMESTAMP(6)      NOT NULL,
    RECOGNITION_PERCENTAGE        NUMBER            NOT NULL,
    PARTY_ID                      NUMBER(18, 0) ,
    CUST_ACCOUNT_ID               NUMBER(18, 0) ,
    BILL_TO_PARTY_SITE_ID         NUMBER(18, 0) ,
    SHIP_TO_PARTY_SITE_ID         NUMBER(18, 0) ,
    TECHNICIAN_PARTY_ID           NUMBER(18, 0) ,
    WORK_ORDER_NUMBER             VARCHAR2(480) ,
    WIE_WO_ID                     NUMBER(18, 0) ,
    WO_RESOURCE_TRANSACTION_ID    NUMBER(18, 0) ,
    INV_TRANSACTION_ID            NUMBER(18, 0) ,
    DOO_ORDER_NUMBER              VARCHAR2(200) ,
    DOO_LINE_ID                   NUMBER(18, 0) ,
    SUBSCRIPTION_TYPE             VARCHAR2(960) ,
    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),
    SUBSCRIPTION_NUMBER           VARCHAR2(480) ,
    BILL_TO_PARTY_ID              NUMBER(18, 0) ,
    CONSTRAINT pk_cst_rcl_rev_rec_txns PRIMARY KEY (REV_REC_TXN_ID, REV_REC_TXN_ID)
);
