Location balance
The Location balance table shows quantity, weight and dimensions for each location, per warehouse.
The table is defined as a view in the database.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | LocBal | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | locationBalance | The API identifier used in GraphQL. |
| Table no. | 371 | The table number in the data model. |
The following fields exist in this table:
Free volume
The difference between the Volume and the Used volume 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 | FreeVol | The database field name. |
| API identifier | freeVolume | The API identifier used in GraphQL. |
| Number | 16169 |
Free weight
The difference between the Weight and the Used weight 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 | FreeWgt | The database field name. |
| API identifier | freeWeight | The API identifier used in GraphQL. |
| Number | 16172 |
Location
Together with the Warehouse no. field, the unique identifier for the location balance.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Location | Text (18) |
| Primary key | Yes | Warehouse no., Location |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Loc | The database field name. |
| API identifier | location | The API identifier used in GraphQL. |
| Number | 16166 |
| 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 line | OrderLineStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Item location | ItemLocationStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Used quantity
The total from the Physical stock field in the Shipment 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 | UsdQty | The database field name. |
| API identifier | usedQuantity | The API identifier used in GraphQL. |
| Number | 16173 |
Used volume
The total volume based on the Physical stock field in the Shipment table and the Volume field in the Product 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 | UsdVol | The database field name. |
| API identifier | usedVolume | The API identifier used in GraphQL. |
| Number | 16168 |
Used weight
The total net weight based on the Physical stock field in the Shipment table and the Net weight field in the Product 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 | UsdWgt | The database field name. |
| API identifier | usedWeight | The API identifier used in GraphQL. |
| Number | 16171 |
Volume
The Volume from the Location 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 | Volume | The database field name. |
| API identifier | volume | The API identifier used in GraphQL. |
| Number | 16167 |
Warehouse no.
Together with the Location field, the unique identifier for the location balance.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| Primary key | Yes | Warehouse no., Location |
| 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 | 16165 |
| 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. | |
| Product | Product |
| ||
| Order line | OrderLineStock |
| ||
| Order line | OrderLineToStock |
| ||
| Order line | OrderLineStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Item location | ItemLocationStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Weight
The Weight from the Location 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 | Wgt | The database field name. |
| API identifier | weight | The API identifier used in GraphQL. |
| Number | 16170 |