Definition of table state-item

Describes a reportable element , Table Dump Name stat-itm

Alphabetical Field Summary

auto-copy: (LOGC) 'Yes' if field is copied from another database, 'No' if buil

bidirectional-element: (LOGC) 'Yes' if changes are pushed back to the originating database

build-ip-name: (CHAR) Builder IP for this field, if not default

comments: (CHAR) Comments for/about this entry

cre-date: (DATE) Date this record was created

cre-time: (CHAR) Time this record was created

cre-user-name: (CHAR) Name of user who created this record

default-value: (CHAR) Default value, if any, for the element

edit-ip-name: (CHAR) Editor IP for this field, if not default

export-ip-name: (CHAR) Export IP for this field, if not default

extern-guid: (CHAR) External Global Unique ID for this record

state-element-code: (CHAR) Code for this state element

state-item-description: (CHAR) Description of this state item

state-item-format: (CHAR) Format mask

state-item-help: (CHAR) Help text value for this field

state-item-id: (INTG) Index Component

state-item-label: (CHAR) Label for this state-item

state-item-multi-list: (CHAR) Comma separated list of possible values for this item

state-item-type: (CHAR) What kind of item is this?

state-item-width: (INTG) Screen width of this item

state-table-name-id: (INTG) Index Component

state-version-id: (INTG) Internally Assigned ID

tag-end: (CHAR) Export tag for the end of this record

tag-start: (CHAR) Export tag to mark the start of this record

upd-date: (DATE) Date this record was last updated on

upd-time: (CHAR) Date this record was last updated

upd-user-name: (CHAR) Name of user who last updated this record

user-editable: (LOGC) 'Yes' if user is allowed to change this record after build

Alphabetical Index Summary

description: state-version-id, state-item-description, state-table-name-id

element-code: state-version-id, state-element-code, state-item-id

extern-guid: extern-guid

state-item-id: (UNIQUE, PRIMARY) state-version-id, state-item-id

state-table-name: state-version-id, state-table-name-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-sit.p

DELETE: Overridable, Procedure is tr-d-sit.p

WRITE: Overridable, Procedure is tr-u-sit.p

Other tables who reference state-item

extracted-item - Describes an 'extracted' item for export

state-record-item - Link between a state-item and a state-record

Tables state-item references

state-table-name - State table names

state-version - Date versioning

Detailed Alphabetical Field Listing
auto-copy Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: 'Yes' if field is copied from another database, 'No' if buil

bidirectional-element Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: 'Yes' if changes are pushed back to the originating database

build-ip-name Data type: CHARACTER
Format: x(32)
Help: Builder IP for this field, if not default

comments Data type: CHARACTER
Format: x(60)
Help: Comments for/about this entry

cre-date Data type: DATE
Format: 99/99/99
Help: Date this record was created

cre-time Data type: CHARACTER
Format: x(8)
Help: Time this record was created

cre-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who created this record

default-value Data type: CHARACTER
Format: x(30)
Help: Default value, if any, for the element

edit-ip-name Data type: CHARACTER
Format: x(32)
Help: Editor IP for this field, if not default

export-ip-name Data type: CHARACTER
Format: x(32)
Help: Export IP for this field, if not default

extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component

state-element-code Data type: CHARACTER
Format: x(16)
Help: Code for this state element
Attributes: Index Component

state-item-description Data type: CHARACTER
Format: x(28)
Help: Description of this state item
Attributes: Index Component

state-item-format Data type: CHARACTER
Format: x(16)
Description: Format mask
Help: Format for this item, when it is displayed on a report

state-item-help Data type: CHARACTER
Format: x(60)
Description: Help text value for this field
Help: What to display for help with prompting a user for a value

state-item-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Index Component
Help: Internally assigned item id
Attributes: Index Component

state-item-label Data type: CHARACTER
Format: x(16)
Help: Label for this state-item

state-item-multi-list Data type: CHARACTER
Format: x(60)
Help: Comma separated list of possible values for this item

state-item-type Data type: CHARACTER
Format: x(7)
Description: What kind of item is this?
Help: Item type (date, char, logical, integer, decimal, table, mul

state-item-width Data type: INTEGER
Format: zzz9 (Initial Value: 8)
Description: Screen width of this item
Help: How wide should this field appear on the screen?

state-table-name-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Index Component
Help: Table that this state item is associated with
Attributes: Index Component

state-version-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally Assigned ID
Attributes: Index Component

tag-end Data type: CHARACTER
Format: x(32)
Help: Export tag for the end of this record

tag-start Data type: CHARACTER
Format: x(32)
Help: Export tag to mark the start of this record

upd-date Data type: DATE
Format: 99/99/99
Help: Date this record was last updated on

upd-time Data type: CHARACTER
Format: x(8)
Help: Date this record was last updated

upd-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who last updated this record

user-editable Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: 'Yes' if user is allowed to change this record after build

Created on 11/14/2011 by DBHTML V1.2