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

COMPANY..SOP40701 Table Definition

(COMPANY..Extended Pricing Price List Report)

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
ITEMDESC char(101)
''
Item Descr...(more) Join Now IV00101.ITEMDESC
DECPLCUR smallint
0
Number of ...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
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
ERMSGTXT char(255)
''
Field Type...(more) Join Now SVC00215.ERMSGTXT
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