Fields - Parts
Fields
| Field Name | Data Type | Description, Example |
|---|---|---|
| DealerId | string | Internal Dealer Identifier (intentionally left blank) |
| Cmf | string | Lightspeed Dealer Identifier |
| PartNumber(key) | string | Identifier of the item |
| SupplierCode(key) | string | Abbreviation of the maker – usually conforms to price book source codes |
| DateGathered | datetime | Date the part quantity was last updated |
| Description | string | Description of the part |
| OnHand | int | Nullable - Amount of the part in the store |
| Avail | int | Nullable - Amount of the part available to sell |
| OnOrder | int | Nullable - Amount of the part on order |
| OnOrderAvail | int | Nullable - Amount of the part on order that is sellable |
| LastSoldDate | date | Nullable - Date when last sold – could be NULL or 1/1/1900 to denote no sales |
| LastReceivedDate | date | Nullable - Date part was last received |
| LastAdjustmentDate | date | Nullable - Date part was last adjusted |
| ReOrderMethod | string | C = Sales Curve,F = ForceM = Min/MaxN = Never Order (Force to 0)F = Force to 1 |
| MinimumQty | int | Nullable - Lowest allowable quantity to have in stock |
| MaximumQty | int | Nullable - Highest allowable quantity to have in stock |
| Cost | money | Nullable - Part cost |
| CurrentActivePrice | money | Nullable - Price that is currently active |
| OrderUnit | string | Free form field – how is the part packaged |
| OrderUnitQty | int | Nullable - How many come in that package? |
| Retail | money | Nullable – Price that the part usually sells for - MSRP |
| LastCountDate | date | Nullable - Date the part was last counted |
| SupersededTo | string | Most current part number for this part |
| UPC | string | UPC code of the part |
| Bin1 | string | Free form field for part location |
| Bin2 | string | Free form field for part location |
| Bin3 | string | Free form field for part location |
| category | string | DMS assigned group for part |
| similarparttype | string | Description of Similar Part Type – Values can be REFERENCE, SIMILAR, BASE |
| activepricetype | string | Description of what price is being used on the part record – Values can be Standard, Sale, Special1, Special2, Special3, Unknown |
| escalationtype | string | How will this part be affected by escalators – Values can be Retail Only, Cost and Retail, Cost Only, No Updating, Unknown |
| reordertype | string | Method of part reordering – Values can Sales Curve, Force to One, Force to Zero, Min/Max, Unknown |
| comments | string | Comments field of the part record |
| indealerpricebook | string | Currently set to 0 |
| glaccountcode | string | GL inventory account number assigned to the part |
| movementcode | string | Customer defined description to assist in seasonal sales |
| nodiscountpart | int | 0 = Can be discounted 1 = Cannot be discounted |
| secondarypartnum | string | Alternate part number for the part record |
| oemreplenishment | boolean | True = part replenishment is influenced by OEM, False = part replenishment is not influenced by OEM |
| reorderpoint | int | Minimum stocking level used by the buying guide |
| suggestedsellqty | int | Dealer specified quantity to be sold at the time of sale |
| saleprice | money | Dealer specified alternative retail price |
| specialprice1 | money | Dealer specified alternative retail price |
| specialprice2 | money | Dealer specified alternative retail price |
| specialprice3 | money | Dealer specified alternative retail price |
| usepkgcost | money | Flag to DMS to multiply pkg cost to pkg qty |
| usepkgprice | money | Flag to DMS to multiply pkg price to pkg qty |
| lastupdatedate | datetime | Date when part was last updated |
| mapflag | Int | 0=not on MAP, 1=is on MAP |
:::tip Best Practice We suggest you use lastupdatedate as your field to determine changes for Lightspeed dealers. :::
Notes
Note: The field lastupdatedate is best used to determine changes to the actual part record (onhand quantity, price change) while the field dategathered is best used to determine transactional history (when was it last sold) of the part.