CREATE TABLE iby_xcc_extract (
    DATA_SET_ID                      NUMBER(18, 0) ,
    SOURCE_HEADER_ID_1               VARCHAR2(120)     NOT NULL,
    SOURCE_HEADER_ID_2               VARCHAR2(120) ,
    CREATION_DATE                    TIMESTAMP(6)      NOT NULL,
    CREATED_BY                       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    LAST_UPDATED_BY                  VARCHAR2(256)     NOT NULL,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    TRANSACTION_NUMBER               VARCHAR2(960) ,
    SOURCE_LINE_ID_1                 VARCHAR2(120)     NOT NULL,
    SOURCE_LINE_ID_2                 VARCHAR2(120) ,
    SOURCE_LINE_ID_3                 VARCHAR2(120) ,
    SOURCE_LINE_ID_4                 VARCHAR2(120) ,
    SOURCE_LINE_ID_5                 VARCHAR2(120) ,
    SOURCE_LINE_ID_6                 VARCHAR2(120) ,
    LINE_NUM                         NUMBER(18, 0) ,
    LEDGER_ID                        NUMBER(18, 0) ,
    BUSINESS_UNIT_ID                 NUMBER(18, 0) ,
    TRANSACTION_SUBTYPE_CODE         VARCHAR2(120) ,
    BUDGET_DATE                      DATE          ,
    ACCOUNTING_DATE                  DATE          ,
    ENTERED_CURRENCY                 VARCHAR2(60)  ,
    ENTERED_AMOUNT                   NUMBER        ,
    BUDGET_CODE_CONCAT_SEGS          VARCHAR2(3200),
    CASH_CODE_COMBINATION_ID         NUMBER(18, 0) ,
    EXPENSE_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    PAYMENT_SERVICE_REQUEST_ID       NUMBER(18, 0)     NOT NULL,
    CALL_APP_PAY_SERVICE_REQ_CODE    VARCHAR2(1020),
    DATA_SET_ID                      NUMBER(18, 0) ,
    SOURCE_HEADER_ID_1               VARCHAR2(120)     NOT NULL,
    SOURCE_HEADER_ID_2               VARCHAR2(120) ,
    CREATION_DATE                    TIMESTAMP(6)      NOT NULL,
    CREATED_BY                       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    LAST_UPDATED_BY                  VARCHAR2(256)     NOT NULL,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    TRANSACTION_NUMBER               VARCHAR2(960) ,
    SOURCE_LINE_ID_1                 VARCHAR2(120)     NOT NULL,
    SOURCE_LINE_ID_2                 VARCHAR2(120) ,
    SOURCE_LINE_ID_3                 VARCHAR2(120) ,
    SOURCE_LINE_ID_4                 VARCHAR2(120) ,
    SOURCE_LINE_ID_5                 VARCHAR2(120) ,
    SOURCE_LINE_ID_6                 VARCHAR2(120) ,
    LINE_NUM                         NUMBER(18, 0) ,
    LEDGER_ID                        NUMBER(18, 0) ,
    BUSINESS_UNIT_ID                 NUMBER(18, 0) ,
    TRANSACTION_SUBTYPE_CODE         VARCHAR2(120) ,
    BUDGET_DATE                      DATE          ,
    ACCOUNTING_DATE                  DATE          ,
    ENTERED_CURRENCY                 VARCHAR2(60)  ,
    ENTERED_AMOUNT                   NUMBER        ,
    BUDGET_CODE_CONCAT_SEGS          VARCHAR2(3200),
    CASH_CODE_COMBINATION_ID         NUMBER(18, 0) ,
    EXPENSE_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    PAYMENT_SERVICE_REQUEST_ID       NUMBER(18, 0)     NOT NULL,
    CALL_APP_PAY_SERVICE_REQ_CODE    VARCHAR2(1020)
);
