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 | Item purchase order route data for feeding 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 + vendor level |
Primary key | ITEM_NO, LOCATION_NO, VENDOR_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) |
VENDOR_NO | The number of the vendor that will deliver the purchase order, refers to NO in vendor | nvarchar(255) |
PRIMARY | 1 if this represents the primary order route; 0 otherwise. Only one line can have primary = 1 for each combination of ITEM_NO and LOCATION_NO | bit |
LEAD_TIME_DAYS | The estimated number of days it takes for an order from the primary vendor to arrive from the moment it is placed. | smallint |
ORDER_FREQUENCY_DAYS | The number of days between orders of this item from the vendor. | smallint |
MIN_ORDER_QTY | Minimum order quantity for each order of this product from the vendor. | 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 | Quantity per unit, orders will be made in multiples of this number. | decimal(18,4) |
QTY_PALLET | The number of units in one pallet. | decimal(18,4) |