ReSA Transaction Item Rev

In Scope

Technical: SA_TRAN_ITEM_REV | ID: OR-RSA-SA_TRAN_ITEM_REV-RESA_TRANSACTION_ITEM_REV

This table will hold all revisions to the details for each item contained in 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_ITEM_REV

Field Definitions(5)

Rules & Considerations(84)

Sample Load Data(4)

_scenario	DAYRPK	STORERPK	REV_NORPK	ITEM_SEQ_NORPK	TRAN_SEQ_NORPK	QTY	DEPT	ITEM	PUMP	CLASS	REF_NO5	REF_NO6	REF_NO7	REF_NO8	TAX_IND	MEDIA_ID	REF_ITEM	SUBCLASS	ERROR_IND	ITEM_TYPE	RETURN_WH	UNIQUE_ID	WASTE_PCT	ORIG_STORE	SALES_TYPE	VOUCHER_NO	WASTE_TYPE	ITEM_STATUS	SALESPERSON	SELLING_UOM	UNIT_RETAIL	INVENTORY_ID	ORIG_TRAN_NO	SELLING_ITEM	STANDARD_QTY	STANDARD_UOM	UOM_QUANTITY	CUST_ORDER_NO	DROP_SHIP_IND	POSTING_STORE	NON_MERCH_ITEM	NO_INV_RET_IND	CATCHWEIGHT_IND	CUST_ORDER_DATE	EXPIRATION_DATE	FULFILLMENT_LOC	ITEM_SWIPED_IND	OVERRIDE_REASON	TOTAL_IGTAX_AMT	CONSIGNMENT_RATE	FULFILL_ORDER_NO	ORIG_UNIT_RETAIL	RETURN_DISPOSITION	RETURN_REASON_CODE	FULFILLMENT_LOC_TYPE	STANDARD_UNIT_RETAIL	UNIT_RETAIL_VAT_INCL	CONSIGNMENT_UNIT_COST	CUSTOMER_ORDER_LINE_NO	ADJUSTED_CONSIGNMENT_RATE	CONSIGNMENT_REVIEW_STATUS	INVENTORY_IDENTIFIER_TYPE	STANDARD_ORIG_UNIT_RETAIL	CONSIGNMENT_STAGED_DATETIME	ADJUSTED_CONSIGNMENT_UNIT_COST
Example values from field definitions	1	1	1	1	1	1.0000	1	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	1	S	SAMPLE	1	SAMPLE	1.0000	1	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMP	1.0000	SAMPLE	1	SAMPLE	1.0000	SAMP	1	SAMPLE	S	1	SAMPLE	S	S	2026-01-01	2026-01-01	1	S	SAMPLE	1.0000	1.0000	SAMPLE	1.0000	SAMPLE	SAMPLE	SA	1.0000	S	1.0000	1	1.0000	S	SAMPLE	1.0000	2026-01-01	1.0000
default	3	1003	4	4	4	12.5000	1003	SA Tran Item Rev-002-ALT	SA Tran	1103	SA Tran Item Rev-002-ALT	SA Tran Item Rev-002-ALT	SA Tran Item Rev-002-ALT	SA Tran Item Rev-002-ALT	S	ALT-SA_TRA	SA Tran Item Rev-002-ALT	1113	S	SA Tra	9003	ALT-SA_TRAN-002	12.5000	1003	R	SA Tran Item Rev-002-ALT	SL	PENDIN	SA Tran It	SA T	12.5000	ALT-SA_TRAN-002	4	SA Tran Item Rev-002-ALT	12.5000	SA T	3	SA Tran Item Rev-002-ALT	S	1003	SA Tran Item Rev-002-ALT	S	N	2026-01-03	2026-01-03	3	k	SA Tra	12.5000	12.5000	SA Tran Item Rev-002-ALT	12.5000	SA Tran It	ALT-SA	SA	12.5000	N	12.5000	4	12.5000	P	L	12.5000	2026-01-03	12.5000
default	5	1005	6	6	6	14.0000	1005	SA Tran Item Rev-003-EDGE	SA Tran	1105	SA Tran Item Rev-003-EDGE	SA Tran Item Rev-003-EDGE	SA Tran Item Rev-003-EDGE	SA Tran Item Rev-003-EDGE	S	EDGE-SA_TR	SA Tran Item Rev-003-EDGE	1115	S	SA Tra	9005	EDGE-SA_TRAN-003	14.0000	1005	R	SA Tran Item Rev-003-EDGE	SL	ACTIVE	SA Tran It	SA T	14.0000	EDGE-SA_TRAN-003	6	SA Tran Item Rev-003-EDGE	14.0000	SA T	5	SA Tran Item Rev-003-EDGE	S	1005	SA Tran Item Rev-003-EDGE	S	Y	2026-01-05	2026-01-05	5	k	SA Tra	14.0000	14.0000	SA Tran Item Rev-003-EDGE	14.0000	SA Tran It	EDGE-S	SA	14.0000	N	14.0000	6	14.0000	A	E	14.0000	2026-01-05	14.0000

