Aggregated shipment
This table is a view that contains values summarised from the Shipment table per product/warehouse combination.
It can be used, for example, to simplify the reconciliation between the Stock balance and Shipment tables.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | AgShp | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | aggregatedShipment | The API identifier used in GraphQL. |
| Table no. | 385 | The table number in the data model. |
The following fields exist in this table:
Accounting value
| 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 | AcVal | The database field name. |
| API identifier | accountingValue | The API identifier used in GraphQL. |
| Number | 16619 |
Available in stock
How much stock is available for reservation in the warehouse.
Calculated as follows: Realised stock + Unrealised stock inc. - Reserved from stock - Picked without reservation.
| 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 | AvStc | The database field name. |
| API identifier | availableInStock | The API identifier used in GraphQL. |
| Number | 16570 |
Available stock
How much stock is currently available for reservations in the warehouse.
| 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 | Av | The database field name. |
| API identifier | available | The API identifier used in GraphQL. |
| Number | 16569 |
Further processed
The quantity which has been processed using transaction type 5 - Further processing.
| 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 | NoFrProd | The database field name. |
| API identifier | furtherProcessed | The API identifier used in GraphQL. |
| Number | 16578 |
Hired
How many units are currently hired. It is updated at the same time as the Reserved quantity field.
| 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 | NoHire | The database field name. |
| API identifier | hired | The API identifier used in GraphQL. |
| Number | 16575 |
Inflow
Incoming quantity.
Inflow is generated by purchase and production orders.
| 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 | InInc | The database field name. |
| API identifier | inflow | The API identifier used in GraphQL. |
| Number | 16565 |
Loaned
How many units are currently loaned. It is updated at the same time as the Reserved quantity field.
| 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 | NoLoan | The database field name. |
| API identifier | loaned | The API identifier used in GraphQL. |
| Number | 16576 |
Lost
The reduction in stock balance due to loss.
- Use of the processing Correct stock balances in the Stock balance table.
- Goods being discarded or needing to be compensated in connection with hire/loan
- Orders with Transaction type set to 4 - Adjustment/internal issue
| 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 | Loss | The database field name. |
| API identifier | lost | The API identifier used in GraphQL. |
| Number | 16577 |
Physical stock
The actual stock of goods in the warehouse.
It is calculated as follows: Physical stock = Realised stock + Unrealised stock inc.
| 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 | PhStc | The database field name. |
| API identifier | physicalStock | The API identifier used in GraphQL. |
| Number | 16562 |
Physical stock value
The actual value of the goods in the warehouse in domestic currency.
It is calculated as the product of the Average cost price and the Physical stock. Physical stock value = Average cost price x Physical stock.
| 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 | PhStcVal | The database field name. |
| API identifier | physicalStockValueDomestic | The API identifier used in GraphQL. |
| Number | 16572 |
Produced
The quantity of the shipment which has been produced for transaction type 7 - Production.
| 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 | NoProd | The database field name. |
| API identifier | produced | The API identifier used in GraphQL. |
| Number | 16580 |
Product no.
Which product no. in the Product table the Stock balance row relates to.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| Primary key | Yes | Product no., Warehouse no. |
| 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 | 16560 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
|
Purchase value
| 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 | PurcVal | The database field name. |
| API identifier | purchaseValue | The API identifier used in GraphQL. |
| Number | 16620 |
Purchased/prod. not received
The unfinished quantity on a purchase or production order.
- Purchase order returns
- Production order returns
- Already reserved quantity against inflow
| 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 | AvInc | The database field name. |
| API identifier | purchaseOrProductionNotReceived | The API identifier used in GraphQL. |
| Number | 16571 |
Realised stock
The stock in the warehouse after realizing an order.
| 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 | RestBal | The database field name. |
| API identifier | realisedStock | The API identifier used in GraphQL. |
| Number | 16563 |
Realised stock value
The actual value of the goods in the warehouse.
It is calculated as the product of the Average cost price and the Realised stock. Realised stock value = Average cost price x Realised stock.
| 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 | StcVal | The database field name. |
| API identifier | realisedStockValueDomestic | The API identifier used in GraphQL. |
| Number | 16573 |
Received
The quantity of the shipment which has been received for transaction type 6 - Purchase.
A quantity is considered as received after the finish and invoice processing.
| 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 | NoRec | The database field name. |
| API identifier | received | The API identifier used in GraphQL. |
| Number | 16579 |
Reserved
How much is reserved in total, calculated on the basis of the Reserved from stock and Reserved from inflow fields.
| 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 | Rsv | The database field name. |
| API identifier | reserved | The API identifier used in GraphQL. |
| Number | 16566 |
Reserved from inflow
How much is reserved from inflow.
Calculated as the sum of the corresponding field in the Shipment table of the same product.
| 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 | NoRsvInc | The database field name. |
| API identifier | reservedFromInflow | The API identifier used in GraphQL. |
| Number | 16568 |
Reserved from stock
How much is reserved from stock.
Calculated as the sum of the corresponding fields in the Shipment table. 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. |
| SQL name | NoRsv | The database field name. |
| API identifier | reservedFromStock | The API identifier used in GraphQL. |
| Number | 16567 |
Sold
The quantity of the shipment which has been invoiced/realized for transaction type 1 - Sales.
| 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 | NoDel | The database field name. |
| API identifier | sold | The API identifier used in GraphQL. |
| Number | 16574 |
Transferred
The quantity which has been transferred between warehouses or shipments for transaction type 8 - Stock transfer.
| 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 | NoTrf | The database field name. |
| API identifier | transferred | The API identifier used in GraphQL. |
| Number | 16581 |
Unrealised stock inc.
The amount of units which are received but not yet invoiced.
After goods are purchased, received goods remain in the Unrealised stock inc. field until you invoice receive the purchased quantity. On receipt of invoice, Unrealised stock inc. field is transferred to the Realised stock field.
| 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 | StcInc | The database field name. |
| API identifier | unrealisedStockIncrease | The API identifier used in GraphQL. |
| Number | 16564 |
Warehouse no.
The warehouse the Stock balance row relates to.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| Primary key | Yes | Product no., Warehouse no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcNo | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 16561 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | Warehouse |
|