Currency

This table contains one row for each currency.

The entries in this table can be referred to from many other tables. If no currency has been specified, the value in the Currency no. field Company information is used.

Currency rounding

Rounding stages

There are three sets of rounding limits and amounts for order totals to allow that larger amounts are rounded more than smaller ones. The highest truncate amount from the stages in which the truncate limit is greater than or equal to the amount in question is chosen.

Negative amounts (credit amounts) are rounded on the basis of the absolute value. Amounts between 0 and the truncate amount are rounded up to the truncate amount.

Printouts

The rounding amount in the order is printed in a total line for each currency between the VAT total lines and the order total lines in the Order document. Positive amounts are rounded up, negative amounts are rounded down.

The rounding amount in an order is added to the order total including VAT, the giro amount and the posted amount for the customer.

Accounting

Rounding is posted in voucher lines for each currency in the rounding account (or the Posting errors account) entered in the Company information table.

The following fields exist in this table:

Bank account

The bank account number for the currency.

The bank account number is printed on giros for the relevant currency, instead of the value entered in the Company information table.

The bank account number is also used in connection with electronic funds transfer.

Note:

The bank account number can be validated according to different rules. To disable this validation you have to change a setting in the Country processing field in the Country table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank account	Text (35)
SQL name	BankG	The database field name.
API identifier	bankAccount	The API identifier used in GraphQL.
Number	577

Bank no.

The bank associated with the currency.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Bank no.	Integer
SQL name	BankCon	The database field name.
API identifier	bankNo	The API identifier used in GraphQL.
Number	6227

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Bank	Bank	Bank no.	Bank no.

Calculate rate

The calculated rate which is used for an exchange rate regulation.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Exchange rate	Decimal
SQL name	CalcRt	The database field name.
API identifier	calculateRate	The API identifier used in GraphQL.
Number	575

Currency no.

A unique number identifying the currency.

International numeric ISO codes for country numbers and International tel. trunk codes are convenient to use.

Note:

If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Currency no.	Integer
Primary key	Yes	Currency no.
SQL name	CurNo	The database field name.
API identifier	currencyNo	The API identifier used in GraphQL.
Number	570

Currency type

Defines how to process the currency.

A look-up in this field gives you the following list of possible values:

0 - EMU-currency (with fixed price per 1 EURO)

For currencies included in European Monetary Union (EMU). The exchange rate says how much one EURO costs in this currency.

Amounts in the default currency are calculated by dividing the currency amount with the exchange rate (to get the EURO amount), and multiplying by the exchange rate per unit on the row for the EURO currency. (If the current currency is the default currency, the currency amount is also displayed as an amount in the default currency.)

1 - Other currency with price per 1 EURO

For other currencies (not EMU currencies) which have exchange rates expressed as the price of one EURO. For countries which are part of the EMU partnership, the exchange rates for all non-EMU currencies (apart from the EURO) are also quoted as the price of one EURO, and these have currency type 1.

2 - Other currency with unit price in default currency

The exchange rates will be expressed as the price in the default currency for 1 unit of the current currency.

3 - Other currency with price per 100 units in default currency

The exchange rates will be expressed as the price in the default currency for 100 units of the current currency.

Note:

You receive a warning if you change the currency type to 0 or 1 if the EURO currency no. field is not filled out in the Company information table. You can use the Change unit processing to change from currency type 3 to 2, or from 0, 1 or 2 to 3. This processing will also update all tables which store exchange rates.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Currency type	Integer
SQL name	CurTp	The database field name.
API identifier	currencyType	The API identifier used in GraphQL.
Number	573

EU invoice fee

The general ledger account to be used when posting an EU invoice fee.

If no value is entered in the field for a currency, the general ledger account entered for Non-taxable invoice fee is used. If neither of these accounts are entered for the relevant currency, general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	EUFeeAc	The database field name.
API identifier	euInvoiceFeeAccountNo	The API identifier used in GraphQL.
Number	5756

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	EuInvoiceFeeAccount	EU invoice fee	Account no.

