VIEW: IBY.IBY_SYS_PMT_PROFILES_B#

Source

View Text - Preformatted

select SYSTEM_PROFILE_CODE SYSTEM_PROFILE_CODE, BEPID BEPID, SECURITY_PROTOCOL_CODE SECURITY_PROTOCOL_CODE, TRANSMIT_PROTOCOL_CODE TRANSMIT_PROTOCOL_CODE, PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE, POSITIVE_PAY_FORMAT_CODE POSITIVE_PAY_FORMAT_CODE, PAY_FILE_LETTER_FORMAT_CODE PAY_FILE_LETTER_FORMAT_CODE, PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG, DEFAULT_PRINTER DEFAULT_PRINTER, DEFAULT_PAYMENT_DOCUMENT_ID DEFAULT_PAYMENT_DOCUMENT_ID, PERIODIC_SEQUENCE_NAME_1 PERIODIC_SEQUENCE_NAME_1, PERIODIC_SEQUENCE_NAME_2 PERIODIC_SEQUENCE_NAME_2, PERIODIC_SEQUENCE_NAME_3 PERIODIC_SEQUENCE_NAME_3, PROCESSING_TYPE PROCESSING_TYPE, MARK_COMPLETE_EVENT MARK_COMPLETE_EVENT, MANUAL_MARK_COMPLETE_FLAG MANUAL_MARK_COMPLETE_FLAG, POSITIVE_PAY_DELIVERY_FLAG POSITIVE_PAY_DELIVERY_FLAG, TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG, SEEDED_FLAG SEEDED_FLAG, AUTOMATIC_PI_REG_SUBMIT AUTOMATIC_PI_REG_SUBMIT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DECLARATION_OPTION DECLARATION_OPTION, DCL_ONLY_FOREIGN_CURR_PMT_FLAG DCL_ONLY_FOREIGN_CURR_PMT_FLAG, DECLARATION_REPORT_FORMAT_CODE DECLARATION_REPORT_FORMAT_CODE, DECLARATION_CURR_FX_RATE_TYPE DECLARATION_CURR_FX_RATE_TYPE, DECLARATION_CURRENCY_CODE DECLARATION_CURRENCY_CODE, DECLARATION_THRESHOLD_AMOUNT DECLARATION_THRESHOLD_AMOUNT, BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE, BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE, BANK_INSTRUCTION_DETAILS BANK_INSTRUCTION_DETAILS, PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1, PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2, INACTIVE_DATE INACTIVE_DATE, ACK_TRANSMIT_PROTOCOL_CODE ACK_TRANSMIT_PROTOCOL_CODE, ACK_SECURITY_PROTOCOL_CODE ACK_SECURITY_PROTOCOL_CODE, SEND_TO_FILE_FLAG SEND_TO_FILE_FLAG, PI_REGISTER_FORMAT PI_REGISTER_FORMAT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, OUTBOUND_PMT_FILE_DIRECTORY OUTBOUND_PMT_FILE_DIRECTORY, OUTBOUND_PMT_FILE_EXTENSION OUTBOUND_PMT_FILE_EXTENSION, OUTBOUND_PMT_FILE_PREFIX OUTBOUND_PMT_FILE_PREFIX, POSITIVE_PAY_FILE_DIRECTORY POSITIVE_PAY_FILE_DIRECTORY, POSITIVE_PAY_FILE_EXTENSION POSITIVE_PAY_FILE_EXTENSION, POSITIVE_PAY_FILE_PREFIX POSITIVE_PAY_FILE_PREFIX, ELECTRONIC_PROCESSING_CHANNEL ELECTRONIC_PROCESSING_CHANNEL, LOGICAL_GROUPING_MODE LOGICAL_GROUPING_MODE, BATCH_BOOKING_FLAG BATCH_BOOKING_FLAG, DISALLOW_SAVE_PRINT_FLAG DISALLOW_SAVE_PRINT_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "IBY"."IBY_SYS_PMT_PROFILES_B"

View Text - HTML Formatted

