biuan SAP® BUSINESS ONE SDK
API UILM2
UILM2 - Inventory Account Substitute Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MessageID KEY UNIQUEMessage IDInt
11OILM
Inventory Log Message
PRIMARYYes
AccountIdAccount IDInt
6
-1
AcctCodeAccount CodenVarChar
15OACT
G/L Accounts
DebitCrediDebit or CreditVarChar
U) Unknown
D) Debit
C) Credit
1
U

Table relationship map

SELECT statement

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

Related information


G/L Accounts OACT SQL Table

Inventory Log Message OILM SQL Table



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