Support_incidents

The CRM Fields and Entity Fields custom fields are available for the Support Incidents table.

Columns

Name Type Length Precision Scale References In Description
assigned_id NUMBER 39 0 entity_id
Entity
Assigned ID
case_email VARCHAR2 300 Case email
case_extid VARCHAR2 255 Case external ID
case_id NUMBER 39 0 Case ID
case_issue_id NUMBER 39 0 case_issue_id
Caseissue
Case issue ID
case_number NUMBER 39 0 Case number
case_numbercode VARCHAR2 99 Case number code
case_origin_id NUMBER 39 0 case_origin_id
Case_origins
Case origin ID
case_phone VARCHAR2 99 Case phone number
case_profile_id NUMBER 39 0 Case profile ID
case_stage VARCHAR2 12 Case stage
case_type_id NUMBER 39 0 case_type_id
Case_types
Case type ID
comments VARCHAR2 4000 Comments
company_id NUMBER 39 0 entity_id
Entity
Company ID
contact_id NUMBER 39 0 contact_id
Contacts
Contact ID
create_date TIMESTAMP Create date (GMT)
date_closed TIMESTAMP Date closed
date_last_modified TIMESTAMP Date last modified
entry_time TIMESTAMP Incident time
helpdesk VARCHAR2 3 Help desk
inboundemail VARCHAR2 300 Inbound email
isinactive VARCHAR2 3 Inactive
item_id NUMBER 39 0 item_id
Items
Item ID
last_modification TIMESTAMP Last modification
last_reopened_date TIMESTAMP Last reopened date
module_name VARCHAR2 4000 Module name
name VARCHAR2 256 Name
owner_id NUMBER 39 0 entity_id
Entity
Owner ID
priority VARCHAR2 64 Priority
product VARCHAR2 64 Product
stage VARCHAR2 30 Stage
status VARCHAR2 64 Status
subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Subsidiary ID
territory_id NUMBER 39 0 territory_id
Territory
Territory ID

Primary key

PK Column Name
case_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
support_incidents_case_origins_fk case_origin_id Case_origins case_origin_id 1
support_incidents_case_types_fk case_type_id Case_types case_type_id 1
support_incidents_caseissue_fk case_issue_id Caseissue case_issue_id 1
support_incidents_contacts_fk contact_id Contacts contact_id 1
support_incidents_entity_fk owner_id Entity entity_id 1
support_incidents_entity_fk_2 assigned_id Entity entity_id 1
support_incidents_entity_fk_3 company_id Entity entity_id 1
support_incidents_items_fk item_id Items item_id 1
support_incidents_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1
support_incidents_territory_fk territory_id Territory territory_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Case_stage_changes_support_incidents_fk case_id Case_stage_changes case_id 1
Caseescalationhistory_support_incidents_fk case_id Caseescalationhistory case_id 1