biuan SAP® BUSINESS ONE SDK
API OILM
OILM - Inventory Log Message Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MessageID KEY UNIQUEMessage IDInt
11
PRIMARYYes
DocEntryDoc Abs EntryInt
11
TransType KEYTransaction TypeInt
11
-1DocLineNo
DocLineNumDoc Line NumberInt
11
QuantityQuantity in DocNum
20
EffectQtyStock Effect QtyNum
20
LocTypeLocation TypeInt
6
LocCodeLocation CodenVarChar
8
TotalLCInventory Total LCNum
20
TotalFCInventory Total FCNum
20
TotalSCInventory Total SCNum
20
BaseAbsEntAbs Entry of Base DocInt
11
BaseTypeBase Transaction TypeInt
-1)
0
13) A/R Invoice
15) Delivery
16) Returns
17) Sales Order
18) A/P Invoice
20) Goods Receipt PO
21) Goods Return
22) Purchase Order
23) Sales Quotation
59) Goods Receipt
67) Inventory Transfer
69) Landed Costs
163) A/P Correction Invoice
164) A/P Correction Invoice Reversal
165) A/R Correction Invoice
166) A/R Correction Invoice Reversal
202) Production Order
203) A/R Down Payment
204) A/P Down Payment
11
-1
BaseCurrBase CurrencynVarChar
3
CurrencyDoc CurrencynVarChar
3OCRN
Currency Codes
AccumTypeAccumulator TypeInt
0
1) ACCUM_ON_HAND
2) ACCUM_COMMITTED
3) ACCUM_ON_ORDER
4) ACCUM_CONSIGNATION
5) ACCUM_COUNTED
11
0
ActionTypeAction TypeInt
0
1) TRANSACTION_IN
2) TRANSACTION_OUT
3) TRANSACTION_SET
4) TRANSACTION_COMPLETE
5) EMPTY_TRANSACTION
6) TRANSACTION_REVALUATION
7) TRANSACTION_REVALUATION_INCREASE
8) TRANSACTION_REVALUATION_DECREASE
9) TRANSACTION_CLOSE_IN
10) TRANSACTION_CLOSE_OUT
11) TRANSACTION_NEGATIVE_REVALUATION
12) TRANSACTION_NULLIFY
13) TRANSACTION_RESERVE_CI_IN
14) TRANSACTION_RESERVE_CI_OUT
15) TRANSACTION_RESERVE_CI_REVAL_INC
16) TRANSACTION_RESERVE_CI_REVAL_DEC
17) TRANSACTION_REVAL_PRICE_CHANGE_INCREASE
18) TRANSACTION_REVAL_PRICE_CHANGE_DECREASE
11
5
ExpensesLCExpenses (LC)Num
20
ExpensesFCExpenses (FC)Num
20
ExpensesSCExpenses (SC)Num
20
DocDueDateDoc. Due DateDate
8
ItemCodeItem CodenVarChar
20OITM
Items
BPCardCode KEYBusiness Partner CodenVarChar
15OCRD
Business Partner
CARDNo
DocDateDoc DateDate
8
DocRateDoc. RateNum
20
CommentCommentnVarChar
127
JrnlMemoJournal RemarksnVarChar
50
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
BaseLineBase Line NumberInt
11
-1
SnBTypeSerials and Batches TypeInt
0
1) Serial Numbers Management
11
-1
CreateTimeGeneration TimeInt
6
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
CreateDateCreation DateDate
8
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
DocPriceDoc PriceNum
20
CardNameBP NamenVarChar
100
DscriptionItem DescriptionnVarChar
100
TreeTypeBOM TypeVarChar
N) Not a BOM
A) Assembly
S) Sales
I) BOM Component Item
P) Production
T) Template
1
N
ApplObj KEYApplied ObjectInt
11
-1APPOBJNo
AppObjAbsApplied Object Abs EntryInt
11
-1
AppObjTypeApplied Object TypeVarChar
1
AppObjLineApplied Object LineInt
11
-1
BASE_REFBase ReferencenVarChar
11
TransSeqRfTransaction Sequence RefInt
11
-1
LayerIDRefLayer ID ReferenceInt
11
-1
VersionNumVersion NumbernVarChar
11
PriceRatePrice RateNum
20
PriceCurrPrice CurrencynVarChar
3OCRN
Currency Codes
DocTotalDocument TotalNum
20
PricePriceNum
20
CIShbQtyCorr. Inv. Doc. Should Be QtyNum
20
SubLineNumSub Line NumberInt
11
-1
PrjCodeProject codenVarChar
20OPRJ
Project Codes
SlpCodeSales EmployeeInt
11OSLP
Sales Employee
-1
TaxDateDocument DateDate
8
UseDocPricUse Document PriceVarChar
Y) Yes
N) No
1
N
VendorNumVendor Catalog No.nVarChar
17
SerialNumSerial NumbernVarChar
17
BlockNumBlock NumbernVarChar
100
ImportLogImport LognVarChar
20
LocationLocationInt
11OLCT
Location
DocPrcRateDocument Price RateNum
20
DocPrcCurrDocument Price CurrencynVarChar
3OCRN
Currency Codes
CgsOcrCodCOGS Distribution RulenVarChar
8OOCR
Distribution Rule
CgsOcrCod2COGS Distribution Rule 2nVarChar
8OOCR
Distribution Rule
CgsOcrCod3COGS Distribution Rule 3nVarChar
8OOCR
Distribution Rule
CgsOcrCod4COGS Distribution Rule 4nVarChar
8OOCR
Distribution Rule
CgsOcrCod5COGS Distribution Rule 5nVarChar
8OOCR
Distribution Rule
BSubLineNoBase Subrow NumberInt
11
-1
AppSubLineApplied Subrow NumberInt
11
-1
UserSignUser SignatureInt
6OUSR
Users
SysRateSystem RateNum
20
ExFromRptExclude from ReportVarChar
Y) Yes
N) No
1
N
Ref3Reference 3nVarChar
11
EnSetCostEnable Set Item Cost in ReturnVarChar
Y) Yes
N) No
1
N
RetCostReturn Cost in A/R ReturnNum
20
DocActionDocument Action TypeInt
11
UseShpdGdUse Shipped Goods AccountVarChar
N) No
Y) Yes
1
N
AddTotalLCAdditional Total LCNum
20
AddExpLCAdditional Expenses LCNum
20
IsNegLnQtyNegative Line QuantityVarChar
1
N

