Document link

This table may contain one or more rows for each version of a document, with references to rows in other tables.

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

The following fields exist in this table:

Amount

Amount based on the supplier invoice document.

This field is used for order match functionality.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	Am	The database field name.
API identifier	amountInCurrency	The API identifier used in GraphQL.
Number	17804

Appointment associate no.

The person responsible for the appointment the document is linked 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	Associate no.	Integer
SQL name	AgrActNo	The database field name.
API identifier	appointmentAssociateNo	The API identifier used in GraphQL.
Number	3888

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Appointment	Appointment	Appointment associate no. Appointment no.	Appointment associate no. Appointment no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Appointment no.

The appointment the document is linked 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	Appointment no.	Integer
SQL name	AgrNo	The database field name.
API identifier	appointmentNo	The API identifier used in GraphQL.
Number	3889

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Appointment	Appointment	Appointment associate no. Appointment no.	Appointment associate no. Appointment no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Associate no.

The associate the document is linked to.

The associate can be any type of Associate.

For example, the field is filled in if the document is created from the Associate table.

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	ActNo	The database field name.
API identifier	associateNo	The API identifier used in GraphQL.
Number	3886

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

Cap. asset no.

The capital asset the document is linked 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	Cap. asset no.	Integer
SQL name	PropNo	The database field name.
API identifier	capitalAssetNo	The API identifier used in GraphQL.
Number	5666

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Capital asset	CapitalAsset	Cap. asset no.	Cap. asset no.

CID code

The CID from the supplier invoice.

This field is used for order match functionality.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	CID code	Text (30)
SQL name	CID	The database field name.
API identifier	cid	The API identifier used in GraphQL.
Number	17799

Contact

The contact person the document is linked to. The contact person must belong to the customer or supplier referenced in Associate no. field.

You can select a Contact person while running the Create document processing.

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	4449

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

Corporate company no.

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	Corporate company no.	Integer
SQL name	CorpCompNo	The database field name.
API identifier	corporateCompanyNo	The API identifier used in GraphQL.
Number	20749

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
Corporate company	CorporateCompany	Corporate company no.	Corporate company no.

Created by associate

The user who created the document.

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	CrActNo	The database field name.
API identifier	createdByAssociateNo	The API identifier used in GraphQL.
Number	4227

Table 7. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	CreatedByAssociate	Created by associate	Associate no.

Disc. amount

Discount amount based on the supplier invoice document.

This field is used for order match functionality.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	DcAm	The database field name.
API identifier	discountAmountInCurrency	The API identifier used in GraphQL.
Number	17803

Disc. %

Discount % based on the supplier invoice document.

This field is used for order match functionality.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	DcP	The database field name.
API identifier	discountPercent	The API identifier used in GraphQL.
Number	17802

Doc. no.

The document that is linked.

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	Doc. no.	Integer
Primary key	Yes	Doc. no., Version no., Line no.
SQL name	DocNo	The database field name.
API identifier	documentNo	The API identifier used in GraphQL.
Number	3884

Table 8. Table relations
To table	Purpose	From columns	To columns	Comments
Document	Document	Doc. no. Version no.	Doc. no. Version no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Due date

The due date from the supplier invoice.

This field is used for order match functionality.

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	DueDt	The database field name.
API identifier	dueDate	The API identifier used in GraphQL.
Number	17798

Invoice date

The invoice date from the supplier invoice.

This field is used for order match functionality.

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	InvoDt	The database field name.
API identifier	invoiceDate	The API identifier used in GraphQL.
Number	17797

Invoice no.

The Invoice number from the supplier invoice.

This field is used for order match functionality.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Doc. no.	Text (40)
SQL name	InvoNo	The database field name.
API identifier	invoiceNo	The API identifier used in GraphQL.
Number	17796

Line no.

Each line in the table is given a consecutive number in the order in which they are entered.

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	Doc. no., Version no., Line no.
SQL name	LnNo	The database field name.
API identifier	lineNo	The API identifier used in GraphQL.
Number	3885

Order line no.

The order line number from the supplier invoice.

This field is used for order match functionality.

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
SQL name	OrdLnNo	The database field name.
API identifier	orderLineNo	The API identifier used in GraphQL.
Number	17795

Table 9. Table relations
To table	Purpose	From columns	To columns	Comments
Order line	OrderLine	Order no. Order line no.	Order 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.

Order no.

The order the document is linked 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	Order no.	Integer
SQL name	OrdNo	The database field name.
API identifier	orderNo	The API identifier used in GraphQL.
Number	4370

Table 10. Table relations
To table	Purpose	From columns	To columns	Comments
Order	Order	Order no.	Order no.
Order line	OrderLine	Order no. Order line no.	Order 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.

Organisational unit 1

The field is used to specify organisational unit.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

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	Organisational unit no.	Integer
SQL name	R1	The database field name.
API identifier	orgUnit1	The API identifier used in GraphQL.
Number	4230

Table 11. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 1	OrgUnit1	Organisational unit 1	Organisational unit 1 no.

Organisational unit 2

The field is used to specify organisational unit.

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	Organisational unit no.	Integer
SQL name	R2	The database field name.
API identifier	orgUnit2	The API identifier used in GraphQL.
Number	4231

