VIEW: IBY.IBY_PAY_INSTRUCTIONS_ALL#

Source

View Text - Preformatted

select PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID, PROCESS_TYPE PROCESS_TYPE, PAYMENT_INSTRUCTION_STATUS PAYMENT_INSTRUCTION_STATUS, PAYMENTS_COMPLETE_CODE PAYMENTS_COMPLETE_CODE, GENERATE_SEP_REMIT_ADVICE_FLAG GENERATE_SEP_REMIT_ADVICE_FLAG, REMITTANCE_ADVICE_CREATED_FLAG REMITTANCE_ADVICE_CREATED_FLAG, REGULATORY_REPORT_CREATED_FLAG REGULATORY_REPORT_CREATED_FLAG, BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PAYMENT_COUNT PAYMENT_COUNT, POSITIVE_PAY_FILE_CREATED_FLAG POSITIVE_PAY_FILE_CREATED_FLAG, PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG, TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG, 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, INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID, PAY_ADMIN_ASSIGNED_REF_CODE PAY_ADMIN_ASSIGNED_REF_CODE, TRANSMISSION_DATE TRANSMISSION_DATE, ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE, COMMENTS COMMENTS, BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE, ORG_ID ORG_ID, ORG_TYPE ORG_TYPE, PAYMENT_DATE PAYMENT_DATE, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID, PAYMENT_FUNCTION PAYMENT_FUNCTION, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, RFC_IDENTIFIER RFC_IDENTIFIER, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS, PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID, PRINTER_NAME PRINTER_NAME, 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, REFERENCE_FORMAT_CODE REFERENCE_FORMAT_CODE, REQUEST_ID REQUEST_ID, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, CARD_ISSUER_FILE_SEQ_NO CARD_ISSUER_FILE_SEQ_NO from "IBY"."IBY_PAY_INSTRUCTIONS_ALL"

View Text - HTML Formatted

SELECT PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, PROCESS_TYPE PROCESS_TYPE
, PAYMENT_INSTRUCTION_STATUS PAYMENT_INSTRUCTION_STATUS
, PAYMENTS_COMPLETE_CODE PAYMENTS_COMPLETE_CODE
, GENERATE_SEP_REMIT_ADVICE_FLAG GENERATE_SEP_REMIT_ADVICE_FLAG
, REMITTANCE_ADVICE_CREATED_FLAG REMITTANCE_ADVICE_CREATED_FLAG
, REGULATORY_REPORT_CREATED_FLAG REGULATORY_REPORT_CREATED_FLAG
, BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PAYMENT_COUNT PAYMENT_COUNT
, POSITIVE_PAY_FILE_CREATED_FLAG POSITIVE_PAY_FILE_CREATED_FLAG
, PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG
, TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG
, 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
, INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, PAY_ADMIN_ASSIGNED_REF_CODE PAY_ADMIN_ASSIGNED_REF_CODE
, TRANSMISSION_DATE TRANSMISSION_DATE
, ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE
, COMMENTS COMMENTS
, BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, ORG_ID ORG_ID
, ORG_TYPE ORG_TYPE
, PAYMENT_DATE PAYMENT_DATE
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, PAYMENT_FUNCTION PAYMENT_FUNCTION
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, RFC_IDENTIFIER RFC_IDENTIFIER
, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID
, PRINTER_NAME PRINTER_NAME
, 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
, REFERENCE_FORMAT_CODE REFERENCE_FORMAT_CODE
, REQUEST_ID REQUEST_ID
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, CARD_ISSUER_FILE_SEQ_NO CARD_ISSUER_FILE_SEQ_NO
FROM "IBY"."IBY_PAY_INSTRUCTIONS_ALL"