| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| custId | integer |
None. |
|
| newUsed | string |
None. |
|
| vYear | integer |
None. |
|
| make | string |
None. |
|
| model | string |
None. |
|
| submodel | string |
None. |
|
| engine | string |
None. |
|
| vin | string |
None. |
|
| mileage | integer |
None. |
|
| Warranty | string |
None. |
|
| Price | decimal number |
None. |
|
| Markup | decimal number |
None. |
|
| surcharge | decimal number |
None. |
|
| Total | decimal number |
None. |
|
| PaymentType | string |
None. |
|
| PaymentType2 | string |
None. |
|
| PaymentType3 | string |
None. |
|
| expDate | date |
None. |
|
| transStatus | string |
None. |
|
| dealStatus | string |
None. |
|
| PendindTransDate | date |
None. |
|
| TransmittedDate | date |
None. |
|
| creditCard | string |
None. |
|
| SecNumber | string |
None. |
|
| PayeeName | string |
None. |
|
| checkNo | string |
None. |
|
| AcctNum | string |
None. |
|
| RouteNum | string |
None. |
|
| Bank | string |
None. |
|
| Address | string |
None. |
|
| city | string |
None. |
|
| State | string |
None. |
|
| zip | string |
None. |
|
| Phone | string |
None. |
|
| string |
None. |
||
| checksaving | integer |
None. |
|
| PayeeName2 | string |
None. |
|
| PayeeName3 | string |
None. |
|
| checkNo2 | string |
None. |
|
| AcctNum2 | string |
None. |
|
| RouteNum2 | string |
None. |
|
| Bank2 | string |
None. |
|
| Address2 | string |
None. |
|
| city2 | string |
None. |
|
| State2 | string |
None. |
|
| zip2 | string |
None. |
|
| phone2 | string |
None. |
|
| checkSaving2 | integer |
None. |
|
| checkNo3 | string |
None. |
|
| AcctNum3 | string |
None. |
|
| RouteNo3 | string |
None. |
|
| Bank3 | string |
None. |
|
| Address3 | string |
None. |
|
| City3 | string |
None. |
|
| State3 | string |
None. |
|
| Zip3 | string |
None. |
|
| Phone3 | string |
None. |
|
| checkSaving3 | integer |
None. |
|
| lastUpated | date |
None. |
|
| lastUser | string |
None. |
|
| Financed | integer |
None. |
|
| FullPay | integer |
None. |
|
| pmt | decimal number |
None. |
|
| term | decimal number |
None. |
|
| percentDown | decimal number |
None. |
|
| downPmt | decimal number |
None. |
|
| WarrNewUsed | string |
None. |
|
| WarrCost | decimal number |
None. |
|
| VehicleClass | string |
None. |
|
| VehicleCost | decimal number |
None. |
|
| VehicleType | string |
None. |
|
| CCExp | string |
None. |
|
| contractNo | string |
None. |
|
| contractNumOnly | integer |
None. |
|
| WarrTerm | string |
None. |
|
| WarrMiles | string |
None. |
|
| SoldDate | date |
None. |
|
| CreatedDate | date |
None. |
|
| LastSaved | date |
None. |
|
| BillAddress | string |
None. |
|
| BillCity | string |
None. |
|
| BillState | string |
None. |
|
| BillZip | string |
None. |
|
| BillPhone | string |
None. |
|
| BillAddress2 | string |
None. |
|
| BillCity2 | string |
None. |
|
| BillState2 | string |
None. |
|
| BillZip2 | string |
None. |
|
| BillPhone2 | string |
None. |
|
| BillAddress3 | string |
None. |
|
| BillCity3 | string |
None. |
|
| BillState3 | string |
None. |
|
| BillZip3 | string |
None. |
|
| BillPhone3 | string |
None. |
|
| commission | decimal number |
None. |
|
| billTo | string |
None. |
|
| owner | string |
None. |
|
| followUp | byte |
None. |
|
| followupStatus | string |
None. |
|
| followUpDate | date |
None. |
|
| followUpNotes | string |
None. |
|
| DateFirstAccessed | date |
None. |
|
| TimeAccessed | string |
None. |
|
| CustCost | decimal number |
None. |
|
| expMiles | integer |
None. |
|
| NameOnCard | string |
None. |
|
| NameOnCard2 | string |
None. |
|
| NameOnCard3 | string |
None. |
|
| last6 | string |
None. |
|
| v1 | string |
None. |
|
| v2 | string |
None. |
|
| v3 | string |
None. |
|
| v1A | string |
None. |
|
| v2A | string |
None. |
|
| v3A | string |
None. |
|
| V1B | string |
None. |
|
| V2B | string |
None. |
|
| V3B | string |
None. |
|
| pmtMethod | string |
None. |
|
| pmtMethod2 | string |
None. |
|
| pmtMethod3 | string |
None. |
|
| billAddressSame | integer |
None. |
|
| billAddressSame2 | integer |
None. |
|
| billAddressSame3 | integer |
None. |
|
| SalesPerson | string |
None. |
|
| SalesPersonId | integer |
None. |
|
| deductList | string |
None. |
|
| warrCode | string |
None. |
|
| warrCompany | string |
None. |
|
| DealerId | integer |
None. |
|
| deductStr | string |
None. |
|
| gap | decimal number |
None. |
|
| gapcost | decimal number |
None. |
|
| declinedGap | byte |
None. |
|
| declinedVsc | byte |
None. |
|
| DeductAmt | decimal number |
None. |
|
| DeductCost | decimal number |
None. |
|
| gapCode | string |
None. |
|
| FWD | integer |
None. |
|
| Awd | integer |
None. |
|
| AWS | integer |
None. |
|
| TurboSuper | integer |
None. |
|
| OneTon | integer |
None. |
|
| Diesel | integer |
None. |
|
| V10 | integer |
None. |
|
| DualRear | integer |
None. |
|
| businessUse | integer |
None. |
|
| HyBird | integer |
None. |
|
| cancelledDate | date |
None. |
|
| refundedDate | date |
None. |
|
| ReqToCancelDate | date |
None. |
|
| Comm | decimal number |
None. |
|
| discount | decimal number |
None. |
|
| upcharge | decimal number |
None. |
|
| mFWD | decimal number |
None. |
|
| mAWD | decimal number |
None. |
|
| mAWS | decimal number |
None. |
|
| mTurboSuper | decimal number |
None. |
|
| mOneTon | decimal number |
None. |
|
| mDiesel | decimal number |
None. |
|
| mV10 | decimal number |
None. |
|
| mDualRear | decimal number |
None. |
|
| mHyBird | decimal number |
None. |
|
| mBusinessUse | decimal number |
None. |
|
| Pif | decimal number |
None. |
|
| totalComm | decimal number |
None. |
|
| TaxRate | decimal number |
None. |
|
| TaxAmt | decimal number |
None. |
|
| WarrSubTotal | decimal number |
None. |
|
| proRatedAmt | decimal number |
None. |
|
| cancelReason | string |
None. |
|
| cancelMiles | integer |
None. |
|
| tstamp | Collection of byte |
None. |
|
| dealerName | string |
None. |
|
| FinanceStatus | string |
None. |
|
| FinanceTransmittedDate | date |
None. |
|
| VscRcvDate | date |
None. |
|
| VscRcvStatus | string |
None. |
|
| VscErrorDesc | string |
None. |
|
| VscRcvCost | decimal number |
None. |
|
| FinRcvDate | date |
None. |
|
| FinRcvStatus | string |
None. |
|
| FinErrorDesc | string |
None. |
|
| BasicWarranty | string |
None. |
|
| PtWarranty | string |
None. |
|
| VscbatchId | integer |
None. |
|
| FinBatchId | integer |
None. |
|
| iDwc | integer |
None. |
|
| vchCampaignId | string |
None. |
|
| Closer | string |
None. |
|
| CloserId | integer |
None. |
|
| CloserComm | decimal number |
None. |
|
| CloserDiscount | decimal number |
None. |
|
| CloserUpCharge | decimal number |
None. |
|
| CloserPif | decimal number |
None. |
|
| CloserTotalComm | decimal number |
None. |
|
| FullFillmentStatus | string |
None. |
|
| FullFillmentDate | date |
None. |
|
| echoNotes | string |
None. |
|
| deferPmt | integer |
None. |
|
| DeferDate | date |
None. |
|
| MthDownPmtSame | integer |
None. |
|
| PmtIncludesFirstPmt | integer |
None. |
|
| vinDecoded | integer |
None. |
|
| Rated | integer |
None. |
|
| vscType | string |
None. |
|
| RateCardCode | string |
None. |
|
| PlanCode | string |
None. |
|
| ClassListCode | string |
None. |
|
| Tonage | string |
None. |
|
| LhName | string |
None. |
|
| LhAddress | string |
None. |
|
| LhCity | string |
None. |
|
| LhState | string |
None. |
|
| LhZip | string |
None. |
|
| LhPhone | string |
None. |
|
| LhFax | string |
None. |
|
| LhContact | string |
None. |
|
| DtRated | date |
None. |
|
| financeFee | decimal number |
None. |
|
| FirstPayDate | date |
None. |
|
| UseFirstPayDate | integer |
None. |
|
| isKilometers | integer |
None. |
|
| FFBatchId | integer |
None. |
|
| CancelFee | decimal number |
None. |
|
| ClaimsPaid | decimal number |
None. |
|
| AdminRefund | decimal number |
None. |
|
| CommChargeBack | decimal number |
None. |
|
| TotalPolicyAdjust | decimal number |
None. |
|
| refundPct | decimal number |
None. |
|
| TotalCustPay | decimal number |
None. |
|
| MiscCancelFee | decimal number |
None. |
|
| Source | string |
None. |
|
| ReprintType | string |
None. |
|
| RequestedRePrintType | string |
None. |
|
| selfFinanced | integer |
None. |
|
| SalesPerson3 | string |
None. |
|
| SalesPerson3Id | integer |
None. |
|
| sales3Discount | decimal number |
None. |
|
| Sales3Comm | decimal number |
None. |
|
| sales3Upcharge | decimal number |
None. |
|
| sales3Pif | decimal number |
None. |
|
| sales3TotalComm | decimal number |
None. |
|
| TCaccept | integer |
None. |
|
| tcDate | date |
None. |
|
| AuthAccept | integer |
None. |
|
| AuthDate | date |
None. |
|
| AuthInitials | string |
None. |
|
| WaitingDays | integer |
None. |
|
| WaitingMiles | integer |
None. |
|
| Addon_Upto | string |
None. |
|
| useWaitingDays | integer |
None. |
|
| ipAddress | string |
None. |
|
| TcName | string |
None. |
|
| AltFinFlag | integer |
None. |
|
| FinSentCode | string |
None. |
|
| FinSentName | string |
None. |
|
| ProductAmt | decimal number |
None. |
|
| ProductCost | decimal number |
None. |
|
| ProductDesc | string |
None. |
|
| PaidStatus | string |
None. |
|
| PaidDate | date |
None. |
|
| FinanceCompanyCollectsDownPmt | integer |
None. |
|
| Loan_Term | integer |
None. |
|
| amt_financed | decimal number |
None. |
|
| loan_pmt | decimal number |
None. |
|
| loan_Apr | decimal number |
None. |
|
| Loan_Type | string |
None. |
|
| Loan_Date | date |
None. |
|
| mModelYears | decimal number |
None. |
|
| AgentFee | decimal number |
None. |
|
| ClassFee | decimal number |
None. |
|
| InvoiceId | integer |
None. |
|
| MSRP | decimal number |
None. |
|
| SubmittedDate | date |
None. |
|
| SalesPerson4 | string |
None. |
|
| SalesPerson4Id | integer |
None. |
|
| SalesPerson5 | string |
None. |
|
| SalesPerson5Id | integer |
None. |
|
| InternalFinance | integer |
None. |
|
| Parent | string |
None. |
|
| CustomerFirstName | string |
None. |
|
| CustomerLastName | string |
None. |
|
| CustomerAddress | string |
None. |
|
| CancelReasonEx | string |
None. |
|
| CancelEffectiveDate | date |
None. |
|
| ParentId | integer |
None. |
|
| Properties | Collection of Pair of string [key] and string [value] |
None. |