Field Listing for Table CALLNOTES
| Field: | TICKETID | Type: | INTEGER |
| Field: | CALLMETHOD | Type: | VARCHAR Length: 20 |
| Field: | CALLDATE | Type: | DATE |
| Field: | CALLTIME | Type: | TIME |
| Field: | CALLSTATUS | Type: | VARCHAR Length: 20 |
| Field: | CALLCONTACT | Type: | VARCHAR Length: 100 |
| Field: | COMPANYTYPE | Type: | VARCHAR Length: 10 |
| Field: | COMPANYNAME | Type: | VARCHAR Length: 50 |
| Field: | CALLADDITIONALDETAILS | Type: | VARCHAR Length: 100 |
| Field: | CALLPHONEORMOBILE | Type: | VARCHAR Length: 50 |
| Field: | CALLEMAIL | Type: | VARCHAR Length: 100 |
| Field: | CALLLEADSOURCE | Type: | VARCHAR Length: 20 |
| Field: | CALLCLASSIFICATION | Type: | VARCHAR Length: 50 |
| Field: | CALLSUBCLASS | Type: | VARCHAR Length: 50 |
| Field: | CALLBRIEFDESCRIPTION | Type: | VARCHAR Length: 100 |
| Field: | CALLNOTE | Type: | BLOB |
| Field: | ACTIONREQUIRED | Type: | BOOLEAN |
| Field: | ACTIONPRIORITY | Type: | VARCHAR Length: 10 |
| Field: | ACTIONREQUIREDDATE | Type: | DATE |
| Field: | ACTIONASSIGNEDTO | Type: | VARCHAR Length: 30 |
| Field: | ACTIONCCEDTO | Type: | VARCHAR Length: 30 |
| Field: | ACTIONHISTORY | Type: | BLOB |
| Field: | ACTIONCOMPLETED | Type: | BOOLEAN |
| Field: | ACTIONSIGNOFFDATE | Type: | DATE |
| Field: | ACTIONSIGNOFFBY | Type: | VARCHAR Length: 30 |
| Field: | CALLRESOLUTIONCODE | Type: | VARCHAR Length: 50 |
| Field: | CALLRESOLUTIONNOTE | Type: | BLOB |
| Field: | CALLRELATESTO | Type: | VARCHAR Length: 20 |
| Field: | CALLLINKEDTO | Type: | VARCHAR Length: 90 |
| Field: | CLOSEDDATE | Type: | DATE |
| Field: | CLOSEDTIME | Type: | TIME |
| Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_5 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_6 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_7 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_8 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_3 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_4 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_5 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_6 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_7 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_8 | Type: | DATE |
| Field: | SERVICEAGREEMENT | Type: | VARCHAR Length: 30 |
| Field: | SEVERITYLEVEL | Type: | INTEGER |
| Field: | LEVELDESCRIPTION | Type: | VARCHAR Length: 50 |
| Field: | AGREEMENTNOTES | Type: | BLOB |
| Field: | CURRENTSERVICESTEP | Type: | VARCHAR Length: 20 |
| Field: | CUSTASSETNAME | Type: | VARCHAR Length: 90 |
| Field: | CALLADDRESS1 | Type: | VARCHAR Length: 50 |
| Field: | CALLADDRESS2 | Type: | VARCHAR Length: 50 |
| Field: | CALLADDRESS3 | Type: | VARCHAR Length: 50 |
| Field: | CALLPOSTALCODE | Type: | VARCHAR Length: 20 |
| Field: | CALLSTATE | Type: | VARCHAR Length: 20 |
| Field: | CALLCITY | Type: | VARCHAR Length: 30 |
| Field: | CALLCOUNTRY | Type: | VARCHAR Length: 30 |
| Field: | CURRENTDUECOLOUR | Type: | INTEGER |
| Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | CALLSTYLE | Type: | VARCHAR Length: 30 |
| Field: | PIPELINENAME | Type: | VARCHAR Length: 50 |
| Field: | CURRENTSTAGE | Type: | VARCHAR Length: 20 |
| Field: | CURRENTSTAGECOLOUR | Type: | INTEGER |
| Field: | EXPECTEDREVENUE | Type: | DOUBLE |
| Field: | EXPECTEDCOST | Type: | DOUBLE |
| Field: | EXPECTEDDATE | Type: | DATE |
| Field: | PROBABILITYPERCENT | Type: | INTEGER |
| Field: | COMPLETIONPERCENT | Type: | INTEGER |
| Field: | SALESOPPORTUNITY | Type: | BOOLEAN |
| Field: | RESPONSIBILITY | Type: | VARCHAR Length: 30 |
| Field: | STRENGTHNOTES | Type: | BLOB |
| Field: | WEAKNESSNOTES | Type: | BLOB |
| Field: | BENEFITNOTES | Type: | BLOB |
| Field: | RISKNOTES | Type: | BLOB |
| Field: | COMPETITIONNOTES | Type: | BLOB |
| Field: | READINESSSTATUS | Type: | VARCHAR Length: 20 |
| Field: | AUTOUPDATING | Type: | INTEGER |
| Field: | CALLMOBILE | Type: | VARCHAR Length: 20 |
| Field: | CALCULATEDPROBABILITY | Type: | INTEGER |
| Field: | COMPANYSTYLE | Type: | VARCHAR Length: 20 |
| Field: | COMPANYREGION | Type: | VARCHAR Length: 20 |
| Field: | SERVICEID | Type: | VARCHAR Length: 30 |
| Field: | URGENTTICKET | Type: | BOOLEAN |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |