Purchase estimate
This table contains one row for each purchase estimate. You can add rows using the Purchase estimate report in the Stock balance table.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | PurcS | The table name in the database. |
| API identifier | purchaseSuggestion | The API identifier used in GraphQL. |
| Table no. | 166 | The table number in the data model. |
The following fields exist in this table:
Collective delivery
There will be a collective delivery of the purchase.
TheDelivery date of the purchase is determined on the basis of the order line with the longest Lead time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | ColDel | The database field name. |
| API identifier | collectiveDelivery | The API identifier used in GraphQL. |
| Number | 5584 |
Description
The description of the purchase estimate.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 5582 |
Keep
The purchase estimate is not deleted when a purchase order is generated.
If this check box is not selected the purchase estimate will be deleted after you have generated a purchase order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Keep | The database field name. |
| API identifier | keep | The API identifier used in GraphQL. |
| Number | 5585 |
Order type
The order type of the purchase estimate.
You can change both transaction type and order type for an order which has already been entered. Business NXT will then reverse the processing of the old transaction or order type to the extent necessary in relation to the new one.
You can combine the transaction type with one of eight different order types:
Business NXT suggests order type 1 - Normal order in the Order type field in the Order head page element when entering sales orders, loan/hire orders and purchase orders. Orders generated from the Appointment table are also allocated this order type, although you can change this in the Company information table.
When you invoice direct and cash orders and save realised orders, Business NXT reserves everything you ask for, even if it is not available. If necessary, shipments are produced with negative availability.
- 1 - Normal order
- You use this for agreed or planned future goods out/goods received. You can part-deliver an order. You must finish a Normal order before you can realise it. Orders generated from the Appointment table are given this order type, but you can change this in the Company information table. This is the only order type for which you can print an order confirmation, pick list, packing slip and consignment note.
- 2 - Direct order
- You can use direct order if you want to enter the invoicing details
directly. You cannot print a pick list for this order type. Business NXT can reserve more than what is available when entering direct orders. Note:If you do not have enough products in stock for a "Direct order" that is to be invoiced, a separate shipment is created for the negative quantity.This applies even if you have not selected the Add shipments with negative availability field, which you can find under the Processing/Processing method/Warehouse menu item in the products or the order lines. You cannot part-deliver a direct order, as it is finished when the invoice is printed.
- 3 - Cash order
- A cash order is the same as a direct order, but the invoice printout
is launched when you save the order. When an invoice is printed for a cash order, the
current date is used as the order date when VAT is calculated. When you save a cash
order a dialog box appears containing payment information. This contains information
on the order amount and a field in which you can key in the amount received. You can
see the difference in the Outstanding field. The dialog box also contains a field in
which you enter the method of payment. The accounts are updated directly via a batch
per cash order. If you do not have enough products in stock for a "Cash order" that is
to be invoiced, a separate shipment is created for the negative quantity. Note:Credit note on cash order is allowed, if user has function access to "Allow credit note on cash order".
- 4 - Realised order
- This order type is realised when saved, i.e. stock and statistics are
updated immediately. Note:You can use this order type when no order documents are used, e.g. in the event of adjustments.We recommend that this order type is not used together with transaction type 1 - Sales, as you are not able to print out or transfer to accounts.
- 5 - Quotation/Inquiry
- You can print this order type as a quotation or inquiry, but no processing is involved. If the quotation is accepted you must change the order type to 1 - Normal order, 2 - Direct order or 3 - Cash order for the order to be processed.
- 6 - Unprocessed order
- This order type corresponds to the quotation order, although you cannot print it out as a quotation. The order does not generate any processing, and you must change it to another order type before you can process it. An unprocessed order is useful for imported orders. When the import is complete you can change the order type so that it can be processed.
- 7 - Advance order
- An advance order uses the same processing method as a normal order, although Business NXT does not check stock availability during order entry or whether the credit limit has been/will be exceeded.
- 8 - Budget order
- If you select this order type it means that the order lines will not be processed, in the same way as for Unprocessed orders.
- 9 - Credit card order
- Note:You cannot use order type 9 - Credit card order with manual entry. It must be imported via the EDI clock.Note:You cannot enter this order type manually. You must import it using the EDI clock. This order type is intended for Internet trading programs such as Zpider, and is dependent on Zpider being installed with communication to the card company. Upon invoicing, the reserved amount is activated at the card company, with the effect that the amount is transferred from the card company. If you delete or edit order type 9 - Credit card order, the reserved amount is cancelled at the card company. It is not possible to increase the amount of such an order over and above what is specified for Invoice customer no. in the Credit card reservation addition % field. A credit card order must be finished before it can be invoiced. Order type 9 - Credit card order also requires that the Invoice reference, Currency no., Contract amount and Invoice customer no. fields are filled in for the order. The following fields are locked for editing in a credit card order:If you change a credit card order to a different order type you cannot reset it to a credit card order, and the amount is cancelled at the card company.
- Invoice customer no.
- Invoice reference
- Masked card no.
- Contract amount
- Contract amount (dom.)
- Currency no.
- Card company
Note:It is not possible to edit such an order unless you have selected "Allow change to credit card order" for the access group under the processing "Function access/Misc.". An increase in the amount is not approved over and above the credit card reservation addition rate, even at this access level.When you copy such an order type, all you have to do is check the box for the credit note to show that it contains order type "9. Credit card order" and a credit is sent to the card company. A credit card order may only be credited once.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order type | Integer |
| SQL name | OrdTp | The database field name. |
| API identifier | orderType | The API identifier used in GraphQL. |
| Number | 5583 |
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. |
| SQL name | PurcSNo | The database field name. |
| API identifier | purchaseSuggestionNo | The API identifier used in GraphQL. |
| Number | 5075 |
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. |