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