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 |