View Name:contr_pr_pf
View Number:426
Group:Sales Mgr
Description:Used by forms Contract (9133), Contract <ID> (9134), More Info (9135, 9674), Line Items (9136, 9175), Line Adjustments (9138), Schedules (9140, 9176), Quote (9672), Quote <ID> (9673) and Schd Adjustments (9679)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
pr_objidcontr_probjidInternal record number of the contr_pr object 3 (UNIQUE)
pf_objidprice_factorobjidInternal record number of the price_factor object 
pr_amtcontr_prfxd_amtIndicate a fixed currency amount applied to the price 
pr_perccontr_prpctThe percentage applied to the price 
pr_precedencecontr_prprecedenceThe order in which the price factor should be applied against the base price 
pr_notescontr_prnotesNotes about the applied price factor 
pr_symbolcontr_prsymbolCurrency symbol for the applied price factor; e.g., $ for US dollar 
pr_basecontr_prfactor_baseHow the price factor was applied; i.e. 1=against the base price, 2=against the net price 
pr_typecontr_prtypeIndicates whether the applied price factor was a discount or surcharge 
pf_idprice_factorfactor_idInternal record number of the price_factor object 
pf_nameprice_factornameThe name of the discount or surcharge 
pf_descprice_factordescriptionThe description of the discount or surcharge 
pf_typeprice_factortypeIndicates whether the price factor is a discount or surcharge 
pf_startprice_factorstart_dateFirst day the price factor became effective 
pf_endprice_factorend_dateLast day the price factor was effective 
pf_precedenceprice_factorprecedenceThe order in which the price factor should be applied against the base price 
pf_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 
pf_amtprice_factorfxd_amtGives a fixed currency amount for the discount or surcharge 
pf_percprice_factorpctThe percentage to be applied as a discount or surcharge 
pf_eli_hdrprice_factoreligible_hdrIndicates whether this factor can be applied at the quote/contract header level; i.e., 0=no, 1=yes, default=1 
pf_eli_dtlprice_factoreligible_dtlIndicates whether this factor can be applied at the quote/contract detail level; i.e., 0=no, 1=yes, default=1 
pf_baseprice_factorfactor_baseHow the price factor is applied; i.e. 1=against the base price, 2=against the net price 
pr_eff_startcontr_preff_start_dtThe date that the price factor becomes effective 
pr_eff_endcontr_preff_end_dtLast day the price factor was effective 
pr_ext_amtcontr_prextended_amtThe extended amount whether fixed amount or percentage 
pr_is_man_adjcontr_pris_man_adjIndicates whether the adjustment was predefined: i.e., 0=predefined, 1=manual adjustment 

Joins:

Join FromJoin To
(contr_pr).contr_pr2price_factor(price_factor).price_factor2contr_pr
My Recent Objects
contr_pr_pf