Table relationship map

SELECT statement

SELECT OILM.MessageID AS 'Message ID', OILM.DocEntry AS 'Doc Abs Entry', OILM.TransType AS 'Transaction Type', OILM.DocLineNum AS 'Doc Line Number', OILM.Quantity AS 'Quantity in Doc', OILM.EffectQty AS 'Stock Effect Qty', OILM.LocType AS 'Location Type', OILM.LocCode AS 'Location Code', OILM.TotalLC AS 'Inventory Total LC', OILM.TotalFC AS 'Inventory Total FC', OILM.TotalSC AS 'Inventory Total SC', OILM.BaseAbsEnt AS 'Abs Entry of Base Doc', OILM.BaseType AS 'Base Transaction Type', OILM.BaseCurr AS 'Base Currency', OILM.Currency AS 'Doc Currency', OILM.AccumType AS 'Accumulator Type', OILM.ActionType AS 'Action Type', OILM.ExpensesLC AS 'Expenses (LC)', OILM.ExpensesFC AS 'Expenses (FC)', OILM.ExpensesSC AS 'Expenses (SC)', OILM.DocDueDate AS 'Doc. Due Date', OILM.ItemCode AS 'Item Code', OILM.BPCardCode AS 'Business Partner Code', OILM.DocDate AS 'Doc Date', OILM.DocRate AS 'Doc. Rate', OILM.Comment AS 'Comment', OILM.JrnlMemo AS 'Journal Remarks', OILM.Ref1 AS 'Reference 1', OILM.Ref2 AS 'Reference 2', OILM.BaseLine AS 'Base Line Number', OILM.SnBType AS 'Serials and Batches Type', OILM.CreateTime AS 'Generation Time', OILM.DataSource AS 'Data Source', OILM.CreateDate AS 'Creation Date', OILM.OcrCode AS 'Distribution Rule', OILM.OcrCode2 AS 'Distribution Rule2', OILM.OcrCode3 AS 'Distribution Rule3', OILM.OcrCode4 AS 'Distribution Rule4', OILM.OcrCode5 AS 'Distribution Rule5', OILM.DocPrice AS 'Doc Price', OILM.CardName AS 'BP Name', OILM.Dscription AS 'Item Description', OILM.TreeType AS 'BOM Type', OILM.ApplObj AS 'Applied Object', OILM.AppObjAbs AS 'Applied Object Abs Entry', OILM.AppObjType AS 'Applied Object Type', OILM.AppObjLine AS 'Applied Object Line', OILM.BASE_REF AS 'Base Reference', OILM.TransSeqRf AS 'Transaction Sequence Ref', OILM.LayerIDRef AS 'Layer ID Reference', OILM.VersionNum AS 'Version Number', OILM.PriceRate AS 'Price Rate', OILM.PriceCurr AS 'Price Currency', OILM.DocTotal AS 'Document Total', OILM.Price AS 'Price', OILM.CIShbQty AS 'Corr. Inv. Doc. Should Be Qty', OILM.SubLineNum AS 'Sub Line Number', OILM.PrjCode AS 'Project code', OILM.SlpCode AS 'Sales Employee', OILM.TaxDate AS 'Document Date', OILM.UseDocPric AS 'Use Document Price', OILM.VendorNum AS 'Vendor Catalog No.', OILM.SerialNum AS 'Serial Number', OILM.BlockNum AS 'Block Number', OILM.ImportLog AS 'Import Log', OILM.Location AS 'Location', OILM.DocPrcRate AS 'Document Price Rate', OILM.DocPrcCurr AS 'Document Price Currency', OILM.CgsOcrCod AS 'COGS Distribution Rule', OILM.CgsOcrCod2 AS 'COGS Distribution Rule 2', OILM.CgsOcrCod3 AS 'COGS Distribution Rule 3', OILM.CgsOcrCod4 AS 'COGS Distribution Rule 4', OILM.CgsOcrCod5 AS 'COGS Distribution Rule 5', OILM.BSubLineNo AS 'Base Subrow Number', OILM.AppSubLine AS 'Applied Subrow Number', OILM.UserSign AS 'User Signature', OILM.SysRate AS 'System Rate', OILM.ExFromRpt AS 'Exclude from Report', OILM.Ref3 AS 'Reference 3', OILM.EnSetCost AS 'Enable Set Item Cost in Return', OILM.RetCost AS 'Return Cost in A/R Return', OILM.DocAction AS 'Document Action Type', OILM.UseShpdGd AS 'Use Shipped Goods Account', OILM.AddTotalLC AS 'Additional Total LC', OILM.AddExpLC AS 'Additional Expenses LC', OILM.IsNegLnQty AS 'Negative Line Quantity' FROM OILM AS OILM

Related information


OILM SQL Table

Business Partner OCRD SQL Table

Distribution Rule OOCR SQL Table

Currency Codes OCRN SQL Table

Items OITM SQL Table

Location OLCT SQL Table

Project Codes OPRJ SQL Table

Sales Employee OSLP SQL Table

Users OUSR 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