Data information
The information below tells you more about the SQL table where AGR houses this data, its importance and an external link to more information about the SQL table.
Importance | Required |
Description | Current available stock. |
Criteria | For all items, , has to be on item+location level |
Primary key | ITEM_NO, LOCATION_NO, STOCK_UNITS |
Table documentation |
Column and type
The information below breaks down the data for this SQL table into columns, descriptions and types.
Column | Functional description | Type |
ITEM_NO | The item the stock belongs to, refers to NO in ITEM | nvarchar(255) |
LOCATION_NO | The location where the item is sold, refers to NO in LOCATION | nvarchar(255) |
STOCK_UNITS | The total quantity currently in stock of a given item in the given location | decimal(18.4) |