IM Supplier Groups
In ScopeTechnical: IM_SUPPLIER_GROUPS | ID: OR-IM-IM_SUPPLIER_GROUPS-IM_SUPPLIER_GROUPS
13 AP_REVIEWER VARCHAR (30 ) LT 14 QTY_DISC_DAY_BEFORE_RTE Y NUMERIC (3) LT 10 15 ONLINE_PARENT_MATCH_IND Y VARCHAR (1) LT 'N'.
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_SUPPLIER_GROUPS
Field Definitions(5)
Rules & Considerations(33)
constraint
validation
Sample Load Data(4)
| _scenario | GROUP_IDRPK | CREATED_BYR | CREATION_DATER | MATCH_TOTAL_QTY_INDR | TOTAL_QTY_REQUIRED_INDR | MATCH_KEY | GROUP_DESC | AP_REVIEWER | MATCH_STGY_ID | LAST_UPDATED_BY | MATCH_MASTER_PO | LAST_UPDATE_DATE | SKU_COMP_PERCENT | EXTERNAL_GROUP_ID | OBJECT_VERSION_ID | ONLINE_PARENT_MATCH_IND | QTY_DISC_DAY_BEFORE_RTE | AUTOMATCH_ACROSS_MULTI_PO_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 2026-01-01 | S | S | SAM | SAMPLE | SAMPLE | 1 | SAMPLE | S | 2026-01-01 | 1.00 | 1 | 1 | S | 1 | S |
| default | 1000000003 | APP_USER_ID | 2026-01-03 | I | I | POL | IM Supplier Groups-002-ALT | IM Supplier Groups-002-ALT | 1000000003 | APP_USER_ID | Y | 2026-01-03 | 12.50 | 1000000003 | 1000000003 | N | 3 | N |
| default | 1000000005 | USERENV | 2026-01-05 | I | I | POL | IM Supplier Groups-003-EDGE | IM Supplier Groups-003-EDGE | 1000000005 | USERENV | Y | 2026-01-05 | 14.00 | 1000000005 | 1000000005 | N | 5 | N |
Example values from field definitions
- GROUP_IDRPK
- 1
- CREATED_BYR
- SAMPLE
- CREATION_DATER
- 2026-01-01
- MATCH_TOTAL_QTY_INDR
- S
- TOTAL_QTY_REQUIRED_INDR
- S
- MATCH_KEY
- SAM
- GROUP_DESC
- SAMPLE
- AP_REVIEWER
- SAMPLE
- MATCH_STGY_ID
- 1
- LAST_UPDATED_BY
- SAMPLE
- MATCH_MASTER_PO
- S
- LAST_UPDATE_DATE
- 2026-01-01
- SKU_COMP_PERCENT
- 1.00
- EXTERNAL_GROUP_ID
- 1
- OBJECT_VERSION_ID
- 1
- ONLINE_PARENT_MATCH_IND
- S
- QTY_DISC_DAY_BEFORE_RTE
- 1
- AUTOMATCH_ACROSS_MULTI_PO_IND
- S
default
- GROUP_IDRPK
- 1000000003
- CREATED_BYR
- APP_USER_ID
- CREATION_DATER
- 2026-01-03
- MATCH_TOTAL_QTY_INDR
- I
- TOTAL_QTY_REQUIRED_INDR
- I
- MATCH_KEY
- POL
- GROUP_DESC
- IM Supplier Groups-002-ALT
- AP_REVIEWER
- IM Supplier Groups-002-ALT
- MATCH_STGY_ID
- 1000000003
- LAST_UPDATED_BY
- APP_USER_ID
- MATCH_MASTER_PO
- Y
- LAST_UPDATE_DATE
- 2026-01-03
- SKU_COMP_PERCENT
- 12.50
- EXTERNAL_GROUP_ID
- 1000000003
- OBJECT_VERSION_ID
- 1000000003
- ONLINE_PARENT_MATCH_IND
- N
- QTY_DISC_DAY_BEFORE_RTE
- 3
- AUTOMATCH_ACROSS_MULTI_PO_IND
- N
default
- GROUP_IDRPK
- 1000000005
- CREATED_BYR
- USERENV
- CREATION_DATER
- 2026-01-05
- MATCH_TOTAL_QTY_INDR
- I
- TOTAL_QTY_REQUIRED_INDR
- I
- MATCH_KEY
- POL
- GROUP_DESC
- IM Supplier Groups-003-EDGE
- AP_REVIEWER
- IM Supplier Groups-003-EDGE
- MATCH_STGY_ID
- 1000000005
- LAST_UPDATED_BY
- USERENV
- MATCH_MASTER_PO
- Y
- LAST_UPDATE_DATE
- 2026-01-05
- SKU_COMP_PERCENT
- 14.00
- EXTERNAL_GROUP_ID
- 1000000005
- OBJECT_VERSION_ID
- 1000000005
- ONLINE_PARENT_MATCH_IND
- N
- QTY_DISC_DAY_BEFORE_RTE
- 5
- AUTOMATCH_ACROSS_MULTI_PO_IND
- N
Rule Validation Summary
- Source Rule Count
- 51
- Governed Rule Count
- 33