QueryDesigner_Conditions (CO00123)

Easily find this page again using the shortlink: http://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 TypeSQL DB LengthKeyable Length
1FieldsListGuid SearchFieldsListGuidGUIDStringString3836
2ConditionsGuid SearchConditionsGuidGUIDStringString3836
3SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
4FromTable SearchFromTableSTR80String8280
5FromField SearchFromFieldSTR80String8280
6FromDictID SearchFromDictIDID_INTInteger24
7FromFieldListSequence SearchFromFieldListSequenceLI_Sequence_NumberLong Integer410
8ToTable SearchToTableSTR80String8280
9ToField SearchToFieldSTR80String8280
10ToDictID SearchToDictIDID_INTInteger24
11ToFieldListSequence SearchToFieldListSequenceLI_Sequence_NumberLong Integer410
12FieldDataType SearchFieldDataTypeFieldDataTypeInteger20
13FieldComparison SearchFieldComparisonCBBoolean20
14QueryOperator SearchQueryOperatorDDLInteger20
15QueryConditon SearchQueryConditonQueryConditonInteger20
16StringFilter SearchStringFilterSTR255String256255
17StringFilter_1 SearchStringFilter[1]STR255String256255
18StringFilter_2 SearchStringFilter[2]STR255String256255
19IntegerFilter SearchIntegerFilterLI9_U0Long Integer49
20IntegerFilter_1 SearchIntegerFilter[1]LI9_U0Long Integer49
21IntegerFilter_2 SearchIntegerFilter[2]LI9_U0Long Integer49
22NumericFilter SearchNumericFilterDLR19_RBS5_TRCurrency1019
23NumericFilter_1 SearchNumericFilter[1]DLR19_RBS5_TRCurrency1019
24NumericFilter_2 SearchNumericFilter[2]DLR19_RBS5_TRCurrency1019
25DateFilter SearchDateFilterDTDate48
26DateFilter_1 SearchDateFilter[1]DTDate48
27DateFilter_2 SearchDateFilter[2]DTDate48
28TimeFilter SearchTimeFilterTM6Time46
29TimeFilter_1 SearchTimeFilter[1]TM6Time46
30TimeFilter_2 SearchTimeFilter[2]TM6Time46
31EnumFilter SearchEnumFilterSTR255String256255
32DEX_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.

Leave a Reply

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