ORTT - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Finance /

CPI and FC Rates

API SB Obob / Get Currency Rate

ORTT - CPI and FC Rates Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
RateDate ^KEY	Exchange Rate Date	Date		8			DATE	No
Currency	Currency Code	nVarChar		3
Rate	Currency Rate	Num		20
DataSource	Data Source	VarChar	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
UserSign	User Signature	Int		6	OUSR 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

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