VIEW: IBY.IBY_UPG_PPP_B#

Source

View Text - Preformatted

select SYSTEM_PROFILE_CODE SYSTEM_PROFILE_CODE, BEP_SUFFIX BEP_SUFFIX, 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, 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, AUTOMATIC_PI_REG_SUBMIT AUTOMATIC_PI_REG_SUBMIT, 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, 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, BEP_ACCOUNT_ID BEP_ACCOUNT_ID, APPLICABLE_PMT_METHOD APPLICABLE_PMT_METHOD, APPLICABLE_CURRENCY APPLICABLE_CURRENCY, APPLICABLE_PAYER_ORG APPLICABLE_PAYER_ORG, APPLICABLE_INT_BANK_ACCOUNT APPLICABLE_INT_BANK_ACCOUNT, PMT_GROUP_BY_PAYMENT_DETAILS PMT_GROUP_BY_PAYMENT_DETAILS, PMT_GROUP_BY_BANK_CHARGE_BEAR PMT_GROUP_BY_BANK_CHARGE_BEAR, PMT_GROUP_BY_DELIVERY_CHANNEL PMT_GROUP_BY_DELIVERY_CHANNEL, PMT_GROUP_BY_REMITTANCE_MES PMT_GROUP_BY_REMITTANCE_MES, PMT_GROUP_BY_MAX_DOCUMENTS PMT_GROUP_BY_MAX_DOCUMENTS, PMT_GROUP_BY_UNIQUE_REMIT_ID PMT_GROUP_BY_UNIQUE_REMIT_ID, PMT_GROUP_BY_SETTLE_PRIORITY PMT_GROUP_BY_SETTLE_PRIORITY, PMT_GROUP_BY_PAYMENT_REASON PMT_GROUP_BY_PAYMENT_REASON, PMT_GROUP_BY_DUE_DATE_FLAG PMT_GROUP_BY_DUE_DATE_FLAG, PMT_MAX_DOCUMENTS_PER_PAYMENT PMT_MAX_DOCUMENTS_PER_PAYMENT, PMT_PAYMENT_DETAILS_LENGTH_LIM PMT_PAYMENT_DETAILS_LENGTH_LIM, PMT_PAYMENT_DETAILS_FORMULA PMT_PAYMENT_DETAILS_FORMULA, INST_GROUP_BY_PAYMENT_DATE INST_GROUP_BY_PAYMENT_DATE, INST_GROUP_BY_PAYMENT_CURRENCY INST_GROUP_BY_PAYMENT_CURRENCY, INST_GROUP_BY_INT_BANK_ACCT INST_GROUP_BY_INT_BANK_ACCT, INST_GROUP_BY_MAX_PAYMENTS INST_GROUP_BY_MAX_PAYMENTS, INST_GROUP_BY_PAY_SERVICE_REQ INST_GROUP_BY_PAY_SERVICE_REQ, INST_GROUP_BY_LEGAL_ENTITY INST_GROUP_BY_LEGAL_ENTITY, INST_GROUP_BY_BILL_PAYABLE INST_GROUP_BY_BILL_PAYABLE, INST_GROUP_BY_MAX_INSTRUCTION INST_GROUP_BY_MAX_INSTRUCTION, INST_GROUP_BY_ORGANIZATION INST_GROUP_BY_ORGANIZATION, INST_GROUP_BY_PAYMENT_FUNCTION INST_GROUP_BY_PAYMENT_FUNCTION, INST_GROUP_BY_PAYMENT_REASON INST_GROUP_BY_PAYMENT_REASON, INST_GROUP_BY_RFC INST_GROUP_BY_RFC, INST_MAX_PAYMENTS_PER_INSTR INST_MAX_PAYMENTS_PER_INSTR, INST_MAX_AMOUNT_PER_INSTR_VAL INST_MAX_AMOUNT_PER_INSTR_VAL, INST_MAX_AMOUNT_PER_INSTR_CURR INST_MAX_AMOUNT_PER_INSTR_CURR, INST_MAX_AMOUNT_FX_RATE_TYPE INST_MAX_AMOUNT_FX_RATE_TYPE, INST_SORT_OPTION_1 INST_SORT_OPTION_1, INST_SORT_ORDER_1 INST_SORT_ORDER_1, INST_SORT_OPTION_2 INST_SORT_OPTION_2, INST_SORT_ORDER_2 INST_SORT_ORDER_2, INST_SORT_OPTION_3 INST_SORT_OPTION_3, INST_SORT_ORDER_3 INST_SORT_ORDER_3, REMIT_DOCUMENT_COUNT_LIMIT REMIT_DOCUMENT_COUNT_LIMIT, REMIT_ALLOW_MULTIPLE_COPY_FLAG REMIT_ALLOW_MULTIPLE_COPY_FLAG, REMIT_PMT_DETAILS_LENGTH_LIM REMIT_PMT_DETAILS_LENGTH_LIM, REMIT_REMITTANCE_ADVICE_FORMAT REMIT_REMITTANCE_ADVICE_FORMAT, REMIT_SRA_OVERRIDE_PAYEE_FLAG REMIT_SRA_OVERRIDE_PAYEE_FLAG, REMIT_ADVICE_DELIVERY_METHOD REMIT_ADVICE_DELIVERY_METHOD, REMIT_AUTOMATIC_SRA_SUBMIT REMIT_AUTOMATIC_SRA_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, ELECTRONIC_PROCESSING_CHANNEL ELECTRONIC_PROCESSING_CHANNEL, LOGICAL_GROUPING_MODE LOGICAL_GROUPING_MODE, BATCH_BOOKING_FLAG BATCH_BOOKING_FLAG, INST_GROUP_BY_PAYMENT_METHOD INST_GROUP_BY_PAYMENT_METHOD, INACTIVE_DATE INACTIVE_DATE from "IBY"."IBY_UPG_PPP_B"

