| SRVRECTYPE |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| CALLNBR |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| EQPLINE |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| LINITMTYP |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| SRVSTAT |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| TECHID |
char(11)
''
|
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
|
|
|
|
| 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
|
| 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
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| 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
|
|
|
|
| ENDTME |
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
|
|
|
|
| TRNSFLOC |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| TRNSFQTY |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| TRNFLAG |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| ORDDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| TRANSLINESEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| LABPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PARTPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| MISCPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| FUFILDAT |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| PONMBRSTR |
char(17)
''
|
Field Type...(more) Join Now
|
|
|
|
| POLNSEQ |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| On_Return |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| RETDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| Miles_Start |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Miles_End |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Miles_Used |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| PRICELVL |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Address_Option |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Misc_Address_Code |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Disable_XFR_Grouping |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| Work_Type |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| ORUNTCST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORUNTPRC |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| OREXTCST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| OXTNDPRC |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_FO_ID |
char(51)
''
|
Field Type...(more) Join Now
|
|
|
|
| svcCreateVoucher |
tinyint
0
|
N/A...(more) Join Now
|
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
POP30300.VCHRNMBR
|
|
|
| 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
|
|
|
|