active | LONG | tinyint | | | 1 | 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) |
description | CHAR | varchar | | 255 | | | The description of the discount or surcharge | Search (2) |
dev | LONG | int | 151 | | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | |
eligible_dtl | LONG | tinyint | | | 1 | 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_hdr | LONG | tinyint | | | 1 | 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_date | CLK_TIME | datetime | | | | | Last date the price factor is effective | Search (2) |
factor_base | LONG | tinyint | | | | DIRECT | How the price factor is applied; i.e. 1=against the base price, 2=against the net price | Search (2) |
factor_id | CHAR | varchar | | 40 | | | The unique identifier of the discount or surcharge | Search (2) |
fxd_amt | DECIMAL | decimal (19,4) | | | | CURRENCY | Gives a fixed currency amount for the discount or surcharge | Search (2) |
name | CHAR | varchar | | 80 | | | The unique name of the discount or surcharge | Search (2) |
objid | LONG | int | 3 | | | DIRECT | Internal record number | Search (2) |
pct | DECIMAL | decimal (19,4) | | | | | The percentage to be applied as a discount or surcharge | Search (2) |
precedence | LONG | tinyint | | | | DIRECT | The order in which the price factor should be applied against the base price | Search (2) |
start_date | CLK_TIME | datetime | | | | | Date the price factor becomes effective | Search (2) |
type | CHAR | varchar | | 40 | | | Indicates the type e.g., 'Discount -Percentage', 'Discount - Fixed Amount' 'Surcharge Percentage', 'Surcharge Fixed Amount' | Search (2) |