How does the DAILY_DATA_TEMP table populated?
Hello All,
I would like to know, how does the DAILY_DATA_TEMP table got populated? From the OG I can see that the records are inserted by the SALDLY.PC program.
But whenever i run the SALDLY.PC it does not insert records into DAILY_DATA_TEMP table, due to this transaction details from DAILY_DATA table not rolled up by the SALWEEK job.
From the ProC code i can see there is a string comparison between two dates which is eow_date and last_end_eow_date. Please refer the below code.
Currently my vdate is 01-MAR-15 and last_eow_date as per SYSTEM_VARIABLES table is - 28-FEB-15.