Item Class Setup (IV40400)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Item Class Setup
Physical Name: IV40400
Technical Name: IV_Item_Class_SETP

Group Display Name: Item Class Setup
Group Technical Name: Item Class Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ITMCLSCD SearchItem Class CodeSTR10_Class_IDString1210
2ITMCLSDC SearchItem Class DescriptionSTR30String3230
3DEFLTCLS SearchDefault ClassCB_DefaultBoolean20
4NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Item Class Setup'].NOTEINDX AS 'Item Class Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Item Class Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
5ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
6ITMTRKOP 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
7LOTTYPE SearchLot TypeSTR10_Lot_TypeString1210
8KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
9KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
10KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
11KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
12ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
13ITMGEDSC SearchItem Generic DescriptionSTR10String1210
14TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger20
15ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Item Class Setup'].ITMTSHID AS 'Item Class Setup-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Class Setup'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
16Purchase_Tax_Options SearchPurchase Tax OptionsDDL_Purchase_Tax_OptionsInteger20
17Purchase_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 Class Setup'].Purchase_Item_Tax_Schedu AS 'Item Class Setup-Purchase Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Class Setup'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
18UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['Item Class Setup'].UOMSCHDL AS 'Item Class Setup-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['Item Class Setup'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
19VCTNMTHD 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
20USCATVLS SearchUser Category ValuesUser_Category_ValueString1210
21USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
22USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
23USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
24USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
25USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
26USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
27DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
28IVIVINDX SearchIV IV IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['Item Class Setup'].ASMVRIDX AS 'Item Class Setup-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].ASMVRIDX = ['Account Index Master'].ACTINDX
43PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
44PriceGroup SearchPrice GroupSTR10_LBAUString1210
45PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
46TCC SearchTax Commodity CodeSTR30_VATString3230
47Revalue_Inventory SearchRevalue InventoryCB_Revalue_InventoryBoolean20
48Tolerance_Percentage SearchTolerance PercentageLI7_U%3Long Integer47
49CNTRYORGN SearchCountry OriginSTR6_VATString86
50STTSTCLVLPRCNTG SearchStatistical Value PercentageINT4_%2Integer24
51INCLUDEINDP SearchInclude in Demand PlanningCB_IncludeInDemandPlanningBoolean20
52LOTEXPWARN SearchLot Expire WarningCB_Lot_Expire_WarningBoolean20
53LOTEXPWARNDAYS SearchLot Expire Warning DaysINT3_RB0_UInteger23
54UseQtyOverageTolerance SearchUse Qty Overage ToleranceCBBoolean20
55UseQtyShortageTolerance SearchUse Qty Shortage ToleranceCBBoolean20
56QtyOverTolerancePercent SearchQty Overage Tolerance PercentageLI5_%3Long Integer45
57QtyShortTolerancePercent SearchQty Shortage Tolerance PercentageLI5_%3Long Integer45
58IVSCRVIX SearchIV STD Cost Revaluation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Class Setup'].IVSCRVIX AS 'Item Class Setup-IV STD Cost Revaluation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVSCRVIX = ['Account Index Master'].ACTINDX
59DEX_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 *