Line Item Extension

Job type: RPG

Archive: Optional

Selection criteria

The following criteria must all be satisfied before a record can be purged:

• Company Number (A9CICD) = incoming parameter.
• Date Created (A9EJDT) <= incoming date parameter.
• Associated order in table CSOQREP (DISE Order) doesn’t exist.
  • OR it does exist and Closed Orders Only incoming parameter is No.
  • OR it does exist, Closed Orders Only incoming parameter is Yes and Order Status (OQHUSU) = ‘6’ (completed) or ‘7’ (cancelled).

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 (after initially defaulting from a configuration table).

Tables Impacted

Name	Description
TFA9CPP	9Item Line Serial Numbers