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

SQL

Inventory and Production /

Non-Inventory and Resource Components Log Msg

API UILM3

UILM3 - Non-Inventory and Resource Components Log Msg Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
MessageID ^KEY ^UNIQUE	Message ID	Int		11	OILM Inventory Log Message		PRIMARY	Yes
LineID	Line ID	Int		11
POLine	Line in Production Order	Int		11
ItemType	Item Type	Int		11
ItemCode	Item No.	nVarChar		20	OITM Items
LocType	Location Type	Int		6
LocCode	Location Code	nVarChar		8
Quantity	Quantity	Num		20
TotalLC	Inventory Total LC	Num		20
BaseAbsEnt	Abs. Entry of Base Doc.	Int		11		-1
BaseType	Base Transaction Type	Int	-1) 0 60) Goods Issue	11		-1
BaseLine	Base Line Number	Int		11		-1

Table relationship map

SELECT statement

SELECT
   UILM3.MessageID AS 'Message ID', 
   UILM3.LineID AS 'Line ID', 
   UILM3.POLine AS 'Line in Production Order', 
   UILM3.ItemType AS 'Item Type', 
   UILM3.ItemCode AS 'Item No.', 
   UILM3.LocType AS 'Location Type', 
   UILM3.LocCode AS 'Location Code', 
   UILM3.Quantity AS 'Quantity', 
   UILM3.TotalLC AS 'Inventory Total LC', 
   UILM3.BaseAbsEnt AS 'Abs. Entry of Base Doc.', 
   UILM3.BaseType AS 'Base Transaction Type', 
   UILM3.BaseLine AS 'Base Line Number'
FROM UILM3 AS UILM3

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