Collections – Customer Info (CN00500)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN00500

Display Name: Collections - Customer Info
Physical Name: CN00500
Technical Name: CN_Customer_Info

Group Display Name: Collection Setup
Group Technical Name: CollectionSetup

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Collections - Customer Info'].CUSTNMBR AS 'Collections - Customer Info-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM CN00500 AS ['Collections - Customer Info'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Collections - Customer Info'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	CRDTMGR	Credit Manager	STR15_LBAU	String	15
3	PreferredContactMethod	Preferred Contact Method	paDDLPreferredContactMethod	Integer	0
4	NOMAIL	No Mail Merge	CN_NoMailMerge	Boolean	0
5	ADRSCODE	Address Code	STR15_Address_Code	String	15
6	Time_Zone	Time Zone	DDL_Time_Zone	Integer	0
7	CN_Credit_Control_Cycle	CN Credit Control Cycle	CN_DDL_CreditControlCycle	Integer	0
8	USRTAB01	User Defined Table 1	STR20	String	20
9	USRTAB09	User Defined Table 2	STR20	String	20
10	USERDEF1	User Defined 1	STR20	String	20
11	USERDEF2	User Defined 2	STR20	String	20
12	USRDAT01	User Defined Date 1	DT	Date	8
13	User_Defined_CB1	User Defined CB1	User Defined CB	Boolean	0
14	User_Defined_CB2	User Defined CB2	User Defined CB	Boolean	0
15	CollectionPlanID	CollectionPlanID	STR15_LBAU	String	15
16	Action_Promised	Action Promised	Action Promised	String	16