biuan SAP® BUSINESS ONE SDK
API OAIM
OAIM - Archive Inventory Message Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MessageID KEY UNIQUEMessage IDInt
11
PRIMARYYes
DocEntryDocument NumberInt
11
TransTypeTransaction TypeInt
11
-1
DocLineNumDocument Row NumberInt
11
QuantityQuantity in DocumentNum
20
EffectQtyEffective Inventory QuantityNum
20
LocTypeLocation TypeInt
6
LocCodeLocation CodenVarChar
8
TotalLCInventory Total LCNum
20
TotalFCInventory Total FCNum
20
BaseAbsEntInternal No. 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
CurrencyDocument 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
ItemCodeItem CodenVarChar
20OITM
Items
DocDateDocument DateDate
8
DocRateDocument RateNum
20
JrnlMemoJournal RemarksnVarChar
50
BaseLineBase Row NumberInt
11
-1
CreateTimeGeneration TimeInt
6
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
DocPriceDocument PriceNum
20
TreeTypeBOM TypeVarChar
N) Not a BOM
A) Assembly
S) Sales
I) BOM Component Item
1
N
ApplObjApplied ObjectInt
11
-1
AppObjAbsApplied Object Internal IDInt
11
-1
AppObjTypeApplied Object TypeVarChar
1
AppObjLineApplied Object RowInt
11
-1
TransSeqRfTransaction Sequence RefInt
11
-1
LayerIDRefLayer ID ReferenceInt
11
-1
VersionNumVersion NumbernVarChar
11
PriceRatePrice RateNum
20
PriceCurrPrice CurrencynVarChar
3OCRN
Currency Codes
PricePriceNum
20
CIShbQtyCorr. Inv. Doc. Should Be QtyNum
20
SubLineNumSubrow NumberInt
11
-1
PrjCodeProject CodenVarChar
20OPRJ
Project Codes
UseDocPricUse Document PriceVarChar
Y) Yes
N) No
1
N
LocationLocationInt
11OLCT
Location
BSubLineNoBase Subrow NumberInt
11
-1
AppSubLineApplied Subrow NumberInt
11
-1
DocActionDocument Action TypeInt
11

Table relationship map

SELECT statement

SELECT OAIM.MessageID AS 'Message ID', OAIM.DocEntry AS 'Document Number', OAIM.TransType AS 'Transaction Type', OAIM.DocLineNum AS 'Document Row Number', OAIM.Quantity AS 'Quantity in Document', OAIM.EffectQty AS 'Effective Inventory Quantity', OAIM.LocType AS 'Location Type', OAIM.LocCode AS 'Location Code', OAIM.TotalLC AS 'Inventory Total LC', OAIM.TotalFC AS 'Inventory Total FC', OAIM.BaseAbsEnt AS 'Internal No. of Base Doc', OAIM.BaseType AS 'Base Transaction Type', OAIM.Currency AS 'Document Currency', OAIM.AccumType AS 'Accumulator Type', OAIM.ActionType AS 'Action Type', OAIM.ExpensesLC AS 'Expenses (LC)', OAIM.ExpensesFC AS 'Expenses (FC)', OAIM.ItemCode AS 'Item Code', OAIM.DocDate AS 'Document Date', OAIM.DocRate AS 'Document Rate', OAIM.JrnlMemo AS 'Journal Remarks', OAIM.BaseLine AS 'Base Row Number', OAIM.CreateTime AS 'Generation Time', OAIM.CreateDate AS 'Creation Date', OAIM.OcrCode AS 'Distribution Rule', OAIM.OcrCode2 AS 'Distribution Rule2', OAIM.OcrCode3 AS 'Distribution Rule3', OAIM.OcrCode4 AS 'Distribution Rule4', OAIM.OcrCode5 AS 'Distribution Rule5', OAIM.DocPrice AS 'Document Price', OAIM.TreeType AS 'BOM Type', OAIM.ApplObj AS 'Applied Object', OAIM.AppObjAbs AS 'Applied Object Internal ID', OAIM.AppObjType AS 'Applied Object Type', OAIM.AppObjLine AS 'Applied Object Row', OAIM.TransSeqRf AS 'Transaction Sequence Ref', OAIM.LayerIDRef AS 'Layer ID Reference', OAIM.VersionNum AS 'Version Number', OAIM.PriceRate AS 'Price Rate', OAIM.PriceCurr AS 'Price Currency', OAIM.Price AS 'Price', OAIM.CIShbQty AS 'Corr. Inv. Doc. Should Be Qty', OAIM.SubLineNum AS 'Subrow Number', OAIM.PrjCode AS 'Project Code', OAIM.UseDocPric AS 'Use Document Price', OAIM.Location AS 'Location', OAIM.BSubLineNo AS 'Base Subrow Number', OAIM.AppSubLine AS 'Applied Subrow Number', OAIM.DocAction AS 'Document Action Type' FROM OAIM AS OAIM

Related information


Currency Codes OCRN SQL Table

Items OITM SQL Table

Location OLCT SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ 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