Order Table
- Daniel Layne
- Matt Sullivan (Unlicensed)
This table is only populated for vehicle transactions
Column | Type | Description |
|---|---|---|
Order_Number | Integer | PK for this Order. There is no reason that this isn’t called Order_Id other than accidental inconsistency |
Relationship_Id | Integer | FK to the relationship that owns this order |
Quote_Proposal_Id | Integer | FK to the quote proposal that spawned this order |
Salesperson_Id | Integer | FK to the salesperson that owns the opportunity or relationship that owns this order |
Funder_Id | Integer | FK to the funder for this order |
Dealer_Id | Integer | FK to the dealer for this order |
Working_User_Id | Integer | FK to the working user for this order |
Relationship_Name | String(255) | The name of the relationship that owns this order |
Salesperson_Name | String(255) | The name of the salesperson that owns the opportunity or relationship that owns this order |
Funder_Name | String(255) | The name of the funder for this order |
Dealer_Name | String(255) | The name of the dealer for this order |
Working_User_Name | String(255) | The name of the user currently working on this order from an administrative perspective |
Quantity | Integer | The number of vehicles represented by this order |
Vehicle_Status | String(30) | The vehicle status of the order |
Finance_Status | String(255) | The status of the quote proposal |
Cancelled | Boolean | True = order has been cancelled |
Source | String(255) | The source of the opportunity that owns this quote proposal |
Subsource | String(255) | The subsource of the opportunity that owns this quote proposal |
Asset_Type | String(255) | Whether this is a CAR or LCV |
Manufacturer | String(255) | The manufacturer of the vehicle/asset |
Range | String(255) | The range of the vehicle/asset |
Model | String(255) | The model of the vehicle/asset |
Derivative | String(255) | The derivative of the vehicle/asset |
Fuel_Type | String(30) | The fuel type of the vehicle |
Otr_Override | Number(13,2) | The on the road price |
Registration_Number | String(8) | The registration number of the vehicle |
VIN | String(20) | The VIN (Vehicle Identification Number) for the vehicle |
Product_Type | String(255) | The finance product |
Maintenance | Boolean | True = the order has a maintenance product |
Other_Service | Boolean | True = the order has an other service |
Term | Integer | The term in months |
Initial_Payment_Multiple | Number(20,2) | The number of initial payments |
Initial_Finance_Payment | Number(20,2) | If a custom initial payment/deposit is being paid, the amount thereof |
Initial_Service_Payment | Number(20,2) | The initial service payment |
Annual_Mileage | Integer | The annual mileage for the order |
Finance_Payment | Number(20,2) | The regular finance payment for the order |
Service_Payment | Number(20,2) | The regular service payment for the order |
Delivery_Postcode | String(10) | The postcode (ZIP Code) for the delivery of the vehicle |
Target_Delivery_Date | String(50) | Free text description of target delivery |
Int_Target_Delivery_Date | Date | Date when the vehicle is expected to be available for delivery |
Confirmed_Delivery_Date | Date | Date when the vehicle will be delivered to the customer |
Order_Date | Date | Date that this order was accepted by the supplying dealer |
Net_Profit | Number(20,2) | The sum of all inflow cashflows less the sum of all outflow cashflows (ignores holding deposits) |
Creation_Date | Timestamp | When the record was created |
Last_Update_Date | Timestamp | When the record was last updated |
Last_Status_Change_Date | Timestamp | The date of the last status change for this quote_proposal |
Caz_* | Various | For Clean Air Zone use only |