Product description
In the Product description table you can enter an alternative product description per language.
This description can be in addition to or instead of the one entered in the Product table, it depends on whether you have checked the Add descr. field in the Language table or not. You can also in the Product description table choose to exclude printing of the alternative product description in particular types of order documents.
See also: Language
On order documents
Under Settings in the Create and send documents dialog for order documents, you can select Product descriptions in current language. This will display descriptions in the language of the customer or supplier.
The descriptions can be used in addition to or replace the descriptions in the Order line table, depending on the Add descr. field in the Language table.
On inquiries and purchase orders the supplier’s description defined in Delivery alternative table will be applied instead if Suppliers product no. and description is selected in the Settings dialog.
On the screen
The product descriptions can also contain information for internal usage, such as sales advantages or questions to customers, which can be excluded on order documents.
You can display product descriptions on the screen, for example by joining them indirectly to the Order line table via the Product table, and adding select conditions on language.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | ProdDesc | The table name in the database. |
| API identifier | productDescription | The API identifier used in GraphQL. |
| Table no. | 117 | The table number in the data model. |
The following fields exist in this table:
Description
The description of the Product in the specified Language.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Description | Text (60) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 2675 |
Exclude output
The documents on which you do not want to print the description line.
Product descriptions which only contain information for internal use, for example sales benefits or questions to the customer, can be excluded from printouts of Order documents.
Order documents
- Invoices/credit notes
- Packing slips
- Pick lists
- Delivery notes
- Order confirmations
- Quotations
- Purchase orders
- Inquiries
- Production orders
- Order prints
Customer documents
- Interest notes
- Reminders
Miscellaneous
- e-Business
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Exclude output | Integer |
| SQL name | ExOutp | The database field name. |
| API identifier | excludeOutput | The API identifier used in GraphQL. |
| Number | 4948 |
Language no.
The language the description is defined for.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Language no. | Integer |
| Primary key | Yes | Product no., Language no., Line no. |
| SQL name | LangNo | The database field name. |
| API identifier | languageNo | The API identifier used in GraphQL. |
| Number | 2674 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Language | Language |
|
Line no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Product no., Language no., Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 4394 |
Product no.
The Product the description is defined for.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| Primary key | Yes | Product no., Language no., Line no. |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 2673 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
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 | 4395 |
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.
| 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. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |