Collections – Collector Master (CN01400)

azurecurveProductsCollections Management (1157)SystemCollections - Collector Master (CN01400)

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

Product: Collections Management (1157)
Series: System

Display Name: Collections - Collector Master
Physical Name: CN01400
Technical Name: CN_Collector_MSTR

Group Display Name: Collections - Collector Setup
Group Technical Name: CollectionCollectorSetup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CollectorID SearchCollector IDSTR15_LBAUString1615
2CollectorName SearchCollector NameSTR64String6664
3Position_Name SearchPosition NameSTR30String3230
4CN_Email_Address SearchCN Email AddressSTR60String6260
5CN_Collector_Phone1 SearchCN Collector Phone1STR25String2625
6CN_Collector_Phone2 SearchCN Collector Phone2STR25String2625
7CN_Collector_Fax SearchCN Collector FaxSTR25String2625
8CN_User_Defined1 SearchCN User Defined1STR50String5250
9CN_User_Defined2 SearchCN User Defined2STR50String5250
10CollectionsUser SearchCollections UserCB_Collections_UserBoolean20
11USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Collections - Collector Master'].USERID AS 'Collections - Collector Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CN01400 AS ['Collections - Collector Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Collections - Collector Master'].USERID = ['Users Master'].USERID
12PASSWORD SearchPasswordSTR15_LBString1615
13eCollectUser SearcheCollect UserCB_eCollectUserBoolean20
14Open_CollectPro_Main SearchOpen CollectPro MainCN_CB_OpenCollectProMainBoolean20
15Open_CollectPro_Query SearchOpen CollectPro QueryCN_CB_OpenCollectionQueryBoolean20
16Open_CollectPro_To_Do SearchOpen CollectPro To DoCN_CB_OpenCollectionsTasksBoolean20
17CN_Default_Action_Assign SearchCN Default Action Assign ToGBInteger20
18NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Collections - Collector Master'].NOTEINDX AS 'Collections - Collector Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CN01400 AS ['Collections - Collector Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Collections - Collector Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19CREATDDT SearchCreated DateDTDate48
20MODIFDT SearchModified DateDTDate48
21LSTUSRED SearchLast User to EditSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Collections - Collector Master'].LSTUSRED AS 'Collections - Collector Master-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CN01400 AS ['Collections - Collector Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Collections - Collector Master'].LSTUSRED = ['Users Master'].USERID
22CN_Signature_ID SearchCN_Signature_IDSTR15_LBAUString1615
23Refresh_Collections_Main SearchRefresh Collections MainCN_Refresh_Collections_MainBoolean20
24CN_Process_Plans SearchCN_Process_PlansCN_Process_Plans_CBBoolean20
25fileName SearchfileNameSTR255String256255
azurecurveProductsCollections Management (1157)SystemCollections - Collector Master (CN01400)

Leave a Reply

Your email address will not be published. Required fields are marked *