| Name | Description | Type | Additional information |
|---|---|---|---|
| Buyer | DealBuyer |
None. |
|
| CoBuyer | DealBuyer |
None. |
|
| TradeIn1 | TradeInVehicle |
None. |
|
| TradeIn2 | TradeInVehicle |
None. |
|
| VIN | string |
None. |
|
| Year | string |
None. |
|
| Make | string |
None. |
|
| Model | string |
None. |
|
| Trim | string |
None. |
|
| Color | string |
None. |
|
| Style | string |
None. |
|
| Miles | integer |
None. |
|
| Engine | string |
None. |
|
| Key | string |
None. |
|
| SoldVehicleTitle | boolean |
None. |
|
| VehicleCost | decimal number |
None. |
|
| VehicleThumbnail | string |
None. |
|
| InternetPrice | decimal number |
None. |
|
| Products | decimal number |
None. |
|
| Taxable | decimal number |
None. |
|
| SurplusAmount | decimal number |
None. |
|
| SurplusTax | decimal number |
None. |
|
| QuickNote | string |
None. |
|
| DownPaymentReceived | decimal number |
None. |
|
| FinanceManager | string |
None. |
|
| Salesman1 | string |
None. |
|
| Salesman2 | string |
None. |
|
| SalesManager | string |
None. |
|
| WarrantyCompany | string |
None. |
|
| GAPCompany | string |
None. |
|
| Product1Company | string |
None. |
|
| Product2Company | string |
None. |
|
| Product3Company | string |
None. |
|
| Product4Company | string |
None. |
|
| Product5Company | string |
None. |
|
| Product6Company | string |
None. |
|
| Product1Name | string |
None. |
|
| Product2Name | string |
None. |
|
| Product3Name | string |
None. |
|
| Product4Name | string |
None. |
|
| Product5Name | string |
None. |
|
| Product6Name | string |
None. |
|
| WeOweCost | decimal number |
None. |
|
| BuyRatePaymentAmount | decimal number |
None. |
|
| SecurityDeposit | decimal number |
None. |
|
| AccountNumber | integer |
None. |
|
| StockNumber | integer |
None. |
|
| TradeInCode1 | integer |
None. |
|
| TradeInCode2 | integer |
None. |
|
| BuyerCode | integer |
None. |
|
| CoBuyerCode | integer |
None. |
|
| SalesPrice | decimal number |
None. |
|
| TradeAllowance1 | decimal number |
None. |
|
| TradeAllowance2 | decimal number |
None. |
|
| DealerFee | decimal number |
None. |
|
| SalesTax | decimal number |
None. |
|
| CountyTaxName | string |
None. |
|
| CountyTaxRate | decimal number |
None. |
|
| TagAgencyFee | decimal number |
None. |
|
| Title | decimal number |
None. |
|
| Tags | decimal number |
None. |
|
| Registration | decimal number |
None. |
|
| TIPayoff1 | decimal number |
None. |
|
| TIPayoff2 | decimal number |
None. |
|
| DownPayment | decimal number |
None. |
|
| ReserveAmount | decimal number |
None. |
|
| BalanceDue | decimal number |
None. |
|
| CurrentDue | decimal number |
None. |
|
| CurrentPaymentNumber | integer |
None. |
|
| ReservePercent | decimal number |
None. |
|
| BuyRate | decimal number |
None. |
|
| InterestRate | decimal number |
None. |
|
| Term | integer |
None. |
|
| FinanceCompany | string |
None. |
|
| FinanceAmount | decimal number |
None. |
|
| WarrantyPrice | decimal number |
None. |
|
| GAPAmount | decimal number |
None. |
|
| Product1Amount | decimal number |
None. |
|
| Product2Amount | decimal number |
None. |
|
| Product3Amount | decimal number |
None. |
|
| Product4Amount | decimal number |
None. |
|
| WarrantyCost | decimal number |
None. |
|
| GapCost | decimal number |
None. |
|
| Product1Cost | decimal number |
None. |
|
| Product2Cost | decimal number |
None. |
|
| Product3Cost | decimal number |
None. |
|
| Product4Cost | decimal number |
None. |
|
| SoldDate | date |
None. |
|
| DocStamp | decimal number |
None. |
|
| PaymentAmount | decimal number |
None. |
|
| LatePaymentAmount | decimal number |
None. |
|
| FirstPaymentDue | date |
None. |
|
| FinalPaymentDue | date |
None. |
|
| NextPaymentDue | date |
None. |
|
| ACV1 | decimal number |
None. |
|
| ACV2 | decimal number |
None. |
|
| Commissions1 | decimal number |
None. |
|
| Commissions2 | decimal number |
None. |
|
| Discount | decimal number |
None. |
|
| VehicleProfit | decimal number |
None. |
|
| TotalProfit | decimal number |
None. |
|
| Status | string |
None. |
|
| Sysuser | string |
None. |
|
| SysDate | date |
None. |
|
| HasCoBuyer | boolean |
None. |
|
| HasTrade1 | boolean |
None. |
|
| HasTrade2 | boolean |
None. |
|
| LeadSource | string |
None. |
|
| DealType | string |
None. |
|
| DealSpotted | boolean |
None. |
|
| Notes | string |
None. |
|
| LeinHolder1 | string |
None. |
|
| LeinHolder2 | string |
None. |
|
| FrontEndProfit | decimal number |
None. |
|
| BackEndProfit | decimal number |
None. |
|
| SalesmanPrice | decimal number |
None. |
|
| FinanceCommissions | decimal number |
None. |
|
| Commission1Override | boolean |
None. |
|
| Commission2Override | boolean |
None. |
|
| ReserveOverride | boolean |
None. |
|
| FinanceCommissionOverride | boolean |
None. |
|
| Commission1Funded | boolean |
None. |
|
| Commission2Funded | boolean |
None. |
|
| FnICommissionFunded | boolean |
None. |
|
| Flag | integer |
None. |
|
| DealFunded | string |
None. |
|
| TagCost | decimal number |
None. |
|
| IsEditing | boolean |
None. |
|
| EditingBy | string |
None. |
|
| LotName | string |
None. |
|
| InsuranceCompany | string |
None. |
|
| InsuranceAgent | string |
None. |
|
| InsuranceAddress | string |
None. |
|
| InsuranceCity | string |
None. |
|
| InsuranceState | string |
None. |
|
| InsuranceZip | string |
None. |
|
| InsurancePhone | string |
None. |
|
| InsurancePolicy | string |
None. |
|
| InsuranceDate | date |
None. |
|
| InsuranceComp | decimal number |
None. |
|
| InsuranceColl | decimal number |
None. |
|
| ReserveFunded | boolean |
None. |
|
| PostedDate | date |
None. |
|
| BHPHStatus | string |
None. |
|
| TransferStatus | string |
None. |
|
| BHPHLiquidValue | decimal number |
None. |
|
| BHPHBadDebtDate | date |
None. |
|
| SalespersonID1 | integer |
None. |
|
| SalespersonID2 | integer |
None. |
|
| FinanceManagerID | integer |
None. |
|
| SalesManagerID | integer |
None. |
|
| WarrantyID | integer |
None. |
|
| GapID | integer |
None. |
|
| ProductID1 | integer |
None. |
|
| ProductID2 | integer |
None. |
|
| ProductID3 | integer |
None. |
|
| ProductID4 | integer |
None. |
|
| WarrantyTerm | integer |
None. |
|
| GapTerm | integer |
None. |
|
| ProductTerm1 | integer |
None. |
|
| ProductTerm2 | integer |
None. |
|
| ProductTerm3 | integer |
None. |
|
| ProductTerm4 | integer |
None. |
|
| SalesTaxID | integer |
None. |
|
| WarrantyPolicy | string |
None. |
|
| GapPolicy | string |
None. |
|
| Product1Policy | string |
None. |
|
| Product2Policy | string |
None. |
|
| Product3Policy | string |
None. |
|
| Product4Policy | string |
None. |
|
| EditingTime | date |
None. |
|
| SalesManagerCommission | decimal number |
None. |
|
| SalesManagerOverride | boolean |
None. |
|
| BDCAgentID | integer |
None. |
|
| BDcAgentCommission | decimal number |
None. |
|
| BDCAgentOverride | boolean |
None. |
|
| LeadID | integer |
None. |
|
| SalesManagerFunded | boolean |
None. |
|
| BDCAgentFunded | boolean |
None. |
|
| RegisterOutState | boolean |
None. |
|
| DealerInventoryTax | decimal number |
None. |
|
| InspectionFee | decimal number |
None. |
|
| FloorPlanCost | decimal number |
None. |
|
| UserField1 | decimal number |
None. |
|
| UserField2 | decimal number |
None. |
|
| Trade1Credit | boolean |
None. |
|
| Trade2Credit | boolean |
None. |
|
| ResidualValue | decimal number |
None. |
|
| DownPayment1 | decimal number |
None. |
|
| DownPayment2 | decimal number |
None. |
|
| DownPayment3 | decimal number |
None. |
|
| DownPayment1Date | date |
None. |
|
| DownPayment2Date | date |
None. |
|
| DownPayment3Date | date |
None. |
|
| Rebates | decimal number |
None. |
|
| MBI | decimal number |
None. |
|
| Assigned | string |
None. |
|
| ContractAnnualMileage | decimal number |
None. |
|
| PlannedAnnualMileage | decimal number |
None. |
|
| LeaseOveragePerMile | decimal number |
None. |
|
| ResidualPercent | decimal number |
None. |
|
| IsResidualPercent | boolean |
None. |
|
| MSRP | decimal number |
None. |
|
| PaymentFrequency | string |
None. |
|
| LeaseTaxCredit | decimal number |
None. |
|
| IsUpFrontLeaseTaxes | boolean |
None. |
|
| ProductID5 | integer |
None. |
|
| ProductID6 | integer |
None. |
|
| Product5Amount | decimal number |
None. |
|
| Product6Amount | decimal number |
None. |
|
| Product5Cost | decimal number |
None. |
|
| Product6Cost | decimal number |
None. |
|
| ProductTerm5 | integer |
None. |
|
| ProductTerm6 | integer |
None. |
|
| Product5Policy | string |
None. |
|
| Product6Policy | string |
None. |
|
| MonthlyDepreciation | decimal number |
None. |
|
| RentalCharge | decimal number |
None. |
|
| MonthlyLeaseTax | decimal number |
None. |
|
| CapCostReduction | decimal number |
None. |
|
| LeaseTotalDueAtSigning | decimal number |
None. |
|
| Refunds | decimal number |
None. |
|
| TaxCreditType | string |
None. |
|
| SalesTaxOverride | boolean |
None. |
|
| TerminationFee | decimal number |
None. |
|
| LeaseEndingOverage | decimal number |
None. |