Example values from field definitions

DAYRPK: 1
STORERPK: 1
REV_NORPK: 1
ITEM_SEQ_NORPK: 1
TRAN_SEQ_NORPK: 1
QTY: 1.0000
DEPT: 1
ITEM: SAMPLE
PUMP: SAMPLE
CLASS: 1
REF_NO5: SAMPLE
REF_NO6: SAMPLE
REF_NO7: SAMPLE
REF_NO8: SAMPLE
TAX_IND: S
MEDIA_ID: SAMPLE
REF_ITEM: SAMPLE
SUBCLASS: 1
ERROR_IND: S
ITEM_TYPE: SAMPLE
RETURN_WH: 1
UNIQUE_ID: SAMPLE
WASTE_PCT: 1.0000
ORIG_STORE: 1
SALES_TYPE: S
VOUCHER_NO: SAMPLE
WASTE_TYPE: SAMPLE
ITEM_STATUS: SAMPLE
SALESPERSON: SAMPLE
SELLING_UOM: SAMP
UNIT_RETAIL: 1.0000
INVENTORY_ID: SAMPLE
ORIG_TRAN_NO: 1
SELLING_ITEM: SAMPLE
STANDARD_QTY: 1.0000
STANDARD_UOM: SAMP
UOM_QUANTITY: 1
CUST_ORDER_NO: SAMPLE
DROP_SHIP_IND: S
POSTING_STORE: 1
NON_MERCH_ITEM: SAMPLE
NO_INV_RET_IND: S
CATCHWEIGHT_IND: S
CUST_ORDER_DATE: 2026-01-01
EXPIRATION_DATE: 2026-01-01
FULFILLMENT_LOC: 1
ITEM_SWIPED_IND: S
OVERRIDE_REASON: SAMPLE
TOTAL_IGTAX_AMT: 1.0000
CONSIGNMENT_RATE: 1.0000
FULFILL_ORDER_NO: SAMPLE
ORIG_UNIT_RETAIL: 1.0000
RETURN_DISPOSITION: SAMPLE
RETURN_REASON_CODE: SAMPLE
FULFILLMENT_LOC_TYPE: SA
STANDARD_UNIT_RETAIL: 1.0000
UNIT_RETAIL_VAT_INCL: S
CONSIGNMENT_UNIT_COST: 1.0000
CUSTOMER_ORDER_LINE_NO: 1
ADJUSTED_CONSIGNMENT_RATE: 1.0000
CONSIGNMENT_REVIEW_STATUS: S
INVENTORY_IDENTIFIER_TYPE: SAMPLE
STANDARD_ORIG_UNIT_RETAIL: 1.0000
CONSIGNMENT_STAGED_DATETIME: 2026-01-01
ADJUSTED_CONSIGNMENT_UNIT_COST: 1.0000

default

DAYRPK: 3
STORERPK: 1003
REV_NORPK: 4
ITEM_SEQ_NORPK: 4
TRAN_SEQ_NORPK: 4
QTY: 12.5000
DEPT: 1003
ITEM: SA Tran Item Rev-002-ALT
PUMP: SA Tran
CLASS: 1103
REF_NO5: SA Tran Item Rev-002-ALT
REF_NO6: SA Tran Item Rev-002-ALT
REF_NO7: SA Tran Item Rev-002-ALT
REF_NO8: SA Tran Item Rev-002-ALT
TAX_IND: S
MEDIA_ID: ALT-SA_TRA
REF_ITEM: SA Tran Item Rev-002-ALT
SUBCLASS: 1113
ERROR_IND: S
ITEM_TYPE: SA Tra
RETURN_WH: 9003
UNIQUE_ID: ALT-SA_TRAN-002
WASTE_PCT: 12.5000
ORIG_STORE: 1003
SALES_TYPE: R
VOUCHER_NO: SA Tran Item Rev-002-ALT
WASTE_TYPE: SL
ITEM_STATUS: PENDIN
SALESPERSON: SA Tran It
SELLING_UOM: SA T
UNIT_RETAIL: 12.5000
INVENTORY_ID: ALT-SA_TRAN-002
ORIG_TRAN_NO: 4
SELLING_ITEM: SA Tran Item Rev-002-ALT
STANDARD_QTY: 12.5000
STANDARD_UOM: SA T
UOM_QUANTITY: 3
CUST_ORDER_NO: SA Tran Item Rev-002-ALT
DROP_SHIP_IND: S
POSTING_STORE: 1003
NON_MERCH_ITEM: SA Tran Item Rev-002-ALT
NO_INV_RET_IND: S
CATCHWEIGHT_IND: N
CUST_ORDER_DATE: 2026-01-03
EXPIRATION_DATE: 2026-01-03
FULFILLMENT_LOC: 3
ITEM_SWIPED_IND: k
OVERRIDE_REASON: SA Tra
TOTAL_IGTAX_AMT: 12.5000
CONSIGNMENT_RATE: 12.5000
FULFILL_ORDER_NO: SA Tran Item Rev-002-ALT
ORIG_UNIT_RETAIL: 12.5000
RETURN_DISPOSITION: SA Tran It
RETURN_REASON_CODE: ALT-SA
FULFILLMENT_LOC_TYPE: SA
STANDARD_UNIT_RETAIL: 12.5000
UNIT_RETAIL_VAT_INCL: N
CONSIGNMENT_UNIT_COST: 12.5000
CUSTOMER_ORDER_LINE_NO: 4
ADJUSTED_CONSIGNMENT_RATE: 12.5000
CONSIGNMENT_REVIEW_STATUS: P
INVENTORY_IDENTIFIER_TYPE: L
STANDARD_ORIG_UNIT_RETAIL: 12.5000
CONSIGNMENT_STAGED_DATETIME: 2026-01-03
ADJUSTED_CONSIGNMENT_UNIT_COST: 12.5000

