Realisation journal
This table contains one row for each time some product transactions are realised.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | RealJ | The table name in the database. |
| API identifier | realisationJournal | The API identifier used in GraphQL. |
| Table no. | 341 | The table number in the data model. |
The following fields exist in this table:
Number of transactions
The number of product transaction records for this realisation journal.
| 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 | TrCnt | The database field name. |
| API identifier | noOfTransactions | The API identifier used in GraphQL. |
| Number | 15261 |
Origin
The process action that created the realisation journal.
- 1 - Manually entered
- 2 - Automatically generated
- 13 - Automatic entry
- 3 - VAT report
- 41 - OSS VAT report
- 10 - Direct debiting
- 4 - Reminder
- 5 - Interest note
- 8 - OCR payment
- 21 - Write off payments
- 6 - Giro payment
- 7 - Direct payment
- 11 - Depreciation on capital assets
- 9 - Order processing
- 23 - Incoming invoice
- 12 - Import
- Normal text import.
- 14 - Previous batch
- 15 - Compressing transactions
- 16 - Posting of costs
- 18 - Internal invoicing
- 17 - Differences
- When you update a batch with this origin code debit/credit control is not carried out.
- 19 - EDI invoice import
- 20 - Payroll
- 22 - Visma Business Services
- 24 - Activate Capital asset
- 25 - Calculate client interest
- 26 - Document Center temporary batch
- 27 - Document Center finished batch
- 28 - Debt collector
- 29 - Split invoice
- 30 - Currency correction
- 31 - External application
- If this origin code is used, this value can be used by other applications that use BIG or SQL and create batches.
- 32 - Cash order document
- 33 - Sell or scrap capital asset
- 34 - Initializing capital asset
- 35 - EDI read dirdeb vouchers
- 37 - Accrual accounting
- 38 - Order processing with picking after invoicing
- 39 - Picked after invoicing
- 40 - Correction of costs
- 42 - Accounting document
- Batch was created from Accounting document table.
- 43 - Order match pre-registration
- 44 - Self billing invoice
- 45 - Split batch, supplier transactions
- Batch was created by Update supplier transactions processing for supplier transactions only.
- 46 - Split batch, cost transactions
- Batch was created by Update supplier transactions processing for cost and capital transactions to be adjusted after payment.
- 47 - Account statement vouchers
- Batch was created by Create voucher processing in the Account statement transaction table.
- 48 - WebFaktura
- 49 - Central
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Prc | The database field name. |
| API identifier | origin | The API identifier used in GraphQL. |
| Number | 15260 |
Realisation journal no.
A unique number identifying the realisation journal.
Is stamped in the Last realisation journal no. field in the Product transaction table, and in the Realisation journal no. field in the Reservation and Voucher tables.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Journal no. | Integer |
| Primary key | Yes | Realisation journal no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RealJNo | The database field name. |
| API identifier | realisationJournalNo | The API identifier used in GraphQL. |
| Number | 13885 |
Voucher jour. no.
The voucher jour. no. of the realisation journal.
The value refers to the Voucher jour. no. field in the Updated journal table. The value is set when the produced voucher of the realisation is updated.
| 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 | JNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 16329 |
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. |