DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module IV tables IV00101
You are currently viewing the COMPANY database.
Change

COMPANY..IV00101 Table Definition

(COMPANY..Item Master)

There are special circumstances importing into the Item Master.  This is normally a dropdown list with values of 0-5 which would be the import values 1-6.  The IU tries to match the imported value to the values in the dropdown and if it finds a match it will set the correct value for you.  In this case, importing the correct value of 3 (to get 2 decimal places because 2 is 3rd on the list) will get you 3 decimal places.  The IU has matched 3 with the list and set it as 4 because it was 4th on the list.  This only affects the IU, using ODBC or another entry method, enter the correct value (3 in this case).


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
ITEMDESC char(101)
''
Item Descr...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
ITMSHNAM char(15)
''
Item Short...(more) Join Now
ITEMTYPE smallint
0
span style...(more) Join Now
ITMGEDSC char(11)
''
span style...(more) Join Now
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
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
TAXOPTNS smallint
0
Tax Option...(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
IVSLSIDX int
0
IV Sales I...(more) Join Now
IVSLDSIX int
0
IV Sales D...(more) Join Now
IVSLRNIX int
0
span style...(more) Join Now
IVINUSIX int
0
span style...(more) Join Now
IVINSVIX int
0
IV In Serv...(more) Join Now
IVDMGIDX int
0
IV Damaged...(more) Join Now
IVVARIDX int
0
IV Varianc...(more) Join Now
DPSHPIDX int
0
Drop Ship ...(more) Join Now
PURPVIDX int
0
Purchase P...(more) Join Now
UPPVIDX int
0
Unrealized...(more) Join Now
IVRETIDX int
0
Inventory ...(more) Join Now
ASMVRIDX int
0
Assembly V...(more) Join Now
ITMCLSCD char(11)
''
Item Class...(more) Join Now
ITMTRKOP smallint
0
Item Track...(more) Join Now
LOTTYPE char(11)
''
Lot Type: ...(more) Join Now
KPERHIST tinyint
0
Keep Perio...(more) Join Now
KPTRXHST tinyint
0
Keep Trx H...(more) Join Now
KPCALHST tinyint
0
span style...(more) Join Now
KPDSTHST tinyint
0
Keep Distr...(more) Join Now
ALWBKORD tinyint
0
Allow Back...(more) Join Now
VCTNMTHD smallint
0
span style...(more) Join Now
UOMSCHDL char(11)
''
p>U of M S...(more) Join Now
join ... more text available
ALTITEM1 char(31)
''
Alternate ...(more) Join Now
ALTITEM2 char(31)
''
Alternate ...(more) Join Now
USCATVLS_1 char(11)
''
User Categ...(more) Join Now
USCATVLS_2 char(11)
''
User Categ...(more) Join Now
USCATVLS_3 char(11)
''
span style...(more) Join Now
USCATVLS_4 char(11)
''
User Categ...(more) Join Now
USCATVLS_5 char(11)
''
User Categ...(more) Join Now
USCATVLS_6 char(11)
''
User Categ...(more) Join Now
MSTRCDTY smallint
0
Master Rec...(more) Join Now
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
PRCLEVEL char(11)
''
Price Leve...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
PINFLIDX int
0
Purch Infl...(more) Join Now
PURMCIDX int
0
Purch Mone...(more) Join Now
IVINFIDX int
0
Inventory ...(more) Join Now
INVMCIDX int
0
span style...(more) Join Now
CGSINFLX int
0
COGS Infla...(more) Join Now
CGSMCIDX int
0
COGS Monet...(more) Join Now
ITEMCODE char(15)
''
Item Code:...(more) Join Now
TCC char(31)
''
Tax Commod...(more) Join Now
PriceGroup char(11)
''
Price Grou...(more) Join Now
PRICMTHD smallint
0
Price Meth...(more) Join Now
PRCHSUOM char(9)
''
Purchasing...(more) Join Now
SELNGUOM char(9)
''
Selling U ...(more) Join Now
KTACCTSR smallint
0
Kit COGS A...(more) Join Now
LASTGENSN char(21)
''
Last Gener...(more) Join Now
ABCCODE smallint
0
ABC Code:&...(more) Join Now
Revalue_Inventory tinyint
0
Revalue In...(more) Join Now
Tolerance_Percentage int
0
Tolerance ...(more) Join Now
Purchase_Item_Tax_Schedu char(15)
''
Purchase I...(more) Join Now
Purchase_Tax_Options smallint
0
Purchase T...(more) Join Now
ITMPLNNNGTYP smallint
0
p>Item Pla...(more) Join Now
STTSTCLVLPRCNTG smallint
0
Statistica...(more) Join Now
CNTRYORGN char(7)
''
Country Or...(more) Join Now
INACTIVE tinyint
0
Inactive:&...(more) Join Now
MINSHELF1 smallint
0
p>MinShelf...(more) Join Now
MINSHELF2 smallint
0
MinShelfLi...(more) Join Now
INCLUDEINDP tinyint
0
Include in...(more) Join Now
LOTEXPWARN tinyint
0
Lot Expire...(more) Join Now
LOTEXPWARNDAYS smallint
0
span style...(more) Join Now
LASTGENLOT char(21)
''
Last Gener...(more) Join Now
Lot_Split_Quantity numeric(19,5)
0.00

UseQtyOverageTolerance tinyint
0

DEX_ROW_TS datetime
(getutcdate())
 Time Stamp...(more) Join Now
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

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3