| ITMCLSCD |
char(11)
''
|
Item Class...(more) Join Now
|
|
|
|
| ITMCLSDC |
char(31)
''
|
Item Class Description
|
Sandy
|
|
|
| DEFLTCLS |
tinyint
0
|
Default Cl...(more) Join Now
|
PM00100.DEFLTCLS
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| ITEMTYPE |
smallint
0
|
span style...(more) Join Now
|
IV00101.ITEMTYPE
|
|
|
| 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
|
|
|
| ITMGEDSC |
char(11)
''
|
span style...(more) Join Now
|
IV00101.ITMGEDSC
|
|
|
| TAXOPTNS |
smallint
0
|
Tax Option...(more) Join Now
|
IV00101.TAXOPTNS
|
|
|
| ITMTSHID |
char(15)
''
|
Item Tax S...(more) Join Now
|
IV00101.ITMTSHID
|
|
|
| Purchase_Tax_Options |
smallint
0
|
Purchase T...(more) Join Now
|
IV00101.Purchase_Tax_Options
|
|
|
| Purchase_Item_Tax_Schedu |
char(15)
''
|
Purchase I...(more) Join Now
|
IV00101.Purchase_Item_Tax_Schedu
|
|
|
| UOMSCHDL |
char(11)
''
|
p>U of M S...(more) Join Now
|
|
|
join ... more text available
|
| VCTNMTHD |
smallint
0
|
span style...(more) Join Now
|
IV00101.VCTNMTHD
|
|
|
| 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
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| IVIVINDX |
int
0
|
IV IV Inde...(more) Join Now
|
|
|
|
| IVIVOFIX |
int
0
|
IV IV Offs...(more) Join Now
|
|
|
|
| IVCOGSIX |
int
0
|
IV COGS In...(more) Join Now
|
IV00101.IVCOGSIX
|
|
|
| IVSLSIDX |
int
0
|
IV Sales I...(more) Join Now
|
IV00101.IVSLSIDX
|
|
|
| IVSLDSIX |
int
0
|
IV Sales D...(more) Join Now
|
IV00101.IVSLDSIX
|
|
|
| IVSLRNIX |
int
0
|
span style...(more) Join Now
|
IV00101.IVSLRNIX
|
|
|
| IVINUSIX |
int
0
|
span style...(more) Join Now
|
IV00101.IVINUSIX
|
|
|
| IVINSVIX |
int
0
|
IV In Serv...(more) Join Now
|
IV00101.IVINSVIX
|
|
|
| IVDMGIDX |
int
0
|
IV Damaged...(more) Join Now
|
IV00101.IVDMGIDX
|
|
|
| IVVARIDX |
int
0
|
IV Varianc...(more) Join Now
|
IV00101.IVVARIDX
|
|
|
| DPSHPIDX |
int
0
|
Drop Ship ...(more) Join Now
|
IV00101.DPSHPIDX
|
|
|
| PURPVIDX |
int
0
|
Purchase P...(more) Join Now
|
IV00101.PURPVIDX
|
|
|
| UPPVIDX |
int
0
|
Unrealized...(more) Join Now
|
IV00101.UPPVIDX
|
|
|
| IVRETIDX |
int
0
|
Inventory ...(more) Join Now
|
IV00101.IVRETIDX
|
|
|
| ASMVRIDX |
int
0
|
Assembly V...(more) Join Now
|
IV00101.ASMVRIDX
|
|
|
| PRCLEVEL |
char(11)
''
|
Price Leve...(more) Join Now
|
|
|
|
| PriceGroup |
char(11)
''
|
Price Grou...(more) Join Now
|
IV00101.PriceGroup
|
|
|
| PRICMTHD |
smallint
0
|
Price Meth...(more) Join Now
|
IV00101.PRICMTHD
|
|
|
| TCC |
char(31)
''
|
Tax Commod...(more) Join Now
|
IV00101.TCC
|
|
|
| Revalue_Inventory |
tinyint
0
|
Revalue In...(more) Join Now
|
IV00101.Revalue_Inventory
|
|
|
| Tolerance_Percentage |
int
0
|
Tolerance ...(more) Join Now
|
IV00101.Tolerance_Percentage
|
|
|
| CNTRYORGN |
char(7)
''
|
Country Or...(more) Join Now
|
IV00101.CNTRYORGN
|
|
|
| STTSTCLVLPRCNTG |
smallint
0
|
Statistica...(more) Join Now
|
IV00101.STTSTCLVLPRCNTG
|
|
|
| INCLUDEINDP |
tinyint
0
|
Include in...(more) Join Now
|
RM00101.INCLUDEINDP
|
|
|
| LOTEXPWARN |
tinyint
0
|
Lot Expire...(more) Join Now
|
IV00101.LOTEXPWARN
|
|
|
| LOTEXPWARNDAYS |
smallint
0
|
span style...(more) Join Now
|
IV00101.LOTEXPWARNDAYS
|
|
|
| UseQtyOverageTolerance |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| UseQtyShortageTolerance |
tinyint
0
|
|
|
|
|
| QtyOverTolerancePercent |
int
0
|
|
|
|
|
| QtyShortTolerancePercent |
int
0
|
|
|
|
|
| IVSCRVIX |
int
0
|
Technical ...(more) Join Now
|
|
|
|