Iif Detail
In ScopeTechnical: IIF_DETAIL | ID: OR-CST-IIF_DETAIL-IIF_DETAIL
This table will hold one record for every SKU/receipt matched in the system, to be transmitted to the financial system.
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
- IIF_DETAIL
Field Definitions(5)
Rules & Considerations(13)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | INVC_IDR | COST_DSCRPNCY_INDR | PAYMENT_QTY | PAYMENT_VAT_RATE | QTY_DSCRPNCY_IND | VAT_DSCRPNCY_IND | PAYMENT_UNIT_COST |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | 1.0000 | 1.0000000000 | S | S | 1.0000 |
| default | Iif Detail-002-ALT | 1000000003 | I | 12.5000 | 12.5000000000 | I | I | 12.5000 |
| default | Iif Detail-003-EDGE | 1000000005 | I | 14.0000 | 14.0000000000 | I | I | 14.0000 |
Example values from field definitions
- ITEMR
- SAMPLE
- INVC_IDR
- 1
- COST_DSCRPNCY_INDR
- S
- PAYMENT_QTY
- 1.0000
- PAYMENT_VAT_RATE
- 1.0000000000
- QTY_DSCRPNCY_IND
- S
- VAT_DSCRPNCY_IND
- S
- PAYMENT_UNIT_COST
- 1.0000
default
- ITEMR
- Iif Detail-002-ALT
- INVC_IDR
- 1000000003
- COST_DSCRPNCY_INDR
- I
- PAYMENT_QTY
- 12.5000
- PAYMENT_VAT_RATE
- 12.5000000000
- QTY_DSCRPNCY_IND
- I
- VAT_DSCRPNCY_IND
- I
- PAYMENT_UNIT_COST
- 12.5000
default
- ITEMR
- Iif Detail-003-EDGE
- INVC_IDR
- 1000000005
- COST_DSCRPNCY_INDR
- I
- PAYMENT_QTY
- 14.0000
- PAYMENT_VAT_RATE
- 14.0000000000
- QTY_DSCRPNCY_IND
- I
- VAT_DSCRPNCY_IND
- I
- PAYMENT_UNIT_COST
- 14.0000
Rule Validation Summary
- Source Rule Count
- 19
- Governed Rule Count
- 13