View Text - HTML Formatted

SELECT SYSTEM_PROFILE_CODE SYSTEM_PROFILE_CODE
, BEP_SUFFIX BEP_SUFFIX
, 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
, 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
, AUTOMATIC_PI_REG_SUBMIT AUTOMATIC_PI_REG_SUBMIT
, 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
, 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
, BEP_ACCOUNT_ID BEP_ACCOUNT_ID
, APPLICABLE_PMT_METHOD APPLICABLE_PMT_METHOD
, APPLICABLE_CURRENCY APPLICABLE_CURRENCY
, APPLICABLE_PAYER_ORG APPLICABLE_PAYER_ORG
, APPLICABLE_INT_BANK_ACCOUNT APPLICABLE_INT_BANK_ACCOUNT
, PMT_GROUP_BY_PAYMENT_DETAILS PMT_GROUP_BY_PAYMENT_DETAILS
, PMT_GROUP_BY_BANK_CHARGE_BEAR PMT_GROUP_BY_BANK_CHARGE_BEAR
, PMT_GROUP_BY_DELIVERY_CHANNEL PMT_GROUP_BY_DELIVERY_CHANNEL
, PMT_GROUP_BY_REMITTANCE_MES PMT_GROUP_BY_REMITTANCE_MES
, PMT_GROUP_BY_MAX_DOCUMENTS PMT_GROUP_BY_MAX_DOCUMENTS
, PMT_GROUP_BY_UNIQUE_REMIT_ID PMT_GROUP_BY_UNIQUE_REMIT_ID
, PMT_GROUP_BY_SETTLE_PRIORITY PMT_GROUP_BY_SETTLE_PRIORITY
, PMT_GROUP_BY_PAYMENT_REASON PMT_GROUP_BY_PAYMENT_REASON
, PMT_GROUP_BY_DUE_DATE_FLAG PMT_GROUP_BY_DUE_DATE_FLAG
, PMT_MAX_DOCUMENTS_PER_PAYMENT PMT_MAX_DOCUMENTS_PER_PAYMENT
, PMT_PAYMENT_DETAILS_LENGTH_LIM PMT_PAYMENT_DETAILS_LENGTH_LIM
, PMT_PAYMENT_DETAILS_FORMULA PMT_PAYMENT_DETAILS_FORMULA
, INST_GROUP_BY_PAYMENT_DATE INST_GROUP_BY_PAYMENT_DATE
, INST_GROUP_BY_PAYMENT_CURRENCY INST_GROUP_BY_PAYMENT_CURRENCY
, INST_GROUP_BY_INT_BANK_ACCT INST_GROUP_BY_INT_BANK_ACCT
, INST_GROUP_BY_MAX_PAYMENTS INST_GROUP_BY_MAX_PAYMENTS
, INST_GROUP_BY_PAY_SERVICE_REQ INST_GROUP_BY_PAY_SERVICE_REQ
, INST_GROUP_BY_LEGAL_ENTITY INST_GROUP_BY_LEGAL_ENTITY
, INST_GROUP_BY_BILL_PAYABLE INST_GROUP_BY_BILL_PAYABLE
, INST_GROUP_BY_MAX_INSTRUCTION INST_GROUP_BY_MAX_INSTRUCTION
, INST_GROUP_BY_ORGANIZATION INST_GROUP_BY_ORGANIZATION
, INST_GROUP_BY_PAYMENT_FUNCTION INST_GROUP_BY_PAYMENT_FUNCTION
, INST_GROUP_BY_PAYMENT_REASON INST_GROUP_BY_PAYMENT_REASON
, INST_GROUP_BY_RFC INST_GROUP_BY_RFC
, INST_MAX_PAYMENTS_PER_INSTR INST_MAX_PAYMENTS_PER_INSTR
, INST_MAX_AMOUNT_PER_INSTR_VAL INST_MAX_AMOUNT_PER_INSTR_VAL
, INST_MAX_AMOUNT_PER_INSTR_CURR INST_MAX_AMOUNT_PER_INSTR_CURR
, INST_MAX_AMOUNT_FX_RATE_TYPE INST_MAX_AMOUNT_FX_RATE_TYPE
, INST_SORT_OPTION_1 INST_SORT_OPTION_1
, INST_SORT_ORDER_1 INST_SORT_ORDER_1
, INST_SORT_OPTION_2 INST_SORT_OPTION_2
, INST_SORT_ORDER_2 INST_SORT_ORDER_2
, INST_SORT_OPTION_3 INST_SORT_OPTION_3
, INST_SORT_ORDER_3 INST_SORT_ORDER_3
, REMIT_DOCUMENT_COUNT_LIMIT REMIT_DOCUMENT_COUNT_LIMIT
, REMIT_ALLOW_MULTIPLE_COPY_FLAG REMIT_ALLOW_MULTIPLE_COPY_FLAG
, REMIT_PMT_DETAILS_LENGTH_LIM REMIT_PMT_DETAILS_LENGTH_LIM
, REMIT_REMITTANCE_ADVICE_FORMAT REMIT_REMITTANCE_ADVICE_FORMAT
, REMIT_SRA_OVERRIDE_PAYEE_FLAG REMIT_SRA_OVERRIDE_PAYEE_FLAG
, REMIT_ADVICE_DELIVERY_METHOD REMIT_ADVICE_DELIVERY_METHOD
, REMIT_AUTOMATIC_SRA_SUBMIT REMIT_AUTOMATIC_SRA_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
, ELECTRONIC_PROCESSING_CHANNEL ELECTRONIC_PROCESSING_CHANNEL
, LOGICAL_GROUPING_MODE LOGICAL_GROUPING_MODE
, BATCH_BOOKING_FLAG BATCH_BOOKING_FLAG
, INST_GROUP_BY_PAYMENT_METHOD INST_GROUP_BY_PAYMENT_METHOD
, INACTIVE_DATE INACTIVE_DATE
FROM "IBY"."IBY_UPG_PPP_B"