IBY_EXT_FD_PMT_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

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 SERVICE_LEVEL_CODE SERVICE_LEVEL_MEANING SERVICE_LEVEL_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 LOGICAL_GROUP_REFERENCE TOTAL_PAYMENT_AMOUNT TOTAL_PAYMENT_COUNT PAYMENT_PROFILE_ID POSITIVE_PAY_FILE_CREATED_FLAG INV_EXT_PAYEE_ID INV_SUPPLIER_SITE_ID ANTICIPATED_VALUE_DATE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY VOID_DATE BEP_STATUS BEP_ERROR_CODE BEP_ERROR_MESSAGE_TEXT ACKNOWLEDGEMENT_DATE PAYMENT_MODE_CODE PAYMENT_INSTRUMENT_ID

Query

SQL_Statement

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, SERVICE_LEVEL_CODE, SERVICE_LEVEL_MEANING, SERVICE_LEVEL_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, LOGICAL_GROUP_REFERENCE, TOTAL_PAYMENT_AMOUNT, TOTAL_PAYMENT_COUNT, PAYMENT_PROFILE_ID, POSITIVE_PAY_FILE_CREATED_FLAG,INV_EXT_PAYEE_ID,INV_SUPPLIER_SITE_ID,ANTICIPATED_VALUE_DATE, CREATED_BY,CREATION_DATE,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,VOID_DATE,BEP_STATUS, BEP_ERROR_CODE, BEP_ERROR_MESSAGE_TEXT, ACKNOWLEDGEMENT_DATE, PAYMENT_MODE_CODE, PAYMENT_INSTRUMENT_ID FROM IBY_EXT_FD_PMT_1_0_VT ORDER BY PAYMENT_REFERENCE_NUMBER