IGI Combined Basis Reports: Payables Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
Combined Basis Reports: Payables Report
Combined Basis Reports: Payables Report
SQL 13 lines
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 |
Parameters 6
| Parameter | Type | List of values SQL |
|---|---|---|
| Primary Ledger | LOV Oracle | |
| Secondary Ledger | LOV Oracle | |
| From Account | Char | |
| To Account | Char | |
| From Period | LOV Oracle | |
| To Period | LOV Oracle |