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

SQL Inventory and Production / Srl & Batch Det of Inv Log Msg

API ILM1

ILM1 - Srl & Batch Det of Inv Log Msg Table

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
MessageID ^KEY ^UNIQUE	Message ID	Int	11	OILM Inventory Log Message	PRIMARY	Yes
ItemCode	Item Code	nVarChar	20	OITM Items
SysNumber	System Number	Int	11
Quantity	Quantity	Num	20
MdAbsEntry	MD Abs Entry	Int	11

Table relationship map

SELECT statement

SELECT
   ILM1.MessageID AS 'Message ID', 
   ILM1.ItemCode AS 'Item Code', 
   ILM1.SysNumber AS 'System Number', 
   ILM1.Quantity AS 'Quantity', 
   ILM1.MdAbsEntry AS 'MD Abs Entry'
FROM ILM1 AS ILM1

Related information

OITM 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates