biuan SAP® BUSINESS ONE SDK
API Inventory Counting Line Uo Ms / Inventory Counting Line Uo M
INC2 - Inventory Counting - UoM Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11OINC
Inventory Counting
BUSINESSYes
LineNumRow NumberInt
11
ChildNumChild NumberInt
11
BarCodeBar CodenVarChar
127
UomCodeUoM CodenVarChar
20OUOM
UoM Master Data
UomQtyUoM Counted QtyNum
20
CountQtyCounted Qty of Inventory UoMNum
20
Tk1UomQtyCounter 1 UoM Counted QtyNum
20
Tk2UomQtyNum
20
Tk1CntQtyCounter 1 Counted Qty of Inv.Num
20
Tk2CntQtyNum
20
ItmsPerUntItems per UnitNum
20
LogInsLog Instance - HistoryInt
11
UgpEntryUoM Group Abs. EntryInt
11OUGP
UoM Group
TeamUomQtyTeam UoM Counted QtyNum
20
TeamCntQtyTeam Counted QtyNum
20
IUomEntryInventory UoM EntrynVarChar
20OUOM
UoM Master Data

Table relationship map

SELECT statement

SELECT INC2.DocEntry AS 'Internal Number', INC2.LineNum AS 'Row Number', INC2.ChildNum AS 'Child Number', INC2.BarCode AS 'Bar Code', INC2.UomCode AS 'UoM Code', INC2.UomQty AS 'UoM Counted Qty', INC2.CountQty AS 'Counted Qty of Inventory UoM', INC2.Tk1UomQty AS 'Counter 1 UoM Counted Qty', INC2.Tk2UomQty AS '', INC2.Tk1CntQty AS 'Counter 1 Counted Qty of Inv.', INC2.Tk2CntQty AS '', INC2.ItmsPerUnt AS 'Items per Unit', INC2.LogIns AS 'Log Instance - History', INC2.UgpEntry AS 'UoM Group Abs. Entry', INC2.TeamUomQty AS 'Team UoM Counted Qty', INC2.TeamCntQty AS 'Team Counted Qty', INC2.IUomEntry AS 'Inventory UoM Entry' FROM INC2 AS INC2

Related information


Inventory Counting Line Uo M InventoryCountingLineUoM Object· Table: INC2V
InventoryCountingLineUoM is a child object of the InventoryCountingLine object and enables you to count inventory by unit of measure (UoM). Source table: INC2V, INC2.   INC2V table contains information of multiple UoMs.
   Parent: Inventory Counting Line Uo Ms InventoryCountingLineUoMs Collection
Inventory Counting OINC SQL Table

UoM Master Data OUOM SQL Table

UoM Group OUGP SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates