|
|
API ILM2
ILM2 - Inventory Account Substitute Table
G/L Accounts OACT SQL Table
Inventory Log Message OILM SQL 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
G/L Accounts OACT SQL Table
Inventory Log Message OILM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
