Purge Non-Operational Freight

Purge Non-Operational Freight is initiated from the Supplementary Purge using Request Type "PNOF".

The Purge Non-Operational Freight utility will delete qualifying entries in the following tables:

  • Non-Operational Freight (NON_OP_FRHT_T)
  • Non-Operational Freight Stop (NON_OP_FRHT_STOP_T)
  • Non-Operational Freight Weight by Freight Class (NON_OP_FRHT_WGT_BY_FRHTCLS_T)
  • Charge Override (CHRG_OVRD_T)
  • Voucher Run Exceptions (VCHR_RUN_EXCP_T)
  • G/L Transactions (GL_TRNS_T)
  • Rating Information (RATG_INFO_T)
  • A/P Voucher (VCHR_AP_T)
  • A/R Voucher (VCHR_AR_T)
  • Freight Bill Detail (FRHT_BILL_DETL_T)
  • Freight Bill Detail Charge (FRHT_BILL_DETL_CHRG_T)
  • Invoice Detail (INVC_DETL_T)
  • Reference Numbers (RFRC_NUM_T)
  • Charge Detail (CHRG_DETL_T)
  • Memo (MMO_T)

This function will purge completed and cancelled non-operational freight (NOF) transactions and all corresponding data. NOF transactions will be purged when either of the following is True:

  • NOF is in Canceled status
  • NOF and all related financial transactions are complete (all of the following are True):
    • Shipping Date is older than the cut-off date.
    • NOF Status is Closed or Voucher Matched.
    • All A/P Vouchers referencing this NOF are in Closed or Canceled Status.
    • All A/R Vouchers referencing this NOF are in Closed or Canceled Status.
    • For each A/P Voucher referencing this NOF:
      • The corresponding Freight Bill must meet minimum status requirements, as dictated on the Purge Supplementary Data page:
      • If Minimum Status is "Closed", status for Freight Bill must be Closed
      • If Minimum Status is "A/R, A/P or G/L", status for Freight Bill must be Accounts Payable or Closed
  • The corresponding Invoice (if it exists) must meet minimum status requirements, as dictated on the Purge Supplementary Data page:
    • If Minimum Status is "Closed", status for Invoice must be Closed
    • If Minimum Status is "A/R, A/P or G/L", status for Invoice must be Accounts Receivable or Closed
  • All G/L Transactions referencing this NOF must meet minimum status requirements, as dictated on the Purge Supplementary Data page:
    • If Minimum Status is "Closed", status for G/L Transaction must be Closed
    • If Minimum Status is "A/R, A/P or G/L", status for G/L Transaction must be Accounts Payable, Accounts Receivable or Closed

See Also