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 |