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 | All sales history for the setup. |
Criteria | For all items. The forecast requires 24 months of data to pick up on seasonality in the data. |
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 that's being sold, refers to NO in ITEM | nvarchar(255) |
LOCATION_NO | The location where the item is sold, corresponds to NO in LOCATION | nvarchar(255) |
DATE | The actual date of the sale transaction | date |
SALE | The total quantity sold of a given item in the given location on this date. (Sum of all POS transactions/sales on this date for the item) | decimal(18,4) |
CUSTOMER_NO | customer no (if applicable) | nvarchar(255) |
REFERENCE_NO | Sales order reference no (if applicable) | nvarchar(255) |
IS_SALES_ORDER | indicates if the transaction is a sales order | bit |
IS_EXCLUDED | Indicates if the sales transaction should be excluded from forecasts | bit |