IGI Combined Basis Reports: Payables - draft

Description
Categories: BI Publisher, Financials
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 Name SQL text Validation
Account Segment
 
Chart of Accounts Id
 
LOV Oracle
Data Access Set Id
 
Number
To Period
 
LOV Oracle
From Period
 
LOV Oracle
To Account
 
From Account
 
Secondary Ledger
 
LOV Oracle
Primary Ledger
 
LOV Oracle
Ask a question