Wfslsupld Staging

In Scope

Technical: WFSLSUPLD_STAGING | ID: OR-FND-WFSLSUPLD_STAGING-WFSLSUPLD_STAGING

Stores the raw file detail data read in from the non- stockholding franchise store sales file.

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: WFSLSUPLD_STAGING

Field Definitions(5)

Rules & Considerations(9)

Sample Load Data(4)

_scenario	ITEM	CHUNK_ID	ERROR_MSG	REPORT_DATE	CUSTOMER_LOC	NET_SALES_QTY	TOTAL_RETAIL_AMT	NET_SALES_QTY_UOM	TOTAL_RETAIL_AMT_CURR	FILE_RECORD_DESCRIPTOR
Example values from field definitions	SAMPLE	1	SAMPLE	2026-01-01	1	1.0000	1.0000	SAMP	SAM	SAMPL
default	Wfslsupld Staging-002-ALT	1000000003	Wfslsupld Staging-002-ALT	2026-01-03	3	12.5000	12.5000	Wfsl	Wfs	Wfsls
default	Wfslsupld Staging-003-EDG	1000000005	Wfslsupld Staging-003-EDGE	2026-01-05	5	14.0000	14.0000	Wfsl	Wfs	Wfsls

Example values from field definitions

ITEM: SAMPLE
CHUNK_ID: 1
ERROR_MSG: SAMPLE
REPORT_DATE: 2026-01-01
CUSTOMER_LOC: 1
NET_SALES_QTY: 1.0000
TOTAL_RETAIL_AMT: 1.0000
NET_SALES_QTY_UOM: SAMP
TOTAL_RETAIL_AMT_CURR: SAM
FILE_RECORD_DESCRIPTOR: SAMPL

default

ITEM: Wfslsupld Staging-002-ALT
CHUNK_ID: 1000000003
ERROR_MSG: Wfslsupld Staging-002-ALT
REPORT_DATE: 2026-01-03
CUSTOMER_LOC: 3
NET_SALES_QTY: 12.5000
TOTAL_RETAIL_AMT: 12.5000
NET_SALES_QTY_UOM: Wfsl
TOTAL_RETAIL_AMT_CURR: Wfs
FILE_RECORD_DESCRIPTOR: Wfsls

default

ITEM: Wfslsupld Staging-003-EDG
CHUNK_ID: 1000000005
ERROR_MSG: Wfslsupld Staging-003-EDGE
REPORT_DATE: 2026-01-05
CUSTOMER_LOC: 5
NET_SALES_QTY: 14.0000
TOTAL_RETAIL_AMT: 14.0000
NET_SALES_QTY_UOM: Wfsl
TOTAL_RETAIL_AMT_CURR: Wfs
FILE_RECORD_DESCRIPTOR: Wfsls

Rule Validation Summary

Source Rule Count: 12
Governed Rule Count: 9