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 |