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(11)
Rules & Considerations(20)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | Y | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | S | S | SAMPLE |
Example values from field definitions
- CREATE_IDR
- SAMPLE
- MANDATORYR
- Y
- WKSHT_KEYR
- SAMPLE
- COLUMN_KEYR
- SAMPLE
- COLUMN_NAMER
- SAMPLE
- TEMPLATE_KEYRPK
- SAMPLE
- MANDATORY_DISABLEDR
- S
- CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP8LAST_UPDATE_IDR
- SAMPLE
- DATE_NUM_FIELD_TYPE
- S
- REQUIRED_VISUAL_IND
- S
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10DEFAULT_VALUE
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 20