Notes

Notes

tp_Notes - tp_Notes

Object: Simple tables

Field

Name

Description

note_ID

Notes ID

note_nttp_ID

Note type

Note type. Link to tp_NoteTypes (Note types)

note_Item_ID

A note can link to an object or to an object specification item. If this is a link to an object, the value in this field must be equal to note_obj_ID. Otherwise, it is a link to an object specification item. The object itself is specified in note_obj_ID.

note_obj_ID

Object

ID of a specific object, to which the note belongs

note_tpsyso_ID

Object type associated with the note. Link to tpsys_Objects (Replication objects)

note_Date

Date

Note generation date

note_Value

Value

Note value. Can be of any type - numeric, string, link to an object, etc.