FS
FSRoute
PX.Objects.FS51 of 51 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RouteCD | nvarchar(15) | Route ID | - | |
Description:No description available | ||||
ActiveOnFriday | bit | Friday | - | |
Description:No description available | ||||
ActiveOnMonday | bit | Monday | - | |
Description:No description available | ||||
ActiveOnSaturday | bit | Saturday | - | |
Description:No description available | ||||
ActiveOnSunday | bit | Sunday | - | |
Description:No description available | ||||
ActiveOnThursday | bit | Thursday | - | |
Description:No description available | ||||
ActiveOnTuesday | bit | Tuesday | - | |
Description:No description available | ||||
ActiveOnWednesday | bit | Wednesday | - | |
Description:No description available | ||||
BeginBranchCDNonexistent in DB | nvarchar(MAX) | Start Branch | - | |
Description:No description available | ||||
BeginBranchID | int | Branch | Branch | |
Description:No description available | ||||
BeginBranchLocationCDNonexistent in DB | nvarchar(MAX) | Start Branch Location | - | |
Description:No description available | ||||
BeginBranchLocationID | int | Branch Location | FSBranchLocation | |
Description:No description available | ||||
BeginTimeOnFriday | datetime | Start time | - | |
Description:No description available | ||||
BeginTimeOnMonday | datetime | Start time | - | |
Description:No description available | ||||
BeginTimeOnSaturday | datetime | Start time | - | |
Description:No description available | ||||
BeginTimeOnSunday | datetime | Start time | - | |
Description:No description available | ||||
BeginTimeOnThursday | datetime | Start time | - | |
Description:No description available | ||||
BeginTimeOnTuesday | datetime | Start time | - | |
Description:No description available | ||||
BeginTimeOnWednesday | datetime | Start time | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Descr | nvarchar(60) | Description | - | |
Description:No description available | ||||
EndBranchCDNonexistent in DB | nvarchar(MAX) | End Branch | - | |
Description:No description available | ||||
EndBranchID | int | Branch | Branch | |
Description:No description available | ||||
EndBranchLocationCDNonexistent in DB | nvarchar(MAX) | End Branch Location | - | |
Description:No description available | ||||
EndBranchLocationID | int | Branch Location | FSBranchLocation | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
MaxAppointmentQty | int | Max. Appointment Qty. | - | |
Description:No description available | ||||
MemRouteNonexistent in DB | nvarchar(MAX) | Route | - | |
Description:No description available | ||||
MemRouteDescriptionNonexistent in DB | nvarchar(MAX) | Route Description | - | |
Description:No description available | ||||
MemRouteNameNonexistent in DB | nvarchar(MAX) | Route Name | - | |
Description:No description available | ||||
NbrTripOnFriday | int | Nbr. Trip(s) per Day | - | |
Description:No description available | ||||
NbrTripOnMonday | int | Nbr. Trip(s) per Day | - | |
Description:No description available | ||||
NbrTripOnSaturday | int | Nbr. Trip(s) per Day | - | |
Description:No description available | ||||
NbrTripOnSunday | int | Nbr. Trip(s) per Day | - | |
Description:No description available | ||||
NbrTripOnThursday | int | Nbr. Trip(s) per Day | - | |
Description:No description available | ||||
NbrTripOnTuesday | int | Nbr. Trip(s) per Day | - | |
Description:No description available | ||||
NbrTripOnWednesday | int | Nbr. Trip(s) per Day | - | |
Description:No description available | ||||
NoAppointmentLimit | bit | No Limit | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
OriginRouteID | int | Origin Route | - | |
Description:No description available | ||||
RouteBeginLocationType | char(4) | Start Location Type | - | |
Description:No description available | ||||
RouteEndLocationType | char(4) | End Location Type | - | |
Description:No description available | ||||
RouteID | int | RouteID | FSRoute | |
Description:No description available | ||||
RouteShort | nvarchar(10) | Route Short | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VehicleTypeID | int | Vehicle Type | FSVehicleType | |
Description:No description available | ||||
WeekCode | nvarchar(MAX) | Week Code(s) e.g.: 1, 2B, 1ACS | - | |
Description:No description available | ||||