TMT Fleet Maintenance External Views
Repair Order Summary
This view will allow you to see a summary of all repair orders.
VIEW_TMWAMSF_REPAIRORDER_SUMMARY
| Field | Field Description |
|---|---|
ORDERID |
Number TMT Fleet Maintenance assigns to an order to track it. This number is used in the database |
ORDERNUM |
The number visible in TMT Fleet Maintenance to track RO’s, PO’s Fuel Tickets, etc |
SHOPID |
Shop Identification Number |
UNITNUMBER |
The Unit ID displayed in Masters Units |
UNITTYPE |
Tractor. Trailer, Tanker, etc. |
STATUS |
Whether Order is Open, Closed, Complete, etc. |
OPENED |
When was the order opened |
CREATEDON |
Date the order was created |
CREATEDBY |
Who the order was created by |
COMPLTBY |
Who the order was completed by |
COMPLETEDON |
Date the order was completed |
CLOSED |
When was the order closed |
CLOSEDBY |
Who closed the order |
PRIORITY |
The priority of the order |
ROTYPE |
Standard or Vendor Repair Order |
VENDOR |
Vendor providing service for order |
CUSTOMERNAME |
Customer name associated with unit |
METERTYPE |
The type of meter used Odometer, Hub, etc. |
READING |
The reading form the meter |
LINETOTAL |
The total amount Charged on the line |
PHYLOCATION |
The Physical location of unit as found in Masters > Units > Misc |
PHYSHOPLOCATION |
Current Shop for unit as found on Masters > Units > Misc |
ACTIVCODE |
Units Activity Delivery, Service, etc. |
UNITSTATUS |
Units status Active, Leased, In Yard, Reports Only, etc |
MAKE |
Units Make |
MODEL |
Units Model |
MODELYEAR |
Units Model Year |
DOMICILE |
Shop that the unit calls home |
DIVISIONCD |
Company Division a unit belongs to |
DEPTCODE |
Department within the company Division |
COSTCTCODE |
Units Cost Center |
UNITUSERFLD1 |
Used to track specific information for a unit |
UNITUSERFLD2 |
Used to track specific information for a unit |
UNITUSERFLD3 |
Used to track specific information for a unit |
UNITUSERFLD4 |
Used to track specific information for a unit |
UNITUSERFLD5 |
Used to track specific information for a unit |
UNITUSERFLD6 |
Used to track specific information for a unit |
UNITUSERFLD7 |
Used to track specific information for a unit |
UNITUSERFLD8 |
Used to track specific information for a unit |
REFINVOICE |
ORDERID of Invoice associated with the order |
REFORDERID |
When tied to purchase order, this will tell you the purchase order’s ID |
REPCLASS |
Scheduled, Nonscheduled, or Emergency |
REPSITE |
Place where the repair was performed. |
ORDERTYPE |
Is order RO, PO, Fuel Ticket, Indirect, Campaign, etc. |
PONUMBER |
Purchase Order Number. It appears on the repair order in Customer PO# field |
COMPLTDATE |
Date order was completed |
CUSTID |
This is the customer number that is assigned to the unit. |
UNITID |
The Unit ID displayed in Masters Units |
REPAIRLIMIT |
The dollar limit assigned to the unit that can be used for repairs |
Example: You can use WHERE clause to filter the results of view. Example of a view filtered by Shop SELECT ORDERID, ORDERNUM, SHOPID, UNITNUMBER, UNITTYPE, STATUS, OPENED, CREATEDON, CREATEDBY, COMPLTBY, COMPLETEDON, CLOSED, CLOSEDBY, PRIORITY, ROTYPE, VENDOR, CUSTOMERNAME, BATCHID, CUSTPONUMBER, METERTYPE, READING, LINETOTAL, PHYLOCATION, PHYSHOPLOCATION, ACTIVCODE, UNITSTATUS, MAKE, MODEL, MODELYEAR, DOMICILE, DIVISIONCD, DEPTCODE, COSTCTCODE, UNITUSERFLD1, UNITUSERFLD2, UNITUSERFLD3, UNITUSERFLD4, UNITUSERFLD5, UNITUSERFLD6, UNITUSERFLD7, UNITUSERFLD8, REFINVOICE, REFORDERID, REPCLASS, REPSITE, ORDERTYPE, PONUMBER, COMPLTDATE, CUSTID, UNITID, REPAIRLIMIT FROM [dbo].[VIEW_TMWAMSF_REPAIRORDER_SUMMARY] WHERE SHOPID='01' |
|
View Purchase Orders by Section
This view, used by Synergize PO invocation, returns a list of purchase orders by sections that are in received or completed status. The view will return the following purchase order types: Standard, Blanket, and Vendor RO. The view includes Order ID, Section, Order Number, Shop (SHOPID), vendor, opened date, purchase order type, shop purchase order merchandise is sent to (SHIPTOID), Shop Name (SHIPNAME), total amount (TOTALAMT - total dollar amount for entire purchase order) and total (TOTAL – total dollar amount for section).
VIEW_TMWAMSF_POS_BY_SECTION
| Field | Field Description |
|---|---|
ORDERID |
Number TMT Fleet Maintenance assigns to an order to track it. This number is used by the database. |
SECTION |
The Section that is assigned by TMT Fleet Maintenance to track the section. This is an internal number created by the database. |
ORDERNUM |
The Order Number that displays in TMT Fleet Maintenance. |
SHOPID |
Shop Identification Number |
VENDOR |
The name of the vendor the purchase order is made out to. |
OPENED |
The date the purchase order was opened. |
POTYPE |
Will display STANDARD, CREDIT, or BLANKET based on the type of PO. |
SHIPTOID |
The shop ID to which the parts for this purchase order should be shipped. |
SHIPNAME |
The full name of the shop to which parts for this purchase order should be shipped. |
TOTALAMT |
The total dollar amount of the entire purchase order. |
TOTAL |
The total amount for a section. |
VIEW_TMWAMSF_POS_BY_SECTION Example: |
|