AutoReport archive
This table contains one row for each VAT report.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | ARArch | The table name in the database. |
| API identifier | autoreportArchive | The API identifier used in GraphQL. |
| Table no. | 394 | The table number in the data model. |
The following fields exist in this table:
Amount
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Am | The database field name. |
| API identifier | amount | The API identifier used in GraphQL. |
| Number | 17734 |
Bank account
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 17732 |
Description
Interpretation of the AutoReport field for actions to the user.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 250 | Text (250) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 17671 |
Norwegian VAT report processing
- 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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatRepProc | The database field name. |
| API identifier | vatReportProcessing | The API identifier used in GraphQL. |
| Number | 19142 |
Payment message
Message from Altinn that describes the payment details for the period if there is VAT to pay.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 1000 | Text (1000) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PayMsg | The database field name. |
| API identifier | paymentMessage | The API identifier used in GraphQL. |
| Number | 18216 |
Reference id
Id for the message for report reference.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RefId | The database field name. |
| API identifier | referenceId | The API identifier used in GraphQL. |
| Number | 17669 |
Reply message
Message that describes the status from Visma.net AutoReport.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 1000 | Text (1000) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RepMsg | The database field name. |
| API identifier | replyMessage | The API identifier used in GraphQL. |
| Number | 17672 |
Report data
Stores the sent XML.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | File in BLOB | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RepData | The database field name. |
| API identifier | reportData | The API identifier used in GraphQL. |
| Number | 17674 |
Report type
Primary key. Represents the type of the report.
- 1 - VAT report
- 2 - Supplier report
- 3 - Supplementary VAT report (NO)
- 4 - Norwegian VAT report
- 5 - Danish VAT report
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Report type | Integer |
| Primary key | Yes | Year, Report type, Sequence no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RepTp | The database field name. |
| API identifier | reportType | The API identifier used in GraphQL. |
| Number | 17685 |
Sequence no.
Primary key. Sequence number is unique per report type and per year.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Year, Report type, Sequence no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SeqNo | The database field name. |
| API identifier | sequenceNo | The API identifier used in GraphQL. |
| Number | 17667 |
Service reference
Governmental id of the report that is generated by Visma.net AutoReport and used in relation with the government.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrvRef | The database field name. |
| API identifier | serviceReference | The API identifier used in GraphQL. |
| Number | 17673 |
Status
Status from Visma.net AutoReport or Business NXT
- 1 - Not sent
- Tax statement is not sent yet.
- 2 - Sent
- Tax statement is sent to AutoReport.
- 3 - Received in AutoReport
- Tax statement is received in AutoReport.
- 4 - Received in governmental portal
- Tax statement is received in governmental portal.
- 5 - Sending failure
- There was a failure in sending of tax statement.
- 6 - Rejected by AutoReport
- Tax statement was rejected by AutoReport. Could be missing or incorrect data.
- 7 - Rejected by governmental portal
- Tax statement was rejected by governmental portal. Could be missing or incorrect data.
- 8 - Withdrawn
- Tax statement was withdrawn by user.
- 9 - Accepted by governmental portal
- Tax statement was accepted by governmental portal.
- 10 - Cancelled in AutoReport
- Tax statement has been cancelled in AutoReport.
- 11 - Payment information received
- Payment information has been received from the governmental portal.
- 12 - Batch created for VAT payment
- A batch for payment has been created for the VAT based on the VAT control account and VAT control supplier settings.
- 13 - No VAT to be paid
- 14 - Report sending is awaiting authentication
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | AutoReport status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | St | The database field name. |
| API identifier | status | The API identifier used in GraphQL. |
| Number | 17670 |
Validation status
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | ValSt | The database field name. |
| API identifier | validationStatus | The API identifier used in GraphQL. |
| Number | 19140 |
VAT approval status
- 1 - Approved
- This value is set after the Send Norwegian VAT report processing in the VAT period tables has been executed and the report has been approved by the Norwegian Tax Authorities. When this value is set, a manual approval of the VAT report using the Approve VAT report processing is no longer possible.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VAT approval status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatAppSt | The database field name. |
| API identifier | vatApprovalStatus | The API identifier used in GraphQL. |
| Number | 19541 |
VAT report no.
This field exists in the VAT period table and it gets a value after the VAT report has been run.
| 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 | VatRepNo | The database field name. |
| API identifier | vatReportNo | The API identifier used in GraphQL. |
| Number | 17668 |
VAT report receipt
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | File in BLOB | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatRepRecp | The database field name. |
| API identifier | vatReportReceipt | The API identifier used in GraphQL. |
| Number | 19148 |
VAT report reply status
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | VatRepSt | The database field name. |
| API identifier | vatReportReplyStatus | The API identifier used in GraphQL. |
| Number | 19141 |
VAT term
Represents the VAT term the VAT report has been run for.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxTrm | The database field name. |
| API identifier | taxTerm | The API identifier used in GraphQL. |
| Number | 17820 |
Year
Primary key. Represents the year the report has been run for.
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, Report type, Sequence no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Yr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 17684 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting period | AccountingPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| VAT period | TaxTerm |
| 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 provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
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 provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | 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. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |