Incoming payment line

This table contains details about incoming payments imported from Visma.net AutoPay.

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

The following fields exist in this table:

Address line

The payer's address.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Address line	Text (60)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PayAd	The database field name.
API identifier	payersAddress	The API identifier used in GraphQL.
Number	19638

AutoPay log seq. no.

Reference to the Identifier column in Visma.net AutoPay log table, where the actual incoming payment file is stored.

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	AutoPay log seq. no., Payment element index, Payment line element index
Write Access	None	You are not allowed to modify the value in this field.
SQL name	SeqNo	The database field name.
API identifier	entryNo	The API identifier used in GraphQL.
Number	19632

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Visma.net AutoPay log	AutopayLog	AutoPay log seq. no.	No.
Voucher	Voucher	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Updated voucher	UpdatedVoucher	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Open customer entry	OpenCustomerEntry	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Customer transaction	CustomerTransaction	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Accounting transaction	AccountingTransaction	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Credit note no.

Reference to credit note.

Retrieved from the <CreditNoteNumber> element in the incoming payment file.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Doc. no.	Text (40)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CrNtNo	The database field name.
API identifier	creditNoteNo	The API identifier used in GraphQL.
Number	19642

Invoice no.

Reference to invoice.

Retrieved from the <InvoiceNumber> element in the incoming payment file.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Doc. no.	Text (40)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	InvoNo	The database field name.
API identifier	invoiceNo	The API identifier used in GraphQL.
Number	19641

Name

The payer's name.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Name	Text (80)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PayNm	The database field name.
API identifier	payersName	The API identifier used in GraphQL.
Number	19637

Payer's account no.

The payer's 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	PayAcc	The database field name.
API identifier	payersAccount	The API identifier used in GraphQL.
Number	19635

Payer's post office

The payer's postal area.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Address line	Text (60)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PayPArea	The database field name.
API identifier	payersPostOffice	The API identifier used in GraphQL.
Number	19640

Payment element index

Reference to the relevant <Payment> element in the incoming payment file.

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	AutoPay log seq. no., Payment element index, Payment line element index
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PayIdx	The database field name.
API identifier	paymentIndex	The API identifier used in GraphQL.
Number	19633

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Voucher	Voucher	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Updated voucher	UpdatedVoucher	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Open customer entry	OpenCustomerEntry	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Customer transaction	CustomerTransaction	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Accounting transaction	AccountingTransaction	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Payment line element index

Reference to the relevant <PaymentLine> element in the incoming payment file.

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	AutoPay log seq. no., Payment element index, Payment line element index
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PayLnIdx	The database field name.
API identifier	paymentLineIndex	The API identifier used in GraphQL.
Number	19634

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Voucher	Voucher	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Updated voucher	UpdatedVoucher	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Open customer entry	OpenCustomerEntry	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Customer transaction	CustomerTransaction	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Accounting transaction	AccountingTransaction	AutoPay log seq. no. Payment element index Payment line element index	AutoPay log seq. no. Payment element index Payment line element index	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Post code

The payer's post code.

If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Post code	Text (40)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PayPNo	The database field name.
API identifier	payersPostCode	The API identifier used in GraphQL.
Number	19639

Proprietary code

Bank transaction code for the payment.

The content of the Proprietary code is bank-specific.

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

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.