Hardware Services

Job type: RPG

Archive: Optional

Selection criteria

The following criteria must all be satisfied before a hardware service job can be purged:

  • Company Number (EACICD) = incoming parameter.
  • Job Cancellation Date (EAF0DT) <> 0 and < incoming cancellation date parameter.
  • Invoice Generated Date (EAF6DT) <> 0 and < incoming invoice date parameter.
  • No record exists in table COGJREP (Invoice Header) for this job’s associated invoices (invoice number stored in JLH3NB in table COJLREP).

The incoming parameters are manually entered in CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office.

 

Tables Impacted

Name

Description

COEACPP

Hware Srv Job

COHGREP

Hware Srv Job Appointment

COHCREP

Hware Srv Job Comment

COHDREP

Hware Srv Job Detail

COJLREP

Hware Srv Job Invoice

COHEREP

Hware Srv Job Charge

COHIREP

Hware Srv Job Repair Est.

CPAJCPP

Hware Srv Job Sts History

CSQ7REP

Hware Srv Job Items

CSRDREP

Hware Srv Job Serial No.