Accounting document
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | InAcDoc | The table name in the database. |
| API identifier | incomingAccountingDocument | The API identifier used in GraphQL. |
| Table no. | 406 | The table number in the data model. |
The following fields exist in this table:
Accounting document no.
The unique number of an accounting document.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Accounting document no. |
| SQL name | InAcDocNo | The database field name. |
| API identifier | incomingAccountingDocumentNo | The API identifier used in GraphQL. |
| Number | 17924 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Document | Document |
| ||
| Batch | Batch |
|
Bank account
The supplier's bank account number.
May also contain Bankgiro or Plusgiro accounts (Sweden).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 20561 |
Description
Text describing the incoming document.
The field is editable, so content may be extended or replaced.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 250 | Text (250) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 18578 |
Doc. date
Date of the document.
If running Process document on documents with Document type 3-6, today's date will be used as voucher date if the field is empty.
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 | DocDt | The database field name. |
| API identifier | documentDate | The API identifier used in GraphQL. |
| Number | 17927 |
Document type
Shows the type of the incoming document.
Processings in the table depend on the type of document.
- 1 - Invoice
- 2 - Expense claim
- 3 - Payment
- 4 - Reminder
- 5 - Receipt
- 6 - Other
- 7 - Credit note
- 8 - Payroll
- The document contains payroll data.
- 9 - Settlement
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Document type | Integer |
| SQL name | InAcDocTp | The database field name. |
| API identifier | incomingAccountingDocumentType | The API identifier used in GraphQL. |
| Number | 18576 |
Due date
Due date on the downloaded document.
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 | DueDt | The database field name. |
| API identifier | dueDate | The API identifier used in GraphQL. |
| Number | 18768 |
External document ID
The ID of the document in an external system.
In use when Origin is 1 - AutoInvoice or 2 - Expense.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | GUID | Text (40) |
| SQL name | ExtDocId | The database field name. |
| API identifier | externalDocumentId | The API identifier used in GraphQL. |
| Number | 17926 |
Giro type
Defines information available on the giro used for payment in Denmark.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank giro type | Integer |
| SQL name | GiroTp | The database field name. |
| API identifier | giroType | The API identifier used in GraphQL. |
| Number | 20564 |
IBAN
The supplier's IBAN account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | IBAN | The database field name. |
| API identifier | iban | The API identifier used in GraphQL. |
| Number | 20562 |
Invoice no.
The invoice number of the downloaded document.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 18766 |
Invoice reference
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 240 | Text (240) |
| SQL name | InvRef | The database field name. |
| API identifier | invoiceReference | The API identifier used in GraphQL. |
| Number | 20980 |
Invoice reference employee
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | InvRefEmp | The database field name. |
| API identifier | invoiceReferenceEmployee | The API identifier used in GraphQL. |
| Number | 20981 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | InvoiceReferenceEmployee |
|
Invoice response status
Displays the latest status sent to the supplier as an invoice response document. More information found in Invoice response.
- 1 - Message acknowledgement
- 2 - Accepted
- 3 - Rejected
- 4 - In process
- 5 - Under query
- 6 - Conditionally accepted
- 7 - Paid
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Response code | Integer |
| SQL name | InvRespSt | The database field name. |
| API identifier | invoiceResponseStatus | The API identifier used in GraphQL. |
| Number | 19726 |
Invoice URL
The content of the field is a link to a document image or to an external system.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | InvoURL | The database field name. |
| API identifier | invoiceUrl | The API identifier used in GraphQL. |
| Number | 17931 |
Nothing to process
Set if you have selected the Nothing to process check box in the dialog for the Status field.
The field is editable so that the status may be changed directly adding or removing content in this 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 | nothingToProcess | The API identifier used in GraphQL. |
| Number | 18580 |
Order no.
Used for matching incoming invoices to purchase orders
The field contains a lookup to the Order table. If an Order no. is found in the invoice file, but a match is not found in the Order table, the field will be left empty.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Order no. | Integer |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 18821 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
|
Organisation no.
The supplier company ID of the downloaded document.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| SQL name | BsNo | The database field name. |
| API identifier | companyNo | The API identifier used in GraphQL. |
| Number | 18767 |
Origin
A source system of the incoming accounting document.
Processings in the table depend on the origin.
- 1 - AutoInvoice
- 2 - Expense
- Stores attachments from claims in Visma.net Expense in the Accounting document attachment table.
- 3 - Document center
- 4 - Scan
- 5 - Payroll
- The document is imported from Payroll.
- 6 - Manual
- 7 - AutoCollect
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Origin | Integer |
| SQL name | InAcDocOr | The database field name. |
| API identifier | incomingAccountingDocumentOrigin | The API identifier used in GraphQL. |
| Number | 17925 |
Postal giro
Contains the supplier's payment account used for FIK in Denmark.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | PGiro | The database field name. |
| API identifier | postalGiro | The API identifier used in GraphQL. |
| Number | 20563 |
Status
Displays the current status of the document.
The status is displayed in a dialog, available by double-clicking.
- Sent for order match
- Sent to accounting
- The invoice passed initial validation and was accepted for accounting processing.
- Status sent to origin
- Error in processing
- Sent to re-invoicing
- Nothing to process
- Multiple supplier matches
- Bank information difference
- Bank information updated
- Match with bank information only
- Duplicate
- Outside tolerance level
- Indicates that the total invoice amount exceeds the allowed deviation tolerance compared to the purchase order amount. The invoice requires manual review and correction before the order match process can be completed.
- Outside tolerance level solved
- Indicates that an invoice previously marked as outside tolerance has been manually corrected on the purchase order lines. After the correction, the order match validation was successfully completed and the document can continue in the processing workflow.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Status | Integer |
| SQL name | InAcDocSt | The database field name. |
| API identifier | incomingAccountingDocumentStatus | The API identifier used in GraphQL. |
| Number | 17929 |
Sup. no.
Supplier no connected to the document.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 17928 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Visma ID
Link to a document image in Visma Document Center that can be viewed with the View document processing.
The field is not editable.
This field isn't used in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 18581 |
Voucher no.
Voucher no. is set when creating a voucher using Process document.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | VoNo | The database field name. |
| API identifier | voucherNo | The API identifier used in GraphQL. |
| Number | 18579 |
Voucher series no.
Used to override the voucher series set in Miscellaneous series when creating a voucher using Process document.
When running the Process document processing with neither Miscellaneous series nor Voucher series no. defined, this will result in an error.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher series no. | Integer |
| SQL name | VoSr | The database field name. |
| API identifier | voucherSeriesNo | The API identifier used in GraphQL. |
| Number | 18577 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher series | VoucherSeriesNo |
|
Voucher URL
The content of the field is a link to a document image or to an external system.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | VoURL | The database field name. |
| API identifier | voucherUrl | The API identifier used in GraphQL. |
| Number | 17932 |
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.
| 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. |