Order document
This table contains one row for each archived order document.
Which types of documents to archive is determined in the Document copies field in the Company information table.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | OrdDoc | The table name in the database. |
| API identifier | orderDocument | The API identifier used in GraphQL. |
| Table no. | 335 | The table number in the data model. |
The following fields exist in this table:
Account set
Used together with VAT and accounting group field to get the correct VAT- and accounting information on orders.
In the VAT- and accounting information table you can connect an Account set with correct general ledger accounts for a VAT and accounting group.
The Account set can then be set on the Account set cust. and/or Account set sup. fields in the Associate table.
The VAT and accounting group and the Account set fields in the Order line table define the tax processing. The fields are suggested on what is entered for the customer or supplier and is used when no other account set is specified on an order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account set | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcSet | The database field name. |
| API identifier | accountSet | The API identifier used in GraphQL. |
| Number | 13167 |
Address line 1
The address of the customer or supplier.
Updated with the corresponding values from the Associate table when you enter the Cust. no./Sup. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad1 | The database field name. |
| API identifier | addressLine1 | The API identifier used in GraphQL. |
| Number | 13107 |
Address line 2
The address of the customer or supplier.
Updated with the corresponding values from the Associate table when you enter the Cust. no./Sup. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad2 | The database field name. |
| API identifier | addressLine2 | The API identifier used in GraphQL. |
| Number | 13108 |
Address line 3
The address of the customer or supplier.
Updated with the corresponding values from the Associate table when you enter the Cust. no./Sup. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad3 | The database field name. |
| API identifier | addressLine3 | The API identifier used in GraphQL. |
| Number | 13109 |
Address line 4
The address of the customer or supplier.
Updated with the corresponding values from the Associate table when you enter the Cust. no./Sup. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad4 | The database field name. |
| API identifier | addressLine4 | The API identifier used in GraphQL. |
| Number | 13110 |
Area
The total of the corresponding fields in the order line.
You can print the value in order documents using the @Order macro. The field is related to the remaining quantities in the orders.
You can also print the values in the order lines for group discounts, group totals, structure heads and order totals by checking the Weight/dimensions on break lines box in the order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Area | The database field name. |
| API identifier | area | The API identifier used in GraphQL. |
| Number | 13289 |
Arrival/departure date
Enter the date when the products arrive at the warehouse in purchase and production orders, or when the product leaves the warehouse in sales and consumed goods orders.
You must complete the field manually. The date is not suggested down on order lines, as it is calculated for each order line.
The date is validated using the regional settings in Windows.
| 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 | ArDt | The database field name. |
| API identifier | arrivalOrDepartureDate | The API identifier used in GraphQL. |
| Number | 13273 |
Arrival/departure week
The week when the products arrive at the warehouse in purchase and production orders, or when the product leaves the warehouse in sales and consumed goods orders.
Filled in when you enter a value in the Arrival/departure date field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | arrivalOrDepartureWeek | The API identifier used in GraphQL. |
| Number | 13272 |
AutoInvoice document ID
A unique identifier that is returned from Visma AutoInvoice, on successfully transferred documents.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | GUID | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MavInvId | The database field name. |
| API identifier | autoInvoiceInvoiceID | The API identifier used in GraphQL. |
| Number | 16483 |
AutoInvoice status
The status for Visma AutoInvoice documents.
- 0 - Not set
- The document was printed without AutoInvoice as
document delivery method, or the document delivery method was disregarded by using a
different print method (Override to printer,
Quick print, Print to PDF,
Send e-mail, Design Excel template, Print to Excel,
Print to clipboard,
Print to file or
Only approval). The
document is ready to be sent to Visma.net AutoInvoice, unless it has been printed using an XML print form or the Document delivery method
= EDI is set.Note:The document type 3 - Packing slips is always created with AutoInvoice status = 0 - Not set because of the way the document is processed.
- 1 - Transferred
- The document has been delivered to Visma.net AutoInvoice. This status does not indicate what has happened after Visma.net AutoInvoice received the document. No further processing possible.
- 2 - Pending
- The document is ready to be sent, but has not yet been processed. This status should only appear if the Document copies option Only approval - print later from document archive has been selected.
- 3 - Failed transfer
- An error occurred while sending to Visma.net AutoInvoice. See the EDI error message table for more details. This status could indicate problems logging in to Visma.net AutoInvoice, communication with Visma.net AutoInvoice (firewall etc.) or issues with creating the XML data (corrupt data etc.).
- 4 - Cannot transfer
- Status set when running the Set AutoInvoice status Cannot transfer processing. This status disables sending the document to Visma.net AutoInvoice. The processing is available for documents that have a status other than 1 - Transferred and 4 - Cannot transfer.
- 5 - Validation failed
- This status is only in use if the System information processing setting Test content is selected. This setting is only available if AutoInvoice test is selected. The status indicates that the XML content includes validation errors, according to the PEPPOL BIS format rules. Detailed error message(s) can be found in the AutoInvoice validation error table.
- 6 - Preparing to send
- 7 - Sent from AutoInvoice
- 8 - Unsuccessful delivery
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | AutoInvoice status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MavStat | The database field name. |
| API identifier | autoInvoiceStatus | The API identifier used in GraphQL. |
| Number | 16455 |
Cap. asset no.
Copied together with the Capital asset proc. field to the Product transaction table. Both values are required for the Activate capital asset processing.
If you take out goods from stock to be used as capital assets in the internal business, you can make an order with transaction type 4 - Adjustment/internal issue and enter the capital asset no and capital asset processing = 1 on the order line and realize the order. From the product transaction established, you can then run the Activate capital asset processing, that will create a batch and voucher for the capital asset activation.
You can also perform purchase orders to transfer directly as a capital asset without the goods entering the warehouse. For purchases the order line is set to Not cost transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 13349 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAsset |
|
Capital asset proc.
Copied together with the Cap. asset no. field to the Product transaction table. Both values are required for the Activate capital asset processing.
You can remove capital assets from the warehouse via the order module and have it posted as acquisition of the selected capital asset.
To ensure that the accounting is correct you should set up a separate account set for this routine in which it is only necessary to enter debit/credit further processing. The account can be directly from the warehouse or another account that is different from further processing for sold goods.
In the order line, unhide the Capital asset proc. and Cap. asset no. fields and enter the processing and the capital asset. It is possible to enter new capital asset when you look up in the field.
- 1 - Acquisition
- To be used on records concerning the main acquisition of capital assets. E.g. cars, or buildings.
- 2 - Addition
- To be used on records concerning additions. The definition of an "addition" is e.g. winter tyres for a car or marquises on a building. Additions can be given a lifetime, that differs from the main acquisition.
- 3 - Revaluation
- To be used on records meant to adjust the total value of a capital
asset. An example when a revaluation can be performed is when a very old real estate
has a much higher market value, than the book value.Note:Revaluation shall NOT be performed when a capital asset has a lower value than expected due to under-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.Note:Revaluation of capital assets is in most countries surrounded by legal restrictions and shall be performed only after accurate consideration.
- 4 - Devaluation
- To be used on records meant to adjust the total value of a capital
asset. An example when a devaluation can be performed is when the value of a real
estate falls under the book value due to a financial crisis or another extraordinary
occurrence.Note:Devaluation shall NOT be performed when a capital asset has a higher value than expected due to over-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.Note:Devaluation of capital assets might be surrounded by legal restrictions in your country and shall be performed only after accurate consideration.
- 5 - Sale
- To be used on records concerning sales of capital assets.
- 6 - Discarded
- To be used on records concerning discard of capital assets.
- 7 - (Not in use)
- Not in use.
- 8 - Back transfer
- Resets depreciation when capital assets are sold or discarded.
- 9 - Depreciation on investment
- 10 - Depreciation on addition
- 11 - Depreciation on revaluation
- 12 - Depreciation on devaluation
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset proc. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PropPrc | The database field name. |
| API identifier | capitalAssetProcessing | The API identifier used in GraphQL. |
| Number | 13348 |
CID code
The CID code (customer identification code) for the order.
Updated on invoicing of orders from the printout calculation. The calculation is only performed for orders that come from the invoice printout. On the invoice you can for example display the field on the bank giro part. The value is also transferred to the voucher line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | CID code | Text (30) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CID | The database field name. |
| API identifier | cid | The API identifier used in GraphQL. |
| Number | 13352 |
Confirm. count
How many times the order has been confirmed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CfCnt | The database field name. |
| API identifier | confirmationCount | The API identifier used in GraphQL. |
| Number | 13264 |
Confirmed delivery date
The date when the ordered products are ready to be sent from our supplier to us or the date when our products or services are ready to be delivered to our customers. The meaning of the field and the calculation of the date depends on the transaction type.
The Generate order processing updates the confirmed delivery date in the Order table with the value from the From date field.
Interest lineThe Transfer interest to order processing sets the confirmed delivery date always to the current date.
Purchase ordersNewly entered purchase orders don't get any date set in the Confirmed delivery date field. The Confirmed processing is updating the Confirmed delivery date field with the date set in the processing dialog box.
Sales ordersThe Confirmed delivery date is updated with the value in the Required delivery date field. This automatic update can be turned off in the Company information table. If you select Do not enter confirmed delivery date when entering data in the Calculate delivery date field then you don't get any value set in the in the Confirmed delivery date field.
The date is validated using the regional settings in Windows.
| 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 | CfDelDt | The database field name. |
| API identifier | confirmedDeliveryDate | The API identifier used in GraphQL. |
| Number | 13187 |
Confirmed delivery week
The Confirmed delivery date field as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | confirmedDeliveryWeek | The API identifier used in GraphQL. |
| Number | 13188 |
Cons. note count
How many times Consignment notes have been printed for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ConCnt | The database field name. |
| API identifier | consignmentNoteCount | The API identifier used in GraphQL. |
| Number | 13267 |
Consignment no.
The consignment no. linked to a delivery, for example the AVB number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Consignment no. | Text (18) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ConsNo | The database field name. |
| API identifier | consignmentNo | The API identifier used in GraphQL. |
| Number | 13182 |
Consignment note no.
The last document number of the Consignment notes printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | ConNo | The database field name. |
| API identifier | consignmentNoteNo | The API identifier used in GraphQL. |
| Number | 13302 |
Contact
A contact person for the order.
The field contains a reference to an Associate no. in the Associate table, representing the contact person. The associate may be selected by manually entering a value or doing a lookup. If a Cust. no. or a Sup. no. has already been set on the order, the lookup will only display contacts relevant for this customer or supplier. If not set, the lookup will open a view of the Associate table.
Double-click to open the dialog:
The Contact tab contans a list with all associates defined for the receiver on the order (that is, field Contact for = Associate no. of the customer). Here you can search for and select contacts.
The Associate tab contains all associates. Here you can search for and select contacts that are not defined for the receiver.
If you type the name or beginning of the name directly into the Contact field, then the system will first search and present a list with all associates defined for the receiver on the order. If no posts are found, the search is expanded, and a list from all associates (regardless of the Contact for setting) will be presented.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LiaActNo | The database field name. |
| API identifier | contact1 | The API identifier used in GraphQL. |
| Number | 13313 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Contact1 |
|
Contact 2
A contact person for the order.
The field contains a reference to an Associate no. in the Associate table, representing the contact person. The associate may be selected by manually entering a value or doing a lookup. If a Cust. no. or a Sup. no. has already been set on the order, the lookup will only display contacts relevant for this customer or supplier. If not set, the lookup will open a view of the Associate table.
Double-click to open the dialog:
The Contact tab contans a list with all associates defined for the receiver on the order (that is, field Contact for = Associate no. of the customer). Here you can search for and select contacts.
The Associate tab contains all associates. Here you can search for and select contacts that are not defined for the receiver.
If you type the name or beginning of the name directly into the Contact field, then the system will first search and present a list with all associates defined for the receiver on the order. If no posts are found, the search is expanded, and a list from all associates (regardless of the Contact for setting) will be presented.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LiaAct2 | The database field name. |
| API identifier | contact2 | The API identifier used in GraphQL. |
| Number | 13351 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Contact2 |
|
Contract amount
A total on which you have agreed for the order in the current currency.
In the order lines you can invoice parts of this amount via the Share field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CtrAm | The database field name. |
| API identifier | contractAmountInCurrency | The API identifier used in GraphQL. |
| Number | 13165 |
Contract amount (dom.)
The Contract amount field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DCtrAm | The database field name. |
| API identifier | contractAmountDomestic | The API identifier used in GraphQL. |
| Number | 13275 |
Contract amount in EURO
The Contract amount field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Contract amount | Euro |
| 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 | contractAmountInEuro | The API identifier used in GraphQL. |
| Number | 13166 |
Cost currency no.
The currency which is used for the cost on a purchase order. It is suggested when the Payment supplier no. field gets updated with a supplier no.
The cost is displayed in default currency. However cost prices can be displayed in currency of the payment supplier, if you select the option Cost prices in currency in the order processing field in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstCur | The database field name. |
| API identifier | costCurrencyNo | The API identifier used in GraphQL. |
| Number | 13249 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | CostCurrency |
|
Cost exchange rate
Cost exchange rate equal to the relevant Sales rate in the Currency table.
You can override this field in Order line and Reservation tables. You can make a reload of the Exchange rate when invoicing by selecting the Justify exchange rate box in the Customer options/Order options dialog box. When the Cost currency no. is changed Inc. cost in the cost currency are updated when saved.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstExRt | The database field name. |
| API identifier | costExchangeRate | The API identifier used in GraphQL. |
| Number | 13250 |
Country no.
Refers to the individual country settings used during invoicing, e.g. Invoice fee limit, Invoice fee and Invoice fee VAT code.
The value is retrieved from the corresponding field in the Associate table. If you have not filled in this field, the default Country no. and Language no. are retrieved from the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 13113 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
Credit note
Selected if you have selected the Credit note check box in the dialog for the Order options field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M17 | The database field name. |
| API identifier | creditNote | The API identifier used in GraphQL. |
| Number | 13283 |
Currency no.
The currency according to the selected customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 13195 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Cust. no.
The customer number for sale, hire and loan orders.
You can enter a customer by opening or searching among the customers in the Associate table. You can also override the Cust. no. in the order lines.
| 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 | 13105 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
|
Cust/Suppl. order no.
You can use this field to store the customer's own order number or your order number with the supplier for a purchase order.
This field is also used for this purpose if you use EDI.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CSOrdNo | The database field name. |
| API identifier | customerOrSupplierOrderNo | The API identifier used in GraphQL. |
| Number | 13291 |
Customer price gr. 1
The price group of the selected customer.
Price groups are suggested from the corresponding fields in the Associate table and Price- and discount matrix table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Customer price group 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustPrGr | The database field name. |
| API identifier | customerPriceGroup1 | The API identifier used in GraphQL. |
| Number | 13139 |
Customer price gr. 2
The price group of the selected customer.
Price groups are suggested from the corresponding fields in the Associate table and Price- and discount matrix table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Customer price group 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustPrG2 | The database field name. |
| API identifier | customerPriceGroup2 | The API identifier used in GraphQL. |
| Number | 13276 |
Customer price gr. 3
The price group of the selected customer.
Price groups are suggested from the corresponding fields in the Associate table and Price- and discount matrix table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Customer price group 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustPrG3 | The database field name. |
| API identifier | customerPriceGroup3 | The API identifier used in GraphQL. |
| Number | 13337 |
Customs
Customs costs in currency or as a % on the basis of what is selected in the Freight processing field.
In purchase orders the Customs field in the order lines are aggregated to the order, whereas in sales orders you must enter the costs in the default currency in the order and the amount is included in the order total.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount or percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PstAm | The database field name. |
| API identifier | customs | The API identifier used in GraphQL. |
| Number | 13184 |
Deduct client resp./Bank
Withdrawal from client responsibility.
- Withdrawal from client bank account
- Post to client bank account
- Use client responsibility 2
- Use client responsibility 3
- 1 - Deduct client responsibility 1/bank and post it
- 2 - Deduct client responsibility 2/bank and post it
- 3 - Deduct client responsibility 3/bank and post it
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Deduct client resp./Bank | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M16 | The database field name. |
| API identifier | deductClientResponsibilityBank | The API identifier used in GraphQL. |
| Number | 13282 |
Delivery address 1
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelAd1 | The database field name. |
| API identifier | deliveryAddress1 | The API identifier used in GraphQL. |
| Number | 13170 |
Delivery address 2
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelAd2 | The database field name. |
| API identifier | deliveryAddress2 | The API identifier used in GraphQL. |
| Number | 13171 |
Delivery address 3
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelAd3 | The database field name. |
| API identifier | deliveryAddress3 | The API identifier used in GraphQL. |
| Number | 13172 |
Delivery address 4
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelAd4 | The database field name. |
| API identifier | deliveryAddress4 | The API identifier used in GraphQL. |
| Number | 13173 |
Delivery associate no.
Suggested on the basis of what is in the Send to associate no. field for the customer or supplier.
You can override this field in the order lines.
You can use this field for purchases if you want the products to be delivered to a different address from the one specified in the Company information table.
You can perform lookups in this field using the following keys:
- Shift + * - With this lookup you limit the lookup to those associates that have reference to the customer/supplier for the order.
- Ctrl + * - This lookup finds all associates.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelActNo | The database field name. |
| API identifier | deliveryAssociateNo | The API identifier used in GraphQL. |
| Number | 13168 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | DeliveryAssociate |
|
Delivery country no.
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelCtry | The database field name. |
| API identifier | deliveryCountryNo | The API identifier used in GraphQL. |
| Number | 13176 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | DeliveryCountry |
|
Delivery language no.
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Language no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelLang | The database field name. |
| API identifier | deliveryLanguageNo | The API identifier used in GraphQL. |
| Number | 13177 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Language | DeliveryLanguage |
|
Delivery method
Is printed in order documents. Examples of delivery methods are road, rail and air.
The Delivery method field is suggested on the basis of:
- the recipient for sale/hire/loan orders
- the supplier or the recipient for purchases
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Delivery method | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelMt | The database field name. |
| API identifier | deliveryMethod | The API identifier used in GraphQL. |
| Number | 13181 |
Delivery name
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelNm | The database field name. |
| API identifier | deliveryName | The API identifier used in GraphQL. |
| Number | 13169 |
Delivery post code
Filled in when you enter the Delivery associate no.
If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Post code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelPNo | The database field name. |
| API identifier | deliveryPostCode | The API identifier used in GraphQL. |
| Number | 13174 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Postal address | DeliveryPostalAddress |
|
Delivery postal area
Filled in when you enter the Delivery associate no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelPArea | The database field name. |
| API identifier | deliveryPostalArea | The API identifier used in GraphQL. |
| Number | 13175 |
Delivery priority
The priority of the order.
This field is suggested by the recipient. When you print Pick lists you can choose to sort by this field. Valid values for the Delivery priority field can be defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Delivery priority | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelPri | The database field name. |
| API identifier | deliveryPriority | The API identifier used in GraphQL. |
| Number | 13218 |
Delivery terms
Is printed in order documents.
Examples of delivery terms are FOB and CIF. The delivery terms are suggested on the basis of what you have entered for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Delivery terms | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelTrm | The database field name. |
| API identifier | deliveryTerms | The API identifier used in GraphQL. |
| Number | 13180 |
Delivery visit post code
Retrieves the value from the Associate table when you enter the Delivery associate no. or Cust. no. in a sales order.
You can override this value.
If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Post code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelVisPN | The database field name. |
| API identifier | deliveryVisitPostCode | The API identifier used in GraphQL. |
| Number | 14523 |
Delivery visit postal area
Retrieves the value from the Associate table when you enter the Delivery associate no. or Cust. no. in a sales order.
You can override this value.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelVisPA | The database field name. |
| API identifier | deliveryVisitPostalArea | The API identifier used in GraphQL. |
| Number | 14524 |
Des. prod. start date
The desired production start date.
If the Des. prod. start date field in the Order table is specified, you cannot run the Calculate production start / costs processing.
The date is validated using the regional settings in Windows.
| 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 | DesProDt | The database field name. |
| API identifier | desiredProductionStartDate | The API identifier used in GraphQL. |
| Number | 13353 |
Deviate prod. no.
For fixed-price invoicing you can choose to keep statistics of the difference between revenue in the invoice plan lines and the invoiceable amounts in the other order lines.
This is done on the basis of the entered consumption of goods and services for a product for over/under-invoicing that you define in the order. The value in this field is suggested on the basis of what you have entered in the Fixed price deviate prod. field in the Company information table.
The transaction is assigned the person and units responsible from the Order and a description from the Product table, and is in addition to transactions for revenue and costs from the standard order lines. If you do not use the order's Deviate prod. no., the revenue and costs from the invoice plan lines will be entered directly in statistics.
You can also use this field when overriding invoiceable amounts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DifProd | The database field name. |
| API identifier | deviateProductNo | The API identifier used in GraphQL. |
| Number | 13274 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | DeviateProduct |
| ||
| Search product | DeviateSearchProduct |
|
Doc. date
The document date.
Originates from the Date field in the Print dialog box to the actual order document report.
Corresponds to the @DocDate macro function on the form.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocDt | The database field name. |
| API identifier | documentDate | The API identifier used in GraphQL. |
| Number | 13096 |
Doc. delivery status
The delivery status of the document.
This field will get the status 1 - Ready for delivery when the invoice has been approved. When the invoice has been sent it will change to 2 - Delivered. The statuses are relevant for use when enabling the option Only approval - print later from document archive in the Document copies field in the Company information table.
- 1 - Ready for delivery
- 2 - Delivered
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. delivery status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocDelSt | The database field name. |
| API identifier | documentDeliveryStatus | The API identifier used in GraphQL. |
| Number | 17705 |
Doc. type
The type of order document.
- 1 - Invoices/credit notes
- 2 - Consignment notes
- You can print batch consignment notes to avoid more expensive freight
charges, as many hauliers charge for each consignment note. If you sort with breaks in
the order head when printing consignment notes, one consignment note is printed for
each break.
You can, for example, sort with breaks by Delivery associate number and possibly Delivery method and Delivery terms.
- 3 - Packing slips
- 4 - Pick lists
- 5 - Order confirmations
- 6 - Quotations
- 7 - Purchase orders
- 8 - Inquiries
- 9 - Production orders
- 10 - Product catalogue
- 11 - Purchase request
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Doc. type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocTp | The database field name. |
| API identifier | documentType | The API identifier used in GraphQL. |
| Number | 13095 |
Document delivery method 1
Defines how you are to send documents.
Suggested on the basis of what you entered in the Associate table for the customer/supplier.
If you have selected the Batch invoice field under Customer options in the Associate table or under Order options in the Order table, you cannot select the EDI field for the Order/Invoice documents.
Order documents
The dialog box contains boxes for each of the relevant document types, that you can check to define required delivery methods. You can send the same document in several different ways by selecting several delivery methods. No documents are sent unless you select at least one of the delivery methods. There is a block against removing all selections in invoices; at least one of the delivery methods must be selected. Print previews of the documents works regardless of which delivery methods have been selected.
Accounting documents
You can send interest notes and reminders as fax and e-mail attachments in the same way as the order documents.
- Printout
- Printout (print to PDF) is the default value for all documents, so you only need to go into the dialog box if you want a different delivery method for any of the documents. You can define default values for this field via the Edit/Entry rules menu item. If the delivery method field is empty, Printout is still selected for all documents in the dialog box.
- You can send all order documents via e-mail. A valid e-mail address needs to
be entered for the associate. There is no validation in place on value in the
e-mail address field.
The name added to the Subject field of the e-mail is taken from the Text table, in the language in which the order/accounting document is entered. Otherwise, the text is obtained from the active language.
- EDI
- The EDI options are not available for delivery notes and production
orders.
EDI documents will only work if you also define the relevant document type in EDI messages.
- AutoInvoice
- AutoInvoice documents will only work if you have set up Visma AutoInvoice in the Visma AutoInvoice portal and in Business NXT.
In addition to the document types with the associated delivery methods described above, there are some additional settings.
EDI Settings
Media type
- E-media
Postage type
- 1. class mail
- 2. class mail
____
- Stop before sending e-mail
- Used to prevent immediate transmission by e-mail. This means you can edit the e-mail before it is sent to the contact.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document delivery method 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocSMt | The database field name. |
| API identifier | documentDeliveryMethod1 | The API identifier used in GraphQL. |
| Number | 13320 |
Document delivery method 2
Defines how you are to send documents.
Suggested on the basis of what you entered in the Associate table for the customer/supplier.
If you have selected the Batch invoice field under Customer options in the Associate table or under Order options in the Order table, you cannot select the EDI field for the Order/Invoice documents.
Order documents
The dialog box contains boxes for each of the relevant document types, that you can check to define required delivery methods. You can send the same document in several different ways by selecting several delivery methods. No documents are sent unless you select at least one of the delivery methods. There is a block against removing all selections in invoices; at least one of the delivery methods must be selected. Print previews of the documents works regardless of which delivery methods have been selected.
Accounting documents
You can send interest notes and reminders as fax and e-mail attachments in the same way as the order documents.
- Printout
- Printout (print to PDF) is the default value for all documents, so you only need to go into the dialog box if you want a different delivery method for any of the documents. You can define default values for this field via the Edit/Entry rules menu item. If the delivery method field is empty, Printout is still selected for all documents in the dialog box.
- You can send all order documents via e-mail. A valid e-mail address needs to
be entered for the associate. There is no validation in place on value in the
e-mail address field.
The name added to the Subject field of the e-mail is taken from the Text table, in the language in which the order/accounting document is entered. Otherwise, the text is obtained from the active language.
- EDI
- The EDI options are not available for delivery notes and production
orders.
EDI documents will only work if you also define the relevant document type in EDI messages.
- AutoInvoice
- AutoInvoice documents will only work if you have set up Visma AutoInvoice in the Visma AutoInvoice portal and in Business NXT.
In addition to the document types with the associated delivery methods described above, there are some additional settings.
EDI Settings
Media type
- E-media
Postage type
- 1. class mail
- 2. class mail
____
- Stop before sending e-mail
- Used to prevent immediate transmission by e-mail. This means you can edit the e-mail before it is sent to the contact.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document delivery method 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocSMt2 | The database field name. |
| API identifier | documentDeliveryMethod2 | The API identifier used in GraphQL. |
| Number | 13350 |
Due date
The due date for the order document.
The due date is calculated on the basis of Payment terms and Invoice date fields. You can also let it be calculated on the basis of the order's Finish date instead of the Invoice date. You activate this by selecting the Due date based on finishing option in the Accounting processing field in the Company information table.
The date is validated using the regional settings in Windows.
| 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 | DueDt | The database field name. |
| API identifier | dueDate | The API identifier used in GraphQL. |
| Number | 13198 |
Due week
The Due date as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | dueWeek | The API identifier used in GraphQL. |
| Number | 13199 |
EDI status
The status of EDI.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | EDISt | The database field name. |
| API identifier | ediStatus | The API identifier used in GraphQL. |
| Number | 13309 |
Empl. no.
Who is performing the task.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EmpNo | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 13219 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
Employee price gr.
Used to refer to the Price- and discount matrix table, and is suggested on the basis of what is entered for an employee.
Valid values for Employee price gr. can be defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Employee price group | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EmpPrGr | The database field name. |
| API identifier | employeePriceGroup | The API identifier used in GraphQL. |
| Number | 13220 |
Exchange price
In use for companies where customers finance purchases by means of exchanging a product or raw materials.
This field is suggested from the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExPr | The database field name. |
| API identifier | exchangePrice | The API identifier used in GraphQL. |
| Number | 13214 |
Exchange rate
Filled in with the prevailing exchange rate from the Currency table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 13196 |
Exclude proc./outp.
Stores the values selected in the dialog box for the Processing/Order status menu item.
- Invoices/credit notes
- Consignment notes
- Packing slips
- Returning
- Finishing
- Pick lists
- Order confirmations
- Acceptance
- Quotations
- Prepayment
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Purchase orders
- Inquiries
- Production orders
- Cancelling
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exclude proc./outp. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExOrdPrc | The database field name. |
| API identifier | excludeProcessingOrOutput | The API identifier used in GraphQL. |
| Number | 13204 |
Exempt from sp. tax
In this field you can exempt the order from special tax.
If you have not already entered this for the customer/supplier, you can enter the following values in this field:
- 1 - No special tax
- 2 - Only specification on invoice
- 1 - No special tax
- No special tax
- 2 - Only specification on invoice
- Only specification on invoice
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exempt from sp. tax | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExSpc | The database field name. |
| API identifier | exemptFromSpecialTax | The API identifier used in GraphQL. |
| Number | 13146 |
Expected return date
When you can expect products to be returned after a hire/loan.
The date is validated using the regional settings in Windows.
| 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 | ERetDt | The database field name. |
| API identifier | expectedReturnDate | The API identifier used in GraphQL. |
| Number | 13257 |
Expected return week
The Expected return date as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | expectedReturnWeek | The API identifier used in GraphQL. |
| Number | 13258 |
Fact. company no./CID-def.
If the order is to go via factoring, the field displays the number of the factoring company or CID code definition.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Factoring no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FCNo | The database field name. |
| API identifier | factoringCompanyNo | The API identifier used in GraphQL. |
| Number | 13354 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Factoring company | FactoringCompany |
|
Factoring no.
The factoring number if the order is to go via factoring.
The field is filled in with the Factoring no. that you have entered for the customer/supplier.
If you want to print invoices/credit notes that are to go via factoring, you check the Factoring box in the Order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FactNo | The database field name. |
| API identifier | factoringNo | The API identifier used in GraphQL. |
| Number | 13202 |
File no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | File no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FileNo | The database field name. |
| API identifier | fileNo | The API identifier used in GraphQL. |
| Number | 18555 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| File archive | FileArchive |
|
Finish date
The date when the order was last finished.
The date is validated using the regional settings in Windows.
| 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 | FinDt | The database field name. |
| API identifier | finishDate | The API identifier used in GraphQL. |
| Number | 13323 |
Finish week
The Finish date field expressed as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | finishWeek | The API identifier used in GraphQL. |
| Number | 13324 |
Finished by
The name of person who last finished anything in the order.
| 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 | FinBy | The database field name. |
| API identifier | finishedBy | The API identifier used in GraphQL. |
| Number | 13292 |
Finished weight
The total finished weight for the consignment.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | FinWgt | The database field name. |
| API identifier | finishedWeight | The API identifier used in GraphQL. |
| Number | 13340 |
Form no.
The form used to locate information on the sheets.
Originates from the Form drop-down list in the Print dialog box to the actual order document report.
Refers together with form type 6 - Order document to the Form table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Form no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FormNo | The database field name. |
| API identifier | formNo | The API identifier used in GraphQL. |
| Number | 13097 |
Free 1
Additional numeric information about the order.
The columns contain break-line totals for break total lines. In batch invoices the total displayed is the total of the values of orders included.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 13331 |
Free 2
Additional numeric information about the order.
The columns contain break-line totals for break total lines. In batch invoices the total displayed is the total of the values of orders included.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 13332 |
Free 3
Additional numeric information about the order.
The columns contain break-line totals for break total lines. In batch invoices the total displayed is the total of the values of orders included.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 13333 |
Free 4
Additional numeric information about the order.
The columns contain break-line totals for break total lines. In batch invoices the total displayed is the total of the values of orders included.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 13334 |
Freight 1
Four fields for entering freight costs in domestic currency.
You can find a more detailed description in Consignment costs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm | The database field name. |
| API identifier | freight1 | The API identifier used in GraphQL. |
| Number | 13183 |
Freight 2
Four fields for entering freight costs in domestic currency.
You can find a more detailed description in Consignment costs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm2 | The database field name. |
| API identifier | freight2 | The API identifier used in GraphQL. |
| Number | 13225 |
Freight 3
Four fields for entering freight costs in domestic currency.
You can find a more detailed description in Consignment costs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm3 | The database field name. |
| API identifier | freight3 | The API identifier used in GraphQL. |
| Number | 13226 |
Freight 4
Four fields for entering freight costs in domestic currency.
You can find a more detailed description in Consignment costs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm4 | The database field name. |
| API identifier | freight4 | The API identifier used in GraphQL. |
| Number | 13227 |
Freight processing
Special processing option for freight.
This field displays a numerical value if one of the four fields for freight or the Customs and Cost price addition (dom.) fields has a special processing option.
Purchase
In purchase orders, consignment costs on order lines are totalled in the order, when cost addition distribution for purchase orders is selected.
Cost addition distribution on purchases
When you select another distribution, the value in the Cost price addition (dom.) field is distributed to the finished order lines according to the selected distribution field (Amount, Net weight, Gross weight, Volume or Quantity).
On receipt of invoice, the field is reset and the value is moved to the Cost price addition so far (dom.) field.
Sale
In sales orders you must enter closing consignment costs in the default currency in the order, and the amount is included in the order total. When invoice printouts are approved, the fields are reset so that the amounts always relate to the next invoicing.
The Company information table contains the Product no. freight 1 - Product no. freight 4 and Product no. customs fields. These fields relate to products from which information is retrieved when printing, running statistics and posting closing consignment costs.
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 | No | This field is not visible by default in the table display. |
| Domain | Freight processing | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrCusPro | The database field name. |
| API identifier | freightProcessing | The API identifier used in GraphQL. |
| Number | 13322 |
Gr. 1
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr | The database field name. |
| API identifier | group1 | The API identifier used in GraphQL. |
| Number | 13119 |
Gr. 2
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr2 | The database field name. |
| API identifier | group2 | The API identifier used in GraphQL. |
| Number | 13120 |
Gr. 3
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr3 | The database field name. |
| API identifier | group3 | The API identifier used in GraphQL. |
| Number | 13121 |
Gr. 4
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 4 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr4 | The database field name. |
| API identifier | group4 | The API identifier used in GraphQL. |
| Number | 13122 |
Gr. 5
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 5 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr5 | The database field name. |
| API identifier | group5 | The API identifier used in GraphQL. |
| Number | 13123 |
Gr. 6
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 6 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr6 | The database field name. |
| API identifier | group6 | The API identifier used in GraphQL. |
| Number | 13124 |
Gr. 7
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 7 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr7 | The database field name. |
| API identifier | group7 | The API identifier used in GraphQL. |
| Number | 13294 |
Gr. 8
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 8 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr8 | The database field name. |
| API identifier | group8 | The API identifier used in GraphQL. |
| Number | 13295 |
Gr. 9
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 9 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr9 | The database field name. |
| API identifier | group9 | The API identifier used in GraphQL. |
| Number | 13296 |
Gr. 10
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 10 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr10 | The database field name. |
| API identifier | group10 | The API identifier used in GraphQL. |
| Number | 13297 |
Gr. 11
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 11 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr11 | The database field name. |
| API identifier | group11 | The API identifier used in GraphQL. |
| Number | 13298 |
Gr. 12
A group to which the order belongs.
Valid order groupings are defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order grouping 12 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr12 | The database field name. |
| API identifier | group12 | The API identifier used in GraphQL. |
| Number | 13299 |
Gross profit
The gross profit in the default currency.
The gross profit is the difference between invoiceable amount (credit amount) and incurred costs (debit amount). Gross profit is calculated for the Transaction type = 1 - Sales.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Gross profit | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M3 | The database field name. |
| API identifier | grossProfitDomestic | The API identifier used in GraphQL. |
| Number | 13157 |
Gross profit in future
The gross profit in the future for the same time limit in the default currency.
The gross profit is the difference between invoiceable amount (credit amount) and incurred costs (debit amount). Gross profit is calculated for the Transaction type = 1 - Sales.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Gross profit | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M8 | The database field name. |
| API identifier | grossProfitInFutureDomestic | The API identifier used in GraphQL. |
| Number | 13241 |
Gross profit so far
The gross profit so far for the same time limit in the default currency.
The field is only calculated for sales.
The gross profit is the difference between invoiceable amount (credit amount) and incurred costs (debit amount). Gross profit is calculated for the Transaction type = 1 - Sales.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Gross profit | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M6 | The database field name. |
| API identifier | grossProfitSoFarDomestic | The API identifier used in GraphQL. |
| Number | 13235 |
Gross profit total
The gross profit for the same time limit in the default currency.
The gross profit is the difference between invoiceable amount (credit amount) and incurred costs (debit amount). Gross profit is calculated for the Transaction type = 1 - Sales.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Gross profit | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M13 | The database field name. |
| API identifier | grossProfitTotalDomestic | The API identifier used in GraphQL. |
| Number | 13247 |
Gross weight
Displays the total for the corresponding field in the order line, and you can print the value in order documents using the @Order macro.
The field is related to the remaining quantities in the orders.
You can also print the values in the order lines for group discounts, group totals, structure heads and order totals by checking the Weight/dimensions on break lines box in the Order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | M18 | The database field name. |
| API identifier | grossWeight | The API identifier used in GraphQL. |
| Number | 13287 |
Gross weight on consignment note
In addition to the Gross weight field, which shows the gross weight for remaining quantities that are not finished in the order.
This field is totalled when printed Consignment notes are approved.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | GWgtCoSF | The database field name. |
| API identifier | grossWeightOnConsignmentNote | The API identifier used in GraphQL. |
| Number | 13329 |
Gross weight ready for consignment note
Gross weight total - Gross weight on consignment note - Gross weight (for remaining quantities).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | M19 | The database field name. |
| API identifier | grossWeightReadyForConsignmentNote | The API identifier used in GraphQL. |
| Number | 13328 |
Gross weight total
In addition to the Gross weight field, which shows the gross weight for remaining quantities that are not finished in the order.
The field is updated simultaneously with the Gross weight field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | GWgtTot | The database field name. |
| API identifier | grossWeightTotal | The API identifier used in GraphQL. |
| Number | 13327 |
Ignore test result
Select this field if you want to ignore flags for credit control when printing the next Pick lists.
Flags for credit control are Credit denied and Credit limit in the Test result field.
When Pick lists have been printed for such orders, the Ignore test result field is deselected.
- 1 - Ignore until first pick list
- 2 - Ignore in all processes
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Ignore test result | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IgnTest | The database field name. |
| API identifier | ignoreTestResult | The API identifier used in GraphQL. |
| Number | 13321 |
Inc. cost
The Inc. cost (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CIncCst | The database field name. |
| API identifier | incurredCostInCurrency | The API identifier used in GraphQL. |
| Number | 13251 |
Inc. cost (dom.)
The total incurred costs in the current currency for a sales order, and is updated continuously when the order is edited.
This applies to both entry of and changes to cost prices and incurred quantities in the order lines and when deleting order lines. These fields are also recalculated when you save.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IncCst | The database field name. |
| API identifier | incurredCostDomestic | The API identifier used in GraphQL. |
| Number | 13164 |
Inc. cost future
The Inc. cost future (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CIncIF | The database field name. |
| API identifier | incurredCostInFutureInCurrency | The API identifier used in GraphQL. |
| Number | 13253 |
Inc. cost future (dom.)
Future incurred costs in the current currency for quantities that have not yet been invoiced.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IncIF | The database field name. |
| API identifier | incurredCostInFutureDomestic | The API identifier used in GraphQL. |
| Number | 13240 |
Inc. cost so far
The Inc. cost so far (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CIncSF | The database field name. |
| API identifier | incurredCostSoFarInCurrency | The API identifier used in GraphQL. |
| Number | 13252 |
Inc. cost so far (dom.)
The incurred costs for the order so far in the current currency. The field is updated when invoicing takes place.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IncSF | The database field name. |
| API identifier | incurredCostSoFarDomestic | The API identifier used in GraphQL. |
| Number | 13234 |
Inc. cost total
The Inc. cost total (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M15 | The database field name. |
| API identifier | incurredCostTotalInCurrency | The API identifier used in GraphQL. |
| Number | 13254 |
Inc. cost total (dom.)
The total values of So far and In future for incurred costs in the current currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M12 | The database field name. |
| API identifier | incurredCostTotalDomestic | The API identifier used in GraphQL. |
| Number | 13246 |
Inf. 1
Additional order information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf | The database field name. |
| API identifier | information1 | The API identifier used in GraphQL. |
| Number | 13125 |
Inf. 2
Additional order information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf2 | The database field name. |
| API identifier | information2 | The API identifier used in GraphQL. |
| Number | 13126 |
Inf. 3
Additional order information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf3 | The database field name. |
| API identifier | information3 | The API identifier used in GraphQL. |
| Number | 13127 |
Inf. 4
Additional order information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf4 | The database field name. |
| API identifier | information4 | The API identifier used in GraphQL. |
| Number | 13128 |
Inf. 5
Additional order information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf5 | The database field name. |
| API identifier | information5 | The API identifier used in GraphQL. |
| Number | 13129 |
Inf. 6
Additional order information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf6 | The database field name. |
| API identifier | information6 | The API identifier used in GraphQL. |
| Number | 13130 |
Inquiry count
How many times Inquiries have been run for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InqCnt | The database field name. |
| API identifier | inquiryCount | The API identifier used in GraphQL. |
| Number | 13261 |
Inquiry no.
The last document number of the Inquiries printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | InqNo | The database field name. |
| API identifier | inquiryNo | The API identifier used in GraphQL. |
| Number | 13308 |
Inv. according to plan
For invoicing according to an invoice plan.
If you are going to invoice the order according to an invoice plan, complete the field with one of the following values:
- 1 - On account/settlement
- 2 - Fixed price
If you do not enter one of these values in the field, the order will be invoiced on an ongoing basis.
If you select value 2 - Fixed price, the value in the Deviate prod. no. field is suggested on the basis of what has been entered in the Fixed price deviate prod. field in the Company information table.
- 1 - On account/settlement
- 2 - Fixed price
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inv. according to plan | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoPl | The database field name. |
| API identifier | invoiceAccordingToPlan | The API identifier used in GraphQL. |
| Number | 13201 |
Invoice count
How many times invoices have been run for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoCnt | The database field name. |
| API identifier | invoiceCount | The API identifier used in GraphQL. |
| Number | 13268 |
Invoice customer no.
You complete this field if payment is to be made by someone other than the customer for a sale, hire or loan order.
Suggested on the basis of the corresponding field in the Associate table for the customer, and is used for d/c ledger entries.
The following fields are overridden by data from invoice customer no.:
- Currency no.
- Cost currency no.
- Payment method
- Payment terms
- Factoring no.
- Account set
- VAT code
- Trade area
If you have selected to use Customer price group 1 - 3, the system uses the value as well as price lookup on invoice customer no. Values are also retrieved from the Customer options field in the Associate table, and put in the Order options field in the Order table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | InvoCust | The database field name. |
| API identifier | invoiceCustomerNo | The API identifier used in GraphQL. |
| Number | 13193 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | InvoiceCustomer |
|
Invoice date
The last date for when the order was invoiced.
If you check the Invoice date from invoice plan box in the Order documents dialog box the date is retrieved from the invoice plan; otherwise the date is retrieved from the dialog box.
The date is validated using the regional settings in Windows.
| 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 | LstInvDt | The database field name. |
| API identifier | invoiceDate | The API identifier used in GraphQL. |
| Number | 13212 |
Invoice no.
The last document number of the invoice printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 13208 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order_InvoiceNo |
| ||
| Customer transaction | CustomerTransaction_InvoiceNo |
| ||
| Customer transaction | CustomerTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Open customer entry | OpenCustomerEntry_InvoiceNo |
| ||
| Open customer entry | OpenCustomerEntry_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Supplier transaction | SupplierTransaction_InvoiceNo |
| ||
| Supplier transaction | SupplierTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Open supplier entry | OpenSupplierEntry_InvoiceNo |
| ||
| Open supplier entry | OpenSupplierEntry_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger transaction | GeneralLedgerTransaction_InvoiceNo |
| ||
| General ledger transaction | GeneralLedgerTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset transaction | CapitalAssetTransaction_InvoiceNo |
| ||
| Capital asset transaction | CapitalAssetTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction | ProductTransaction_InvoiceNo |
| ||
| Product transaction | ProductTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Voucher | Voucher_InvoiceNo |
| ||
| Voucher | Voucher_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Voucher | Voucher_CrossReference |
| ||
| Updated voucher | UpdatedVoucher_InvoiceNo |
| ||
| Updated voucher | UpdatedVoucher_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher_CrossReference |
|
Invoice reference
The number of the invoice to which the Credit note refers.
If you have chosen to present original lines in the Invoice ref. processing field in the Company information table, the product transactions that have the same invoice reference as the invoice number are imported, and the products will be put back in the shipments from where they are taken. The field is included as a cross-reference in d/c ledger entries, so that credit notes are automatically matched to invoices.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoRef | The database field name. |
| API identifier | invoiceReference | The API identifier used in GraphQL. |
| Number | 13203 |
Invoice week
The Invoice date field expressed as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | invoiceWeek | The API identifier used in GraphQL. |
| Number | 13213 |
Invoiceable amount
Can be used to override the Order total net in the current currency.
An adjustment line is then added with the product number that you have defined in the Deviate prod. no. field. The transaction date is set to the same date as order line where you enter the amount and other values from the order such as organisational units and similar.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OvCNOSm | The database field name. |
| API identifier | invoiceableAmountInCurrency | The API identifier used in GraphQL. |
| Number | 13330 |
Invoiceable amount in EURO
The amount in the Invoiceable amount field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Invoiceable amount | Euro |
| 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 | invoiceableAmountInEuro | The API identifier used in GraphQL. |
| Number | 13149 |
Invoiced amount in future
The Invoiced amount in future (dom.) field converted into the default currency.
In addition to the Order total field, which is calculated on the basis of the remaining quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoIF | The database field name. |
| API identifier | invoicedAmountInFutureInCurrency | The API identifier used in GraphQL. |
| Number | 13237 |
Invoiced amount in future (dom.)
The total for the order in the current currency, for quantities not invoiced yet.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DInvoIF | The database field name. |
| API identifier | invoicedAmountInFutureDomestic | The API identifier used in GraphQL. |
| Number | 13239 |
Invoiced amount in future in EURO
The Invoiced amount in future (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Invoiced amount in future | Euro |
| 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 | invoicedAmountInFutureInEuro | The API identifier used in GraphQL. |
| Number | 13238 |
Invoiced amount NOW
The value in the current currency of order lines for which you are currently reporting receipt of invoice for the purchase order.
This field is updated continuously when you enter, change or delete order lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M5 | The database field name. |
| API identifier | invoicedAmountNowInCurrency | The API identifier used in GraphQL. |
| Number | 13206 |
Invoiced amount NOW in EURO
The Invoiced amount NOW field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Invoiced amount NOW | Euro |
| 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 | invoicedAmountNowInEuro | The API identifier used in GraphQL. |
| Number | 13207 |
Invoiced amount so far
The Invoiced amount so far (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoSF | The database field name. |
| API identifier | invoicedAmountSoFarInCurrency | The API identifier used in GraphQL. |
| Number | 13232 |
Invoiced amount so far (dom.)
The total for the order so far in the current currency, and is in addition to the Order total field, which is calculated on the basis of the remaining quantity.
This field is updated on invoicing.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoAm | The database field name. |
| API identifier | invoicedAmountSoFarDomestic | The API identifier used in GraphQL. |
| Number | 13209 |
Invoiced amount so far in EURO
The Invoiced amount so far (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Invoiced amount so far | Euro |
| 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 | invoicedAmountSoFarInEuro | The API identifier used in GraphQL. |
| Number | 13233 |
Invoiced amount total
The Invoiced amount total (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M10 | The database field name. |
| API identifier | invoicedAmountTotalInCurrency | The API identifier used in GraphQL. |
| Number | 13243 |
Invoiced amount total (dom.)
The total value in the current currency for the Invoiced amount so far and Invoiced amount in future fields.
In addition to the order total fields, which is calculated on the basis of the remaining quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M11 | The database field name. |
| API identifier | invoicedAmountTotalDomestic | The API identifier used in GraphQL. |
| Number | 13245 |
Invoiced amount total in EURO
The Invoiced amount total (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Invoiced amount total | Euro |
| 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 | invoicedAmountTotalInEuro | The API identifier used in GraphQL. |
| Number | 13244 |
Label
This is a free information field, which you can edit out in printouts.
Will be applied as invoice no. if the Invoice no. from 'Label'. check box is selected in the lookup dialog box to the Order options field (which is suggested from the Customer options in the Associate table).
The vouchers will still be assigned voucher numbers from the Voucher series table.
The field is used in countries where invoice numbers are pre-printed on the invoice form.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Label | Text (50) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Label | The database field name. |
| API identifier | label | The API identifier used in GraphQL. |
| Number | 13189 |
Language no.
The language determines which texts are printed in documents that you send to the customer/supplier.
The value in this field is retrieved from your entry in the same field in the Associate table. If you have not filled in this field, the default value is retrieved from the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Language no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Lang | The database field name. |
| API identifier | languageNo | The API identifier used in GraphQL. |
| Number | 13114 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Language | Language |
|
Layout no.
The layout used when the document was produced, i.e. the output layout from the form, or the screen layout from which the report was run.
Refers to the Window table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | LayNo | The database field name. |
| API identifier | layoutNo | The API identifier used in GraphQL. |
| Number | 13098 |
Length
Displays the total for the corresponding field in the order line.
The field is related to the remaining quantity in the order, and you can print this field in order documents in the usual way using the @Order macro. You can also print the value in the order lines for group discounts, group totals, structure heads and order totals by checking the Weight/dimensions on break lines box in the Order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Lgt | The database field name. |
| API identifier | length | The API identifier used in GraphQL. |
| Number | 13288 |
Main order doc. no.
The order document number of the batch invoice, if this row represents an order on that batch invoice.
Assumes that the Grouping by order check box was selected in the advanced report parameter dialog box to the Invoices/credit notes report.
The Doc. type, Doc. date, Form no., Layout no. and Page elem. no. fields will then only be filled out on the row for the batch invoice.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | MnOrDocN | The database field name. |
| API identifier | mainOrderDocumentNo | The API identifier used in GraphQL. |
| Number | 13758 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order document | MainOrderDocument |
|
Main order no.
You can use this field to arrange orders in an unlimited number of levels.
This field refers to any order under which this order belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MainOrd | The database field name. |
| API identifier | mainOrderNo | The API identifier used in GraphQL. |
| Number | 13256 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | MainOrder |
|
Margin
Calculated by dividing the Gross profit by the Order total net (dom.) field, and displays the share of the Order total net (dom.) remaining when costs have been covered.
The field is only calculated for sales.
You can specify a minimum limit for the margin in the Min. margin field in the Company information table. You will be given a warning on saving if the margin is below the minimum limit.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Margin | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M4 | The database field name. |
| API identifier | margin | The API identifier used in GraphQL. |
| Number | 13158 |
Margin in future
The future margin of the product.
Calculated by dividing the Gross profit in future by the Invoiced amount in future field, and displays the share of the Invoiced amount in future remaining when costs have been covered.
The field is only calculated for sales.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Margin | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M9 | The database field name. |
| API identifier | marginInFuture | The API identifier used in GraphQL. |
| Number | 13242 |
Margin so far
Calculated by dividing the Gross profit so far by the Invoiced amount so far field, and displays the share of the Invoiced amount so far remaining when costs have been covered.
The field is only calculated for sales.
You can specify a minimum limit for the margin in the Min. margin field in the Company information table. You will be given a warning on saving if the margin is below the minimum limit.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Margin | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M7 | The database field name. |
| API identifier | marginSoFar | The API identifier used in GraphQL. |
| Number | 13236 |
Margin total
The total margin for the product.
Calculated by dividing the Gross profit total by the Invoiced amount total field, and displays the share of the Invoiced amount total remaining when costs have been covered.
The field is only calculated for sales.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Margin | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M14 | The database field name. |
| API identifier | marginTotal | The API identifier used in GraphQL. |
| Number | 13248 |
Memo file name
The file name and path of any memo file that is linked to the order.
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) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 13216 |
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19242 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Name
Filled in when you enter a customer/supplier number.
You can override this field when using sundry customers or if there is a temporary change of address.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Nm | The database field name. |
| API identifier | name | The API identifier used in GraphQL. |
| Number | 13106 |
Net weight
Displays the total for the corresponding field in the order line, and you can print the value in order documents using the @Order macro.
The field is related to the remaining quantities in the orders.
You can also print the values in the order lines for group discounts, group totals, structure heads and order totals by checking the Weight/dimensions on break lines box in the Order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | NWgt | The database field name. |
| API identifier | netWeight | The API identifier used in GraphQL. |
| Number | 13285 |
Non-taxable amount
Displays the Non-taxable amount in the current currency in the order, and is updated when saved.
You can print this field using the @Order macro in the order documents.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DtyFrAm | The database field name. |
| API identifier | nonTaxableAmountInCurrency | The API identifier used in GraphQL. |
| Number | 13269 |
Non-taxable amount (dom.)
The amount from the Non-taxable amount field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DDtyFrAm | The database field name. |
| API identifier | nonTaxableAmountDomestic | The API identifier used in GraphQL. |
| Number | 13271 |
Non-taxable amount in EURO
The amount from the Non-taxable amount field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Non-taxable amount | Euro |
| 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 | nonTaxableAmountInEuro | The API identifier used in GraphQL. |
| Number | 13270 |
Order balance accretion
The Order balance accretion (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdBal | The database field name. |
| API identifier | orderBalanceAccretionInCurrency | The API identifier used in GraphQL. |
| Number | 13310 |
Order balance accretion (dom.)
This field monitors the order's contribution to the customer's order balance in the current currency.
This matches the Invoiced amount in future field, except that you always see the order balance in gross terms including VAT, so that it can be compared with the d/c ledger balance.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DOrdBal | The database field name. |
| API identifier | orderBalanceAccretionDomestic | The API identifier used in GraphQL. |
| Number | 13312 |
Order balance accretion in EURO
The Order balance accretion (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Order balance accretion | Euro |
| 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 | orderBalanceAccretionInEuro | The API identifier used in GraphQL. |
| Number | 13311 |
Order basis no.
Stores the sales order number and purchase estimate number respectively when you generate purchase and production orders on the basis of sales orders and purchase estimates.
You can also use the field freely as an integer field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order basis no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdBasNo | The database field name. |
| API identifier | orderBasisNo | The API identifier used in GraphQL. |
| Number | 13137 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | OrderBasis |
|
Order confirmation no.
The last document number of the Order confirmations printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CfNo | The database field name. |
| API identifier | orderConfirmationNo | The API identifier used in GraphQL. |
| Number | 13305 |
Order date
The current date is suggested.
The Order date can be overridden by the Trans. date in the order lines. The selection in the Comparison date field in the Company information table determines whether the Order date/Trans. date is used when comparing with the from and to dates in the Price- and discount matrix and the Stock balance tables.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdDt | The database field name. |
| API identifier | orderDate | The API identifier used in GraphQL. |
| Number | 13103 |
Order doc. no.
A unique number identifying the order document.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Order doc. no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdDocNo | The database field name. |
| API identifier | orderDocumentNo | The API identifier used in GraphQL. |
| Number | 13094 |
Order document processing
Settings defining the behaviour of the order document.
- Write memos
- Memos attached to the order lines will be printed.
Originates from the Order line memos check box in the advanced report parameter dialog box for the actual order document report.
- Giro document
- The invoice has a giro amount (greater than 0).
- Grouping by order
- A row will be added for each order, with the Main order no. field referring to the batch invoice.
Originates from the Grouping by order check box in the advanced report parameter dialog box to the Invoices/credit notes report.
- Page break per order
- A page break will be included for each order on a batch
invoice.
Originates from the Page break per order check box in the advanced report parameter dialog box to the Invoices/credit notes report.
- External processing 1
- May be set by external tools. (The bit value for this check box is 16.)
- External processing 2
- May be set by external tools. (The bit value for this check box is 32.)
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order document processing | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdDPro | The database field name. |
| API identifier | orderDocumentProcessing | The API identifier used in GraphQL. |
| Number | 13717 |
Order no.
The order number.
If you select Order no in Next on + only in the Company information table, you can only use the + key and not enter the Order no. directly.
When you create new orders values are suggested in the following fields:
- Transaction type
- Order type
- Order date/Order week
- Required delivery date and Confirmed delivery date/Confirmed delivery week
- Warehouse no.
- Currency no. and Exchange rate
- Cost currency no. and Cost exchange rate
You can change these values using the Edit/Entry rules menu item.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Order no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 13100 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
| ||
| Customer transaction | CustomerTransaction_OrderNo |
| ||
| Customer transaction | CustomerTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Open customer entry | OpenCustomerEntry_OrderNo |
| ||
| Open customer entry | OpenCustomerEntry_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Supplier transaction | SupplierTransaction_OrderNo |
| ||
| Supplier transaction | SupplierTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Open supplier entry | OpenSupplierEntry_OrderNo |
| ||
| Open supplier entry | OpenSupplierEntry_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger transaction | GeneralLedgerTransaction_OrderNo |
| ||
| General ledger transaction | GeneralLedgerTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset transaction | CapitalAssetTransaction_OrderNo |
| ||
| Capital asset transaction | CapitalAssetTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction | ProductTransaction_OrderNo |
| ||
| Product transaction | ProductTransaction_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Voucher | Voucher_OrderNo |
| ||
| Voucher | Voucher_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher_OrderNo |
| ||
| Updated voucher | UpdatedVoucher_OrderNoAndInvoiceNo |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Order options
Settings defining the behaviour of the order.
Values from the selected check boxes are added and the calculated value is entered in this field. If other orders are to have the same preferences, you can type the value directly in the field without displaying the dialog box.
General
- Gross order
- This check box is selected on the basis of the customer number/supplier number entered in the order head. See the description for the Customer options/Supplier options field in the Associate table. If you select this check box, all prices and amounts will include VAT.
- Credit note
- A credit note will be issued. See also Credit note
- Reserve on save
- When saving Business NXT will reserve the quantity that has not already been reserved. The Not reserved field in the order line will then be reset. This check box is selected on the basis of the customer number entered in the order head. See the description for the Customer options field in the Associate table.
- Reserve within lead time
- This field shows whether reserve on save should only apply to order lines within the lead time. The selection is greyed out if you have not selected the Reserve on save check box. This does not apply to reservations displayed in the order lines/products or in the Reservation table. It also applies to selection of the Reserve on save check box under the Processing method/Warehouse menu item. This check box is selected on the basis of the customer number entered in the order head. See the description for the Customer options field in the Associate table.
- Accept changes manually
- This check box is suggested on the basis of the customer number entered in the order head. See the description for the Customer options field in the Associate table. When you insert new order lines in an order, the Accepted by us check box in the dialog box for the Order line status field is selected. This does not happen if you have selected the Accept changes manually check box.
- Pick complete order
- This check box is used to exempt customers/orders from partial deliveries. When printing pick lists the order will only be included if the whole order can be picked at one time. This check box is selected on the basis of the customer number entered in the order head. See the description for the Customer options field in the Associate table.
- Exclude from reduplication
- All of the values in the order lines are retained when you transfer the order lines to an order using the "Transfer" processing.
- Do not move confirmed delivery date to earlier
- The confirmed delivery date will not be changed for allocated orders
which are to be delivered after the confirmed date. Orders with an earlier date get an
updated confirmed delivery date with a confirmed date from the purchase production
order when the Confirmed and Sent processings are used.
For loose allocations, future orders will not be reserved if this field has not been selected:
- Reserve by confirmed / sent under Reservation processing in the Company information table.
- Reserve against all orders in the dialog box for the Confirmed and Sent processings. A check is suggested when Reserve by confirmed / sent in Reservation processing in the Company information table is selected.
- As standard for all orders under the Calculate delivery date field in the Company information table.
- Each individual order in the Customer options field in the Associate table.
Invoicing
- Batch invoice
- The order will be included in a batch invoice. When printing invoices/credit notes, select the check box in the Order documents dialog box to show whether or not Business NXT should process such orders. A more detailed explanation of batch invoice processing can be found under Printing order documents and Invoicing. This check box is selected on the basis of the customer number entered in the order head. See the description for the Customer options field in the Associate table.
- Justify exchange rate
- This check box shows whether you have to re-enter exchange rates from
the Currency
table during invoicing. Selection of the check box relates to the exchange rates in
the order head and the order lines, for both current currency and cost currency. This
check box is selected on the basis of the customer number entered in the order head.
See the description for the Customer options
field in the Associate
table.Note:This processing can only be used for sales orders; if you use it for other types of orders it leads to an accounting error. There are no restrictions on using this processing for purchase and production orders.
- Exempt from invoice fee
- This check box is selected on the basis of the customer number entered in the order head. See the description for the Customer options field in the Associate table. Select this check box to exempt the invoice from any invoice fee. If an order qualifying for an invoice fee is part-delivered, it will be necessary to exempt it from invoice fees. If you part deliver an order that was not to be subject to an invoice fee at the outset, the individual invoices will not be subject to any fees either.
- Ref. Entry Free of interest
- Ref. Entry Free of reminder fee
- The reminder fee will be printed in the total row. The reminder fee will not be added to the To pay total on the reminder. The reminder fee will be added to the Giro amount, even if an item is exempt from reminder fees.
- Invoice no. from 'Label'.
- Uses the value in the Label field as invoice no.
- Withdrawal from client bank account
- The customer's client responsible balance/bank account will be debited upon settlement, once any on account entries for the order have been used. You can combine this option with Post to client bank account.
- Post to client bank account
- Settlement invoices are posted with the on account amount that is attached when posting, instead of being returned to the account to which it was originally posted on account.
- Use client responsibility 2
- The amount is restricted upwards to the outgoing balance of client responsibility 2 for the accounting period within which the order document date falls.
- Use client responsibility 3
- The amount is restricted upwards to the outgoing balance of client responsibility 3 for the accounting period within which the order document date falls.
- Prepayment
- This function prevents the order from being further processed until a payment has been entered in the accounts or until you have removed the credit suspension manually. Advance payment will be retrieved from the customer or supplier if Customer options or Supplier options has been selected for Prepayment. The selection will be removed if a payment is posted for the customer/supplier. This is described in the section entitled ../../../business/concept/c_prepayment.html.
- Use original exchange rate on credit notes
Invoice received
- Produce CID code
- This check box is selected on the basis of the supplier number entered in the order head. See the description for the Supplier options field in the Associate table. Selection of the check box defines whether Business NXT is to include the CID code in the vouchers produced for receipt of invoices.
- Do not copy from payment supplier
- Is used when you perform a run with factoring and a bank account number, etc. is available for each supplier. These values will then be used for the payment and not the values from the Payment supplier no..
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order options | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdPref | The database field name. |
| API identifier | orderPreferences | The API identifier used in GraphQL. |
| Number | 13281 |
Order price gr.
If you have orders with the same price and discount structure you can assign the same value in this field for use in the price- and discount matrix.
You can enter valid values for the Order price gr. field in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order price group | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdPrGr | The database field name. |
| API identifier | orderPriceGroup | The API identifier used in GraphQL. |
| Number | 13138 |
Order status 1
Refers to the information displayed in the dialog box for the Order status processing.
The Order status processing opens a dialog box that displays which processes the active order is ready for or has been through. You can also exempt the order from processing. This dialog box has three tabs: Order status, Miscellaneous and Credit card order.
The Order status tab contains statuses that relate to order documents and the order flow. The dialog box has three columns of check boxes:Ready for, Performed and Excluded, the last of which you can edit. You can, for example, exempt an order from invoicing if it is to be part delivered and you do not want to invoice it until everything has been delivered. The customer requires a packing slip per delivery. There is also a field in the order lines in which you can exempt them from processes and printouts. The Performed check box is selected if something has been processed. If Ready for is clear at the same time, this means that everything has been processed.
The order status optimises printouts and processing by virtue of the fact that Business NXT does not spend time reading through order lines to find orders that will not be included anyway. You can also make selections in the fields via the bit operators in the “Selection” dialog box to limit which orders you want to see. At the same time you help Business NXT not to lock, search or release an unnecessary number of orders.
Business NXT only processes orders for which the Ready for check box has been selected for the relevant process/printout, or which are locked by the process. In the case of a cumulative printout a check is performed to see whether Ready for or Performed has been selected.
The Ready for check box is selected on the basis of the transaction type and order type in the order head, the quantity in the order lines and which modules the installation comprises. This is independent of which access group you belong to. When you try to launch a printout or a process, access restrictions for your access group will also come into force.
Order status
Ready for / Performed / Excluded
- Invoices/credit notes
- Consignment notes
- Packing slips
- Returning
- Finishing
- If an order is not ready for finishing/goods received, then neither is it ready for printouts that arrive earlier. This means quotations, order confirmations and pick lists, or production orders, inquiries, purchase orders and purchase order confirmations
- Pick lists
- Order confirmations
- The order status fields Sent from supplier and Order confirmations are also updated for sales orders and not just purchase orders. This means that you
can choose between all the combinations that can occur in a single order. Only stock
goods are included as ready for Purchase confirmation and Sent from supplier.
For direct orders the Ready for check box is not deselected for order confirmations or purchase order confirmations. This applies even if the order is not ready for finishing/goods received, as long as it is ready for invoice or invoice received. A purchase order confirmation presupposes that something has been ordered.
- Acceptance
- Quotations
- Prepayment
- Prepayment will be selected when the Order options field for the order is selected in Prepayment. This parameter will prevent you running a pick list and finishing for the order. Only ready for parameters are selected. When prepayment is made, the selection for ready for prepayment will be removed. NOTE: If prepayment is made with only a fraction of the amount, the selection will be removed anyway.
- Delivery notes
- Delivery note is not an order document and can be performed from the
Associate table to which
the order lines are joined. All of the orders for each customer are printed and the
order lines are approved.
If you want to do this for each order, you can do this from all order documents with the exception of pick list, which does not have an approval dialog box. You must then select "Set delivery message to completed" under the "Options" tab in the "Order documents" dialog box.
When this option is checked, "Order printouts" also has an approval dialog box, because changes have been made to the order.
- Invoice received
- Goods received
- Sent from supplier
- The order status fields Sent from supplier and Order confirmations are also updated for sales orders and not just purchase orders. This means that you can choose between all the combinations that can occur in a single order. Only stock goods are included as ready for Purchase confirmation and Sent from supplier.
- Purchase confirmation
- Purchase orders
- Inquiries
- Production orders
- Structure lines finished
- Final cost on product transactions
- Cancelling
Miscellaneous
Miscellaneous
- Locked / Transferred
- Orders that have been transferred to an external application for
processing will be blocked. This should be done automatically when data is imported
and then imported back into the integration tool.
If you have selected this field, you cannot make changes to orders and order lines. A message appears stating that the order is blocked for processing. If you have not selected this field, the Locked / Transferred memory column in the Order table is automatically selected.
Note:Business NXT's integration with Visma Retail updates this field when the cash account imports orders into Business NXT for processing. EDI import with rule file has a separate import command to enable or disable this selection. c,Suspended,nn,1,0,,,,,,,,,I, nn is replaced with the position in the file and the values are 0 = deselect and 1 = select.Note:The order status on the purchase order is set as Locked / Transferred and the order is locked from editing when the order's approval status is:- 1 - Sent
- 2 - Pending workflow
- 3 - Waiting for approval
The Locked / Transferred flag is released for the order associated with an Approval task when its status changes to:- 4 - Approved
- 5 - Rejected
- 6 - Requested cancel
- 7 - Cancelled
- 8 - Error
To release the lock while in Approval, use the Cancel approval processing in the Approval task table.
Note:If the order is marked as Locked / Transferred, the Insert before (Ctrl+I) and Insert after (Shift+Ctrl+I) commands are prevented from running on order line level. - Precalculated production
- A new calculation will not be done when you have executed the Calculate production start / costs processing and selected the Precalculation parameter.
Origin
- EDI
- Visma XML
- Document center
Order match status
- Order match in progress
- If enabled, then the Order match process is in progress on that specific order.
- Inside tolerance level
- If enabled, then at least one order line has the same Order match status.
- Outside tolerance level
- If enabled, then at least one order line has the same Order match status.
- Excessive quantity
- If enabled, then the Quantity on an invoice is more than what has been finished on the order line.
- Original values overwritten
- If enabled, then at least one original Order line value has been overridden by a specific invoice value.
- Order match on totals
Approval status
-
Workflow status in Visma.net Approval integration.
- 1 - Sent
- Request has been send to Visma.net Approval.
- 2 - Pending workflow
- Visma.net Approval has received the request, but was not able to solve the workflow. Request needs to be handled forward in Visma.net Approval.
- 3 - Waiting for approval
- Visma.net Approval has received the request. It is in a workflow and waiting to be approved or rejected.
- 4 - Approved
- Request has been approved in Visma.net Approval.
- 5 - Rejected
- Request has been rejected in Visma.net Approval.
- 6 - Requested cancel
- User has requested cancellation of the approval request.
- 7 - Cancelled
- Request has been cancelled. Cancellation has been confirmed by Visma.net Approval.Note:If the request was already approved or rejected in Visma.net Approval, only status in Business NXT is set to 7 - Cancelled. Status is not visible in Visma.net Approval.
- 8 - Error
- There was an error in request handling. See more details in Comment field in Approval task change log table.
- 9 - In approval flow
- 10 - Automatically approved
Credit card order
Connection disturbance
- The Payment Service Providers invoice reference is missing
- The Invoice reference field in the order head must contain the reference that the Payment Service Provider has assigned to this order, and without this reference the payment cannot be executed.
- The currency lacks ISO code
- If there is no currency number for the order or the specified currency has no ISO code in the Currency table, the transaction cannot be completed.
- Invoice customer no. is missing on credit card order
- Unless Invoice customer number is completed for the order, the order will not be sent to the Payment Service Provider, as this field is used to determine which credit card is being used.
- Contract amount is missing on credit card order
- If the contract amount used to store the reserved amount at the Payment Service Provider is not completed, the order is not sent.
Credit card order processing
- Program for connecting to Payment Service Provider not found
- Selected if the program for the Payment Service Provider cannot be found.
- Unable to connect to Payment Service Provider
- Selected if Business NXT cannot connect to the Payment Service Provider.
- User name or password for Payment Service is not registered in Company data
- Selected if no User name card payment or Password card payment is registered for the Payment Service Provider in the Company information table.
Credit card order validation
- Credit note is already created and suspended from additional credit note
- If you have created a credit note using the Create order copy processing for a credit card order, this field is checked. The check is placed to prevent you from creating another credit note for the credit card payment, as this can mean that more money is paid back to the card holder than was charged.
- Invoice amount is to big compared to reserved amount at the Payment Service Provider
- Selected if you have access to changing a credit card order and the
amount exceeds the reserved amount and the order is not transferred.
Reference is made to the value in the Credit card reservation addition % column in the Associate table for the customer specified as the invoice customer.
- An error occurred during registering of the sale at the Payment Service Provider
- Selected, for the orders that were not confirmed or are incorrect, if an error occurs during the transfer of invoices to the Payment Service Provider.
- An error occurred during the refund at the Payment Service Provider
- Selected, for the orders that were not confirmed or are incorrect, if an error occurs during the transfer of credit notes to the Payment Service Provider.
- An error occurred during the cancelling of the reservation at the Payment Service Provider
- Selected, for the orders that were not confirmed or are incorrect, if an error occurs during the transfer of cancelled orders to the Payment Service Provider.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order status 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdPrSt | The database field name. |
| API identifier | orderStatus1 | The API identifier used in GraphQL. |
| Number | 13205 |
Order status 2
Refers to the information displayed in the dialog box for the Order status processing.
The Order status processing opens a dialog box that displays which processes the active order is ready for or has been through. You can also exempt the order from processing. This dialog box has three tabs: Order status, Miscellaneous and Credit card order.
The Order status tab contains statuses that relate to order documents and the order flow. The dialog box has three columns of check boxes:Ready for, Performed and Excluded, the last of which you can edit. You can, for example, exempt an order from invoicing if it is to be part delivered and you do not want to invoice it until everything has been delivered. The customer requires a packing slip per delivery. There is also a field in the order lines in which you can exempt them from processes and printouts. The Performed check box is selected if something has been processed. If Ready for is clear at the same time, this means that everything has been processed.
The order status optimises printouts and processing by virtue of the fact that Business NXT does not spend time reading through order lines to find orders that will not be included anyway. You can also make selections in the fields via the bit operators in the “Selection” dialog box to limit which orders you want to see. At the same time you help Business NXT not to lock, search or release an unnecessary number of orders.
Business NXT only processes orders for which the Ready for check box has been selected for the relevant process/printout, or which are locked by the process. In the case of a cumulative printout a check is performed to see whether Ready for or Performed has been selected.
The Ready for check box is selected on the basis of the transaction type and order type in the order head, the quantity in the order lines and which modules the installation comprises. This is independent of which access group you belong to. When you try to launch a printout or a process, access restrictions for your access group will also come into force.
Order status
Ready for / Performed / Excluded
- Invoices/credit notes
- Consignment notes
- Packing slips
- Returning
- Finishing
- If an order is not ready for finishing/goods received, then neither is it ready for printouts that arrive earlier. This means quotations, order confirmations and pick lists, or production orders, inquiries, purchase orders and purchase order confirmations
- Pick lists
- Order confirmations
- The order status fields Sent from supplier and Order confirmations are also updated for sales orders and not just purchase orders. This means that you
can choose between all the combinations that can occur in a single order. Only stock
goods are included as ready for Purchase confirmation and Sent from supplier.
For direct orders the Ready for check box is not deselected for order confirmations or purchase order confirmations. This applies even if the order is not ready for finishing/goods received, as long as it is ready for invoice or invoice received. A purchase order confirmation presupposes that something has been ordered.
- Acceptance
- Quotations
- Prepayment
- Prepayment will be selected when the Order options field for the order is selected in Prepayment. This parameter will prevent you running a pick list and finishing for the order. Only ready for parameters are selected. When prepayment is made, the selection for ready for prepayment will be removed. NOTE: If prepayment is made with only a fraction of the amount, the selection will be removed anyway.
- Delivery notes
- Delivery note is not an order document and can be performed from the
Associate table to which
the order lines are joined. All of the orders for each customer are printed and the
order lines are approved.
If you want to do this for each order, you can do this from all order documents with the exception of pick list, which does not have an approval dialog box. You must then select "Set delivery message to completed" under the "Options" tab in the "Order documents" dialog box.
When this option is checked, "Order printouts" also has an approval dialog box, because changes have been made to the order.
- Invoice received
- Goods received
- Sent from supplier
- The order status fields Sent from supplier and Order confirmations are also updated for sales orders and not just purchase orders. This means that you can choose between all the combinations that can occur in a single order. Only stock goods are included as ready for Purchase confirmation and Sent from supplier.
- Purchase confirmation
- Purchase orders
- Inquiries
- Production orders
- Structure lines finished
- Final cost on product transactions
- Cancelling
Miscellaneous
Miscellaneous
- Locked / Transferred
- Orders that have been transferred to an external application for
processing will be blocked. This should be done automatically when data is imported
and then imported back into the integration tool.
If you have selected this field, you cannot make changes to orders and order lines. A message appears stating that the order is blocked for processing. If you have not selected this field, the Locked / Transferred memory column in the Order table is automatically selected.
Note:Business NXT's integration with Visma Retail updates this field when the cash account imports orders into Business NXT for processing. EDI import with rule file has a separate import command to enable or disable this selection. c,Suspended,nn,1,0,,,,,,,,,I, nn is replaced with the position in the file and the values are 0 = deselect and 1 = select.Note:The order status on the purchase order is set as Locked / Transferred and the order is locked from editing when the order's approval status is:- 1 - Sent
- 2 - Pending workflow
- 3 - Waiting for approval
The Locked / Transferred flag is released for the order associated with an Approval task when its status changes to:- 4 - Approved
- 5 - Rejected
- 6 - Requested cancel
- 7 - Cancelled
- 8 - Error
To release the lock while in Approval, use the Cancel approval processing in the Approval task table.
Note:If the order is marked as Locked / Transferred, the Insert before (Ctrl+I) and Insert after (Shift+Ctrl+I) commands are prevented from running on order line level. - Precalculated production
- A new calculation will not be done when you have executed the Calculate production start / costs processing and selected the Precalculation parameter.
Origin
- EDI
- Visma XML
- Document center
Order match status
- Order match in progress
- If enabled, then the Order match process is in progress on that specific order.
- Inside tolerance level
- If enabled, then at least one order line has the same Order match status.
- Outside tolerance level
- If enabled, then at least one order line has the same Order match status.
- Excessive quantity
- If enabled, then the Quantity on an invoice is more than what has been finished on the order line.
- Original values overwritten
- If enabled, then at least one original Order line value has been overridden by a specific invoice value.
- Order match on totals
Approval status
-
Workflow status in Visma.net Approval integration.
- 1 - Sent
- Request has been send to Visma.net Approval.
- 2 - Pending workflow
- Visma.net Approval has received the request, but was not able to solve the workflow. Request needs to be handled forward in Visma.net Approval.
- 3 - Waiting for approval
- Visma.net Approval has received the request. It is in a workflow and waiting to be approved or rejected.
- 4 - Approved
- Request has been approved in Visma.net Approval.
- 5 - Rejected
- Request has been rejected in Visma.net Approval.
- 6 - Requested cancel
- User has requested cancellation of the approval request.
- 7 - Cancelled
- Request has been cancelled. Cancellation has been confirmed by Visma.net Approval.Note:If the request was already approved or rejected in Visma.net Approval, only status in Business NXT is set to 7 - Cancelled. Status is not visible in Visma.net Approval.
- 8 - Error
- There was an error in request handling. See more details in Comment field in Approval task change log table.
- 9 - In approval flow
- 10 - Automatically approved
Credit card order
Connection disturbance
- The Payment Service Providers invoice reference is missing
- The Invoice reference field in the order head must contain the reference that the Payment Service Provider has assigned to this order, and without this reference the payment cannot be executed.
- The currency lacks ISO code
- If there is no currency number for the order or the specified currency has no ISO code in the Currency table, the transaction cannot be completed.
- Invoice customer no. is missing on credit card order
- Unless Invoice customer number is completed for the order, the order will not be sent to the Payment Service Provider, as this field is used to determine which credit card is being used.
- Contract amount is missing on credit card order
- If the contract amount used to store the reserved amount at the Payment Service Provider is not completed, the order is not sent.
Credit card order processing
- Program for connecting to Payment Service Provider not found
- Selected if the program for the Payment Service Provider cannot be found.
- Unable to connect to Payment Service Provider
- Selected if Business NXT cannot connect to the Payment Service Provider.
- User name or password for Payment Service is not registered in Company data
- Selected if no User name card payment or Password card payment is registered for the Payment Service Provider in the Company information table.
Credit card order validation
- Credit note is already created and suspended from additional credit note
- If you have created a credit note using the Create order copy processing for a credit card order, this field is checked. The check is placed to prevent you from creating another credit note for the credit card payment, as this can mean that more money is paid back to the card holder than was charged.
- Invoice amount is to big compared to reserved amount at the Payment Service Provider
- Selected if you have access to changing a credit card order and the
amount exceeds the reserved amount and the order is not transferred.
Reference is made to the value in the Credit card reservation addition % column in the Associate table for the customer specified as the invoice customer.
- An error occurred during registering of the sale at the Payment Service Provider
- Selected, for the orders that were not confirmed or are incorrect, if an error occurs during the transfer of invoices to the Payment Service Provider.
- An error occurred during the refund at the Payment Service Provider
- Selected, for the orders that were not confirmed or are incorrect, if an error occurs during the transfer of credit notes to the Payment Service Provider.
- An error occurred during the cancelling of the reservation at the Payment Service Provider
- Selected, for the orders that were not confirmed or are incorrect, if an error occurs during the transfer of cancelled orders to the Payment Service Provider.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order status 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdPrSt2 | The database field name. |
| API identifier | orderStatus2 | The API identifier used in GraphQL. |
| Number | 13318 |
Order total gross
The Order total gross (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M1 | The database field name. |
| API identifier | orderSumGrossInCurrency | The API identifier used in GraphQL. |
| Number | 13152 |
Order total gross (dom.)
The order totals are calculated on the basis of the remaining quantities in the order lines, i.e. quantities that have not been finished. Invoice fees are not included in the order total.
Calculated when you save the order, displays the total of the net order total in the current currency after line, group and total discounts, special tax, VAT and rounding.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | M2 | The database field name. |
| API identifier | orderSumGrossDomestic | The API identifier used in GraphQL. |
| Number | 13156 |
Order total gross in EURO
The Order total gross (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Order total gross | Euro |
| 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 | orderSumGrossInEuro | The API identifier used in GraphQL. |
| Number | 13153 |
Order total net
The Order total net (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NOrdSum | The database field name. |
| API identifier | orderSumNetInCurrency | The API identifier used in GraphQL. |
| Number | 13147 |
Order total net (dom.)
Calculated when you save the order, displays the net order total in the current currency after line, group and total discounts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DNOrdSum | The database field name. |
| API identifier | orderSumNetDomestic | The API identifier used in GraphQL. |
| Number | 13154 |
Order total net in EURO
The Order total net (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Order total net | Euro |
| 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 | orderSumNetInEuro | The API identifier used in GraphQL. |
| Number | 13148 |
Order type
Defines how the order will be processed.
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 | Yes | This field is visible by default in the table display. |
| Domain | Order type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdTp | The database field name. |
| API identifier | orderType | The API identifier used in GraphQL. |
| Number | 13102 |
Order week
The order date as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | orderWeek | The API identifier used in GraphQL. |
| Number | 13104 |
Organisational unit 1
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 13131 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 13132 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 13133 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 13134 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 13135 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 13136 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 13342 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 13343 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 13344 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 13345 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 13346 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
Which organisational unit the order is to be linked to.
The fields appear with the name allocated in the organisational units fields in the Company information table.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 13347 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Original confirmed delivery date
When you save the order this field is filled in with the Confirmed delivery date, if not already filled in.
For offers this field is used as Validity date in standard layouts and printouts.
The date is validated using the regional settings in Windows.
| 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 | FCfDelDt | The database field name. |
| API identifier | originalConfirmedDeliveryDate | The API identifier used in GraphQL. |
| Number | 13315 |
Original confirmed delivery week
The Original confirmed delivery date field as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | originalConfirmedDeliveryWeek | The API identifier used in GraphQL. |
| Number | 13314 |
Original print destination
The print destination used when the invoice was approved.
- 1 - Print preview
- The print destination is ../../../business/auto/reference/r_gc_menuchoice_previewprintout.html.
- 2 - Print
- The print destination is ../../../business/auto/reference/r_gc_menuchoice_printtocurrentdestination.html.
- 3 - Override to printer
- Not used.
- 4 - Quick print
- The print destination is ../../../business/auto/reference/r_gc_menuchoice_quickprint.html.
- 5 - Print to PDF
- The print destination is ../../../business/auto/reference/r_gc_menuchoice_printtopdf.html.
- 6 - Send e-mail
- The print destination is ../../../business/auto/reference/r_gc_menuchoice_sendemail.html.
- 7 - Design Excel template
- Not used.
- 8 - Print to Excel
- Not used.
- 9 - Print to clipboard
- Not used.
- 10 - Print to file
- The print destination is ../../../business/auto/reference/r_gc_menuchoice_printtofile.html.
- 11 - Only approval
- The print destination is ../../../business/auto/reference/r_gc_menuchoice_onlyapproval.html.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Print destination | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrnDst | The database field name. |
| API identifier | originalPrintDestination | The API identifier used in GraphQL. |
| Number | 17704 |
Our ref.
A free information field, which you can edit out in printouts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Reference | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OurRef | The database field name. |
| API identifier | ourReference | The API identifier used in GraphQL. |
| Number | 13190 |
Pack units
How many separate packages the consignment consists of.
When you select Labels in the Order documents dialog box, the same number of labels is printed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Package | The database field name. |
| API identifier | packUnits | The API identifier used in GraphQL. |
| Number | 13228 |
Packing slip count
How many times Packing slips have been run for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PacCnt | The database field name. |
| API identifier | packingSlipCount | The API identifier used in GraphQL. |
| Number | 13266 |
Packing slip no.
The last document number of the Packing slips printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | PacNo | The database field name. |
| API identifier | packingSlipNo | The API identifier used in GraphQL. |
| Number | 13303 |
Page elem. no.
The actual page element against the Order table, in the layout used when the document was produced.
Refers together with the Layout no. field to the Window element table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | PgElNo | The database field name. |
| API identifier | pageElementNo | The API identifier used in GraphQL. |
| Number | 13099 |
Payment method
Payment method might be cash and bank giro.
Suggested on the basis of what is entered for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment method | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmtMt | The database field name. |
| API identifier | paymentMethod | The API identifier used in GraphQL. |
| Number | 13200 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment method | PaymentMethod |
|
Payment supplier no.
You complete this field if payment is to be made to someone other than the supplier for a purchase.
Suggested on the basis of the corresponding field in the Associate table for the supplier, and is used for d/c ledger entries.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | RmtSup | The database field name. |
| API identifier | remittanceSupplierNo | The API identifier used in GraphQL. |
| Number | 13194 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | RemittanceSupplier |
|
Payment terms
Suggested on the basis of what is entered for the customer/supplier.
The Payment terms field form the basis of the calculation of Due date field in invoices. If this field is empty, the Standard payment terms. field from the Company information table is used.
You can override the due date in orders and voucher lines, or later in the open entries.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment terms | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmtTrm | The database field name. |
| API identifier | paymentTerms | The API identifier used in GraphQL. |
| Number | 13197 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment term | PaymentTerms |
|
Period key
The period key that you want to copy to the voucher line.
The value in this field is copied to the order lines if a period key is not specified for the product specified in the order line. The product key overrides the period key specified in the order line. When you approve the invoices, the period key is copied to the voucher lines that apply to sales income and product costs based on what is specified in the VAT- and accounting information table.
It can be accrued "until the year-end" from the order. When invoicing in the current year for example for hire, licensing costs or subscriptions which end during the same calendar year (i.e. not the accounting year). The Accrual accounting to end of year choice is on the Processing/Processing method/Post processing menu choice in order lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period key | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrK | The database field name. |
| API identifier | periodKeyNo | The API identifier used in GraphQL. |
| Number | 15867 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Period key | PeriodKey |
|
Pick list count
How many times Pick lists have been run for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PicCnt | The database field name. |
| API identifier | pickListCount | The API identifier used in GraphQL. |
| Number | 13265 |
Pick list no.
The last document number of the Pick lists printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | PicNo | The database field name. |
| API identifier | pickListNo | The API identifier used in GraphQL. |
| Number | 13304 |
Post code
Filled in when you enter a customer/supplier number.
If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Post code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PNo | The database field name. |
| API identifier | postCode | The API identifier used in GraphQL. |
| Number | 13111 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Postal address | PostalAddress |
|
Postal area
Filled in when you enter a customer/supplier number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PArea | The database field name. |
| API identifier | postalArea | The API identifier used in GraphQL. |
| Number | 13112 |
Price from supplier no.
Suggested on the basis of what you have entered for the customer.
Makes it possible to calculate sales prices for specific customers or specific orders as purchase prices from a specified supplier plus a possible % supplement. At the same time the Cost price field is set equal to the Purchase price.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | PrSup | The database field name. |
| API identifier | priceFromSupplierNo | The API identifier used in GraphQL. |
| Number | 13279 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | PriceFromSupplier |
|
Price in % of cost
Complete this field if you want to set the current price to be a percentage of the Purchase price, e.g. 100 % to cover the full cost.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SaleCstP | The database field name. |
| API identifier | priceInPercentOfCost | The API identifier used in GraphQL. |
| Number | 13255 |
Prod. order counter
How many Production orders have been printed and approved for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdCnt | The database field name. |
| API identifier | productionOrderCount | The API identifier used in GraphQL. |
| Number | 13326 |
Prod. order no.
The production order number of the production order that was last printed and approved.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | ProdNo | The database field name. |
| API identifier | productionOrderNo | The API identifier used in GraphQL. |
| Number | 13325 |
Purchase count
How many times Purchase orders have been run for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PurcCnt | The database field name. |
| API identifier | purchaseCount | The API identifier used in GraphQL. |
| Number | 13262 |
Purchase order no.
The last document number of the Purchase orders printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | PurcNo | The database field name. |
| API identifier | purchaseOrderNo | The API identifier used in GraphQL. |
| Number | 13307 |
Quantity in basis unit
Displays the total for the corresponding field in the order line, and you can print the value in order documents using the @Order macro.
The field is related to the remaining quantities in the orders.
You can also print the values in the order lines for group discounts, group totals, structure heads and order totals by checking the Weight/dimensions on break lines box in the Order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | NoUn | The database field name. |
| API identifier | quantityInBasisUnit | The API identifier used in GraphQL. |
| Number | 13293 |
Quotation count
How many times Quotations have been run for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document counter | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OfCnt | The database field name. |
| API identifier | quotationCount | The API identifier used in GraphQL. |
| Number | 13263 |
Quotation no.
The last document number of the Quotations printed for the order.
The document numbers are retrieved from the voucher and document series in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | OfNo | The database field name. |
| API identifier | quotationNo | The API identifier used in GraphQL. |
| Number | 13306 |
Required delivery date
Suggested with the current date when you create the order.
The field is not suggested for purchase or production orders, or when you have selected Do not enter required delivery date when entering data under Calculate delivery date in the Company information table. If this field has been filled in, the value is suggested in newly entered order lines.
The date is validated using the regional settings in Windows.
| 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 | DelDt | The database field name. |
| API identifier | requiredDeliveryDate | The API identifier used in GraphQL. |
| Number | 13185 |
Required delivery week
The Required delivery date field as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | requiredDeliveryWeek | The API identifier used in GraphQL. |
| Number | 13186 |
Requisition no.
A free information field, which you can edit out in printouts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Requisition no. | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ReqNo | The database field name. |
| API identifier | requisitionNo | The API identifier used in GraphQL. |
| Number | 13192 |
Responsible
Suggested on the basis of what is entered for the customer/supplier.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Rsp | The database field name. |
| API identifier | official | The API identifier used in GraphQL. |
| Number | 13117 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Official |
|
Rounding
Calculated in the current currency when saved.
You define which rounding rules will apply in the Currency table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Trunc | The database field name. |
| API identifier | roundingInCurrency | The API identifier used in GraphQL. |
| Number | 13222 |
Rounding (dom.)
The amount from the Rounding field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DTrunc | The database field name. |
| API identifier | roundingDomestic | The API identifier used in GraphQL. |
| Number | 13224 |
Rounding in EURO
The amount from the Rounding field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Rounding | Euro |
| 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 | roundingInEuro | The API identifier used in GraphQL. |
| Number | 13223 |
Sales price addition %
A percentage value that is suggested on the basis of what you have entered for the customer.
Sales prices can then be calculated for specific customers or specific orders, and a percentage addition from this field is applied to the purchase prices from a specified supplier in the Price from supplier no. field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SPrAdd | The database field name. |
| API identifier | salesPriceAddition | The API identifier used in GraphQL. |
| Number | 13280 |
Seller/buyer
The Empl. no. field in the Associate table.
It is suggested on the basis of what is entered for the customer/supplier.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SelBuy | The database field name. |
| API identifier | sellerOrBuyer | The API identifier used in GraphQL. |
| Number | 13116 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | SellerOrBuyer |
|
Sent date
The date on which the products were sent from the supplier for purchases.
You must complete the field manually. The date is not suggested in order lines. This field is filled in when you use the Sent processing. The date is not suggested for order lines, and does not affect the Sent from supplier check box under Order status or Order line status.
The date is validated using the regional settings in Windows.
| 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 | RlDelDt | The database field name. |
| API identifier | sentDate | The API identifier used in GraphQL. |
| Number | 13317 |
Sent week
The Sent date field expressed as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | sentWeek | The API identifier used in GraphQL. |
| Number | 13316 |
Settlem. date
The highest date for when the order was settled.
When approving settlement invoices, both the Settlem. date and Invoice date fields are filled in. The Invoice date is not put back if you perform a settlement on an earlier date.
The date is validated using the regional settings in Windows.
| 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 | LstSetDt | The database field name. |
| API identifier | settlementDate | The API identifier used in GraphQL. |
| Number | 13210 |
Settlem. week
The Settlem. date field expressed as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | 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 | settlementWeek | The API identifier used in GraphQL. |
| Number | 13211 |
Ship to associate no.
Who is to receive the goods, if this associate differs from the content of the fields for Send to associate no., Cust. no., Send in to associate no. and us.
This field is updated with the value in the Ship to associate no. field for the customer/supplier in the Associate table. You can override the value in the field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ShpActNo | The database field name. |
| API identifier | shipToAssociateNo | The API identifier used in GraphQL. |
| Number | 13355 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ShipToAssociate |
|
Sp. tax amount
The Sp. tax amount (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SpcTxAm | The database field name. |
| API identifier | specialTaxAmountInCurrency | The API identifier used in GraphQL. |
| Number | 13229 |
Sp. tax amount (dom.)
The special tax amount in the current currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DSpcTxAm | The database field name. |
| API identifier | specialTaxAmountDomestic | The API identifier used in GraphQL. |
| Number | 13231 |
Sp. tax amount in EURO
The Sp. tax amount (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Sp. tax amount | Euro |
| 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 | specialTaxAmountInEuro | The API identifier used in GraphQL. |
| Number | 13230 |
Sup. no.
The supplier number for purchases.
You can call up a supplier by opening or searching among the suppliers in the Associate table. You can also override the Sup. no. in the order lines.
Values are suggested in a number of fields on the basis of the information entered for the supplier in the Associate table. This applies to:
- Name
- Address line 1 - Address line 4
- Post code and Postal area
- Country no.
- Language no.
- Organisational unit 1 - Organisational unit 12
- Seller/buyer
- Responsible
- Total disc. %
- Delivery associate no.
- Payment supplier no.
- Your ref.
- Document delivery method 1 and Document delivery method 2
| 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 | 13115 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Tare
The total for the corresponding field in the order lines, and you can print the value in order documents using the @Order macro.
The field is related to the remaining quantities in the orders.
You can also print the values in the order lines for group discounts, group totals, structure heads and order totals by checking the Weight/dimensions on break lines box in the Order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Tare | The database field name. |
| API identifier | tare | The API identifier used in GraphQL. |
| Number | 13286 |
Test result
Test results are based on the credit control setting in the Company information table.
The result of the credit control test is saved in this field.
- Credit denied
- Credit limit
- Overdue invoices
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Test result | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TestRes | The database field name. |
| API identifier | testResult | The API identifier used in GraphQL. |
| Number | 13319 |
Ton rate
You can then select one of the four ton rates which will apply for the current associate.
You can perform lookups in the field and access values you have entered in the Transport agreement table. In the Transport agreement table there are fields for Ton rate 1 - Ton rate 4.
- 1 - Ton rate 1
- 2 - Ton rate 2
- 3 - Ton rate 3
- 4 - Ton rate 4
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Ton rate | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TonRt | The database field name. |
| API identifier | tonRate | The API identifier used in GraphQL. |
| Number | 13341 |
Total before gr. disc.
The Total before gr. disc. (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdSumT | The database field name. |
| API identifier | sumBeforeGroupDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 13160 |
Total before gr. disc. (dom.)
This is a control total field containing the total remaining amount in the current currency, minus line and total discounts but not group discounts, VAT, special tax or invoice fee.
This field is updated continuously when you enter and change prices, quantities and line and total discounts, and delete order lines. The field is recalculated when you save.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DOrdSumT | The database field name. |
| API identifier | sumBeforeGroupDiscountDomestic | The API identifier used in GraphQL. |
| Number | 13163 |
Total before gr. disc. in EURO
The Total before gr. disc. (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Total before gr. disc. | Euro |
| 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 | sumBeforeGroupDiscountInEuro | The API identifier used in GraphQL. |
| Number | 13161 |
Total before total- and gr. disc.
The total in standard currency before total and group discount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdSum | The database field name. |
| API identifier | sumBeforeTotalAndGroupDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 13159 |
Total before total- and gr. disc. (dom.)
The total before total and group discount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DOrdSum | The database field name. |
| API identifier | sumBeforeTotalAndGroupDiscountDomestic | The API identifier used in GraphQL. |
| Number | 13162 |
Total disc. %
Suggested on the basis of what you have entered for the customer/supplier, and displays the total discount as a percentage.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TotDcP | The database field name. |
| API identifier | totalDiscountPercent | The API identifier used in GraphQL. |
| Number | 13140 |
Total discount amount
The Total before gr. disc. (dom.) field converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TotDcAm | The database field name. |
| API identifier | totalDiscountAmountInCurrency | The API identifier used in GraphQL. |
| Number | 13141 |
Total discount amount (dom.)
In addition to, or instead of, using a percentage you can enter a discount amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TotDcDAm | The database field name. |
| API identifier | totalDiscountAmountDomestic | The API identifier used in GraphQL. |
| Number | 13143 |
Total discount amount in EURO
The Total before gr. disc. (dom.) field converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Total discount amount | Euro |
| 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 | totalDiscountAmountInEuro | The API identifier used in GraphQL. |
| Number | 13142 |
Trade area
Specifies whether the customer/supplier is domestic, in another EU country or outside the EU/abroad.
Suggested on the basis of the Trade area field in the Associate table. See the more detailed explanation in the Associate table.
When registering orders Trade area is checked. If it is 1 - Non-taxable domestic, the price is calculated without VAT. The sales price is reduced by the value of the VAT code selected in the Price- and discount matrix. The remainder is the gross sales price.
You can enter the VAT code by which the gross price will be reduced in the Price- and discount matrix table in the Gross price tax code field. The function has only been implemented for Gross prices = 1 Sales price. It is a condition that the Trade area field has been filled in.
If you want to read more about how the VAT code for the invoice fee is calculated, see under the Invoice fee VAT code field in the Country table.
When this field has been filled in (with a value other than 0) this means that VAT will not be calculated on orders. 0 appears blank. The area code determines which of the account references for taxable, non-taxable domestic, EU and export/import are to be used in connection with sales, discounts, additions, special taxes and purchases in the Tax- and accounting inf. table, and invoice fees in the Currency table. If the product is not taxable and the associate is domestic, the account references for non-taxable are used regardless. This is an exception from the rule that the VAT follows the product. For example, the VAT rules of a country may require VAT to be invoiced to the customer if the product goes to another EU country but the invoice stays in the same country. If the Delivery associate number has Trade area 2, 4 or 5 in the Associate table, but Trade area 0 is within the trade area of the order, the system does not overwrite the value. Otherwise, the value in Delivery associate number overwrites the values from the Invoice customer number field.
The Order processing 2 field contains the parameter Do not overwrite trade area and EU VAT with local VAT, which you should use in combination with the Trade area and VAT codes from delivery associate number option. When you have set these parameters, Business NXT will calculate the VAT from the Delivery associate number when invoicing.
The area codes apply to both customers and suppliers, unless otherwise stated.
The area code forms the basis when Business NXT selects the turnover class of the vouchers.
- 0 - Taxable domestic according to VAT- and accounting inf./VAT code
- 1 - Non-taxable domestic
- 2 - Within other EU country
- only relevant if the company is located in an EU country
- 3 - Outside EU/Abroad
- applies to all other foreign associates
- 4 - Subsidiary in another EU country
- only relevant for customers, only relevant if the company is located in an EU country, treated in the same way as 2 in respect of account references
- 5 - Transfer between other EU countries
- only relevant for suppliers, only relevant if the company is located in an EU country, treated in the same way as 2 in respect of account references
- 6 - Consuming of products
- 7 - Reversed domestic tax
- 8 - Rent income voluntary
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trade area | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExVat | The database field name. |
| API identifier | tradeArea | The API identifier used in GraphQL. |
| Number | 13145 |
Trans. group 1
These are free group fields that you can override in the order lines.
The fields are carried forward to the Product transaction table. You define valid transaction groups in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr | The database field name. |
| API identifier | transactionGroup1 | The API identifier used in GraphQL. |
| Number | 13118 |
Trans. group 2
These are free group fields that you can override in the order lines.
The fields are carried forward to the Product transaction table. You define valid transaction groups in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr2 | The database field name. |
| API identifier | transactionGroup2 | The API identifier used in GraphQL. |
| Number | 13259 |
Trans. group 3
These are free group fields that you can override in the order lines.
The fields are carried forward to the Product transaction table. You define valid transaction groups in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr3 | The database field name. |
| API identifier | transactionGroup3 | The API identifier used in GraphQL. |
| Number | 13300 |
Trans. group 4
These are free group fields that you can override in the order lines.
The fields are carried forward to the Product transaction table. You define valid transaction groups in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 4 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr4 | The database field name. |
| API identifier | transactionGroup4 | The API identifier used in GraphQL. |
| Number | 13301 |
Transaction type
The various ways in which goods can move in and out of the warehouse.
- 1 - Sales
- Normal sale.
The goods move out of the warehouse.
- 2 - Hire
- Hire against payment.
The goods move out of the warehouse.
- 3 - Loan
- Loan of goods without payment.
The goods move out of the warehouse.
- 4 - Adjustment/internal issue
- Registration of goods that have been lost.
The goods move out of the warehouse.
- 5 - Further processing
- Internal consumption of goods for further processing.
The goods move out of the warehouse.
- 6 - Purchase
- Goods that are purchased from other parties.
The goods move into of the warehouse.
- 7 - Production
- Goods produced by the company itself.
The goods move into of the warehouse.
- 8 - Stock transfer
- Transfer of stock between the company's own warehouses.
You can also use this transaction type when performing a stock transfer of unrealised transactions. It is not possible to reserve or finish inflow transactions on stock transfer orders.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Transaction type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrTp | The database field name. |
| API identifier | transactionType | The API identifier used in GraphQL. |
| Number | 13101 |
Transf. to warehouse
You can use this field for warehouse transfers, even for hire/loan orders if the products have been returned to a different warehouse from the one from which they were taken.
If this field is empty, the Warehouse no. field is used. This means that you must change the sequence of the shipments in the same warehouse when performing a transfer, and return the products to the same warehouse from which they were taken in the case of hire/loan orders.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ToStc | The database field name. |
| API identifier | transferToWarehouseNo | The API identifier used in GraphQL. |
| Number | 13179 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | TransferToWarehouse |
|
Transp. agr. no.
The supplier's transport agreement number.
You can refer to the Transport agreement table. The Transp. agr. no. field will be copied to the same field on the order lines. The field will also be updated in the Product transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transp. agr. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TspAgrNo | The database field name. |
| API identifier | transportAgreementNo | The API identifier used in GraphQL. |
| Number | 13339 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Transport agreement | TransportAgreement |
|
VAT amount
The VAT amount in the current currency, which is calculated when you save the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatAm | The database field name. |
| API identifier | vatAmountInCurrency | The API identifier used in GraphQL. |
| Number | 13150 |
VAT amount (dom.)
The VAT amount converted into the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DVatAm | The database field name. |
| API identifier | vatAmountDomestic | The API identifier used in GraphQL. |
| Number | 13155 |
VAT amount in EURO
The VAT amount converted into EUROS.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | VAT amount | Euro |
| 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 | vatAmountInEuro | The API identifier used in GraphQL. |
| Number | 13151 |
VAT code
Link to the VAT code table. It is suggested on the basis of what is entered for the customer/supplier.
If this field is empty the VAT code sales/VAT code purch. fields from the VAT- and accounting information table are used.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VAT code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ObVatNo | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 13144 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
Volume
Displays the total for the corresponding field in the order lines, and you can print the value in order documents using the @Order macro.
The field is related to the remaining quantities in the order.
You can also print the values in the order lines for group discounts, group totals, structure heads and order totals by checking the Weight/dimensions on break lines box in the Order documents dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | Vol | The database field name. |
| API identifier | volume | The API identifier used in GraphQL. |
| Number | 13290 |
Wage rate no.
The basis when referring to the Price- and discount matrix.
You can override this field in the order lines. You can define valid wage rate numbers in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Wage rate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WageRtNo | The database field name. |
| API identifier | payrollRateNo | The API identifier used in GraphQL. |
| Number | 13221 |
Warehouse no.
Which warehouse the goods are located in or are to be delivered to.
It is suggested on the basis of:
- the recipient for sale/hire/loan orders
- the supplier or the recipient for purchases
When creating a new order, the Default warehouse from the Company information table is entered in the Warehouse no. field. If a warehouse is not specified, warehouse number 1 is used, which is the default warehouse. If you select Warehouse from product in Company information, the product's normal warehouse will be suggested in the order lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrStc | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 13178 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | Warehouse |
|
Web page
When you enter the customer number/supplier number in the order, the value from the Web page 1 field in the Associate table is suggested in this field.
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) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 13338 |
Your ref.
A free information field, which you can edit out in printouts.
Suggested on the basis of what you have entered for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Reference | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | YrRef | The database field name. |
| API identifier | yourReference | The API identifier used in GraphQL. |
| Number | 13191 |
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. |