Document Item-Level Detail

In Scope

Technical: IM_FDG_DOC_DTL | ID: OR-IM-IM_FDG_DOC_DTL-IM_FDG_DOCUMENT_DTL

Stores the Item level details of the document.

See how this object fits into Invoice Matching

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

Field Definitions(5)

Rules & Considerations(28)

constraint

validation

Sample Load Data(4)

_scenario	DOC_IDR	DTL_IDRPK	PROCESS_IDR	QTY	UOM	VPN	GTIN	ITEM	LINE_NO	PACK_IND	UNIT_AMT	CREATE_BY	GTIN_TYPE	ITEM_DESC	TOTAL_AMT	TOTAL_CHARGE	TOTAL_TAX_AMT	LAST_UPDATE_BY	TOTAL_ROUNDING	CREATE_DATETIME	ITEM_SHORT_DESC	TOTAL_ALLOWANCE	TOTAL_AMT_INCL_TAX	LAST_UPDATE_DATETIME
Example values from field definitions	1	1	1	1.0000000000	SAMP	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	1.0000000000	SAMPLE	SAMPLE	SAMPLE	1.0000000000	1.0000000000	1.0000000000	SAMPLE	1.0000000000	2026-01-01	SAMPLE	1.0000000000	1.0000000000	2026-01-01
default	1000000003	1000000003	1000000003	12.5000000000	IM F	IM Fdg Doc Dtl-002-ALT	IM Fdg Doc Dtl-002-ALT	IM Fdg Doc Dtl-002-ALT	IM Fdg Doc Dtl-	N	12.5000000000	CLIENT_INFO	IM Fdg	IM Fdg Doc Dtl-002-ALT	12.5000000000	12.5000000000	12.5000000000	CLIENT_INFO	12.5000000000	2026-01-03	IM Fdg Doc Dtl-002-ALT	12.5000000000	12.5000000000	2026-01-03
default	1000000005	1000000005	1000000005	14.0000000000	IM F	IM Fdg Doc Dtl-003-EDGE	IM Fdg Doc Dtl-003-EDGE	IM Fdg Doc Dtl-003-EDGE	IM Fdg Doc Dtl-	Y	14.0000000000	SE SSION_USER	IM Fdg	IM Fdg Doc Dtl-003-EDGE	14.0000000000	14.0000000000	14.0000000000	SE SSION_USER	14.0000000000	2026-01-05	IM Fdg Doc Dtl-003-EDGE	14.0000000000	14.0000000000	2026-01-05

Example values from field definitions

DOC_IDR: 1
DTL_IDRPK: 1
PROCESS_IDR: 1
QTY: 1.0000000000
UOM: SAMP
VPN: SAMPLE
GTIN: SAMPLE
ITEM: SAMPLE
LINE_NO: SAMPLE
PACK_IND: S
UNIT_AMT: 1.0000000000
CREATE_BY: SAMPLE
GTIN_TYPE: SAMPLE
ITEM_DESC: SAMPLE
TOTAL_AMT: 1.0000000000
TOTAL_CHARGE: 1.0000000000
TOTAL_TAX_AMT: 1.0000000000
LAST_UPDATE_BY: SAMPLE
TOTAL_ROUNDING: 1.0000000000
CREATE_DATETIME: 2026-01-01
ITEM_SHORT_DESC: SAMPLE
TOTAL_ALLOWANCE: 1.0000000000
TOTAL_AMT_INCL_TAX: 1.0000000000
LAST_UPDATE_DATETIME: 2026-01-01

default

DOC_IDR: 1000000003
DTL_IDRPK: 1000000003
PROCESS_IDR: 1000000003
QTY: 12.5000000000
UOM: IM F
VPN: IM Fdg Doc Dtl-002-ALT
GTIN: IM Fdg Doc Dtl-002-ALT
ITEM: IM Fdg Doc Dtl-002-ALT
LINE_NO: IM Fdg Doc Dtl-
PACK_IND: N
UNIT_AMT: 12.5000000000
CREATE_BY: CLIENT_INFO
GTIN_TYPE: IM Fdg
ITEM_DESC: IM Fdg Doc Dtl-002-ALT
TOTAL_AMT: 12.5000000000
TOTAL_CHARGE: 12.5000000000
TOTAL_TAX_AMT: 12.5000000000
LAST_UPDATE_BY: CLIENT_INFO
TOTAL_ROUNDING: 12.5000000000
CREATE_DATETIME: 2026-01-03
ITEM_SHORT_DESC: IM Fdg Doc Dtl-002-ALT
TOTAL_ALLOWANCE: 12.5000000000
TOTAL_AMT_INCL_TAX: 12.5000000000
LAST_UPDATE_DATETIME: 2026-01-03

default

DOC_IDR: 1000000005
DTL_IDRPK: 1000000005
PROCESS_IDR: 1000000005
QTY: 14.0000000000
UOM: IM F
VPN: IM Fdg Doc Dtl-003-EDGE
GTIN: IM Fdg Doc Dtl-003-EDGE
ITEM: IM Fdg Doc Dtl-003-EDGE
LINE_NO: IM Fdg Doc Dtl-
PACK_IND: Y
UNIT_AMT: 14.0000000000
CREATE_BY: SE SSION_USER
GTIN_TYPE: IM Fdg
ITEM_DESC: IM Fdg Doc Dtl-003-EDGE
TOTAL_AMT: 14.0000000000
TOTAL_CHARGE: 14.0000000000
TOTAL_TAX_AMT: 14.0000000000
LAST_UPDATE_BY: SE SSION_USER
TOTAL_ROUNDING: 14.0000000000
CREATE_DATETIME: 2026-01-05
ITEM_SHORT_DESC: IM Fdg Doc Dtl-003-EDGE
TOTAL_ALLOWANCE: 14.0000000000
TOTAL_AMT_INCL_TAX: 14.0000000000
LAST_UPDATE_DATETIME: 2026-01-05

Rule Validation Summary

Source Rule Count: 40
Governed Rule Count: 28