Quote_Proposal Table
- Daniel Layne
Column | Type | Description |
|---|---|---|
Quote_Proposal_Id | Integer | PK of the quote proposal |
Relationship_Id | Integer | FK to the relationship that owns this quote proposal |
Opportunity_Id | Integer | FK to the opportunity that owns this quote proposal |
Funder_Id | Integer | FK to the funder currently assigned to this quote proposal |
Salesperson_Id | Integer | FK to the salesperson that owns the opportunity or relationship that owns this quote proposal |
Quote | Boolean | True = record represents a quote, False = record represents a proposal |
Extension | Boolean | True = record is a quote for an extension of an existing contract |
Ntu | Boolean | True = proposal was Not Taken Up |
Finance_Status | String(255) | The status of the quote proposal |
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 |
Relationship_Name | String(255) | The name of the relationship that owns this quote poroposal |
Funder_Name | String(255) | The name of the funder currently assigned to this quote proposal |
Salesperson_Name | String(255) | The name of the salesperson that owns the opportunity or relationship that owns this quote proposal |
Asset_Type | String(255) | For automotive quote proposals, whether this is a CAR or LCV. For asset quote proposals, the user configured asset type |
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) | For vehicle quote proposals, the on the road price |
Product_Type | String(255) | The finance product |
Maintenance | Boolean | True = the quote proposal has a maintenance product |
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 quote proposal |
Finance_Payment | Number(20,2) | The regular finance payment for the quote proposal |
Service_Payment | Number(20,2) | The regular service payment for the quote proposal |
Target_Delivery | String(50) | Free text description of target delivery |
Int_Target_Delivery_date | Date | Date when the vehicle is expected to be available for delivery |
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 |