View Name:p_factor_view
View Number:5062
Group:Sales Mgr
Description:Gets price adjustments. Used by forms Line Adjustments (9138) and Schedule Adjustmens(9679)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidprice_factorobjidPrice_factor internal record number 3 (UNIQUE)
factor_idprice_factorfactor_idThe unique identifier of the discount or surcharge 
nameprice_factornameThe name of the discount or surcharge 
descriptionprice_factordescriptionThe description of the discount or surcharge 
typeprice_factortypeIndicates whether the factor is a discount or surcharge 
start_dateprice_factorstart_dateDate the price factor becomes effective 
end_dateprice_factorend_dateLast date the price factor is effective 
precedenceprice_factorprecedenceThe order in which the price factor should be applied against the base price 
activeprice_factoractiveIndicates if the discount or surcharge is currently available for selection in the process of building quotes or contracts; i.e., 0=no, 1=yes 
fixed_amtprice_factorfxd_amtGives a fixed currency amount for the discount or surcharge 
percentageprice_factorpctThe percentage to be applied as a discount or surcharge 
factor_baseprice_factorfactor_baseHow the price factor is applied; i.e. 1=against the base price, 2=against the net price 
eligible_hdrprice_factoreligible_hdrIndicates whether this factor can be applied at the quote/contract header level; i.e., 0=no, 1=yes, default=1 
eligible_dtlprice_factoreligible_dtlIndicates whether this factor can be applied at the quote/contract detail level; i.e., 0=no, 1=yes, default=1 
currency_objidcurrencyobjidCurrency internal record number 
cur_namecurrencynameName of the currency 
cur_symbolcurrencysymbolSymbol for the currency; e.g., $ for US dollar 
cur_desccurrencydescriptionDescription of the currency 
sub_scalecurrencysub_scaleGives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 

Joins:

Join FromJoin To
(price_factor).factor2currency(currency).currency2price_factor
My Recent Objects
p_factor_view