RepoSetupsOrderBy, 64 (ver3.6.1)
Reporting engine how the items are sorted after retrieving the data.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Break_Gen_Formula | 3.6.1 | CLOB | When the value for this generated formula is changed then a Break is made in the report. |
Break_Generation | 3.6.1 | Varchar(21) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Direction_Up | 3.6.1 | Number(10,0) | Indicates whether this report is to be order in an Ascending = 1 or Descending=0 mode. |
Field_Number | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Formula_And_Parameters | 3.6.1 | CLOB | The formula used to order this report. This is in Data Code format. |
Formula_And_Parameters_Display | 3.6.1 | CLOB | Similar to Formula_and _Parameters but a space is added to ~ wherever encountered so it displays correctly. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Order_Index | 3.6.1 | Number(10,0) | The number provided to this item for referencing purposes. |
ReportSetupID | 3.6.1 | Number(10,0) | The internal number for the parent RepoSetups with which this record is associated. Indexed. |
Table_Number | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Unused1 | 3.6.1 | Number(10,0) | Currently unused field. |
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. |