Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN40500
Product: Collections Management (1157)
Series: Sales
Display Name: Collections - Security SETP Group Display Name: Collection Setup
Physical Name: CN40500
Technical Name: CN_Security_SETP
Group Technical Name: CollectionSetup
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | USERID  | User ID | STR15_User_ID | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Collections - Security SETP'].USERID AS 'Collections - Security SETP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CN40500 AS ['Collections - Security SETP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Collections - Security SETP'].USERID = ['Users Master'].USERID | ||||||
| 2 | Allow_ED_Notes_Others | Restrict Edit Others Notes | CB_Edit_Others_Notes | Boolean | 0 | |
| 3 | Allow_ED_Notes_User | Restrict Edit Own Notes | CB_Restrict_Edit_Own_Notes | Boolean | 0 | |
| 4 | Allow_View_Only_Own_Note | Restrict View Others Notes | CB_View_Others_Notes | Boolean | 0 | |
| 5 | Open_CollectPro_Main | Open CollectPro Main | CN_CB_OpenCollectProMain | Boolean | 0 | |
| 6 | Open_CollectPro_Query | Open CollectPro Query | CN_CB_OpenCollectionQuery | Boolean | 0 | |
| 7 | Open_CollectPro_To_Do | Open CollectPro To Do | CN_CB_OpenCollectionsTasks | Boolean | 0 | |
| 8 | STCUSTID | Start Customer ID | STR15_RM_Customer_Number | String | 15 | |
| 9 | STCUSTNM | Start Customer Name | STR64_Customer_Name | String | 64 | |
| 10 | STTCLSID | Start Class ID | STR15_LBAU | String | 15 | |
| 11 | STTUDEF1 | Start User Defined 1 | STR20 | String | 20 | |
| 12 | STSPRSID | Start Salesperson ID | STR15_LBAU | String | 15 | |
| 13 | STSLSTER | Start Sales Territory | STR15_LBAU | String | 15 | |
| 14 | Start_Credit_Manager | Start Credit Manager | STR15_LBAU | String | 15 | |
| 15 | ENCUSTID | End Customer ID | STR15_RM_Customer_Number | String | 15 | |
| 16 | ENCSTNAM | End Customer Name | STR64_Customer_Name | String | 64 | |
| 17 | ENDCLSID | End Class ID | STR15_LBAU | String | 15 | |
| 18 | ENUSRDF1 | End User Defined 1 | STR20 | String | 20 | |
| 19 | ENSPSNID | End Salesperson ID | STR15_LBAU | String | 15 | |
| 20 | ENSLSTER | End Sales Territory | STR15_LBAU | String | 15 | |
| 21 | End_Credit_Manager | End Credit Manager | STR15_LBAU | String | 15 | |
| 22 | CN_Email_Address | CN Email Address | STR60 | String | 60 | |
| 23 | Position_Name | Position Name | STR30 | String | 30 | |