Module List > Module SVC tables SVC30203
You are currently viewing the COMPANY database.
Change

COMPANY..SVC30203 Table Definition

(COMPANY..Service Call Line Detail History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3