Table Name:account
Table Number:163
Group:Sales Mgr
Description:Reserved; obsolete. Replaced by bus_org (173)
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
account_idCHARvarchar 40  Local identifier of the account  
annual_revnDECIMALdecimal (19,4)   CURRENCY Latest annual revenue amount for the account  
comp_productCHARvarchar 255  A high-level description of competitor products  
comp_psnCHARvarchar 40  How we rank in the account as compared to our competitor. This is a user-defined pop up  
cust_sinceCLK_TIMEdatetime    Date business organization became a customer  
descriptionCHARvarchar 255  Description of the account  
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
inst_prodCHARvarchar 255  A high-level description of the products installed at the business organization  
nameCHARvarchar280  Name of the account  
objidLONGint3  DIRECT Internal record number  
ownershipCHARvarchar 25  Reserved not used; see bus_org  
productCHARvarchar 255  Reserved not used; see bus_org  
ptl_revnDECIMALdecimal (19,4)   CURRENCY Total potential revenue at the account from all opportunities  
sales_ratingCHARvarchar 25  Rating as sale's prospect (A,B,C,D). This is a user-defined pop up  
size_emplLONGint   DIRECT Reserved not used; see bus_org  
stock_symCHARvarchar 10  Stock symbol  
tax_exemptCHARvarchar 25  Tax exempt number for the account  
typeCHARvarchar 40  Account type. This is a user-defined popup with default name Account Type  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
account2bus_orgOTOPbus_orgbus_org2accountRelated bus_org. Reserved; obsolete    
default2price_progOTOPprice_progdefault2accountDefault price schedule for the account. Reserved; obsolete    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
account_indexaccount_idUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
account_indexaccount_idnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
account