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.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL namePurcSThe table name in the database.
API identifierpurchaseSuggestionThe API identifier used in GraphQL.
Table no.166The 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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
SQL nameColDelThe database field name.
API identifiercollectiveDeliveryThe API identifier used in GraphQL.
Number5584 

Description

The description of the purchase estimate.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNameText (80)
SQL nameDescrThe database field name.
API identifierdescriptionThe API identifier used in GraphQL.
Number5582 

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
SQL nameKeepThe database field name.
API identifierkeepThe API identifier used in GraphQL.
Number5585 

Order type

The order type of the purchase estimate.

Note:
It is only possible to select the order types 1 - Normal order, 5 - Quotation/Inquiry and 6 - Unprocessed order, as the other types cannot be used for purchase or production orders.

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.

Note:
You must not change the transaction type and order type of an order that has been processed. This can mean that the order will not be processed or that stock is incorrect. If you change the order type from 1 - Normal order to 2 - Direct order, this can mean that cost prices and stock will not be correct after invoicing.

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.

A look-up in this field gives you the following list of possible values:
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:
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.
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.
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:
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.
You can use this order type when no order documents are used, e.g. in the event of adjustments.
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:
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.
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:
  • Invoice customer no.
  • Invoice reference
  • Masked card no.
  • Contract amount
  • Contract amount (dom.)
  • Currency no.
  • Card company
There is a separate tab in "Order status" for credit card orders, providing information about deviations and omissions for this order type.
Note:
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.
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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrder typeInteger
SQL nameOrdTpThe database field name.
API identifierorderTypeThe API identifier used in GraphQL.
Number5583 

Purchase order no.

A unique number identifying the purchase estimate.

Note:
If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Primary keyYesPurchase order no.
SQL namePurcSNoThe database field name.
API identifierpurchaseSuggestionNoThe API identifier used in GraphQL.
Number5075 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA 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. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA 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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA 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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 1. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.