External stored procedures: Road Calls

TMTAMSEXT_ROADCALL_INS

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@ERRORID

INT

Error ID supplied if an invalid parameter was entered

@CALLID

INT

Number TMT Fleet Maintenance assigns to a Road Call to track it. This number is used in the database

@UNITID

VARCHAR (24)

Number assigned by database to track the unit. Only seen in database

@UNITCUSTID

VARCHAR (12)

@CUSTID

VARCHAR (12)

Identifies the customer

@SHOPID

VARCHAR (12)

Shop Identification Number

@DRIVERNUM

VARCHAR (12)

Driver Identification Number

@FIRSTNAME

VARCHAR (30)

Drivers First Name

@LASTNAME

VARCHAR (30)

Drivers Last Name

@DRIVERPHONE

VARCHAR (25)

Drivers Phone Number

@DATEOPENED

DATETIME

When the order was opened

@LOCATION

VARCHAR (255)

Physical location of unit

@METERREADING

NUMERIC (15,2)

The amount of miles, hours, and so on, since the last entry

@CALLNOTES

VARCHAR (6000)

Notes from the Road Call

@INTEGRATIONID

INT

Identifies the integration the reading came from

TMTAMSEXT_ROADCALL_INS Example:
DECLARE @ERRORID INT, @CALLID INT, @UNITID VARCHAR(24), @UNITCUSTID VARCHAR(12), @CUSTID VARCHAR(12), @SHOPID VARCHAR(12), @DRIVERNUM VARCHAR(12), @FIRSTNAME VARCHAR(30), @LASTNAME VARCHAR(30), @DRIVERPHONE VARCHAR(25), @DATEOPENED DATETIME, @LOCATION VARCHAR(255), @METERREADING NUMERIC(15,2), @CALLNOTES VARCHAR(6000), @INTEGRATIONID INT

— Set parameter values

EXECUTE @RC = [TFW1230v2].[dbo].[TMTAMSEXT_ROADCALL_INS] @ERRORID OUTPUT, @CALLID OUTPUT, @UNITID, @UNITCUSTID, @CUSTID, @SHOPID, @DRIVERNUM, @FIRSTNAME, @LASTNAME, @DRIVERPHONE, @DATEOPENED, @LOCATION, @METERREADING, @CALLNOTES, @INTEGRATIONID