ReSA System Value

In Scope

Technical: SA_SYS_VALUE | ID: OR-RSA-SA_SYS_VALUE-RESA_SYSTEM_VALUE

Stores the ReSA calculated value for a given total_value_seq_no and value_rev_no.

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_SYS_VALUE

Field Definitions(5)

Rules & Considerations(22)

constraint

validation

Sample Load Data(4)

Example values from field definitions

DAYRPK
1
STORERPK
1
SYS_VALUER
1.0000
TOTAL_SEQ_NORPK
1
VALUE_REV_NORPK
1
UPDATE_ID
SAMPLE
TOTAL_REV_NO
1
CREATE_DATETIME
2026-01-01
UPDATE_DATETIME
2026-01-01

default

DAYRPK
3
STORERPK
1003
SYS_VALUER
12.5000
TOTAL_SEQ_NORPK
4
VALUE_REV_NORPK
4
UPDATE_ID
MDM_USER
TOTAL_REV_NO
4
CREATE_DATETIME
2026-01-03
UPDATE_DATETIME
2026-01-03

default

DAYRPK
5
STORERPK
1005
SYS_VALUER
14.0000
TOTAL_SEQ_NORPK
6
VALUE_REV_NORPK
6
UPDATE_ID
BATCH_USER
TOTAL_REV_NO
6
CREATE_DATETIME
2026-01-05
UPDATE_DATETIME
2026-01-05

Rule Validation Summary

Source Rule Count
44
Governed Rule Count
22