Table Name:wipbin
Table Number:5
Group:Workflow Mgr
Description:Work in Process bin object which contains an individual's work in process; e.g., cases, subcases, solutions, part requests or change requests
Flags: 
Baseline/Custom:Baseline
select * from table_wipbin
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
descriptionCHARvarchar 255  WIPbin description  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
dialog_idLONGint  375 DIRECT Used to distinguish between ClearSupport & Logistics WIPbins; default posts ClearSupport WIPbin form (375)  
icon_idLONGint16  DIRECT Reserved; obsolete  
objidLONGint3  DIRECT Internal record number Search (29)
ranking_ruleCHARvarchar 80  Reserved; not used  
titleCHARvarchar224  WIPbin title Search (5)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
wipbin2bugOTMbugbug_wip2wipbinChange requests in the WIPbin    
wipbin2caseOTMcasecase_wip2wipbinCases in the WIPbin    
wipbin2contractOTMcontractcontr_wip2wipbinContract objects in the WIPbin    
wipbin2demand_dtlOTMdemand_dtldemand_dtl_wip2wipbinPart request objects in the WIPbin    
wipbin2dialogueOTMdialoguedialogue_wip2wipbinDialogue objects in the WIPbin    
wipbin2employeeMTMemployeeemp_access2wipbinReserved; not used  mtm_wipbin4_
employee7		 
wipbin2jobOTMjobjob_wip2wipbinJob objects in the WIPbin    
wipbin2opportunityOTMopportunityopp_wip2wipbinOpportunity objects in the WIPbin    
wipbin2probdescOTMprobdescprobdesc_wip2wipbinSolutions in the WIPbin    
wipbin2subcaseOTMsubcasesubc_wip2wipbinSubcases in the WIPbin    
wipbin2taskOTMtasktask_wip2wipbinTask objects in the WIPbin    
wipbin_owner2userMTOuserowner2wipbinUser that owns the WIPbin    
default_wipbin2userOTOFuseruser_default2wipbinUser's default WIPbin    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_wipbin_owner2userwipbin_owner2usernonclustered located on PRIMARY
ind_wipbin_titletitlenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
56wipelm_case case, condition, gbst_elm, site, user, wipbin, workaround
57wipelm_subcase condition, gbst_elm, site, subcase, user, wipbin
58wipelm_dtl condition, demand_dtl, gbst_elm, mod_level, part_num, user, wipbin
96wipelm_fnl condition, probdesc, wipbin
116cls_case_view case, condition, contact, employee, site, user, wipbin
121case2wip_sub case, condition, subcase, wipbin
122case2wip_dfe case, disptchfe, wipbin
166cls_sub_view case, condition, contact, employee, site, subcase, user, wipbin
167cls_dfe_view case, condition, contact, disptchfe, employee, site, user, wipbin
195wipelm_bug bug, condition, gbst_elm, part_num, wipbin
381wip_element case, condition, demand_dtl, gbst_elm, mod_level, part_num, wipbin
393dfe_case_user case, disptchfe, queue, user, wipbin
394dfe_subcase_user disptchfe, queue, subcase, user, wipbin
4628fc_wipelm_task condition, gbst_elm, task, wipbin
4650fc_user_case_view case, condition, contact, employee, gbst_elm, queue, site, user, wipbin, workaround
4651fc_user_subcase_view case, condition, contact, employee, gbst_elm, queue, site, subcase, user, wipbin
5037wipelm_contr condition, contract, gbst_elm, wipbin
5039wipelm_opp condition, gbst_elm, opportunity, wipbin
5087wipelm_task condition, gbst_elm, task, wipbin
5291site2case_view case, site, wipbin
5319wipelm_dlg condition, dialogue, gbst_elm, wipbin
5356sfa_opp_wk_v condition, gbst_elm, opportunity, queue, user, wipbin
5358sfa_tsk_wk_v condition, gbst_elm, queue, task, user, wipbin
5462wap_case_info address, case, condition, contact, contract, employee, gbst_elm, queue, site, site_part, user, wipbin
5740case_more_info address, case, condition, contact, country, gbst_elm, queue, site, user, wipbin
5741subcase_overview case, condition, contact, gbst_elm, queue, subcase, user, wipbin
5748wipelm_all wipbin
6018schdl_tracker_sub_v2 address, case, disptchfe, employee, hgsl2hgse, queue, site, user, wipbin
6019schdl_tracker_sub_v3 address, disptchfe, employee, hgsl2hgse, queue, site, subcase, user, wipbin
6025wipelm_demanddtl condition, demand_dtl, gbst_elm, wipbin
My Recent Objects
wipbin      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user