ReSA Transaction Tax Rev

In Scope

Technical: SA_TRAN_TAX_REV | ID: OR-RSA-SA_TRAN_TAX_REV-RESA_TRANSACTION_TAX_REV

Stores all revisions to taxes associated with a transaction.

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_TRAN_TAX_REV

Field Definitions(5)

Rules & Considerations(29)

constraint

validation

Sample Load Data(4)

_scenario	DAYRPK	STORERPK	TAX_CODER	TAX_SEQ_NORPK	TRAN_SEQ_NORPK	REV_NO	TAX_AMT	REF_NO17	REF_NO18	REF_NO19	REF_NO20	ERROR_IND
Example values from field definitions	1	1	SAMPLE	1	1	1	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S
default	3	1003	ALT-SA	4	4	4	12.5000	SA Tran Tax Rev-002-ALT	SA Tran Tax Rev-002-ALT	SA Tran Tax Rev-002-ALT	SA Tran Tax Rev-002-ALT	S
default	5	1005	EDGE-S	6	6	6	14.0000	SA Tran Tax Rev-003-EDGE	SA Tran Tax Rev-003-EDGE	SA Tran Tax Rev-003-EDGE	SA Tran Tax Rev-003-EDGE	S

Example values from field definitions

DAYRPK: 1
STORERPK: 1
TAX_CODER: SAMPLE
TAX_SEQ_NORPK: 1
TRAN_SEQ_NORPK: 1
REV_NO: 1
TAX_AMT: 1.0000
REF_NO17: SAMPLE
REF_NO18: SAMPLE
REF_NO19: SAMPLE
REF_NO20: SAMPLE
ERROR_IND: S

default

DAYRPK: 3
STORERPK: 1003
TAX_CODER: ALT-SA
TAX_SEQ_NORPK: 4
TRAN_SEQ_NORPK: 4
REV_NO: 4
TAX_AMT: 12.5000
REF_NO17: SA Tran Tax Rev-002-ALT
REF_NO18: SA Tran Tax Rev-002-ALT
REF_NO19: SA Tran Tax Rev-002-ALT
REF_NO20: SA Tran Tax Rev-002-ALT
ERROR_IND: S

default

DAYRPK: 5
STORERPK: 1005
TAX_CODER: EDGE-S
TAX_SEQ_NORPK: 6
TRAN_SEQ_NORPK: 6
REV_NO: 6
TAX_AMT: 14.0000
REF_NO17: SA Tran Tax Rev-003-EDGE
REF_NO18: SA Tran Tax Rev-003-EDGE
REF_NO19: SA Tran Tax Rev-003-EDGE
REF_NO20: SA Tran Tax Rev-003-EDGE
ERROR_IND: S

Rule Validation Summary

Source Rule Count: 35
Governed Rule Count: 29