biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Resource Transaction Log
API ORTL
ORTL - Resource Transaction Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LogEntry KEY UNIQUELog Entry IDInt
11
PRIMARYYes
ResCodeResource CodenVarChar
20ORSC
Resources
DocTypeTransact. TypeInt
11
DocEntryDocument Internal IDInt
11
DocLineDoc. Row NumberInt
11
BaseTypeBase Document TypeInt
11
BaseEntryBase Document Internal IDInt
11
BaseLineBase Document Row NumberInt
11
ActionTypeAction TypeInt
0
1) RESOURCE_TRANSACTION_IN
2) RESOURCE_TRANSACTION_OUT
11
0
LocTypeLocation TypeInt
6
LocCodeLocation CodenVarChar
8
VersionNumVersion NumbernVarChar
11
PostDatePosting DateDate
8
CreateDateCreation DateDate
8
CreateTimeCreation TimeInt
6
DocQtyDoc. QuantityNum
20
PricePriceNum
20
LineTotalRow TotalNum
20
OpenQtyOpen QuantityNum
20

Table relationship map

SELECT statement

SELECT ORTL.LogEntry AS 'Log Entry ID', ORTL.ResCode AS 'Resource Code', ORTL.DocType AS 'Transact. Type', ORTL.DocEntry AS 'Document Internal ID', ORTL.DocLine AS 'Doc. Row Number', ORTL.BaseType AS 'Base Document Type', ORTL.BaseEntry AS 'Base Document Internal ID', ORTL.BaseLine AS 'Base Document Row Number', ORTL.ActionType AS 'Action Type', ORTL.LocType AS 'Location Type', ORTL.LocCode AS 'Location Code', ORTL.VersionNum AS 'Version Number', ORTL.PostDate AS 'Posting Date', ORTL.CreateDate AS 'Creation Date', ORTL.CreateTime AS 'Creation Time', ORTL.DocQty AS 'Doc. Quantity', ORTL.Price AS 'Price', ORTL.LineTotal AS 'Row Total', ORTL.OpenQty AS 'Open Quantity' FROM ORTL AS ORTL

Related information


ORTL SQL Table

Resources ORSC SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates