AM
AMRPItemSite
The table that stores replenishment values for an Inventory Item at a Warehouse. These values are used by Inventory Planning Regeneration (AM505000) (corresponding to the MRPEngine graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMGroupWindow | int | Days of Supply | - | |
Description:Days of Supply for the Inventory Planning | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | MRP Bucket Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
LeadTime | int | Lead Time | - | |
Description:No description available | ||||
LotSize | decimal | Lot Size | - | |
Description:No description available | ||||
MaxOrdQty | decimal | Max Order Qty | - | |
Description:No description available | ||||
MinOrdQty | decimal | Min Order Qty | - | |
Description:No description available | ||||
PreferredVendorID | int | Preferred Vendor | Vendor | |
Description:No description available | ||||
ProductManagerID | int | Product Manager | EPEmployee | |
Description:No description available | ||||
QtyOnHand | decimal | Qty. On Hand | - | |
Description:No description available | ||||
ReorderPoint | decimal | Reorder Point | - | |
Description:No description available | ||||
ReplenishmentSiteID | int | Replenishment Warehouse | INSite | |
Description:No description available | ||||
ReplenishmentSource | char(1) | Replenishment Source | - | |
Description:Replenishment source | ||||
SafetyStock | decimal | Safety Stock | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TransferLeadTime | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||