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 |