Country

This table contains one row for each country, with options for invoicing, reminders and interest calculation.

You use this table to make settings specific for different countries, related to laws, rules and other conditions.

The entries in this table can be referred to from many other tables. If no country is specified, the Country no. field in the Company information table is used.

The following fields exist in this table:

After last reminder

How the application is to proceed after a customer has received the maximum number of reminders the customer is to have.

If the field is not filled in, customers will continue to receive reminders for other invoices. After last reminder, No reminders field is set to 1 - No reminders in Open customer entry table. To continue printing reminders, clear the value from the field.

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

1 - Stop sending reminders: No reminders option will enabled in Customer options field in Associate table after the last reminder has been printed.
2 - Stop reminders and interest: Claims for legal collection will be sent after the last reminder. No reminders and No interest options will enabled in Customer options field in Associate table after the last reminder has been printed.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	After last reminder	Integer
SQL name	AftRem	The database field name.
API identifier	afterLastReminder	The API identifier used in GraphQL.
Number	2058

Compound interest

Who the compound interest on interest notes are calculated for.

If the field is empty, interest will not be calculate for the customer entries with the same voucher type that is defined in the Interest note series field in the Company information table.

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

1 - Corporate customers: Compound interest is calculated for corporate customers, i.e. customers who are not marked as Private person in the Customer options field in the Associate table.
2 - All customers: Compound interest is calculated for all customers.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Compound interest	Integer
SQL name	CmpInt	The database field name.
API identifier	compoundInterest	The API identifier used in GraphQL.
Number	2061

Country no.

A unique number identifying the country.

International numeric ISO codes for country numbers and international telephone 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	Country no.	Integer
Primary key	Yes	Country no.
SQL name	CtryNo	The database field name.
API identifier	countryNo	The API identifier used in GraphQL.
Number	549

Country processing

Processings rules for the country.

A look-up opens the dialog box where you can see the following check boxes and options:

Manage

Do not post invoice fee: Customers will not be charged with invoice fee on invoices.
Do not do lookup in Bizweb
Create RF Creditor references: When enabled, RF creditor references (ISO 11649) are created for the customers in the country. Letters RF and two check digits are added in front of normally created CID.

Field control

Exempt from CID code check: The CID code fields will not be controlled for correct value when entering. This will disable both regular and RF creditor reference validation.
If this check box is not selected the check sum control is processed in all tables where CID code exists.
Exempt from organisation no. check: The Organisation no. fields will not be controlled for correct value when entering.
If this check box is not selected the check sum control is processed in all tables where organisation number exists.
Note:
If VUD login is enabled, a valid Organisation no. is required when creating new companies.
Exempt from bank account check: The Bank account and Postal giro fields will not be controlled for correct value when entering.
If this check box is not selected the check sum control is processed in all tables where bank account and postal giro exists.
Exempt from IBAN check: The Bank account and Postal giro fields will not be controlled for correct value when entering.

Fixed CID modulus

Use modulus 10 and 11: Control based both on modulus 10 and 11.
Use only modulus 10: Control based on modulus 10 with the multiplier 2,1,2,1.
Use only modulus 11: Control based on modulus 11 with the multiplier 2,3,4,5,6,7.
Use only Finnish CID calculation: Control based on modulus 10 (Finland) with the multiplier 7,3,1.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Country processing	Integer
SQL name	CtryPro	The database field name.
API identifier	countryProcessing	The API identifier used in GraphQL.
Number	11033

Currency no.

The currency suggested when you enter the country in the Associate and Order tables.

All amounts in the Country and Reminder tables (fees and minimum amounts) are entered in this currency. If this field is not filled in the Currency no. from the Company information table is used.

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	Currency no.	Integer
SQL name	Cur	The database field name.
API identifier	currencyNo	The API identifier used in GraphQL.
Number	553

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

Days of grace

