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 | Historical stock levels. |
Criteria | For all items, on item + location level |
Primary key | TRANSACTION_ID |
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 |
TRANSACTION_ID | Unique identifier on this entry | bigint |
ITEM_NO | The item to which the stock belongs, refers to NO in ITEM | nvarchar(255) |
LOCATION_NO | The location where the stock is held, refers to NO in LOCATION | nvarchar(255) |
DATE | The date of the stock level or when the stock move occurred | date |
STOCK_MOVE | The amount of stock moved on the given date. | decimal(18.4) |
STOCK_LEVEL | The total quantity in stock of a given item in the given location on the given date. | decimal(18.4) |