Currency Cutoffs

The CurrencyCutoff table, located in the Location package, contains information on the currency cutoff for different regions across the world. This table includes data on the maximum and minimum amount of local currency that can be used for transactions in specific countries, as well as any limitations or restrictions on the use of foreign currencies. This table is important for businesses and individuals who are conducting transactions in different regions, as it can help them determine the appropriate currency to use and avoid potential penalties or fees. Additionally, the CurrencyCutoff table may also include information on currency exchange rates and conversion fees for countries with multiple accepted currencies.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Body Params
int32

The CurrencyCutoff table is an essential part of any financial database. It stores information about the different currency cutoff points, which have a direct impact on various financial transactions. In this table, the CurrencyCutoffId serves as the unique identifier for each cutoff point, allowing for efficient data management and organization. This field is of the integer data type, meaning it can only store whole numbers. The CurrencyCutoffId acts as the primary key for this table, enabling easy retrieval of specific cutoff points and maintaining data integrity. Overall, this field ensures accurate and streamlined tracking of currency cutoff points within the financial system.

string | null

The CurrencyId field in the CurrencyCutoff table is a nvarchar data type with a maximum length of 128 characters. This field stores the unique identifier for a specific currency within the table. It is often used as a primary key to uniquely identify each currency in the CurrencyCutoff table. With a maximum length of 128 characters, this field allows for a wide range of currency identifiers to be stored, accommodating various international currencies.

string | null

The CutoffCategoryId field in the CurrencyCutoff table is a nvarchar data type with a maximum length of 450. This field serves as a unique identifier for each currency cutoff category, providing a way to distinguish between different categories within the table. It allows for efficient sorting and filtering of data related to currency cutoff, facilitating the management and analysis of financial information. The maximum length of 450 ensures that the field can store a wide range of category identifiers, accommodating potential future expansions to the currency cutoff system.

string | null

The EventTypeId field in the CurrencyCutoff table is a nvarchar data type with a maximum length of 64 characters. This field is used to store the type of event or activity associated with a specific currency cutoff. Examples of events could include a financial transaction, a currency conversion, or a price change. The purpose of the EventTypeId field is to provide a way to categorize and track different types of currency cutoffs within the table. This field is helpful in analyzing and managing currency data, as it allows for the easy identification of specific events or activities that may impact the value or availability of a particular currency.

string
required

The Cutoff field in the CurrencyCutoff table represents the designated time at which a currency's value will be determined and updated. It is essential for financial tracking and analysis as it provides a consistent reference point for currency conversions and transactions. The data type for this field is time, allowing for accurate and precise tracking of currency cutoffs. This field ensures accuracy and efficiency in financial reporting and decision-making.

int32

The DaysOffset field in the CurrencyCutoff table is a numeric data type of integer, used to determine the number of days to adjust a currency cutoff date. This field allows for flexibility in setting a cutoff date for currency exchange rates, allowing for delays or advances in the time frame. This field is integral in the accurate and efficient calculation of currency rates, aiding in financial planning and decision making.

string | null

Miscellaneous notes and information for the entry or record.

Headers
string
enum
Defaults to application/json;odata.metadata=minimal;odata.streaming=true

Generated from available request content types

Response
200

OK

Language
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here!