biuan SAP® BUSINESS ONE SDK
API RTL1
RTL1 - Resource Transaction Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LogEntry KEY UNIQUELog Entry IDInt
11
PRIMARYYes
StdCostNumResource Standard Cost NumberInt
11
BaseLogEntBase Log Entry IDInt
11ORTL
Resource Transaction Log
-1
DocQtyDoc. QuantityNum
20
PricePriceNum
20
TotalTotalNum
20
OpenTotalOpen TotalNum
20

SELECT statement

SELECT RTL1.LogEntry AS 'Log Entry ID', RTL1.StdCostNum AS 'Resource Standard Cost Number', RTL1.BaseLogEnt AS 'Base Log Entry ID', RTL1.DocQty AS 'Doc. Quantity', RTL1.Price AS 'Price', RTL1.Total AS 'Total', RTL1.OpenTotal AS 'Open Total' FROM RTL1 AS RTL1

Related information


Resource Transaction Log ORTL 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