Home > Technical > Table Definitions > 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) |