RepoSetupsVariables, 83 (ver3.6.1)
This table stores information on report specific variables.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
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. |
Initialization_Value | 3.6.1 | CLOB | The value set to initialize this variable at start, such as 0. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Missing_Value_Symbol | 3.6.1 | CLOB | If a value is missing for a record what should be shown instead, such as -999. |
Name | 3.6.1 | Varchar(31) | Name provided to this report variable. |
Order_Index | 3.6.1 | Number(10,0) | The number provided to this item for referencing purposes. |
Permanent_In_Merger | 3.6.1 | Number(10,0) | Indicates whether this is a permanent value for the merger report. 1=Permanent, 0=Normal. |
ReportSetupID | 3.6.1 | Number(10,0) | The internal number for the parent RepoSetups with which this record is associated. Indexed. |
Value | 3.6.1 | CLOB | Actual values being set for the variables in Code format. Multiple entries allowed separated by semicolon. |
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. |
When_To_Set | 3.6.1 | Number(10,0) | When this variables should be set: Before Main Query, After Main Query, For Each Row, Before Each Row, Never. |