PRODUCT Table
Contains products.
| Field | Data Type | Description |
|---|---|---|
|
LABCODE |
Variable string (10) |
Laboratory code. |
|
PRODUCTCODE |
Variable string (20) |
Code for the product. |
|
DESCRIPTION |
Variable string (40) |
Description of the product. |
|
NOTESFILE |
Variable string (80) |
URL of a file containing notes on the product. |
|
PRODUCTDATE |
Date-time |
Date-time the product limits were last revised. |
|
USERFIELD1..USERFIELD20 |
Variable string (n) |
Extra site-specific fields accessed via a customised screen. |
Primary key
LABCODE + PRODUCTCODE
