ReSA Error Worksheet

In Scope

Technical: SA_ERROR_WKSHT | ID: OR-RSA-SA_ERROR_WKSHT-RESA_ERROR_WORKSHEET

Stores errors generated by the auditing process for audit rules that have not been approved yet.

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_WKSHT

Field Definitions(5)

Rules & Considerations(30)

constraint

validation

Sample Load Data(4)

Example values from field definitions

DAYRPK
1
STORERPK
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_SEQ_NO
1
TOTAL_SEQ_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
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 Wksht-002-ALT
ORIG_VALUE
SA Error Wksht-002-ALT
KEY_VALUE_1
3
KEY_VALUE_2
3
KEY_VALUE_3
3
TRAN_SEQ_NO
4
TOTAL_SEQ_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
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 Wksht-003-EDGE
ORIG_VALUE
SA Error Wksht-003-EDGE
KEY_VALUE_1
5
KEY_VALUE_2
5
KEY_VALUE_3
5
TRAN_SEQ_NO
6
TOTAL_SEQ_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
40
Governed Rule Count
30