Table CGroup
Purpose
Kit creation order.
Field definitions in table CGroup
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | ARTCODE | VARCHAR(50) | N | Master article code |
| 2 | Y | QTY | NUMERIC(0,18) | N | Quantity to be created |
| 3 | Y | STOCKCODE | VARCHAR(50) | N | Stock type (must be 75) |
| 4 | Y | CREATIONDATE | VARCHAR(50) | N | Creation date of record |
| 5 | Y | SUPPLIER | VARCHAR(50) | N | Supplier code |
| 6 | Y | SUPPLIERID | NUMERIC(0,18) | N | Supplier ID |
| 7 | Y | PCNAME | VARCHAR(50) | N | Name of user that created the record |
| 8 | Y | COMMENTS | VARCHAR(50) | N | Comments |
| 9 | Y | StockOperated | VARCHAR(1) | N | ? Default 'Y' |
| 10 | Y | ReadyQTY | INT | N | Quantity ready ? |
| 11 | Y | MLotNo | VARCHAR(50) | N | ? |
| 12 | Y | MExpiryDate | TIMESTAMP | N | Expiry date for the kit |
| 13 | Y | ID | NUMERIC(0,18) | N | Unique ID for the record |