Table Name:price_factor
Table Number:99
Group:Sales Mgr
Description:Describes discounts and surcharges which may be applied against specific base prices as expressed in the price_inst object
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
activeLONGtinyint  DIRECT Indicates if the discount or surcharge is currently available for selection in the process of building quotes or contracts; i.e., 0=no, 1=yes, default=1 Search (2)
descriptionCHARvarchar 255  The description of the discount or surcharge Search (2)
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
eligible_dtlLONGtinyint  DIRECT Indicates whether this factor can be applied at the quote/contract detail level; i.e., 0=no, 1=yes, default=1 Search (2)
eligible_hdrLONGtinyint  DIRECT Indicates whether this factor can be applied at the quote/contract header level; i.e., 0=no, 1=yes, default=1 Search (2)
end_dateCLK_TIMEdatetime    Last date the price factor is effective Search (2)
factor_baseLONGtinyint   DIRECT How the price factor is applied; i.e. 1=against the base price, 2=against the net price Search (2)
factor_idCHARvarchar 40  The unique identifier of the discount or surcharge Search (2)
fxd_amtDECIMALdecimal (19,4)   CURRENCY Gives a fixed currency amount for the discount or surcharge Search (2)
nameCHARvarchar 80  The unique name of the discount or surcharge Search (2)
objidLONGint3  DIRECT Internal record number Search (2)
pctDECIMALdecimal (19,4)    The percentage to be applied as a discount or surcharge Search (2)
precedenceLONGtinyint   DIRECT The order in which the price factor should be applied against the base price Search (2)
start_dateCLK_TIMEdatetime    Date the price factor becomes effective Search (2)
typeCHARvarchar 40  Indicates the type e.g., 'Discount -Percentage', 'Discount - Fixed Amount' 'Surcharge Percentage', 'Surcharge Fixed Amount' Search (2)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
price_factor2bus_prf_roleOTMbus_prf_rolebu_pf_role2price_factorBus_org roles for the price factor    
price_factor2contr_prOTMcontr_prcontr_pr2price_factorContract headers or line items adjusted using the price factor    
factor2currencyMTOcurrencycurrency2price_factorCurrency in which the discount/surcharge is denominated   Search (1)
eligibility2price_instMTMprice_insteligibility2price_factorPrice items that are authorized to use the price factor; Reserved; not used  mtm_price_factor0_
price_inst3
 
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
id_indfactor_idUNIQUE 
name_indnameUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
id_indfactor_idnonclustered, unique located on PRIMARY
name_indnamenonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
426contr_pr_pf contr_pr, price_factor
5062p_factor_view currency, price_factor
My Recent Objects
price_factor