Active company process
This table contains one row for each company process in the currently logged on sessions.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | ActPrc | The table name in the database. |
| API identifier | activeCompanyProcess | The API identifier used in GraphQL. |
| Table no. | 23 | The table number in the data model. |
The following fields exist in this table:
Process no.
The process number which is also an unique identifier for the active company process.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Process no. | Integer |
| Primary key | Yes | Process no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Prc | The database field name. |
| API identifier | activeProcessNo | The API identifier used in GraphQL. |
| Number | 461 |
Processing
The operation in progress.
- 58 - Saving changes
- 23 - Printing purchase suggestions
- 27 - Generating orders from purchase suggestions
- 30 - Splitting orders
- 65 - Transferring order lines
- 31 - Resetting orders
- 32 - Adding order lines
- 62 - Recalculating prices for order
- 49 - Resaving orders
- 33 - Cancelling orders
- 34 - Confirming/Accepting orders
- 35 - Registering shipment from supplier
- 16 - Finishing orders
- 37 - Returning orders
- 38 - Registering invoice reception
- 84 - Invoice receival from import basis
- 46 - Updating orders
- 20 - Finishing pick lists
- 21 - Withdrawing pick lists
- 8 - Printing invoices
- 75 - Printing consignment note
- 39 - Printing labels
- 40 - Printing packing slips
- 41 - Printing pick lists
- 42 - Printing order confirmations
- 43 - Printing quotations
- 44 - Printing purchase orders
- 87 - Approval requests
- 45 - Printing inquiries
- 57 - Printing production orders
- 22 - Creating stock balances
- 19 - Adjusting prices
- 54 - Transferring to stock count
- 55 - Withdrawing reservations
- 15 - Correcting stock balances
- 29 - Regenerating stock balances
- 47 - Calculating "in order" inside lead time
- 17 - Transferring shipments
- 18 - Separating shipments
- 56 - Posting costs
- 63 - Internal invoicing
- 77 - Calculate production start
- 85 - Calculate production costs
- 1 - Updating vouchers
- 48 - Creates new batches from updated batches
- 61 - Creating batch with differences
- 89 - Updating accounting balances
- 10 - Regenerating accounting balances
- 52 - Printing delivery notifications
- 11 - Editing open customer entries
- 2 - Matching open customer entries
- 79 - Lookup and match customer entry
- 67 - Writes off payments
- 74 - Splitting invoice payment
- 9 - Terminating customer entries
- 3 - Cancelling matching of customer entries
- 24 - Direct debiting
- 25 - Creating new direct debits
- 64 - Generate factoring file
- 5 - Printing reminders
- 6 - Printing interest notes
- 68 - Calculate client interest
- 81 - Delete client interest suggestion
- 82 - Post client interest suggestion
- 51 - Printing refund requests
- 50 - Authorising incoming invoices
- 12 - Editing open supplier entries
- 13 - Matching open supplier entries
- 80 - Lookup and match supplier entry
- 14 - Cancelling matching of supplier entries
- 7 - Paying suppliers
- 83 - Terminate supplier entries
- 26 - Depreciating capital assets
- 70 - Activating capital asset
- 28 - Generating automatic entries
- 88 - Bank reconciliation statements
- 4 - Closing VAT periods
- 86 - Closing OSS VAT periods
- 53 - Compresses transactions
- 59 - Changing unit for exchange rates
- 60 - Changing default currency
- 66 - Deleting orders
- 69 - Export batch to file
- 71 - Sending debt collection report
- 72 - Transfer to currency correction from trans table
- 73 - Transfer from currency correction to trans table
- 76 - Transfer to wage
- 78 - Approve time schedule
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Processing | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Func | The database field name. |
| API identifier | processFunctionNo | The API identifier used in GraphQL. |
| Number | 1983 |
Session ID
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | GUID | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SesId | The database field name. |
| API identifier | sessionId | The API identifier used in GraphQL. |
| Number | 16544 |
Session no.
A unique number identifying the user for the duration of that user's session.
This number is related to the Session no. field from the Active session table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Session no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SesNo | The database field name. |
| API identifier | sessionNo | The API identifier used in GraphQL. |
| Number | 4857 |
Tables with locked rows
Information about the tables in which a row is locked for insertions or changes.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Tables with locked rows | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TabFlB | The database field name. |
| API identifier | tablesWithLockedRowsBlob | The API identifier used in GraphQL. |
| Number | 16399 |
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. |