Agreements
Job type: RPG
Archive: Optional
Selection criteria
The following criteria must all be satisfied before an agreement
In the Cloud Monetisation Platform, the entity that holds the instructions for generating the bills for one or more subscriptions. including the addresses and how often the bill is generated. can be purged:
- Company Number (EDCICD) = incoming parameter.
- Agreement Termination Date (EDBIDT) <> 0 and < incoming date parameter.
- No record exists in table COCXREP (Subscription A billing entity that incurs a charge. Examples include a network attached device whose usage you want to measure and charge for, or a monthly software subscription) for this agreement.
- No record exists in table COFNREP (Diary Event) for this agreement OR records do exist but all have Event Status (FNA1ST) = ‘S’, ‘R’ or ‘G’.
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 and records are purged by agreement number except those indicated by a number in parentheses in the table, as explained in the Notes.
|
Name |
Description |
|---|---|
|
COEDREP |
Agreement |
|
COE4REP |
Agreement Tariff |
|
COGCREP |
Agreement Service |
|
COEWREP |
Alc Disc Scheme |
|
COEXREP (1) |
Alc Disc Scheme Srv |
|
COE0REP (1) |
Alc Disc Scheme CC Group |
|
COEYREP (1) |
Alc Disc Scheme Srv Val B |
|
COEZREP (1) |
Alc Disc Scheme Srv Vol B |
|
COE1REP (1) |
Alc Disc Sch CC Grp Val B |
|
COE2REP (1) |
Alc Disc Sch CC Grp Dur B |
|
COIHREP (1) |
Alc Disc Sch CC Grp Vol B |
|
CSQEREP |
Agreement Bundle |
|
CSQFREP |
Agreement Bundle Band |
|
CSF3REP |
Agreement Cost Center |
|
CSKDCPP |
Agreement Network Stats |
|
CSKKCPP |
Agreement Ntwk Type Stats |
|
CSKMCPP |
Agreement Tariff Stats |
|
CSNFREP (1) |
Alc Disc Sch Favourite No |
|
CSRKREP (1) |
Alc Disc Scheme Extension |
|
CSRLREP (1) |
Alc Disc Schm Inv Vol Bnd |
|
CSNGREP (1) |
Alc Disc Sch CC Gp Fav No |
|
CSRNREP (1) |
Alc Disc Scheme X-Product |
|
COE5REP (2) |
Call Class Override Table |
|
COE6REP (2) |
Dialled No Override Table |
|
CXGMREP |
Contract History - Agrmt |
|
CXGJREP |
Agreement Extension |
|
CXGLREP |
Contract Attachment |
|
COFNREP |
Diary Event |
|
COFOREP (3) |
Diary Event Action |
|
COFRREP (3) |
Diary Event Letter Detail |
|
COFSREP (3) |
Diary Event Note Line |
|
COFUREP (3) |
Diary Event Pass to Hist |
|
COFVREP (3) |
DE Resolution Date Change |
|
COIYCPP (3) |
Diary Event Process Error |
|
COJOREP (3) |
Diary Event S/L Adjustment |
|
CRN5CPP (3) |
Diary Event Short Message |
|
CRN6CPP (3) |
Diary Event Short Msg Txt |
|
CRN7CPP (3) |
Diary Event Short Msg Dtl |
|
COBQREP (3) |
Account Move Action Detl |
|
COB5REP (3) |
Network Action Detail |
|
CSO6REP (3) |
Network Pending Activity |
|
COCFREP (3) |
Subs Service Action Detl |
|
COFPREP (3) |
Diary Event Actioned Item |
|
COFQREP (3) |
Diary Event Letter |
|
COJUCPP (4) |
DE Item Confirm Error |
|
COMOREP (3) |
Diary Event Letter Fax |
|
CXANCPP (3) |
Diary Event Task Data |
|
CZILCPP (3) (5) |
Diary Event Email |
|
TFB0CPP (3) (5) |
9Network Request Log |
Notes:
- Uses DS Allocation Number (EWC0NB) from table COEWREP (Alc Disc Scheme) as the key.
- Uses override level = ‘2’ (agreement) and reference ID = EDB6NB as its key, rather than the usual agreement number.
- Uses Event Number (FNBMCD) from table COFNREP (Diary Event) as the key.
- Uses Action Item Number (FPDFNB) from table COFPREP (Diary Event Actioned Item) as the key.
- Tables are GDPR-related and so are not archived.