Collections – Notes (CN00100)

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

Product: Collections Management (1157)
Series: Sales

Display Name: Collections - Notes
Physical Name: CN00100
Technical Name: CN_Notes

Group Display Name: Collection Notes
Group Technical Name: CollectionNotes

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Collections - Notes'].CUSTNMBR AS 'Collections - Notes-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       CN00100 AS ['Collections - Notes']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Collections - Notes'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
3DATE1 SearchDateDT6Date46
4Contact_Date SearchContact DateDT_DateDate46
5TIME1 SearchTimeTM6Time46
6Contact_Time SearchContact TimeTM6Time46
7NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Collections - Notes'].NOTEINDX AS 'Collections - Notes-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CN00100 AS ['Collections - Notes']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Collections - Notes'].NOTEINDX = ['Record Notes Master'].NOTEINDX
8RevisionNumber SearchCN Revision NumberINT4Integer24
9CN_Group_Note SearchCN Group NoteCN_CB_Group_NoteBoolean20
10Caller_ID_String SearchCaller ID StringSTR15_LBAUString1615
11Action_Promised SearchAction PromisedAction PromisedString1816
12ActionType SearchAction TypeCN_Action_TypeInteger20
13Action_Date SearchAction DateDT_DateDate46
14Action_Assigned_To SearchAction Assigned ToSTR15_LBAUString1615
15Action_Completed SearchAction CompletedCB_Action_CompletedBoolean20
16ACTCMDSP SearchAction Completed Sort ByCB_Action_CompletedBoolean20
17Action_Completed_Date SearchAction Completed DateDATEDate46
18Action_Completed_Time SearchAction Completed TimeTM6Time46
19Amount_Promised SearchAmount PromisedDLR19_$S2Currency1019
20Amount_Received SearchAmount ReceivedDLR19_RBS0_UTR$Currency1019
21USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Collections - Notes'].USERID AS 'Collections - Notes-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CN00100 AS ['Collections - Notes']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Collections - Notes'].USERID = ['Users Master'].USERID
22Note_Display_String SearchNote Display StringNote Display StringString7270
23CNTCPRSN SearchContact PersonSTR60String6260
24ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
25USERDEF1 SearchUser Defined 1STR20String2220
26USERDEF2 SearchUser Defined 2STR20String2220
27USRDAT01 SearchUser Defined Date 1DTDate48
28PRIORT SearchNote PriorityDDL_CN_Note_PriorityInteger20
29NOTECAT SearchNote CategorySTR15String1615
30NoteStatus SearchNoteStatusNoteStatusDDLInteger20
31Action_Cancelled_By SearchAction Cancelled BySTR15_User_IDString1615
32Action_Cancelled_Date SearchAction Cancelled DateDT6Date46
33MODIFDT SearchModified DateDTDate48

Leave a Reply

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