HCPRCCLASS – Price Class

System
Inventory Control (IC)
Prefix
HPC
Primary key
ITEM-GROUP, PRICE-CLASS, COST-LIMIT
Fields
8
Updated by
1 program
Referenced by
3 programs

HCPRCCLASS is the Price Class table in Lawson Inventory Control (prefix HPC). It is indexed by ITEM-GROUP, PRICE-CLASS, COST-LIMIT (HPCSET1). It is related 1:1 to ITEMGROUP. It is updated by PC08.1 and referenced by PC10.1, PC120 and PC810. The table has 8 fields, 1 index and 1 documented relation.

About HCPRCCLASS

This is the Price Class file.

Fields (8)

Column = COBOL field name without the HPC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
HPC-ITEM-GROUP PK
ITEM_GROUP		Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.PC08.1
HPC-PRICE-CLASS PK
PRICE_CLASS		Alpha 4A code that identifies the rules for calculating a patient charge price.PC08.1
HPC-COST-LIMIT PK
COST_LIMIT		Numeric 8An upper limit; the lower limit is either zero, or the upper limit of the previous limit of the same price class. If the cost of an item is within this range, then this rule applies.PC08.1
HPC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PC08.1
HPC-MARKUP-PCT
MARKUP_PCT		Percent 6.2 (Percent)—PC08.1
HPC-ADD-ON-AMT
ADD_ON_AMT		Signed 18.5—PC08.1
HPC-ROUND-UP-AMT
ROUND_UP_AMT		Signed 18.5—PC08.1
HPC-MINIMUM-PRICE
MINIMUM_PRICE		Signed 18.5—PC08.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HPCSET1ITEM-GROUP, PRICE-CLASS, COST-LIMITPrimaryPC08.1, PC10.1, PC120, PC810

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequiredHPC-ITEM-GROUP → ITG-ITEM-GROUP

Programs

Updated by (1)

Referenced by (3)