biuan SAP® BUSINESS ONE SDK
API ORTS
ORTS - CPI and FC Rates for Reports 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
ReportTypeReport Rate TypeVarChar
S) Standard Report Rate
I) Intrastat Exchange Rate
1
S

SELECT statement

SELECT ORTS.RateDate AS 'Exchange Rate Date', ORTS.Currency AS 'Currency Code', ORTS.Rate AS 'Currency Rate', ORTS.DataSource AS 'Data Source', ORTS.UserSign AS 'User Signature', ORTS.ReportType AS 'Report Rate Type' FROM ORTS AS ORTS

Related information


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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates