SRVRECTYPE

i4

2

Y

Not applicable

Service record type

CALLNBR

string

11

Y

Not applicable

Service call number

EQPLINE

i4

4

N

1

The Equipment Sequence Number. If not provided on an update the default will be 1.

LNITMSEQ

i4

4

N

0

The sequence number for the line. If not provided on an update a new service call line record will be created.

LINITMTYP

string

3

Y

P

Indicates the type of service call line. Options are: A=Additional Charge;

E=Expense;

L=Labor;

P=Parts.

If not provided the default will be P for parts.

SRVSTAT

string

3

N

Not applicable

The status of the service call line; Only valid for line type = L (Labor) or P (Parts).

TECHID

string

11

N

Not applicable

The technician of the service call line; Only valid for line type = L (Labor) or P (Parts).

CUSTNMBR

string

15

Y

Not applicable

Customer number

ADRSCODE

string

15

Y

Not applicable

Customer address code

ITEMNMBR

string

31

Y

Not applicable

Item number

CKNORETURNS

i4

1

N

0

Flag used to indicate not to create returnable line for items that are set as returnable;

0=False;

1=True

ITEMDESC

string

101

N

Not applicable

Item description

LOCNCODE

string

11

Y

Not applicable

The location code for parts used on the service call line

UOFM

string

9

N

<blank>

Unit of measure

QTYORDER

number

21

N

0

The amount of labor or quantity of parts required for the service call line. Only valid for line type = L (Labor) or P (Parts).

ATYALLOC

number

21

N

0

The quantity of the parts line that is allocated in Inventory. Only valid for line type = P (Parts) and will be unallocated when the part is used.

QTYBACKO

number

21

N

0

The quantity of the parts line that is backordered. Only valid for line type = P (Parts) and will be reduced as the backorder is filled by an Inventory transfer or receipt of a purchase order.

QTYSOLD

number

21

N

0

The quantity of the line that was actually used. This is the value that will be transferred to the invoice during the service call billing process.

UNITCOST

number

21

N

0

The cost per unit of measure for the current detailed entry. This cost will typically default from the Inventory current cost for most items, but can be modified for additional charge and expense lines.

UNITPRCE

number

21

N

0

The price per unit of measure for the service call line

XTNDPRCE

number

21

N

0

The extended price of the line, which is the unit price times the quantity sold. This value may also be affected by the applicable billing percentage for parts, labor or miscellaneous lines.

NOTETXT

string

3000

N

<blank>

Notes field

STRTDATE

datetime

16

N

Not applicable

Only valid for line type = L (Labor) and contains the date on which the labor line started.

STRTTIME

datetime

16

N

Not applicable

Only valid for line type = L (Labor) and contains the time on which the labor line started.

ENDDATE

datetime

16

N

Not applicable

Only valid for line type = L (Labor) and contains the date on which the labor line ended.

ENDTME

datetime

16

N

Not applicable

Only valid for line type = L (Labor) and contains the time on which the labor line ended.

TRANSTME

number

11

N

0

The actual time for a labor line and is only valid for line type = L (Labor). Values should be in portions of an hour. For example, a half hour would be 00030, while one hour would be 00100

BILLABLTIM

number

11

N

0

The amount of time that should be billed for a labor line and is only valid for line type = L (Labor).This value may vary from the transaction time field based on rounding or minimum labor settings. Values should be in portions of an hour. For example, a half hour would be 00030, while one hour would be 00100

ENTDTE

datetime

16

N

Not applicable

Entry Date

ENTTME

datetime

16

N

Not applicable

Entry Time

LABPCT

number

21

N

Default from setup

The percent of the line that is billable to the customer. This value is only used in calculations for records where line type = L (Labor). The value will default from any contract or warranty attached to the current contract, otherwise it will default to 100

PARTPCT

number

21

N

Default from setup

The percent of the line that is billable to the customer. This value is only used in calculations for records where line type = P (Parts). The value will default from any contract or warranty attached to the current contract, otherwise it will default to 100

MISCPCT

number

21

N

Default from setup

The percent of the line that is billable to the customer. This value is only used in calculations for records where line type = A (Additional Charge) or E (Expense). The value will default from any contract or warranty attached to the current contract, otherwise it will default to 100

CKCREATEPO

i4

2

N

0

Flag used to indicate if a PO for a parts line should be created; 0=False; 1=True

VENDORID

string

15

N

Not applicable

Vendor number

PRMDATE

datetime

16

N

Not applicable

Promised Date

Miles_Start

i4

8

N

<blank>

The starting mileage for the line. Only valid for line type = L (Labor)

Miles_End

i4

8

N

<blank>

The ending mileage for the line. Only valid for line type = L (Labor)

Miles_Used

i4

8

N

<blank>

The total mileage for the line, (Miles_End less Miles_Start). Only valid for line type = L (Labor).

PRICELVL

string

15

N

Default from setup

The Inventory price level for the line. For parts, expense and additional charge lines the price level defaults from the Service Call header. For labor lines, the price level defaults from the Technician assigned to the labor line.

SVC_Address_Option

i4

2

N

Default from setup

The Address Option selection and is only valid for line type = P (Parts). Valid options are: 0=Labor, Additional Charge or Expense record;

1=Customer Address ID;

2=Tech Site;

3=Misc Address Code;

4=Transfer Header Modified

SVC_Misc_Address_Code

string

15

N

<blank>

The miscellaneous address to be used when SVC_Address_Option =3

SVC_Disable_XFR_Grouping

i4

1

N

0

Flag which indicates whether transfer or purchase order lines will be consolidated or not consolidated with other open transfers or purchase orders.

0=False;

1=True

Work_Type

string

11

N

<blank>

The work type code for the line. Only valid for line type = L (Labor).

SVC_FO_ID

string

51

N

<blank>

Front office integration ID

CURNCYID

string

15

N

Default from setup

Currency ID

NonInventory

i4

1

N

0

Non-inventory items

0=Inventory item

1=Noninventory item

Create_Overtime_Labor

i4

1

N

0

Overtime labor rates to be used for labor outside of technician schedule.

0=False

1=True

Overtime_Labor_item_Number

string

31

N

Default from setup

Item number for overtime labor if automatic overtime ins enabled. The default is the overtime labor item for the specified Service Type.

UpdateIfExists

i4

1

N

1

Flag to allow data to be updated if it exists:

0=Do not update;

1=Update

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates the requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only