Definition of table state-table-code

State table codes , Table Dump Name stat-tbc

Alphabetical Field Summary

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

description: (CHAR) Description of this table code entry

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

level-data[10]: (CHAR) Enter the level related data

state-table-code-id: (INTG) Internally assigned table code ID

state-table-code-order: (INTG) Order you would like the code displayed on the screen list

state-table-name-id: (INTG) Table name this table code belongs to

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

table-code: (CHAR) Name of this table code entry

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

Alphabetical Index Summary

extern-guid: extern-guid

state-table-code: (UNIQUE, PRIMARY) state-version-id, state-table-name-id, state-table-code-id

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

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

Alphabetical Trigger Summary

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

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

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

Other tables who reference state-table-code

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

Tables state-table-code references

state-table-name - State table names

state-version - Date versioning

Detailed Alphabetical Field Listing
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

description Data type: CHARACTER
Format: x(28)
Help: Description of this table code entry

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

level-data Data type: CHARACTER (Extent: 10)
Format: x(28)
Help: Enter the level related data

state-table-code-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Internally assigned table code ID
Attributes: Index Component

state-table-code-order Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Order you would like the code displayed on the screen list
Attributes: Index Component

state-table-name-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Table name this table code belongs to
Attributes: Index Component

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

table-code Data type: CHARACTER
Format: x(8)
Help: Name of this table code entry
Attributes: Index Component

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

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