Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CO00121
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Query Designer Fields List
Physical Name: CO00121
Technical Name: QueryDesigner_FieldsList
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|---|---|---|---|---|
| 1 | FieldsListGuid  | FieldsListGuid | String | GUIDString | 36 |
| 2 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 |
| 3 | DefaultField | DefaultField | Boolean | CB | 0 |
| 4 | TableDictID | TableDictID | Integer | ID_INT | 4 |
| 5 | TableSeries | TableSeries | Integer | TableSeries | 0 |
| 6 | TableTechnicalName | TableTechnicalName | String | STR80 | 80 |
| 7 | TablePhysicalName | TablePhysicalName | String | STR30 | 30 |
| 8 | TableDisplayName | TableDisplayName | String | STR80 | 80 |
| 9 | FieldPhysicalName | FieldPhysicalName | String | STR30 | 30 |
| 10 | FieldDisplayName | FieldDisplayName | String | STR80 | 80 |
| 11 | FieldSource | FieldSource | Integer | FieldSource | 0 |
| 12 | FieldDataType | FieldDataType | Integer | FieldDataType | 0 |
| 13 | DecimalDigits | DecimalDigits | Integer | INT2 | 2 |
| 14 | RelativeDecimalPosition | RelativeDecimalPosition | Boolean | Boolean | 0 |
| 15 | ShowCurrencySymbol | ShowCurrencySymbol | Boolean | Boolean | 0 |
| 16 | ShowPercentSign | ShowPercentSign | Boolean | Boolean | 0 |
| 17 | CRNCYSYM | Currency Symbol | String | Currency_Symbol | 3 |
| 18 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 |
| 19 | Hidden | Hidden | Boolean | CB | 0 |