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

SQL

Inventory and Production /

Inventory Account Substitute

API ILM2

ILM2 - Inventory Account Substitute 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
AccountId	Account ID	Int		6		-1
AcctCode	Account Code	nVarChar		15	OACT G/L Accounts
DebitCredi	Debit or Credit	VarChar	U) Unknown D) Debit C) Credit	1		U

Table relationship map

SELECT statement

SELECT
   ILM2.MessageID AS 'Message ID', 
   ILM2.AccountId AS 'Account ID', 
   ILM2.AcctCode AS 'Account Code', 
   ILM2.DebitCredi AS 'Debit or Credit'
FROM ILM2 AS ILM2

Related information

OACT 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