Unmatched Invoices
Job type: RPG
Archive: Optional
Selection criteria
Deletes every unmatched invoice where:
- Invoice Run Number (GJCLCD) = incoming parameter
- Company Number (GJCICD) = incoming parameter, and
- 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.
An unmatched invoice is defined as one that has a total, positive 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).
The above rules mean that an unmatched credit note will never be purged here.
|
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 |