CREATE TABLE gtg_ts_paymentprocessreq (
    ETL_SEQUENCE_ID                   NUMBER(19, 0) ,
    ETL_VERSION_NUMBER                NUMBER(18, 0) ,
    DELETE_VERSION_NUMBER             NUMBER(18, 0) ,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    ALLOW_ZERO_PAYMENTS_FLAG          VARCHAR2(4)   ,
    AMT                               NUMBER        ,
    AMTDOUBLE                         NUMBER        ,
    BANK_CHARGE_BEARER                VARCHAR2(120) ,
    CALL_APP_PAY_SERVICE_REQ_CODE     VARCHAR2(1020),
    CREATE_PMT_INSTRUCTIONS_FLAG      VARCHAR2(4)   ,
    DOCUMENT_REJECTION_LEVEL_CODE     VARCHAR2(120) ,
    EXTERNAL_BANK_ACCOUNT_ID          NUMBER(18, 0) ,
    IBYPAYMENTSALL_CB                 VARCHAR2(256) ,
    IBYPAYMENTSALL_CD                 TIMESTAMP(6)  ,
    IBYPAYMENTSALL_LUB                VARCHAR2(256) ,
    IBYPAYMENTSALL_LUD                TIMESTAMP(6)  ,
    IBYPAYSERVICEREQUESTS_CB          VARCHAR2(256) ,
    IBYPAYSERVICEREQUESTS_CD          TIMESTAMP(6)  ,
    IBYPAYSERVICEREQUESTS_LUB         VARCHAR2(256) ,
    IBYPAYSERVICEREQUESTS_LUD         TIMESTAMP(6)  ,
    INT_BANK_ACCOUNT_NAME             VARCHAR2(1440),
    ORG_NAME                          VARCHAR2(960) ,
    PAPER_DOCUMENT_NUMBER             NUMBER(18, 0) ,
    PAYEE_NAME                        VARCHAR2(1440),
    PAYMENT_CURRENCY_CODE             VARCHAR2(40)  ,
    PAYMENT_DATE                      DATE          ,
    PAYMENT_DOCUMENT_ID               NUMBER(18, 0) ,
    PAYMENT_ID                        NUMBER(18, 0) ,
    PAYMENT_INSTRUCTION_ID            NUMBER(18, 0) ,
    PAYMENT_PROCESS_REQUEST_NAME      VARCHAR2(1020),
    PAYMENT_PROFILE_ACCT_NAME         VARCHAR2(400) ,
    PAYMENT_PROFILE_ID                NUMBER(18, 0) ,
    PAYMENT_REFERENCE_NUMBER          NUMBER(18, 0) ,
    PAYMENT_REJECTION_LEVEL_CODE      VARCHAR2(120) ,
    PAYMENT_SERVICE_REQUEST_ID        NUMBER(18, 0) ,
    PAYMENT_SERVICE_REQUEST_STATUS    VARCHAR2(120) ,
    PAYMENT_STATUS                    VARCHAR2(120) ,
    REVINS                            VARCHAR2(4)   ,
    REVPRPPAY                         VARCHAR2(4)   ,
    SETTLEMENT_PRIORITY               VARCHAR2(120) ,
    ETL_SEQUENCE_ID                   NUMBER(19, 0) ,
    ETL_VERSION_NUMBER                NUMBER(18, 0) ,
    DELETE_VERSION_NUMBER             NUMBER(18, 0) ,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    ALLOW_ZERO_PAYMENTS_FLAG          VARCHAR2(4)   ,
    AMT                               NUMBER        ,
    AMTDOUBLE                         NUMBER        ,
    BANK_CHARGE_BEARER                VARCHAR2(120) ,
    CALL_APP_PAY_SERVICE_REQ_CODE     VARCHAR2(1020),
    CREATE_PMT_INSTRUCTIONS_FLAG      VARCHAR2(4)   ,
    DOCUMENT_REJECTION_LEVEL_CODE     VARCHAR2(120) ,
    EXTERNAL_BANK_ACCOUNT_ID          NUMBER(18, 0) ,
    IBYPAYMENTSALL_CB                 VARCHAR2(256) ,
    IBYPAYMENTSALL_CD                 TIMESTAMP(6)  ,
    IBYPAYMENTSALL_LUB                VARCHAR2(256) ,
    IBYPAYMENTSALL_LUD                TIMESTAMP(6)  ,
    IBYPAYSERVICEREQUESTS_CB          VARCHAR2(256) ,
    IBYPAYSERVICEREQUESTS_CD          TIMESTAMP(6)  ,
    IBYPAYSERVICEREQUESTS_LUB         VARCHAR2(256) ,
    IBYPAYSERVICEREQUESTS_LUD         TIMESTAMP(6)  ,
    INT_BANK_ACCOUNT_NAME             VARCHAR2(1440),
    ORG_NAME                          VARCHAR2(960) ,
    PAPER_DOCUMENT_NUMBER             NUMBER(18, 0) ,
    PAYEE_NAME                        VARCHAR2(1440),
    PAYMENT_CURRENCY_CODE             VARCHAR2(40)  ,
    PAYMENT_DATE                      DATE          ,
    PAYMENT_DOCUMENT_ID               NUMBER(18, 0) ,
    PAYMENT_ID                        NUMBER(18, 0) ,
    PAYMENT_INSTRUCTION_ID            NUMBER(18, 0) ,
    PAYMENT_PROCESS_REQUEST_NAME      VARCHAR2(1020),
    PAYMENT_PROFILE_ACCT_NAME         VARCHAR2(400) ,
    PAYMENT_PROFILE_ID                NUMBER(18, 0) ,
    PAYMENT_REFERENCE_NUMBER          NUMBER(18, 0) ,
    PAYMENT_REJECTION_LEVEL_CODE      VARCHAR2(120) ,
    PAYMENT_SERVICE_REQUEST_ID        NUMBER(18, 0) ,
    PAYMENT_SERVICE_REQUEST_STATUS    VARCHAR2(120) ,
    PAYMENT_STATUS                    VARCHAR2(120) ,
    REVINS                            VARCHAR2(4)   ,
    REVPRPPAY                         VARCHAR2(4)   ,
    SETTLEMENT_PRIORITY               VARCHAR2(120) ,
    CONSTRAINT pk_gtg_ts_paymentprocessreq PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
