| WORECTYPE |
smallint
0
|
1 - Quoteb...(more) Join Now
|
|
|
|
| WORKORDNUM |
char(11)
''
|
|
|
|
|
| WOSTAT |
char(3)
''
|
|
|
|
|
| WOTYPE |
char(11)
''
|
|
|
|
|
| SVC_Depot_Priority |
numeric(19,5)
0.00
|
|
|
|
|
| PARWORECTYPE |
smallint
0
|
|
|
|
|
| PARWONUM |
char(15)
''
|
|
|
|
|
| ORIGIN |
smallint
0
|
Payables:
...(more) Join Now
|
SY00500.ORIGIN
|
|
|
| REFRENCE |
char(31)
''
|
Reference:...(more) Join Now
|
POP30300.REFRENCE
|
|
|
| TIMEZONE |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| ENTDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ENTTME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ETADTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ETATME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ECOMPDT |
datetime
'1/1/1900'
|
|
|
|
|
| EComp_Time |
datetime
'1/1/1900'
|
|
|
|
|
| RETUDATE |
datetime
'1/1/1900'
|
|
|
|
|
| Return_Time |
datetime
'1/1/1900'
|
|
|
|
|
| COMPDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| COMPTME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| BIN |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
Field Type...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
Field Type...(more) Join Now
|
|
|
|
| ZIPCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| RETDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| SRVRECTYPE |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| CALLNBR |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| SERVLITEMSEQ |
int
0
|
|
|
|
|
| IBITEMNUM |
char(31)
''
|
|
|
|
|
| IBSERIAL |
char(21)
''
|
|
|
|
|
| IBEQUIPID |
int
0
|
|
|
|
|
| OBITEMNUM |
char(31)
''
|
|
|
|
|
| OBSERIAL |
char(21)
''
|
|
|
|
|
| OBEQUIPID |
int
0
|
|
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| STATIONID |
char(11)
''
|
|
|
|
|
| ROUTEID |
char(11)
''
|
|
|
|
|
| SEQUENCE1 |
numeric(19,5)
0.00
|
|
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| IBANALCODE |
char(11)
''
|
|
|
|
|
| OBANALCODE |
char(11)
''
|
|
|
|
|
| CUSTOWN |
tinyint
0
|
|
|
|
|
| ORDDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| TRANSLINESEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| FACTSEAL |
tinyint
0
|
|
|
|
|
| LABSTOTCST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PARSTOTCST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| TOTLABHRS |
numeric(19,5)
0.00
|
|
|
|
|
| PRICELVL |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| NUMRESCHED |
smallint
0
|
|
|
|
|
| Commit_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Commit_Time |
datetime
'1/1/1900'
|
|
|
|
|
| USERDEF1 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF03 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF04 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF05 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_RMA_Reason_Code |
char(3)
''
|
|
|
|
|
| SVC_RMA_Reason_Code_Desc |
char(31)
''
|
|
|
|
|
| SVC_Process_SEQ_Number |
numeric(19,5)
0.00
|
|
|
|
|
| svcRMAComponentSeq |
int
0
|
|
|
|
|
| QTYTYPE |
smallint
0
|
QTY Type...(more) Join Now
|
WOUF0132.QTYTYPE
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|