Vehicle Inventory Resource Mapping
Here are the Salesforce objects that are mapped to VehicleInventory BOD:
- BusinessBrand
- GeoCountry
- Product2
- Product2.BusinessBrandId = BusinessBrand.Id
- Location
- Asset
- Asset.Product2Id = Product2.Id
- Asset.AccountId = Account.Id
- AssociatedLocation:
- AssociatedLocation.LocationId = Location.Id
- Account:
- Account.Id = AssociatedLocation.AccountId
- ProductItem:
- ProductItem.Product2Id = Product.Id
- ProductItem.LocationId = Location.Id
- SerializedProduct:
- SerializedProduct.Product2Id = Product.Id
- SerializedProduct.ProductItemId = ProductItem.Id
- SerializedProduct.AssetId = Asset.Id
- VehicleDefinition:
- VehicleDefinition.Id = Product.Id
- VehicleDefinition.GeoCountryId = GeoCountry.Id
- Vehicle:
- Vehicle.VehicleDefinitionId = VehicleDefinition.Id
- Vehicle.VehicleIdentificationNumber = Product.Id
- Vehicle.AssetId = Asset.Id
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| Description | ModelDescription | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelDescription |
| MakeName | MakeString | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.MakeString |
| ManufacturerName | ManufacturerName | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ManufacturerName |
| ManufacturerPartNumber | OrganizationID | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.OrganizationID |
| ModelName | ModelDescription | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelDescription |
| ModelYear | ModelYear as Number default null | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelYear as Number default null |
| Name | MakeString ++ Model ++ ModelYear | Yes | ((VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.MakeString default "") ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Model default "")) ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelYear default "") |
| ProductCategoryCode | ModelGroup | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelGroup |
| ProductCode | ProductClassCode | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ProductClassCode |
| VehicleTrimLevel | TrimCode | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.TrimCode |
| VersionName | SeriesName | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.SeriesName |
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| BodyType | BodyStyle | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.BodyStyle |
| DoorCount | DoorsQuantityNumeric default 0 | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.DoorsQuantityNumeric default 0 |
| DrivetrainType | DriveTrain | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.DriveTrain |
| EmissionStandard | Emissions | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.Emissions |
| EngineCubicCapacity | CompressionRatioMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.CompressionRatioMeasure |
| EngineName | MakeString ++ Model ++ ModelYear | No | ((VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.MakeString default "") ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.Model default "")) ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.ModelYear default "") |
| FuelType | FuelTypeCode | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.FuelTypeCode |
| Height | HeightMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VehicleDimension.HeightMeasure |
| Length | LengthMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VehicleDimension.LengthMeasure |
| MaximumGrossWeight | GrossWeightMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.GrossWeightMeasure |
| MaximumTorque | PressureMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.TorqueMeasure.PressureMeasure |
| ModelCode | Vehicle.Model | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Model |
| Name | MakeString ++ Model ++ ModelYear | Yes | ((VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.MakeString default "") ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Model default "")) ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelYear default "") |
| TopSpeed | MaximumSpeedMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.MaximumSpeedMeasure |
| TransmissionType | TransmissionTypeName | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.TransmissionGroup.TransmissionTypeName |
| VariantName | VariantID | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VariantID |
| VehicleClass | VehicleClassCode | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VehicleClassCode |
| Wheelbase | WheelBaseMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.WheelBaseMeasure |
| Width | WidthMeasure | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VehicleDimension.WidthMeasure |
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| City | CityName | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.CityName |
| Country | CountryID | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.CountryID |
| Description | ModelDescription | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelDescription |
| InstallDate | EventOccurrenceDateTime as String | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.PartyActionEvent.EventOccurrenceDateTime as String |
| Name | MakeString ++ Model ++ ModelYear | Yes | ((VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.MakeString default "") ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Model default "")) ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelYear default "") |
| PostalCode | Postcode | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.Postcode |
| Price | ChargeAmount | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.Price.ChargeAmount |
| PurchaseDate | EventOccurrenceDateTime as String | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.PartyActionEvent.EventOccurrenceDateTime as String |
| SerialNumber | VehicleID | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VehicleID |
| State | StateOrProvinceCountrySub-DivisionID | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress."StateOrProvinceCountrySub-DivisionID" |
| Street | StreetName | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.StreetName |
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| AverageMarketValue | ChargeAmount | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.Price.ChargeAmount |
| ChassisNumber | ChassisSerialString | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Chassis.ChassisSerialString |
| ConditionType | Condition | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Condition |
| CylinderCount | NumberOfEngineCylindersNumeric as String | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.NumberOfEngineCylindersNumeric as String |
| EngineNumber | EngineSerialString | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.EngineSerialString |
| ExteriorColor | ColorName | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ColorGroup.ColorName |
| IsTelematicsServiceActive | SubscriptionServiceStatus | No | (isEmpty(VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.TelematicsSubscription.SubscriptionList.SubscriptionServiceStatus)) as Boolean default true |
| LatestResidualValue | OptionResidualValueAmount | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionResidualValueAmount |
| LatestResidualValueDate | PriceEffectiveDate as String | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.PriceEffectiveDate as String |
| LocationCity | CityName | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.CityName |
| LocationCountry | CountryID | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.CountryID |
| LocationPostalCode | Postcode | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.Postcode |
| LocationState | StateOrProvinceCountrySub-DivisionID | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress."StateOrProvinceCountrySub-DivisionID" |
| LocationStreet | StreetName | No | VehicleInventory.VehicleInventoryHeader.ManufacturerParty.SpecifiedOrganization.PostalAddress.StreetName |
| LowestMarketValue | ChargeAmount | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.Price.ChargeAmount |
| ManufacturedDate | CompleteDateTime as String | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VehicleMajorPartsProductItem.VehicleMajorPartsProductItemConfiguration.EffectivePeriod.CompleteDateTime as String |
| MarketPrice | ChargeAmount | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.Price.ChargeAmount |
| MarketPriceDate | PriceEffectiveDate | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.PriceEffectiveDate as String) if(!isEmpty(VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.PriceEffectiveDate)) |
| MarketPriceSource | PriceSourceCode | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Option.OptionPricing.PriceSourceCode |
| Name | MakeString ++ Model ++ ModelYear | Yes | ((VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.MakeString default "") ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Model default "")) ++ (VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.ModelYear default "") |
| RegistrationRegionCode | RegistrationStateProvince | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.RegistrationStateProvince |
| SteeringType | SteeringSystem | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.SteeringSystem |
| StockCode | VehicleStockString | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.Engine.VehicleStockString |
| VehicleRegistrationNumber | RegistrationID | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.RegistrationID |
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| Name | CompanyName | Yes | VehicleInventory.VehicleInventoryHeader.SoldToParty.SpecifiedOrganization.CompanyName |
| Type | BusinessTypeCode | No | VehicleInventory.VehicleInventoryHeader.SoldToParty.SpecifiedOrganization.BusinessTypeCode |
| Phone | CompleteNumber | No | VehicleInventory.VehicleInventoryHeader.SoldToParty.SpecifiedOrganization.PrimaryContact.TelephoneCommunication.CompleteNumber |
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| Name | BrandingDescription | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.BrandedInfo.BrandingDescription |
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| Name | AddressID | No | VehicleInventory.VehicleInventoryHeader.SoldToParty.SpecifiedOrganization.PostalAddress.AddressID |
| PossessionDate | DealerInventoryDate as String | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.DealerInventoryDate as String |
| Field | Salesforce Mapping | Required | Field Path |
|---|---|---|---|
| SerialNumber | VehicleID | No | VehicleInventory.VehicleInventoryInvoice.VehicleInventoryVehicleLineItem.Vehicle.VehicleID |