| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Codetype | varchar | 1 | Yes | |||
| CodeLabel | varchar | 20 | Yes | |||
| Code | varchar | 3 | Yes | |||
| Description | varchar | 30 | Yes | |||
| MaximumAllowableFare | money | Yes | ||||
| ServiceOverheadRate | money | Yes | ||||
| InvoiceType | varchar | 1 | Yes | |||
| DefaultDestination | varchar | 50 | Yes | |||
| DefaultZone | varchar | 6 | Yes | |||
| DefaultAmbTripcode | varchar | 3 | Yes | |||
| DefaultWCTripcodes | varchar | 3 | Yes | |||
| UseCashRates | bit | Yes | ||||
| UseCashFares | bit | Yes | ||||
| GenerateNewClientsServiceRequest | bit | Yes | ||||
| UseTripTickets | bit | Yes | ||||
| ClientMustPrePayService | bit | Yes | ||||
| ChargeFullFarePurposeCode | bit | Yes | ||||
| newfield2 | varchar | 1 | Yes | |||
| DefaultPickupTime | varchar | 5 | Yes | |||
| DefaultDestinationTime | varchar | 5 | Yes | |||
| SkipPostingforTripVerification | bit | Yes | ||||
| PostTripsAsVerified | bit | Yes | ||||
| Medcode | bit | Yes | ||||
| RequiresCMN | bit | Yes | ||||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_RevenueCodes | clustered, unique, primary key located on PRIMARY | ID |
| U_CodetypeCode | nonclustered, unique located on PRIMARY | Codetype, Code |