FIF Invc Details Export
In ScopeTechnical: FIF_INVC_DETAILS_EXPORT | ID: OR-FIN-FIF_INVC_DETAILS_EXPORT-FIF_INVC_DETAILS_EXPORT
This table will hold a row of each SKU or type of non_merchandise cost associated on an invoice in the system that is to be transmitted to the financial system.
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
- FIF_INVC_DETAILS_EXPORT
Field Definitions(5)
Rules & Considerations(18)
Sample Load Data(4)
| _scenario | AMOUNT | LINE_NO | TAX_CODE | ATTRIBUTE1 | ATTRIBUTE2 | ATTRIBUTE3 | ATTRIBUTE4 | ATTRIBUTE5 | CREATED_BY | UNIT_PRICE | CREATION_DATE | LAST_UPDATE_BY | RTK_INVOICE_ID | ITEM_DESCRIPTION | LAST_UPDATE_DATE | INVOICE_LINE_TYPE | QUANTITY_INVOICED | ATTRIBUTE_CATEGORY | DIST_CODE_CMBINATION_ID | AMOUNT_INCLUDES_TAX_FLAG |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | 2026-01-01 | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 | SAMPLE | 1 | S |
| default | 12.5000 | 4 | ALT-FIF_INVC-00 | FIF Invc Details Export-002-ALT | FIF Invc Details Export-002-ALT | FIF Invc Details Export-002-ALT | FIF Invc Details Export-002-ALT | FIF Invc Details Export-002-ALT | 3 | 12.5000 | 2026-01-03 | 3 | 1000000003 | FIF Invc Details Export: Alternate source profile | 2026-01-03 | FIF Invc Details Export-0 | 12.5000 | FIF Invc Details Export-002-ALT | 1000000003 | F |
| default | 14.0000 | 6 | EDGE-FIF_INVC-0 | — | — | — | — | — | 5 | 14.0000 | 2026-01-05 | 5 | 1000000005 | — | 2026-01-05 | FIF Invc Details Export-0 | 14.0000 | — | 1000000005 | F |
Example values from field definitions
- AMOUNT
- 1.0000
- LINE_NO
- 1
- TAX_CODE
- SAMPLE
- ATTRIBUTE1
- SAMPLE
- ATTRIBUTE2
- SAMPLE
- ATTRIBUTE3
- SAMPLE
- ATTRIBUTE4
- SAMPLE
- ATTRIBUTE5
- SAMPLE
- CREATED_BY
- 1
- UNIT_PRICE
- 1.0000
- CREATION_DATE
- 2026-01-01
- LAST_UPDATE_BY
- 1
- RTK_INVOICE_ID
- 1
- ITEM_DESCRIPTION
- SAMPLE
- LAST_UPDATE_DATE
- 2026-01-01
- INVOICE_LINE_TYPE
- SAMPLE
- QUANTITY_INVOICED
- 1.0000
- ATTRIBUTE_CATEGORY
- SAMPLE
- DIST_CODE_CMBINATION_ID
- 1
- AMOUNT_INCLUDES_TAX_FLAG
- S
default
- AMOUNT
- 12.5000
- LINE_NO
- 4
- TAX_CODE
- ALT-FIF_INVC-00
- ATTRIBUTE1
- FIF Invc Details Export-002-ALT
- ATTRIBUTE2
- FIF Invc Details Export-002-ALT
- ATTRIBUTE3
- FIF Invc Details Export-002-ALT
- ATTRIBUTE4
- FIF Invc Details Export-002-ALT
- ATTRIBUTE5
- FIF Invc Details Export-002-ALT
- CREATED_BY
- 3
- UNIT_PRICE
- 12.5000
- CREATION_DATE
- 2026-01-03
- LAST_UPDATE_BY
- 3
- RTK_INVOICE_ID
- 1000000003
- ITEM_DESCRIPTION
- FIF Invc Details Export: Alternate source profile
- LAST_UPDATE_DATE
- 2026-01-03
- INVOICE_LINE_TYPE
- FIF Invc Details Export-0
- QUANTITY_INVOICED
- 12.5000
- ATTRIBUTE_CATEGORY
- FIF Invc Details Export-002-ALT
- DIST_CODE_CMBINATION_ID
- 1000000003
- AMOUNT_INCLUDES_TAX_FLAG
- F
default
- AMOUNT
- 14.0000
- LINE_NO
- 6
- TAX_CODE
- EDGE-FIF_INVC-0
- ATTRIBUTE1
- —
- ATTRIBUTE2
- —
- ATTRIBUTE3
- —
- ATTRIBUTE4
- —
- ATTRIBUTE5
- —
- CREATED_BY
- 5
- UNIT_PRICE
- 14.0000
- CREATION_DATE
- 2026-01-05
- LAST_UPDATE_BY
- 5
- RTK_INVOICE_ID
- 1000000005
- ITEM_DESCRIPTION
- —
- LAST_UPDATE_DATE
- 2026-01-05
- INVOICE_LINE_TYPE
- FIF Invc Details Export-0
- QUANTITY_INVOICED
- 14.0000
- ATTRIBUTE_CATEGORY
- —
- DIST_CODE_CMBINATION_ID
- 1000000005
- AMOUNT_INCLUDES_TAX_FLAG
- F
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 18