Item Quantity Master (IV00102)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Item Quantity Master
Physical Name: IV00102
Technical Name: IV_Item_MSTR_QTYS

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
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Item Quantity Master'].ITEMNMBR AS 'Item Quantity Master-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       IV00102 AS ['Item Quantity Master']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Item Quantity Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
2LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Item Quantity Master'].LOCNCODE AS 'Item Quantity Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IV00102 AS ['Item Quantity Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Item Quantity Master'].LOCNCODE = ['Site Setup'].LOCNCODE
3BINNMBR SearchBin NumberSTR20String2220
4RCRDTYPE SearchRecord TypeINT1Integer21
5PRIMVNDR SearchPrimary VendorSTR_15_Vendor_IDString1615
6ITMFRFLG SearchItem Freeze FlagYNBoolean20
7BGNGQTY SearchBeginning QTYDLR17_QTY_RBS0_STRCurrency1017
8LSORDQTY SearchLast ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
9LRCPTQTY SearchLast RCPT QTYDLR17_QTY_RBS0_UTRCurrency1017
10LSTORDDT SearchLast ORD DateDATEDate46
11LSORDVND SearchLast ORD VendorSTR_15_Vendor_IDString1615
12LSRCPTDT SearchLast RCPT DateDATEDate46
13QTYRQSTN SearchQTY RequisitionedDLR17_QTY_RBS0_UTRCurrency1017
14QTYONORD SearchQTY On OrderDLR17_QTY_RBS0_UTRCurrency1017
15QTYBKORD SearchQTY Back OrderedDLR17_QTY_RBS0_UTRCurrency1017
16QTY_Drop_Shipped SearchQTY Drop ShippedDLR17_QTY_RBS0_UTRCurrency1017
17QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency1017
18QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency1017
19QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency1017
20QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency1017
21QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency1017
22ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
23QTYCOMTD SearchQTY CommittedDLR17_QTY_RBS0_UTRCurrency1017
24QTYSOLD SearchQTY SoldDLR17_QTY_RBS0_UTRCurrency1017
25NXTCNTDT SearchNext Count DateDTDate48
26NXTCNTTM SearchNext Count TimeTM6Time46
27LSTCNTDT SearchLast Count DateDTDate48
28LSTCNTTM SearchLast Count TimeTM6Time46
29STCKCNTINTRVL SearchStock Count IntervalINT4_U0Integer24
30Landed_Cost_Group_ID SearchLanded Cost Group IDSTR15_LBAUString1615
31BUYERID SearchBuyer IDSTR15_User_IDString1615
32PLANNERID SearchPlanner IDSTR15_User_IDString1615
33ORDERPOLICY SearchOrder PolicyDDL_Order_PolicyInteger20
34FXDORDRQTY SearchFixed Order QtyDLR17_QTY_RBS0_UTRCurrency1017
35ORDRPNTQTY SearchOrder Point QtyDLR17_QTY_RBS0_UTRCurrency1017
36NMBROFDYS SearchNumber of DaysINT3_U0Integer23
37MNMMORDRQTY SearchMinimum Order QtyDLR17_QTY_RBS0_UTRCurrency1017
38MXMMORDRQTY SearchMaximum Order QtyDLR17_QTY_RBS0_UTRCurrency1017
39ORDERMULTIPLE SearchOrder MultipleDLR17_QTY_RBS0_UTRCurrency1017
40REPLENISHMENTMETHOD SearchReplenishment MethodDDL_Replenishment_MethodInteger20
41SHRINKAGEFACTOR SearchShrinkage FactorDLR1_4Currency106
42PRCHSNGLDTM SearchPurchasing Lead TimeDLR4_U2Currency109
43MNFCTRNGFXDLDTM SearchManufacturing Fixed Lead TimeDLR4_U2Currency109
44MNFCTRNGVRBLLDTM SearchManufacturing Variable Lead TimeDLR3_U4Currency108
45STAGINGLDTME SearchStaging Lead TimeDLR4_U2Currency109
46PLNNNGTMFNCDYS SearchPlanning Time Fence DaysINT3_U0Integer23
47DMNDTMFNCPRDS SearchDemand Time Fence PeriodsINT3_U0Integer23
48INCLDDINPLNNNG SearchIncluded in PlanningCBBoolean20
49CALCULATEATP SearchCalculate ATPCBBoolean20
50AUTOCHKATP SearchAuto Check ATPCBBoolean20
51PLNFNLPAB SearchPlan Final PABCBBoolean20
52FRCSTCNSMPTNPRD SearchForecast Consumption PeriodDDL_Forecast_Consumption_PeriodInteger20
53ORDRUPTOLVL SearchOrder Up To LevelDLR17_QTY_RBS0_UTRCurrency1017
54SFTYSTCKQTY SearchSafety Stock QtyDLR17_QTY_RBS0_UTRCurrency1017
55REORDERVARIANCE SearchReorder VarianceDLR17_QTY_RBS0_UTRCurrency1017
56PORECEIPTBIN SearchPurchase Receipt BinSTR15_BinString1615
57PORETRNBIN SearchPurchase Returns BinSTR15_BinString1615
58SOFULFILLMENTBIN SearchSO Fulfillment BinSTR15_BinString1615
59SORETURNBIN SearchSO Return BinSTR15_BinString1615
60BOMRCPTBIN SearchBOM Receipt BinSTR15_BinString1615
61MATERIALISSUEBIN SearchMaterial Issues BinSTR15_BinString1615
62MORECEIPTBIN SearchMO Receipt BinSTR15_BinString1615
63REPAIRISSUESBIN SearchRepair Issues BinSTR15_BinString1615
64ReplenishmentLevel SearchReplenishment LevelDDL_ReplenishmentLevelInteger20
65POPOrderMethod SearchPOP Order MethodDDL_POP_OrderMethodInteger20
66MasterLocationCode SearchMaster Location CodeSTR10_Location_CodeString1210
67POPVendorSelection SearchPOP Vendor SelectionDDL_POP_VendorSelectionInteger20
68POPPricingSelection SearchPOP Pricing SelectionDDL_POP_PriceSelectionInteger20
69PurchasePrice SearchPurchase PriceDLR17_RBS0_UTR$Currency1017
70IncludeAllocations SearchInclude AllocationsCB_IncludeAllocationsBoolean20
71IncludeBackorders SearchInclude BackordersCB_IncludeBackordersBoolean20
72IncludeRequisitions SearchInclude RequisitionsCB_IncludeRequisitionsBoolean20
73PICKTICKETITEMOPT SearchPicking Ticket Item OptionDDL_PickingTicketItemOptionInteger20
74INCLDMRPMOVEIN SearchIncludeMRPMoveInIncludeMRPMoveInBoolean20
75INCLDMRPMOVEOUT SearchIncludeMRPMoveOutIncludeMRPMoveOutBoolean20
76INCLDMRPCANCEL SearchIncludeMRPCancelIncludeMRPCancelBoolean20
77Move_Out_Fence SearchMove-Out FenceINT3_U0Integer23
78INACTIVE SearchInactiveCB_InactiveBoolean20
79DEX_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 *