Contract Table
- Daniel Layne
Column | Type | Description |
|---|---|---|
Relationship_Id | Integer | FK to the relationship that owns this contract |
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 |
Contract_Number | String | A textual reference for the contract. |
Quote | Boolean | True = record represents a quote, False = record represents a proposal |
Contract_Status | String(255) | The status of the contract |
Relationship_Name | String(255) | The name of the relationship that owns this contract |
Funder_Name | String(255) | The name of the funder assigned to this contract |
Salesperson_Name | String(255) | The name of the salesperson that owns the relationship that owns this contract |
Introducer | String(255) | The name of the introducer related to this contract |
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 |
Registration_Number | String(13) | For vehicle contracts, the registration number of the related vehicle |
Amount_Financed | Number(20,2) | The amount financed at the start of the contract |
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 |
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 |
Inception_Date | Date | Date the contract began |
Maturity_Date | Date | Date the contract will/did mature |
Extension_End_Date | Date | Date the contract extension will end |
Informal_Extension | Boolean | True = contract is in an informal extension |
Formal_Extension | Boolean | True = contract is in a formal extension |
Early_Termination | Boolean | True = contract has been early terminated |
Apr | Number(10,6) | The assumed APR of the contract at its start |
Residual_Value | Number(20,2) | The anticipated residual value of the asset or vehicle at the maturity date of the contract |
Creation_Date | Timestamp | When the record was created |
Last_Update_Date | Timestamp | When the record was last updated |