Alphabetical Field Summary
Alphabetical Index Summary
Alphabetical Trigger Summary
Other tables who reference site-fld-define
Tables site-fld-define references
cre-time Data type: CHARACTER
Format: x(8)
Description: Time record was created
cre-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user who created the record
data-type Data type: CHARACTER
Format: x(10) (Initial Value: Character)
Help: Char,Decimal,Date,Integer,Logical,Table,Note,Contact,Link,St
description Data type: CHARACTER
Format: x(28)
Help: Description of this site field
Attributes: Index Component
extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component
fld-format Data type: CHARACTER
Format: x(28) (Initial Value: x(8))
Help: Format of this field
fld-help Data type: CHARACTER
Format: x(63)
Help: Help message for this field
fld-label Data type: CHARACTER
Format: x(32)
Help: Label for this field
fld-view-as Data type: CHARACTER
Format: x(8) (Initial Value: FILL-IN)
Help: View this field as a FILL-IN or EDITOR
fld-width Data type: INTEGER
Format: z9 (Initial Value: 8)
Help: Width of the field on screen
journal-note-dates Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to auto-assign journalled note dates
journal-notes Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to journalize changes to the field value, No to keep onl
link-site-fld-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Site Fld ID this field is linked to
multi-values Data type: CHARACTER
Format: x(132)
Help: Values for multiple-choice fields (seperate items with comma
note-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Note Code ID to use when datatype is NOTE
note-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Note Group ID of associate group when datatype is NOTE
primary-key Data type: INTEGER
Format: zzzzzzzzz9
Help: Unique, Primary key for record
show-contact-part Data type: CHARACTER
Format: x(10)
Help: Part of contact to use (name,address1,city,state,phone,etc)
show-note-part Data type: CHARACTER
Format: x(8) (Initial Value: Comments)
Help: From note, show Comments, Date, Flag or Table
show-table-code Data type: LOGICAL
Format: Code/Desc (Initial Value: Yes)
Help: Select whether the table Code or Description should appear
show-table-level Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Which level of the table to show (0=Description)
site-fld-id Data type: INTEGER
Format: zzzzzzzzz9
Description: [DEFINE KEY]
Help: Internally assigned site field #
Attributes: Index Component
site-frame-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Associated site frame
Attributes: Index Component
state-item-id Data type: INTEGER
Format: zzzzzzzzz9
Help: State item that this field is associated with
Attributes: Index Component
table-name-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: ID of the table used for this field when datatype is TABLE
upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date record was last updated
upd-time Data type: CHARACTER
Format: x(8)
Description: Record last updated at
upd-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user record was updated by
Created on 12/28/2020 by DBHTML V1.2