ReSA Error Rev

In Scope

Technical: SA_ERROR_REV | ID: OR-RSA-SA_ERROR_REV-RESA_ERROR_REV

Stores a record for every modification of an error generated during the automated audit process.

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_ERROR_REV

Field Definitions(5)

Rules & Considerations(46)

constraint

validation

Sample Load Data(4)

Example values from field definitions

DAYRPK
1
STORERPK
1
REV_NORPK
1
ERROR_SEQ_NORPK
1
STORE_DAY_SEQ_NOR
1
REC_TYPE
SAMPLE
UPDATE_ID
SAMPLE
ERROR_CODE
SAMPLE
ORIG_CC_NO
SAMPLE
ORIG_VALUE
SAMPLE
KEY_VALUE_1
1
KEY_VALUE_2
1
KEY_VALUE_3
1
TRAN_REV_NO
1
TRAN_SEQ_NO
1
TOTAL_SEQ_NO
1
VALUE_REV_NO
1
HQ_OVERRIDE_IND
S
UPDATE_DATETIME
2026-01-01
BAL_GROUP_SEQ_NO
1
STORE_OVERRIDE_IND
S

default

DAYRPK
3
STORERPK
1003
REV_NORPK
4
ERROR_SEQ_NORPK
4
STORE_DAY_SEQ_NOR
4
REC_TYPE
SA Err
UPDATE_ID
MDM_USER
ERROR_CODE
ALT-SA_ERROR-002
ORIG_CC_NO
SA Error Rev-002-ALT
ORIG_VALUE
SA Error Rev-002-ALT
KEY_VALUE_1
3
KEY_VALUE_2
3
KEY_VALUE_3
3
TRAN_REV_NO
4
TRAN_SEQ_NO
4
TOTAL_SEQ_NO
4
VALUE_REV_NO
4
HQ_OVERRIDE_IND
S
UPDATE_DATETIME
2026-01-03
BAL_GROUP_SEQ_NO
4
STORE_OVERRIDE_IND
S

default

DAYRPK
5
STORERPK
1005
REV_NORPK
6
ERROR_SEQ_NORPK
6
STORE_DAY_SEQ_NOR
6
REC_TYPE
SA Err
UPDATE_ID
BATCH_USER
ERROR_CODE
EDGE-SA_ERROR-003
ORIG_CC_NO
SA Error Rev-003-EDGE
ORIG_VALUE
SA Error Rev-003-EDGE
KEY_VALUE_1
5
KEY_VALUE_2
5
KEY_VALUE_3
5
TRAN_REV_NO
6
TRAN_SEQ_NO
6
TOTAL_SEQ_NO
6
VALUE_REV_NO
6
HQ_OVERRIDE_IND
S
UPDATE_DATETIME
2026-01-05
BAL_GROUP_SEQ_NO
6
STORE_OVERRIDE_IND
S

Rule Validation Summary

Source Rule Count
58
Governed Rule Count
46