DM_SITE_CODE issue
The DM_SITE_CODE in the “Sales Staging Table” (actually the
error version at this point) is not the correct structure and therefore all the
sales are erroring out when that data looks for a “match” in the Location
Table.
In the location table, you can see the correct structure in
the “DM_SITE_CODE” column – number/colon/number. The next screen shot
shows the same data in the “T_EP_SITE” table (may or may not be the source for
the Sales Table process). The structure and data match.
The 2rd screen shot is from the “Sales data error