Approval task change log
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | AppTskChL | The table name in the database. |
| API identifier | approvalTaskChangeLog | The API identifier used in GraphQL. |
| Table no. | 430 | The table number in the data model. |
The following fields exist in this table:
Approval action
Indicates the action that was logged with the record.
Workflow status in Visma.net Approval integration.
- 1 - Sent
- Request has been send to Visma.net Approval.
- 2 - Pending workflow
- Visma.net Approval has received the request, but was not able to solve the workflow. Request needs to be handled forward in Visma.net Approval.
- 3 - Waiting for approval
- Visma.net Approval has received the request. It is in a workflow and waiting to be approved or rejected.
- 4 - Approved
- Request has been approved in Visma.net Approval.
- 5 - Rejected
- Request has been rejected in Visma.net Approval.
- 6 - Requested cancel
- User has requested cancellation of the approval request.
- 7 - Cancelled
- Request has been cancelled. Cancellation has been confirmed by Visma.net Approval.Note:If the request was already approved or rejected in Visma.net Approval, only status in Business NXT is set to 7 - Cancelled. Status is not visible in Visma.net Approval.
- 8 - Error
- There was an error in request handling. See more details in Comment field in Approval task change log table.
- 9 - In approval flow
- 10 - Automatically approved
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Approval status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ac | The database field name. |
| API identifier | action | The API identifier used in GraphQL. |
| Number | 18525 |
Approval Sequence no.
Identification of the message from Visma.net Approval.
| 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 | AppSeqNo | The database field name. |
| API identifier | approvalSequenceNo | The API identifier used in GraphQL. |
| Number | 18527 |
Approval Task no.
Reference to Approval Task no. in Approval task table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Approval Task no. | Integer |
| Primary key | Yes | Approval Task no., Sequence no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TskNo | The database field name. |
| API identifier | approvalTaskNo | The API identifier used in GraphQL. |
| Number | 18523 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Approval task | ApprovalTask |
|
Comment
Possible comment that was either sent to or received from Visma.net Approval.
| 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 | Cmt | The database field name. |
| API identifier | comment | The API identifier used in GraphQL. |
| Number | 18528 |
Date
Date of the performed action in Visma.net Approval.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dt | The database field name. |
| API identifier | date | The API identifier used in GraphQL. |
| Number | 18529 |
Empl. no.
Employee who is connected to the record. Reference to the Empl. no. field in Associate table.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EmpNo | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 18526 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
Message XML
Sent or received message in XML format.
| 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 | MsgXml | The database field name. |
| API identifier | messageXml | The API identifier used in GraphQL. |
| Number | 18541 |
Sequence no.
Sequence of the log records.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Approval Task no., 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 | 18524 |
Time
Time of the performed action in Visma.net Approval.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | Tm | The database field name. |
| API identifier | time | The API identifier used in GraphQL. |
| Number | 18530 |
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. |