Transaction Data

In Scope

Technical: TRAN_DATA | ID: OR-FIN-TRAN_DATA-TRANSACTION_DATA

Stores the stock ledger financial transaction data that are generated throughout on-line day as well as from batch processes which affect the stock ledger. Each night, all transactions on the...

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

Field Definitions(5)

Rules & Considerations(47)

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	TIMESTAMP	TRAN_CODE	TRAN_DATE	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	SALES_PROCESS_ID	DEAL_TOTAL_RETAIL	TOTAL_COST_EXCL_ELC
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	S	1.0000	1	SAMPLE	1.0000	1	1	S	1.0000	1.0000	1.0000	2026-01-01	1	1.0000	1.0000
default	1003	1103	1113	Tran Data-002-ALT	12.5000	12.5000	C	3	W	T	Tran Data Secondary	Tran Data-002-ALT	Tran Data-002-ALT	12.5000000000	Tran Data-002-ALT	2026-02-09	3	2026-01-03	v	12.5000	1000000003	Tran Data-002-ALT	12.5000	1000000003	3	T	12.5000	12.5000	12.5000	2026-01-03	1000000003	12.5000	12.5000
default	1005	1105	1115	Tran Data-003-EDGE	14.0000	14.0000	C	5	E	T	Tran Data Core	Tran Data-003-EDGE	Tran Data-003-EDGE	14.0000000000	Tran Data-003-EDGE	2026-03-12	5	2026-01-05	v	14.0000	1000000005	Tran Data-003-EDGE	14.0000	1000000005	5	T	14.0000	14.0000	14.0000	2026-01-05	1000000005	14.0000	14.0000

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
TIMESTAMP: 2026-01-01
TRAN_CODE: 1
TRAN_DATE: 2026-01-01
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
SALES_PROCESS_ID: 1
DEAL_TOTAL_RETAIL: 1.0000
TOTAL_COST_EXCL_ELC: 1.0000

default

DEPTR: 1003
CLASSR: 1103
SUBCLASSR: 1113
ITEM: Tran Data-002-ALT
UNITS: 12.5000
AV_COST: 12.5000
ADJ_CODE: C
LOCATION: 3
LOC_TYPE: W
PACK_IND: T
PGM_NAME: Tran Data Secondary
REF_NO_1: Tran Data-002-ALT
REF_NO_2: Tran Data-002-ALT
VAT_RATE: 12.5000000000
GL_REF_NO: Tran Data-002-ALT
TIMESTAMP: 2026-02-09
TRAN_CODE: 3
TRAN_DATE: 2026-01-03
SALES_TYPE: v
TOTAL_COST: 12.5000
POS_TRAN_ID: 1000000003
REF_PACK_NO: Tran Data-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
SALES_PROCESS_ID: 1000000003
DEAL_TOTAL_RETAIL: 12.5000
TOTAL_COST_EXCL_ELC: 12.5000