The number of days after the Due date that a payment will be accepted without classifying the open customer entry as subject for interest invoice.

For more information, see calculation of the Ready for reminder date field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Days	Integer
SQL name	GrcDy	The database field name.
API identifier	daysOfGrace	The API identifier used in GraphQL.
Number	2057

Days of grace cash disc.

The number of days after the Cash due date that a payment containing only the cash amount will still be accepted.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Days	Integer
SQL name	GrcDyCsh	The database field name.
API identifier	daysOfGraceCashDiscount	The API identifier used in GraphQL.
Number	11039

Default turnover class

The default turnover class for associates with this country.

On vouchers with general ledger entries for sales and purchases that are generated on the basis of orders, the turnover class is defined on the basis of the Transaction type, Trade area and Service type fields.

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

1 - Taxable sales

Is used for sales of taxable products. I.e. when

the Transaction type is 1 - Sales or 2 - Hire
the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code

2 - Non-taxable domestic sales

Is used for sales of non-taxable products. I.e. when

the Transaction type is 1 - Sales or 2 - Hire
the Trade area is 1 - Non-taxable domestic

10 - Transfer of goods to EU countries

Used when

the Transaction type is 1 - Sales or 2 - Hire
the Trade area is 4 - Subsidiary in another EU country
Service type1 - Services is not selected

5 - Sale of goods to EU countries

Used when

the Transaction type is 1 - Sales or 2 - Hire
the Trade area is 2 - Within other EU country
Service type1 - Services is not selected

3 - Sale of goods outside EU/Abroad

Used when

the Transaction type is 1 - Sales or 2 - Hire
the Trade area is 3 - Outside EU/Abroad
Service type1 - Services is not selected

9 - Sale of services abroad

Used when

the Transaction type is 1 - Sales or 2 - Hire
the Trade area is 2 - Within other EU country, 3 - Outside EU/Abroad or 4 - Subsidiary in another EU country
Service type1 - Services is selected

13 - Non-taxable sales

16 - Sales outside tax area

18 - Sales, taxable for purchaser

20 - Agent sales to third party

22 - Sales of services to EU countries

26 - Rent income voluntary

27 - OSS union scheme services

28 - OSS union scheme goods

29 - OSS import scheme

4 - Taxable purchases

Is used for purchases of taxable products. I.e. when

the Transaction type is 6 - Purchase
the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code

7 - Non-taxable domestic purchases

Is used for purchases of non-taxable products. I.e. when

the Transaction type is 6 - Purchase
the Trade area is 1 - Non-taxable domestic

15 - Domestic purchases with reversed VAT deduction

11 - Transfer of goods between other EU countries

Used when

the Transaction type is 6 - Purchase
the Trade area is 5 - Transfer between other EU countries
Service type1 - Services is not selected

6 - Purchase of goods from EU countries

Used when

the Transaction type is 6 - Purchase
the Trade area is 2 - Within other EU country
Service type1 - Services is not selected

8 - Purchase of goods outside EU/Abroad

Used when

the Transaction type is 6 - Purchase
the Trade area is 3 - Outside EU/Abroad
Service type1 - Services is not selected

12 - Purchase of services abroad

Used when

the Transaction type is 6 - Purchase
the Trade area is 2 - Within other EU country or 5 - Transfer between other EU countries
Service type1 - Services is selected

14 - Non-taxable purchases

17 - Purchase outside tax area

19 - Purchase, taxable by purchaser

21 - Purchase of services from EU countries

23 - Domestic purchase of services

24 - Taxable product consumption

25 - Domestic purchases with reversed VAT liability

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Turnover class	Integer
SQL name	StTxCl	The database field name.
API identifier	defaultTurnoverClass	The API identifier used in GraphQL.
Number	11038

Default VAT code

The default VAT code for associates with this country.

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	VAT code	Integer
SQL name	StTxCd	The database field name.
API identifier	defaultTaxCode	The API identifier used in GraphQL.
Number	11037

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
VAT code	DefaultTaxCode	Default VAT code	VAT code

