VAT period

This table contains one row for each VAT period.

When you enter vouchers, Business NXT suggests the first VAT period the value date falls within.

The following fields exist in this table:

Explanation

Additional information and explanations for any deviations for electronic reporting to Altinn. Explanation can be added to VAT report by a macro @Explanation().

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Explanation	Unlimited text
SQL name	Expl	The database field name.
API identifier	explanation	The API identifier used in GraphQL.
Number	18404

From date

The starting date for the VAT periods.

You use the From date field when defining a date range for the VAT periods. It is this date range that is used to locate the correct VAT period for the individual vouchers.

If you use the standard 6 VAT periods per year, you enter + in all fields. The From date field will then have the correct values entered automatically for all records. If you have selected the Monthly VAT terms field in the Company information table, you will instead have 12 VAT periods when you enter + in these fields.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
SQL name	FrDt	The database field name.
API identifier	fromDate	The API identifier used in GraphQL.
Number	1610

Main tax term

A general term for several VAT periods.

When you are printing the VAT report, and have selected Main VAT period in the VAT report dialog box, the VAT report is printed for all rows in the VAT period table with same value in the Main tax term field as the row in which you have the cursor when you on the Home tab, in the Printing group, click Print Preview.

Note:

This functionality is exclusively to be used by primary industries (fishery and agriculture) in the Norwegian market.

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	Period	Integer
SQL name	MainTrm	The database field name.
API identifier	mainTaxTerm	The API identifier used in GraphQL.
Number	13000

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
VAT period	MainTaxTerm	Year Main tax term	Year VAT term	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Norwegian VAT report processing

The type of VAT report to create (applicable in Norway).

The column contains settings for specific types of VAT reports, and have the option Agriculture VAT period. Applicable only for Norwegian customers.

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

Agriculture VAT period
Main VAT term
Withdraw tax statement

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Norwegian VAT report processing	Integer
SQL name	VatRepProc	The database field name.
API identifier	vatReportProcessing	The API identifier used in GraphQL.
Number	19135

Selected remark

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	VAT remark	Text (200)
SQL name	Rem	The database field name.
API identifier	remark	The API identifier used in GraphQL.
Number	19527

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
VAT period remark	Remark	Selected remark	Remark

To date

The ending date for the VAT period.

You use this when defining a date range for the VAT period. It is this date range that is used to locate the correct VAT period for the individual vouchers.

If you use the standard 6 VAT periods per year, you enter + in all fields. All fields then have the correct values entered automatically. If you have checked the Monthly VAT terms field in the Company information table, you will instead have 12 VAT periods when you enter + in these fields.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
SQL name	ToDt	The database field name.
API identifier	toDate	The API identifier used in GraphQL.
Number	1611

VAT report no.

A unique number identifying the VAT report.

The field is updated when you run a printout of VAT statements. If you want to change the next free number, you can do this in the Company information table using the Change counters processing.

If you want to print this number on the VAT report, you do this by using the macro function @VATReportno() in VAT report forms.

The VAT report number is contained in the General ledger transaction and Capital asset transaction tables.

If you interrupt printing the VAT report, the VAT report number is returned, as long as nobody has used the series in the meantime.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	TxStNo	The database field name.
API identifier	taxStatementNo	The API identifier used in GraphQL.
Number	8526

VAT term

The VAT period number in the VAT year.

Accounting data for several years can be retained, which is why both year and VAT term are entered. Varying financial years are permitted. There are no restrictions on the number of periods per year.

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	Period	Integer
Primary key	Yes	Year, VAT term
SQL name	TrmNo	The database field name.
API identifier	taxTerm	The API identifier used in GraphQL.
Number	1609

Year

The year for the VAT period.

Accounting data for several years can be retained, which is why both Year and VAT term are entered. Varying financial years are permitted. There are no restrictions on the number of VAT periods per year.

If you type + in the field, the same year/next period in relation to the previous row is suggested.

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	Year	Integer
Primary key	Yes	Year, VAT term
SQL name	Yr	The database field name.
API identifier	year	The API identifier used in GraphQL.
Number	1608

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
VAT period	MainTaxTerm	Year Main tax term	Year VAT term	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

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