Definition of table product

No table description available

Table Dump Name: product

Alphabetical Field Summary

• comments: (CHAR)
• 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
• product-description: (CHAR) Description of this Product
• product-id: (INTG) Internally assigned Product ID code
• product-shortname: (CHAR) Shorthand Name for product (for browsers/listers)
• release-date: (DATE) Date product was released
• released: (LOGC) Yes if Product has been released for distribution/use
• 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: (CHAR) Version of this product

Alphabetical Index Summary

• product-description: product-description
• product-id: (UNIQUE, PRIMARY) product-id

Alphabetical Trigger Summary

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

Other tables who reference product

• call-browse - Denormalized Call Log Browsing table
• call-log - Log of customer calls
• component - Product Components
• dev-request - A request of development for resources to fix a bug and/or e
• product-version - Version of the product
• site-product - Products Installed at a site

Tables product references

• 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

product-description Data type: CHARACTER
Format: x(32)
Help: Description of this Product
Attributes: Index Component

product-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Product ID code
Attributes: Index Component

product-shortname Data type: CHARACTER
Format: x(8)
Help: Shorthand Name for product (for browsers/listers)

release-date Data type: DATE
Format: 99/99/9999
Help: Date product was released

released Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if Product has been released for distribution/use

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 Data type: CHARACTER
Format: X(8)
Help: Version of this product

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