Query Designer Fields List (CO00121)

azurecurveProductsMicrosoft Dynamics GP (0)CompanyQuery Designer Fields List (CO00121)

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

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1FieldsListGuid SearchFieldsListGuidGUIDStringString3836
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3DefaultField SearchDefaultFieldCBBoolean20
4TableDictID SearchTableDictIDID_INTInteger24
5TableSeries SearchTableSeriesTableSeriesInteger20
6TableTechnicalName SearchTableTechnicalNameSTR80String8280
7TablePhysicalName SearchTablePhysicalNameSTR30String3230
8TableDisplayName SearchTableDisplayNameSTR80String8280
9FieldPhysicalName SearchFieldPhysicalNameSTR30String3230
10FieldDisplayName SearchFieldDisplayNameSTR80String8280
11FieldSource SearchFieldSourceFieldSourceInteger20
12FieldDataType SearchFieldDataTypeFieldDataTypeInteger20
13DecimalDigits SearchDecimalDigitsINT2Integer22
14RelativeDecimalPosition SearchRelativeDecimalPositionBooleanBoolean20
15ShowCurrencySymbol SearchShowCurrencySymbolBooleanBoolean20
16ShowPercentSign SearchShowPercentSignBooleanBoolean20
17CRNCYSYM SearchCurrency SymbolCurrency_SymbolString43
18DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
19Hidden SearchHiddenCBBoolean20
20DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)CompanyQuery Designer Fields List (CO00121)

Leave a Reply

Your email address will not be published. Required fields are marked *