Reconciled transaction

This table serves as a link between reconciled transactions in the General ledger transaction and Account statement transaction tables.

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

The following fields exist in this table:

Account statement trans. no.

Link to reconciled entry in Account statement transaction table.

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
Primary key	Yes	Account statement trans. no., Voucher jour. no., Audit no.
Write Access	None	You are not allowed to modify the value in this field.
SQL name	AcStmtTrNo	The database field name.
API identifier	accountStatementTransactionNo	The API identifier used in GraphQL.
Number	18660

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Account statement transaction	AccountStatementTransaction	Account statement trans. no.	Account statement trans. no.

Algorithm

Which reconciliation algorithm that was used for the row.

A look-up in this field gives you the following list of possible values:

1 - Manually reconciled: Manually reconciled. The Manual reconciliation processing has been executed for the transactions.
7 - Single transactions with same bank reference
2 - Multiple general ledger transactions on same date: Automatically reconciled. Multiple General ledger transaction rows have been reconciled with one Account statement transaction row. Same date on all rows.
3 - Multiple account statement transactions on same date: Automatically reconciled. Multiple Account statement transaction rows have been reconciled with one General ledger transaction row. Same date on all rows.
4 - Single transactions on same date: Automatically reconciled. One General ledger transaction row has been reconciled with one Account statement transaction row. Same date on both rows.
5 - Account statement transaction on later date: Automatically reconciled. One General ledger transaction row has been reconciled with one Account statement transaction row. The date on the Account statement transaction row is one day later than the date on the General ledger transaction row.
6 - General ledger transaction on later date: Automatically reconciled. One General ledger transaction row has been reconciled with one Account statement transaction row. The date on the General ledger transaction row is one day later than the date on the Account statement transaction row.
8 - Multiple debit and credit general ledger transactions on same date
9 - Manually reconciled multiple debit and credit general ledger transactions
10 - Multiple general ledger transactions against multiple account statement transactions on same date

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Algorithm	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	Alg	The database field name.
API identifier	algorithm	The API identifier used in GraphQL.
Number	18812

Audit no.

Link to reconciled entry in General ledger transaction table, together with the Voucher jour. no. field.

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	Audit no.	Integer
Primary key	Yes	Account statement trans. no., Voucher jour. no., Audit no.
Write Access	None	You are not allowed to modify the value in this field.
SQL name	EntNo	The database field name.
API identifier	auditNo	The API identifier used in GraphQL.
Number	18662

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger transaction	GeneralLedgerTransaction	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Bank partner no.

The bank partner for which the reconciled transaction belongs to.

This foreign key allows for the Bank partner table to be joined with the Reconciled transaction table.

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

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Bank partner	BankPartner	Bank partner no.	Bank partner no.

Reconciled amount

Reconciled amount.

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	RecAm	The database field name.
API identifier	reconciledAmountDomestic	The API identifier used in GraphQL.
Number	18665

Reconciled amount in currency

Reconciled amount in currency.

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	CurRecAm	The database field name.
API identifier	reconciledAmountInCurrency	The API identifier used in GraphQL.
Number	18664

Reconciliation no.

Approved reconciliation number.

Assigned a value when the row is printed on the Bank reconciliation statement report, and the report is approved.

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	RecNo	The database field name.
API identifier	reconciliationNo	The API identifier used in GraphQL.
Number	18663

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Approved reconciliation	ApprovedReconciliation	Reconciliation no.	Reconciliation no.

Voucher jour. no.

Link to reconciled entry in General ledger transaction table, together with the Audit no. field.

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	Account statement trans. no., Voucher jour. no., Audit no.
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	18661

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger transaction	GeneralLedgerTransaction	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	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 6. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.