| 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 | T000 | MANDT | Allow NULL? |
| 2 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | CHAR | (N' ') | No | | OIB_UMRSL | Allow NULL? |
| 3 | PDTYP | Oil product type | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_PDTYP | Allow NULL? |
| 4 | BSTMP | Oil/gas standard/base temperature | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BSTMP | |
| 5 | BSTEH | Oil/gas standard/base temperature unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BSTEH | Allow NULL? |
| 6 | WQTYL | Lower warning tolerance limit for manual entries (in %) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_WQTYL | |
| 7 | WQTYH | Upper warning tolerance limit for manual entries (in %) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_WQTYH | |
| 8 | EQTYL | Lower Tolerance Limit for Manual Quantity Entries (in %) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_EQTYL | |
| 9 | EQTYH | Upper Tolerance Limit for Manual Quantity Entries (in %) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_EQTYH | |
| 10 | DNTYP | Density Type | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_DNTYP | Allow NULL? |
| 11 | VCFLN | Volume correction factor | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_VCFLN | Allow NULL? |
| 12 | MCFI | Meter correction factor indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_MCFI | Allow NULL? |
| 13 | PDCL | Oil/Gas product conversion class | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_PDCL | Allow NULL? |
| 14 | HVTYP | Heating value type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_HVTYP | Allow NULL? |
| 15 | BPRESH | Natural Gas Base Pressure for Combustion (Heating Value) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BPRESH | |
| 16 | BPRESHEH | Natural gas std/base press.: combustion (heat. value): unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BPRESHEH | Allow NULL? |
| 17 | BSTMPH | Natural Gas Base Temperature of Combustion (Heating Value) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BSTMPH | |
| 18 | BSTMPHEH | Natural gas std/base temp.: combustion (heat. value): unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BSTMPHEH | Allow NULL? |
| 19 | EXT_PROG_VERSION | Supported version of external routines | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_EXT_VERSION | Allow NULL? |
| 20 | BPRESV | Oil/gas standard/base pressure:metering (volume, density) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BPRESV | |
| 21 | BPRESVEH | Oil/gas standard/base pres.:metering (volume, density): unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BPRESVEH | Allow NULL? |
| 22 | BTMPVP | Oil/gas standard/base temperature (vapor pressure) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BTMPVP | |
| 23 | BTMPVPEH | Oil/gas standard/base temperature unit (vapor pressure) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BTMPVPEH | Allow NULL? |
| 24 | CHGS | Conversion handling for gases | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_CHGS | Allow NULL? |
| 25 | CHLQ | Conversion handling for liquid products | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_CHLQ | Allow NULL? |
| 26 | EXTDNUNIT | Unit for densities of petroleum products and natural gas | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_DNEH | Allow NULL? |
| 27 | EXTHVUNIT | Heating value unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_HVEH | Allow NULL? |
| 28 | EXTIND | External functions ind. (API c-codes, etc.) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_EXTIND | Allow NULL? |
| 29 | VCFLN_LPG | Volume correction factor LPG | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_VCFLN_LPG | Allow NULL? |
| 30 | BSDNEH | Base density unit (at standard reference conditions) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BSDNEH | Allow NULL? |
| 31 | BSHVEH | Base heating value unit (at standard reference conditions) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BSHVEH | Allow NULL? |
| 32 | TDTHV | Test density/test heating value - parameter handling | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_TDTHV | Allow NULL? |
| 33 | BDBHV | Base density / base heating value parameter handling | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_BDBHV | Allow NULL? |
| 34 | AROMATICS | Industrial aromatic hydrocarbons: Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_AROMATICS | Allow NULL? |
| 35 | BHVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_HVCLS | Allow NULL? |
| 36 | IDGAS | Indicator for SAP natural gas routine (ideal/real gas) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_IDGAS | Allow NULL? |
| 37 | RFC_RELEASE | Release indicator for external (RFC) calls to QCI | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_RELEASE | Allow NULL? |
