Collections – Query Master (CN00600)

azurecurve Products Collections Management (1157)SalesCollections - Query Master (CN00600)

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
Physical Name: CN00600
Technical Name: CN_Query_MSTR

Group Display Name: Collection Query
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

azurecurve Products Collections Management (1157)SalesCollections - Query Master (CN00600)

Leave a Reply Cancel reply