Export invoice fee

The general ledger account to be used when posting invoice fees for exports.

If no value is entered in the field for a currency, the general ledger account entered for non-taxable or taxable invoice fee is used. If neither of these accounts are entered for the relevant currency, the general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	ExFeeAc	The database field name.
API identifier	exportInvoiceFeeAccountNo	The API identifier used in GraphQL.
Number	3576

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	ExportInvoiceFee	Export invoice fee	Account no.

Import factor

The number by which the exchange rate is multiplied to make the import exchange rate match the exchange rate that is defined in the Currency table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	Factor	The database field name.
API identifier	importFactor	The API identifier used in GraphQL.
Number	12781

Incom. invoice fee

The general ledger account to be used when posting an incoming invoice fee.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	IIFeeAc	The database field name.
API identifier	incomingInvoiceFeeAccountNo	The API identifier used in GraphQL.
Number	10470

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	IncomingInvoiceFeeAccount	Incom. invoice fee	Account no.

Interest account

The general ledger account to be used when posting interest income.

Note:

This field must have a value for the default currency to be able to start printing interest notes and interest suggestions.

If no value is entered in this field for a currency, the general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	IntAc	The database field name.
API identifier	interestAccountNo	The API identifier used in GraphQL.
Number	2069

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	InterestAccount	Interest account	Account no.

Interest rounding amount

The truncated amount to be used for Interest notes.

The rounding account is defined in the Company information table. If no rounding account is defined, rounding is posted to the Posting errors account from the same table.

If UK interest notes amounts are to be rounded to the nearest 50 pence, 0.5 should be entered as the rounding amount.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	IntTrAm	The database field name.
API identifier	interestRoundingAmount	The API identifier used in GraphQL.
Number	4804

ISO code

The ISO code for the currency.

Any code can be entered into this field. There is no validation whether or not it is a legal ISO code.

Note:

If currency payments are used in the electronic funds transfer routines, the currency designations must comply with standard ISO abbreviations from the banks.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	ISO code	Text (3)
SQL name	ISO	The database field name.
API identifier	isoCode	The API identifier used in GraphQL.
Number	571

Name

The name of the currency.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Name	Text (80)
SQL name	Nm	The database field name.
API identifier	name	The API identifier used in GraphQL.
Number	572

Non-taxable invoice fee

The general ledger account to be used when posting a non-taxable invoice fee.

If no value is entered in this field for a currency, the general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	FrFeeAc	The database field name.
API identifier	nonTaxableInvoiceFeeAccountNo	The API identifier used in GraphQL.
Number	3575

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	NonTaxableInvoiceFee	Non-taxable invoice fee	Account no.

Payment fee account

The general ledger account to be used when posting fees for electronic funds transfer.

If no value is entered in this field for a currency, the general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	RmtFeeAc	The database field name.
API identifier	remittanceFeeAccountNo	The API identifier used in GraphQL.
Number	8394

Table 7. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	RemittanceFeeAccount	Payment fee account	Account no.

Payments account

The general ledger account to be used when posting electronic funds transfer.

Note:

This field must have a value for the default currency to be able to start printing payment suggestions and payment giros.

If no value is entered in this field for a currency, the general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	RmtAc	The database field name.
API identifier	remittanceAccountNo	The API identifier used in GraphQL.
Number	578

Table 8. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	RemittanceAccount	Payments account	Account no.

Rem./int.fee account

The general ledger account to be used when posting reminder and interest fees.

Note:

This field must have a value for the default currency to be able to start printing reminders and reminder suggestions.

If no value is entered in this field for a currency, the general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	FeeAc	The database field name.
API identifier	reminderAndInterestFeeAccountNo	The API identifier used in GraphQL.
Number	2070

Table 9. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	ReminderAndInterestFeeAccount	Rem./int.fee account	Account no.

Rounding amount 1

