Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN00600
Product: Collections Management (1157)
Series: Sales
Display Name: Collections - Query Master Group Display Name: Collection Query
Physical Name: CN00600
Technical Name: CN_Query_MSTR
Group Technical Name: CollectionQuery
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | Query_ID ![]() | Query ID | STR15_LBAU | String | 15 |
2 | Query_Description ![]() | Query Description | STR30 | String | 30 |
3 | STCUSTID ![]() | Start Customer ID | STR15_RM_Customer_Number | String | 15 |
4 | STCUSTNM ![]() | Start Customer Name | STR64_Customer_Name | String | 64 |
5 | STTCLSID ![]() | Start Class ID | STR15_LBAU | String | 15 |
6 | STTUDEF1 ![]() | Start User Defined 1 | STR20 | String | 20 |
7 | STSPRSID ![]() | Start Salesperson ID | STR15_LBAU | String | 15 |
8 | STSLSTER ![]() | Start Sales Territory | STR15_LBAU | String | 15 |
9 | StartPrefContactMethod ![]() | Start Preferred Contact Method | paDDLPreferredContactMethod | Integer | 0 |
10 | CNStartTimeZone ![]() | CN Start Time Zone | INT | Integer | 0 |
11 | STRTUDEF ![]() | Start User Defined | STR20 | String | 20 |
12 | STUDDAT1 ![]() | Start User Defined Date 1 | DATE | Date | 6 |
13 | STUDTAB1 ![]() | Start User Defined Table 1 | STR20 | String | 20 |
14 | ENCUSTID ![]() | End Customer ID | STR15_RM_Customer_Number | String | 15 |
15 | ENCSTNAM ![]() | End Customer Name | STR64_Customer_Name | String | 64 |
16 | ENDCLSID ![]() | End Class ID | STR15_LBAU | String | 15 |
17 | ENUSRDF1 ![]() | End User Defined 1 | STR20 | String | 20 |
18 | ENSPSNID ![]() | End Salesperson ID | STR15_LBAU | String | 15 |
19 | ENSLSTER ![]() | End Sales Territory | STR15_LBAU | String | 15 |
20 | CNEndTimeZone ![]() | CN End Time Zone | DDL_Time_Zone | Integer | 0 |
21 | EndPrefContactMethod ![]() | End Preferred Contact Method | paDDLPreferredContactMethod | Integer | 0 |
22 | ENUSRDEF ![]() | End User Defined | STR20 | String | 20 |
23 | ENDUDDT1 ![]() | End User Defined Date 1 | DATE | Date | 6 |
24 | ENDUDTBL ![]() | End User Defined Table 1 | STR20 | String | 20 |
25 | StartCreditControlCycle ![]() | CN Start Credit Control Cycle | CN_DDL_CreditControlCycle | Integer | 0 |
26 | EndCreditControlCyle ![]() | CN End Credit Control Cycle | CN_DDL_CreditControlCycle | Integer | 0 |
27 | CONNAACT ![]() | Consolidate National Account Activity | CB_Conslidate_NA_Activity | Boolean | 0 |
28 | DateSelection ![]() | Date Selection | INT1 | Integer | 1 |
29 | QRYSTCDTPER ![]() | Query Start Credit Limit Period | INT | Integer | 0 |
30 | QryEndCrLimitPeriod ![]() | Query End Credit Limit Period | INT | Integer | 0 |
31 | QRYSTCDTAMT ![]() | Query Start Credit Limit Amount | DLR17_QTY_RBS0_STR | Currency | 17 |
32 | QryEndCreditLimitAmt ![]() | Query End Credit Limit Amount | DLR17_RBSO_STR$ | Currency | 17 |
33 | QryStartDateToken ![]() | Query Start Date Token | CN_DDL_Date_Tokens | Integer | 0 |
34 | QryEndDateToken ![]() | Query End Date Token | CN_DDL_Date_Tokens | Integer | 0 |
35 | STRTNGDT ![]() | Starting Date | DT | Date | 8 |
36 | ENDINGDT ![]() | Ending Date | DT | Date | 8 |
37 | Starting_Trx_Days ![]() | Starting Trx Days | INT3 | Integer | 3 |
38 | Ending_Trx_Days ![]() | Ending Trx Days | INT3 | Integer | 3 |
39 | Start_Caller_ID ![]() | Start Caller ID | STR15_User_ID | String | 15 |
40 | Start_Contact_Date ![]() | Start Contact Date | DATE | Date | 6 |
41 | Start_Action_Assigned_To ![]() | Start Action Assigned To | STR15_User_ID | String | 15 |
42 | Start_Action_Promised ![]() | Start Action Promised | Action Promised | String | 16 |
43 | Start_Action_Date ![]() | Start Action Date | DATE | Date | 6 |
44 | SNOTPRTY ![]() | Start Note Priority | DDL | Integer | 0 |
45 | QRYACTCOM ![]() | Query Action Completed | INT | Integer | 0 |
46 | End_Caller_ID ![]() | End Caller ID | STR15_User_ID | String | 15 |
47 | End_Contact_Date ![]() | End Contact Date | DATE | Date | 6 |
48 | End_Action_Assigned_To ![]() | End Action Assigned To | STR15_User_ID | String | 15 |
49 | End_Action_Promised ![]() | End Action Promised | Action Promised | String | 16 |
50 | End_Action_Date ![]() | End Action Date | DATE | Date | 6 |
51 | ENOTPRTY ![]() | End Note Priority | DDL | Integer | 0 |
52 | QCMFLAG ![]() | Query Credit Manager Flag | Boolean | Boolean | 0 |
53 | Start_Credit_Manager ![]() | Start Credit Manager | STR15_LBAU | String | 15 |
54 | End_Credit_Manager ![]() | End Credit Manager | STR15_LBAU | String | 15 |
55 | CUSTCSTS ![]() | Customer Commitment Status | Customer Commitment Status | Integer | 0 |
56 | QueryBalanceReturned ![]() | Query Balance Returned | CN_DDL_BalanceReturned | Integer | 0 |
57 | QueryExcludeOlderBalance ![]() | Query Exclude Older Balances | CN_CBExcludeOlderBalances | Boolean | 0 |
58 | QryExcludeifPaymentMade ![]() | Query Exclude if Payment Made | CB | Boolean | 0 |
59 | QueryNumberofDays ![]() | Query Number of Days | INT3 | Integer | 3 |
60 | QueryNoteExists ![]() | Query Note Exists | CN_DDL_NoteExists | Integer | 0 |
61 | STUDTAB2 ![]() | Start User Defined Table 2 | STR20 | String | 20 |
62 | ENDUDTBL2 ![]() | End User Defined Table 2 | STR20 | String | 20 |
63 | USERLANG ![]() | User Language ID | INT | Integer | 0 |
64 | CN_Credit_LevelStart ![]() | Start CN Credit Level | CN_DDL_CreditLevel | Integer | 0 |
65 | CN_Credit_LevelEnd ![]() | End CN Credit Level | CN_DDL_CreditLevel | Integer | 0 |
66 | Query_Exclude_Partial_Pa ![]() | Query Exclude Partial Payments | Query Exclude Partial Payments CB | Boolean | 0 |
67 | CN_BalanceOverCreditLim ![]() | CN_BalanceOverCreditLimit | Boolean | Boolean | 0 |
68 | StartNoteStatus ![]() | StartNoteStatus | NoteStatusDDL | Integer | 0 |
69 | EndNoteStatus ![]() | EndNoteStatus | NoteStatusDDL | Integer | 0 |
70 | QueryInvoiceDocumentID ![]() | Query Invoice Document ID | STR15_LBAU | String | 15 |
71 | Start_Collection_Plan_ID ![]() | Start Collection Plan ID | STR15_LBAU | String | 15 |
72 | End_Collection_Plan_ID ![]() | End Collection Plan ID | STR15_LBAU | String | 15 |
73 | CN_Query_Type ![]() | CN_Query_Type | GB | Integer | 0 |
74 | TXTFIELD ![]() | Text Field | TX32000 | Text | 32000 |