Table 12. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 2	OrgUnit2	Organisational unit 2	Organisational unit 2 no.

Organisational unit 3

The field is used to specify organisational unit.

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	Organisational unit no.	Integer
SQL name	R3	The database field name.
API identifier	orgUnit3	The API identifier used in GraphQL.
Number	4232

Table 13. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 3	OrgUnit3	Organisational unit 3	Organisational unit 3 no.

Organisational unit 4

The field is used to specify organisational unit.

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	Organisational unit no.	Integer
SQL name	R4	The database field name.
API identifier	orgUnit4	The API identifier used in GraphQL.
Number	4233

Table 14. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 4	OrgUnit4	Organisational unit 4	Organisational unit 4 no.

Organisational unit 5

The field is used to specify organisational unit.

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	Organisational unit no.	Integer
SQL name	R5	The database field name.
API identifier	orgUnit5	The API identifier used in GraphQL.
Number	4234

Table 15. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 5	OrgUnit5	Organisational unit 5	Organisational unit 5 no.

Organisational unit 6

The field is used to specify organisational unit.

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	Organisational unit no.	Integer
SQL name	R6	The database field name.
API identifier	orgUnit6	The API identifier used in GraphQL.
Number	4235

Table 16. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 6	OrgUnit6	Organisational unit 6	Organisational unit 6 no.

Organisational unit 7

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

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	Long alphanumeric organisational unit no.	Text (40)
SQL name	R7	The database field name.
API identifier	orgUnit7	The API identifier used in GraphQL.
Number	9582

Table 17. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 7	OrgUnit7	Organisational unit 7	Organisational unit 7 no.

Organisational unit 8

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

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	Short alphanumeric organisational unit no.	Text (10)
SQL name	R8	The database field name.
API identifier	orgUnit8	The API identifier used in GraphQL.
Number	9583

Table 18. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 8	OrgUnit8	Organisational unit 8	Organisational unit 8 no.

Organisational unit 9

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

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	Short alphanumeric organisational unit no.	Text (10)
SQL name	R9	The database field name.
API identifier	orgUnit9	The API identifier used in GraphQL.
Number	9584

Table 19. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 9	OrgUnit9	Organisational unit 9	Organisational unit 9 no.

Organisational unit 10

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

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	Short alphanumeric organisational unit no.	Text (10)
SQL name	R10	The database field name.
API identifier	orgUnit10	The API identifier used in GraphQL.
Number	9585

Table 20. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 10	OrgUnit10	Organisational unit 10	Organisational unit 10 no.

Organisational unit 11

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

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	Short alphanumeric organisational unit no.	Text (10)
SQL name	R11	The database field name.
API identifier	orgUnit11	The API identifier used in GraphQL.
Number	9586

Table 21. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 11	OrgUnit11	Organisational unit 11	Organisational unit 11 no.

Organisational unit 12

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

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	Short alphanumeric organisational unit no.	Text (10)
SQL name	R12	The database field name.
API identifier	orgUnit12	The API identifier used in GraphQL.
Number	9587

Table 22. Table relations
To table	Purpose	From columns	To columns	Comments
Organisational unit 12	OrgUnit12	Organisational unit 12	Organisational unit 12 no.

Price

Price based on the supplier invoice document.

This field is used for order match functionality.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Price	Decimal
SQL name	Price	The database field name.
API identifier	priceInCurrency	The API identifier used in GraphQL.
Number	17801

Product no.

The product the document is linked 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	Product no.	Text (40)
SQL name	ProdNo	The database field name.
API identifier	productNo	The API identifier used in GraphQL.
Number	3887

Table 23. Table relations
To table	Purpose	From columns	To columns	Comments
Product	Product	Product no.	Product no.
Search product	SearchProduct	Product no.	Product no.

Quantity

Quantity based on the supplier invoice document.

This field is used for order match functionality.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	NoInvoAb	The database field name.
API identifier	quantity	The API identifier used in GraphQL.
Number	17800

Rsv. no.

The reservation the document is linked 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	Appointment no.	Integer
SQL name	RsvNo	The database field name.
API identifier	reservationNo	The API identifier used in GraphQL.
Number	4246

Table 24. Table relations
To table	Purpose	From columns	To columns	Comments
Resource reservation	ResourceReservation	Res. no. Rsv. no.	Res. no. Rsv. no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Res. no.

The resource the document is linked 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	Res. no.	Integer
SQL name	ResNo	The database field name.
API identifier	resourceNo	The API identifier used in GraphQL.
Number	4245

Table 25. Table relations
To table	Purpose	From columns	To columns	Comments
Resource	Resource	Res. no.	Res. no.
Resource reservation	ResourceReservation	Res. no. Rsv. no.	Res. no. Rsv. no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

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	3890

Version no.

The version number of the document.

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	Doc. no., Version no., Line no.
SQL name	VerNo	The database field name.
API identifier	versionNo	The API identifier used in GraphQL.
Number	6728

Table 26. Table relations
To table	Purpose	From columns	To columns	Comments
Document	Document	Doc. no. Version no.	Doc. no. Version no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

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