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. |