PRICE_SCHEME Table
Contains pricing schedules for the block pricing of schemes.
| Field | Data Type | Description |
|---|---|---|
|
LABCODE |
Variable string (10) |
Laboratory code. |
|
CONV_CODE |
Variable string (20) |
Code for the currency. |
|
PRICECODE |
Variable string (20) |
Code for the price item, from the PRICE table. |
|
RANGESEQUENCE |
Variable string (4) |
Sequence of the price schedule, from 0001 to 9999. |
|
RANGEUPTO |
Real |
Amount up to which a priced item is priced at the given PRICE. Examples: Up to 10 samples, up to 20 analytes, up to 2 hours. |
|
PRICE |
Real |
Block price. |
|
RANGEMIN |
Real |
Minimum block price for the range. |
|
RANGEMAX |
Real |
Maximum block price for the range. |
Primary key
LABCODE + CONV_CODE + PRICECODE + RANGESEQUENCE
Foreign key
LABCODE + CONV_CODE + PRICECODE --> PRICE. LABCODE + CONV_CODE + PRICECODE
