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

SQL

Inventory and Production /

Bin Transaction Log

API OBTL

OBTL - Bin Transaction Log Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int	11			PRIMARY	Yes
MessageID ^KEY	ILM Message ID	Int	11	OILM Inventory Log Message		MESSAGE_ID	No
BinAbs ^KEY	Bin Internal Number	Int	11	OBIN Bin Location		BIN_ABS	No
SnBMDAbs	SnB Master Data Internal Number	Int	11		-1
Quantity	Quantity	Num	20
ITLEntry	ITL Log Internal ID	Int	11	OITL Inventory Transactions Log	-1

Table relationship map

SELECT statement

SELECT
   OBTL.AbsEntry AS 'Internal Number', 
   OBTL.MessageID AS 'ILM Message ID', 
   OBTL.BinAbs AS 'Bin Internal Number', 
   OBTL.SnBMDAbs AS 'SnB Master Data Internal Number', 
   OBTL.Quantity AS 'Quantity', 
   OBTL.ITLEntry AS 'ITL Log Internal ID'
FROM OBTL AS OBTL

Related information

OBIN SQL Table

OITL SQL Table

OILM SQL Table

biuan SAP® BUSINESS ONE

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