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