Pre-Paid Usage

Job type: RPG

Archive: Optional

Selection criteria

Deletes every record where Date Created (B5EJDT) <= incoming date parameter. The parameter is manually entered in CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office as a number of days, which is converted to a date.

Associated tables are purged using Original Request Number (B5N2NB) and Original Request Sequence (B5N3NB) as the key.

Tables Impacted

Name

Description

C9B5REP

Pre-Paid Usage Detail

C4JMREP

CPP Calls Basket

CQAPCPP

Usage Attribute

CQAICPP

Usage Attribute Unique