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 | Item information. |
Criteria | All items that need to be visible in AGR. Excluding inactive items with no stock or other items that don't need to be seen in AGR |
Primary key | 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 |
NO | The Item number. A unique identifier to an 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) |
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) |
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) |
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) |
ITEM_GROUP_NO_LVL_1 | The NO of the highest level in the item group hierarchy, refers to NO in ITEM_GROUP | nvarchar(255) |
ITEM_GROUP_NO_LVL_2 | The NO of the second highest level in the item group hierarchy, refers to NO in ITEM_GROUP | nvarchar(255) |
ITEM_GROUP_NO_LVL_3 | The NO of the third level in the item group hierarchy, refers to NO in ITEM_GROUP | nvarchar(255) |
BASE_UNIT_OF_MEASURE | The base unit of measure for the item | nvarchar(50) |
PURCHASE_UNIT_OF_MEASURE | The purchase unit of measure. Can be the same as base unit | nvarchar(50) |
QTY_PER_PURCHASE_UNIT | The number of base units in one purchase unit | decimal(18.4) |
SPECIAL_ORDER | Special Order Items, AKA purchase-to-order or make-to-order are items that do not get statistical forecast / safety stock calculated, and replenishment for these items are solely driven by customer orders | bit |
REORDER_POINT | The Reorder point, if using the Min/Max Order Methodology, AGR order calculations will suggest an order if the stock level is below Reorder Point | decimal(18.4) |