Reservation
This table functions as a link between order lines, pick lists, shipments and transactions. If you want full follow-up on serial numbers, you use this table to update shipments with serial numbers for stock increases and decreases.
You can choose to join it to order lines during order entry unless the entire quantity in the order line is to be processed in the same way. You may do this, for example, if you need to reserve from various shipments on stock reduction or split up into several shipments on stock increase. On stock increase, information is transferred from the Reservation or Order line table to the shipments and the other way on stock reduction.
You can also join the Reservation table to the Pick list table to see which reservations the various pick lists cover.
Reservations are created when you save purchase and production orders, and at the same time a shipment and a product transaction are created. Allocated orders are also given a reservation when saved, as these must increase reserved from inflow/warehouse and reduce the available quantity.
If you part finish or part invoice an order line, reservations are reduced by the part finished/invoiced quantity and form a new shipment and product transaction, and the original reservation, shipment and product transaction are corrected by the finished quantity.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | Rsv | The table name in the database. |
| API identifier | reservation | The API identifier used in GraphQL. |
| Table no. | 129 | The table number in the data model. |
The following fields exist in this table:
Accounting document no.
The accounting document no refers to Incoming accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InAcDocNo | The database field name. |
| API identifier | incomingAccountingDocumentNo | The API identifier used in GraphQL. |
| Number | 17965 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
Actual return date
The date on which the return of goods has taken place.
In the Order and the Order line table there is Expected return date field, in which you enter the date when the return is expected to take place.
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 |
| SQL name | RlRetDt | The database field name. |
| API identifier | actualReturnDate | The API identifier used in GraphQL. |
| Number | 5022 |
Actual return week
The value in the Actual return date field presented as week 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 |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | actualReturnWeek | The API identifier used in GraphQL. |
| Number | 5657 |
Alloc. order line no.
Only used for sales orders and goods consumption lines for a production. Points to the line number of the purchase/production order to which it is allocated.
The value is filled in when running the Generate purchase/production orders processing in the Order table, or manually enter an order number in the Allocated order no. field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LnPurcNo | The database field name. |
| API identifier | allocatedOrderLineNo | The API identifier used in GraphQL. |
| Number | 17666 |
Allocated order no.
Used to link a sales order line to a specific purchase or production order.
The value is filled in when running the Generate purchase/production orders processing in the Order table. By deleting the contents of this field, the allocation is withdrawn.
Order lines can be joined to purchase orders via allocated order numbers to see which sales order lines are allocated to them.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| SQL name | PurcNo | The database field name. |
| API identifier | allocatedOrderNo | The API identifier used in GraphQL. |
| Number | 17665 |
Balance to pick
The difference between the total quantity and what previously has been picked.
This is the maximum quantity which is available for picking and is also the quantity suggested when printing pick lists.
When the structure head is exempted from warehousing, the picked quantity is saved in the structure head. The Balance to pick field is then also calculated. If the Finish picked quantity with menu choice check box in the Proc. method 1 field is selected, the structure head will also be finished when finishing the picked quantity.
If the box to Pick same fraction of structure lines and the Pick complete structure check boxes in the Proc. method 1 field both are selected, the picked quantity is calculated as the share which has been picked. Otherwise the full quantity applies.
| 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | balanceToPick | The API identifier used in GraphQL. |
| Number | 4971 |
Compensate
How much of the finished quantity must be compensated in a hire or loan order for this Reservation record.
The value is accumulated on the order line that this reservation belongs to.
| 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 | NoComp | The database field name. |
| API identifier | compensate | The API identifier used in GraphQL. |
| Number | 4470 |
Compensate NOW
How much, if any, the customer must compensate now of the products returned from hire or loan.
When you save the value in this field reduces the stock level and is accumulated in the Lost field in the Shipment table and updates the Compensate field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | CompN | The database field name. |
| API identifier | compensateNow | The API identifier used in GraphQL. |
| Number | 5018 |
Cost currency no.
The cost currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | CstCur | The database field name. |
| API identifier | costCurrencyNo | The API identifier used in GraphQL. |
| Number | 4879 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | CostCurrency |
|
Cost exchange rate
The currency for the costs prices.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | CstExRt | The database field name. |
| API identifier | costExchangeRate | The API identifier used in GraphQL. |
| Number | 4880 |
Cost price
The cost price for the product , in the actual currency.
The cost price in production orders is updated when the invoice is received, if the product has a new price when it is purchased.
The cost price is retrieved from the Average cost price field in the Stock balance table when order lines have transaction type:
- 1 - Sales
- 2 - Hire
- 3 - Loan
- 4 - Adjustment/internal issue
- 5 - Further processing
The cost price is retrieved from the Average cost price field in the Price- and discount matrix table, if have not:
- selected the Cost price from the price and discount matrix if sold out field under Price/discount processing in the Company information table
- 0.00 in the Average cost price field in the Stock balance table
and the order lines have transaction type:
- 6 - Purchase
- 7 - Production
Reservations are updated correctly upon reservation. If you have selected the Calculate avg. cost price on the order line field under Processing method or in the Company information table, the order line is updated with the average cost price from reservations.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | CCstPr | The database field name. |
| API identifier | costPriceInCurrency | The API identifier used in GraphQL. |
| Number | 4732 |
Cost price (dom.)
The cost price for the product , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | CstPr | The database field name. |
| API identifier | costPriceDomestic | The API identifier used in GraphQL. |
| Number | 4881 |
Cost price addition (dom.)
Displays the calculated Cost price addition in domestic amount.
- Cost price addition distributed from the order head calculated based on the values set in the Order table fields Cost price addition (dom.) and Freight processing
- Cost price addition % calculated from Price and currency rate on the order line
| 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 | DCstAd | The database field name. |
| API identifier | costPriceAdditionDomestic | The API identifier used in GraphQL. |
| Number | 16205 |
Customs
The customs duty for the product.
For purchase order lines, the original value in the field is suggested based on the value in the Delivery alternative table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount or percent | Decimal |
| SQL name | Cus | The database field name. |
| API identifier | customs | The API identifier used in GraphQL. |
| Number | 6473 |
Discard NOW
How much, if any, of the product is not to be returned to the warehouse and must be discarded now when the product is returned from hire or loan.
When you save the value in this field reduces the stock level and is accumulated in the Lost field in the Shipment table and updates the Discarded field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | ScrN | The database field name. |
| API identifier | discardNow | The API identifier used in GraphQL. |
| Number | 5019 |
Discarded
How much of the product is not returned to the warehouse and are discarded now when the product is returned from hire or loan.
| 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 | NoScr | The database field name. |
| API identifier | discarded | The API identifier used in GraphQL. |
| Number | 4472 |
Finish at
The time of the last finish in the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| SQL name | FinTm | The database field name. |
| API identifier | finishAt | The API identifier used in GraphQL. |
| Number | 6741 |
Finish date
The date when the order was last finished.
When finishing the current date is always used for the transactions. You can override the value by entering manually in the Manual finish 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 |
| SQL name | RlDelDt | The database field name. |
| API identifier | finishDate | The API identifier used in GraphQL. |
| Number | 4526 |
Finish NOW
How much, if any, you will like to finish now.
When you save the quantity is updated in the Finished field.
Limitations to changing the field
- You enter an order line and complete the Product no. and
Quantity
fields.
This requires saving before finishing and applies to all transaction types.
- The shipment in the order line is undergoing stocktaking.
You will be notified with an error message in the Status bar.
- The customer has a credit limit or credit suspension, and the credit control is
active.
This requires saving before finishing. You will be notified with an error message in the Status bar.
- When you have expanded a structure.This requires saving before finishing. You will be notified with an error message in the Status bar.Note:If you have performed a selection of order lines, for example to show only the structure head on a production order, and parameters are defined to finish from the structure head, the hidden lines are processed and finishing is performed for the hidden lines. You are not given a message if something cannot be finished in the hidden lines because it is not available in stock.
Finish 0 and release reservations
If you enter 0 in the field and finish, the reservation is withdrawn and you can print a new pick list. The Finish 0 and release reservations check box in the Order line status field is temporary selected. After saving or processing of the order, the check box is cleared. It is only stored temporarily so that the system can read keying of the value 0 as a 0 entry, because the default value in the field is also 0.
There is also a corresponding field in the Reservation table, but this field does not have the same logic for 0 entry.
Finish negative numbers
You are allowed to finish a negative quantity if you have selected the Delete rest when filling in "Finish NOW" check box on the Editing page in the Processing method field. This causes the total quantity to be reduced. If you want to withdraw the quantity and keep it for a later interim delivery, you must deselect Delete rest when filling in "Finish NOW", otherwise the quantity will be reset to zero.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | FinN | The database field name. |
| API identifier | finishNow | The API identifier used in GraphQL. |
| Number | 4975 |
Finish week
The date when the order was last finished saved as day of week 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 |
| 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 | 5655 |
Finished
How much of the total quantity that has been finished.
The value in this field constitutes the total of the values in the Finished field in the relevant rows in the Reservation table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | NoFin | The database field name. |
| API identifier | finished | The API identifier used in GraphQL. |
| Number | 4976 |
Finished by
The name of the person who last finished something in the order line.
| 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 | 6127 |
Freight 1
These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.
See also: Delivery alternative
The value in these fields are shown per unit and in the default currency.
When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | Fr | The database field name. |
| API identifier | freight1 | The API identifier used in GraphQL. |
| Number | 6469 |
Freight 2
These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.
See also: Delivery alternative
The value in these fields are shown per unit and in the default currency.
When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | Fr2 | The database field name. |
| API identifier | freight2 | The API identifier used in GraphQL. |
| Number | 6470 |
Freight 3
These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.
See also: Delivery alternative
The value in these fields are shown per unit and in the default currency.
When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | Fr3 | The database field name. |
| API identifier | freight3 | The API identifier used in GraphQL. |
| Number | 6471 |
Freight 4
These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.
See also: Delivery alternative
The value in these fields are shown per unit and in the default currency.
When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| SQL name | Fr4 | The database field name. |
| API identifier | freight4 | The API identifier used in GraphQL. |
| Number | 6472 |
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) |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 13782 |
Invoice NOW
You can use this field when you receive invoices for parts of a purchase order line.
When you save the quantity is updated in the Invoiced/realised field.
You cannot invoice more than what is finished and not previously realised.
It is not permitted to withdraw realisation. If necessary, you must do this via crediting.
This field is blocked for use by production orders and you can only approve (receive invoice) for the entire production. You must do this from the order head.
| 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 | RlzN | The database field name. |
| API identifier | invoiceNow | The API identifier used in GraphQL. |
| Number | 5007 |
Invoiced/realised
How much of the finished quantity has been invoiced or realised.
The value in this field constitutes the total of the values in the Invoiced/realised field in the relevant rows in the Reservation table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | NoRlz | The database field name. |
| API identifier | invoicedOrRealised | The API identifier used in GraphQL. |
| Number | 4337 |
Line no.
The value in the Line no. field of the order line that this reservation belongs to.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Order no., Line no., Rsv. no. |
| SQL name | OrdLnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 3037 |
Location
The item's location, for example a shelf number and rack number.
If you double-click or press * in the field, you will be referred to the Location or Item location table, depending of which table you have chosen to look up in the Reservation processing in the Company information table, where you can see the physical appearance and location of the item.
If you have not selected Use location control in Reservation processing in the Company information table, you are only given a warning that the location cannot be found, but you can also decide yourself what should be here.
The location for goods you receive and the value is included in shipments. In increase order lines, the location is suggested as the normal location from the Stock balance table. You can edit them in the Shipment table later. If you need more values, you can join to the Reservation table and enter a value in the equivalent field there and, if necessary, split the shipments afterwards.
When a stock transfer is performed, the value in the Location field in the Order line table is selected ahead of the value in the Location field from the Shipment from which it is picked.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Location | Text (18) |
| SQL name | Loc | The database field name. |
| API identifier | location | The API identifier used in GraphQL. |
| Number | 3718 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Location | Location |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Order jour. no.
The number of the order journal produced when creating the reservation.
When a product transaction is created from an order line, it is assigned a unique order journal number. The Reservation record is updated with this number together with the transaction number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | JNo | The database field name. |
| API identifier | orderJournalNo | The API identifier used in GraphQL. |
| Number | 4338 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product transaction | ProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Order no.
The order.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Order no. | Integer |
| Primary key | Yes | Order no., Line no., Rsv. no. |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 3036 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
| ||
| Order line | OrderLine |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Pick list | PickList |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Packed
How much of the finished quantity has been printed and approved in packing slips.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | NoPac | The database field name. |
| API identifier | packed | The API identifier used in GraphQL. |
| Number | 16509 |
Pick list no.
The number of the pick list that has been produced from this reservation.
When pick lists are printed, the reservation rows are given a pick list number. This is used in connection with any subsequent finishing in accordance with the pick list or withdrawal of the pick list. You can then join the Reservation record to the Pick list 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 | PicRunNo | The database field name. |
| API identifier | pickListNo | The API identifier used in GraphQL. |
| Number | 3731 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Pick list | PickList |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Pick NOW
How much, if any, you will like to pick now without printing pick list or if you want to pick a specific quantity or as a check against it.
Not in use.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | PicN | The database field name. |
| API identifier | pickNow | The API identifier used in GraphQL. |
| Number | 4972 |
Picked
How much of the total quantity that has been picked.
The value in this field constitutes the total of the values in the Picked field in the relevant rows in the Reservation table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | NoPic | The database field name. |
| API identifier | picked | The API identifier used in GraphQL. |
| Number | 4730 |
Picture file name
A link to the picture file for the order line.
The picture file is copied from the from the product to the order line if the Copy picture from product check box on the Misc. page in the Proc. method 1 field is selected.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| SQL name | PictFNm | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 8668 |
Product no.
The product for the line.
When you type in a product number in the order lines, the associated description is suggested in the Description field. You can change the description if you wish.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 15372 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
| ||
| Stock balance | StockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | ToStockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Shipment | TransferToShipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Quantity
The quantity you want to reserve.
For stock increase orders, it determines the size of the shipments you want to split the order line into.
If you want to reserve the entire quantity on the order line from the same shipment, you can do this directly on the order line. The Reserved field is then increased by the quantity which can be reserved. The quantity which cannot be reserved is deducted from the Quantity field so that Quantity = Reserved + Invoiced/realised - Finished.
The Quantity field is reduced on finishing in such a way that the outstanding quantity is displayed on the reservation line.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Num | The database field name. |
| API identifier | quantity | The API identifier used in GraphQL. |
| Number | 3040 |
Realisation journal no.
The number of the realisation journal created for the part of the order that this reservation represents.
When a reservation is realised, it is assigned a realisation journal number, which you can find in the accounts together with the transaction number of the product transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| SQL name | RealJNo | The database field name. |
| API identifier | realisationJournalNo | The API identifier used in GraphQL. |
| Number | 13896 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | RealisationJournal |
|
Reserved
How much of the total quantity that is reserved. Calculated on the basis of the values in the Reserved from stock and Reserved from inflow fields.
If goods are returned, discarded, replaced or invoiced/realised, reservations are cancelled.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| 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 | reserved | The API identifier used in GraphQL. |
| Number | 15954 |
Reserved from inflow
How much of the total quantity that is reserved from inflow; the total of the values in the Reserved from inflow field in the relevant rows in the Reservation table.
| 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 | NoRsvInc | The database field name. |
| API identifier | reservedFromInflow | The API identifier used in GraphQL. |
| Number | 15955 |
Reserved from stock
How much of the total quantity that is reserved from stock; the total of the values in the Reserved from stock field in the relevant rows in the Reservation table.
If goods are returned, discarded, replaced or invoiced/realised, reservations are cancelled.
| 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 | NoRsv | The database field name. |
| API identifier | reservedFromStock | The API identifier used in GraphQL. |
| Number | 4336 |
Return NOW
How much, if any, you will like to return now from hire or loan without running the Returned processing in the Order, Order line or Reservation table.
When you save the quantity is updated in the Returned field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | RetN | The database field name. |
| API identifier | returnNow | The API identifier used in GraphQL. |
| Number | 5017 |
Returned
How much has been returned from hire or loan.
| 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 | NoRet | The database field name. |
| API identifier | returned | The API identifier used in GraphQL. |
| Number | 4468 |
Rsv. no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Order no., Line no., Rsv. no. |
| SQL name | SeqNo | The database field name. |
| API identifier | reservationNo | The API identifier used in GraphQL. |
| Number | 3038 |
Scan doc. no.
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PLDNo | The database field name. |
| API identifier | scanDocumentNo | The API identifier used in GraphQL. |
| Number | 11975 |
Scan status
The status of the scanned document.
Is used in connection with Visma Document Center.
- 1 - Scanned document
- 2 - Document on flow
- 4 - Document finished
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Scan status | Integer |
| SQL name | PLDFlow | The database field name. |
| API identifier | scanStatus | The API identifier used in GraphQL. |
| Number | 11976 |
Serial no.
The serial number for goods you receive and the number is included in shipments.
When you enter a serial number in the field, the shipment is updated with the lowest shipment number that this serial number matches.
When you enter the shipment number and the serial number is loaded, there is no check on the serial number. If you re-renter the serial number, a check is performed on the serial number.
If you have set up the product to produce a shipment for each serial number when stock increases, or to produce a reservation for each serial number when stock is reduced, and the Quantity field is greater than 1, you must enter the serial number in the reservation lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Serial no. | Text (40) |
| SQL name | SerNo | The database field name. |
| API identifier | serialNo | The API identifier used in GraphQL. |
| Number | 3717 |
Shipment no.
The shipment from which the goods are taken or to which the goods are delivered. The field contains no value if it is not overridden, as this information is contained in the Reservation table.
If the product is set up as a serial no. product and with a check in Calculate Finish NOW when entering serial no. in the Processing method dialog box, this will also retrieve the respective shipment for this serial number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Shipment no. | Integer |
| SQL name | ShpNo | The database field name. |
| API identifier | shipmentNo | The API identifier used in GraphQL. |
| Number | 3039 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Shipment Trans Info 1
Additional information from the shipment being used for this reservation.
This value in these fields are transferred from the corresponding record in the Shipment table when the reservation row is created. This information will then be updated in the Product transaction table upon realisation.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (22) |
| SQL name | TrInf1 | The database field name. |
| API identifier | shipmentTransactionInformation1 | The API identifier used in GraphQL. |
| Number | 11834 |
Shipment Trans Info 2
Additional information from the shipment being used for this reservation.
This value in these fields are transferred from the corresponding record in the Shipment table when the reservation row is created. This information will then be updated in the Product transaction table upon realisation.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (22) |
| SQL name | TrInf2 | The database field name. |
| API identifier | shipmentTransactionInformation2 | The API identifier used in GraphQL. |
| Number | 11835 |
Sort seq. no.
The order of the lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 3041 |
Total quantity
The total invoiceable/realisable quantity, which is the sum of the outstanding quantity and the finished quantity.
The field assumes the value you enter in the Quantity field and remains unchanged when you finish. If you increase or reduce the value in the Quantity field, the Total quantity field is also changed.
| 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | totalQuantity | The API identifier used in GraphQL. |
| Number | 5000 |
Trans. no.
The product transaction associated with this reservation record.
When a product transaction is created on an order line, it is also assigned a unique order journal entry. The reservation is updated with this number together with the Trans. no. field , so that it can update the correct product transaction when there are changes in status and values from the order line.
| 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 | TrNo | The database field name. |
| API identifier | transactionNo | The API identifier used in GraphQL. |
| Number | 4339 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product transaction | ProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Transaction type
The transaction type for the product defining the way the goods move in or 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 | No | This field is not 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 | 15459 |
Transf. jour. no.
The order journal entry that represents a stock transfer.
On finishing, references to the Product transaction table are placed in this field. This makes it possible to correct or delete product transactions in the future.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrfJNo | The database field name. |
| API identifier | transferToJournalNo | The API identifier used in GraphQL. |
| Number | 4765 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product transaction | TransferToProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Transf. shipment no.
Can be used in connection with stock transfers and hire/loan, if you need to return the goods to a shipment other than the one from which they were taken.
Using this field you can reserve an order line for a specific shipment during order entry. If the entire quantity cannot be reserved for the same shipment, you can join to the Reservation table and reserve for as many shipments as you want.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Shipment no. | Integer |
| SQL name | TrfShpNo | The database field name. |
| API identifier | transferToShipmentNo | The API identifier used in GraphQL. |
| Number | 4344 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Shipment | TransferToShipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Transf. to location
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Location | Text (18) |
| SQL name | ToLoc | The database field name. |
| API identifier | transferToLocation | The API identifier used in GraphQL. |
| Number | 16409 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Location | StockTransferLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Transf. to warehouse
Overrides the equivalent field in the order head and you can use it for stock transfers or hire/loan if the goods are returned to a warehouse other than the one from which they were taken.
| 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 | 15978 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Location | StockTransferLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | ToStockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Warehouse | ToWarehouse |
| ||
| Shipment | TransferToShipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Transf. trans. no.
The product transaction that represents a stock transfer.
When a stock transfer order is finished, a product transaction is created. This field will then receive the value of the Trans. no. field for that product transaction.
| 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 | TrfTrNo | The database field name. |
| API identifier | transferToTransactionNo | The API identifier used in GraphQL. |
| Number | 4766 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product transaction | TransferToProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Use by date
The use by date for goods you receive.
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 |
| SQL name | DurDt | The database field name. |
| API identifier | useByDate | The API identifier used in GraphQL. |
| Number | 4763 |
Use by week
The use by date for goods you receive saved as day of week 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 |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | useByWeek | The API identifier used in GraphQL. |
| Number | 5656 |
Visma ID
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 11974 |
Warehouse no.
The warehouse owns the shipment that this reservation is placed on.
When you enter a value in the Delivery associate no. field, the warehouse number is suggested.
Increase order lines that do not have reservation rows, for example credit orders with transaction type 1 - Sales, are not blocked from changing the warehouse number.
You can change the Warehouse no. on order lines that lead to a stock increase as long as it has not be reserved by other orders, or as long as something has been realised on the order line.
When processing the order lines, the information in the order head is used if it has not been filled in in the order lines. Information specified in the order lines overrides the information in the order head. This applies, for example, to warehouse numbers. The warehouse number specified in the order line overrides the warehouse number specified in the order head. The warehouse number in the order head is suggested again based on the consignee. If a consignee is not specially specified, it is the same as the customer or supplier, depending on the transaction type.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 15373 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Location | Location |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | StockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Warehouse | Warehouse |
| ||
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |