SA Tran Item Hist

In Scope

Technical: SA_TRAN_ITEM_HIST | ID: OR-MFCS-SA_TRAN_ITEM_HIST

Stores historical records for SA tran item hist in Oracle Retail Merchandising, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and traceability of sales…

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_HIST

Field Definitions(65)

Rules & Considerations(150)

Sample Load Data(4)

_scenario	DAYR	STORER	TAX_INDR	ERROR_INDR	ITEM_TYPER	ITEM_SEQ_NOR	ITEM_STATUSR	TRAN_SEQ_NOR	UOM_QUANTITYR	DROP_SHIP_INDR	ITEM_SWIPED_INDR	HIST_WRITTEN_DATER	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	SA Tran Item Hist-001	SA Tran Item Hist-001	SA Tran Item Hist-001	0002	ACTIVE	2	11.0000	SA Tran Item Hist-001	SA Tran Item Hist-001	2026-01-01	N	11.0000	1001	SA Tran Item Hist-001	SA Tran Item Hist-001	1101	SA Tran Item Hist-001	SA Tran Item Hist-001	SA Tran Item Hist-001	SA Tran Item Hist-001	1000000001	SA Tran Item Hist-001	1111	9001	STD-SA_TRAN-001	11.0000	1001	R	SA Tran Item Hist-001	SA Tran Item Hist-001	SA Tran Item Hist-001	SA Tran Item Hist-001	11.0000	STD-SA_TRAN-001	2	SA Tran Item Hist-001	11.0000	SA Tran Item Hist-001	SA Tran Item Hist-001	1001	SA Tran Item Hist-001	SA Tran Item Hist-001	SA Tran Item Hist-001	2026-01-01	2026-01-01	1	SA Tran Item Hist-001	11.0000	11.0000	SA Tran Item Hist-001	11.0000	SA Tran Item Hist-001	STD-SA_TRAN-001	SA Tran Item Hist-001	11.0000	11.0000	000002	11.0000	ACTIVE	SA Tran Item Hist-001	11.0000	2026-01-01	11.0000

default

DAYR: 001
STORER: 1001
TAX_INDR: SA Tran Item Hist-001
ERROR_INDR: SA Tran Item Hist-001
ITEM_TYPER: SA Tran Item Hist-001
ITEM_SEQ_NOR: 0002
ITEM_STATUSR: ACTIVE
TRAN_SEQ_NOR: 2
UOM_QUANTITYR: 11.0000
DROP_SHIP_INDR: SA Tran Item Hist-001
ITEM_SWIPED_INDR: SA Tran Item Hist-001
HIST_WRITTEN_DATER: 2026-01-01
UNIT_RETAIL_VAT_INCLR: N
QTY: 11.0000
DEPT: 1001
ITEM: SA Tran Item Hist-001
PUMP: SA Tran Item Hist-001
CLASS: 1101
REF_NO5: SA Tran Item Hist-001
REF_NO6: SA Tran Item Hist-001
REF_NO7: SA Tran Item Hist-001
REF_NO8: SA Tran Item Hist-001
MEDIA_ID: 1000000001
REF_ITEM: SA Tran Item Hist-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 Hist-001
WASTE_TYPE: SA Tran Item Hist-001
SALESPERSON: SA Tran Item Hist-001
SELLING_UOM: SA Tran Item Hist-001
UNIT_RETAIL: 11.0000
INVENTORY_ID: STD-SA_TRAN-001
ORIG_TRAN_NO: 2
SELLING_ITEM: SA Tran Item Hist-001
STANDARD_QTY: 11.0000
STANDARD_UOM: SA Tran Item Hist-001
CUST_ORDER_NO: SA Tran Item Hist-001
POSTING_STORE: 1001
NON_MERCH_ITEM: SA Tran Item Hist-001
NO_INV_RET_IND: SA Tran Item Hist-001
CATCHWEIGHT_IND: SA Tran Item Hist-001
CUST_ORDER_DATE: 2026-01-01
EXPIRATION_DATE: 2026-01-01
FULFILLMENT_LOC: 1
OVERRIDE_REASON: SA Tran Item Hist-001
TOTAL_IGTAX_AMT: 11.0000
CONSIGNMENT_RATE: 11.0000
FULFILL_ORDER_NO: SA Tran Item Hist-001
ORIG_UNIT_RETAIL: 11.0000
RETURN_DISPOSITION: SA Tran Item Hist-001
RETURN_REASON_CODE: STD-SA_TRAN-001
FULFILLMENT_LOC_TYPE: SA Tran Item Hist-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: SA Tran Item Hist-001
STANDARD_ORIG_UNIT_RETAIL: 11.0000
CONSIGNMENT_STAGED_DATETIME: 2026-01-01
ADJUSTED_CONSIGNMENT_UNIT_COST: 11.0000

All objects