RMS Oi Dept Options
In ScopeTechnical: RMS_OI_DEPT_OPTIONS | ID: OR-MFCS-RMS_OI_DEPT_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
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_DEPT_OPTIONS
Field Definitions(30)
Rules & Considerations(11)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | RMS Oi Dept Options-001 | RMS Oi Dept Options-001 | RMS Oi Dept Options-001 | RMS Oi Dept Options-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | Y | 1 | RMS Oi Dept Options-001 | 0 | 001 | RMS Oi Dept Options-001 | RMS Oi Dept Options-001 | 10 | Y | RMS Oi Dept Options-001 | 1 | 0 | RMS Oi Dept Options-001 | RMS Oi Dept Options-001 | 00001 | RMS Oi Dept Options-001 | RMS Oi Dept Options-001 | RMS Oi Dept Options-001 | Y | 00001 | RMS Oi Dept Options-001 |
default
- DEPTRPK
- 1001
- DS_SHOW_INCOMP_ITEM_HTS
- RMS Oi Dept Options-001
- DS_SHOW_INCOMP_ITEM_LOC
- RMS Oi Dept Options-001
- DS_SHOW_INCOMP_ITEM_UDA
- RMS Oi Dept Options-001
- DS_SHOW_INCOMP_ITEM_VAT
- RMS Oi Dept Options-001
- IA_VARIANCE_RANGE_PCT_1
- 11.0000
- IA_VARIANCE_RANGE_PCT_2
- 11.0000
- IA_VARIANCE_RANGE_PCT_3
- 11.0000
- IA_VARIANCE_RANGE_PCT_4
- 11.0000
- IC_UNEXP_INV_DELETE_IND
- Y
- IC_UNEXP_INV_WARN_COUNT
- 1
- DS_SHOW_INCOMP_ITEM_REPL
- RMS Oi Dept Options-001
- IC_NEG_INV_TOLERANCE_QTY
- 0
- DS_DAYS_AFTER_ITEM_CREATE
- 001
- DS_SHOW_INCOMP_ITEM_DIMEN
- RMS Oi Dept Options-001
- DS_SHOW_INCOMP_ITEM_SPACK
- RMS Oi Dept Options-001
- FA_CUM_MARKON_MIN_VAR_PCT
- 10
- IC_UNEXP_INV_INACTIVE_IND
- Y
- DS_SHOW_INCOMP_ITEM_IMAGES
- RMS Oi Dept Options-001
- IC_UNEXP_INV_CRITIAL_COUNT
- 1
- IC_UNEXP_INV_TOLERANCE_QTY
- 0
- DS_SHOW_INCOMP_ITEM_SEASONS
- RMS Oi Dept Options-001
- DS_SHOW_INCOMP_ITEM_TICKETS
- RMS Oi Dept Options-001
- DS_PURGE_DAYS_AFTER_CREATION
- 00001
- DS_SHOW_INCOMP_ITEM_IMP_ATTR
- RMS Oi Dept Options-001
- DS_SHOW_INCOMP_ITEM_REF_ITEM
- RMS Oi Dept Options-001
- DS_SHOW_INCOMP_ITEM_REL_ITEM
- RMS Oi Dept Options-001
- IC_UNEXP_INV_DISCONTINUE_IND
- Y
- DS_PURGE_DAYS_AFTER_LAST_TRAN
- 00001
- DS_SHOW_INCOMP_ITEM_SUBS_ITEM
- RMS Oi Dept Options-001