Resa Related Reference Data

In Scope

Technical: SA_GL_REF_DATA | ID: OR-RSA-SA_GL_REF_DATA-RESA_GL_REFERENCE_DATA

Stores the ReSA related reference data.

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_GL_REF_DATA

Field Definitions(5)

Rules & Considerations(24)

validation

constraint

Sample Load Data(4)

Example values from field definitions

DAYR
1
STORER
1
ACCT_DATER
2026-01-01
PROCESSED_DATER
2026-01-01
STORE_DAY_SEQ_NOR
1
ID
1
PERIOD
SAMPLE
ATTRIB1
SAMPLE
ATTRIB2
SAMPLE
TOTAL_ID
SAMPLE
UPDATE_ID
SAMPLE
TOTAL_VALUE
1.0000
CURRENCY_CODE
SAM
SET_OF_BOOKS_ID
1
REFERENCE_TRACE_ID
SAMPLE

default

DAYR
3
STORER
1003
ACCT_DATER
2026-01-03
PROCESSED_DATER
2026-01-03
STORE_DAY_SEQ_NOR
4
ID
3
PERIOD
SA GL Ref Data-
ATTRIB1
SA GL Ref Data-002-ALT
ATTRIB2
SA GL Ref Data-002-ALT
TOTAL_ID
ALT-SA_GL-
UPDATE_ID
MDM_USER
TOTAL_VALUE
12.5000
CURRENCY_CODE
ALT
SET_OF_BOOKS_ID
1000000003
REFERENCE_TRACE_ID
ALT-SA_GL-002

default

DAYR
5
STORER
1005
ACCT_DATER
2026-01-05
PROCESSED_DATER
2026-01-05
STORE_DAY_SEQ_NOR
6
ID
5
PERIOD
SA GL Ref Data-
ATTRIB1
SA GL Ref Data-003-EDGE
ATTRIB2
SA GL Ref Data-003-EDGE
TOTAL_ID
EDGE-SA_GL
UPDATE_ID
BATCH_USER
TOTAL_VALUE
14.0000
CURRENCY_CODE
EDG
SET_OF_BOOKS_ID
1000000005
REFERENCE_TRACE_ID
EDGE-SA_GL-003

Rule Validation Summary

Source Rule Count
48
Governed Rule Count
24