Search product
When you search in the Product no. field, the search is made in both number and description fields.
If there is only one option, it will be entered directly on the order line. If there are more options, these are displayed in a dialog where you can filter further to find and select the requested product.
Performing a search
- Click in the Product no. field.
- Enter one or more letters/digits of what you are searching for, and press Enter.
- You can enter more letters/digits on the line above the dialog to further limit the search. A dialog with all matching occurrences is displayed.
- Select the product you were searching for and press Enter.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | AllProd | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | searchProduct | The API identifier used in GraphQL. |
| Table no. | 369 | The table number in the data model. |
The following fields exist in this table:
Alt. description
The alternative description for the product from the respective table.
| Product origin | Field from the table |
|---|---|
| 1 - Products | Blank |
| 2 - Products, EAN item no. | Blank |
| 3 - Barcodes | Blank |
| 4 - Alt. suppliers, Sup. item no. | Sup. descr. |
| 5 - Product customers, Cust. item no. | Inf. 1 |
| 6 - Alternative products | Description |
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Description | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AltDescr | The database field name. |
| API identifier | alternativeDescription | The API identifier used in GraphQL. |
| Number | 16138 |
Cust. no.
The customer from the Product customer table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cust. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustNo | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 16140 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
|
Description
The product description from the Product table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Description | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 16137 |
Line no.
The identifier of the correct product, if there are several records with the same Product no., from the respective table.
| Product origin | Field from the table |
|---|---|
| 1 - Products | 0 |
| 2 - Products, EAN item no. | 0 |
| 3 - Barcodes | 0 |
| 4 - Alt. suppliers, Sup. item no. | Line no. |
| 5 - Product customers, Cust. item no. | 0 |
| 6 - Alternative products | Line no. |
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 16143 |
Product no.
The product number is retrieved from the different tables, and the original product number will be used on the order line.
| 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., Product origin |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 16134 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
|
Product origin
The product origin of the record.
- 1 - Products
- 2 - Products, EAN item no.
- 3 - Barcodes
- 4 - Alt. suppliers, Sup. item no.
- 5 - Product customers, Cust. item no.
- 6 - Alternative products
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product origin | Integer |
| Primary key | Yes | Product no., Product origin |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Origin | The database field name. |
| API identifier | productOrigin | The API identifier used in GraphQL. |
| Number | 16136 |
Quantity per unit
The quantity per unit from the respective table.
| Product origin | Field from the table |
|---|---|
| 1 - Products | Quantity per unit |
| 2 - Products, EAN item no. | Quantity per unit |
| 3 - Barcodes | Quantity per unit |
| 4 - Alt. suppliers, Sup. item no. | Quantity per unit |
| 5 - Product customers, Cust. item no. | Quantity per unit |
| 6 - Alternative products | Blank |
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UnRt | The database field name. |
| API identifier | quantityPerUnit | The API identifier used in GraphQL. |
| Number | 16142 |
Search prod. no.
Alternative search entry for the Product no. field in the Order line table, from the respective table.
| Product origin | Field from the table |
|---|---|
| 1 - Products | Product no. |
| 2 - Products, EAN item no. | EAN item no. |
| 3 - Barcodes | Barcode |
| 4 - Alt. suppliers, Sup. item no. | Sup. no. |
| 5 - Product customers, Cust. item no. | Customer's product no. |
| 6 - Alternative products | Alternative product no. |
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrchProd | The database field name. |
| API identifier | searchProductNo | The API identifier used in GraphQL. |
| Number | 16135 |
Sup. no.
The supplier from the Delivery alternative table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Sup. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 16139 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Unit
The unit from the respective table.
| Product origin | Field from the table |
|---|---|
| 1 - Products | Default unit |
| 2 - Products, EAN item no. | Default unit |
| 3 - Barcodes | Unit |
| 4 - Alt. suppliers, Sup. item no. | Purch. unit |
| 5 - Product customers, Cust. item no. | Default unit |
| 6 - Alternative products | Blank |
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Unit | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 16141 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | Unit |
|
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. |