Table Name:addr_ba_role
Table Number:5700
Group:Billing Manager
Description:Gives roles which address and billing arrangements play for one another
Flags: 
Baseline/Custom:Baseline
select * from table_addr_ba_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 (1)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
address_role2addressMTOaddressaddress2addr_ba_roleThe related address   Search (2)
blg_argmnt_role2blg_argmntMTOblg_argmntblg_argmnt2addr_ba_roleThe related billing arrangement   Search (2)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5700role_name:address_role2address:blg_argmnt_role2blg_argmntUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ar2a5700address_role2address, role_name, blg_argmnt_role2blg_argmntnonclustered located on PRIMARY
bar2ba5700blg_argmnt_role2blg_argmnt, role_name, address_role2addressnonclustered located on PRIMARY
I5700role_name, address_role2address, blg_argmnt_role2blg_argmntnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
rnbar2ba5700role_name, blg_argmnt_role2blg_argmnt, address_role2addressnonclustered located on PRIMARY
My Recent Objects
addr_ba_role      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user