Transaction Taxes

In Scope

Technical: SA_TRAN_TAX | ID: OR-RSA-SA_TRAN_TAX-RESA_TRANSACTION_TAX

This is a new table that contains all 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

Field Definitions(5)

Rules & Considerations(25)

constraint

validation

Sample Load Data(4)

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

Example values from field definitions

DAYRPK: 1
STORERPK: 1
TAX_CODER: SAMPLE
TAX_SEQ_NORPK: 1
TRAN_SEQ_NORPK: 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
TAX_AMT: 12.5000
REF_NO17: SA Tran Tax-002-ALT
REF_NO18: SA Tran Tax-002-ALT
REF_NO19: SA Tran Tax-002-ALT
REF_NO20: SA Tran Tax-002-ALT
ERROR_IND: S

default

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

Rule Validation Summary

Source Rule Count: 31
Governed Rule Count: 25