Consolidated Exchange Rate

Internal ID: consolidatedexchangerate

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
accountingbook text false Accounting Book false If the Multi-Book Accounting feature is provisioned in your account, this is the accounting book associated with this consolidated exchange rate.
averagerate currency2 true Average Exchange Rate true This is the average exchange rate. This rate is calculated from a weighted average of the exchange rates for transactions applied during the period to accounts with a general rate type of Average. This rate is used to translate accounts in the income statement and to build retained earnings.
currentrate currency2 true Current Exchange Rate true This is the current exchange rate. Also referred to as ending rate. This rate is based on the currency exchange rate that is effective at the end of the reported upon period. This rate is used for most asset and liability accounts in the balance sheet.
fromcurrency text false From Currency false This is the currency from which the exchange rate is calculated.
fromsubsidiary text false From Subsidiary false This is the subsidiary from which the exchange rate is calculated.
historicalrate currency2 false Historical Exchange Rate true This is the historical exchange rate. This rate is calculated from a weighted average of the exchange rates for transactions applied during the period to accounts with a general rate type of Historical. This rate is used for equity accounts, or owner's investments, in the balance sheet.
isderived checkbox false Exchange Rate Derived false If this box is checked, the exchange rate is indirect. Indirect rates are rates set between subsidiaries more than one hierarchical level removed from each other, such as a child and grandchild. Indirect rates are always set by the system and cannot be edited or auto calculated by users.
iseliminationsubsidiary checkbox false Is Elimination Subsidiary false If this box is checked, the subsidiary associated with this consolidated exchange rate is an elimination subsidiary. You cannot edit the rates for an elimination subsidiary.
isperiodclosed checkbox false Period Closed false If this box is checked, the accounting period is closed.
postingperiod select false Posting Period false This is the posting period for this exchange rate.
tocurrency text false To Currency false This is the currency into which the exchange rate is calculated.
tosubsidiary text false To Subsidiary false This is the subsidiary to which the exchange rate is calculated.

Search Filters

Internal ID Type Label
accountingbook select Accounting Book
externalid select External ID
externalidstring text External ID (Text)
fromsubsidiary select From Subsidiary
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isderivedrate checkbox Is Derived Rate
period select Period
periodstartdate date Period Start Date
tosubsidiary select To Subsidiary

Search Columns

Internal ID Type Label
accountingbook text Accounting Book
averagerate rate Average
closed checkbox Closed
currentrate rate Current
externalid select External ID
fromcurrency text From Currency
fromsubsidiary text From Subsidiary
historicalrate rate Historical
internalid select Internal ID
periodenddate date Period End Date
periodname text Period
periodstartdate date Period Start Date
tocurrency text To Currency
tosubsidiary text To Subsidiary