RMS Oi Data Stwrd Incomp Items
In ScopeTechnical: RMS_OI_DATA_STWRD_INCOMP_ITEMS | ID: OR-ITM-RMS_OI_DATA_STWRD_INCOMP_ITEMS-RMS_OI_DATA_STWRD_INCOMP_ITEMS
This tables holds data for the Data Steward Incomplete Items Report.
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_DATA_STWRD_INCOMP_ITEMS
Field Definitions(5)
Rules & Considerations(35)
Sample Load Data(4)
| _scenario | HTS | UDA | VAT | VPN | DEPT | ITEM | CLASS | IMAGES | STATUS | TICKET | SEASONS | LOCATION | PACK_IND | SUBCLASS | CREATE_ID | DEPT_NAME | ITEM_DESC | REF_ITEMS | UNIT_COST | CLASS_NAME | DIMENSIONS | SESSION_ID | SUBS_ITEMS | CREATE_DATE | IMPORT_ATTR | ITEM_PARENT | SIMPLE_PACK | PRIM_COUNTRY | SUP_CURRENCY | PRIM_SUPPLIER | RELATED_ITEMS | REPLENISHMENT | SUBCLASS_NAME | SELLING_RETAIL | REQD_COMPLETION | PRIM_SUPPLIER_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | 1 | S | 1 | 1 | 1 | S | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | 1 | 1 | 1 | 2026-01-01 | 1 | SAMPLE | 1 | SAM | SAM | 1 | 1 | 1 | SAMPLE | 1.0000 | 1 | SAMPLE |
| default | 3 | 3 | 3 | RMS Oi Data Stwrd Incomp Items | 1003 | RMS Oi Data Stwrd Incomp | 1103 | 3 | P | 3 | 3 | 3 | R | 1113 | MDM_USER | Footwear | RMS Oi Data Stwrd Incomp Items-002-ALT | 3 | 12.5000 | Womenswear | 3 | 1000000003 | 3 | 2026-01-03 | 3 | RMS Oi Data Stwrd Incomp | 3 | RMS | RMS | 3 | 3 | 3 | Fashion Range | 12.5000 | 3 | RMS Oi Data Stwrd Incomp Items Secondary |
| default | 5 | 5 | 5 | RMS Oi Data Stwrd Incomp Items | 1005 | RMS Oi Data Stwrd Incomp | 1105 | 5 | A | 5 | 5 | 5 | R | 1115 | BATCH_USER | Beauty | RMS Oi Data Stwrd Incomp Items-003-EDGE | 5 | 14.0000 | Kidswear | 5 | 1000000005 | 5 | 2026-01-05 | 5 | RMS Oi Data Stwrd Incomp | 5 | RMS | RMS | 5 | 5 | 5 | Value Range | 14.0000 | 5 | RMS Oi Data Stwrd Incomp Items Core |
Example values from field definitions
- HTS
- 1
- UDA
- 1
- VAT
- 1
- VPN
- SAMPLE
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- IMAGES
- 1
- STATUS
- S
- TICKET
- 1
- SEASONS
- 1
- LOCATION
- 1
- PACK_IND
- S
- SUBCLASS
- 1
- CREATE_ID
- SAMPLE
- DEPT_NAME
- SAMPLE
- ITEM_DESC
- SAMPLE
- REF_ITEMS
- 1
- UNIT_COST
- 1.0000
- CLASS_NAME
- SAMPLE
- DIMENSIONS
- 1
- SESSION_ID
- 1
- SUBS_ITEMS
- 1
- CREATE_DATE
- 2026-01-01
- IMPORT_ATTR
- 1
- ITEM_PARENT
- SAMPLE
- SIMPLE_PACK
- 1
- PRIM_COUNTRY
- SAM
- SUP_CURRENCY
- SAM
- PRIM_SUPPLIER
- 1
- RELATED_ITEMS
- 1
- REPLENISHMENT
- 1
- SUBCLASS_NAME
- SAMPLE
- SELLING_RETAIL
- 1.0000
- REQD_COMPLETION
- 1
- PRIM_SUPPLIER_NAME
- SAMPLE
default
- HTS
- 3
- UDA
- 3
- VAT
- 3
- VPN
- RMS Oi Data Stwrd Incomp Items
- DEPT
- 1003
- ITEM
- RMS Oi Data Stwrd Incomp
- CLASS
- 1103
- IMAGES
- 3
- STATUS
- P
- TICKET
- 3
- SEASONS
- 3
- LOCATION
- 3
- PACK_IND
- R
- SUBCLASS
- 1113
- CREATE_ID
- MDM_USER
- DEPT_NAME
- Footwear
- ITEM_DESC
- RMS Oi Data Stwrd Incomp Items-002-ALT
- REF_ITEMS
- 3
- UNIT_COST
- 12.5000
- CLASS_NAME
- Womenswear
- DIMENSIONS
- 3
- SESSION_ID
- 1000000003
- SUBS_ITEMS
- 3
- CREATE_DATE
- 2026-01-03
- IMPORT_ATTR
- 3
- ITEM_PARENT
- RMS Oi Data Stwrd Incomp
- SIMPLE_PACK
- 3
- PRIM_COUNTRY
- RMS
- SUP_CURRENCY
- RMS
- PRIM_SUPPLIER
- 3
- RELATED_ITEMS
- 3
- REPLENISHMENT
- 3
- SUBCLASS_NAME
- Fashion Range
- SELLING_RETAIL
- 12.5000
- REQD_COMPLETION
- 3
- PRIM_SUPPLIER_NAME
- RMS Oi Data Stwrd Incomp Items Secondary
default
- HTS
- 5
- UDA
- 5
- VAT
- 5
- VPN
- RMS Oi Data Stwrd Incomp Items
- DEPT
- 1005
- ITEM
- RMS Oi Data Stwrd Incomp
- CLASS
- 1105
- IMAGES
- 5
- STATUS
- A
- TICKET
- 5
- SEASONS
- 5
- LOCATION
- 5
- PACK_IND
- R
- SUBCLASS
- 1115
- CREATE_ID
- BATCH_USER
- DEPT_NAME
- Beauty
- ITEM_DESC
- RMS Oi Data Stwrd Incomp Items-003-EDGE
- REF_ITEMS
- 5
- UNIT_COST
- 14.0000
- CLASS_NAME
- Kidswear
- DIMENSIONS
- 5
- SESSION_ID
- 1000000005
- SUBS_ITEMS
- 5
- CREATE_DATE
- 2026-01-05
- IMPORT_ATTR
- 5
- ITEM_PARENT
- RMS Oi Data Stwrd Incomp
- SIMPLE_PACK
- 5
- PRIM_COUNTRY
- RMS
- SUP_CURRENCY
- RMS
- PRIM_SUPPLIER
- 5
- RELATED_ITEMS
- 5
- REPLENISHMENT
- 5
- SUBCLASS_NAME
- Value Range
- SELLING_RETAIL
- 14.0000
- REQD_COMPLETION
- 5
- PRIM_SUPPLIER_NAME
- RMS Oi Data Stwrd Incomp Items Core
Rule Validation Summary
- Source Rule Count
- 41
- Governed Rule Count
- 35