QueryDesigner_Conditions (CO00123)

azurecurveProductsMicrosoft Dynamics GP (0)CompanyQueryDesigner_Conditions (CO00123)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CO00123

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: QueryDesigner_Conditions
Physical Name: CO00123
Technical Name: QueryDesigner_Conditions

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1FieldsListGuid SearchFieldsListGuidGUIDStringString36
2ConditionsGuid SearchConditionsGuidGUIDStringString36
3SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
4FromTable SearchFromTableSTR80String80
5FromField SearchFromFieldSTR80String80
6FromDictID SearchFromDictIDID_INTInteger4
7FromFieldListSequence SearchFromFieldListSequenceLI_Sequence_NumberLong Integer10
8ToTable SearchToTableSTR80String80
9ToField SearchToFieldSTR80String80
10ToDictID SearchToDictIDID_INTInteger4
11ToFieldListSequence SearchToFieldListSequenceLI_Sequence_NumberLong Integer10
12FieldDataType SearchFieldDataTypeFieldDataTypeInteger0
13FieldComparison SearchFieldComparisonCBBoolean0
14QueryOperator SearchQueryOperatorDDLInteger0
15QueryConditon SearchQueryConditonQueryConditonInteger0
16StringFilter SearchStringFilterSTR255String255
17StringFilter_1 SearchStringFilter[1]STR255String255
18StringFilter_2 SearchStringFilter[2]STR255String255
19IntegerFilter SearchIntegerFilterLI9_U0Long Integer9
20IntegerFilter_1 SearchIntegerFilter[1]LI9_U0Long Integer9
21IntegerFilter_2 SearchIntegerFilter[2]LI9_U0Long Integer9
22NumericFilter SearchNumericFilterDLR19_RBS5_TRCurrency19
23NumericFilter_1 SearchNumericFilter[1]DLR19_RBS5_TRCurrency19
24NumericFilter_2 SearchNumericFilter[2]DLR19_RBS5_TRCurrency19
25DateFilter SearchDateFilterDTDate8
26DateFilter_1 SearchDateFilter[1]DTDate8
27DateFilter_2 SearchDateFilter[2]DTDate8
28TimeFilter SearchTimeFilterTM6Time6
29TimeFilter_1 SearchTimeFilter[1]TM6Time6
30TimeFilter_2 SearchTimeFilter[2]TM6Time6
31EnumFilter SearchEnumFilterSTR255String255
32DEX_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)CompanyQueryDesigner_Conditions (CO00123)

Leave a Reply

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