Do not post invoice fee

Visualises the Do not post invoice fee option under the Country processing field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	dontPostInvoiceFee	The API identifier used in GraphQL.
Number	11040

Interest fee

The interest fee that will be included in the interest notes.

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

Interest free days

The number of days before interest should be calculated.

In some countries, it is not permitted to calculate interest until after the first 30 days following the invoice date.

If, for example, you use the payment term Per 10 days, enter 20 in the Interest free days field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Days	Integer
SQL name	IntFrDy	The database field name.
API identifier	interestFreeDays	The API identifier used in GraphQL.
Number	10965

Interest method

How the interest is calculated.

In connection with interest calculation, it is required that the interest method be entered for the default company. This will be used if the field is not filled in for the country.

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

1 - Days after due date
2 - Started months: Interest is calculated per month or part thereof, i.e. for one month if payment is made by the same date in the month after the due date, for two months if payment is made by the same date.
3 - Days after due date, backdated: Interest is calculated only for settled entries. Interest from date and Interest to date will be updated for the Open customer entry.
4 - Started months, backdated: Interest is calculated per month or part thereof, i.e. for one month if payment is made by the same date in the month after the due date, for two months if payment is made by the same date two months after due date etc. You calculate interest on entries only after they have been settled.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Interest method	Integer
SQL name	IntMt	The database field name.
API identifier	interestMethod	The API identifier used in GraphQL.
Number	2060

Interest period

The minimum number of days between each calculation of interest on an entry.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Days	Integer
SQL name	Intv	The database field name.
API identifier	interestPeriod	The API identifier used in GraphQL.
Number	2059

Inv.fee VAT code

The VAT code for the invoice fee.

If the invoice fee is to have the same VAT code as the invoice, you do not enter a VAT code in the Country table.

If the invoice fee is always liable to VAT, you enter a VAT code in the Country table.

Examples of how the VAT code for the invoice fee is calculated:

If the value in the Trade area field in the Order table is different from 0 - Taxable domestic according to VAT- and accounting inf./VAT code, and you have not entered a VAT code in the Inv.fee VAT code field in the Country table, VAT is not calculated on the invoice fee.
If the value in the Trade area field in the Order table is different from 0 - Taxable domestic according to VAT- and accounting inf./VAT code, and you have entered a VAT code in the Inv.fee VAT code field in the Country table, this VAT code is used to calculate VAT on the invoice fee.
If the value in the Trade area field in the Order table is set to 0 - Taxable domestic according to VAT- and accounting inf./VAT code, and you have not entered a VAT code in the Inv.fee VAT code field in the Country table, the VAT code from the order head is used to calculate VAT on the invoice fee.
If the value in the Trade area field in the Order table is set to 0 - Taxable domestic according to VAT- and accounting inf./VAT code, and you have entered a VAT code in the Inv.fee VAT code field in the Country table, the VAT code from the Country table is used to calculate VAT on the 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	VAT code	Integer
SQL name	FeeVat	The database field name.
API identifier	invoiceFeeTaxCode	The API identifier used in GraphQL.
Number	3572

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
VAT code	InvoiceFeeTaxCode	Inv.fee VAT code	VAT code

Invoice fee

An invoice fee is added to a country if the order total in the default Currency no. after deduction of all discounts and before VAT is less than the amount stated in the Invoice fee limit field in the Country table. The field shall only be used if the invoice fee is always liable the same VAT rate, and will be overridden if an invoice fee is used in the order head.

If no country is entered for the customer or order, the Country no. field in the Company information table is used.

Whether invoice fees are to be calculated on credit notes is determined by the Inv. fee on credit notes and Order processing 1 fields in the Company information table.

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

Invoice fee limit

A limit for the invoice fee for net orders.

