Franchise Order Purge (wfordprg)
Module Name |
wfordprg.pc |
Description |
Franchise Order Purge |
Functional Area |
Franchise Management |
Module Type |
Admin |
Module Technology |
ProC |
Catalog ID |
RMS392 |
Wrapper Script |
rmswrap_multi.ksh |
Design Overview
This batch program is used to purge franchise orders from Merchandising after a set number of days have elapsed, as defined by the system parameter Franchise History Months. Additionally, in order to be purged via this process, the franchise orders must have no associated franchise returns and must not have any billing records that have not been extracted or where not enough time has elapsed since they were extracted, as defined by the Franchise History Months system parameter.
Restart/Recovery
The logical unit of work for this module is defined as a unique franchise order number. The restart franchise order view is used for threading. This batch program uses table-based restart/recovery. The commit happens in the database when the maximum commit counter is reached.
Design Assumptions
-
Transfers, Allocations, POs and Store Orders associated with franchise orders are deleted through purge processes for those functional areas (e.g. tsfprg for Transfers). Franchise orders will not be allowed to be deleted until these associated records have been removed via the other processes.