ReSA Total

In Scope

Technical: SA_TOTAL | ID: OR-RSA-SA_TOTAL-RESA_TOTAL

Stores the the specific information for a total on a given store/day or store/day balancing level.

See how this object fits into Sales Audit

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: SA_TOTAL

Field Definitions(5)

Rules & Considerations(26)

constraint

validation

Sample Load Data(4)

_scenario	DAYRPK	STORERPK	TOTAL_IDR	TOTAL_SEQ_NORPK	STORE_DAY_SEQ_NOR	STATUS	REF_NO1	REF_NO2	REF_NO3	ERROR_IND	DISPLAY_ORDER	BAL_GROUP_SEQ_NO
Example values from field definitions	1	1	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	1
default	3	1003	ALT-SA_TOT	4	4	D	SA Total-002-ALT	SA Total-002-ALT	SA Total-002-ALT	S	SA Tot	4
default	5	1005	EDGE-SA_TO	6	6	values	SA Total-003-EDGE	SA Total-003-EDGE	SA Total-003-EDGE	S	SA Tot	6

Example values from field definitions

DAYRPK: 1
STORERPK: 1
TOTAL_IDR: SAMPLE
TOTAL_SEQ_NORPK: 1
STORE_DAY_SEQ_NOR: 1
STATUS: SAMPLE
REF_NO1: SAMPLE
REF_NO2: SAMPLE
REF_NO3: SAMPLE
ERROR_IND: S
DISPLAY_ORDER: SAMPLE
BAL_GROUP_SEQ_NO: 1

default

DAYRPK: 3
STORERPK: 1003
TOTAL_IDR: ALT-SA_TOT
TOTAL_SEQ_NORPK: 4
STORE_DAY_SEQ_NOR: 4
STATUS: D
REF_NO1: SA Total-002-ALT
REF_NO2: SA Total-002-ALT
REF_NO3: SA Total-002-ALT
ERROR_IND: S
DISPLAY_ORDER: SA Tot
BAL_GROUP_SEQ_NO: 4

default

DAYRPK: 5
STORERPK: 1005
TOTAL_IDR: EDGE-SA_TO
TOTAL_SEQ_NORPK: 6
STORE_DAY_SEQ_NOR: 6
STATUS: values
REF_NO1: SA Total-003-EDGE
REF_NO2: SA Total-003-EDGE
REF_NO3: SA Total-003-EDGE
ERROR_IND: S
DISPLAY_ORDER: SA Tot
BAL_GROUP_SEQ_NO: 6

Rule Validation Summary

Source Rule Count: 37
Governed Rule Count: 26