The invoice fee limit is converted, if necessary, into the default currency for comparison, using the applicable Sales rate 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	InvoAm	The database field name.
API identifier	invoiceFeeLimit	The API identifier used in GraphQL.
Number	2466

Invoice fee limit on gross order

A limit for the invoice fee for gross orders.

Amount set in this field (gross amount) will be used as invoice fee limit on gross orders. If Invoice fee limit on gross order is not set, no invoice fee limit will be applied.

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

ISO code

The ISO code for the country.

Is used on payment transfers.

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	550

Language no.

The language that will be suggested when you enter the country in the Associate and Order tables.

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	Language no.	Integer
SQL name	Lang	The database field name.
API identifier	languageNo	The API identifier used in GraphQL.
Number	552

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Language	Language	Language no.	Language no.

Length of IBAN

The length of the IBAN number for IBAN account checks.

An IBAN account check has been implemented in bank account fields. To make it work correctly, it is important to fill in the correct length of the IBAN account number in this field.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
SQL name	LgtIBAN	The database field name.
API identifier	lengthOfIban	The API identifier used in GraphQL.
Number	16215

Maximum number of interest days

The maximum number of days it is permitted to calculate interest for the country.

This will be taken account again when you carry out the interest calculation.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Days	Integer
SQL name	MxIntDy	The database field name.
API identifier	maxNoOfInterestDays	The API identifier used in GraphQL.
Number	10966

Min. interest per note

The minimum interest amount in an interest note, before the addition of an interest fee, before the note is printed.

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

Min. interest per trans.

The minimum interest amount on a transaction before it is included in an interest note.

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

Name

The name of the country.

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	551

National code

The national code for addresses abroad.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	National code	Text (5)
SQL name	NatCd	The database field name.
API identifier	nationalCode1	The API identifier used in GraphQL.
Number	7547

National code 2

The national code for addresses abroad, to be used in the Intrastat reports.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	National code	Text (5)
SQL name	NatCd2	The database field name.
API identifier	nationalCode2	The API identifier used in GraphQL.
Number	8397

Overdue payment terms

Which terms are to apply to the payment of interest and fees.

If you do not complete the field, the payment terms for the customer are used. If you want a cash due date, you can define payment terms for that.

Payment terms texts for different languages can be defined in the Text table. These texts has text type 6.

Note:

If you double-click or press * in this field, you can look up a Payment terms in the Text 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	Payment terms	Integer
SQL name	PmtTrm	The database field name.
API identifier	overduePaymentTerms	The API identifier used in GraphQL.
Number	2067

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
Payment term	PaymentTerms	Overdue payment terms	Payment terms

Penalty interest company

The interest rate for corporate customers which is to be used unless a different interest rate is entered for the customer or the record.

Corporate customers are customers that are not marked as Private person in the Customer options field in the Associate table.

This rate might in some countries be decided by the authorities.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Percent	Decimal
SQL name	FrmRt	The database field name.
API identifier	companyRate	The API identifier used in GraphQL.
Number	2062

Private rate

An interest rate for private customers which is to be used unless a different interest rate is entered for the customer or entry.

The authorities fix the maximum rates for default interest and this may be different for businesses and private consumers.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Percent	Decimal
SQL name	PrvRt	The database field name.
API identifier	privateRate	The API identifier used in GraphQL.
Number	2063

Reminder paym. term

The payment condition to use when you issue reminders.

If you do not add a payment condition here the value in the Standard payment terms. field in the Company information table will be used.

Payment terms texts for different languages can be defined in the Text table. These texts has text type 6.

Note:

If you double-click or press * in this field, you can look up a Payment terms in the Text 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	Payment terms	Integer
SQL name	RemPmt	The database field name.
API identifier	reminderPaymentTerms	The API identifier used in GraphQL.
Number	10927

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
Payment term	ReminderPaymentTerms	Reminder paym. term	Payment terms

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 7. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.