objid | price_factor | objid | Price_factor internal record number | 3 (UNIQUE) |
factor_id | price_factor | factor_id | The unique identifier of the discount or surcharge | |
name | price_factor | name | The name of the discount or surcharge | |
description | price_factor | description | The description of the discount or surcharge | |
type | price_factor | type | Indicates whether the factor is a discount or surcharge | |
start_date | price_factor | start_date | Date the price factor becomes effective | |
end_date | price_factor | end_date | Last date the price factor is effective | |
precedence | price_factor | precedence | The order in which the price factor should be applied against the base price | |
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 | |
fixed_amt | price_factor | fxd_amt | Gives a fixed currency amount for the discount or surcharge | |
percentage | price_factor | pct | The percentage to be applied as a discount or surcharge | |
factor_base | price_factor | factor_base | How the price factor is applied; i.e. 1=against the base price, 2=against the net price | |
eligible_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 | |
eligible_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 | |
currency_objid | currency | objid | Currency internal record number | |
cur_name | currency | name | Name of the currency | |
cur_symbol | currency | symbol | Symbol for the currency; e.g., $ for US dollar | |
cur_desc | currency | description | Description of the currency | |
sub_scale | currency | sub_scale | Gives 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 | |