|
This data object is used to display usage of a given parts inventory detail record. A record will be displayed for each month/year combination in which the given part had greater than zero picks or greater than zero sales. Please note that no records will be displayed for a part that has never had any picks or sales. To get a listing of all parts inventory records with their corresponding usage records, start in Parts Inventory or Parts Inventory Extended and join to Parts Inventory Usage.
This information comes from the 12 Month History tab in the Parts Inventory application in Fusion.
URL
/frw/PartsInventoryUsage
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AverageCost | This field displays the average cost of the given part. |
| BarCode | This field displays the bar code for the given parts inventory detail record. |
| BinLocation | This field displays the bin location for the given parts inventory detail record. |
| Branch | This field displays the branch associated with the given parts inventory detail record. |
| DateAdded | This field displays the date on which the given part was added to inventory, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| DaysSinceLastSale | This field displays the number of days between the last sold date and the current date. |
| Description | This field displays the description of the given part. |
| Ignore | This field displays whether the automatically recorded picks and usage for the given month were marked to be ignored for reporting and ordering purposes. |
| Inactive | This field displays whether the given parts inventory detail record has been marked as inactive. |
| LastCountDate | This field displays the date on which the given part was last counted, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LastOrderedDate | This field displays the date on which the given part was last ordered, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LastOutOfStockDate | This field displays the date on which the given part last went out of stock, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LastPriceChangeDate | This field displays the date on which the price of the given part was last changed, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LastPriceFileUpdate | This field displays the date on which the price file for the given part was last updated, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LastReceivedDate | This field displays the date on which the given part was last received, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LastReplacementCostChangeDate | This field displays the date on which the replacement cost of the given part was last changed, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LastSoldDate | This field displays the date on which the given part was last sold, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LIFODate | This field displays the LIFO date for the given part, from the Dates group box on the Purchase Control tab in the parts inventory record. |
| LostSales | This field displays the number of lost sales that were recorded for the given part in the given month and year. |
| ManualPicks | This field displays the number of picks that were manually recorded on the 12 Month History tab for the given part and the given month and year. |
| ManualSales | This field displays the number of sales that were manually recorded on the 12 Month History tab for the given part and the given month and year. |
| Month | This field displays the month in which the picks and usage displayed in the given record occurred. |
| PartNumber | This field displays the part number of the given part. |
| PartType | This field displays the part type of the given part. |
| Picks | This field displays the number of picks that were recorded by the application for the given part in the given month and year. |
| PYPicks | This field displays the total number of picks for the given part in the year prior to the given year. |
| PYSales | This field displays the total number of sales for the given part in the year prior to the given year. |
| PYTDPicks | This field displays the number of picks for the given part through the given month in the year prior to the given year. |
| PYTDSales | This field displays the number of sales for the given part through the given month in the year prior to the given year. |
| QuantityAvailable | This field displays the quantity available of the given part at the given branch. |
| QuantityCommitted | This field displays the quantity of the given part at the given branch that is committed to open orders. |
| QuantityOnBackorder | This field displays the quantity of the given part at the given branch that is on backorder from invoiced orders. |
| QuantityOnOrder | This field displays the quantity of the given part at the given branch that is expected from open purchase orders. |
| ReplacementCost | This field displays the replacement cost of the given part. |
| Sales | This field displays the number of sales that were recorded by the application for the given part in the given month and year. |
| StockClass | This field displays the stock class of the given part. |
| StockStatus | This field displays the stock status for the given parts inventory detail record. |
| Supplier | This field displays the supplier associated with the given part. |
| TotalLostSales | This field displays the total lost sales for the given part in the given month and year, from the Total Lost column on the 12 Month History tab. |
| TotalPicks | This field displays the total picks (Picks + Manual Picks) for the given part and the given month and year. |
| TotalSales | This field displays the total sales (Sales + Manual Sales) for the given part and the given month and year. |
| Year | This field displays the year in which the picks and usage displayed in the given record occurred. |
| YTDPicks | This field displays the number of picks for the given part through the given month in the given year. |
| YTDSales | This field displays the number of sales for the given part through the given month in the given year. |