| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| KEYNUM | numeric | Yes | ||||
| DRIVE | varchar | 20 | Yes | |||
| EXP1 | numeric | Yes | ||||
| EXP2 | numeric | Yes | ||||
| EXP3 | numeric | Yes | ||||
| CMP1 | numeric | Yes | ||||
| CMP2 | numeric | Yes | ||||
| CMP3 | numeric | Yes | ||||
| EXT | varchar | 3 | Yes | |||
| COLOR1 | numeric | Yes | ||||
| COLOR2 | numeric | Yes | ||||
| COLOR3 | numeric | Yes | ||||
| COLOR4 | numeric | Yes | ||||
| COLOR5 | numeric | Yes | ||||
| COLOR6 | numeric | Yes | ||||
| OPSYS | varchar | 8 | Yes | |||
| HELPON | varchar | 1 | Yes | |||
| ALTID | varchar | 3 | Yes | |||
| CROSSREF1 | varchar | 25 | Yes | |||
| CROSSREF2 | varchar | 25 | Yes | |||
| CROSSREF3 | varchar | 25 | Yes | |||
| CLTIDNUM | numeric | Yes | ||||
| PICKUPD | varchar | 1 | Yes | |||
| BILLUPD | varchar | 1 | Yes | |||
| MAIDA | varchar | 3 | Yes | |||
| MAIDF | varchar | 3 | Yes | |||
| MAIDP | varchar | 3 | Yes | |||
| ALTA | varchar | 3 | Yes | |||
| ALTF | varchar | 3 | Yes | |||
| ALTP | varchar | 3 | Yes | |||
| TRAVEL | numeric | Yes | ||||
| MAXTRAVEL | numeric | Yes | ||||
| TRAN | numeric | Yes | ||||
| procdate | numeric | Yes | ||||
| PROCOPT1 | varchar | 1 | Yes | |||
| PROCOPT2 | varchar | 1 | Yes | |||
| PROCOPT3 | varchar | 1 | Yes | |||
| SRIWRT | varchar | 1 | Yes | |||
| BILLNOSHOW | varchar | 1 | Yes | |||
| PZONES | numeric | Yes | ||||
| DZONES | numeric | Yes | ||||
| MATCH | numeric | Yes | ||||
| USEWIN | varchar | 1 | Yes | |||
| PPMINUT | numeric | Yes | ||||
| PMMINUT | numeric | Yes | ||||
| DPMINUT | numeric | Yes | ||||
| DMMINUT | numeric | Yes | ||||
| USEZONASN | varchar | 1 | Yes | |||
| AUTOCAP | varchar | 1 | Yes | |||
| ROUTINE | varchar | 1 | Yes | |||
| PSTIME1 | varchar | 5 | Yes | |||
| PETIME1 | varchar | 5 | Yes | |||
| PSTIME2 | varchar | 5 | Yes | |||
| PETIME2 | varchar | 5 | Yes | |||
| shareflag | varchar | 1 | Yes | |||
| tripcode | varchar | 30 | Yes | |||
| numveh | numeric | Yes | ||||
| GRPSEL | varchar | 1 | Yes | |||
| GRP1CODE | varchar | 6 | Yes | |||
| GRP2CODE | varchar | 6 | Yes | |||
| INVOICE | numeric | Yes | ||||
| AGENCY | varchar | 3 | Yes | |||
| FUNDING | varchar | 3 | Yes | |||
| PURPOSE | varchar | 3 | Yes | |||
| rankareas | varchar | 1 | Yes | |||
| RECNUM | numeric | Yes | ||||
| RESETTBS | varchar | 1 | Yes | |||
| AMBDWELL | numeric | Yes | ||||
| WCDWELL | numeric | Yes | ||||
| DEMANDDEL | varchar | 1 | Yes | |||
| PEAKMPH | numeric | Yes | ||||
| NPEAKMPH | numeric | Yes | ||||
| SHIFT | varchar | 1 | Yes | |||
| nopause | varchar | 1 | Yes | |||
| VEHASSNSCN | varchar | 1 | Yes | |||
| BROKER | varchar | 1 | Yes | |||
| cltscn | varchar | 1 | Yes | |||
| reqscn | varchar | 1 | Yes | |||
| TRIPSHR | numeric | Yes | ||||
| DEFSTATE | varchar | 2 | Yes | |||
| region | varchar | 4 | Yes | |||
| WAITDISP | varchar | 1 | Yes | |||
| PEAKMPZ | numeric | Yes | ||||
| NPEAKMPZ | numeric | Yes | ||||
| PCATC | varchar | 3 | Yes | |||
| APPCITY | varchar | 1 | Yes | |||
| PROFILE | varchar | 20 | Yes | |||
| PROMPTPRT | varchar | 1 | Yes | |||
| CUSVMAN | varchar | 1 | Yes | |||
| AUTOAN | varchar | 1 | Yes | |||
| ESCORTTC | varchar | 3 | Yes | |||
| LASTJUDP | numeric | Yes | ||||
| REVJDATE | numeric | Yes | ||||
| VERSION | varchar | 4 | Yes | |||
| SPANUM | numeric | Yes | ||||
| EPANUM | numeric | Yes | ||||
| AUTOANCS | varchar | 1 | Yes | |||
| RECORQMN | varchar | 1 | Yes | |||
| DEFCODE | varchar | 2 | Yes | |||
| PICKUPDN | varchar | 1 | Yes | |||
| BILLUPDN | varchar | 1 | Yes | |||
| REQAVEHV | varchar | 1 | Yes | |||
| DESTPOP | varchar | 1 | Yes | |||
| AUTODATE | datetime | Yes | ||||
| RESTRICT | varchar | 1 | Yes | |||
| PICKINFO2 | varchar | 1 | Yes | |||
| POSTSUSP | varchar | 1 | Yes | |||
| DemandDeleteDays | numeric | Yes | ||||
| ClientNotesFolder | varchar | 100 | Yes | |||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_SystemParameters | clustered, unique, primary key located on PRIMARY | ID |