| Name | Description | Type | Additional information |
|---|---|---|---|
| construction_id | integer |
None. |
|
| financetype | string |
None. |
|
| interestrate | decimal number |
None. |
|
| loanterm | integer |
None. |
|
| contractprice | decimal number |
None. |
|
| downpayment | decimal number |
None. |
|
| miscellaneous | decimal number |
None. |
|
| short_info | string |
Required |
|
| description | string |
Required Data type: MultilineText |
|
| brokerid | integer |
None. |
|
| brokername | string |
None. |
|
| directorid | integer |
None. |
|
| directorname | string |
None. |
|
| managerid | integer |
None. |
|
| managername | string |
None. |
|
| salesagentid | integer |
None. |
|
| salesagentname | string |
None. |
|
| clientid | integer |
None. |
|
| clientname | string |
None. |
|
| client_lastname | string |
Required |
|
| client_firstname | string |
Required |
|
| client_middlename | string |
None. |
|
| client_address | string |
None. |
|
| client_birthdate | date |
None. |
|
| client_phonenumber | string |
None. |
|
| client_tinnumber | string |
None. |
|
| client_emailaddress | string |
None. |
|
| requirement_id | integer |
None. |
|
| submitted_requirements | string |
None. |
|
| requirements_complete | boolean |
None. |
|
| transaction_date | date |
None. |
|
| status | string |
None. |
|
| date_added | date |
None. |
|
| added_by | string |
None. |
|
| stamp | date |
None. |