Delivery alternative
This table is used when creating purchase estimates, purchase orders and generating orders.
Alternative suppliers are defined per product, in prioritised sequence. For each supplier you can, for example, define which product descriptions, terms of delivery and purchase units each supplier uses.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | DelAlt | The table name in the database. |
| API identifier | deliveryAlternative | The API identifier used in GraphQL. |
| Table no. | 115 | The table number in the data model. |
The following fields exist in this table:
Adm. time
The Adm. time for an Order.
The time which is required for internal approvals before goods can be delivered. It is used to calculate the Total lead time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Days | Integer |
| SQL name | AdmTm | The database field name. |
| API identifier | administrationTime | The API identifier used in GraphQL. |
| Number | 6328 |
Buyer
The Buyer of the Product.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | Buyer | The database field name. |
| API identifier | buyer | The API identifier used in GraphQL. |
| Number | 6121 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Buyer |
|
Cost price addition %
The percentage by which the net Purchase price after line discounts must increase to match the Cost price.
This is only applicable for purchase orders.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | DCstAdP | The database field name. |
| API identifier | costPriceAdditionPercent | The API identifier used in GraphQL. |
| Number | 15882 |
Customs
The Customs duty for the Product.
The Customs duty value can be used as an amount per Unit in default Currency or as a percentage.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount or percent | Decimal |
| SQL name | CusAm | The database field name. |
| API identifier | customs | The API identifier used in GraphQL. |
| Number | 2623 |
EAN item no.
The international article number assigned to the product.
An EAN/GTIN item number has either 8 or 13 digits. The 8-digit version is used for small packages. EAN/GTIN codes with 13 digits are unique all over the world, and the 2 or 3 first digits identify the country where the code was assigned.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EAN code | Text (40) |
| SQL name | EANItmNo | The database field name. |
| API identifier | eanItemNo | The API identifier used in GraphQL. |
| Number | 17972 |
Econ. purch. qty
The most profitable quantity for the Product.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | EcPurcQt | The database field name. |
| API identifier | economicPurchaseQuantity | The API identifier used in GraphQL. |
| Number | 2617 |
Free 1
Additional numeric information about the delivery alternative.
Can be used to see break-line totals on break lines or for any other information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 15922 |
Free 2
Additional numeric information about the delivery alternative.
Can be used to see break-line totals on break lines or for any other information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 15923 |
Free 3
Additional numeric information about the delivery alternative.
Can be used to see break-line totals on break lines or for any other information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 15924 |
Free 4
Additional numeric information about the delivery alternative.
Can be used to see break-line totals on break lines or for any other information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 15925 |
Freight 1
The freight amount of the Product. It can be used as an amount per unit in default Currency or as a percentage value.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | FrAm | The database field name. |
| API identifier | freight1 | The API identifier used in GraphQL. |
| Number | 2621 |
Freight 2
The freight amount of the Product. It can be used as an amount per unit in default Currency or as a percentage value.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | FrAm2 | The database field name. |
| API identifier | freight2 | The API identifier used in GraphQL. |
| Number | 4821 |
Freight 3
The freight amount of the Product. It can be used as an amount per unit in default Currency or as a percentage value.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | FrAm3 | The database field name. |
| API identifier | freight3 | The API identifier used in GraphQL. |
| Number | 4822 |
Freight 4
The freight amount of the Product. It can be used as an amount per unit in default Currency or as a percentage value.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | FrAm4 | The database field name. |
| API identifier | freight4 | The API identifier used in GraphQL. |
| Number | 4823 |
Freight processing
Which of the fields are using percentage values and which Customs duties are calculated based on freight.
Specify in %
- Freight 1
- Freight 2
- Freight 3
- Freight 4
- Customs
Calculate customs from
- Freight 1
- Freight 2
- Freight 3
- Freight 4
Additional cost distribution
- From order line
- Amount
- Net weight
- Gross weight
- Volume
- Quantity
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Freight processing | Integer |
| SQL name | FrCusPro | The database field name. |
| API identifier | freightProcessing | The API identifier used in GraphQL. |
| Number | 6465 |
Gr. 1
A group to which the delivery alternative belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Delivery alternative grouping 1 | Integer |
| SQL name | Gr | The database field name. |
| API identifier | group1 | The API identifier used in GraphQL. |
| Number | 15916 |
Gr. 2
A group to which the delivery alternative belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Delivery alternative grouping 2 | Integer |
| SQL name | Gr2 | The database field name. |
| API identifier | group2 | The API identifier used in GraphQL. |
| Number | 15917 |
Incm. doc. no.
The source of the most recent update from the supplier.
The value is set automatically when updating product data from Incoming product data. The field contains a lookup to the Incoming document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InDocNo | The database field name. |
| API identifier | incomingDocumentNo | The API identifier used in GraphQL. |
| Number | 18460 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Incoming document | IncomingDocument |
|
Inf. 1
Additional delivery alternative information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf | The database field name. |
| API identifier | information1 | The API identifier used in GraphQL. |
| Number | 15918 |
Inf. 2
Additional delivery alternative information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf2 | The database field name. |
| API identifier | information2 | The API identifier used in GraphQL. |
| Number | 15919 |
Inf. 3
Additional delivery alternative information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf3 | The database field name. |
| API identifier | information3 | The API identifier used in GraphQL. |
| Number | 15920 |
Inf. 4
Additional delivery alternative information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf4 | The database field name. |
| API identifier | information4 | The API identifier used in GraphQL. |
| Number | 15921 |
Lead time
The number of days the supplier needs to delivery the Product.
Suggested from the Associate table once the Sup. no. is entered. The value can be overridden if the Product deviates from the suggestion. It is used to calculate the Total lead time.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Days | Integer |
| SQL name | DelTm | The database field name. |
| API identifier | leadTime | The API identifier used in GraphQL. |
| Number | 2619 |
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., Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 2611 |
Memo file name
The file name for the Memo attached to Delivery alternative.
On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.
Double-click or press * to open the Select file dialog box to manually select a memo file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 12827 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo no. | Integer |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19234 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Order match processing
- Add order line automatically
If enabled, the purchase order line will be added automatically, it the item was previously white-listed in Delivery alternative table.
- Do not finish order line automatically
- If enabled, the user can have the option of checking the line before
finishing.
This parameter keeps the possibility of a control over the amounts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order match processing | Integer |
| SQL name | OrdMaProc | The database field name. |
| API identifier | orderMatchProcessing | The API identifier used in GraphQL. |
| Number | 18553 |
Production
Select this column if a production order has to be created instead of a purchase order.
When purchase and production orders are generated from a Purchase estimate or a sales order, this selection determines whether the Product is placed on a production order or a purchase order.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | PurcPrc | The database field name. |
| API identifier | production | The API identifier used in GraphQL. |
| Number | 2618 |
Production time
How long it takes to produce a Product.
Suggested from the Associate table once the Sup. no. is entered. The value can be overridden if the Product deviates from the suggestion. It is used to calculate theTotal lead time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Days | Integer |
| SQL name | ProdTm | The database field name. |
| API identifier | productionTime | The API identifier used in GraphQL. |
| Number | 11599 |
Product no.
The Product no. for the Delivery alternative.
| 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., Line no. |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 2610 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
Purch. unit
The Unit which is usually ordered for the Product from this supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Unit | Integer |
| SQL name | StPurcUn | The database field name. |
| API identifier | purchaseUnit | The API identifier used in GraphQL. |
| Number | 2615 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | Unit |
|
Quantity per unit
The Quantity per unit of the Unit used to specify the stock for the Product.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | StUnRt | The database field name. |
| API identifier | quantityPerUnit | The API identifier used in GraphQL. |
| Number | 11936 |
Recycling 1
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg1 | The database field name. |
| API identifier | recycling1 | The API identifier used in GraphQL. |
| Number | 6743 |
Recycling 2
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg2 | The database field name. |
| API identifier | recycling2 | The API identifier used in GraphQL. |
| Number | 6744 |
Recycling 3
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg3 | The database field name. |
| API identifier | recycling3 | The API identifier used in GraphQL. |
| Number | 6745 |
Recycling 4
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg4 | The database field name. |
| API identifier | recycling4 | The API identifier used in GraphQL. |
| Number | 6746 |
Recycling 5
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg5 | The database field name. |
| API identifier | recycling5 | The API identifier used in GraphQL. |
| Number | 6747 |
Recycling 6
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg6 | The database field name. |
| API identifier | recycling6 | The API identifier used in GraphQL. |
| Number | 6748 |
Recycling 7
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg7 | The database field name. |
| API identifier | recycling7 | The API identifier used in GraphQL. |
| Number | 6749 |
Recycling 8
The weight per purchase Unit for various types of material, such as metal, paper and plastic, for which the producer must calculate a recycling charge. This might be relevant in rows where you have selected the Production field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Reg8 | The database field name. |
| API identifier | recycling8 | The API identifier used in GraphQL. |
| Number | 6750 |
Responsible
The employee responsible for the supplier.
The employee who is responsible to keep the information in the Delivery alternative table up to date for this record.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | Rsp1 | The database field name. |
| API identifier | official1 | The API identifier used in GraphQL. |
| Number | 6123 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Official1 |
|
Responsible 2
The employee responsible for the supplier.
The employee who is responsible to keep the information in the Delivery alternative table up to date for this record.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | Rsp2 | The database field name. |
| API identifier | official2 | The API identifier used in GraphQL. |
| Number | 6124 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Official2 |
|
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 | 2624 |
Source country
The Country of origin for the Product. This is required when reporting to EU countries.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Country no. | Integer |
| SQL name | SrcCtry | The database field name. |
| API identifier | sourceCountryNo | The API identifier used in GraphQL. |
| Number | 4499 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | SourceCountry |
|
Sup. descr.
The Sup. descr. of the Product if it deviates from what is set in the Product table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 60 | Text (60) |
| SQL name | SupDescr | The database field name. |
| API identifier | supplierDescription | The API identifier used in GraphQL. |
| Number | 2614 |
Sup. no.
The supplier of the Product.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 2612 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Sup. prod. no.
The Sup. prod. no. if it is different from the value in the Product 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 | SupProd | The database field name. |
| API identifier | supplierProductNo | The API identifier used in GraphQL. |
| Number | 2613 |
Supplier's price
The Supplier's price for the Product.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | SupPrice | The database field name. |
| API identifier | suppliersPrice | The API identifier used in GraphQL. |
| Number | 6509 |
Supplier's stock balance
The Supplier's stock balance for the Product.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | SupStock | The database field name. |
| API identifier | suppliersStockBalance | The API identifier used in GraphQL. |
| Number | 6508 |
Total lead time
The Total lead time for the Order.
The Total lead time is the sum of Adm. time and Lead time and Transport time and Production time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Days | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | totalLeadTime | The API identifier used in GraphQL. |
| Number | 6327 |
Transport time
The number of days it takes to transport the Product from the supplier to your Warehouse or directly to the customer.
Suggested from the Associate table once the Sup. no. is entered. The value can be overridden if the Product deviates from the suggestion. It is used to calculate theTotal lead time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Days | Integer |
| SQL name | TanspTm | The database field name. |
| API identifier | transportTime | The API identifier used in GraphQL. |
| Number | 5049 |
Web page
The address of a web page for Delivery alternative.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | IntAd | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 6600 |
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. |