PRCONVALUE

Each row of this table represents a price constant value. Price constant value could be number or monetary amount.

Column Descriptions:

NameTypeDescription
PRCONSTANT_IDBIGINT NOT NULLGenerated Key
CURRENCYCHAR (3) NOT NULLThe currency for the monetary type price constant. If empty, it indicates the value is a number type price constant.
VALUEDECIMAL (20,5) NOT NULLThe value of the price constant.
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>PRCONSTANT_ID+CURRENCYPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3638PRCONSTANT_IDPRCONSTANTPRCONSTANT_IDCascade