Module List > Module SOP tables SOP60100
You are currently viewing the COMPANY database.
Change

COMPANY..SOP60100 Table Definition

(COMPANY..SOP_POPLink)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SOPNUMBE char(21)
''
SOP Number...(more) Join Now
SOPTYPE smallint
0
SOP Type: ...(more) Join Now
LNITMSEQ int
0
Line Item ...(more) Join Now
CMPNTSEQ int
0
Component ...(more) Join Now
PONUMBER char(17)
''
PO Number:...(more) Join Now
ORD int
0
Ord: Same ...(more) Join Now
RCTINVCERRORS binary(4)
0
Receipt In...(more) Join Now
RCPTCOST numeric(19,5)
0.00
Receipt Co...(more) Join Now
RCPTPRIORITY smallint
0
Receipt Pr...(more) Join Now
QTYONPO numeric(19,5)
0.00
QTY On PO:...(more) Join Now
QTYONPOBASE numeric(19,5)
0.00
QTY On PO ...(more) Join Now
QTYRECVD numeric(19,5)
0.00
QTY Receiv...(more) Join Now
QTYRECINBASE numeric(19,5)
0.00
QTY Receiv...(more) Join Now
RQSTFFDATE datetime
'1/1/1900'
Requested ...(more) Join Now
QTYBSUOM numeric(19,5)
0.00
QTY In Bas...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
ITEMDESC char
''
Item Descr...(more) Join Now WO010116.ITEMDESC
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
UOFM char
''
U of M The...(more) Join Now
See I... more text available
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