DataExportTemplateOption (ver9.1.0)
This table stores a row for each format and export option in a stored template available in the Export Summary and Output Options section of the Export tab in the Data Export Manager.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DataExportTemplateID | 9.1.0 | Number(19) | Internal number for the associated DataExportTemplate record. Required. Indexed. |
DataExportTemplateOptionID | 9.1.0 | Number(19) | Unique sequential number generated by the application. Required. Indexed. |
Option_Name | 9.1.0 | Varchar2(100) | Internal name attribute of the format option. Required. Note: The displayed name is derived from this column value. |
Option_Value | 9.1.0 | Varchar2(100) | Internal value of the option. Known as post value. Note: The displayed value is derived from this column value. |
Option_Type | 9.1.0 | Varchar2(50) | Indicates the section of the screen, format or export, in which the option is displayed. Valid values: Formatter, Export. Required. |
WhenCreated | 9.1.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.1.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.1.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 9.1.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |