Transaction Data History

In Scope

Technical: TRAN_DATA_HISTORY | ID: OR-FIN-TRAN_DATA_HISTORY-TRANSACTION_DATA_HISTORY

Historical inventory and stock-ledger transaction records by item, hierarchy, and location, preserving posted transaction detail for downstream finance reporting.

See how this object fits into Finance

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: TRAN_DATA_HISTORY

Field Definitions(5)

Rules & Considerations(44)

constraint

validation

Sample Load Data(4)

_scenario	DEPTR	CLASSR	SUBCLASSR	ITEM	UNITS	AV_COST	ADJ_CODE	LOCATION	LOC_TYPE	PACK_IND	PGM_NAME	REF_NO_1	REF_NO_2	VAT_RATE	GL_REF_NO	POST_DATE	TRAN_CODE	TRAN_DATE	IFTD_ROWID	SALES_TYPE	TOTAL_COST	POS_TRAN_ID	REF_PACK_NO	TOTAL_RETAIL	TRAN_DATA_ID	DEAL_LOCATION	DEAL_LOC_TYPE	DEAL_TOTAL_COST	NEW_UNIT_RETAIL	OLD_UNIT_RETAIL	RECORD_SYS_DATE	PROCESSING_VDATE	SALES_PROCESS_ID	DEAL_TOTAL_RETAIL	TOTAL_COST_EXCL_ELC	TRAN_DATA_TIMESTAMP
Example values from field definitions	1	1	1	SAMPLE	1.0000	1.0000	S	1	S	S	SAMPLE	SAMPLE	SAMPLE	1.0000000000	SAMPLE	2026-01-01	1	2026-01-01	SAMPLE	S	1.0000	1	SAMPLE	1.0000	1	1	S	1.0000	1.0000	1.0000	2026-01-01	2026-01-01	1	1.0000	1.0000	2026-01-01
default	1003	1103	1113	Tran Data History-002-ALT	12.5000	12.5000	C	3	W	T	Tran Data History Secondary	Tran Data History-002-ALT	Tran Data History-002-ALT	12.5000000000	Tran Data History-002-ALT	2026-01-03	3	2026-01-03	Tran Data History-	R	12.5000	1000000003	Tran Data History-002-ALT	12.5000	1000000003	3	T	12.5000	12.5000	12.5000	2026-01-03	2026-01-03	1000000003	12.5000	12.5000	2026-02-09
default	1005	1105	1115	Tran Data History-003-EDG	14.0000	14.0000	C	5	E	T	Tran Data History Core	Tran Data History-003-EDGE	Tran Data History-003-EDGE	14.0000000000	Tran Data History-003-EDG	2026-01-05	5	2026-01-05	Tran Data History-	C	14.0000	1000000005	Tran Data History-003-EDG	14.0000	1000000005	5	T	14.0000	14.0000	14.0000	2026-01-05	2026-01-05	1000000005	14.0000	14.0000	2026-03-12

Example values from field definitions

DEPTR: 1
CLASSR: 1
SUBCLASSR: 1
ITEM: SAMPLE
UNITS: 1.0000
AV_COST: 1.0000
ADJ_CODE: S
LOCATION: 1
LOC_TYPE: S
PACK_IND: S
PGM_NAME: SAMPLE
REF_NO_1: SAMPLE
REF_NO_2: SAMPLE
VAT_RATE: 1.0000000000
GL_REF_NO: SAMPLE
POST_DATE: 2026-01-01
TRAN_CODE: 1
TRAN_DATE: 2026-01-01
IFTD_ROWID: SAMPLE
SALES_TYPE: S
TOTAL_COST: 1.0000
POS_TRAN_ID: 1
REF_PACK_NO: SAMPLE
TOTAL_RETAIL: 1.0000
TRAN_DATA_ID: 1
DEAL_LOCATION: 1
DEAL_LOC_TYPE: S
DEAL_TOTAL_COST: 1.0000
NEW_UNIT_RETAIL: 1.0000
OLD_UNIT_RETAIL: 1.0000
RECORD_SYS_DATE: 2026-01-01
PROCESSING_VDATE: 2026-01-01
SALES_PROCESS_ID: 1
DEAL_TOTAL_RETAIL: 1.0000
TOTAL_COST_EXCL_ELC: 1.0000
TRAN_DATA_TIMESTAMP: 2026-01-01

default

DEPTR: 1003
CLASSR: 1103
SUBCLASSR: 1113
ITEM: Tran Data History-002-ALT
UNITS: 12.5000
AV_COST: 12.5000
ADJ_CODE: C
LOCATION: 3
LOC_TYPE: W
PACK_IND: T
PGM_NAME: Tran Data History Secondary
REF_NO_1: Tran Data History-002-ALT
REF_NO_2: Tran Data History-002-ALT
VAT_RATE: 12.5000000000
GL_REF_NO: Tran Data History-002-ALT
POST_DATE: 2026-01-03
TRAN_CODE: 3
TRAN_DATE: 2026-01-03
IFTD_ROWID: Tran Data History-
SALES_TYPE: R
TOTAL_COST: 12.5000
POS_TRAN_ID: 1000000003
REF_PACK_NO: Tran Data History-002-ALT
TOTAL_RETAIL: 12.5000
TRAN_DATA_ID: 1000000003
DEAL_LOCATION: 3
DEAL_LOC_TYPE: T
DEAL_TOTAL_COST: 12.5000
NEW_UNIT_RETAIL: 12.5000
OLD_UNIT_RETAIL: 12.5000
RECORD_SYS_DATE: 2026-01-03
PROCESSING_VDATE: 2026-01-03
SALES_PROCESS_ID: 1000000003
DEAL_TOTAL_RETAIL: 12.5000
TOTAL_COST_EXCL_ELC: 12.5000
TRAN_DATA_TIMESTAMP: 2026-02-09