Order attachment

When attachments are added to orders, they are stored in this table.

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

The following fields exist in this table:

Attachment no.

Within an order, attachments are given a consecutive number, in the order in which they are entered.

Note:

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

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	Order no., Attachment no.
SQL name	AttNo	The database field name.
API identifier	attachmentNo	The API identifier used in GraphQL.
Number	16514

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Order document attachment	OrderDocumentAttachment	Order no. Attachment no.	Order no. Attachment 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 order attachment.

If the field is empty when adding an attachment, value is suggested from the attachments file name.

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

File data

The attachment.

The field where the actual attachment is stored. If data is present, the field displays a clip.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	File in BLOB	Unlimited text
Write Access	None	You are not allowed to modify the value in this field.
SQL name	FileData	The database field name.
API identifier	fileData	The API identifier used in GraphQL.
Number	16526

File no.

Reference to file stored in File Service.

Automatically set when executing the Attach documents processing. Links to the File archive table, where actual the reference to File Service 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	No	This field is not visible by default in the table display.
Domain	File no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	FlNo	The database field name.
API identifier	fileNo	The API identifier used in GraphQL.
Number	19685

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
File archive	FileArchive	File no.	File no.

Order attachment processing

Settings specifying to which order documents the attachment shall be connected.

Note:

Setting and clearing check boxes after the document is printed, does not affect order document copies.

A look-up opens the dialog box where you can see the following check boxes and options:

Attach to order documents

Invoices/credit notes: The attachment will be printed together with invoices/credit notes.
Consignment notes: The attachment will be printed together with consignment notes.
Packing slips: The attachment will be printed together with packing slips.
Pick lists: The attachment will be printed together with pick lists.
Order confirmations: The attachment will be printed together with order confirmations.
Quotations: The attachment will be printed together with quotations.
Purchase orders: The attachment will be printed together with purchase orders.
Approval requests: The attachment will be printed together with Approval request order document types.
Inquiries: The attachment will be printed together with inquiries.
Production orders: The attachment will be printed together with production orders.
Order prints: The attachment will be printed together with order prints.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Order attachment processing	Integer
SQL name	OrdAttProc	The database field name.
API identifier	orderAttachmentProcessing	The API identifier used in GraphQL.
Number	16517

Order attachment type

Specification of the attachments file type.

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

1 - PDF document

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Order attachment type	Integer
SQL name	FileTp	The database field name.
API identifier	fileType	The API identifier used in GraphQL.
Number	16518

Order no.

The order to which the attachment is connected.

Foreign key to the Order and Order document tables.

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
Primary key	Yes	Order no., Attachment no.
SQL name	OrdNo	The database field name.
API identifier	orderNo	The API identifier used in GraphQL.
Number	16513

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Order	Order	Order no.	Order no.
Order document attachment	OrderDocumentAttachment	Order no. Attachment no.	Order no. Attachment 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	16515

Source file name

The file name of the attachment.

The source file name without path information.

Tip:

If a value is added to the field double-clicking or pressing * displays the file. If no file is selected a Select file dialog will be opened.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	File name	Text (260)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	SrcFNm	The database field name.
API identifier	sourceFileName	The API identifier used in GraphQL.
Number	16519

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.