POS/2.30/Database Model/stocklevel
Contents |
STOCKLEVEL
Description
Columns
This table contains the following columns:
| Name | PK | Nullable | Data Type | Default | Description |
| ID | Y | N | VARCHAR | ||
| LOCATION | N | N | VARCHAR | ||
| PRODUCT | N | N | VARCHAR | ||
| STOCKSECURITY | N | Y | DOUBLE | ||
| STOCKMAXIMUM | N | Y | DOUBLE |
Foreign Keys
These are the foreign keys for this table:
| Name | Referencing column | Referenced table | Referenced column | Description |
| STOCKLEVEL_PRODUCT | PRODUCT | PRODUCTS | ID | |
| STOCKLEVEL_LOCATION | LOCATION | LOCATIONS | ID |
Indexes
| Languages: |
POS/2.30/Database Model/stockdiary | POS/2.30/Database Model/taxcategories