Paid Invoices
Job type: RPG
Archive: Optional
Selection criteria
Deletes every paid invoice where:
- Invoice Run Number (GJCLCD) = incoming parameter
- Company Number (GJCICD) = incoming parameter
- Invoice Status (GJC6ST) = ‘2’ (printed)
The incoming parameters are manually input in CMP
Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office.
A paid invoice is defined as one that has no open amount (field RPAAP) in the F0311 table (Accounts Receivable) for that document type and invoice number and there are no unresolved records in table CSORREP (Query Amounts) for that invoice (i.e. ORQ1ST = ‘2’ for every record found).
|
Name |
Description |
|---|---|
|
COGJREP |
Invoice Header |
|
COGKREP |
Invoice Detail |
|
CFBAREP |
Inv Detail VAT Incl Audit |
|
COI8CPP |
Invoice Insert |
|
COHTREP |
Invoice Tax Breakdown |
|
COGTREP |
Invoice/Surrogate X-Ref |
|
COG0REP |
Subscription Invoice |
|
COGPREP |
Subs Detailed Bill Hist |
|
COISREP |
Subs Invoice Comment Hist |
|
CSORREP |
Query Amounts |
|
CHA8REP |
Inv Billable Ast Hdr Hist |
|
CHA9REP |
Inv Billable Ast Dtl Hist |
|
TZCGREP |
9Original Print Values |