Home > Technical > Table Definitions > ROUNDRULEDTL

ROUNDRULEDTL

Rounding rules are used when proposing sell prices. A rounding rule has one header and multiple details. This table stores the detail information. The headers are stored in ROUNDRULEHDR.

Column Type Description
LINTROUNDRULE INT The code of the rounding rule header that this detail belongs to.
ROUNDRULEHDR.ctrCode
CTRCODE INT A unique number assigned by the system.
CURFROMDOLLAR DECIMAL(19,4) If the Base Sell Price is greater than or equal to this and less than or equal to curToDollar, this rule will be examined for further
CURTODOLLAR DECIMAL(19,4) See curFromDollar.
STRTYPE VARCHAR(1) ‘A’= Adjust cents. This will examine curFromCents and curToCents and if within the range, will adjust the cents to the value in curAmount.‘S’= Set Sell Price. This will set the sell price to the curAmount without any further checks.
CURFROMCENTS DECIMAL(19,4) If the strType = ‘A’ then the cents of the Base Sell Price is compared to this field and curToCents. If it is within the range, the cents of the Rounded Sell Price will be set to curAmount.
CURTOCENTS DECIMAL(19,4) See curFromCents.
CURAMOUNT DECIMAL(19,4) If strType = ‘A’, see curFromCents. If strType =’S’, the Rounded Sell Price will be set to this specific value.
 

Primary Key: LINTROUNDRULE + CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)