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