| 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 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | OII_GMMNR | Allow NULL? |
| 3 | ITMSTM | GMM: Inverse timestamp | decimal | 15 | 0 | DEC | ((0)) | No | | OII_ITMSTM | |
| 4 | METEV | GMM: History record type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | OII_METEV | Allow NULL? |
| 5 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 6 | MCOUNT | GMM: Meter counter reading | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | OIRC_MCOUNT | Allow NULL? |
| 7 | CONFAC | GMM: Conversion factor | decimal | 10 | 5 | DEC | ((0)) | Yes | | OII_CONFAC | |
| 8 | BASME | Base UoM of material at event entry | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OII_BASME | Allow NULL? |
| 9 | MENGE | SSR Fuels - Sales flow quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIRC_MENGE | |
| 10 | XMCOUNT | GMM: Previous meter reading | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | OII_XMCOUN | Allow NULL? |
| 11 | XMATNR | GMM: Previous material assigned | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | OII_XMATNR | Allow NULL? |
| 12 | XCONFAC | GMM: Previous conversion factor | decimal | 10 | 5 | DEC | ((0)) | Yes | | OII_XCONFA | |
| 13 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 14 | PARFN | MRN business partner role / relation type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OIF_PARFN | Allow NULL? |
| 15 | FTMSTM | Start of partner function validity period: time stamp | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | OIF_FTMSTM | Allow NULL? |
| 16 | PARPOS | Partner counter | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIF_PARPOS | Allow NULL? |
| 17 | TTMSTM | End of partner function validity period - timestamp | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | OIF_TTMSTM | Allow NULL? |
| 18 | METREV | SSR: Meter event type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIRC_GMME | OIRC_METREV | Allow NULL? |
| 19 | SEQNR | GMM: Sequence number of meter assigned to customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | OII_GSEQNR | Allow NULL? |
| 20 | PR_NUMBER | SSR Fuels - Process number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | OIRC_PR_NUMBER | Allow NULL? |
| 21 | MRDATE | SSR Fuels - local date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIRC_DATUM | Allow NULL? |
| 22 | MRTIME | SSR Fuels - Local time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OIRC_UZEIT | Allow NULL? |
| 23 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | OIRC_TIMEZONE | Allow NULL? |
| 24 | SERVTYP | Service type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OIRA_STYP | Allow NULL? |
| 25 | EQUNR | Equipment number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | EQUI | OII_EQUNR | Allow NULL? |
| 26 | KBETR | SSR Meters - Actual price | decimal | 11 | 2 | CURR | ((0)) | Yes | | OIRC_KBETR | |
| 27 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | KONWA | Allow NULL? |
| 28 | KPEIN | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 29 | KMEIN | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | KMEIN | Allow NULL? |
| 30 | KWERT | Condition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWERT | |
| 31 | XPARFN | MRN business partner role / relation type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OIF_PARFN | Allow NULL? |
| 32 | XFTMSTM | Start of partner function validity period: time stamp | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | OIF_FTMSTM | Allow NULL? |
| 33 | XPARPOS | Partner counter | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIF_PARPOS | Allow NULL? |
| 34 | XTTMSTM | End of partner function validity period - timestamp | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | OIF_TTMSTM | Allow NULL? |
| 35 | XSERVTYP | SSR Meters - Previous service type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OIRC_XSTYP | Allow NULL? |
| 36 | XKBETR | SSR Meters - Previous condition value | decimal | 11 | 2 | CURR | ((0)) | Yes | | OIRC_XKBETR | |
| 37 | XKONWA | SSR Meters - Previous condition currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | OIRC_XKONWA | Allow NULL? |
| 38 | XKPEIN | SSR Meters - Previous condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | OIRC_XKPEIN | |
| 39 | XKMEIN | SSR Meters - Previous condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIRC_XKMEIN | Allow NULL? |
| 40 | XKWERT | SSR Meters - Previous condition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIRC_XKWERT | |
| 41 | VKDAT | SSR PC: Sales date at the service station | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIRE_VKDAT | Allow NULL? |
| 42 | STATUS_UPDATE | SSR: Indicator to cancel process status update | char | 1 | 0 | CHAR | (N' ') | Yes | | OIRA_SKIP_ST_UPD | Allow NULL? |
| 43 | LINKNR | Link number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | OIRA_LINKNR | Allow NULL? |
| 44 | ITLINKNR | Item link number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | OIRA_ITLINKNR | Allow NULL? |
| 45 | LINKYEAR | Document link number year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | OIRA_JAHR | Allow NULL? |
| 46 | KBETR_TARGET | SSR Pricing - Target price | decimal | 11 | 2 | CURR | ((0)) | Yes | | OIRC_KBETR_TARGET | |
| 47 | KONWA_TARGET | SSR Pricing - Target price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | OIRC_KONWA_TARGET | Allow NULL? |
| 48 | KPEIN_TARGET | SSR Pricing - Target price pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | OIRC_KPEIN_TARGET | |
| 49 | KMEIN_TARGET | SSR Pricing - Target price condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIRC_KMEIN_TARGET | Allow NULL? |
| 50 | ONLINE | SSR Meters - On-line process indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIRC_ONLINE | Allow NULL? |
| 51 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 52 | LGORT | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGORT_D | Allow NULL? |
| 53 | MRDATE_TARGET | SSR Fuels - local date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIRC_DATUM | Allow NULL? |
| 54 | MRTIME_TARGET | SSR Fuels - Local time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OIRC_UZEIT | Allow NULL? |
| 55 | ERDAT | Date record created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OII_ERDAT | Allow NULL? |
| 56 | ERZEIT | Time record created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OII_ERZEIT | Allow NULL? |
| 57 | ERNAM | User who created record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | OII_ERNAM | Allow NULL? |
| 58 | AEDAT | Date record changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OII_AEDAT | Allow NULL? |
| 59 | AEZEIT | Time record changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OII_AEZEIT | Allow NULL? |
| 60 | AENAM | User who changed record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | OII_AENAM | Allow NULL? |
| 61 | BLOIND | Blocking indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OII_BLOIND | Allow NULL? |
| 62 | DELIND | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OII_DELIND | Allow NULL? |
| 63 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIF_PBLNR | Allow NULL? |
| 64 | RNBT | Business type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OIRA_RNBT | Allow NULL? |