default

DAYRPK: 5
STORERPK: 1005
REV_NORPK: 6
ITEM_SEQ_NORPK: 6
TRAN_SEQ_NORPK: 6
QTY: 14.0000
DEPT: 1005
ITEM: SA Tran Item Rev-003-EDGE
PUMP: SA Tran
CLASS: 1105
REF_NO5: SA Tran Item Rev-003-EDGE
REF_NO6: SA Tran Item Rev-003-EDGE
REF_NO7: SA Tran Item Rev-003-EDGE
REF_NO8: SA Tran Item Rev-003-EDGE
TAX_IND: S
MEDIA_ID: EDGE-SA_TR
REF_ITEM: SA Tran Item Rev-003-EDGE
SUBCLASS: 1115
ERROR_IND: S
ITEM_TYPE: SA Tra
RETURN_WH: 9005
UNIQUE_ID: EDGE-SA_TRAN-003
WASTE_PCT: 14.0000
ORIG_STORE: 1005
SALES_TYPE: R
VOUCHER_NO: SA Tran Item Rev-003-EDGE
WASTE_TYPE: SL
ITEM_STATUS: ACTIVE
SALESPERSON: SA Tran It
SELLING_UOM: SA T
UNIT_RETAIL: 14.0000
INVENTORY_ID: EDGE-SA_TRAN-003
ORIG_TRAN_NO: 6
SELLING_ITEM: SA Tran Item Rev-003-EDGE
STANDARD_QTY: 14.0000
STANDARD_UOM: SA T
UOM_QUANTITY: 5
CUST_ORDER_NO: SA Tran Item Rev-003-EDGE
DROP_SHIP_IND: S
POSTING_STORE: 1005
NON_MERCH_ITEM: SA Tran Item Rev-003-EDGE
NO_INV_RET_IND: S
CATCHWEIGHT_IND: Y
CUST_ORDER_DATE: 2026-01-05
EXPIRATION_DATE: 2026-01-05
FULFILLMENT_LOC: 5
ITEM_SWIPED_IND: k
OVERRIDE_REASON: SA Tra
TOTAL_IGTAX_AMT: 14.0000
CONSIGNMENT_RATE: 14.0000
FULFILL_ORDER_NO: SA Tran Item Rev-003-EDGE
ORIG_UNIT_RETAIL: 14.0000
RETURN_DISPOSITION: SA Tran It
RETURN_REASON_CODE: EDGE-S
FULFILLMENT_LOC_TYPE: SA
STANDARD_UNIT_RETAIL: 14.0000
UNIT_RETAIL_VAT_INCL: N
CONSIGNMENT_UNIT_COST: 14.0000
CUSTOMER_ORDER_LINE_NO: 6
ADJUSTED_CONSIGNMENT_RATE: 14.0000
CONSIGNMENT_REVIEW_STATUS: A
INVENTORY_IDENTIFIER_TYPE: E
STANDARD_ORIG_UNIT_RETAIL: 14.0000
CONSIGNMENT_STAGED_DATETIME: 2026-01-05
ADJUSTED_CONSIGNMENT_UNIT_COST: 14.0000

Rule Validation Summary

Source Rule Count: 130
Governed Rule Count: 84

All objects