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 | If applicable |
Description | Records for Items in a particular location. Allows for feeding location specific data for items into AGR. Can be left empty if no data is kept at that level. |
Criteria | Only needed where any of the data recorded in the table is maintained at item + location level |
Primary key | ITEM_NO, LOCATION_NO |
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 number. Refers to NO in ITEM | nvarchar(255) |
LOCATION_NO | The location number. Refers to NO in LOCATION | nvarchar(255) |
MIN_STOCK | If Min_Stock > 0, then the system will ensure stock doesn’t drop below the min value. | decimal(18,4) |
MAX_STOCK | Only used when using min/max replenishment method | decimal(18,4) |
CLOSED_FOR_ORDERING | 1 if the item is not to be ordered; 0 otherwise. If closed, then the item is not replenished in AGR. The closed items can however be available for reporting. | bit |
RESPONSIBLE | Person responsible for the item | nvarchar(255) |
NAME | The name/short description of the item | nvarchar(255) |
DESCRIPTION | A more detailed description of the item | nvarchar(255) |
PRIMARY_VENDOR_NO | The Primary Vendor's number, refers to column NO in table VENDOR | nvarchar(255) |
LEAD_TIME_DAYS | The estimated number of days it takes for a purchase order from the primary vendor to arrive in a location from the moment it is placed. | smallint |
ORDER_FREQUENCY_DAYS | The number of days between orders of this item. Used to determine the appropriate order period in AGR. | smallint |
ORDER_COVERAGE_DAYS | Used instead of the order frequency to determine order period when items are to be checked for order need frequently, but ordered less frequently, with each order covering a longer period | smallint |
MIN_ORDER_QTY | Minimum order quantity in base units for each order of this item from the primary vendor; defaults to one unit | decimal(18,4) |
ORIGINAL_NO | Vendor’s item reference number | nvarchar(50) |
SALE_PRICE | The items sale price | decimal(18,4) |
COST_PRICE | The items landed cost price, including shipping & handling costs. Used to derive stock value from stock units. | decimal(18,4) |
PURCHASE_PRICE | The Purchase price of one base unit of the item. This is the direct cost, used to calculate the purchase value of orders & constrain orders on minimum order value | decimal(18,4) |
ORDER_MULTIPLE | AGR will suggest orders in multiples of this number of base units | decimal(18,4) |
QTY_PALLET | The number of base units in one pallet | decimal(18,4) |
VOLUME | The volume of one base unit | decimal(18,4) |
WEIGHT | The weight of one base unit | decimal(18,4) |