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

COMPANY..SOP40706 Table Definition

(COMPANY..Extended Pricing Price Book Prices)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
PRCBKID char(15)
''

ITEMNMBR char(31)
''
span style...(more) Join Now IV00103.ITEMNMBR
join ... more text available
UOFM char(9)
''
U of M The...(more) Join Now
See I... more text available
QTYFROM numeric(19,5)
0.00

QTYTO numeric(19,5)
0.00

UMQTYINB numeric(19,5)
0.00
U Of M QTY...(more) Join Now POP10110.UMQTYINB
UNITPRCE numeric(19,5)
0.00
Unit Price...(more) Join Now SOP10200.UNITPRCE
CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
ERRVAL int
0

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