Deal Perf Transaction Data

In Scope

Technical: DEAL_PERF_TRAN_DATA | ID: OR-CST-DEAL_PERF_TRAN_DATA-DEAL_PERF_TRANSACTION_DATA

Stores the deal related transaction data that are generated throughout on-line day as well as from batch processes. Each night, specific deal related transactions on tran_data will be copied to...

See how this object fits into Cost

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

Field Definitions(5)

Rules & Considerations(36)

constraint

validation

Sample Load Data(4)

_scenario	DEPTR	CLASSR	SUBCLASSR	ITEM	UNITS	AV_COST	REF_NO1	REF_NO2	ADJ_CODE	LOCATION	LOC_TYPE	PACK_IND	PGM_NAME	VAT_RATE	GL_REF_NO	TRAN_CODE	TRAN_DATE	SALES_TYPE	STORE_TYPE	TOTAL_COST	COSTING_LOC	REF_PACK_NO	TOTAL_RETAIL	TRAN_DATA_ID	NEW_UNIT_RETAIL	OLD_UNIT_RETAIL	COSTING_LOC_TYPE	STOCKHOLDING_IND
Example values from field definitions	1	1	1	SAMPLE	1.0000	1.0000	SAMPLE	SAMPLE	S	1	S	S	SAMPLE	1.0000000000	SAMPLE	1	2026-01-01	S	S	1.0000	1	SAMPLE	1.0000	1	1.0000	1.0000	S	S
default	1003	1103	1113	Deal Perf Tran Data-002-A	12.5000	12.5000	Deal Perf Tran Data-002-ALT	Deal Perf Tran Data-002-ALT	A	3	D	D	Deal Perf Tran Data Secondary	12.5000000000	Deal Perf Tran Data-002-A	3	2026-01-03	D	D	12.5000	3	Deal Perf Tran Data-002-A	12.5000	1000000003	12.5000	12.5000	D	N
default	1005	1105	1115	Deal Perf Tran Data-003-E	14.0000	14.0000	Deal Perf Tran Data-003-EDGE	Deal Perf Tran Data-003-EDGE	E	5	D	D	Deal Perf Tran Data Core	14.0000000000	Deal Perf Tran Data-003-E	5	2026-01-05	D	D	14.0000	5	Deal Perf Tran Data-003-E	14.0000	1000000005	14.0000	14.0000	D	Y

Example values from field definitions

DEPTR: 1
CLASSR: 1
SUBCLASSR: 1
ITEM: SAMPLE
UNITS: 1.0000
AV_COST: 1.0000
REF_NO1: SAMPLE
REF_NO2: SAMPLE
ADJ_CODE: S
LOCATION: 1
LOC_TYPE: S
PACK_IND: S
PGM_NAME: SAMPLE
VAT_RATE: 1.0000000000
GL_REF_NO: SAMPLE
TRAN_CODE: 1
TRAN_DATE: 2026-01-01
SALES_TYPE: S
STORE_TYPE: S
TOTAL_COST: 1.0000
COSTING_LOC: 1
REF_PACK_NO: SAMPLE
TOTAL_RETAIL: 1.0000
TRAN_DATA_ID: 1
NEW_UNIT_RETAIL: 1.0000
OLD_UNIT_RETAIL: 1.0000
COSTING_LOC_TYPE: S
STOCKHOLDING_IND: S

default

DEPTR: 1003
CLASSR: 1103
SUBCLASSR: 1113
ITEM: Deal Perf Tran Data-002-A
UNITS: 12.5000
AV_COST: 12.5000
REF_NO1: Deal Perf Tran Data-002-ALT
REF_NO2: Deal Perf Tran Data-002-ALT
ADJ_CODE: A
LOCATION: 3
LOC_TYPE: D
PACK_IND: D
PGM_NAME: Deal Perf Tran Data Secondary
VAT_RATE: 12.5000000000
GL_REF_NO: Deal Perf Tran Data-002-A
TRAN_CODE: 3
TRAN_DATE: 2026-01-03
SALES_TYPE: D
STORE_TYPE: D
TOTAL_COST: 12.5000
COSTING_LOC: 3
REF_PACK_NO: Deal Perf Tran Data-002-A
TOTAL_RETAIL: 12.5000
TRAN_DATA_ID: 1000000003
NEW_UNIT_RETAIL: 12.5000
OLD_UNIT_RETAIL: 12.5000
COSTING_LOC_TYPE: D
STOCKHOLDING_IND: N