Module List > Module IV tables IV00103
You are currently viewing the COMPANY database.
Change

COMPANY..IV00103 Table Definition

(COMPANY..Item Vendor Master)

This file holds information about the items in the vendor supplies.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
ITMVNDTY smallint
0
Item Vendo...(more) Join Now
VNDITNUM char(31)
''
Vendor Ite...(more) Join Now
QTYRQSTN numeric(19,5)
0.00
QTY Requis...(more) Join Now
QTYONORD numeric(19,5)
0.00
QTY On Ord...(more) Join Now
QTY_Drop_Shipped numeric(19,5)
0.00
QTY Drop S...(more) Join Now
LSTORDDT datetime
'1/1/1900'
Last ORD D...(more) Join Now
LSORDQTY numeric(19,5)
0.00
Last ORD Q...(more) Join Now
LRCPTQTY numeric(19,5)
0.00
Last RCPT ...(more) Join Now
LSRCPTDT datetime
'1/1/1900'
Last RCPT ...(more) Join Now
LRCPTCST numeric(19,5)
0.00
Last RCPT ...(more) Join Now
AVRGLDTM int
0
Average Le...(more) Join Now
NORCTITM smallint
0
Number of ...(more) Join Now
MINORQTY numeric(19,5)
0.00
span style...(more) Join Now
MAXORDQTY numeric(19,5)
0.00
Maximum OR...(more) Join Now
ECORDQTY numeric(19,5)
0.00
Economic O...(more) Join Now
VNDITDSC char(101)
''
Vendor Ite...(more) Join Now
Last_Originating_Cost numeric(19,5)
0.00
span style...(more) Join Now
Last_Currency_ID char(15)
''
Last Curre...(more) Join Now
FREEONBOARD smallint
0
Free On Bo...(more) Join Now
PRCHSUOM char(9)
''
Purchasing...(more) Join Now IV00101.PRCHSUOM
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
PLANNINGLEADTIME smallint
0
span style...(more) Join Now
ORDERMULTIPLE numeric(19,5)
0.00
Order Mult...(more) Join Now
MNFCTRITMNMBR char(31)
''
Manufactur...(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