biuan SAP® BUSINESS ONE SDK
API SB Obob / Get Currency Rate
ORTT - CPI and FC Rates Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RateDate KEYExchange Rate DateDate
8
DATENo
CurrencyCurrency CodenVarChar
3
RateCurrency RateNum
20
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
UserSignUser SignatureInt
6OUSR
Users

SELECT statement

SELECT ORTT.RateDate AS 'Exchange Rate Date', ORTT.Currency AS 'Currency Code', ORTT.Rate AS 'Currency Rate', ORTT.DataSource AS 'Data Source', ORTT.UserSign AS 'User Signature' FROM ORTT AS ORTT

Related information


Get Currency Rate GetCurrencyRate Method· Table: ORTT
Returns a Recordset object that contains the currency rate for a specified date and currency code. See Currency sample. Source table: ORTT.
   Parent: SB Obob SBObob Object
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