biuan SAP® BUSINESS ONE SDK
API Document Lines / Batch Numbers
ITL1 - Srl & Batch Details in Transac Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LogEntry KEY UNIQUELog Internal IDInt
11OITL
Inventory Transactions Log
PRIMARYYes
ItemCode KEYItem CodenVarChar
20OITM
Items
SNB_SYSIDNo
SysNumberSystem NumberInt
11
QuantityQuantityNum
20
AllocQtyAllocated QuantityNum
20
MdAbsEntryMD Abs EntryInt
11
ReleaseQtyRelease QuantityNum
20
PickedQtyPicked QuantityNum
20

Table relationship map

SELECT statement

SELECT ITL1.LogEntry AS 'Log Internal ID', ITL1.ItemCode AS 'Item Code', ITL1.SysNumber AS 'System Number', ITL1.Quantity AS 'Quantity', ITL1.AllocQty AS 'Allocated Quantity', ITL1.MdAbsEntry AS 'MD Abs Entry', ITL1.ReleaseQty AS 'Release Quantity', ITL1.PickedQty AS 'Picked Quantity' FROM ITL1 AS ITL1

Related information


Batch Numbers BatchNumbers Object· Table: OBTN BTNT
BatchNumbers is a business object that represents the batch numbers of an item in the Inventory and Production module. This object enables you to add batch numbers for a selected item row (one record per item). Source table: OBTN, OBTW, OITL,...
   Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
Items OITM SQL Table

Inventory Transactions Log OITL SQL Table



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