S9T Tmpl Cols Def
In ScopeTechnical: S9T_TMPL_COLS_DEF | ID: OR-TRD-S9T_TMPL_COLS_DEF-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- S9T_TMPL_COLS_DEF
Field Definitions(5)
Rules & Considerations(23)
constraint
validation
Sample Load Data(4)
| _scenario | MANDATORYR | WKSHT_KEYRPK | COLUMN_KEYRPK | COLUMN_NAMER | TEMPLATE_KEYRPK | CREATE_ID | MANDATORY_DISABLED | DATE_NUM_FIELD_TYPE | REQUIRED_VISUAL_IND | CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP8LAST_UPDATE_ID | LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10DEFAULT_VALUE |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | Y | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | S | S | SAMPLE | SAMPLE |
| default | N | ALT-S9T_TMPL-002 | ALT-S9T_TMPL-002 | S9T Tmpl Cols Def Secondary | ALT-S9T_TMPL-002 | C LIENT_INFO | N | 2 | N | C LIENT_INFO | 2026-01-02-ALT |
| default | N | EDGE-S9T_TMPL-003 | EDGE-S9T_TMPL-003 | S9T Tmpl Cols Def Core | EDGE-S9T_TMPL-003 | USE RENV | N | 2 | N | USE RENV | 2026-01-03-EDGE |
Example values from field definitions
- MANDATORYR
- Y
- WKSHT_KEYRPK
- SAMPLE
- COLUMN_KEYRPK
- SAMPLE
- COLUMN_NAMER
- SAMPLE
- TEMPLATE_KEYRPK
- SAMPLE
- CREATE_ID
- SAMPLE
- MANDATORY_DISABLED
- S
- DATE_NUM_FIELD_TYPE
- S
- REQUIRED_VISUAL_IND
- S
- CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP8LAST_UPDATE_ID
- SAMPLE
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10DEFAULT_VALUE
- SAMPLE
default
- MANDATORYR
- N
- WKSHT_KEYRPK
- ALT-S9T_TMPL-002
- COLUMN_KEYRPK
- ALT-S9T_TMPL-002
- COLUMN_NAMER
- S9T Tmpl Cols Def Secondary
- TEMPLATE_KEYRPK
- ALT-S9T_TMPL-002
- CREATE_ID
- C LIENT_INFO
- MANDATORY_DISABLED
- N
- DATE_NUM_FIELD_TYPE
- 2
- REQUIRED_VISUAL_IND
- N
- CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP8LAST_UPDATE_ID
- C LIENT_INFO
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10DEFAULT_VALUE
- 2026-01-02-ALT
default
- MANDATORYR
- N
- WKSHT_KEYRPK
- EDGE-S9T_TMPL-003
- COLUMN_KEYRPK
- EDGE-S9T_TMPL-003
- COLUMN_NAMER
- S9T Tmpl Cols Def Core
- TEMPLATE_KEYRPK
- EDGE-S9T_TMPL-003
- CREATE_ID
- USE RENV
- MANDATORY_DISABLED
- N
- DATE_NUM_FIELD_TYPE
- 2
- REQUIRED_VISUAL_IND
- N
- CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP8LAST_UPDATE_ID
- USE RENV
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10DEFAULT_VALUE
- 2026-01-03-EDGE
Rule Validation Summary
- Source Rule Count
- 37
- Governed Rule Count
- 23