Approved reconciliation

This table contains information about approved reconciliation.

Each time the Bank reconciliation statement report is processed using the Finalise (or Send) options from the Bank partner table, a row is added to this table.

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

The following fields exist in this table:

Bank account name

Name of the reconciled bank account.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	String of length 100	Text (100)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	BankAcNm	The database field name.
API identifier	bankAccountName	The API identifier used in GraphQL.
Number	18642

Bank account no.

The reconciled bank account no.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank account	Text (35)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	BankG	The database field name.
API identifier	bankAccountNo	The API identifier used in GraphQL.
Number	18641

Bank partner no.

The bank partner for which the bank reconciliation statement belongs to.

This foreign key allows for the Bank partner table to be joined with the Approved reconciliation 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	18963

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

Closing bank balance

Closing balance for the reconciled period, from the bank.

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	ClBankBal	The database field name.
API identifier	closingBankBalance	The API identifier used in GraphQL.
Number	18649

Closing GL balance

Closing balance for the reconciled period, from the accounting.

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	ClGlBal	The database field name.
API identifier	closingGeneralLedgerBalance	The API identifier used in GraphQL.
Number	18647

Corrected GL balance

Closing general ledger balance after corrections.

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	CorGlBal	The database field name.
API identifier	correctedGeneralLedgerBalance	The API identifier used in GraphQL.
Number	18646

Difference

Difference amount for the approved reconciliation.

Calculated as the difference between the Closing bank balance and Corrected GL balance fields.

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.
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	difference	The API identifier used in GraphQL.
Number	18825

File data

Contains the reconciliation report in PDF format.

Double click in the field will open the reconciliation report in a PDF browser.

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	FileData	The database field name.
API identifier	fileData	The API identifier used in GraphQL.
Number	18826

GL bank account

General ledger account no. for bank.

The general ledger account no. for the reconciled bank account.

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

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	BankAccount	GL bank account	Account no.

Period

Accounting period for the reconciliation.

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

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.

Reconciled per date

Reconciliation approved per 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	RecPerDt	The database field name.
API identifier	reconciledPerDate	The API identifier used in GraphQL.
Number	18645

Reconciliation date

Date when the approval of the reconciliation was done.

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	RecoDt	The database field name.
API identifier	reconciliationDate	The API identifier used in GraphQL.
Number	18644

Reconciliation no.

Incremental value, primary key of the table.

When the Bank reconciliation statement report is printed from the Bank partner table and the content is approved, all relevant transactions in the Reconciled transaction table will be updated with this value.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Reconciliation no.
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	18640

Year

Accounting year for the reconciliation.

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	AcYr	The database field name.
API identifier	year	The API identifier used in GraphQL.
Number	18823

Table 4. 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 5. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.