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 TypeLength
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_CodeString10
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 NumberSTR20String20
4RCRDTYPE SearchRecord TypeINT1Integer1
5PRIMVNDR SearchPrimary VendorSTR_15_Vendor_IDString15
6ITMFRFLG SearchItem Freeze FlagYNBoolean0
7BGNGQTY SearchBeginning QTYDLR17_QTY_RBS0_STRCurrency17
8LSORDQTY SearchLast ORD QTYDLR17_QTY_RBS0_UTRCurrency17
9LRCPTQTY SearchLast RCPT QTYDLR17_QTY_RBS0_UTRCurrency17
10LSTORDDT SearchLast ORD DateDATEDate6
11LSORDVND SearchLast ORD VendorSTR_15_Vendor_IDString15
12LSRCPTDT SearchLast RCPT DateDATEDate6
13QTYRQSTN SearchQTY RequisitionedDLR17_QTY_RBS0_UTRCurrency17
14QTYONORD SearchQTY On OrderDLR17_QTY_RBS0_UTRCurrency17
15QTYBKORD SearchQTY Back OrderedDLR17_QTY_RBS0_UTRCurrency17
16QTY_Drop_Shipped SearchQTY Drop ShippedDLR17_QTY_RBS0_UTRCurrency17
17QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency17
18QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency17
19QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency17
20QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency17
21QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency17
22ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
23QTYCOMTD SearchQTY CommittedDLR17_QTY_RBS0_UTRCurrency17
24QTYSOLD SearchQTY SoldDLR17_QTY_RBS0_UTRCurrency17
25NXTCNTDT SearchNext Count DateDTDate8
26NXTCNTTM SearchNext Count TimeTM6Time6
27LSTCNTDT SearchLast Count DateDTDate8
28LSTCNTTM SearchLast Count TimeTM6Time6
29STCKCNTINTRVL SearchStock Count IntervalINT4_U0Integer4
30Landed_Cost_Group_ID SearchLanded Cost Group IDSTR15_LBAUString15
31BUYERID SearchBuyer IDSTR15_User_IDString15
32PLANNERID SearchPlanner IDSTR15_User_IDString15
33ORDERPOLICY SearchOrder PolicyDDL_Order_PolicyInteger0
34FXDORDRQTY SearchFixed Order QtyDLR17_QTY_RBS0_UTRCurrency17
35ORDRPNTQTY SearchOrder Point QtyDLR17_QTY_RBS0_UTRCurrency17
36NMBROFDYS SearchNumber of DaysINT3_U0Integer3
37MNMMORDRQTY SearchMinimum Order QtyDLR17_QTY_RBS0_UTRCurrency17
38MXMMORDRQTY SearchMaximum Order QtyDLR17_QTY_RBS0_UTRCurrency17
39ORDERMULTIPLE SearchOrder MultipleDLR17_QTY_RBS0_UTRCurrency17
40REPLENISHMENTMETHOD SearchReplenishment MethodDDL_Replenishment_MethodInteger0
41SHRINKAGEFACTOR SearchShrinkage FactorDLR1_4Currency6
42PRCHSNGLDTM SearchPurchasing Lead TimeDLR4_U2Currency9
43MNFCTRNGFXDLDTM SearchManufacturing Fixed Lead TimeDLR4_U2Currency9
44MNFCTRNGVRBLLDTM SearchManufacturing Variable Lead TimeDLR3_U4Currency8
45STAGINGLDTME SearchStaging Lead TimeDLR4_U2Currency9
46PLNNNGTMFNCDYS SearchPlanning Time Fence DaysINT3_U0Integer3
47DMNDTMFNCPRDS SearchDemand Time Fence PeriodsINT3_U0Integer3
48INCLDDINPLNNNG SearchIncluded in PlanningCBBoolean0
49CALCULATEATP SearchCalculate ATPCBBoolean0
50AUTOCHKATP SearchAuto Check ATPCBBoolean0
51PLNFNLPAB SearchPlan Final PABCBBoolean0
52FRCSTCNSMPTNPRD SearchForecast Consumption PeriodDDL_Forecast_Consumption_PeriodInteger0
53ORDRUPTOLVL SearchOrder Up To LevelDLR17_QTY_RBS0_UTRCurrency17
54SFTYSTCKQTY SearchSafety Stock QtyDLR17_QTY_RBS0_UTRCurrency17
55REORDERVARIANCE SearchReorder VarianceDLR17_QTY_RBS0_UTRCurrency17
56PORECEIPTBIN SearchPurchase Receipt BinSTR15_BinString15
57PORETRNBIN SearchPurchase Returns BinSTR15_BinString15
58SOFULFILLMENTBIN SearchSO Fulfillment BinSTR15_BinString15
59SORETURNBIN SearchSO Return BinSTR15_BinString15
60BOMRCPTBIN SearchBOM Receipt BinSTR15_BinString15
61MATERIALISSUEBIN SearchMaterial Issues BinSTR15_BinString15
62MORECEIPTBIN SearchMO Receipt BinSTR15_BinString15
63REPAIRISSUESBIN SearchRepair Issues BinSTR15_BinString15
64ReplenishmentLevel SearchReplenishment LevelDDL_ReplenishmentLevelInteger0
65POPOrderMethod SearchPOP Order MethodDDL_POP_OrderMethodInteger0
66MasterLocationCode SearchMaster Location CodeSTR10_Location_CodeString10
67POPVendorSelection SearchPOP Vendor SelectionDDL_POP_VendorSelectionInteger0
68POPPricingSelection SearchPOP Pricing SelectionDDL_POP_PriceSelectionInteger0
69PurchasePrice SearchPurchase PriceDLR17_RBS0_UTR$Currency17
70IncludeAllocations SearchInclude AllocationsCB_IncludeAllocationsBoolean0
71IncludeBackorders SearchInclude BackordersCB_IncludeBackordersBoolean0
72IncludeRequisitions SearchInclude RequisitionsCB_IncludeRequisitionsBoolean0
73PICKTICKETITEMOPT SearchPicking Ticket Item OptionDDL_PickingTicketItemOptionInteger0
74INCLDMRPMOVEIN SearchIncludeMRPMoveInIncludeMRPMoveInBoolean0
75INCLDMRPMOVEOUT SearchIncludeMRPMoveOutIncludeMRPMoveOutBoolean0
76INCLDMRPCANCEL SearchIncludeMRPCancelIncludeMRPCancelBoolean0
77Move_Out_Fence SearchMove-Out FenceINT3_U0Integer3
78INACTIVE SearchInactiveCB_InactiveBoolean0
79DEX_ROW_ID Searchintint10

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 *