SRVRECTYPE

i4

2

Y

Not applicable

Service record type

CALLNBR

string

11

Y

Not applicable

Service call number

SRVSTAT

string

3

N

Default from setup

Service call status code

SRVTYPE

string

11

N

Default from setup

Service type

SVCDESCR

string

61

N

<blank>

Service description

PriorityLevel

i4

2

N

0

Priority level

CUSTNMBR

string

15

Y

<blank>

Customer number

Customer_Reference

string

21

N

<blank>

Customer reference

ADRSCODE

string

15

N

<blank>

Customer address code

CUSTNAME

string

65

N

<blank>

Customer name

ADDRESS1

string

61

N

<blank>

Customer address line 1

ADDRESS2

string

61

N

<blank>

Customer address line 2

ADDRESS3

string

61

N

<blank>

Customer address line 3

CITY

string

35

N

<blank>

Customer city

STATE

string

29

N

<blank>

Customer state code

ZIP

string

11

N

<blank>

Customer ZIP Code

COUNTRY

string

61

N

<blank>

Customer country

CNTCPRSN

string

61

N

<blank>

Customer Contact person

PHONE1

string

21

N

<blank>

Customer phone 1

CKHOLD

i4

2

N

0

Flag to allow check on hold status:

0=Does not check hold status;

1=Checks hold status

OFFID

string

11

N

<blank>

Office ID

SVCAREA

string

11

N

<blank>

Service area

TECHID

string

11

N

<blank>

Technician ID

TIMEZONE

string

3

N

<blank>

Time zone

CONTNBR

string

11

N

<blank>

Contract number

PRICELVL

string

15

N

Default from setup

The price level assigned to the current service call. This value defaults from the customer card, item card of the item to be repaired or service setup, in that order. This price level will default on all entries in the SVC00203 table except labor transactions.

ENTDTE

datetime

16

N

<blank>

Entry date

ENTTME

datetime

16

N

<blank>

Entry time

ETADTE

datetime

16

N

<blank>

ETA date

ETATME

datetime

16

N

<blank>

ETA Time

DISPDTE

datetime

16

N

<blank>

Dispatch date

DISPTME

datetime

16

N

<blank>

Dispatch time

ARRIVDTE

datetime

16

N

<blank>

Arrival date

ARRIVTME

datetime

16

N

<blank>

Arrival time

COMPDTE

datetime

16

N

<blank>

Complete date

COMPTME

datetime

16

N

<blank>

Complete time

Response_Date

datetime

16

N

<blank>

Response date

Response_Time

datetime

16

N

<blank>

Response time

SLPRSNID

string

15

N

<blank>

Salesperson ID

PORDNMBR

string

20

N

<blank>

Purchase order number

NOTETXT

string

2000

N

Default from setup

Notes field

USERDEF1

string

21

N

<blank>

User defined 1

USERDEF2

string

21

N

<blank>

User defined 2

USERDEF3

string

21

N

<blank>

User defined 3

USERDEF4

string

21

N

<blank>

User defined 4

USERDEF5

string

21

N

<blank>

User defined 5

SVC_On_Hold

i4

1

N

0

Flag to indicate the service call is on hold

PYMTRMID

string

21

N

<blank>

Payment term ID

SVC_FO_ID

string

50

N

<blank>

Front office integration ID

CURNCYID

string

15

N

<blank>

Currency ID

AutoCreateLabor

i4

1

N

0

Flag to allow labor lines to be automatically created for Arrival and Completion:

0=No;

1=Yes

UpdateIfExists

i4

1

N

1

Flag to allow customer data to be updated if it exists:

0=No;

1=Yes

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