| 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 |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| pf_active | price_factor | active | 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 | |
| pf_amt | price_factor | fxd_amt | Gives a fixed currency amount for the discount or surcharge | |
| pf_base | price_factor | factor_base | How the price factor is applied; i.e. 1=against the base price, 2=against the net price | |
| pf_desc | price_factor | description | The description of the discount or surcharge | |
| pf_eli_dtl | price_factor | eligible_dtl | Indicates whether this factor can be applied at the quote/contract detail level; i.e., 0=no, 1=yes, default=1 | |
| pf_eli_hdr | price_factor | eligible_hdr | Indicates whether this factor can be applied at the quote/contract header level; i.e., 0=no, 1=yes, default=1 | |
| pf_end | price_factor | end_date | Last day the price factor was effective | |
| pf_id | price_factor | factor_id | Internal record number of the price_factor object | |
| pf_name | price_factor | name | The name of the discount or surcharge | |
| pf_objid | price_factor | objid | Internal record number of the price_factor object | |
| pf_perc | price_factor | pct | The percentage to be applied as a discount or surcharge | |
| pf_precedence | price_factor | precedence | The order in which the price factor should be applied against the base price | |
| pf_start | price_factor | start_date | First day the price factor became effective | |
| pf_type | price_factor | type | Indicates whether the price factor is a discount or surcharge | |
| pr_amt | contr_pr | fxd_amt | Indicate a fixed currency amount applied to the price | |
| pr_base | contr_pr | factor_base | How the price factor was applied; i.e. 1=against the base price, 2=against the net price | |
| pr_eff_end | contr_pr | eff_end_dt | Last day the price factor was effective | |
| pr_eff_start | contr_pr | eff_start_dt | The date that the price factor becomes effective | |
| pr_ext_amt | contr_pr | extended_amt | The extended amount whether fixed amount or percentage | |
| pr_is_man_adj | contr_pr | is_man_adj | Indicates whether the adjustment was predefined: i.e., 0=predefined, 1=manual adjustment | |
| pr_notes | contr_pr | notes | Notes about the applied price factor | |
| pr_objid | contr_pr | objid | Internal record number of the contr_pr object | 3 (UNIQUE) |
| pr_perc | contr_pr | pct | The percentage applied to the price | |
| pr_precedence | contr_pr | precedence | The order in which the price factor should be applied against the base price | |
| pr_symbol | contr_pr | symbol | Currency symbol for the applied price factor; e.g., $ for US dollar | |
| pr_type | contr_pr | type | Indicates whether the applied price factor was a discount or surcharge |
Join From | Join To |
|---|---|
| (contr_pr).contr_pr2price_factor | (price_factor).price_factor2contr_pr |
| contr_pr_pf | |||