IGI Combined Basis Reports: Payables Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Combined Basis Reports: Payables Report
Application: Public Sector Financials International
Source: Combined Basis Reports: Payables Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIPCBAP_XML
DB package: IGI_IGIPCBAP_XMLP_PKG
SELECT	  ORG_ID
	, ORGANIZATION	
	, ACCOUNT_NUM
	, DOC_SEQ_NUM
	, INVOICE_NUM
	, INVOICE_DATE
	, VENDOR_NUM
	, ROUND(AMOUNT,2) AMOUNT
	, ROUND(OPENING_VAR,2) OPENING_VAR,
	IGI_IGIPCBAP_XMLP_PKG.CF_NO_DATAFORMULA(INVOICE_NUM) CF_NO_DATA
FROM	IGI_CBR_AP_INTERFACE
ORDER BY 1 ASC,2 ASC,3 ASC
Parameter NameSQL textValidation
Primary Ledger
 
LOV Oracle
Secondary Ledger
 
LOV Oracle
From Account
 
Char
To Account
 
Char
From Period
 
LOV Oracle
To Period
 
LOV Oracle
Download
Related Blitz Reports
IGI Combined Basis Reports: Receivables - draft IGI Combined Basis Reports: Detail Report- Not Supported: Reserved For Future Use IGI Standing Charges: Transaction History Report- Not Supported: Reserved For Future Use IGI Standing Charges: Transaction Report- Not Supported: Reserved For Future Use GL MoFU KPI Dashboard Exceptions GL MoFU KPI Dashboard IGI Secondary Invoice Approval : Secondary Approval of Invoices - draft IGI CIS2007 Subcontractor Statement of Payment and Deductions IGI CIS2007 Registered Supplier Listing
Blitz Report™