Inquiries

The following are the Inquiries for Accounts Payable in Advantage:

Name	Page Code	Description
Backup Withholding Date Range Summary	BWRSI	This page enables you to search for records that have been stored on the Backup Withholding History Daily Balance table and view the summarized information in a single record.
Backup Withholding Notice Print History	BWNPH	This page stores historical information of printed First and Second Backup Withholding Notices. This table is populated by the Print Backup Withholding Notices batch process. You may also request that First or Second Backup Notices be reprinted from this page.
Backup Withholding Record Date	BWRDI	This page enables viewing information associated with federal backup withholding on the Backup Withholding History Daily Balance table.
Bank Account Balance	ABAL	This inquiry provides a snap shot of the Estimated Bank Balance in a bank account at a specific point in time. The point in time balance will be constrained by the rate at which updated account transaction information can be provided to you by the bank.
Bank Deposit Balance	BDB	This inquiry provides a snapshot of the daily bank deposit balances, which includes Open Deposits, Return Items. Adjustments, Total Bank Balance, Book Balance, and Variances.
Commodity Based Encumbrance Search	ENSRCH	This page allows searching for an encumbrance based on vendor and transaction details and to create a Payment Request transaction for all accounting lines or only the selected accounting lines.
Commodity Spend Analysis	CIPRCMPI	This inquiry allows researching spending on commodity codes. That spending can be viewed in many different ways including by vendor, by year, by month, and by the department and unit values used in the creation of Payment Request transactions.
Electronic Billing Inquiry	EBIT	This page captures the electronic invoice data from the Commodity lines of Invoice-Electronic (IE) transactions. Records cannot be manually modified/added/deleted directly on the table; instead, the table is only updated by the IE transaction, EPRC transaction, and the Electronic Payment Request Generation Chain Job.
Electronic Data Interchange Invoice File	EDIF	The Electronic Data Interchange Invoice File page allows you to see file detail information regarding EDI transactions processed by the system.
Electronic Data Interchange Invoice Header	EDIH	The Electronic Data Interchange Invoice Header page allows you to see invoice header information for EDI transactions loaded by the system.
Electronic Data Interchange Invoice Detail	EDID	The Electronic Data Interchange Invoice Detail page allows you to see EDI segment details for EDI transactions loaded by the system.
Intercept Activity	INTA	This page serves as the data source for intercept activity reporting including intercept activity associated with a payment provided in a particular Check Writer file, and allows you to view transaction detail information on payment offset activity for each individual claim. Refer to the "Intercept Activity (INTA)" topic in the CGI Advantage - Intercept User Guide for more information.
Intercept Activity Query	INTAQ	This page provides an alternate view of the Intercept Activity table. Refer to the “Intercept Activity Query (INTAQ)” topic in the CGI Advantage - Intercept User Guide for more information.
Interest Payment Request Inquiry	IPRINQ	The Interest Payment Request Inquiry (IPRINQ) provides you the ability to review and query Interest Payment Request (IPR) transactions.
Prenotes in Progress	PRNIP	This inquiry allows you to view the prenote status of vendors who are awaiting approval to receive payments electronically deposited directly to their bank accounts. The system updates this page automatically when you update the EFT status for a vendor to Prenote Requested on the Vendor/Customer table.
Retainage Detail	RTGDET	This page provides a detailed view of the amount of retainage withheld for each Payment Request commodity line.
Retainage Released/Forfeited	RTGPAID	This page lists all payout transactions that were created during the Retainage Payout process.
Retainage Summary by Award	RTGA	This page displays a commodity line that has retainage terms established or retainage withheld by a specific Payment Request transaction. The page displays the summarized retainage amounts by the Award totals.
Retainage Summary by Commodity Line	RTGSUM	This page stores the Award transaction and retainage terms if the Award is subject to retainage. RTGSUM is used to establish the payout of retainage, and to track the amount of retainage withheld, released, and forfeited against each commodity on the Award transaction that is subject to retainage.
Scheduled Invoice Generation	SIG	This page provides information about past and the next scheduled recurring invoices to be generated. Scheduled Invoice Generation records cannot be modified once a Recurring Invoice transaction has been generated.
Scheduled Invoice Generation Management	SIGM	This page allows you to manage recurring payments that are scheduled to have an Invoice generated during the Generate Recurring Invoice process.
Vendor Customer Archive	VCARCH	This inquiry allows you to view and query the list of Vendor/Customer Codes already archived or eligible to be archived, and is used by the Vendor Customer Archiving and Vendor Customer Archiving VSS Updates processes to communicate the list of Vendor/Customer codes to be archived between the Financial and Vendor Self Service (VSS) applications.
Vendor Invoice Registry	VIR	This page displays a list of each Vendor Invoice recorded in Advantage. The Vendor Invoice Registry is used to ensure that duplicate invoices are not recorded from the same vendor.
Vendor Payment History	VPAY	This inquiry allows you to search for specific information related to vendor payment transactions. The Vendor Payment History page allows you to query disbursement/payment information for transactions that belong to the AD, MD, DC, CR, RE, IET, and ITA Transaction Types.
Vendor Transaction History	VTH	This inquiry allows you to search for specific information related to vendor transactions. You can query information for all transactions that can be queried from Vendor Payment History. The Vendor Transaction History pages allows you to also query transactions of the RQ, PO, PR, ABS, JV and PYRL Transaction Types.