CREATE TABLE iby_sys_pmt_profiles_b] (
    SYSTEM_PROFILE_CODE               VARCHAR2(400)     NOT NULL,
    LOGICAL_GROUPING_MODE             VARCHAR2(120) ,
    BEPID                             NUMBER(18, 0) ,
    SECURITY_PROTOCOL_CODE            VARCHAR2(400) ,
    TRANSMIT_PROTOCOL_CODE            VARCHAR2(400) ,
    PAYMENT_FORMAT_CODE               VARCHAR2(120)     NOT NULL,
    POSITIVE_PAY_FORMAT_CODE          VARCHAR2(120) ,
    PAY_FILE_LETTER_FORMAT_CODE       VARCHAR2(120) ,
    PRINT_INSTRUCTION_IMMED_FLAG      VARCHAR2(4)       NOT NULL,
    DEFAULT_PRINTER                   VARCHAR2(1020),
    DEFAULT_PAYMENT_DOCUMENT_ID       NUMBER(18, 0) ,
    PERIODIC_SEQUENCE_NAME_1          VARCHAR2(320) ,
    PERIODIC_SEQUENCE_NAME_2          VARCHAR2(320) ,
    PERIODIC_SEQUENCE_NAME_3          VARCHAR2(320) ,
    PROCESSING_TYPE                   VARCHAR2(120)     NOT NULL,
    MARK_COMPLETE_EVENT               VARCHAR2(120)     NOT NULL,
    MANUAL_MARK_COMPLETE_FLAG         VARCHAR2(4)       NOT NULL,
    POSITIVE_PAY_DELIVERY_FLAG        VARCHAR2(4)       NOT NULL,
    TRANSMIT_INSTR_IMMED_FLAG         VARCHAR2(4)       NOT NULL,
    SEEDED_FLAG                       VARCHAR2(4)   ,
    AUTOMATIC_PI_REG_SUBMIT           VARCHAR2(4)       NOT NULL,
    AUTOMATIC_PPR_REPORT_SUBMIT       VARCHAR2(4)   ,
    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) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)      NOT NULL,
    DECLARATION_OPTION                VARCHAR2(120) ,
    DCL_ONLY_FOREIGN_CURR_PMT_FLAG    VARCHAR2(4)   ,
    DECLARATION_REPORT_FORMAT_CODE    VARCHAR2(120) ,
    DECLARATION_CURR_FX_RATE_TYPE     VARCHAR2(1020),
    DECLARATION_CURRENCY_CODE         VARCHAR2(40)  ,
    DECLARATION_THRESHOLD_AMOUNT      NUMBER        ,
    BANK_INSTRUCTION1_CODE            VARCHAR2(120) ,
    BANK_INSTRUCTION2_CODE            VARCHAR2(120) ,
    BANK_INSTRUCTION_DETAILS          VARCHAR2(1020),
    PAYMENT_TEXT_MESSAGE1             VARCHAR2(600) ,
    PAYMENT_TEXT_MESSAGE2             VARCHAR2(600) ,
    INACTIVE_DATE                     DATE          ,
    ACK_TRANSMIT_PROTOCOL_CODE        VARCHAR2(400) ,
    ACK_SECURITY_PROTOCOL_CODE        VARCHAR2(400) ,
    SEND_TO_FILE_FLAG                 VARCHAR2(4)       NOT NULL,
    PPR_REPORT_FORMAT                 VARCHAR2(120) ,
    PI_REGISTER_FORMAT                VARCHAR2(120) ,
    ATTRIBUTE_CATEGORY                VARCHAR2(600) ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    OUTBOUND_PMT_FILE_DIRECTORY       VARCHAR2(1020),
    OUTBOUND_PMT_FILE_EXTENSION       VARCHAR2(1020),
    OUTBOUND_PMT_FILE_PREFIX          VARCHAR2(1020),
    POSITIVE_PAY_FILE_DIRECTORY       VARCHAR2(1020),
    POSITIVE_PAY_FILE_EXTENSION       VARCHAR2(1020),
    POSITIVE_PAY_FILE_PREFIX          VARCHAR2(1020),
    ELECTRONIC_PROCESSING_CHANNEL     VARCHAR2(200) ,
    START_DATE                        DATE              NOT NULL,
    END_DATE                          DATE              NOT NULL,
    BATCH_BOOKING_FLAG                VARCHAR2(4)   ,
    SERVICE_LEVEL_CODE                VARCHAR2(120) ,
    DELIVERY_CHANNEL_CODE             VARCHAR2(120) ,
    SEED_DATA_SOURCE                  VARCHAR2(2048),
    ORA_SEED_SET1                     VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                     VARCHAR2(4)       NOT NULL,
    AUTO_RECORD_PRINTED_PMTS_FLAG     VARCHAR2(4)   
);
