The note table in the onpload database

The note table holds comments that you can store about the components that are used for loads and unloads. You can store notes about all of the onpload components: projects, devices, formats, maps, queries, filters, and load and unload jobs.

Column Type Description
type CHAR(18) Specifies the type of component to which this note is attached
formid INTEGER Corresponds to the formid of the component specified in the type column (The two columns together uniquely identify the component to which the note is attached.)
projectid INTEGER ID of project to which this note belongs (foreign key to the project table)
createdate DATE Date that the note was created
modifydate DATE Date that the note was last modified
note TEXT Text of the note

Copyright© 2018 HCL Technologies Limited