IGI Standing Charges: Listing - draft

Description
Categories: BI Publisher
Columns: Sob Name, Standing Charge, Charge Reference, Transaction, Status, Date, Batch Source, Sales Person, Bill To Name, Ship To Name ...
Application: Public Sector Financials International
Source: Standing Charges: Listing (XML) - Not Supported: Reserved For Future Use
Short Name: IGIRRSCL_XML
DB package: IGI_IGIRRSCL_XMLP_PKG
SELECT   distinct  gsob.NAME "sob_name"
      , sc.description "Standing_Charge"
      , sc.charge_reference "Charge_Reference"
      , ty.NAME "Transaction"
      , sc.status "Status"
      , sc.standing_charge_date "Date"
      , bs.name "Batch_Source"
      , sr.name "Sales_Person"
      , hp1.party_name Bill_to_name
      , cu2.party_name Ship_to_name
      , sc.suppress_inv