The rounding amount for order totals.

If, for example, UK amounts are to be rounded to the nearest 50 pence, enter 0.5 in this field. Order totals are then rounded to the nearest amount divisible by the relevant rounding amount for the currency.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	TrAm1	The database field name.
API identifier	roundingAmount1	The API identifier used in GraphQL.
Number	2465

Rounding amount 2

The rounding amount for order totals.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	TrAm2	The database field name.
API identifier	roundingAmount2	The API identifier used in GraphQL.
Number	4799

Rounding amount 3

The rounding amount for order totals.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Amount	Decimal
SQL name	TrAm3	The database field name.
API identifier	roundingAmount3	The API identifier used in GraphQL.
Number	4801

Rounding limit 1

Order totals are rounded to the nearest amount divisible by the relevant truncate amount for the currency.

If, for example, UK amounts are to be rounded to the nearest 50 pence, enter 0.5 as the truncate amount in this field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	TrLmt1	The database field name.
API identifier	roundingLimit1	The API identifier used in GraphQL.
Number	4797

Rounding limit 2

Order totals are rounded to the nearest amount divisible by the relevant truncate amount for the currency.

If, for example, UK amounts are to be rounded to the nearest 50 pence, enter 0.5 as the truncate amount in this field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	TrLmt2	The database field name.
API identifier	roundingLimit2	The API identifier used in GraphQL.
Number	4798

Rounding limit 3

Order totals are rounded to the nearest amount divisible by the relevant truncate amount for the currency.

If, for example, UK amounts are to be rounded to the nearest 50 pence, enter 0.5 as the truncate amount in this field.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Amount	Decimal
SQL name	TrLmt3	The database field name.
API identifier	roundingLimit3	The API identifier used in GraphQL.
Number	4800

Sales rate

The exchange rate used for sales.

This rate is suggested when a voucher, invoice or purchase order is entered in a foreign currency. The exchange rate can be overridden on each individual voucher line, order line or purchase order line.

Note:

It is important to keep the sales rate updated, because it is used if no exchange rate is entered for the transaction.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Exchange rate	Decimal
SQL name	SalesRt	The database field name.
API identifier	salesRate	The API identifier used in GraphQL.
Number	574

Taxable invoice fee

The general ledger account to be used when posting a taxable invoice fee.

Note:

This field must have a value for the default currency to be able to start printing invoices.

If no value is entered in this field for a currency, the general ledger account for the default currency is used. The default currency is entered in the Company information table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	ObFeeAc	The database field name.
API identifier	taxableInvoiceFeeAccountNo	The API identifier used in GraphQL.
Number	3573

Table 10. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	TaxableInvoiceFee	Taxable invoice fee	Account no.

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by user

The name of the user that changed the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChUsr	The database field name.
API identifier	changedByUser	The API identifier used in GraphQL.
Number	A unique column number.

Changed date

The date when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChDt	The database field name.
API identifier	changedDate	The API identifier used in GraphQL.
Number	A unique column number.

Changed time

The time when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTm	The database field name.
API identifier	changedTime	The API identifier used in GraphQL.
Number	A unique column number.

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTs	The database field name.
API identifier	changedTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Created by user

The name of the user that created the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreUsr	The database field name.
API identifier	createdByUser	The API identifier used in GraphQL.
Number	A unique column number.

Created date

The date when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreDt	The database field name.
API identifier	createdDate	The API identifier used in GraphQL.
Number	A unique column number.

Created time

The time when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTm	The database field name.
API identifier	createdTime	The API identifier used in GraphQL.
Number	A unique column number.

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTs	The database field name.
API identifier	createdTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Edit status	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	LckSt	The database field name.
API identifier	editStatus	The API identifier used in GraphQL.
Number	A unique column number.

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Process no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChPrc	The database field name.
API identifier	lockedByProcessNo	The API identifier used in GraphQL.
Number	A unique column number.

Table 11. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.