| Name | Description | Type | Additional information |
|---|---|---|---|
| ID | integer |
None. |
|
| PropertyChainID | integer |
None. |
|
| LinkedTo | integer |
None. |
|
| PropertyID | integer |
None. |
|
| ClientID | integer |
None. |
|
| SolicitorID | integer |
None. |
|
| EstateAgentID | integer |
None. |
|
| MortgageProviderID | integer |
None. |
|
| MortgageBrokerID | integer |
None. |
|
| PropertyOfferID | integer |
None. |
|
| ClientName | string |
String length: inclusive between 0 and 50 |
|
| ClientBusinessName | string |
String length: inclusive between 0 and 50 |
|
| ClientAddress | string |
String length: inclusive between 0 and 255 |
|
| ClientTelephone | string |
String length: inclusive between 0 and 50 |
|
| ClientEmail | string |
String length: inclusive between 0 and 50 |
|
| EstateAgentBusinessName | string |
String length: inclusive between 0 and 50 |
|
| EstateAgentContactName | string |
String length: inclusive between 0 and 50 |
|
| EstateAgentAddress | string |
String length: inclusive between 0 and 255 |
|
| EstateAgentTelephone | string |
String length: inclusive between 0 and 50 |
|
| EstateAgentEmail | string |
String length: inclusive between 0 and 50 |
|
| SolicitorBusinessName | string |
String length: inclusive between 0 and 50 |
|
| SolicitorContactName | string |
String length: inclusive between 0 and 50 |
|
| SolicitorAddress | string |
String length: inclusive between 0 and 255 |
|
| SolicitorTelephone | string |
String length: inclusive between 0 and 50 |
|
| SolicitorEmail | string |
String length: inclusive between 0 and 50 |
|
| MortgageProviderBusinessName | string |
String length: inclusive between 0 and 50 |
|
| MortgageProviderContactName | string |
String length: inclusive between 0 and 50 |
|
| MortgageProviderAddress | string |
String length: inclusive between 0 and 255 |
|
| MortgageProviderTelephone | string |
String length: inclusive between 0 and 50 |
|
| MortgageProviderEmail | string |
String length: inclusive between 0 and 50 |
|
| MortgageBrokerBusinessName | string |
String length: inclusive between 0 and 50 |
|
| MortgageBrokerContactName | string |
String length: inclusive between 0 and 50 |
|
| MortgageBrokerAddress | string |
String length: inclusive between 0 and 255 |
|
| MortgageBrokerTelephone | string |
String length: inclusive between 0 and 50 |
|
| MortgageBrokerEmail | string |
String length: inclusive between 0 and 50 |
|
| Notes | string |
None. |
|
| OfferDate | date |
None. |
|
| ExchangeDate | date |
None. |
|
| CompletionDate | date |
None. |
|
| ChainStatusID | integer |
None. |
|
| InActive | byte |
None. |