VIEW: IBY.IBY_PAY_INSTRUCTIONS_H#

Source

View Text - Preformatted

select PAYMENT_INSTRUCTION_HISTORY_ID PAYMENT_INSTRUCTION_HISTORY_ID, PMT_INSTRUCTION_HISTORY_DATE PMT_INSTRUCTION_HISTORY_DATE, PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID, PAYMENT_INSTRUCTION_NAME PAYMENT_INSTRUCTION_NAME, PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE, BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BEPID BEPID, PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG, TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TRANSMIT_CONFIGURATION_ID TRANSMIT_CONFIGURATION_ID, SECURITY_CONFIGURATION_ID SECURITY_CONFIGURATION_ID, POSITIVE_PAY_FORMAT_CODE POSITIVE_PAY_FORMAT_CODE, PROCESS_TYPE PROCESS_TYPE, PAYMENT_INSTRUCTION_STATUS PAYMENT_INSTRUCTION_STATUS, PAYMENTS_COMPLETE_FLAG PAYMENTS_COMPLETE_FLAG, INT_BANK_ACCOUNT_ROUTING_NUM INT_BANK_ACCOUNT_ROUTING_NUM, INT_BANK_ACCOUNT_NUMBER INT_BANK_ACCOUNT_NUMBER, INT_BANK_ACCOUNT_IBAN_NUMBER INT_BANK_ACCOUNT_IBAN_NUMBER, SEQUENCE_NUMBER SEQUENCE_NUMBER, PAY_ADMIN_ASSIGNED_REF_CODE PAY_ADMIN_ASSIGNED_REF_CODE, PAYMENT_COUNT PAYMENT_COUNT, TRANSMISSION_DATE TRANSMISSION_DATE, ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE, COMMENTS COMMENTS, REMITTANCE_ADVICE_CREATED_FLAG REMITTANCE_ADVICE_CREATED_FLAG, BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PAYMENT_FUNCTION PAYMENT_FUNCTION, PRINTER_NAME PRINTER_NAME, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, 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 from "IBY"."IBY_PAY_INSTRUCTIONS_H"

View Text - HTML Formatted

SELECT PAYMENT_INSTRUCTION_HISTORY_ID PAYMENT_INSTRUCTION_HISTORY_ID
, PMT_INSTRUCTION_HISTORY_DATE PMT_INSTRUCTION_HISTORY_DATE
, PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, PAYMENT_INSTRUCTION_NAME PAYMENT_INSTRUCTION_NAME
, PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE
, BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BEPID BEPID
, PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG
, TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRANSMIT_CONFIGURATION_ID TRANSMIT_CONFIGURATION_ID
, SECURITY_CONFIGURATION_ID SECURITY_CONFIGURATION_ID
, POSITIVE_PAY_FORMAT_CODE POSITIVE_PAY_FORMAT_CODE
, PROCESS_TYPE PROCESS_TYPE
, PAYMENT_INSTRUCTION_STATUS PAYMENT_INSTRUCTION_STATUS
, PAYMENTS_COMPLETE_FLAG PAYMENTS_COMPLETE_FLAG
, INT_BANK_ACCOUNT_ROUTING_NUM INT_BANK_ACCOUNT_ROUTING_NUM
, INT_BANK_ACCOUNT_NUMBER INT_BANK_ACCOUNT_NUMBER
, INT_BANK_ACCOUNT_IBAN_NUMBER INT_BANK_ACCOUNT_IBAN_NUMBER
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, PAY_ADMIN_ASSIGNED_REF_CODE PAY_ADMIN_ASSIGNED_REF_CODE
, PAYMENT_COUNT PAYMENT_COUNT
, TRANSMISSION_DATE TRANSMISSION_DATE
, ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE
, COMMENTS COMMENTS
, REMITTANCE_ADVICE_CREATED_FLAG REMITTANCE_ADVICE_CREATED_FLAG
, BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PAYMENT_FUNCTION PAYMENT_FUNCTION
, PRINTER_NAME PRINTER_NAME
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, 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
FROM "IBY"."IBY_PAY_INSTRUCTIONS_H"