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 TypeLength
1FieldsListGuid SearchFieldsListGuidGUIDStringString36
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
3DefaultField SearchDefaultFieldCBBoolean0
4TableDictID SearchTableDictIDID_INTInteger4
5TableSeries SearchTableSeriesTableSeriesInteger0
6TableTechnicalName SearchTableTechnicalNameSTR80String80
7TablePhysicalName SearchTablePhysicalNameSTR30String30
8TableDisplayName SearchTableDisplayNameSTR80String80
9FieldPhysicalName SearchFieldPhysicalNameSTR30String30
10FieldDisplayName SearchFieldDisplayNameSTR80String80
11FieldSource SearchFieldSourceFieldSourceInteger0
12FieldDataType SearchFieldDataTypeFieldDataTypeInteger0
13DecimalDigits SearchDecimalDigitsINT2Integer2
14RelativeDecimalPosition SearchRelativeDecimalPositionBooleanBoolean0
15ShowCurrencySymbol SearchShowCurrencySymbolBooleanBoolean0
16ShowPercentSign SearchShowPercentSignBooleanBoolean0
17CRNCYSYM SearchCurrency SymbolCurrency_SymbolString3
18DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
19Hidden SearchHiddenCBBoolean0
20DEX_ROW_ID Searchintint10

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 *