Table Name:con_blg_argmnt_role
Table Number:5698
Group:Billing Manager
Description:Gives roles which contacts and billing arrangements play for one another
Flags: 
Baseline/Custom:Baseline
select * from table_con_blg_argmnt_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
ba_role2blg_argmntMTOblg_argmntba2con_blg_argmnt_roleThe related billing arrangement   Search (2)
con_role2contactMTOcontactcontact2con_blg_argmnt_roleThe related contact   Search (2)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5698role_name:con_role2contact:ba_role2blg_argmntUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
br2ba5698ba_role2blg_argmnt, role_name, con_role2contactnonclustered located on PRIMARY
cr2c5698con_role2contact, role_name, ba_role2blg_argmntnonclustered located on PRIMARY
I5698role_name, con_role2contact, ba_role2blg_argmntnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
rnbr2ba5698role_name, ba_role2blg_argmnt, con_role2contactnonclustered located on PRIMARY
My Recent Objects
con_blg_argmnt_role      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user