| WORECTYPE |
smallint
0
|
1 - Quoteb...(more) Join Now
|
|
|
|
| WORKORDNUM |
char(11)
''
|
|
|
|
|
| WOSTAT |
char(3)
''
|
|
|
|
|
| LINITMTYP |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ITEMUSETYPE |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| ITEMDESC |
char(101)
''
|
Field Type...(more) Join Now
|
|
|
|
| STATIONID |
char(11)
''
|
|
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| UOFM |
char(9)
''
|
Field Type...(more) Join Now
|
|
|
See I... more text available
|
| TECHID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| QTYORDER |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ATYALLOC |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| QTYBACKO |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| QTYSOLD |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| UNITCOST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| UNITPRCE |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| EXTDCOST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| XTNDPRCE |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| STRTDATE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| STRTTIME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ENDDATE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ENDTIME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| TRANSTME |
char(7)
''
|
Field Type...(more) Join Now
|
|
|
|
| BILLABLTIM |
char(7)
''
|
Field Type...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| SEQUENCE1 |
numeric(19,5)
0.00
|
|
|
|
|
| ORDDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| TRANSLINESEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| PONMBRSTR |
char(17)
''
|
Field Type...(more) Join Now
|
|
|
|
| POLNSEQ |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| FUFILDAT |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CMPNTSEQ |
int
0
|
Component ...(more) Join Now
|
|
|
|
| CMPITQTY |
numeric(19,5)
0.00
|
N/A...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|