RepoSetupsItems, 60 (ver3.6.1)
Reporting engine individual items that make up the report.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ConversionTable | 3.6.1 | CLOB | Values that need to be converted from their original settings separated by semicolon, such as 1=Y, 2=N. |
Conversion_Table_Def_Value | 3.6.1 | CLOB | A default value to be given when there is no conversion value available. |
DataToExport | 3.6.1 | CLOB | Actual data/columns to be exported in a Data Code format. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | An optional area to describe any information about this item. |
Display_Format | 3.6.1 | Varchar(79) | The format this item is to be displayed, such as ###0 = number greater than 0. |
FixedLength_FillChar | 3.6.1 | Varchar(11) | For fixed length fields the character to fill the field. This can be in an ASCII format. |
FixedLength_Justification | 3.6.1 | Number(10,0) | Alignment for this field: Right, Center or Left. |
FixedLength_Length | 3.6.1 | Number(10,0) | Length of this fixed length field. |
FixedLength_StartPosition | 3.6.1 | Number(10,0) | When import the start position of the field. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ItemNbr | 3.6.1 | Number(10,0) | Number that can be manually assigned to this item for reference purposes. |
MissingValueSymbol | 3.6.1 | Varchar(79) | What symbol to use if the item value is missing, such as for decimal use 0.00. |
Nbr_Of_Decimals | 3.6.1 | Number(10,0) | Number of decimals to be used for the value of this item. For numeric values only and up to 12. |
ReportSetupID | 3.6.1 | Number(10,0) | The internal number for the parent RepoSetupID with which this record is associated. Indexed. |
TitleHeading | 3.6.1 | CLOB | Heading for this field on the report. |
Trim_Nbr_Of_Chars | 3.6.1 | Number(10,0) | Trim number of characters at the start point given. Passed in through an Import for Exporting. |
Trim_Start_At | 3.6.1 | Number(10,0) | The point to start trimming the characters. Passed in through an Import for Exporting. |
Unused1 | 3.6.1 | Number(10,0) | Currently unused field. |
User_Info | 3.6.1 | CLOB | Any user information passed in through Import for Exporting purposes. |
User_Modifiable | 3.6.1 | Number(10,0) | Indicates whether this item is user modifiable. Passed in through Import for Exporting purposes. |
Value_Type | 3.6.1 | Number(10,0) | Datatype of the Variable to be used: 1=Integer, 2=Real, 3=Text, 4=Date, 5=Boolean, 6=Time, 7= Undefined. |