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) |