| 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 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | | IBLNR | Allow NULL? |
| 3 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 4 | ZEILI | Line Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DZEILE | Allow NULL? |
| 5 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | OIB01 | OIB_UMRSL | Allow NULL? |
| 6 | CMODE | Conversion Mode | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_CMODE | Allow NULL? |
| 7 | FDICHEH | Unit for densities at standard/base conditions | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BDNEH | Allow NULL? |
| 8 | FDICH | Fixed Density | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_FDICH | |
| 9 | COEFF | Quantity Conversion Coefficient | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_COEFF | |
| 10 | BDICHEH | Unit for densities at standard/base conditions | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BDNEH | Allow NULL? |
| 11 | BDICH | Oil/gas density at standard/base conditions | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BDICH | |
| 12 | BHVALEH | Heating value unit at standard/base conditions (natural gas) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BHVEH | Allow NULL? |
| 13 | BHVAL | Heating value at standard/base conditions (natural gas) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BHVAL | |
| 14 | TSTMP | Oil/Gas Test Temperature: Observed Density | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TSTMP | |
| 15 | TSTEH | Test Temperature Unit (Density): Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TSTEH | Allow NULL? |
| 16 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTTMP | |
| 17 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTTEH | Allow NULL? |
| 18 | THVAL | Heating value at test conditions (natural gas): observed | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_THVAL | |
| 19 | TDICHEH | Unit for densities of petroleum products and natural gas | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_DNEH | Allow NULL? |
| 20 | TDICH | Oil/Gas Test Density | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TDICH | |
| 21 | MTPRES | Oil/gas material pressure: observed quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTPRES | |
| 22 | MTPRESEH | Oil/gas material pressure unit: observed quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTPRESEH | Allow NULL? |
| 23 | TPRED | Oil/gas test pressure: metering (obs. density) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TPRED | |
| 24 | TPREDEH | Oil/Gas test press. unit: metering (density) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TPREDEH | Allow NULL? |
| 25 | TPRHV | Natural gas test pressure: combustion (obs. heating value ) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TPRHV | |
| 26 | TPRHVEH | Natural gas test pressure unit: combustion ( heating value ) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TPRHVEH | Allow NULL? |
| 27 | TTMPHV | Natural gas test temperature: combustion (obs. heat. value ) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TTMPHV | |
| 28 | TTMPHVEH | Natural gas test temp. unit: combustion (heating value) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TTMPHVEH | Allow NULL? |
| 29 | ATPRES | Atmospheric pressure of the air surrounding a product | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_ATPRES | |
| 30 | ATPRESEH | Atmospheric pressure unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_ATPRESEH | Allow NULL? |
| 31 | VAPRES | Vapor pressure of liquid petroleum gases (LPG) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_VAPRES | |
| 32 | VAPRESEH | Vapor pressure unit (LPG) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_VAPRESEH | Allow NULL? |
| 33 | THVALEH | Heating value unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_HVEH | Allow NULL? |
| 34 | MTCOMBTMP | Natural gas material combustion temp.: observed quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTCOMBTMP | |
| 35 | MTCOMBTEH | Natural gas material combustion temp. unit: obs. quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTCOMBTEH | Allow NULL? |
| 36 | MTCOMBPRES | Natural gas material combustion pressure: observed quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTCOMBPRES | |
| 37 | MTCOMBPRESEH | Natural gas material combustion pres. unit: oberved quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTCOMBPRESEH | Allow NULL? |
| 38 | TSTMPCAL | Natural gas: Calorimeter test temperature (density) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TSTMPCAL | |
| 39 | TSTMPCALEH | Natural gas: unit for calorimeter test temperature (density) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TSTMPCALEH | Allow NULL? |
| 40 | TPREDCAL | Natural gas: Calorimeter test pressure (density) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TPREDCAL | |
| 41 | TPREDCALEH | Natural gas: Unit for calorimeter test pressure (density) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TPREDCALEH | Allow NULL? |
| 42 | HYDRO | Hydrometer Correction Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_HYDRO | Allow NULL? |
| 43 | ABIND | Air Bouyancy Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_ABIND | Allow NULL? |
| 44 | ABFAC | Air Bouyancy Factor | decimal | 3 | 1 | DEC | ((0)) | Yes | | OIB_ABFAC | |
| 45 | MCF | Meter correction factor | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MCF1 | |
| 46 | BSWCN | BSW % | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BSWCN | |
| 47 | BSWCNEH | BSW % unit (volume %, mol %, mass % or proportion ) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BSWCNEH | Allow NULL? |
| 48 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_HVCLS | Allow NULL? |
| 49 | HVCLS_TO | Heating value class (calorific value class) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_HVCLS | Allow NULL? |
| 50 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | GUID_32 | Allow NULL? |
| 51 | CH4RATIO | Natural gas CH4 content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CH4RAT | |
| 52 | N2RATIO | Natural gas N2 (nitrogen) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_N2RAT | |
| 53 | CO2RATIO | Natural gas CO2 content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CO2RAT | |
| 54 | C2H6RATIO | Natural gas C2H6 (ethane) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_C2H6RAT | |
| 55 | C3H8RATIO | Natural gas C3H8 (propane) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_C3H8RAT | |
| 56 | H2ORATIO | Natural gas H2O content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_H2ORAT | |
| 57 | H2SRATIO | Natural gas H2S content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_H2SRAT | |
| 58 | H2RATIO | Natural gas H2 (Hydrogen) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_H2RAT | |
| 59 | CORATIO | Natural gas CO content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CORAT | |
| 60 | O2RATIO | Natural gas oxygen (O2) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_O2RAT | |
| 61 | ISOC4H10RATIO | Natural gas ISO-C4H10 (iso-butane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_ISOC4H10RAT | |
| 62 | NC4H10RATIO | Natural gas n-C4H10 (n-butane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_NC4H10RAT | |
| 63 | ISOC5H12RATIO | Natural gas ISO-C5H12 (ISO-pentane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_ISOC5H12RAT | |
| 64 | NC5H12RATIO | Natural gas n-C5H12 (n-pentane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_NC5H12RAT | |
| 65 | C6H14RATIO | Natural gas C6H14 (n-hexane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_C6H14RAT | |
| 66 | C7H16RATIO | Natural gas C7H16 (n-heptane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_C7H16RAT | |
| 67 | C8H18RATIO | Natural gas C8H18 (n-octane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_C8H18RAT | |
| 68 | C9H20RATIO | Natural gas C9H20 (n-Nonane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_C9H20RAT | |
| 69 | C10H22RATIO | Natural gas C10H22 (n-Decane ) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_C10H22RAT | |
| 70 | HERATIO | Natural gas He (Helium) content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_HERAT | |
| 71 | ARRATIO | Natural gas Argon content (ratio) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_ARRAT | |
| 72 | GASCOMPRATEH | Unit (vol. %, mol % or mass % ) of natural gas composition | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_GASCOMPRATEH | Allow NULL? |
| 73 | MOLDEN | Natural gas molar density (mol/volume) at standard condition | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MOLDEN | |
| 74 | MOLDENEH | Unit for molar density at base conditions ( nat.gas) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MOLDENEH | Allow NULL? |
| 75 | MOLWEIGHT | Molecular weight of natural gas:return value from AGA c-code | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MOLWEIGHT | |
| 76 | HYDROCARBMOLFRAC | Hydrocarbon mole fraction calculated from AGA c-code | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_HYDROCARBMOLFRAC | |
| 77 | MOLWEIGHTEH | Unit for molar mass | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MOLWEIGHTEH | Allow NULL? |
| 78 | CUSTPARCHAR1 | Customer parameter character field 1 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | OIB_CUSTPARCHAR1 | Allow NULL? |
| 79 | CUSTPARFLOAT1 | Customer parameter float 1 | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CUSTPARFLOAT1 | |
| 80 | CUSTEH1 | Customer parameter 1 unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_CUSTEH1 | Allow NULL? |
| 81 | CUSTPARCHAR2 | Customer parameter character field 2 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | OIB_CUSTPARCHAR2 | Allow NULL? |
| 82 | CUSTPARFLOAT2 | Customer parameter float 2 | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CUSTPARFLOAT2 | |
| 83 | CUSTEH2 | Customer parameter 2 unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_CUSTEH2 | Allow NULL? |
| 84 | CUSTPARCHAR3 | Customer parameter character field 3 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | OIB_CUSTPARCHAR3 | Allow NULL? |
| 85 | CUSTPARFLOAT3 | Customer parameter float 3 | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_CUSTPARFLOAT3 | |
| 86 | CUSTEH3 | Customer parameter 3 unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_CUSTEH3 | Allow NULL? |
