IGI Standing Charges: Transaction - draft

Description
Categories: BI Publisher
Columns: Sob Name, Charge Reference, Customer, Batch Source, Trans Type, Status, Stop, Department, Description, Invoice Number ...
Application: Public Sector Financials International
Source: Standing Charges: Transaction Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIRRTRN_XML
DB package: IGI_IGIRRTRN_XMLP_PKG
SELECT	gsob.NAME		"sob_name"
,	sc.charge_reference 		"Charge Reference"
,	hp.party_name			"Customer"
,	bs.name			"Batch Source"
,	ty.name			"Trans Type"
,	sc.status			"Status"
,	sc.suppress_inv_print	"Stop"
,	sr.name			"Department"
,	sc.description		"Description"
,	tx.trx_number		"Invoice number"
,	tx.trx_date		"Invoice Date"
,	max(gd.gl_Date)           	"GL Date"