| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| id | Part Inventory Id | int | vrpt_PartInventoryList |
| inv_binLabel | Part Inventory Bin Label | nvarchar | |
| inv_maximumLevel | Part Inventory Maximum Level | int | |
| inv_minimumLevel | Part Inventory Minimum Level | int | |
| inv_pa_fk | Part Id | int | vr_Part |
| inv_pk | Part Inventory Id | int | vrpt_PartInventoryList |
| inv_quantityOnHand | Part Inventory Quantity on Hand | int | |
| inv_record_code | Part Inventory Record Code | nvarchar | |
| inv_reorderPoint | Part Inventory Reorder Point | int | |
| inv_reorderQuantity | Part Inventory Reorder Quantity | int | |
| inv_wh_fk | Warehouse Id | int | vr_warehouse |
| pa_code | Part Code | nvarchar | |
| pa_description | Part Description | nvarchar | |
| pa_pk | Part Id | int | vr_Part |
| TotalQuantity | Total Quantity | int | |
| WH_CODE | Warehouse Code | nvarchar | |
| WH_NAME | Warehouse Name | nvarchar | |
| wh_parent_fk | Warehouse Id | int | vr_warehouse |
| WH_PK | Warehouse Id | int | vr_warehouse |