S9T Tmpl Cols Def
In ScopeTechnical: S9T_TMPL_COLS_DEF | ID: OR-MFCS-S9T_TMPL_COLS_DEF
Stores column definition for spreadsheet templates used by RMS. E.g.
See how this object fits into Trade Management
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
- S9T_TMPL_COLS_DEF
Field Definitions(11)
Rules & Considerations(39)
Sample Load Data(4)
| _scenario | CREATE_IDR | MANDATORYR | WKSHT_KEYR | COLUMN_KEYR | COLUMN_NAMER | TEMPLATE_KEYRPK | MANDATORY_DISABLEDR | CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP8LAST_UPDATE_IDR | DATE_NUM_FIELD_TYPE | REQUIRED_VISUAL_IND | LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10DEFAULT_VALUE |
|---|---|---|---|---|---|---|---|---|---|---|---|
| default | USERENV | N | STD-S9T_TMPL-001 | STD-S9T_TMPL-001 | S9T Tmpl Cols Def Primary | STD-S9T_TMPL-001 | N | USERENV | 2026-01-01 | N | 2026-01-01 |
default
- CREATE_IDR
- USERENV
- MANDATORYR
- N
- WKSHT_KEYR
- STD-S9T_TMPL-001
- COLUMN_KEYR
- STD-S9T_TMPL-001
- COLUMN_NAMER
- S9T Tmpl Cols Def Primary
- TEMPLATE_KEYRPK
- STD-S9T_TMPL-001
- MANDATORY_DISABLEDR
- N
- CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP8LAST_UPDATE_IDR
- USERENV
- DATE_NUM_FIELD_TYPE
- 2026-01-01
- REQUIRED_VISUAL_IND
- N
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10DEFAULT_VALUE
- 2026-01-01