Increment Virtual Business Date (dtesys)
|
Module Name |
dtesys.pc |
|
Description |
Increment Virtual Business Date |
|
Functional Area |
Administration |
|
Module Type |
Admin |
|
Module Technology |
ProC |
|
Catalog ID |
RMS220 |
|
Wrapper Script |
rmswrap.ksh |
Design Overview
This batch program updates the PERIOD table for various dates required in Merchandising such as vdate, end-of-month and end-of-week dates.
Vdate (short for virtual business date) is used by Merchandising to maintain a consistent ‘virtual' business date (without regard for actual date changes at midnight or different dates in different timezone) for accounting purposes. Sysdate from the database is used to capture audit time and date stamps on transactions.
Note:
Vdate is used to determine the business date for the financial impact of transactions.
Generally, dtesys is run without additional input parameters and increments the data by one day. However, if a specific date is passed into the program as a parameter, the system date will be updated to that date.
Special processing also occurs:
-
Weekly
When vdate = next_eow_date_unit, the program increments the last_eow_date_unit and next_eow_date_unit columns on system_variables. The last_eow_date_unit is updated to the current next_eow_date_unit and the next_eow_date_unit is updated to the next end-of-week date (calculated).
-
Monthly
When vdate = next_eom_date_unit, the program updates the last_eom_date_unit and next_eom_date_unit columns on system_variables. The last_eom_date_unit is updated to the current next_eom_date_unit and the next_eom_date_unit is updated to the next end-of-month date (calculated).