eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FV_PAYMENT_MASTER_V

Product:	FV - Federal Financials
Description:	Retrieves payment details in the form Document Cross-Reference
Implementation/DBA Data:	APPS.FV_PAYMENT_MASTER_V

View Text

SELECT AC.ORG_ID
, AC.CHECK_ID
, AC.VENDOR_ID
, AC.VENDOR_SITE_ID
, AC.TREASURY_PAY_NUMBER
, AC.TREASURY_PAY_DATE
, AC.AMOUNT
, AC.CHECKRUN_NAME
, AC.CHECK_NUMBER
, AC.CHECK_DATE
, AC.STATUS_LOOKUP_CODE
, AC.VOID_DATE
FROM AP_CHECKS AC

Columns

Name
ORG_ID
CHECK_ID
VENDOR_ID
VENDOR_SITE_ID
TREASURY_PAY_NUMBER
ACCOMPLISHED_DATE
AMOUNT
CHECKRUN_NAME
CHECK_NUMBER
CHECK_DATE
VOID_STATUS
VOID_DATE