| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | F_PR | SSR - processing profile ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | PARFN | SSR - process business partner role | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | HANTYG | Handling type for transfer gain | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | HANTYL | Handling type for transfer loss | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | IND_MMD | SSR: Material movements defaults | char | 1 | 0 | | | | Allow NULL? |
| 8 | LOGDOC_PBLIND | Location indicator for logistics document definition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | LOGDOCDSCH | SSR Logistics document creation schedule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | LOGDOCSDEF | SSR Logistics document - schedule determination methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | TSTMP | Oil/Gas Test Temperature: Observed Density | float | 15 | 16 | | | | |
| 12 | TSTEH | Test Temperature Unit (Density): Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | | | |
| 14 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | THVAL | Heating value at test conditions (natural gas): observed | float | 15 | 16 | | | | |
| 16 | TDICHEH | Unit for densities of petroleum products and natural gas | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | TDICH | Oil/Gas Test Density | float | 15 | 16 | | | | |
| 18 | MTPRES | Oil/gas material pressure: observed quantity | float | 15 | 16 | | | | |
| 19 | MTPRESEH | Oil/gas material pressure unit: observed quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | TPRED | Oil/gas test pressure: metering (obs. density) | float | 15 | 16 | | | | |
| 21 | TPREDEH | Oil/Gas test press. unit: metering (density) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | TPRHV | Natural gas test pressure: combustion (obs. heating value ) | float | 15 | 16 | | | | |
| 23 | TPRHVEH | Natural gas test pressure unit: combustion ( heating value ) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | TTMPHV | Natural gas test temperature: combustion (obs. heat. value ) | float | 15 | 16 | | | | |
| 25 | TTMPHVEH | Natural gas test temp. unit: combustion (heating value) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | ATPRES | Atmospheric pressure of the air surrounding a product | float | 15 | 16 | | | | |
| 27 | ATPRESEH | Atmospheric pressure unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | VAPRES | Vapor pressure of liquid petroleum gases (LPG) | float | 15 | 16 | | | | |
| 29 | VAPRESEH | Vapor pressure unit (LPG) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | THVALEH | Heating value unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | MTCOMBTMP | Natural gas material combustion temp.: observed quantity | float | 15 | 16 | | | | |
| 32 | MTCOMBTEH | Natural gas material combustion temp. unit: obs. quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | MTCOMBPRES | Natural gas material combustion pressure: observed quantity | float | 15 | 16 | | | | |
| 34 | MTCOMBPRESEH | Natural gas material combustion pres. unit: oberved quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | TSTMPCAL | Natural gas: Calorimeter test temperature (density) | float | 15 | 16 | | | | |
| 36 | TSTMPCALEH | Natural gas: unit for calorimeter test temperature (density) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | TPREDCAL | Natural gas: Calorimeter test pressure (density) | float | 15 | 16 | | | | |
| 38 | TPREDCALEH | Natural gas: Unit for calorimeter test pressure (density) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | HYDRO | Hydrometer Correction Indicator | char | 1 | 0 | | | | Allow NULL? |
| 40 | ABIND | Air Bouyancy Indicator | char | 1 | 0 | | | | Allow NULL? |
| 41 | ABFAC | Air Bouyancy Factor | decimal | 3 | 1 | | | | |
| 42 | MCF | Meter correction factor | float | 15 | 16 | | | | |
| 43 | BSWCN | BSW % | float | 15 | 16 | | | | |
| 44 | BSWCNEH | BSW % unit (volume %, mol %, mass % or proportion ) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | HVCLS_TO | Heating value class (calorific value class) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | | | Allow NULL? |
| 48 | VRKME | Sales unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 49 | METREV | SSR Meters: end period meter event type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 50 | E_TIMEF | SSR Meters - end period event time from | nvarchar | 6 | 0 | | | | Allow NULL? |
| 51 | E_TIMET | SSR Meters - end period event time to | nvarchar | 6 | 0 | | | | Allow NULL? |
| 52 | MRDSCH | SSR Meters - Meter reading schedule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 53 | MRSDEF | SSR Meters - Schedule determination methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 54 | MRCHK | SSR Meters - user check methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 55 | PCTOL | SSR Meters - Price change tolerance (in minutes) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 56 | DCTOL | SSR Meters - dealer change tolerance (in minutes) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 57 | SOCEV | SSR Stocks - Default SOC event | nvarchar | 2 | 0 | | | | Allow NULL? |
| 58 | IND_DRM | SSR Stocks: maintenance control for dip readings | char | 1 | 0 | | | | Allow NULL? |
| 59 | DRSSCH | SSR Stocks - dip readings schedule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 60 | DRSDEF | SSR Stocks - schedule determination methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 61 | PROWL | Warning loss percentage tolerance limit | decimal | 5 | 2 | | | | |
| 62 | PROEL | Error loss percentage tolerance limit | decimal | 5 | 2 | | | | |
| 63 | PROWG | Warning gain percentage tolerance limit | decimal | 5 | 2 | | | | |
| 64 | PROEG | Error gain percentage tolerance limit | decimal | 5 | 2 | | | | |
| 65 | TOLROUT | SSR Stocks - Tolerance quantity base methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 66 | DRCHK | SSR stocks - user check methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 67 | INVCAL | SSR Invoicing - invoicing calendar | nvarchar | 2 | 0 | | | | Allow NULL? |
| 68 | INVMETH | Invoicing method for SSR Invoicing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 69 | EOMCAL | SSR Invoicing - calendar ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 70 | COMMCAL | Calendar for monthly commission recalculation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 71 | ZLSCH | Payment method | char | 1 | 0 | | | | Allow NULL? |
| 72 | BVTYP | Partner bank type for invoicing items | nvarchar | 4 | 0 | | | | Allow NULL? |
| 73 | LOGDOCDSCH_DR | SSR Logistics document creation schedule (Dip reading) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 74 | LOGDOCSDEF_DR | SSR Logistics document - schedule determination methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 75 | ROLLOVER_CHECK | SSR Meters - Rollover control methods | nvarchar | 20 | 0 | | | | Allow NULL? |
| 76 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 77 | DIALOG_CHECK | SSR Meters - Dialog save methods | nvarchar | 20 | 0 | | | | Allow NULL? |