Budget Exchange Rate

Internal ID: budgetexchangerate

Fields

Internal ID Type nlapiSubmitField Label Required Help
accountingbook select Accounting Book false If the Full Multi-Book Accounting or Adjustment-Only Books features are provisioned in your account, this is the accounting book or adjustment-only book associated with this budget.
averagerate currency2 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 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.
externalid text External ID false
fromcurrency select From Currency false This is the currency from which the exchange rate is calculated.
fromsubsidiary select From Subsidiary false This is the subsidiary from which the exchange rate is calculated.
historicalrate currency2 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.
id integer Internal ID false
internalid integer Internal ID false
isderived checkbox 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 Is Elimination Subsidiary false If this box is checked, the subsidiary associated with this budget exchange rate is an elimination subsidiary. You cannot edit the rates for an elimination subsidiary.
isperiodclosed checkbox Period Closed false If this box is checked, the accounting period is closed.
periodstartdate date Period Start Date false
postingperiod select Posting Period false This is the posting period for this exchange rate.
tocurrency select To Currency false This is the currency into which the exchange rate is calculated.
tosubsidiary select 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)
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
fromsubsidiary text From Subsidiary
historicalrate rate Historical
internalid select Internal ID
periodenddate date Period End Date
periodname text Period
periodstartdate date Period Start Date
tosubsidiary text To Subsidiary