| Name | Description | Type | Additional information |
|---|---|---|---|
| CrmID |
Primary key. Auto-incremented. database reference = CRM.id |
integer |
None. |
| DateOpened |
database reference = CRM.datentime |
date |
None. |
| DateLastAction |
database reference = CRM.lastactiondatentime |
date |
None. |
| Subject |
database reference = CRM.subject |
string |
String length: inclusive between 0 and 50 |
| DepartmentID |
database reference = CRM.departmentid |
integer |
None. |
| StatusID |
database reference = CRM.status |
integer |
None. |
| CustomerName |
database reference = CRM.customer |
string |
String length: inclusive between 0 and 255 |
| CustomerEmail |
database reference = CRM.custemail |
string |
Required String length: inclusive between 0 and 100 |
| CustomerPhone |
database reference = CRM.phone |
string |
String length: inclusive between 0 and 50 |
| CustomerIpAddress |
database reference = CRM.custip |
string |
String length: inclusive between 0 and 50 |
| OrderID |
database reference = CRM.orderid |
integer |
None. |
| CustomerID |
database reference = CRM.custid |
integer |
None. |
| ProductId |
database reference = CRM.productid |
integer |
None. |
| CrmMessageList | Collection of CrmMessage |
None. |