This data object is used to display parts inventory picks and sales by month for each year in which the given part has had picks or sales. Please note that if there were no picks or sales in a given year, there will be no record for that year. The data is displayed with a row for each year and a column for each month. Please note that the 13 Month fields only contain data for the current year’s records, summarizing the past 13 months.

This information can be found in the Parts Inventory application in Fusion, largely on the 12 Month History tab.

URL

/frw/PartsInventoryYearlyUsage

Field Details…

SQL Field Name Column Description
13MonthLostSales This field displays, for the current year records, the lost sales for the given part for the past 13 months (current month + last 12 months).
13MonthManualPicks This field displays, for the current year records, the manual picks for the given part for the past 13 months (current month + last 12 months).
13MonthManualSales This field displays, for the current year records, the manual sales for the given part for the past 13 months (current month + last 12 months).
13MonthPicks This field displays, for the current year records, the picks for the given part for the past 13 months (current month + last 12 months).
13MonthSales This field displays, for the current year records, the sales for the given part for the past 13 months (current month + last 12 months).
13MonthTotalPicks This field displays, for the current year records, the total picks (picks + manual picks) for the given part for the past 13 months (current month + last 12 months).
13MonthTotalSales This field displays, for the current year records, the total sales (sales + manual sales) for the given part for the past 13 months (current month + last 12 months).
AprManualPicks This field displays the quantity of picks manually recorded for the given part for April of the given year.
AprManualSales This field displays the quantity of sales manually recorded for the given part for April of the given year.
AprPicks This field displays quantity of picks for the given part in the month of April in the given year.
AprSales This field displays quantity of sales for the given part in the month of April in the given year.
AprTotalPicks This field displays the total picks (picks + manual picks) for the given part for April of the given year.
AprTotalSales This field displays the total sales (sales + manual sales) for the given part for April of the given year.
AugManualPicks This field displays the quantity of picks manually recorded for the given part for August of the given year.
AugManualSales This field displays the quantity of sales manually recorded for the given part for August of the given year.
AugPicks This field displays quantity of picks for the given part in the month of August in the given year.
AugSales This field displays quantity of sales for the given part in the month of August in the given year.
AugTotalPicks This field displays the total picks (picks + manual picks) for the given part for August of the given year.
AugTotalSales This field displays the total sales (sales + manual sales) for the given part for August of the given year.
BarCode This field displays the barcode associated with the given part.
BinLocation This field displays the bin location associated with the given part.
Branch This field displays the branch that the given part record is associated with.
DateAdded This field displays the date on which the given part was added to inventory, from the Purchase Control tab in the Parts Inventory application. Please note that this date can be manually updated in Fusion, so it could differ from the system generated add date on the bottom of the Parts Inventory application.
DecManualPicks This field displays the quantity of picks manually recorded for the given part for December of the given year.
DecManualSales This field displays the quantity of sales manually recorded for the given part for December of the given year.
DecPicks This field displays quantity of picks for the given part in the month of December in the given year.
DecSales This field displays quantity of sales for the given part in the month of December in the given year.
DecTotalPicks This field displays the total picks (picks + manual picks) for the given part for December of the given year.
DecTotalSales This field displays the total sales (sales + manual sales) for the given part for December of the given year.
Description This field displays the description associated with the given part number.
FebManualPicks This field displays the quantity of picks manually recorded for the given part for February of the given year.
FebManualSales This field displays the quantity of sales manually recorded for the given part for February of the given year.
FebPicks This field displays quantity of picks for the given part in the month of February in the given year.
FebSales This field displays quantity of sales for the given part in the month of February in the given year.
FebTotalPicks This field displays the total picks (picks + manual picks) for the given part for February of the given year.
FebTotalSales This field displays the total sales (sales + manual sales) for the given part for February of the given year.
Inactive This field displays whether the given part has been set to inactive.
JanManualPicks This field displays the quantity of picks manually recorded for the given part for January of the given year.
JanManualSales This field displays the quantity of sales manually recorded for the given part for January of the given year.
JanPicks This field displays quantity of picks for the given part in the month of January in the given year.
JanSales This field displays quantity of sales for the given part in the month of January in the given year.
JanTotalPicks This field displays the total picks (picks + manual picks) for the given part for January of the given year.
JanTotalSales This field displays the total sales (sales + manual sales) for the given part for January of the given year.
JulManualPicks This field displays the quantity of picks manually recorded for the given part for July of the given year.
JulManualSales This field displays the quantity of sales manually recorded for the given part for July of the given year.
JulPicks This field displays quantity of picks for the given part in the month of July in the given year.
JulSales This field displays quantity of sales for the given part in the month of July in the given year.
JulTotalPicks This field displays the total picks (picks + manual picks) for the given part for July of the given year.
JulTotalSales This field displays the total sales (sales + manual sales) for the given part for July of the given year.
JunManualPicks This field displays the quantity of picks manually recorded for the given part for June of the given year.
JunManualSales This field displays the quantity of sales manually recorded for the given part for June of the given year.
JunPicks This field displays quantity of picks for the given part in the month of June in the given year.
JunSales This field displays quantity of sales for the given part in the month of June in the given year.
JunTotalPicks This field displays the total picks (picks + manual picks) for the given part for June of the given year.
JunTotalSales This field displays the total sales (sales + manual sales) for the given part for June of the given year.
MarManualPicks This field displays the quantity of picks manually recorded for the given part for March of the given year.
MarManualSales This field displays the quantity of sales manually recorded for the given part for March of the given year.
MarPicks This field displays quantity of picks for the given part in the month of March in the given year.
MarSales This field displays quantity of sales for the given part in the month of March in the given year.
MarTotalPicks This field displays the total picks (picks + manual picks) for the given part for March of the given year.
MarTotalSales This field displays the total sales (sales + manual sales) for the given part for March of the given year.
MayManualPicks This field displays the quantity of picks manually recorded for the given part for May of the given year.
MayManualSales This field displays the quantity of sales manually recorded for the given part for May of the given year.
MayPicks This field displays quantity of picks for the given part in the month of May in the given year.
MaySales This field displays quantity of sales for the given part in the month of May in the given year.
MayTotalPicks This field displays the total picks (picks + manual picks) for the given part for May of the given year.
MayTotalSales This field displays the total sales (sales + manual sales) for the given part for May of the given year.
NovManualPicks This field displays the quantity of picks manually recorded for the given part for November of the given year.
NovManualSales This field displays the quantity of sales manually recorded for the given part for November of the given year.
NovPicks This field displays quantity of picks for the given part in the month of November in the given year.
NovSales This field displays quantity of sales for the given part in the month of November in the given year.
NovTotalPicks This field displays the total picks (picks + manual picks) for the given part for November of the given year.
NovTotalSales This field displays the total sales (sales + manual sales) for the given part for November of the given year.
OctManualPicks This field displays the quantity of picks manually recorded for the given part for October of the given year.
OctManualSales This field displays the quantity of sales manually recorded for the given part for October of the given year.
OctPicks This field displays quantity of picks for the given part in the month of October in the given year.
OctSales This field displays quantity of sales for the given part in the month of October in the given year.
OctTotalPicks This field displays the total picks (picks + manual picks) for the given part for October of the given year.
OctTotalSales This field displays the total sales (sales + manual sales) for the given part for October of the given year.
PartNumber This field displays the part number of the given part record.
PartType This field displays the part type (Part, Exchange, or Core) of the given part.
SepManualPicks This field displays the quantity of picks manually recorded for the given part for September of the given year.
SepManualSales This field displays the quantity of sales manually recorded for the given part for September of the given year.
SepPicks This field displays quantity of picks for the given part in the month of September in the given year.
SepSales This field displays quantity of sales for the given part in the month of September in the given year.
SepTotalPicks This field displays the total picks (picks + manual picks) for the given part for September of the given year.
SepTotalSales This field displays the total sales (sales + manual sales) for the given part for September of the given year.
StockStatus This field displays the stock status of the given part.
SuggestedOrderMonths This field displays the months of sales history that should be considered when making decisions about purchasing for the given part.
Supplier This field displays the supplier of the given parts inventory record.
Year This field displays the year in which the given part usage was recorded.