biuan SAP® BUSINESS ONE SDK
API Document Lines / Batch Numbers
OITL - Inventory Transactions Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LogEntryLog Internal IDInt
11
TransId KEYTransaction IDInt
11
TRANSIDNo
ItemCodeItem CodenVarChar
20OITM
Items
ItemNameItem DescriptionnVarChar
100
ManagedBy KEYManagement MethodInt
10000044) BTN
10000045) SRN
4) ITM
11
4ACTUAL_INFNo
DocEntryDocument Internal IDInt
11
DocLineDoc. Row NumberInt
11
DocType KEYTransact. TypeInt
11
-1DOC_REFNo
DocNumDoc. NumberInt
11
BaseEntryBase Document Internal IDInt
11
-1
BaseLineBase Document Row NumberInt
11
-1
BaseType KEYBase Document 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
-1BASEREFNo
ApplyEntryApplied Document Internal IDInt
11
ApplyLineApplied Document Line NumberInt
11
ApplyType KEYApplied Document TypeInt
11
-1APPLYREFNo
DocDateDoc. Posting DateDate
8
CardCodeBP CodenVarChar
15OCRD
Business Partner
CardNameBP NamenVarChar
100
DocQtyDoc. QuantityNum
20
StockQtyStock Affecting QuantityNum
20
DefinedQtySnB Defined QuantityNum
20
StockEffStock EffectInt
0
1) ACCUM_ON_HAND
2) ACCUM_COMMITTED
11
0
CreateDateCreation DateDate
8
LocTypeLocation TypeInt
6
LocCodeLocation CodenVarChar
8
AppDocNumApplied Document NumberInt
11
VersionNumVersion NumbernVarChar
11
TransferedYear TranferVarChar
1
N
InstanceINSTANCEInt
6
0
SubLineNumSubrow NumberInt
11
-1
BSubLineNoBase Subrow NumberInt
11
-1
AppSubLineApplied Subrow NumberInt
11
-1
ActBaseTpActual Base TypeInt
11
-1
ActBaseEntActual Base EntryInt
11
ActBaseLnActual Base LineInt
11
-1
ActBasSubLActual Base SublineInt
11
-1
AllocateTp KEYAllocate Document TypeInt
11
-1ALLOC_REFNo
AllocatEntAllocate Document EntryInt
11
-1
AllocateLnAllocate Document LineInt
11
-1
CreateTimeCreation TimeInt
6
0

Table relationship map

SELECT statement

SELECT OITL.LogEntry AS 'Log Internal ID', OITL.TransId AS 'Transaction ID', OITL.ItemCode AS 'Item Code', OITL.ItemName AS 'Item Description', OITL.ManagedBy AS 'Management Method', OITL.DocEntry AS 'Document Internal ID', OITL.DocLine AS 'Doc. Row Number', OITL.DocType AS 'Transact. Type', OITL.DocNum AS 'Doc. Number', OITL.BaseEntry AS 'Base Document Internal ID', OITL.BaseLine AS 'Base Document Row Number', OITL.BaseType AS 'Base Document Type', OITL.ApplyEntry AS 'Applied Document Internal ID', OITL.ApplyLine AS 'Applied Document Line Number', OITL.ApplyType AS 'Applied Document Type', OITL.DocDate AS 'Doc. Posting Date', OITL.CardCode AS 'BP Code', OITL.CardName AS 'BP Name', OITL.DocQty AS 'Doc. Quantity', OITL.StockQty AS 'Stock Affecting Quantity', OITL.DefinedQty AS 'SnB Defined Quantity', OITL.StockEff AS 'Stock Effect', OITL.CreateDate AS 'Creation Date', OITL.LocType AS 'Location Type', OITL.LocCode AS 'Location Code', OITL.AppDocNum AS 'Applied Document Number', OITL.VersionNum AS 'Version Number', OITL.Transfered AS 'Year Tranfer', OITL.Instance AS 'INSTANCE', OITL.SubLineNum AS 'Subrow Number', OITL.BSubLineNo AS 'Base Subrow Number', OITL.AppSubLine AS 'Applied Subrow Number', OITL.ActBaseTp AS 'Actual Base Type', OITL.ActBaseEnt AS 'Actual Base Entry', OITL.ActBaseLn AS 'Actual Base Line', OITL.ActBasSubL AS 'Actual Base Subline', OITL.AllocateTp AS 'Allocate Document Type', OITL.AllocatEnt AS 'Allocate Document Entry', OITL.AllocateLn AS 'Allocate Document Line', OITL.CreateTime AS 'Creation Time' FROM OITL AS OITL

Related information


Batch Numbers BatchNumbers Object· Table: OBTN BTNT
BatchNumbers is a business object that represents the batch numbers of an item in the Inventory and Production module. This object enables you to add batch numbers for a selected item row (one record per item). Source table: OBTN, OBTW, OITL,...
   Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
OITL SQL Table

Business Partner OCRD SQL Table

Items OITM 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