Realisation journal line

This table contains one row for each product transaction that is realised.

Property	Value	Description
Database	Company	This table is in the company databases.
SQL name	RealJLn	The table name in the database.
API identifier	realisationJournalLine	The API identifier used in GraphQL.
Table no.	355	The table number in the data model.

The following fields exist in this table:

Journal date

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	JDt	The database field name.
API identifier	journalDate	The API identifier used in GraphQL.
Number	16598

Line no.

Each line in the table is given a consecutive number in the order in which they are entered.

Note:

The Line no. does not change when inserting new lines between existing ones. The Sort seq. no. specifies the order of the lines and is affected when new lines are inserted between existing lines.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Realisation journal no., Line no.
Write Access	None	You are not allowed to modify the value in this field.
SQL name	LnNo	The database field name.
API identifier	lineNo	The API identifier used in GraphQL.
Number	15263

Order jour. no.

The order journal of the associated product transaction.

The value is set when the Realisation journal line record is created.

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	Journal no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	OrdJNo	The database field name.
API identifier	orderJournalNo	The API identifier used in GraphQL.
Number	15264

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Order journal	OrderJournal	Order jour. no.	Order jour. no.
Product transaction	ProductTransaction	Order jour. no. Trans. no.	Order jour. no. Trans. no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Order no.

The order that is the source of the realisation journal.

The value is set when the Realisation journal line record is created.

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	Order no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	OrdNo	The database field name.
API identifier	orderNo	The API identifier used in GraphQL.
Number	15266

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Order	Order	Order no.	Order no.
General ledger transaction	AccountTransactionOrderNo	Order no.	Order no.

Period

The accounting period of the corresponding accounting transaction.

The value is set when the record in the Voucher table, produced of the realisation, gets updated.

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	Pr	The database field name.
API identifier	period	The API identifier used in GraphQL.
Number	16332

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Accounting period	AccountingPeriod	Year Period	Year Period	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Posted value

Property	Value	Description
Visible by default	Yes	This field is 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	RlStcVal	The database field name.
API identifier	realisedStockValueDomestic	The API identifier used in GraphQL.
Number	16597

Realisation journal no.

The record in the Realisation journal table that this Realisation journal line record belongs to.

The value is set when the Realisation journal line record is created.

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	Journal no.	Integer
Primary key	Yes	Realisation journal no., Line 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	15262

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Realisation journal	RealisationJournal	Realisation journal no.	Realisation journal no.

Stock change

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	StcCh	The database field name.
API identifier	stockChange	The API identifier used in GraphQL.
Number	16595

Stock value

Property	Value	Description
Visible by default	Yes	This field is 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	StcCst	The database field name.
API identifier	stockCostsDomestic	The API identifier used in GraphQL.
Number	16596

Trans. no.

The number of the associated product transaction.

The value is set when the Realisation journal line record is created.

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	No.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	TrNo	The database field name.
API identifier	transactionNo	The API identifier used in GraphQL.
Number	15265

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
Product transaction	ProductTransaction	Order jour. no. Trans. no.	Order jour. no. Trans. no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Value date

The value in the Value date field of the corresponding record in the General ledger transaction table.

The value is set when the record in the Voucher table, produced of the realisation, gets updated.

The date is validated using the regional settings in Windows.

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	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ValDt	The database field name.
API identifier	valueDate	The API identifier used in GraphQL.
Number	16330

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger transaction	AccountTransactionValueDate	Value date	Value date

Voucher jour. no.

The value in the Voucher jour. no. field of the corresponding record in the Updated journal table.

The value is set when the record in the Voucher table, produced of the realisation, gets updated.

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	Journal no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	VoJNo	The database field name.
API identifier	voucherJournalNo	The API identifier used in GraphQL.
Number	15267

Table 7. Table relations
To table	Purpose	From columns	To columns
Updated journal	UpdatedJournal	Voucher jour. no.	Voucher jour. no.
General ledger transaction	AccountTransactionVoucherJournalNo	Voucher jour. no.	Voucher jour. no.
Realisation journal	RealisationJournalVoucherJournalNo	Voucher jour. no.	Voucher jour. no.

Year

The value in the Year field of the corresponding record in the General ledger transaction table.

The value is set when the record in the Voucher table, produced of the realisation, gets updated.

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
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	16331

Table 8. Table relations
To table	Purpose	From columns	To columns	Comments
Accounting period	AccountingPeriod	Year Period	Year Period	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.

Table 9. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.