External stored procedures: PMs

TMTEXT_PMSDUE

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@UNITID

INTEGER, Optional

Unit Identification Number

@SHOPID

VARCHAR, (12), Optional

Shop Identification Number

@CUSTOMERID

VARCHAR, (12), Optional

Identification number for the customer.

@PHYLOCATION

VARCHAR, (12), Optional

The Physical location of unit as found on Masters > Units > Misc

@PHYSHOPLOCATION

VARCHAR, (12), Optional

Current Shop for unit as found on Masters > Units > Misc

@COSTCENTER

VARCHAR, (12), Optional

Units Cost Center

@MAKE

VARCHAR, (12), Optional

Units Make

@MODEL

VARCHAR, (12), Optional

Units Model

@DIVISIONCD

VARCHAR, (12), Optional

Company Division a unit belongs to.

@STATUS

VARCHAR, (12), Optional

Whether Unit is Active, In Shop, Reports Only, etc.

@DEPTCODE

VARCHAR, (12), Optional

Company Department a unit belongs to.

@ACTIVITY

VARCHAR, (12), Optional

Units activity Delivery, Tractor, Service, etc.

@UNITTYPE

VARCHAR, (12), Optional

Tractor. Trailer, Tanker, etc.

@FLEETID

VARCHAR, (12), Optional

ID used to identify Year, Make, Model, Capacity, Unit Type, Engine & wheelbase of Unit. Any combination of these can be used.

@MODELYEAR

INTEGER, Optional

Units Model year

@PMCOMPCODE

VARCHAR, (12), Optional

Component Code that represents a PM. Always starts with 000-

@PMTYPE

VARCHAR, (12), Optional

Independent or Dependent

@UNITUSERFLD1

VARCHAR, (12), Optional

Used to track specific information for a unit

@UNITUSERFLD2

VARCHAR, (12), Optional

Used to track specific information for a unit

@UNITUSERFLD3

VARCHAR, (12), Optional

Used to track specific information for a unit

@UNITUSERFLD4

VARCHAR, (12), Optional

Used to track specific information for a unit

@UNITUSERFLD5

VARCHAR, (12), Optional

Used to track specific information for a unit

@UNITUSERFLD6

VARCHAR, (12), Optional

Used to track specific information for a unit

@UNITUSERFLD7

VARCHAR, (12), Optional

Used to track specific information for a unit

@UNITUSERFLD8

VARCHAR, (12), Optional

Used to track specific information for a unit

@STARTDATE

DATETIME, Optional

Not being used at this time

@ENDDATE

DATETIME, Optional

Not being used at this time

@PMPERCENT

NUMERIC, (15,6), Optional

Percentage of time before PM is due (if under 100% if over 100% PM is past due)

TMTEXT_PMSDUE Example:
DECLARE @UNITID INT, @SHOPID VARCHAR(12), @CUSTOMERID VARCHAR(12), @PHYLOCATION VARCHAR(12), @PHYSHOPLOCATION VARCHAR(12), @COSTCENTER VARCHAR(12), @MAKE VARCHAR(12), @MODEL VARCHAR(12), @DIVISIONCD VARCHAR(12), @STATUS VARCHAR(12), @DEPTCODE VARCHAR(12), @ACTIVITY VARCHAR(12), @UNITTYPE VARCHAR(12), @FLEETID VARCHAR(12), @MODELYEAR INT, @PMCOMPCODE VARCHAR(12), @PMTYPE VARCHAR(12), @UNITUSERFLD1 VARCHAR(12), @UNITUSERFLD2 VARCHAR(12), @UNITUSERFLD3 VARCHAR(12), @UNITUSERFLD4 VARCHAR(12), @UNITUSERFLD5 VARCHAR(12), @UNITUSERFLD6 VARCHAR(12), @UNITUSERFLD7 VARCHAR(12), @UNITUSERFLD8 VARCHAR(12), @STARTDATE DATETIME, @ENDDATE DATETIME, @PMPERCENT NUMERIC(15,6)

— Set parameter values

EXEC @RC = [dbo].[TMTEXT_PMSDUE] @UNITID, @SHOPID, @CUSTOMERID, @PHYLOCATION, @PHYSHOPLOCATION, @COSTCENTER, @MAKE, @MODEL, @DIVISIONCD, @STATUS, @DEPTCODE, @ACTIVITY, @UNITTYPE, @FLEETID, @MODELYEAR, @PMCOMPCODE, @PMTYPE, @UNITUSERFLD1, @UNITUSERFLD2, @UNITUSERFLD3, @UNITUSERFLD4, @UNITUSERFLD5, @UNITUSERFLD6, @UNITUSERFLD7, @UNITUSERFLD8, @STARTDATE, @ENDDATE, @PMPERCENT

TMTEXT_PM_INTERVAL_UPD

Updates existing pm intervals based on unit type. You have the option of updating 1 or 2 intervals at a time. If you are only updating one meter type the values for METERTYPE2 and INTERVAL2 need to be set to NULL

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@UNITTYPE

INTEGER, Required

Tractor. Trailer, Tanker, etc.

@METERTYPE1

VARCHAR, (12), Required

The type of meter used Odometer, Hub, etc.

@INTERVAL1

NUMERIC, (15,6), Required

How long between PMs example 30 days, 10,000 miles, etc.

@METERTYPE2

VARCHAR, (12), Optional

The type of meter used Odometer, Hub, etc.

@INTERVAL2

NUMERIC, (15,6), Optional

How long between PMs example 30 days, 10,000 miles, etc.

@PMCOMPCODE

VARCHAR, (12), Required

Component Code that represents a PM. Always starts with 000-

TMTEXT_PM_INTERVAL_UPD Output Parameters:
@ERRORMESSAGE — VARCHAR(60)

TMTEXT_PM_INTERVAL_UPD Example:
DECLARE @UNITTYPE VARCHAR(12), @METERTYPE1 VARCHAR(12), @INTERVAL1 NUMERIC(15,6), @METERTYPE2 VARCHAR(12), @INTERVAL2 NUMERIC(15,6), @PMCOMPCODE VARCHAR(12), @ERRORMESSAGE VARCHAR(60)

— Set parameter values

EXEC [dbo].[TMTEXT_PM_INTERVAL_UPD] @UNITTYPE, @METERTYPE1, @INTERVAL1, @METERTYPE2, @INTERVAL2, @PMCOMPCODE, @ERRORMESSAGE OUTPUT

— Return the error code
SELECT @ERRORMESSAGE