| 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 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | CHAR | (N' ') | No | OIFSPBL | OIF_PBLNR | Allow NULL? |
| 3 | RNBT | Business type | nvarchar | 4 | 0 | CHAR | (N' ') | No | OIRBPBLB | OIRA_RNBT | Allow NULL? |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 5 | SERVTYP | Service type | nvarchar | 4 | 0 | CHAR | (N' ') | No | OIRASTYP | OIRA_STYP | Allow NULL? |
| 6 | TMSTM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 7 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | OIRC_TIMEZONE | Allow NULL? |
| 8 | P_DATE | SSR Fuels - local date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIRC_DATUM | Allow NULL? |
| 9 | P_TIME | SSR Fuels - Local time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OIRC_UZEIT | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 11 | KBETR | SSR Pricing - Actual price | decimal | 11 | 2 | CURR | ((0)) | Yes | | OIRC_KBETR_ACTUAL | |
| 12 | KBETR_TARGET | SSR Pricing - Target price | decimal | 11 | 2 | CURR | ((0)) | Yes | | OIRC_KBETR_TARGET | |
| 13 | KONWA | SSR Pricing - Actual price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | OIRC_KONWA_ACTUAL | Allow NULL? |
| 14 | KPEIN | SSR Pricing - Actual price pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | OIRC_KPEIN_ACTUAL | |
| 15 | KMEIN | SSR Pricing - Actual price condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIRC_KMEIN_ACTUAL | Allow NULL? |
| 16 | KBETR_DIFF | SSR Pricing - Difference target/actual price | decimal | 11 | 2 | CURR | ((0)) | Yes | | OIRC_KBETR_DIFF | |
| 17 | PROC_TYPE | SSR Fuels - Process type | char | 1 | 0 | CHAR | (N' ') | Yes | | OIRC_IND_PROC | Allow NULL? |
| 18 | TOL_STATUS | SSR Fuels - Price status check light | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | OIRC_PRSTCHK | Allow NULL? |
| 19 | STCODE | SSR Fuels - Status code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIRC_STCODE_SAP | Allow NULL? |
| 20 | BEZEI | Description | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BEZEI40 | Allow NULL? |
| 21 | USR_IND | SSR Fuels - User error indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIRC_USR_IND | Allow NULL? |
| 22 | ERDAT | Date record created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OII_ERDAT | Allow NULL? |
| 23 | ERZEIT | Time record created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OII_ERZEIT | Allow NULL? |
| 24 | ERNAM | User who created record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | OII_ERNAM | Allow NULL? |
| 25 | AEDAT | Date record changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OII_AEDAT | Allow NULL? |
| 26 | AEZEIT | Time record changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OII_AEZEIT | Allow NULL? |
| 27 | AENAM | User who changed record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | OII_AENAM | Allow NULL? |
| 28 | BLOIND | Blocking indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OII_BLOIND | Allow NULL? |
| 29 | DELIND | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OII_DELIND | Allow NULL? |
| 30 | ADDRESS | Character field length 57 | nvarchar | 57 | 0 | CHAR | (N' ') | Yes | | CHAR57 | Allow NULL? |
