RMS Oi Department Options
In ScopeTechnical: RMS_OI_DEPT_OPTIONS | ID: OR-FND-RMS_OI_DEPT_OPTIONS-RMS_OI_DEPARTMENT_OPTIONS
Stores department level configurations for the Dashboard Reports.
See how this object fits into Foundation Data
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_DEPT_OPTIONS
Field Definitions(30)
Rules & Considerations(32)
validation
constraint
Sample Load Data(4)
| _scenario | DEPTRPK | DS_SHOW_INCOMP_ITEM_HTS | DS_SHOW_INCOMP_ITEM_LOC | DS_SHOW_INCOMP_ITEM_UDA | DS_SHOW_INCOMP_ITEM_VAT | IA_VARIANCE_RANGE_PCT_1 | IA_VARIANCE_RANGE_PCT_2 | IA_VARIANCE_RANGE_PCT_3 | IA_VARIANCE_RANGE_PCT_4 | IC_UNEXP_INV_DELETE_IND | IC_UNEXP_INV_WARN_COUNT | DS_SHOW_INCOMP_ITEM_REPL | IC_NEG_INV_TOLERANCE_QTY | DS_DAYS_AFTER_ITEM_CREATE | DS_SHOW_INCOMP_ITEM_DIMEN | DS_SHOW_INCOMP_ITEM_SPACK | FA_CUM_MARKON_MIN_VAR_PCT | IC_UNEXP_INV_INACTIVE_IND | DS_SHOW_INCOMP_ITEM_IMAGES | IC_UNEXP_INV_CRITIAL_COUNT | IC_UNEXP_INV_TOLERANCE_QTY | DS_SHOW_INCOMP_ITEM_SEASONS | DS_SHOW_INCOMP_ITEM_TICKETS | DS_PURGE_DAYS_AFTER_CREATION | DS_SHOW_INCOMP_ITEM_IMP_ATTR | DS_SHOW_INCOMP_ITEM_REF_ITEM | DS_SHOW_INCOMP_ITEM_REL_ITEM | IC_UNEXP_INV_DISCONTINUE_IND | DS_PURGE_DAYS_AFTER_LAST_TRAN | DS_SHOW_INCOMP_ITEM_SUBS_ITEM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | S | S | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 1 | S | 1.0000 | 1 | S | S | 1.0000 | S | S | 1 | 1.0000 | S | S | 1 | S | S | S | S | 1 | S |
Example values from field definitions
- DEPTRPK
- 1
- DS_SHOW_INCOMP_ITEM_HTS
- S
- DS_SHOW_INCOMP_ITEM_LOC
- S
- DS_SHOW_INCOMP_ITEM_UDA
- S
- DS_SHOW_INCOMP_ITEM_VAT
- S
- IA_VARIANCE_RANGE_PCT_1
- 1.0000
- IA_VARIANCE_RANGE_PCT_2
- 1.0000
- IA_VARIANCE_RANGE_PCT_3
- 1.0000
- IA_VARIANCE_RANGE_PCT_4
- 1.0000
- IC_UNEXP_INV_DELETE_IND
- S
- IC_UNEXP_INV_WARN_COUNT
- 1
- DS_SHOW_INCOMP_ITEM_REPL
- S
- IC_NEG_INV_TOLERANCE_QTY
- 1.0000
- DS_DAYS_AFTER_ITEM_CREATE
- 1
- DS_SHOW_INCOMP_ITEM_DIMEN
- S
- DS_SHOW_INCOMP_ITEM_SPACK
- S
- FA_CUM_MARKON_MIN_VAR_PCT
- 1.0000
- IC_UNEXP_INV_INACTIVE_IND
- S
- DS_SHOW_INCOMP_ITEM_IMAGES
- S
- IC_UNEXP_INV_CRITIAL_COUNT
- 1
- IC_UNEXP_INV_TOLERANCE_QTY
- 1.0000
- DS_SHOW_INCOMP_ITEM_SEASONS
- S
- DS_SHOW_INCOMP_ITEM_TICKETS
- S
- DS_PURGE_DAYS_AFTER_CREATION
- 1
- DS_SHOW_INCOMP_ITEM_IMP_ATTR
- S
- DS_SHOW_INCOMP_ITEM_REF_ITEM
- S
- DS_SHOW_INCOMP_ITEM_REL_ITEM
- S
- IC_UNEXP_INV_DISCONTINUE_IND
- S
- DS_PURGE_DAYS_AFTER_LAST_TRAN
- 1
- DS_SHOW_INCOMP_ITEM_SUBS_ITEM
- S
Rule Validation Summary
- Source Rule Count
- 41
- Governed Rule Count
- 32