!!!Alias: MNO
(P2K_AM_NOTES)

Unique Keys: Note

ERD: [ERD-AM30]

Notes

!!Table Columns

||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[MTD_ID]|Number(10)|[ID]| |link to [P2K_AM_TABLE_DETAILS]
|[MUS_ID]|Number(10)|[ID]|Y|link to [P2K_AM_USERS]
|[MNT_ID]|Number(10)|[ID]| |link to [P2K_AM_NOTE_TYPES]
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[REFERENCE_ID]|Number(10)|[NUMBER10|NUMBERn]|Y|
|[NOTE_TEXT]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]|Y|
|[NOTE_START_DATE]|Date()|[DATE]| |
|[NOTE_END_DATE]|Date()|[DATE]| |
|[FILE_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[EDITOR]|Varchar2(2)|[X_EDITOR]| |
|[PRIVATE_ITEM]|Varchar2(1)|[TOGGLE]| |
|[SUBJECT_REF_ID]|Number(10)|[NUMBER10|NUMBERn]| |

!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_CONTEXT]

User Fields: Not Allowed\\
Audit Logging: Not Allowed\\


----
![Notes|Edit:Internal.P2K_AM_NOTES] 	
[{InsertPage page='Internal.P2K_AM_NOTES' default='Click to create a new notes page'}]