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

COMPANY..SVC00701 Table Definition

(COMPANY..Service Transfer Line Detail)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ORDDOCID char(15)
''
Field Type...(more) Join Now
LNITMSEQ int
0
Field Type...(more) Join Now
STATUS smallint
0
p>Field Ty...(more) Join Now
ITEMNMBR char(31)
''
Field Type...(more) Join Now
join ... more text available
DSCRIPTN char(31)
''
Field Type...(more) Join Now
UOFM char(9)
''
Field Type...(more) Join Now
See I... more text available
TRNSFQTY numeric(19,5)
0.00
Field Type...(more) Join Now
QTYFULFI numeric(19,5)
0.00
QTY Fulfil...(more) Join Now
QTYSHPPD numeric(19,5)
0.00
QTY Shippe...(more) Join Now POP10500.QTYSHPPD
QTY_To_Receive numeric(19,5)
0.00

QTYRECVD numeric(19,5)
0.00
QTY Receiv...(more) Join Now SOP10200.QTYRECVD
CALLNBR char(11)
''
Field Type...(more) Join Now
SRVRECTYPE smallint
0
Field Type...(more) Join Now
SERVLITEMSEQ int
0

EQPLINE int
0
Field Type...(more) Join Now
LINITMTYP char(3)
''
Field Type...(more) Join Now
RETDOCID char(15)
''
Field Type...(more) Join Now
LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
RTV_Number char(15)
''

WORECTYPE smallint
0
1 - Quoteb...(more) Join Now
WORKORDNUM char(11)
''

QTYBSUOM numeric(19,5)
0.00
QTY In Bas...(more) Join Now
TRNSFLOC char(11)
''
Field Type...(more) Join Now
ITLOCN char(11)
''

TRNSTLOC char(11)
''
Transfer T...(more) Join Now IV10001.TRNSTLOC
TRFQTYTY smallint
0
Transfer F...(more) Join Now IV10001.TRFQTYTY
TRTQTYTY smallint
0
Transfer T...(more) Join Now IV10001.TRTQTYTY
DECPLCUR smallint
0
Number of ...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
Landed_Cost_Group_ID char(15)
''
Landed Cos...(more) Join Now IV00102.Landed_Cost_Group_ID
Reason_Code char
''

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