SA Tran Item Rev

In Scope

Technical: SA_TRAN_ITEM_REV | ID: OR-MFCS-SA_TRAN_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

Target Structure

Load Approach: Table
Target Objects: SA_TRAN_ITEM_REV

Field Definitions(65)

Rules & Considerations(159)

Sample Load Data(4)

_scenario	DAYR	STORER	REV_NOR	TAX_INDR	ERROR_INDR	ITEM_TYPER	ITEM_SEQ_NOR	ITEM_STATUSR	TRAN_SEQ_NORPK	UOM_QUANTITYR	DROP_SHIP_INDR	ITEM_SWIPED_INDR	UNIT_RETAIL_VAT_INCLR	QTY	DEPT	ITEM	PUMP	CLASS	REF_NO5	REF_NO6	REF_NO7	REF_NO8	MEDIA_ID	REF_ITEM	SUBCLASS	RETURN_WH	UNIQUE_ID	WASTE_PCT	ORIG_STORE	SALES_TYPE	VOUCHER_NO	WASTE_TYPE	SALESPERSON	SELLING_UOM	UNIT_RETAIL	INVENTORY_ID	ORIG_TRAN_NO	SELLING_ITEM	STANDARD_QTY	STANDARD_UOM	CUST_ORDER_NO	POSTING_STORE	NON_MERCH_ITEM	NO_INV_RET_IND	CATCHWEIGHT_IND	CUST_ORDER_DATE	EXPIRATION_DATE	FULFILLMENT_LOC	OVERRIDE_REASON	TOTAL_IGTAX_AMT	CONSIGNMENT_RATE	FULFILL_ORDER_NO	ORIG_UNIT_RETAIL	RETURN_DISPOSITION	RETURN_REASON_CODE	FULFILLMENT_LOC_TYPE	STANDARD_UNIT_RETAIL	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
default	001	1001	002	SA Tran Item Rev-001	SA Tran Item Rev-001	SA Tran Item Rev-001	0002	ACTIVE	2	1	SA Tran Item Rev-001	keyed	N	11.0000	1001	SA Tran Item Rev-001	SA Tran Item Rev-001	1101	SA Tran Item Rev-001	SA Tran Item Rev-001	SA Tran Item Rev-001	SA Tran Item Rev-001	STD-SA_TRAN-001	SA Tran Item Rev-001	1111	9001	STD-SA_TRAN-001	11.0000	1001	R	SA Tran Item Rev-001	SL	SA Tran Item Rev-001	SA Tran Item Rev-001	11.0000	STD-SA_TRAN-001	2	SA Tran Item Rev-001	11.0000	SA Tran Item Rev-001	SA Tran Item Rev-001	1001	SA Tran Item Rev-001	SA Tran Item Rev-001	Y	2026-01-01	2026-01-01	1	SA Tran Item Rev-001	11.0000	11.0000	SA Tran Item Rev-001	11.0000	SA Tran Item Rev-001	STD-SA_TRAN-001	SA Tran Item Rev-001	11.0000	11.0000	000002	11.0000	ACTIVE	IIDT	11.0000	2026-01-01	11.0000

default

DAYR: 001
STORER: 1001
REV_NOR: 002
TAX_INDR: SA Tran Item Rev-001
ERROR_INDR: SA Tran Item Rev-001
ITEM_TYPER: SA Tran Item Rev-001
ITEM_SEQ_NOR: 0002
ITEM_STATUSR: ACTIVE
TRAN_SEQ_NORPK: 2
UOM_QUANTITYR: 1
DROP_SHIP_INDR: SA Tran Item Rev-001
ITEM_SWIPED_INDR: keyed
UNIT_RETAIL_VAT_INCLR: N
QTY: 11.0000
DEPT: 1001
ITEM: SA Tran Item Rev-001
PUMP: SA Tran Item Rev-001
CLASS: 1101
REF_NO5: SA Tran Item Rev-001
REF_NO6: SA Tran Item Rev-001
REF_NO7: SA Tran Item Rev-001
REF_NO8: SA Tran Item Rev-001
MEDIA_ID: STD-SA_TRAN-001
REF_ITEM: SA Tran Item Rev-001
SUBCLASS: 1111
RETURN_WH: 9001
UNIQUE_ID: STD-SA_TRAN-001
WASTE_PCT: 11.0000
ORIG_STORE: 1001
SALES_TYPE: R
VOUCHER_NO: SA Tran Item Rev-001
WASTE_TYPE: SL
SALESPERSON: SA Tran Item Rev-001
SELLING_UOM: SA Tran Item Rev-001
UNIT_RETAIL: 11.0000
INVENTORY_ID: STD-SA_TRAN-001
ORIG_TRAN_NO: 2
SELLING_ITEM: SA Tran Item Rev-001
STANDARD_QTY: 11.0000
STANDARD_UOM: SA Tran Item Rev-001
CUST_ORDER_NO: SA Tran Item Rev-001
POSTING_STORE: 1001
NON_MERCH_ITEM: SA Tran Item Rev-001
NO_INV_RET_IND: SA Tran Item Rev-001
CATCHWEIGHT_IND: Y
CUST_ORDER_DATE: 2026-01-01
EXPIRATION_DATE: 2026-01-01
FULFILLMENT_LOC: 1
OVERRIDE_REASON: SA Tran Item Rev-001
TOTAL_IGTAX_AMT: 11.0000
CONSIGNMENT_RATE: 11.0000
FULFILL_ORDER_NO: SA Tran Item Rev-001
ORIG_UNIT_RETAIL: 11.0000
RETURN_DISPOSITION: SA Tran Item Rev-001
RETURN_REASON_CODE: STD-SA_TRAN-001
FULFILLMENT_LOC_TYPE: SA Tran Item Rev-001
STANDARD_UNIT_RETAIL: 11.0000
CONSIGNMENT_UNIT_COST: 11.0000
CUSTOMER_ORDER_LINE_NO: 000002
ADJUSTED_CONSIGNMENT_RATE: 11.0000
CONSIGNMENT_REVIEW_STATUS: ACTIVE
INVENTORY_IDENTIFIER_TYPE: IIDT
STANDARD_ORIG_UNIT_RETAIL: 11.0000
CONSIGNMENT_STAGED_DATETIME: 2026-01-01
ADJUSTED_CONSIGNMENT_UNIT_COST: 11.0000

All objects