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
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | FieldsListGuid | FieldsListGuid | String | GUIDString | 36 |
2 | ConditionsGuid | ConditionsGuid | String | GUIDString | 36 |
3 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 |
4 | FromTable | FromTable | String | STR80 | 80 |
5 | FromField | FromField | String | STR80 | 80 |
6 | FromDictID | FromDictID | Integer | ID_INT | 4 |
7 | FromFieldListSequence | FromFieldListSequence | Long Integer | LI_Sequence_Number | 10 |
8 | ToTable | ToTable | String | STR80 | 80 |
9 | ToField | ToField | String | STR80 | 80 |
10 | ToDictID | ToDictID | Integer | ID_INT | 4 |
11 | ToFieldListSequence | ToFieldListSequence | Long Integer | LI_Sequence_Number | 10 |
12 | FieldDataType | FieldDataType | Integer | FieldDataType | 0 |
13 | FieldComparison | FieldComparison | Boolean | CB | 0 |
14 | QueryOperator | QueryOperator | Integer | DDL | 0 |
15 | QueryConditon | QueryConditon | Integer | QueryConditon | 0 |
16 | StringFilter | StringFilter | STR255 | String | 255 |
17 | StringFilter_1 | StringFilter[1] | String | STR255 | 255 |
18 | StringFilter_2 | StringFilter[2] | String | STR255 | 255 |
19 | IntegerFilter_1 | IntegerFilter[1] | Long Integer | LI9_U0 | 9 |
20 | IntegerFilter_2 | IntegerFilter[2] | Long Integer | LI9_U0 | 9 |
21 | IntegerFilter | IntegerFilter | LI9_U0 | Long Integer | 9 |
22 | NumericFilter_1 | NumericFilter[1] | Currency | DLR19_RBS5_TR | 19 |
23 | NumericFilter_2 | NumericFilter[2] | Currency | DLR19_RBS5_TR | 19 |
24 | DateFilter_1 | DateFilter[1] | Date | DT | 8 |
25 | NumericFilter | NumericFilter | DLR19_RBS5_TR | Currency | 19 |
26 | DateFilter_2 | DateFilter[2] | Date | DT | 8 |
27 | TimeFilter_1 | TimeFilter[1] | Time | TM6 | 6 |
28 | DateFilter | DateFilter | DT | Date | 8 |
29 | TimeFilter_2 | TimeFilter[2] | Time | TM6 | 6 |
30 | EnumFilter | EnumFilter | String | STR255 | 255 |
31 | TimeFilter | TimeFilter | TM6 | Time | 6 |