Proxy

You can enter persons authorised to manage a bank account in this table, one on each row.

This may be applicable in accounting offices where employees have authority over customer accounts.

When you edit the table, the relevant row in the Associate table is locked. If you delete an associate, the corresponding rows will also be deleted in the Proxy table.

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

The following fields exist in this table:

Associate no.

The associate who owns the bank account the proxy is assigned.

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
Primary key	Yes	Associate no., Bank seq. no., Proxy no.
SQL name	ActNo	The database field name.
API identifier	associateNo	The API identifier used in GraphQL.
Number	10648

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Associate	Associate no.	Associate no.
Bank account	BankAccount	Associate no. Bank seq. no.	Associate no. Line no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Bank seq. no.

The associate's bank account the proxy is assigned.

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
Primary key	Yes	Associate no., Bank seq. no., Proxy no.
SQL name	BankLnNo	The database field name.
API identifier	bankSequenceNo	The API identifier used in GraphQL.
Number	10649

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Bank account	BankAccount	Associate no. Bank seq. no.	Associate no. Line no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Description

The description of the proxy.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	String of length 80	Text (80)
SQL name	Descr	The database field name.
API identifier	description	The API identifier used in GraphQL.
Number	10654

From date

The date from which proxy assignment is valid.

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
SQL name	FrDt	The database field name.
API identifier	fromDate	The API identifier used in GraphQL.
Number	10651

Proxy associate no.

The associate who is assigned as a proxy.

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	PrxActNo	The database field name.
API identifier	proxyAssociateNo	The API identifier used in GraphQL.
Number	10650

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	ProxyAssociate	Proxy associate no.	Associate no.

Proxy no.

A unique number in the combination of associate and bank account.

Note:

The Line no. does not change when inserting new lines between existing ones. The Sort seq. no. specifies the order of the lines and is affected when new lines are inserted between existing lines.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Associate no., Bank seq. no., Proxy no.
SQL name	PrxNo	The database field name.
API identifier	proxyNo	The API identifier used in GraphQL.
Number	10804

Proxy type

The type of proxy relationship.

Proxy type texts for different languages can be defined in the Text table. These texts has text type 147.

Note:

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

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Proxy type	Integer
SQL name	PrxTp	The database field name.
API identifier	proxyType	The API identifier used in GraphQL.
Number	10653

Sort seq. no.

The order of the lines.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Sort seq. no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	Srt	The database field name.
API identifier	sortSequenceNo	The API identifier used in GraphQL.
Number	10655

To date

The date to which proxy assignment is valid.

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
SQL name	ToDt	The database field name.
API identifier	toDate	The API identifier used in GraphQL.
Number	10652

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.