| 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
|
|
|
|