Purchase estimate line
This table contains one row for each line on a purchase estimate.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | PurcSLn | The table name in the database. |
| API identifier | purchaseSuggestionLine | The API identifier used in GraphQL. |
| Table no. | 167 | The table number in the data model. |
The following fields exist in this table:
Del. alt. no.
The delivery alternative. The value is used to retrieve the supplier's product number and description when printing out inquiries and purchases.
The delivery alternative is set based on the highest priority for the product or a combination of product and supplier. The shortest lead time for a supplier or a combination of product and supplier is considered as the highest priority.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DelAltNo | The database field name. |
| API identifier | deliveryAlternativeNo | The API identifier used in GraphQL. |
| Number | 5087 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Delivery alternative | DeliveryAlternative |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Inf. 1
Additional purchase estimate line information.
The field can be included in the order line as additional information and also be printed on a order document.
| 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 | 6526 |
Inf. 2
Additional purchase estimate line information.
The field can be included in the order line as additional information and also be printed on a order document.
| 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 | 6527 |
Latest arrival date
The date on which the stock balance becomes lower than the minimum level or when it becomes negative.
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 | ArDt | The database field name. |
| API identifier | latestArrivalDate | The API identifier used in GraphQL. |
| Number | 5560 |
Latest arrival week
The week on which the stock balance becomes lower than the minimum level or when it becomes negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | latestArrivalWeek | The API identifier used in GraphQL. |
| Number | 5658 |
Latest delivery date
The latest delivery date of the product.
The value is calculated based on the Latest arrival date and Transport time fields. If the value in one of these fields is changed, the Latest delivery date field is recalculated.
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 | DelDt | The database field name. |
| API identifier | latestDeliveryDate | The API identifier used in GraphQL. |
| Number | 5090 |
Latest delivery week
The latest delivery week of the product.
The value is calculated based on the Latest arrival week and Transport time fields. If the value in one of these fields is changed, the Latest delivery week field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | latestDeliveryWeek | The API identifier used in GraphQL. |
| Number | 5659 |
Latest purchase date
The latest purchase date of the product.
The value is equal to the difference between the Latest delivery date and Lead time fields. If the value in one of these fields is changed, the Latest purchase date field is recalculated.
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 | PurcDt | The database field name. |
| API identifier | latestPurchaseDate | The API identifier used in GraphQL. |
| Number | 5089 |
Latest purchase week
The latest purchase week of the product.
The value is equal to the difference between the Latest delivery week and Lead time fields. If the value in one of these fields is changed, the Latest purchase week field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | latestPurchaseWeek | The API identifier used in GraphQL. |
| Number | 5660 |
Lead time
The number of days needed for the supplier to deliver the product.
For sales order lines, the original value in the field is suggested based on the value in the Stock balance table.
For purchase order lines, the original value in the field is suggested based on the value in the Delivery alternative table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | 5573 |
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 | Purchase order no., Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 5084 |
Overridden del. date
The overridden delivery date of the purchase estimate.
An entry in this field triggers the following update:
- Latest arrival date is set equal to Overridden del. date + Transport time
- Latest delivery date is set equal to Overridden del. date
- Latest purchase date is set equal to Overridden del. date - Lead time
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 | OvDelDt | The database field name. |
| API identifier | overriddenDeliveryDate | The API identifier used in GraphQL. |
| Number | 6587 |
Overridden del. week
The overridden delivery week of the purchase estimate.
The value is calculated based on the Overridden del. date field.
An entry in this field triggers the following update:
- Latest arrival week is set equal to Overridden del. week + Transport time
- Latest delivery week is set equal to Overridden del. week
- Latest purchase week is set equal to Overridden del. week - Lead time
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | overriddenDeliveryWeek | The API identifier used in GraphQL. |
| Number | 6592 |
Product no.
The product for the line.
| 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 | 5085 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
| ||
| Stock balance | StockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Delivery alternative | DeliveryAlternative |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Production
The purchase estimate line is included in a production order or a purchase order for a particular supplier.
The value is suggested from the Delivery alternative table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Prod | The database field name. |
| API identifier | production | The API identifier used in GraphQL. |
| Number | 5727 |
Production time
The time it takes to produce the product. This value is used in calculation of delivery dates.
For production order lines, the original value in the field is suggested based on the value in the Delivery alternative table.
| 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 | 11598 |
Purchase order no.
A unique number identifying the purchase estimate.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Purchase order no., Line no. |
| SQL name | PurcSNo | The database field name. |
| API identifier | purchaseSuggestionNo | The API identifier used in GraphQL. |
| Number | 5083 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Purchase estimate | PurchaseSuggestion |
|
Qty. before rounding
The quantity before rounding.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | NumBefR | The database field name. |
| API identifier | quantityBeforeRounding | The API identifier used in GraphQL. |
| Number | 6332 |
Quantity
The number of units for the product/service.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Num | The database field name. |
| API identifier | quantity | The API identifier used in GraphQL. |
| Number | 5091 |
Quantity per unit
The quantity per unit of the product.
Only used when the unit for a product differs from the product or supplier setting.
Different packaging sizes could be a reason to use this field. The value will be copied to the Order line table.
| 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 | 11955 |
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 | 5092 |
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 | 5088 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Transport time
The number of days it takes to transport the product from the supplier to your warehouse or directly to the customer.
This value is suggested from the Delivery alternative table.
| 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 | 5572 |
Unit
The unit for the product.
The default unit from the Delivery alternative table if it is entered, or the Default unit from the Product table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Unit | Integer |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 5515 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | Unit |
|
Warehouse no.
The warehouse from which the goods are collected or to which the goods are delivered.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| SQL name | StcNo | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 5086 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | Warehouse |
| ||
| Stock balance | StockBalance |
| 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.
| 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. |