Corporation settlement account

You use this table to create account mappings between companies.

Property	Value	Description
Database	System	This table is in the system (vbsys) database.
SQL name	GrpSetl	The table name in the database.
API identifier	corporationSettlementAccount	The API identifier used in GraphQL.
Table no.	333	The table number in the data model.

The following fields exist in this table:

Corp. settlement proc.

The type of settlement processing.

A look-up opens the dialog box where you can see the following check boxes and options:

Corp. settlement type

Other
OCR payments: This option is reserved for some EFT systems for reading OCR and will be used for corporate solutions.
Reconciliation: This functionality is not supported in Business NXT. This option is reserved for the BankX solution.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Corp. settlement proc.	Integer
SQL name	GrpProc	The database field name.
API identifier	corporateSettlementProcessing	The API identifier used in GraphQL.
Number	13799

Corp. settlement type

The type of OCR settlement account.

Note:

If a type is not given, 3 - General ledger account is assumed.

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

1 - Customer: The account number refer to a customer.
2 - Supplier: The account number refer to a supplier.
3 - General ledger account: The account number refer to a general ledger account.
4 - Capital asset: The account number refer to a capital asset.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account type	Integer
SQL name	GrpAcTp	The database field name.
API identifier	corporateSettlementType	The API identifier used in GraphQL.
Number	13800

From company no.

The company where the corporate settlement operates from.

For accounts where the corporate settlement processing is OCR payments, this is the company where the money is paid to.
For accounts where the corporate settlement processing is Reconciliation, this is the company where the data is fetched from.

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	Company no.	Integer
SQL name	FrFrmNo	The database field name.
API identifier	fromCompanyNo	The API identifier used in GraphQL.
Number	13021

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Company	FromCompany	From company no.	Company no.

Line no.

A unique number identifying the corporation settlement account .

Note:

If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Line no.
SQL name	LnNo	The database field name.
API identifier	lineNo	The API identifier used in GraphQL.
Number	13020

OCR Settlement account

The account to be used for the company you transfer payments to.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	OCRAcNo	The database field name.
API identifier	ocrSettlementAccountNo	The API identifier used in GraphQL.
Number	13023

To company no.

The company the data is transferred to.

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	Company no.	Integer
SQL name	ToFrmNo	The database field name.
API identifier	toCompanyNo	The API identifier used in GraphQL.
Number	13022

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Company	ToCompany	To company no.	Company no.

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