Item Master (IV00101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00101

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Item Master
Physical Name: IV00101
Technical Name: IV_Item_MSTR_IC

Group Display Name: Item Master
Group Technical Name: Item Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
2ITEMDESC SearchItem DescriptionSTR100String102100
3NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Item Master'].NOTEINDX AS 'Item Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Item Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4ITMSHNAM SearchItem Short NameSTR15String1615
5ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
6ITMGEDSC SearchItem Generic DescriptionSTR10String1210
7STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
8CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
9ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
10DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
11DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
12ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Item Master'].ITMTSHID AS 'Item Master-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Master'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
13TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger20
14IVIVINDX SearchIV IV IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVIVINDX AS 'Item Master-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVIVINDX = ['Account Index Master'].ACTINDX
15IVIVOFIX SearchIV IV Offset IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVIVOFIX AS 'Item Master-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVIVOFIX = ['Account Index Master'].ACTINDX
16IVCOGSIX SearchIV COGS IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVCOGSIX AS 'Item Master-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVCOGSIX = ['Account Index Master'].ACTINDX
17IVSLSIDX SearchIV Sales IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSLSIDX AS 'Item Master-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSLSIDX = ['Account Index Master'].ACTINDX
18IVSLDSIX SearchIV Sales Discounts IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSLDSIX AS 'Item Master-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSLDSIX = ['Account Index Master'].ACTINDX
19IVSLRNIX SearchIV Sales Returns IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSLRNIX AS 'Item Master-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSLRNIX = ['Account Index Master'].ACTINDX
20IVINUSIX SearchIV In Use IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVINUSIX AS 'Item Master-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVINUSIX = ['Account Index Master'].ACTINDX
21IVINSVIX SearchIV In Service IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVINSVIX AS 'Item Master-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVINSVIX = ['Account Index Master'].ACTINDX
22IVDMGIDX SearchIV Damaged IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVDMGIDX AS 'Item Master-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVDMGIDX = ['Account Index Master'].ACTINDX
23IVVARIDX SearchIV Variances IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVVARIDX AS 'Item Master-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVVARIDX = ['Account Index Master'].ACTINDX
24DPSHPIDX SearchDrop Ship IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].DPSHPIDX AS 'Item Master-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].DPSHPIDX = ['Account Index Master'].ACTINDX
25PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].PURPVIDX AS 'Item Master-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].PURPVIDX = ['Account Index Master'].ACTINDX
26UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].UPPVIDX AS 'Item Master-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].UPPVIDX = ['Account Index Master'].ACTINDX
27IVRETIDX SearchInventory Returns IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVRETIDX AS 'Item Master-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVRETIDX = ['Account Index Master'].ACTINDX
28ASMVRIDX SearchAssembly Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].ASMVRIDX AS 'Item Master-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].ASMVRIDX = ['Account Index Master'].ACTINDX
29ITMCLSCD SearchItem Class CodeSTR10_Class_IDString1210
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['Item Master'].ITMCLSCD AS 'Item Master-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['Item Master'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
30ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
Designation for the tracking type of the Item.

Click to show/hide Item Tracking Options

1	0 decimals
2	1
3	2
4	3
5	4
6	5
31LOTTYPE SearchLot TypeSTR10_Lot_TypeString1210
32KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
33KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
34KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
35KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
36ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
37VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
The valuation method for the inventory line item.

Click to show/hide Valuation methods

1	FIFO Perpetual
2	LIFO Perpetual
3	Average Perpetual
4	FIFO Periodic
5	LIFO Periodic
38UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['Item Master'].UOMSCHDL AS 'Item Master-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['Item Master'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
39ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString3230
40ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
41USCATVLS SearchUser Category ValuesUser_Category_ValueString1210
42USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
43USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
44USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
45USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
46USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
47USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
48MSTRCDTY SearchMaster Record TypeINT1Integer21
49MODIFDT SearchModified DateDTDate48
50CREATDDT SearchCreated DateDTDate48
51WRNTYDYS SearchWarranty DaysINT4Integer24
52PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
53LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Item Master'].LOCNCODE AS 'Item Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Item Master'].LOCNCODE = ['Site Setup'].LOCNCODE
54PINFLIDX SearchPurch Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].PINFLIDX AS 'Item Master-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].PINFLIDX = ['Account Index Master'].ACTINDX
55PURMCIDX SearchPurch Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].PURMCIDX AS 'Item Master-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].PURMCIDX = ['Account Index Master'].ACTINDX
56IVINFIDX SearchInventory Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVINFIDX AS 'Item Master-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVINFIDX = ['Account Index Master'].ACTINDX
57INVMCIDX SearchInventory Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].INVMCIDX AS 'Item Master-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].INVMCIDX = ['Account Index Master'].ACTINDX
58CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].CGSINFLX AS 'Item Master-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].CGSINFLX = ['Account Index Master'].ACTINDX
59CGSMCIDX SearchCOGS Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].CGSMCIDX AS 'Item Master-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].CGSMCIDX = ['Account Index Master'].ACTINDX
60ITEMCODE SearchItem CodeSTR15String1615
61TCC SearchTax Commodity CodeSTR30_VATString3230
62PriceGroup SearchPrice GroupSTR10_LBAUString1210
63PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
64PRCHSUOM SearchPurchasing U Of MU_Of_MString108
65SELNGUOM SearchSelling U Of MU_Of_MString108
66KTACCTSR SearchKit COGS Account SourceGBInteger20
67LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString2220
68ABCCODE SearchABC CodeDDL_ABC_CodeInteger20
69Revalue_Inventory SearchRevalue InventoryCB_Revalue_InventoryBoolean20
70Tolerance_Percentage SearchTolerance PercentageLI7_U%3Long Integer47
71Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Item Master'].Purchase_Item_Tax_Schedu AS 'Item Master-Purchase Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Master'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72Purchase_Tax_Options SearchPurchase Tax OptionsDDL_Purchase_Tax_OptionsInteger20
73ITMPLNNNGTYP SearchItem Planning TypeDDL_Item_Planning_TypeInteger20
74STTSTCLVLPRCNTG SearchStatistical Value PercentageINT4_%2Integer24
75CNTRYORGN SearchCountry OriginSTR6_VATString86
76INACTIVE SearchInactiveCB_InactiveBoolean20
77MINSHELF1 SearchMinShelfLife1INT4_U0Integer24
78MINSHELF2 SearchMinShelfLife2INT4_U0Integer24
79INCLUDEINDP SearchInclude in Demand PlanningCB_IncludeInDemandPlanningBoolean20
80LOTEXPWARN SearchLot Expire WarningCB_Lot_Expire_WarningBoolean20
81LOTEXPWARNDAYS SearchLot Expire Warning DaysINT3_RB0_UInteger23
82LASTGENLOT SearchLast Generated Lot NumberSTR20_LBAUString2220
83Lot_Split_Quantity SearchLot Split QuantityDLR17_QTY_RBS0_UTRCurrency1017
84UseQtyOverageTolerance SearchUse Qty Overage ToleranceCBBoolean20
85UseQtyShortageTolerance SearchUse Qty Shortage ToleranceCBBoolean20
86QtyOverTolerancePercent SearchQty Overage Tolerance PercentageLI5_%3Long Integer45
87QtyShortTolerancePercent SearchQty Shortage Tolerance PercentageLI5_%3Long Integer45
88IVSCRVIX SearchIV STD Cost Revaluation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSCRVIX AS 'Item Master-IV STD Cost Revaluation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSCRVIX = ['Account Index Master'].ACTINDX
89DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
90DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *