| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SETID | Number/character defining a set of physical properties data | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | PAR_NAME | Parameter of the Quantity Conversion Interface | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | MOLWEIGHT | Molecular weight of natural gas:return value from AGA c-code | float | 15 | 16 | | | | |
| 5 | BOILPOINTTEMP | Boiling point: temperature at reference pressure | float | 15 | 16 | | | | |
| 6 | FREEZPOINTTEMP | Freezing point: temperature, at defined pressure | float | 15 | 16 | | | | |
| 7 | VAPRES | Vapor pressure of liquid petroleum gases (LPG) | float | 15 | 16 | | | | |
| 8 | BDICHLIQUID | Gas component - liquid absolute density at base conditions | float | 15 | 16 | | | | |
| 9 | API | Gas component liquid API gravity at base conditions | float | 15 | 16 | | | | |
| 10 | RELDICHLIQUID | Gas component - liquid relative density at base conditions | float | 15 | 16 | | | | |
| 11 | RELDICHGAS | Gas component ideal gas relative density at base conditions | float | 15 | 16 | | | | |
| 12 | BDICHGAS | Gas component -ideal gas absolute density at base conditions | float | 15 | 16 | | | | |
| 13 | SUMMATIONFACTOR | Summation factor (1/pressure) | float | 15 | 16 | | | | |
| 14 | LIQ_GAL_LBMOL | Ratio of liquid component, volume / mol | float | 15 | 16 | | | | |
| 15 | FT3IDGSGALLIQUID | Ratio of ideal gas volume in cubic feet per liquid gallon | float | 15 | 16 | | | | |
| 16 | VOLRATIO | Ratio of liquid to gaseous volume of component | float | 15 | 16 | | | | |
| 17 | CRITPRES | Critical pressure of natural gas component | float | 15 | 16 | | | | |
| 18 | CRITTEMP | Critical temperature of natural gas component | float | 15 | 16 | | | | |
| 19 | BHVALLQSUP | Gas component heating value, superior, fuel as liquid | float | 15 | 16 | | | | |
| 20 | BHVALGSSUP | Gas comp. heat. value,superior, id. react. fuel as ideal gas | float | 15 | 16 | | | | |
| 21 | BHVALGSINF | Gas comp. heat. value, inferior, ideal reaction, ideal gas | float | 15 | 16 | | | | |
| 22 | VOLAIRGASRAT | Volume of air to burn one volume of ideal gas(dimensionless) | float | 15 | 16 | | | | |
| 23 | HVALVAPOR | Heat of vaporization (heat. value at boiling point) | float | 15 | 16 | | | | |
| 24 | SPECHEATCV | Specific heat of natural gas component: C_v | float | 15 | 16 | | | | |
| 25 | SPECHEATCP | Specific heat of natural gas component: C_p | float | 15 | 16 | | | | |
| 26 | SPECHEATCS | Specific heat of natural gas component: saturated liquid | float | 15 | 16 | | | | |
| 27 | FLLIMUP | Flammability limit, upper, Vol% in air | float | 15 | 16 | | | | |
| 28 | FLLIMLOW | Flammability limit, lower, Vol% in air | float | 15 | 16 | | | | |
| 29 | OCTANEMOT | Octane number (motor clear) | float | 15 | 16 | | | | |
| 30 | OCTANERES | Octane number (research clear) | float | 15 | 16 | | | | |
