All Invoices
Job type: RPG
Archive: Optional
Selection criteria
Deletes every invoice where:
- Invoice Run Number (GJCLCD) = incoming parameter
- Company Number (GJCICD) = incoming parameter
- Invoice Status (GJC6ST) = ‘2’ (printed)
The incoming parameters are manually entered in CMP
Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office.
The selection criteria also requires that 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 |