VIEW: APPS.IBY_EXT_FD_PMT_1_0_V

Source

View Text - Preformatted

SELECT payment_instruction_id, payment_id, internal_bank_account_id, legal_entity_id, calling_app_id, application_name, payment_service_request_id, payment_function, payment_function_meaning, payment_org_id, payment_org_type, payment_org_type_meaning, payment_org_name, payment_doc_category, payment_doc_sequence_name, payment_doc_sequence_value, payment_reference_number, paper_document_number, payment_date, payment_due_date, maturity_date, payment_status, payment_status_meaning, payee_party_id, payee_party_site_use_id, external_bank_account_id, payment_amount, payment_currency_code, payment_amount_text, payment_method_code, payment_method_name, payment_method_attr_cat, exclusive_payment_flag, settlement_priority, settlement_priority_meaning, amount_withheld, discount_amount_taken, bank_charge_bearer, bank_charge_bearer_meaning, bank_charge_amount, delivery_channel_code, delivery_channel_meaning, delivery_channel_format_value, bank_instruction1_code, bank_instruction1_meaning, bank_instruction1_format_value, bank_instruction2_code, bank_instruction2_meaning, bank_instruction2_format_value, bank_instruction_details, payment_text_message1, payment_text_message2, payment_text_message3, payment_details, unique_remittance_identifier, uri_check_digit, payment_reason_code, payment_reason_meaning, payment_reason_format_value, payment_reason_comments, remittance_message1, remittance_message2, remittance_message3, declare_payment_flag, declaration_amount, declaration_currency_code, federal_allotment_code, federal_offset_eligibility, payment_attr_cat, beneficiary_name, federal_sps_treasury_symbol, employee_payment_flag, payment_method_format_value, /*LKQ POS PAY ISSUE - PAVAN*/ positive_pay_file_created_flag, void_date, logical_group_reference, payment_profile_id,anticipated_value_date FROM iby_ext_fd_pmt_1_0_vt ORDER BY payment_reference_number

View Text - HTML Formatted

SELECT PAYMENT_INSTRUCTION_ID
, PAYMENT_ID
, INTERNAL_BANK_ACCOUNT_ID
, LEGAL_ENTITY_ID
, CALLING_APP_ID
, APPLICATION_NAME
, PAYMENT_SERVICE_REQUEST_ID
, PAYMENT_FUNCTION
, PAYMENT_FUNCTION_MEANING
, PAYMENT_ORG_ID
, PAYMENT_ORG_TYPE
, PAYMENT_ORG_TYPE_MEANING
, PAYMENT_ORG_NAME
, PAYMENT_DOC_CATEGORY
, PAYMENT_DOC_SEQUENCE_NAME
, PAYMENT_DOC_SEQUENCE_VALUE
, PAYMENT_REFERENCE_NUMBER
, PAPER_DOCUMENT_NUMBER
, PAYMENT_DATE
, PAYMENT_DUE_DATE
, MATURITY_DATE
, PAYMENT_STATUS
, PAYMENT_STATUS_MEANING
, PAYEE_PARTY_ID
, PAYEE_PARTY_SITE_USE_ID
, EXTERNAL_BANK_ACCOUNT_ID
, PAYMENT_AMOUNT
, PAYMENT_CURRENCY_CODE
, PAYMENT_AMOUNT_TEXT
, PAYMENT_METHOD_CODE
, PAYMENT_METHOD_NAME
, PAYMENT_METHOD_ATTR_CAT
, EXCLUSIVE_PAYMENT_FLAG
, SETTLEMENT_PRIORITY
, SETTLEMENT_PRIORITY_MEANING
, AMOUNT_WITHHELD
, DISCOUNT_AMOUNT_TAKEN
, BANK_CHARGE_BEARER
, BANK_CHARGE_BEARER_MEANING
, BANK_CHARGE_AMOUNT
, DELIVERY_CHANNEL_CODE
, DELIVERY_CHANNEL_MEANING
, DELIVERY_CHANNEL_FORMAT_VALUE
, BANK_INSTRUCTION1_CODE
, BANK_INSTRUCTION1_MEANING
, BANK_INSTRUCTION1_FORMAT_VALUE
, BANK_INSTRUCTION2_CODE
, BANK_INSTRUCTION2_MEANING
, BANK_INSTRUCTION2_FORMAT_VALUE
, BANK_INSTRUCTION_DETAILS
, PAYMENT_TEXT_MESSAGE1
, PAYMENT_TEXT_MESSAGE2
, PAYMENT_TEXT_MESSAGE3
, PAYMENT_DETAILS
, UNIQUE_REMITTANCE_IDENTIFIER
, URI_CHECK_DIGIT
, PAYMENT_REASON_CODE
, PAYMENT_REASON_MEANING
, PAYMENT_REASON_FORMAT_VALUE
, PAYMENT_REASON_COMMENTS
, REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3
, DECLARE_PAYMENT_FLAG
, DECLARATION_AMOUNT
, DECLARATION_CURRENCY_CODE
, FEDERAL_ALLOTMENT_CODE
, FEDERAL_OFFSET_ELIGIBILITY
, PAYMENT_ATTR_CAT
, BENEFICIARY_NAME
, FEDERAL_SPS_TREASURY_SYMBOL
, EMPLOYEE_PAYMENT_FLAG
, PAYMENT_METHOD_FORMAT_VALUE
, /*LKQ POS PAY ISSUE - PAVAN*/ POSITIVE_PAY_FILE_CREATED_FLAG
, VOID_DATE
, LOGICAL_GROUP_REFERENCE
, PAYMENT_PROFILE_ID
, ANTICIPATED_VALUE_DATE
FROM IBY_EXT_FD_PMT_1_0_VT ORDER BY PAYMENT_REFERENCE_NUMBER