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
1FieldsListGuidFieldsListGuidGUIDStringString3836
2ConditionsGuidConditionsGuidGUIDStringString3836
3SEQNUMBRSequence NumberLI_Sequence_NumberLong Integer410
4FromTableFromTableSTR80String8280
5FromFieldFromFieldSTR80String8280
6FromDictIDFromDictIDID_INTInteger24
7FromFieldListSequenceFromFieldListSequenceLI_Sequence_NumberLong Integer410
8ToTableToTableSTR80String8280
9ToFieldToFieldSTR80String8280
10ToDictIDToDictIDID_INTInteger24
11ToFieldListSequenceToFieldListSequenceLI_Sequence_NumberLong Integer410
12FieldDataTypeFieldDataTypeFieldDataTypeInteger20
13FieldComparisonFieldComparisonCBBoolean20
14QueryOperatorQueryOperatorDDLInteger20
15QueryConditonQueryConditonQueryConditonInteger20
16StringFilterStringFilterSTR255String256255
17StringFilter_1StringFilter[1]STR255String256255
18StringFilter_2StringFilter[2]STR255String256255
19IntegerFilterIntegerFilterLI9_U0Long Integer49
20IntegerFilter_1IntegerFilter[1]LI9_U0Long Integer49
21IntegerFilter_2IntegerFilter[2]LI9_U0Long Integer49
22NumericFilterNumericFilterDLR19_RBS5_TRCurrency1019
23NumericFilter_1NumericFilter[1]DLR19_RBS5_TRCurrency1019
24NumericFilter_2NumericFilter[2]DLR19_RBS5_TRCurrency1019
25DateFilterDateFilterDTDate48
26DateFilter_1DateFilter[1]DTDate48
27DateFilter_2DateFilter[2]DTDate48
28TimeFilterTimeFilterTM6Time46
29TimeFilter_1TimeFilter[1]TM6Time46
30TimeFilter_2TimeFilter[2]TM6Time46
31EnumFilterEnumFilterSTR255String256255
32DEX_ROW_IDintint1010

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 *