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 TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NumberString15
3DATE1 SearchDateDT6Date6
4Contact_Date SearchContact DateDT_DateDate6
5TIME1 SearchTimeTM6Time6
6Contact_Time SearchContact TimeTM6Time6
7NOTEINDX SearchNote IndexDLR14Currency14
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 NumberINT4Integer4
9CN_Group_Note SearchCN Group NoteCN_CB_Group_NoteBoolean0
10Caller_ID_String SearchCaller ID StringSTR15_LBAUString15
11Action_Promised SearchAction PromisedAction PromisedString16
12ActionType SearchAction TypeCN_Action_TypeInteger0
13Action_Date SearchAction DateDT_DateDate6
14Action_Assigned_To SearchAction Assigned ToSTR15_LBAUString15
15Action_Completed SearchAction CompletedCB_Action_CompletedBoolean0
16ACTCMDSP SearchAction Completed Sort ByCB_Action_CompletedBoolean0
17Action_Completed_Date SearchAction Completed DateDATEDate6
18Action_Completed_Time SearchAction Completed TimeTM6Time6
19Amount_Promised SearchAmount PromisedDLR19_$S2Currency19
20Amount_Received SearchAmount ReceivedDLR19_RBS0_UTR$Currency19
21USERID SearchUser IDSTR15_User_IDString15
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 StringString70
23CNTCPRSN SearchContact PersonSTR60String60
24ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
25USERDEF1 SearchUser Defined 1STR20String20
26USERDEF2 SearchUser Defined 2STR20String20
27USRDAT01 SearchUser Defined Date 1DTDate8
28PRIORT SearchNote PriorityDDL_CN_Note_PriorityInteger0
29NOTECAT SearchNote CategorySTR15String15
30NoteStatus SearchNoteStatusNoteStatusDDLInteger0
31Action_Cancelled_By SearchAction Cancelled BySTR15_User_IDString15
32Action_Cancelled_Date SearchAction Cancelled DateDT6Date6
33MODIFDT SearchModified DateDTDate8

Leave a Reply

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