Definition of table product-version

Table Description

Version of the product

Table Dump Name: prod-vrs

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
expected-release-date: (CHAR) Expected release date, if any, for this verion (Q3 99, etc)
product-id: (INTG) Product ID this version is associated with
release-date: (DATE) Actual date this version was released
released: (LOGC) Yes if this version has been released
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
version-id: (INTG) Version ID for this version
version-name: (CHAR) Name of this version
version-order: (INTG) Order of this version in relation to others of this product

Alphabetical Index Summary

product-version: (UNIQUE, PRIMARY) product-id, version-id
version-name: product-id, version-name, version-order
version-order: product-id, version-order, version-id

Alphabetical Trigger Summary

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

Other tables who reference product-version

dev-request - A request of development for resources to fix a bug and/or e
site-product - Products Installed at a site

Tables product-version references

product - (no description available)
site-product - Products Installed at a site

Detailed Alphabetical Field Listing

cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of record creation

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

expected-release-date Data type: CHARACTER
Format: x(32) (Initial Value: Unannounced)
Help: Expected release date, if any, for this verion (Q3 99, etc)

product-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Product ID this version is associated with
Attributes: Index Component

release-date Data type: DATE
Format: 99/99/9999
Help: Actual date this version was released

released Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this version has been released

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

version-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Version ID for this version
Attributes: Index Component

version-name Data type: CHARACTER
Format: X(8)
Help: Name of this version
Attributes: Index Component

version-order Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Order of this version in relation to others of this product
Attributes: Index Component