Listing of SQL view names for boards
The system is installed with at least one default view for each Board Type. You will select these views when you use:
-
TMW Operations Board Setup to create a new board view from a SQL view.
-
Microsoft SQL Server Management Studio to create new SQL views by copying the system default SQL views.
The scroll views are used in the Scroll windows.
The planning boards have their own views as well as child views. These are the resource grids that display when you access:
-
The Driver, Tractor, Trailer, or Carrier sub tab in the lower section of the Planning Worksheet.
In this example, the Drivers sub tab is selected. It is a child view of the All Inbound view.
-
The Tractor or Trailer sub tab on the Trip Planner.
In this example, the Tractors sub tab is selected. It is a child view of the Scroll Shifts view.
Note: The Carrier tab on the Trip Planner is reserved for future functionality.
Each of these default SQL views can be copied to create views that pull different columns from the database tables.
Outbound views
| SQL view name | Board Setup type name | Board Type | Default view |
|---|---|---|---|
OperationsTripViewStops |
Trips Scroll View |
OUTSCR |
All Loads |
Inbound views
| SQL view name / child view | Board Setup type name | Board Type | Default view |
|---|---|---|---|
OperationsInboundView |
Inbound Scroll View |
INBSCR |
All Inbound |
TMWScrollDriverView |
Driver Scroll View |
DRVSCR |
ScrollDriver |
TMWScrollTractorView |
Tractor Scroll View |
TRCSCR |
ScrollTractor |
TMWScrollTrailerView |
Trailer Scroll View |
TRLSCR |
ScrollTrailer |
TMWScrollCarrierView |
Carrier Scroll View |
CARSCR |
ScrollCarrier |
Shift views
| SQL view name / child view | Board Setup type name | Board Type | Default view |
|---|---|---|---|
ShiftPlanningDriverView |
Shift Planner Scroll |
SHFSCR |
Scroll Shifts |
TMWScrollTractorView |
Tractor Scroll View |
TRCSCR |
ScrollTractor |
TMWScrollTrailerView |
Trailer Scroll View |
TRLSCR |
ScrollTrailer |
TMWScrollCarrierView |
Carrier Scroll View |
CARSCR |
ScrollCarrier |
Appointment Scheduler views
| SQL view name | Board Setup type name | Board Type | Default view |
|---|---|---|---|
TMWScrollAppointments |
Appointment Scheduler Scroll |
APPSCR |
Scroll Appointments |
Resource scroll views
Resource scroll views that are marked with a blue asterisk (*) are also used as child views of Inbound and Shift views.
| SQL view name | Board Setup type name | Board Type | Default view |
|---|---|---|---|
TMWScrollBranchView |
Branch Scroll View |
BRNSCR |
ScrollBranch |
TMWScrollCarrierView * |
Carrier Scroll View |
CARSCR |
ScrollCarrier |
TMWScrollCommoditiesView |
Commodity Scroll View |
COMSCR |
ScrollCommodity |
TMWScrollCompanyView |
Company Scroll View |
CMPSCR |
ScrollCompany |
TMWScrollDriverView * |
Driver Scroll View |
DRVSCR |
ScrollDriver |
TMWScrollEmptyMoveView |
EmprtyMove Scroll View |
EMPSCR |
ScrollEmptyMove |
TMWScrollExpirationsView |
Expirations Scroll View |
EXPSCR |
Open Expirations |
TMWScrollInvoiceView |
Invoice Scroll View |
INVSCR |
ScrollInvoice |
TMWScrollOrderView |
Order Scroll View |
ORDSCR |
ScrollOrder |
TMWScrollPassengerView |
Passenger Scroll View |
PASSCR |
ScrollPassenger |
TMWScrollPayToView |
PayTo Scroll View |
PTSCR |
ScrollPayTo |
TMWScrollReferenceNumberView |
Reference Number Scroll View |
REFSCR |
ScrollReferenceNumber |
TMWScrollStopView |
Stop Scroll View |
STPSCR |
ScrollStop |
TMWScrollThirdPartyView |
ThirdParty Scroll View |
TPSCR |
ScrollThirdParty |
TMWScrollTractorView * |
Tractor Scroll View |
TRCSCR |
ScrollTractor |
TMWScrollTrailerView * |
Trailer Scroll View |
TRLSCR |
ScrollTrailer |
TMWScrollTruckStopView |
TruckStop Scroll View |
TSSCR |
ScrollTruckStop |