Consolidated Exchange Rate

consolidatedexchangerate

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Accounting Book accountingbook select Yes Yes Yes
Average Exchange Rate averagerate currency2 Yes Yes Yes
Current Exchange Rate currentrate currency2 Yes Yes Yes
External ID externalid text Yes Yes Yes
From Currency fromcurrency select Yes Yes Yes
From Subsidiary fromsubsidiary select Yes Yes Yes
Historical Exchange Rate historicalrate currency2 Yes Yes Yes
Internal ID id integer Yes Yes Yes
Posting Period postingperiod select Yes Yes Yes
To Currency tocurrency select Yes Yes Yes
To Subsidiary tosubsidiary select Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Consolidated Exchange Rate to Accounting Book (accountingBook.id) consolidated exchange rate (consolidatedexchangerate, consolidatedexchangerate.accountingbook) No Yes Yes
Consolidated Exchange Rate to Currency (currency.id) consolidated exchange rate (consolidatedexchangerate, consolidatedexchangerate.fromcurrency) No Yes Yes
Consolidated Exchange Rate to Subsidiary (subsidiary.id) consolidated exchange rate (consolidatedexchangerate, consolidatedexchangerate.fromsubsidiary) No Yes Yes
Consolidated Exchange Rate to Accounting Period (accountingPeriod.id) consolidated exchange rate (consolidatedexchangerate, consolidatedexchangerate.postingperiod) No Yes Yes
Consolidated Exchange Rate to Currency (currency.id) consolidated exchange rate (consolidatedexchangerate, consolidatedexchangerate.tocurrency) No Yes Yes
Consolidated Exchange Rate to Subsidiary (subsidiary.id) consolidated exchange rate (consolidatedexchangerate, consolidatedexchangerate.tosubsidiary) No Yes Yes