usm_numeric_policy

Defines the policy used in determining the currency while billing

Column Name Column Datatype Column Null Option Column Comment
policy_id varchar(30) not null Unique id.
scale integer with null The number of digits to the right of the decimal point.
rounding_mode integer with null ROUND_CEILING - Rounding mode to round towards positive infinity. ROUND_DOWN - Rounding mode to round towards zero. ROUND_FLOOR - Rounding mode to round towards negative infinity. ROUND_HALF_DOWN - Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round down. ROUND_HALF_UP - Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up. ROUND_UNNECESSARY - Rounding mode to assert that the requested operation has an exact result, hence no rounding is necessary. ROUND_UP - Rounding mode to round away from zero.
negative_symbol varchar(4) with null Negative symbol to be used.
display_leading_zeros integer1 with null Indication to display leading zeros.
type integer not null Type = 1 for quantity based Type = 2 for currency based
min_scale integer with null  

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.