| Name | Description | Type | Additional information |
|---|---|---|---|
| DealID | integer |
None. |
|
| DealDate | date |
None. |
|
| DealDateText | string |
None. |
|
| Customer | string |
None. |
|
| VehicleID | integer |
None. |
|
| VIN | string |
None. |
|
| StockNumber | string |
None. |
|
| ModelYear | integer |
None. |
|
| Make | string |
None. |
|
| Model | string |
None. |
|
| Color | string |
None. |
|
| SalePrice | decimal number |
None. |
|
| TypeOfDeal | DealTypeEnum |
None. |
|
| TypeOfDealText | string |
None. |
|
| DealStatusID | DealStatusEnum |
None. |
|
| DealStatusIDText | string |
None. |
|
| SaleTotal | decimal number |
None. |
|
| BalanceDue | decimal number |
None. |
|
| SellerName | string |
None. |
|
| TradeAmount | decimal number |
None. |
|
| AMPrice | decimal number |
None. |
|
| Mileage | integer |
None. |
|
| LeadSourceName | string |
None. |
|
| TrackingURL | string |
None. |
|
| LienHolderName | string |
None. |
|
| ContractTypeDescription | string |
None. |
|
| ContractType | byte |
None. |
|
| ApplyCode | boolean |
None. |
|
| ColorCode | string |
None. |
|
| PhoneNumber | string |
None. |
|
| ApplyColor | boolean |
None. |
|
| ApplyCodeSoldAt | boolean |
None. |
|
| ColorCodeSoldAt | string |
None. |
|
| ApplyColorSoldAt | boolean |
None. |
|
| NoContract | boolean |
None. |
|
| NoTracking | boolean |
None. |
|
| Working | boolean |
None. |
|
| Prospect | boolean |
None. |
|
| AMClass | string |
None. |
|
| VTRClass | string |
None. |
|
| VSCClass | string |
None. |
|
| TradeClass | string |
None. |
|
| CoBuyerID | integer |
None. |
|
| CoBuyerName | string |
None. |
|
| PaymentModeID | enumPaymentType |
None. |
|
| PaymentModeText | string |
None. |
|
| BankName | string |
None. |
|
| DeliveryDate | date |
None. |
|
| Age | integer |
None. |
|
| IsFutureDeal | boolean |
None. |
|
| EmailAddress | string |
None. |
|
| PhoneNumber2 | string |
None. |
|
| Street | string |
None. |
|
| ZIPCode | string |
None. |
|
| City | string |
None. |
|
| State | string |
None. |
|
| FirstName | string |
None. |
|
| LastName | string |
None. |
|
| Phone2 | string |
None. |
|
| SecondSellerName | string |
None. |
|
| SignerName | string |
None. |
|
| DealAge | integer |
None. |
|
| StateFeeTax | string |
None. |
|
| VTRPrice | decimal number |
None. |
|
| VSCPrice | decimal number |
None. |
|
| PNoteAmount | decimal number |
None. |
|
| PNoteDueDate | date |
None. |
|
| PNoteDueDateText | string |
None. |
|
| LastFundedDateAdd | date |
None. |
|
| LastFundedDateAddText | string |
None. |
|
| TotalCost | decimal number |
None. |
|
| PackFee | decimal number |
None. |
|
| TotalCostPlusPackFee | decimal number |
None. |
|
| VGP | decimal number |
None. |
|
| TotalTax | decimal number |
None. |
|
| TotalDealFee | decimal number |
None. |
|
| CommissionPaid | decimal number |
None. |
|
| VGP2 | decimal number |
None. |
|
| NetPL | decimal number |
None. |