Prodtype table details
- Last UpdatedApr 24, 2025
- 1 minute read
Each record in the prodtype table provides specific information on a product type. A many-to-one relationship exists between prodtype and prodgroup records. A product group can be associated with many product types. The prodtype table contains the following internal fields:
|
Internal Field Name |
Data Type |
Description |
|---|---|---|
|
baseCompressibility |
float |
The compressibility of product at base conditions. |
|
base_dens |
float |
The base density to the Correction Library. |
|
base_dens_units |
enum_densunit_long |
The product density unit in which the product is measured. |
|
compress |
oas_boolean_t |
Is this a compressible product? |
|
description |
description |
Description of the prodgroup record, up to 47 characters in length. |
|
grade |
int |
An integer identifier of the product. |
|
k |
float |
The Isentropic Exponent, which is used in orifice meter calculations to determine a compressible fluid’s expansion factor. |
|
max_dens |
float |
The maximum product density. |
|
min_dens |
float |
The minimum product density. |
|
moleslt |
moleperslot |
A molecular product composition (moleper) record that represents the product type's molecular composition. |
|
name |
pntname |
The name of the product type. |
|
prod_color |
short |
The color used to represent the product type in easy eXtended Operator Station (ezXOS). |
|
prod_grpslt |
prodgroupslot |
The corresponding product group. |
|
sonic_vel |
float |
The Sonic Velocity. Only used if the interface detection application uses sonic velocity as the detection property. |
|
t_coef |
float |
The Thermal Expansion Coefficient. Used if American Petroleum Institute (API) corrections for specialized products are used. |
|
VTtemp |
floatarray |
Used in conjunction with VTvisc to configure the viscosity of the product at a given temperature. |
|
VTvisc |
floatarray |
Used in conjunction with VTtemp to configure the viscosity of the product at a given temperature. |