Payment

Each time the Create payment suggestion processing in the Open supplier entry table is run, a row is added to this table.

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

The following fields exist in this table:

Bank partner no.

The Bank partner for the payment suggestion which was selected in the Create payment suggestion processing dialog box.

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	BPartNo	The database field name.
API identifier	bankPartnerNo	The API identifier used in GraphQL.
Number	6920

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

Description

The description of 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	Descr	The database field name.
API identifier	description	The API identifier used in GraphQL.
Number	6923

EFT currency code

The currency code which is used for electronic payments.

EFT Currency code texts for different languages can be defined in the Text table. These texts has text type 129.

Note:

If you double-click or press * in this field, you can look up a EFT Currency code in the Text table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	EFT Currency code	Integer
SQL name	CurCd	The database field name.
API identifier	eftCurrencyCode	The API identifier used in GraphQL.
Number	11443

Estimated transf. date

The estimated transfer date according to the payment suggestion.

The date is suggested from the Create payment suggestion dialog box. The date can be overridden.

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	PlTrfDt	The database field name.
API identifier	estimatedTransferDate	The API identifier used in GraphQL.
Number	6924

File name for bank

The name and path of the file that was sent to the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Data filename	Text (260)
SQL name	ToFileNm	The database field name.
API identifier	bankFileName	The API identifier used in GraphQL.
Number	6925

From day-seq. no.

This field is no longer in use. Be aware the field may be removed in later versions.

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	FrDySq	The database field name.
API identifier	fromDaySequenceNo	The API identifier used in GraphQL.
Number	6927

Payment no.

A unique number identifying the Payment.

The number is allocated by the system during the Create payment suggestion routine in the Open supplier entry table.

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	Payment no.	Integer
Primary key	Yes	Payment no.
SQL name	BPmtNo	The database field name.
API identifier	paymentNo	The API identifier used in GraphQL.
Number	6919

Payment status

The current status of the payment suggestion in the payment process.

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

1 - Estimate
2 - Transferred
3 - Transferred with rejections: This value is used when some payment lines are rejected by the external EFT system, and payment lines with no errors are transferred to the bank.
8 - Transferred to EFT system, not to bank: This value is a temporary status which is checked when the external EFT system processes data before the bank file is generated.
9 - Missing payment lines: This value is checked for return data when payments do not have associated payment lines.
10 - Rejected by EFT system: Transactions that are not accepted by the external EFT system are given this value. This value is used in the Payments table if all payment lines for a payment are rejected, otherwise value 3 is used.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Payment status	Integer
SQL name	PmtSt	The database field name.
API identifier	paymentStatus	The API identifier used in GraphQL.
Number	6926

Payment type

The Payment type for the payment record.

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

1 - Payment
2 - Direct debit
3 - Payment/Direct debit

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Payment type	Integer
SQL name	PmtTp	The database field name.
API identifier	paymentType	The API identifier used in GraphQL.
Number	11442

To day-seq. no.

This field is no longer in use. Be aware the field may be removed in later versions.

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	ToDySq	The database field name.
API identifier	toDaySequenceNo	The API identifier used in GraphQL.
Number	6928

Transf. date

The Transf. date on which the payment suggestion was sent to the bank for debiting.

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	TrfDt	The database field name.
API identifier	transferDate	The API identifier used in GraphQL.
Number	6922

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