POS/2.30/Database Model/stockcurrent
Contents |
STOCKCURRENT
Description
Columns
This table contains the following columns:
| Name | PK | Nullable | Data Type | Default | Description |
| LOCATION | N | N | VARCHAR | ||
| PRODUCT | N | N | VARCHAR | ||
| ATTRIBUTESETINSTANCE_ID | N | Y | VARCHAR | ||
| UNITS | N | N | DOUBLE |
Foreign Keys
These are the foreign keys for this table:
| Name | Referencing column | Referenced table | Referenced column | Description |
| STOCKCURRENT_FK_1 | PRODUCT | PRODUCTS | ID | |
| STOCKCURRENT_ATTSETINST | ATTRIBUTESETINSTANCE_ID | ATTRIBUTESETINSTANCE | ID | |
| STOCKCURRENT_FK_2 | LOCATION | LOCATIONS | ID |
Indexes
These are the indexes for this table (for each index there is a list of the columns included within it):
| Name | Unique | Reference | Description |
| STOCKCURRENT_INX | Y | LOCATION - PRODUCT - ATTRIBUTESETINSTANCE_ID - |
| Languages: |
POS/2.30/Database Model/sharedtickets | POS/2.30/Database Model/stockdiary