Collections – Notes History (CN30100)

azurecurveProductsCollections Management (1157)SalesCollections - Notes History (CN30100)

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

Product: Collections Management (1157)
Series: Sales

Display Name: Collections - Notes History
Physical Name: CN30100
Technical Name: CN_Notes_HIST

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 History'].CUSTNMBR AS 'Collections - Notes History-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       CN30100 AS ['Collections - Notes History']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Collections - Notes History'].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 History'].NOTEINDX AS 'Collections - Notes History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CN30100 AS ['Collections - Notes History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Collections - Notes History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
8RevisionNumber SearchCN Revision NumberINT4Integer24
9RevisionDate SearchCN Revision DateDATEDate46
10RevisionTime SearchCN Revision TimeTM6Time46
11CN_Group_Note SearchCN Group NoteCN_CB_Group_NoteBoolean20
12Caller_ID_String SearchCaller ID StringSTR15_LBAUString1615
13Action_Promised SearchAction PromisedAction PromisedString1816
14ActionType SearchAction TypeCN_Action_TypeInteger20
15Action_Date SearchAction DateDT_DateDate46
16Action_Assigned_To SearchAction Assigned ToSTR15_LBAUString1615
17Action_Completed SearchAction CompletedCB_Action_CompletedBoolean20
18Action_Completed_Date SearchAction Completed DateDATEDate46
19Action_Completed_Time SearchAction Completed TimeTM6Time46
20Amount_Promised SearchAmount PromisedDLR19_$S2Currency1019
21USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Collections - Notes History'].USERID AS 'Collections - Notes History-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CN30100 AS ['Collections - Notes History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Collections - Notes History'].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
azurecurveProductsCollections Management (1157)SalesCollections - Notes History (CN30100)

Leave a Reply

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