Table Name:con_fin_accnt_role
Table Number:5699
Group:Billing Manager
Description:Gives roles which contacts and financial accounts play for one another
Flags: 
Baseline/Custom:Baseline
select * from table_con_fin_accnt_role
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
activeLONGsmallint   DIRECT Indicates whether the role is currently being used; i.e., 0=inactive, 1=active  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
focus_typeLONGsmallint   DIRECT Object type ID of the role-player; i.e., 15=an installed part's role, 173=a business organization's role  
last_updateCLK_TIMEdatetime   CHANGE_DATE Date time of last update  
objidLONGint3  DIRECT Internal record number Search (2)
role_nameCHARvarchar 80  Name of the role Search (2)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
con_accnt_role2contactMTOcontactcontact2con_fin_accnt_roleThe related contact   Search (2)
fin_accnt_role2fin_accntMTOfin_accntaccnt2con_fin_accnt_roleThe related financial account   Search (2)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5699role_name:con_accnt_role2contact:fin_accnt_role2fin_accntUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
car2c5699con_accnt_role2contact, role_name, fin_accnt_role2fin_accntnonclustered located on PRIMARY
far2fa5699fin_accnt_role2fin_accnt, role_name, con_accnt_role2contactnonclustered located on PRIMARY
I5699role_name, con_accnt_role2contact, fin_accnt_role2fin_accntnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
rnfar2fa5699role_name, fin_accnt_role2fin_accnt, con_accnt_role2contactnonclustered located on PRIMARY
My Recent Objects
con_fin_accnt_role      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user