| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| ITEMDESC |
char(51)
''
|
Item Descr...(more) Join Now
|
IV00101.ITEMDESC
|
|
|
| ITMSHNAM |
char(15)
''
|
Item Short...(more) Join Now
|
IV00101.ITMSHNAM
|
|
|
| ITEMTYPE |
smallint
0
|
span style...(more) Join Now
|
IV00101.ITEMTYPE
|
|
|
| ITMGEDSC |
char(11)
''
|
span style...(more) Join Now
|
IV00101.ITMGEDSC
|
|
|
| STNDCOST |
numeric(19,5)
0.00
|
When using...(more) Join Now
|
|
|
|
| CURRCOST |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
|
| ITEMSHWT |
int
0
|
Item Shipp...(more) Join Now
|
IV00101.ITEMSHWT
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| ITMTSHID |
char(15)
''
|
Item Tax S...(more) Join Now
|
IV00101.ITMTSHID
|
|
|
| TAXOPTNS |
smallint
0
|
Tax Option...(more) Join Now
|
IV00101.TAXOPTNS
|
|
|
| IV_IV_STRING |
char(129)
''
|
|
|
|
|
| IV_IV_Offset_String |
char(129)
''
|
|
|
|
|
| IV_COGS_String |
char(129)
''
|
|
|
|
|
| IV_Sales_String |
char(129)
''
|
|
|
|
|
| IV_Sales_Discounts_Strin |
char(129)
''
|
|
|
|
|
| IV_Sales_Returns_String |
char(129)
''
|
|
|
|
|
| IV_In_Use_String |
char(129)
''
|
|
|
|
|
| IV_In_Service_String |
char(129)
''
|
|
|
|
|
| IV_Damaged_String |
char(129)
''
|
|
|
|
|
| IV_Variances_String |
char(129)
''
|
|
|
|
|
| Drop_Ship_String |
char(129)
''
|
|
|
|
|
| Purchase_Price_Variance_ |
char(129)
''
|
|
|
|
|
| Unrealized_Purchase_Pric |
char(129)
''
|
|
|
|
|
| Inventory_Returns_String |
char(129)
''
|
|
|
|
|
| Assembly_Variance_String |
char(129)
''
|
|
|
|
|
| ITMCLSCD |
char(11)
''
|
Item Class...(more) Join Now
|
|
|
|
| ITMTRKOP |
smallint
0
|
Item Track...(more) Join Now
|
IV00101.ITMTRKOP
|
|
|
| LOTTYPE |
char(11)
''
|
Lot Type: ...(more) Join Now
|
IV00101.LOTTYPE
|
|
|
| KPERHIST |
tinyint
0
|
Keep Perio...(more) Join Now
|
RM00101.KPERHIST
|
|
|
| KPTRXHST |
tinyint
0
|
Keep Trx H...(more) Join Now
|
RM00101.KPTRXHST
|
|
|
| KPCALHST |
tinyint
0
|
Keep Calen...(more) Join Now
|
RM00101.KPCALHST
|
|
|
| KPDSTHST |
tinyint
0
|
Keep Distr...(more) Join Now
|
RM00101.KPDSTHST
|
|
|
| ALWBKORD |
tinyint
0
|
Allow Back...(more) Join Now
|
IV00101.ALWBKORD
|
|
|
| VCTNMTHD |
smallint
0
|
span style...(more) Join Now
|
IV00101.VCTNMTHD
|
|
|
| UOMSCHDL |
char(11)
''
|
p>U of M S...(more) Join Now
|
|
|
join ... more text available
|
| ALTITEM1 |
char(31)
''
|
Alternate ...(more) Join Now
|
IV00101.ALTITEM1
|
|
|
| ALTITEM2 |
char(31)
''
|
Alternate ...(more) Join Now
|
IV00101.ALTITEM2
|
|
|
| USCATVLS_1 |
char(11)
''
|
User Categ...(more) Join Now
|
IV00101.USCATVLS_1
|
|
|
| USCATVLS_2 |
char(11)
''
|
User Categ...(more) Join Now
|
IV00101.USCATVLS_2
|
|
|
| USCATVLS_3 |
char(11)
''
|
span style...(more) Join Now
|
IV00101.USCATVLS_3
|
|
|
| USCATVLS_4 |
char(11)
''
|
User Categ...(more) Join Now
|
IV00101.USCATVLS_4
|
|
|
| USCATVLS_5 |
char(11)
''
|
User Categ...(more) Join Now
|
IV00101.USCATVLS_5
|
|
|
| USCATVLS_6 |
char(11)
''
|
Warranty D...(more) Join Now
|
IV00101.USCATVLS_6
|
|
|
| MSTRCDTY |
smallint
0
|
Master Rec...(more) Join Now
|
IV00101.MSTRCDTY
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Created Da...(more) Join Now
|
|
|
|
| WRNTYDYS |
smallint
0
|
span style...(more) Join Now
|
IV00101.WRNTYDYS
|
|
|
| PRCLEVEL |
char(11)
''
|
Price Leve...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| Purch_Inflation_String |
char(129)
''
|
|
|
|
|
| Purch_Monetary_Correctio |
char(129)
''
|
|
|
|
|
| Inventory_Inflation_Stri |
char(129)
''
|
|
|
|
|
| Inventory_Monetary_Corre |
char(129)
''
|
|
|
|
|
| COGS_Inflation_String |
char(129)
''
|
|
|
|
|
| COGS_Monetary_Correction |
char(129)
''
|
|
|
|
|
| ITEMCODE |
char(15)
''
|
Item Code:...(more) Join Now
|
IV00101.ITEMCODE
|
|
|
| TCC |
char(31)
''
|
Tax Commod...(more) Join Now
|
IV00101.TCC
|
|
|
| PriceGroup |
char(11)
''
|
Price Grou...(more) Join Now
|
IV00101.PriceGroup
|
|
|
| PRICMTHD |
smallint
0
|
Price Meth...(more) Join Now
|
IV00101.PRICMTHD
|
|
|
| PRCHSUOM |
char(9)
''
|
Purchasing...(more) Join Now
|
IV00101.PRCHSUOM
|
|
|
| SELNGUOM |
char(9)
''
|
Selling U ...(more) Join Now
|
IV00101.SELNGUOM
|
|
|
| KTACCTSR |
smallint
0
|
Kit COGS A...(more) Join Now
|
IV00101.KTACCTSR
|
|
|
| LASTGENSN |
char(21)
''
|
Last Gener...(more) Join Now
|
IV00101.LASTGENSN
|
|
|
| ABCCODE |
smallint
0
|
ABC Code:&...(more) Join Now
|
IV00101.ABCCODE
|
|
|
| UMSCHDSC |
char(31)
''
|
|
|
|
|
| BASEUOFM |
char(9)
''
|
|
|
|
See I... more text available
|
| Selling_Quantity_in_Base |
numeric(19,5)
0.00
|
|
|
|
|
| Purchasing_Quantity_in_B |
numeric(19,5)
0.00
|
|
|
|
|
| Price_Schedule |
char(11)
''
|
|
|
|
|
| LISTPRCE |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Imported_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Imported_Time |
datetime
'1/1/1900'
|
|
|
|
|
| Migrated |
tinyint
0
|
|
|
|
|
| Migrated_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Migrated_Time |
datetime
'1/1/1900'
|
|
|
|
|
| ERRDESCR |
char(131)
''
|
|
|
|
|
| UMA_Text_Field |
char(255)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|