Definition of table site-note

Table Description

Table Dump Name: site-not

Alphabetical Field Summary

• cre-date: (DATE) Date of record creation
• cre-time: (CHAR) Time of record creation
• cre-user-name: (CHAR) Login name of user who created the record
• note-code-id: (INTG) Internally assigned note code ID
• note-date: (DATE) Date for this note
• note-flag: (LOGC) Yes or no for this note
• note-group-id: (INTG) Internally assigned note group ID
• note-seq: (INTG) Note sequence
• note-text: (CHAR) Text of this note
• site-id: (INTG) Products Sites ID
• upd-date: (DATE) Date of records last modification
• upd-time: (CHAR) Time of records last modification
• upd-user-name: (CHAR) Login name of user who last modified the record

Alphabetical Index Summary

• note-by-seq: site-id, note-seq
• site-note: (PRIMARY) site-id, note-group-id, note-code-id, note-date

Alphabetical Trigger Summary

• CREATE: Overridable, Procedure is tr-c-sin.p
• DELETE: Overridable, Procedure is tr-d-sin.p
• WRITE: Overridable, Procedure is tr-u-sin.p

Tables site-note references

• note-code - Note Codes, one per note group
• note-group - Note Groups
• site - Installed Sites

Detailed Alphabetical Field Listing

cre-time Data type: CHARACTER
Format: X(8)
Description: Time of record creation

cre-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who created the record

note-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned note code ID
Attributes: Index Component

note-date Data type: DATE
Format: 99/99/9999
Help: Date for this note
Attributes: Index Component

note-flag Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes or no for this note

note-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned note group ID
Attributes: Index Component

note-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Note sequence
Attributes: Index Component

note-text Data type: CHARACTER
Format: x(60)
Help: Text of this note

site-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Products Sites ID
Attributes: Index Component

upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of records last modification

upd-time Data type: CHARACTER
Format: X(8)
Description: Time of records last modification

upd-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who last modified the record

Created on 04/03/2003 by DBHTML V1.1c