IM Oi Supp Site Report
In ScopeTechnical: IM_OI_SUPP_SITE_REPORT | ID: OR-IM-IM_OI_SUPP_SITE_REPORT-IM_OI_SUPP_SITE_REPORT
Stores the Supplier Site scorecard information for ReIM OI dashboard.
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_OI_SUPP_SITE_REPORT
Field Definitions(5)
Rules & Considerations(16)
Sample Load Data(4)
| _scenario | SUPPLIERR | SESSION_IDR | SUP_NAME | FILTER_IND | TOTAL_AMOUNT | INVOICE_COUNT | AUTOMATCH_RATE | QTY_DISC_COUNT | AUTOMATCH_COUNT | COST_DISC_COUNT | COMPLIANCE_SCARD | SUPP_CURRENCY_CODE | LATE_SHIP_INVC_COUNT | EARLY_SHIP_INVC_COUNT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | S | 1.0000 | 1 | 1.00 | 1 | 1 | 1 | 1 | SAM | 1 | 1 |
| default | 3 | 1000000003 | IM Oi Supp Site Report Secondary | I | 12.5000 | 3 | 12.50 | 3 | 3 | 3 | 3 | ALT | 3 | 3 |
| default | 5 | 1000000005 | IM Oi Supp Site Report Core | I | 14.0000 | 5 | 14.00 | 5 | 5 | 5 | 5 | EDG | 5 | 5 |
Example values from field definitions
- SUPPLIERR
- 1
- SESSION_IDR
- 1
- SUP_NAME
- SAMPLE
- FILTER_IND
- S
- TOTAL_AMOUNT
- 1.0000
- INVOICE_COUNT
- 1
- AUTOMATCH_RATE
- 1.00
- QTY_DISC_COUNT
- 1
- AUTOMATCH_COUNT
- 1
- COST_DISC_COUNT
- 1
- COMPLIANCE_SCARD
- 1
- SUPP_CURRENCY_CODE
- SAM
- LATE_SHIP_INVC_COUNT
- 1
- EARLY_SHIP_INVC_COUNT
- 1
default
- SUPPLIERR
- 3
- SESSION_IDR
- 1000000003
- SUP_NAME
- IM Oi Supp Site Report Secondary
- FILTER_IND
- I
- TOTAL_AMOUNT
- 12.5000
- INVOICE_COUNT
- 3
- AUTOMATCH_RATE
- 12.50
- QTY_DISC_COUNT
- 3
- AUTOMATCH_COUNT
- 3
- COST_DISC_COUNT
- 3
- COMPLIANCE_SCARD
- 3
- SUPP_CURRENCY_CODE
- ALT
- LATE_SHIP_INVC_COUNT
- 3
- EARLY_SHIP_INVC_COUNT
- 3
default
- SUPPLIERR
- 5
- SESSION_IDR
- 1000000005
- SUP_NAME
- IM Oi Supp Site Report Core
- FILTER_IND
- I
- TOTAL_AMOUNT
- 14.0000
- INVOICE_COUNT
- 5
- AUTOMATCH_RATE
- 14.00
- QTY_DISC_COUNT
- 5
- AUTOMATCH_COUNT
- 5
- COST_DISC_COUNT
- 5
- COMPLIANCE_SCARD
- 5
- SUPP_CURRENCY_CODE
- EDG
- LATE_SHIP_INVC_COUNT
- 5
- EARLY_SHIP_INVC_COUNT
- 5
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 16