CURFORMAT

Each row of this table represents the Language-independent part of a currency formatting rule. If a Store has no formatting rule for a particular currency, it uses the formatting rule of its StoreGroup.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe StoreEntity this formatting rule is part of.
SETCCURRCHAR (3) NOT NULLThe currency. This is a currency code as per ISO 4217 standards.
ROUNDINGMULTIPLEINTEGER NOT NULL DEFAULT 1Rounding multiple according to national law or practice. For example, specify 5 to round dollars to the nearest five cent piece. The default value is 1.
NUMBRUSG_IDINTEGER NOT NULL DEFAULT -1This currency formatting rule should be used when formatting monetary amounts for this usage.
ROUNDINGMETHODCHAR (1) NOT NULL DEFAULT 'R'How to round to a multiple of ROUNDINGMULTIPLE: R = round normally - up or down - to the nearest multiple T = truncate - round down for positive amounts, round up for negative amounts.
DECIMALPLACESINTEGER NOT NULL DEFAULT 2The number of decimal places in a rounded or truncated monetary amount.
MINAPPROVEAMOUNTDECIMAL (20,5)A small amount to be authorized when a backorder is initially submitted, to check that a successful authorization can be obtained. The full amount of the Order will not be authorized until sufficient inventory is allocated to release the backorder.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STOREENT_ID+SETCCURR+NUMBRUSG_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_292NUMBRUSG_IDNUMBRUSGNUMBRUSG_IDCascade
F_293STOREENT_IDSTOREENTSTOREENT_IDCascade
F_294SETCCURRSETCURRSETCCURRCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_291STOREENT_ID+SETCCURR+NUMBRUSG_IDCURFMTDESCSTOREENT_ID+SETCCURR+NUMBRUSG_IDCascade