FV_TREASURY_TRANSACTION_V

Details

• Schema: FUSION

• Object owner: FV

• Object type: VIEW

Columns

Name
TREASURY_CONFIRMATION_ID TREASURY_DOC_DATE TREASURY_ACCOMPLISHMENT_DATE PAYMENT_DOCUMENT_NAME PAYMENT_INSTRUCTION_REF_CODE PAYMENT_INSTRUCTION_ID BANK_ACCOUNT_NUMBER VENDOR_NAME FEDERAL_PAYMENT_TYPE BANK_BRANCH_NAME PAYMENT_ACCOUNTED_CODE STATUS_CODE

Query

SQL_Statement

SELECT FTC.TREASURY_CONFIRMATION_ID "TREASURY_CONFIRMATION_ID", FTC.TREASURY_CONFIRM_DATE "TREASURY_DOC_DATE", FTC.TREASURY_CONFIRM_DATE "TREASURY_ACCOMPLISHMENT_DATE", CPD.PAYMENT_DOCUMENT_NAME "PAYMENT_DOCUMENT_NAME", IPI.PAY_ADMIN_ASSIGNED_REF_CODE "PAYMENT_INSTRUCTION_REF_CODE", FTC.PAYMENT_INSTRUCTION_ID "PAYMENT_INSTRUCTION_ID", AC.BANK_ACCOUNT_NUM "BANK_ACCOUNT_NUMBER", AC.VENDOR_NAME "VENDOR_NAME", FTC.FEDERAL_PAYMENT_TYPE_CODE "FEDERAL_PAYMENT_TYPE", IPA.EXT_BANK_BRANCH_NAME "BANK_BRANCH_NAME", FTC.PAYMENT_ACCOUNTED_CODE, FTC.STATUS_CODE FROM FV_TREASURY_CONFIRM_ALL FTC, AP_CHECKS_ALL AC, IBY_PAY_INSTRUCTIONS_ALL IPI, CE_PAYMENT_DOCUMENTS CPD, IBY_PAYMENTS_ALL IPA WHERE FTC.PAYMENT_INSTRUCTION_ID = AC.PAYMENT_INSTRUCTION_ID AND FTC.PAYMENT_INSTRUCTION_ID = IPI.PAYMENT_INSTRUCTION_ID AND AC.PAYMENT_DOCUMENT_ID = CPD.PAYMENT_DOCUMENT_ID AND IPA.PAYMENT_INSTRUCTION_ID=FTC.PAYMENT_INSTRUCTION_ID AND IPA.PAPER_DOCUMENT_NUMBER=AC.CHECK_NUMBER