Item Level Details Of The Document
In ScopeTechnical: 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(24)
Rules & Considerations(27)
constraint
validation
Sample Load Data(4)
| _scenario | DOC_IDRPK | 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 |
Example values from field definitions
- DOC_IDRPK
- 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
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 27