ReSA Transaction Item Rev History

In Scope

Technical: SA_TRAN_ITEM_REV_HIST | ID: OR-RSA-SA_TRAN_ITEM_REV_HIST-RESA_TRANSACTION_ITEM_REV_HISTORY

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

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_HIST

Field Definitions(5)

Rules & Considerations(76)

Sample Load Data(4)

_scenario	DAYR	STORER	REV_NOR	ITEM_SEQ_NOR	TRAN_SEQ_NOR	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	HIST_WRITTEN_DATE	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	2026-01-01	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 Hist-002	SA Tran	1103	SA Tran Item Rev Hist-002-ALT	SA Tran Item Rev Hist-002-ALT	SA Tran Item Rev Hist-002-ALT	SA Tran Item Rev Hist-002-ALT	S	ALT-SA_TRA	SA Tran Item Rev Hist-002	1113	S	SA Tra	9003	ALT-SA_TRAN-002	12.5000	1003	R	SA Tran Item Rev Hist-002	SA Tra	PENDIN	SA Tran It	SA T	12.5000	ALT-SA_TRAN-002	4	SA Tran Item Rev Hist-002	12.5000	SA T	3	SA Tran Item Rev Hist-002-ALT	S	1003	SA Tran Item Rev Hist-002	S	S	2026-01-03	2026-01-03	3	S	SA Tra	12.5000	12.5000	SA Tran Item Rev Hist-002-ALT	12.5000	2026-01-03	SA Tran It	ALT-SA	SA	12.5000	N	12.5000	4	12.5000	P	SA Tra	12.5000	2026-01-03	12.5000
default	5	1005	6	6	6	14.0000	1005	SA Tran Item Rev Hist-003	SA Tran	1105	SA Tran Item Rev Hist-003-EDGE	SA Tran Item Rev Hist-003-EDGE	SA Tran Item Rev Hist-003-EDGE	SA Tran Item Rev Hist-003-EDGE	S	EDGE-SA_TR	SA Tran Item Rev Hist-003	1115	S	SA Tra	9005	EDGE-SA_TRAN-003	14.0000	1005	R	SA Tran Item Rev Hist-003	SA Tra	ACTIVE	SA Tran It	SA T	14.0000	EDGE-SA_TRAN-003	6	SA Tran Item Rev Hist-003	14.0000	SA T	5	SA Tran Item Rev Hist-003-EDGE	S	1005	SA Tran Item Rev Hist-003	S	S	2026-01-05	2026-01-05	5	S	SA Tra	14.0000	14.0000	SA Tran Item Rev Hist-003-EDGE	14.0000	2026-01-05	SA Tran It	EDGE-S	SA	14.0000	N	14.0000	6	14.0000	A	SA Tra	14.0000	2026-01-05	14.0000

Example values from field definitions

DAYR: 1
STORER: 1
REV_NOR: 1
ITEM_SEQ_NOR: 1
TRAN_SEQ_NOR: 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
HIST_WRITTEN_DATE: 2026-01-01
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

DAYR: 3
STORER: 1003
REV_NOR: 4
ITEM_SEQ_NOR: 4
TRAN_SEQ_NOR: 4
QTY: 12.5000
DEPT: 1003
ITEM: SA Tran Item Rev Hist-002
PUMP: SA Tran
CLASS: 1103
REF_NO5: SA Tran Item Rev Hist-002-ALT
REF_NO6: SA Tran Item Rev Hist-002-ALT
REF_NO7: SA Tran Item Rev Hist-002-ALT
REF_NO8: SA Tran Item Rev Hist-002-ALT
TAX_IND: S
MEDIA_ID: ALT-SA_TRA
REF_ITEM: SA Tran Item Rev Hist-002
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 Hist-002
WASTE_TYPE: SA Tra
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 Hist-002
STANDARD_QTY: 12.5000
STANDARD_UOM: SA T
UOM_QUANTITY: 3
CUST_ORDER_NO: SA Tran Item Rev Hist-002-ALT
DROP_SHIP_IND: S
POSTING_STORE: 1003
NON_MERCH_ITEM: SA Tran Item Rev Hist-002
NO_INV_RET_IND: S
CATCHWEIGHT_IND: S
CUST_ORDER_DATE: 2026-01-03
EXPIRATION_DATE: 2026-01-03
FULFILLMENT_LOC: 3
ITEM_SWIPED_IND: S
OVERRIDE_REASON: SA Tra
TOTAL_IGTAX_AMT: 12.5000
CONSIGNMENT_RATE: 12.5000
FULFILL_ORDER_NO: SA Tran Item Rev Hist-002-ALT
ORIG_UNIT_RETAIL: 12.5000
HIST_WRITTEN_DATE: 2026-01-03
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: SA Tra
STANDARD_ORIG_UNIT_RETAIL: 12.5000
CONSIGNMENT_STAGED_DATETIME: 2026-01-03
ADJUSTED_CONSIGNMENT_UNIT_COST: 12.5000

default

DAYR: 5
STORER: 1005
REV_NOR: 6
ITEM_SEQ_NOR: 6
TRAN_SEQ_NOR: 6
QTY: 14.0000
DEPT: 1005
ITEM: SA Tran Item Rev Hist-003
PUMP: SA Tran
CLASS: 1105
REF_NO5: SA Tran Item Rev Hist-003-EDGE
REF_NO6: SA Tran Item Rev Hist-003-EDGE
REF_NO7: SA Tran Item Rev Hist-003-EDGE
REF_NO8: SA Tran Item Rev Hist-003-EDGE
TAX_IND: S
MEDIA_ID: EDGE-SA_TR
REF_ITEM: SA Tran Item Rev Hist-003
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 Hist-003
WASTE_TYPE: SA Tra
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 Hist-003
STANDARD_QTY: 14.0000
STANDARD_UOM: SA T
UOM_QUANTITY: 5
CUST_ORDER_NO: SA Tran Item Rev Hist-003-EDGE
DROP_SHIP_IND: S
POSTING_STORE: 1005
NON_MERCH_ITEM: SA Tran Item Rev Hist-003
NO_INV_RET_IND: S
CATCHWEIGHT_IND: S
CUST_ORDER_DATE: 2026-01-05
EXPIRATION_DATE: 2026-01-05
FULFILLMENT_LOC: 5
ITEM_SWIPED_IND: S
OVERRIDE_REASON: SA Tra
TOTAL_IGTAX_AMT: 14.0000
CONSIGNMENT_RATE: 14.0000
FULFILL_ORDER_NO: SA Tran Item Rev Hist-003-EDGE
ORIG_UNIT_RETAIL: 14.0000
HIST_WRITTEN_DATE: 2026-01-05
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: SA Tra
STANDARD_ORIG_UNIT_RETAIL: 14.0000
CONSIGNMENT_STAGED_DATETIME: 2026-01-05
ADJUSTED_CONSIGNMENT_UNIT_COST: 14.0000

Rule Validation Summary

Source Rule Count: 114
Governed Rule Count: 76

All objects