WS_Notes_MSTR (WS00501)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: WS_Notes_MSTR
Physical Name: WS00501
Technical Name: WS_Notes_MSTR

Group Display Name: TimeTrack
Group Technical Name: TimeTrack

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['WS_Notes_MSTR'].NOTEINDX AS 'WS_Notes_MSTR-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WS00501 AS ['WS_Notes_MSTR']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['WS_Notes_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
3WS_Transaction_Type SearchWS Transaction TypeSTR10_LBAUString1210
4EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
5DATE1 SearchDateDT6Date46
6TIME1 SearchTimeTM6Time46
7Note_Author SearchNote AuthorSTR_20String2220
8Printable_Group SearchPrintable GroupGB_PrintableInteger20
9USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS_Notes_MSTR'].USERID AS 'WS_Notes_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS00501 AS ['WS_Notes_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_Notes_MSTR'].USERID = ['Users Master'].USERID
10Record_Notes SearchRecord NotesTX32000Text232000

Leave a Reply

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