Invc Detail
In ScopeTechnical: INVC_DETAIL | ID: OR-MFCS-INVC_DETAIL
Stores one row for each SKU on an invoice. When an invoice header is purged, all associated rows on this table are also purged.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- INVC_DETAIL
Field Definitions(17)
Rules & Considerations(40)
Sample Load Data(4)
| _scenario | ITEMRPK | STATUSR | INVC_IDRPK | INVC_QTYR | VAT_CODEPK | PROCESSED_INDR | INVC_UNIT_COSTR | QTY_DSCRPNCY_INDR | VAT_DSCRPNCY_INDR | COST_DSCRPNCY_INDR | COMMENTS | ORIG_QTY | REF_ITEM | POST_DATE | INVC_VAT_RATE | ORIG_VAT_RATE | ORIG_UNIT_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Invc Detail-001 | U | 1000000001 | 11.0000 | STD-INVC_DETAI-001 | Y | 11.0000 | Y | Y | Y | Invc Detail-001 | 11.0000 | Invc Detail-001 | 2026-01-01 | 11.0000 | 11.0000 | 11.0000 |
default
- ITEMRPK
- Invc Detail-001
- STATUSR
- U
- INVC_IDRPK
- 1000000001
- INVC_QTYR
- 11.0000
- VAT_CODEPK
- STD-INVC_DETAI-001
- PROCESSED_INDR
- Y
- INVC_UNIT_COSTR
- 11.0000
- QTY_DSCRPNCY_INDR
- Y
- VAT_DSCRPNCY_INDR
- Y
- COST_DSCRPNCY_INDR
- Y
- COMMENTS
- Invc Detail-001
- ORIG_QTY
- 11.0000
- REF_ITEM
- Invc Detail-001
- POST_DATE
- 2026-01-01
- INVC_VAT_RATE
- 11.0000
- ORIG_VAT_RATE
- 11.0000
- ORIG_UNIT_COST
- 11.0000