Table Suppliers
Purpose
List of suppliers.
Field definitions in table Suppliers
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | NAME | VARCHAR(50) | N | Unique name for supplier |
| 2 | Y | NAME2 | VARCHAR(50) | N | Description |
| 3 | Y | STREET | VARCHAR(50) | N | Address: Street |
| 4 | Y | POSTCODE | VARCHAR(50) | N | Address: ZIP code |
| 5 | Y | TOWN | VARCHAR(50) | N | Address: Town |
| 6 | Y | PCNAME | VARCHAR(50) | N | User that created the record. |
| 7 | Y | FILLDATE | VARCHAR(20) | N | Date record is created |
| 8 | Y | TEL | VARCHAR(100) | N | Telephone nummer |
| 9 | Y | FAX | VARCHAR(100) | N | Fax number |
| 10 | Y | VARCHAR(50) | N | Contact email address | |
| 11 | Y | PERSON | VARCHAR(100) | N | Contact person name |
| 12 | Y | ID | VARCHAR(50) | Y | ? Uniek ID (timestamp) |
| 13 | Y | SUPPLIERNO | VARCHAR(50) | N | ? Uniek ID (timestamp) |
| 14 | Y | SQPK | INT | N | Sequence (ordering in display) |
| 15 | N | MonthsBeforeExpiry | NUMERIC(0,18) | N | |
| 16 | Y | ActivateReturnMenu | VARCHAR(1) | N | Used in return screen: returns allowed or not ? |