Home > Technical > Table Definitions > CUSTORDERSERVICE

CUSTORDERSERVICE

Column

Type

Description

INTORDERCODE

BIGINT

 

STRTYPE

VARCHAR(10)

 

STRBRANDNAME

VARCHAR(30)

 

STRMODEL

VARCHAR(30)

 

STRSERIALNUMBER

VARCHAR(30)

 

DTMRECEIVED

DATETIME

 

MEMFAULT

VARCHAR(2000)

 

MEMREPAIR

VARCHAR(2000)

 

CURESTIMATEAMT

DECIMAL(19,4)

 

DTMESTIMATEFINISH

DATETIME

 

YSNREQPARTS

VARCHAR(1)

 

DTMREQPARTS

DATETIME

 

YSNPARTSORDERED

VARCHAR(1)

 

DTMPARTSORDERED

DATETIME

 

YSNPARTSRECEIVED

VARCHAR(1)

 

DTMPARTSRECEIVED

DATETIME

 

YSNCOMPLETE

VARCHAR(1)

 

DTMCOMPLETE

DATETIME

 

YSNWARRANTYJOB

VARCHAR(1)

 

DTMWARRANTYEXPIRES

DATETIME

 

STRJOBNOTE

VARCHAR(50)

 

YSNSENDOUT

VARCHAR(1)

 

DTMSENDOUT

DATETIME

 

STRSENDOUTNOTE

VARCHAR(100)

 

MEMPARTS

VARCHAR(2000)

 

 

Primary Key: INTORDERCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)