| Name | Description | Type | Additional information |
|---|---|---|---|
| leadID | integer |
None. |
|
| SMLeadId | integer |
None. |
|
| leadCategoryID | integer |
None. |
|
| leadType | integer |
None. |
|
| captureDate | date |
None. |
|
| captureUser | string |
None. |
|
| LsnClientID | integer |
None. |
|
| saleDate | date |
None. |
|
| saleUser | string |
None. |
|
| ChgCategoryUserID | integer |
None. |
|
| LsnAddressID | integer |
None. |
|
| sourceTypeID | integer |
None. |
|
| workTypeID | string |
None. |
|
| LsnCustCode | string |
None. |
|
| LsnBranchCode | string |
None. |
|
| addressAuthenticated | integer |
None. |
|
| LsnDivision | integer |
None. |
|
| LsnSubDivision | integer |
None. |
|
| LsnMainArea | string |
None. |
|
| LsnSubArea | string |
None. |
|
| TecAreaId | integer |
None. |
|
| SalesBranch | integer |
None. |
|
| SalesArea | integer |
None. |
|
| suburbID | integer |
None. |
|
| Title | string |
None. |
|
| FirstNames | string |
None. |
|
| Surname | string |
None. |
|
| Cell | string |
None. |
|
| PremisesPh | string |
None. |
|
| ContactPh | string |
None. |
|
| string |
None. |
||
| LanguagePreference | string |
None. |
|
| IDnumber | string |
None. |
|
| IdType | string |
None. |
|
| PassportNo | string |
None. |
|
| CompanyRegNo | string |
None. |
|
| VATnumber | string |
None. |
|
| SuspendMode | string |
None. |
|
| SuspendReason | string |
None. |
|
| CustDesc | string |
None. |
|
| BuildingNo | string |
None. |
|
| Building | string |
None. |
|
| StreetNo | string |
None. |
|
| StreetName | string |
None. |
|
| StreetType | string |
None. |
|
| Suburb | string |
None. |
|
| Town | string |
None. |
|
| Province | string |
None. |
|
| Country | string |
None. |
|
| AreaPostalCode | string |
None. |
|
| Latitude | decimal number |
None. |
|
| Longitude | decimal number |
None. |
|
| ResidentialFlag | string |
None. |
|
| newClient | integer |
None. |
|
| newAddress | integer |
None. |
|
| newDebtor | integer |
None. |
|
| debtorID | integer |
None. |
|
| processID | integer |
None. |
|
| modifyDetails | integer |
None. |
|
| BusinessName | string |
None. |
|
| workflowID | integer |
None. |
|
| CompanyID | integer |
None. |
|
| followUp | date |
None. |
|
| AEName | string |
None. |
|
| AEStreetNo | string |
None. |
|
| AEStreetName | string |
None. |
|
| AEArea | string |
None. |
|
| AEType | string |
None. |
|
| SMdebtorID | integer |
None. |
|
| PayRefNo | string |
None. |
|
| regionID | integer |
None. |
|
| SentToCAD | date |
None. |
|
| SentToCredit | date |
None. |
|
| DeleteDate | date |
None. |
|
| excludeCategories | integer |
None. |
|
| exclusionUser | string |
None. |
|
| LsnSiteType | string |
None. |
|
| isHomeAutomation | integer |
None. |
|
| BDI | string |
None. |
|
| TenantId | integer |
None. |
|
| Synched | boolean |
None. |
|
| FaultTypeId | integer |
None. |
|
| LinkOnlyClient | boolean |
None. |
|
| Comment | string |
None. |
|
| Directions | string |
None. |
|
| Police | string |
None. |
|
| Fire | string |
None. |
|
| Medical | string |
None. |
|
| PostalAddressID | integer |
None. |
|
| PostalAddress1 | string |
None. |
|
| PostalAddress2 | string |
None. |
|
| PostalAddress3 | string |
None. |
|
| PostalAddress4 | string |
None. |
|
| PostalCode | string |
None. |
|
| Active | integer |
None. |
|
| TenantID | integer |
None. |