Skip to main content

Currencies

Written by Nick Maxwell

Data Dictionary

All currency types configured in your Unleashed account with their exchange rates and buy/sell rates against base currency.Useful for normalizing values across multi-currency transactions, analyzing forex impact on revenue, or converting historical amounts to a single reporting currency.Note that Connectorly provide daily close FX rates for all currencies that you use in any connected Xero if you need a reference. These are available in the sp.currencies table.

Field

Type

Notes

Connection ID

Integer

The Connectorly Connection ID. If you group Connectorly's together, then you will see a Connection ID for each one. Organisations has the corresponding Connection Name for each Connection ID.

Currency

Text

The ISO Currency Code, API: Currency.CurrencyCode

Currency GUID

Text

API: Currency.Guid

Data current as of

Datetime

Gives the date and time that this record was taken from Unleashed.

Default Buy Rate

Number

API: Currency.DefaultBuyRate

Default Sell Rate

Number

API: Currency.DefaultSellRate

Description

Text

API: Currency.Description

Updated

Datetime

Derived from datetime with timezone conversion of Updated

Did this answer your question?