Table: Companies
Primary Key: Company
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Company ID | Long | 4 | ✓ | |
| Company Name | Text | 255 | ||
| Employee Number Prefix | Text | 255 | ||
| Employee Number Length | Long | 4 | ||
| Export Company to Enguage | Boolean | 1 | ||
| Company Trading Name | Text | 255 | ||
| Company Registration Number | Text | 255 | ||
| VAT Number | Text | 255 | ||
| PAYE Reference Number | Text | 255 | ||
| COIDA Reference Number | Text | 255 | ||
| UIF Reference Number | Text | 255 | ||
| UIF Telephone Number | Text | 255 | ||
| UIF Contact Person | Text | 255 | ||
| SDL Number | Text | 255 | ||
| Physical Address 1 | Text | 255 | ||
| Physical Address 2 | Text | 255 | ||
| Physical Suburb | Text | 255 | ||
| Physical City | Text | 255 | ||
| Physical Postal Code | Text | 255 | ||
| Physical Province | Text | 255 | ||
| Physical Country | Text | 255 | ||
| Postal Address 1 | Text | 255 | ||
| Postal Address 2 | Text | 255 | ||
| Postal City | Text | 255 | ||
| Postal Code | Text | 255 | ||
| Postal Province | Text | 255 | ||
| Postal Country | Text | 255 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Companies$Physical Postal Code
- Companies$Postal Code
- Companies$PrimaryKey [PRIMARY KEY] [UNIQUE]