ITL1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

API Document Lines / Batch Numbers

ITL1 - Srl & Batch Details in Transac Table

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
LogEntry ^KEY ^UNIQUE	Log Internal ID	Int	11	OITL Inventory Transactions Log	PRIMARY	Yes
ItemCode ^KEY	Item Code	nVarChar	20	OITM Items	SNB_SYSID	No
SysNumber	System Number	Int	11
Quantity	Quantity	Num	20
AllocQty	Allocated Quantity	Num	20
MdAbsEntry	MD Abs Entry	Int	11
ReleaseQty	Release Quantity	Num	20
PickedQty	Picked Quantity	Num	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

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
OITM SQL Table

OITL SQL Table

biuan SAP® BUSINESS ONE

Object
Document_Lines

Object
BatchNumbers

Method

Add

SetCurrentLine

Property

AddmisionDate

DTW DB

BaseLineNumber

DTW DB

BatchNumber

DTW DB

Count

ExpiryDate

DTW DB

InternalSerialNumber

DTW DB

Location

DTW DB

ManufacturerSerialNumber

DTW DB

ManufacturingDate

DTW DB

Notes

DTW DB

Quantity

DTW DB

TrackingNote

TrackingNoteLine

UserFields

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