Sales Orders
Job type: RPG
Archive: Optional
Selection criteria
The following criteria must all be satisfied before an order can be purged:
- Company Number (OQCICD) = incoming parameter.
- Despatch by Date (OQN9DT) < incoming date parameter.
- 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 and records are purged by order number, except for those indicated by an asterisk (*) in the table. These tables are GPDR related, so they are not archived.
An exit point program is used to configure additional satellite tables to purge. The impacted tables listed include those purged by the exit point program of the Sales Demo environment.
|
Name |
Description |
|---|---|
|
CSOQREP |
DISE Order |
|
CSQAREP |
Order Line |
|
CSQGREP |
DISE Item Line |
|
CXE7CPP |
Order Item Subs Link |
|
CSTOREP |
Order Comments |
|
CSQ0CPP |
Subscription Order |
|
SQQ5REP |
Satellite Order Header |
|
SQQ6REP |
Satellite Order Detail |
|
SQQ8REP |
DISE Order X-Ref |
|
SQRAREP |
Satellite Serial Number |
|
SQRBREP |
Satellite Order Address |
|
SQRDREP |
Satellite Status Change |
|
SGGWCPP |
DISE Order Status |
|
SJQOREP |
Outstanding SOP Items |
|
SQRCCPP |
Dispatcher Consignments |
|
TQAJCPP |
9Dispatcher Additional Dt |
|
DCEMREP * |
920/20 Interface Hdr WRKF |