Bank

This table may contain one row with SWIFT information for each issue bank that foreign suppliers use.

The information is retrieved by some external EFT systems.

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

The following fields exist in this table:

Bank account

The bank account number you can use for payments and when importing OCR.

Electronic Funds Transfer: By using Electronic Funds Transfer you can automate the payment of your invoices.
OCR giro: By importing OCR files from the bank you do not need to enter your payments manually.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank account	Text (35)
SQL name	BGiro	The database field name.
API identifier	bankAccount	The API identifier used in GraphQL.
Number	6209

Bank branch

Details about the bank branch. For example clearing codes, bank codes, routing number etc.

This field is not used for the payment.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank account	Text (35)
SQL name	Branch	The database field name.
API identifier	bankBranch	The API identifier used in GraphQL.
Number	5073

Bank no.

A unique number identifying the bank.

It is only in the Associate table where the Bank no. field is used on payments to be able to enter the Swift code of the Bank.

SWIFT: SWIFT (Society for Worldwide Interbank Financial Telecommunication) acts as a register of addresses for the international banking network. It is used in connection with electronic funds transfer to identify the issuing bank of the payee's bank for foreign payments.

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	Bank no.	Integer
Primary key	Yes	Bank no.
SQL name	BCNo	The database field name.
API identifier	bankNo	The API identifier used in GraphQL.
Number	6203

Contact

The contact person at the bank.

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	Associate no.	Integer
SQL name	LiaActNo	The database field name.
API identifier	contact	The API identifier used in GraphQL.
Number	6215

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Contact	Contact	Associate no.

Currency account

The bank account is used as a currency account.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
SQL name	CurAc	The database field name.
API identifier	currencyAccount	The API identifier used in GraphQL.
Number	6210

Currency no.

The currency for the 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	Currency no.	Integer
SQL name	CurNo	The database field name.
API identifier	currencyNo	The API identifier used in GraphQL.
Number	6211

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Currency	Currency	Currency no.	Currency no.

Fax

The fax number of the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Phone	Text (20)
SQL name	Fax	The database field name.
API identifier	fax	The API identifier used in GraphQL.
Number	6214

GL account

The GL account which is used for accounting transactions, related to the Bank.

This field is not used for the payment.

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
SQL name	GenAcNo	The database field name.
API identifier	generalLedgerAccountNo	The API identifier used in GraphQL.
Number	6212

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	GeneralLedgerAccount	GL account	Account no.

IBAN

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank account	Text (35)
SQL name	IBAN	The database field name.
API identifier	ibanBic	The API identifier used in GraphQL.
Number	17661

Name

The name of the bank.

This field is not used for the payment.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Name	Text (80)
SQL name	Nm	The database field name.
API identifier	name	The API identifier used in GraphQL.
Number	6248

Phone

The phone number of the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Phone	Text (20)
SQL name	Phone	The database field name.
API identifier	phone	The API identifier used in GraphQL.
Number	6213

Swift address 1

The SWIFT address of the bank.

Normally you type the name of the bank in the Swift address 1 field and the rest of the address in the SWIFT address 2-4 fields.

SWIFT: SWIFT (Society for Worldwide Interbank Financial Telecommunication) acts as a register of addresses for the international banking network. It is used in connection with electronic funds transfer to identify the issuing bank of the payee's bank for foreign payments.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Address line	Text (60)
SQL name	SwftAd1	The database field name.
API identifier	swiftAddress1	The API identifier used in GraphQL.
Number	6205

Swift address 2

The SWIFT address of the bank.

Normally you type the name of the bank in the Swift address 1 field and the rest of the address in the SWIFT address 2-4 fields.

SWIFT: SWIFT (Society for Worldwide Interbank Financial Telecommunication) acts as a register of addresses for the international banking network. It is used in connection with electronic funds transfer to identify the issuing bank of the payee's bank for foreign payments.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Address line	Text (60)
SQL name	SwftAd2	The database field name.
API identifier	swiftAddress2	The API identifier used in GraphQL.
Number	6206

Swift address 3

The SWIFT address of the bank.

Normally you type the name of the bank in the Swift address 1 field and the rest of the address in the SWIFT address 2-4 fields.

SWIFT: SWIFT (Society for Worldwide Interbank Financial Telecommunication) acts as a register of addresses for the international banking network. It is used in connection with electronic funds transfer to identify the issuing bank of the payee's bank for foreign payments.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Address line	Text (60)
SQL name	SwftAd3	The database field name.
API identifier	swiftAddress3	The API identifier used in GraphQL.
Number	6207

Swift address 4

The SWIFT address of the bank.

Normally you type the name of the bank in the Swift address 1 field and the rest of the address in the SWIFT address 2-4 fields.

SWIFT: SWIFT (Society for Worldwide Interbank Financial Telecommunication) acts as a register of addresses for the international banking network. It is used in connection with electronic funds transfer to identify the issuing bank of the payee's bank for foreign payments.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Address line	Text (60)
SQL name	SwftAd4	The database field name.
API identifier	swiftAddress4	The API identifier used in GraphQL.
Number	6208

Swift code

The Swift code of the bank.

The Bank has to be registered in the Payment supplier no. or the Associate no. field in the Associate table and the Swift code has to be filled in for this bank.

SWIFT: SWIFT (Society for Worldwide Interbank Financial Telecommunication) acts as a register of addresses for the international banking network. It is used in connection with electronic funds transfer to identify the issuing bank of the payee's bank for foreign payments.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Swift code	Text (11)
SQL name	SwftCd	The database field name.
API identifier	swiftCode	The API identifier used in GraphQL.
Number	6204

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