Fields - PartHistory
| Field Name | Data Type | Description, Example |
|---|---|---|
| DealerId | string | Internal Dealer Identifier (intentionally left blank) |
| PartNumber | string | Primary part identifier |
| SupplierCode | string | Part number short code of manufacturer |
| LastSoldDate | date | Date when dealer last sold part |
| DateGathered | date | Date when part history record was created |
| quantitysoldlastweek | int | Amount of part sold this week – rolling week |
| quantitysoldlast2weeks | int | Amount of part sold in the last two weeks – rolling two weeks |
| quantitysoldlast2years | int | Amount of part sold in the last two years – rolling two years |
| quantitysoldlast3years | int | Amount of part sold in the last three years – rolling three years |
| quantitysoldlast4years | int | Amount of part sold in the last four years – rolling four years |
| quantitysoldlast5years | int | Amount of part sold in the last five years – rolling five years |
| quantitysoldlast10years | int | Amount of part sold in the last ten years – rolling ten years |
| lostsaleslastyear | int | Amount of lost sales recorded for part for prior calendar year |
| lostsalesytd | int | Amount of lost sales recorded for the current calendar year |
| lostsalesmtd | int | Amount of last sales recorded for the current month |
| monthsnosale | int | Amount of consecutive months since last sale |
| saleslastyeartotal | int | Amount of sales for prior calendar year |
| salesthisyeartotal | int | Amount of sales for current calendar year |
| repairordernumber | int | |
| saleslast01 (-12) | int | 01 is sales the last month, 02 is the sales the last two months, etc. |
| specialordersmtd | int | Amount of special orders on the part in current month |
| specialordersytd | int | Amount of special orders on the part in the current year |
| lastupdatedate | date | Date when part was last modified. |