Great Plains version 6.0 employee notes field

[ldesantis]

Can anyone tell me what table the notes field is in from the \Cards\Human Resources\Employee\Employee\Employee Maintenance screen? Thanks.

 

[winthropdc]

All Record Level Notes are stored in the SY_Record_Notes_MSTR (SY03900) table and use the Note Index field in the main table as the link.

In your case the 'Note Index' of table UPR_MSTR (UPR00100.NOTEINDX).

If using the Report Writer, you can either add the Record Notes Master table using a relationship based on the Note Index field or use the RW_GetNoteText function from User defined functions under calculated fields.


RW_GetNoteText

Module:
System Manager

Series:
System

Script type:
Global function

Form (If a form global):


Category:
Data Retrieval

Description:
Returns Note Text field as strings of given length for the specified Note Index.
Prerequisites:
none

Parameters:
in currency IN_NoteIndex. { Note Index of Note }
in integer IN_characters. { Number of Characters per Line }
in integer IN_line. { Line Number to Return }

Return Value:
function returns string OUT_string.


David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.