| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SETID | Number/character defining a set of physical properties data | nvarchar | 2 | 0 | CHAR | (N' ') | No | OIB_PPP_HEADER | OIB_SET_NUMBER | Allow NULL? |
| 3 | PAR_NAME | Parameter of the Quantity Conversion Interface | nvarchar | 10 | 0 | CHAR | (N' ') | No | OIB07 | OIB_PAR_NAME | Allow NULL? |
| 4 | MOLWEIGHT | Molecular weight of natural gas:return value from AGA c-code | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MOLWEIGHT | |
| 5 | BOILPOINTTEMP | Boiling point: temperature at reference pressure | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BOILPOINTTEMP | |
| 6 | FREEZPOINTTEMP | Freezing point: temperature, at defined pressure | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_FREEZPOINTTEMP | |
| 7 | VAPRES | Vapor pressure of liquid petroleum gases (LPG) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_VAPRES | |
| 8 | BDICHLIQUID | Gas component - liquid absolute density at base conditions | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BDICHABS | |
| 9 | API | Gas component liquid API gravity at base conditions | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_API | |
| 10 | RELDICHLIQUID | Gas component - liquid relative density at base conditions | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BDICHREL | |
| 11 | RELDICHGAS | Gas component ideal gas relative density at base conditions | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BDICHRELGS | |
| 12 | BDICHGAS | Gas component -ideal gas absolute density at base conditions | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BDICHGS | |
| 13 | SUMMATIONFACTOR | Summation factor (1/pressure) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_SUMMATIONFACTOR | |
| 14 | LIQ_GAL_LBMOL | Ratio of liquid component, volume / mol | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_LGRATGALLBMOL | |
| 15 | FT3IDGSGALLIQUID | Ratio of ideal gas volume in cubic feet per liquid gallon | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_LGRATFT3IDGS | |
| 16 | VOLRATIO | Ratio of liquid to gaseous volume of component | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_LGRAT | |
| 17 | CRITPRES | Critical pressure of natural gas component | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CRITPRS | |
| 18 | CRITTEMP | Critical temperature of natural gas component | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CRITTMP | |
| 19 | BHVALLQSUP | Gas component heating value, superior, fuel as liquid | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BHVALLQSUP | |
| 20 | BHVALGSSUP | Gas comp. heat. value,superior, id. react. fuel as ideal gas | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BHVALGSSUP | |
| 21 | BHVALGSINF | Gas comp. heat. value, inferior, ideal reaction, ideal gas | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BHVALGSINF | |
| 22 | VOLAIRGASRAT | Volume of air to burn one volume of ideal gas(dimensionless) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_AIR_GAS_RAT | |
| 23 | HVALVAPOR | Heat of vaporization (heat. value at boiling point) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_HVALVAPOR | |
| 24 | SPECHEATCV | Specific heat of natural gas component: C_v | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_SPECHEATCV | |
| 25 | SPECHEATCP | Specific heat of natural gas component: C_p | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_SPECHEATCP | |
| 26 | SPECHEATCS | Specific heat of natural gas component: saturated liquid | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_SPECHEATCS | |
| 27 | FLLIMUP | Flammability limit, upper, Vol% in air | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_FLLIMUP | |
| 28 | FLLIMLOW | Flammability limit, lower, Vol% in air | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_FLLIMLOW | |
| 29 | OCTANEMOT | Octane number (motor clear) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MOTORCLEAR | |
| 30 | OCTANERES | Octane number (research clear) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_RESEARCH | |
