WS_Notes_MSTR_HIST (WS30501)

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

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

Display Name: WS_Notes_MSTR_HIST
Physical Name: WS30501
Technical Name: WS_Notes_MSTR_HIST

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_HIST'].NOTEINDX AS 'WS_Notes_MSTR_HIST-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WS30501 AS ['WS_Notes_MSTR_HIST']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['WS_Notes_MSTR_HIST'].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_HIST'].USERID AS 'WS_Notes_MSTR_HIST-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS30501 AS ['WS_Notes_MSTR_HIST']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_Notes_MSTR_HIST'].USERID = ['Users Master'].USERID
10Record_Notes SearchRecord NotesTX32000Text232000

Leave a Reply

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