SELECT SYSTEM_PROFILE_CODE SYSTEM_PROFILE_CODE
, BEPID BEPID
, SECURITY_PROTOCOL_CODE SECURITY_PROTOCOL_CODE
, TRANSMIT_PROTOCOL_CODE TRANSMIT_PROTOCOL_CODE
, PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE
, POSITIVE_PAY_FORMAT_CODE POSITIVE_PAY_FORMAT_CODE
, PAY_FILE_LETTER_FORMAT_CODE PAY_FILE_LETTER_FORMAT_CODE
, PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG
, DEFAULT_PRINTER DEFAULT_PRINTER
, DEFAULT_PAYMENT_DOCUMENT_ID DEFAULT_PAYMENT_DOCUMENT_ID
, PERIODIC_SEQUENCE_NAME_1 PERIODIC_SEQUENCE_NAME_1
, PERIODIC_SEQUENCE_NAME_2 PERIODIC_SEQUENCE_NAME_2
, PERIODIC_SEQUENCE_NAME_3 PERIODIC_SEQUENCE_NAME_3
, PROCESSING_TYPE PROCESSING_TYPE
, MARK_COMPLETE_EVENT MARK_COMPLETE_EVENT
, MANUAL_MARK_COMPLETE_FLAG MANUAL_MARK_COMPLETE_FLAG
, POSITIVE_PAY_DELIVERY_FLAG POSITIVE_PAY_DELIVERY_FLAG
, TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG
, SEEDED_FLAG SEEDED_FLAG
, AUTOMATIC_PI_REG_SUBMIT AUTOMATIC_PI_REG_SUBMIT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DECLARATION_OPTION DECLARATION_OPTION
, DCL_ONLY_FOREIGN_CURR_PMT_FLAG DCL_ONLY_FOREIGN_CURR_PMT_FLAG
, DECLARATION_REPORT_FORMAT_CODE DECLARATION_REPORT_FORMAT_CODE
, DECLARATION_CURR_FX_RATE_TYPE DECLARATION_CURR_FX_RATE_TYPE
, DECLARATION_CURRENCY_CODE DECLARATION_CURRENCY_CODE
, DECLARATION_THRESHOLD_AMOUNT DECLARATION_THRESHOLD_AMOUNT
, BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE
, BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE
, BANK_INSTRUCTION_DETAILS BANK_INSTRUCTION_DETAILS
, PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1
, PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2
, INACTIVE_DATE INACTIVE_DATE
, ACK_TRANSMIT_PROTOCOL_CODE ACK_TRANSMIT_PROTOCOL_CODE
, ACK_SECURITY_PROTOCOL_CODE ACK_SECURITY_PROTOCOL_CODE
, SEND_TO_FILE_FLAG SEND_TO_FILE_FLAG
, PI_REGISTER_FORMAT PI_REGISTER_FORMAT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, OUTBOUND_PMT_FILE_DIRECTORY OUTBOUND_PMT_FILE_DIRECTORY
, OUTBOUND_PMT_FILE_EXTENSION OUTBOUND_PMT_FILE_EXTENSION
, OUTBOUND_PMT_FILE_PREFIX OUTBOUND_PMT_FILE_PREFIX
, POSITIVE_PAY_FILE_DIRECTORY POSITIVE_PAY_FILE_DIRECTORY
, POSITIVE_PAY_FILE_EXTENSION POSITIVE_PAY_FILE_EXTENSION
, POSITIVE_PAY_FILE_PREFIX POSITIVE_PAY_FILE_PREFIX
, ELECTRONIC_PROCESSING_CHANNEL ELECTRONIC_PROCESSING_CHANNEL
, LOGICAL_GROUPING_MODE LOGICAL_GROUPING_MODE
, BATCH_BOOKING_FLAG BATCH_BOOKING_FLAG
, DISALLOW_SAVE_PRINT_FLAG DISALLOW_SAVE_PRINT_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "IBY"."IBY_SYS_PMT_PROFILES_B"