| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | NAME1 | Internal name field | nvarchar | 35 | 0 | | | | Allow NULL? |
| 4 | A1_SGRNDB | Land Register Number (IS-Oil MRN Demo APPEND) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | A1_UTILTP | Usage Type of Property (IS-Oil MRN Demo APPEND) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | A1_GRTYP | Property Type (IS-Oil MRN Demo APPEND) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | A1_GRQAL | Quality of Business Location (IS-Oil MRN Demo APPEND) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | A1_GRFRM | Property Type (IS-Oil MRN Demo APPEND) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | A1_GRGZS | Overall Condition of Property (IS-Oil MRN Demo APPEND) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | A1_DAKTB | Date Active in Inventory (IS-Oil MRN Demo APPEND) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | ADDRNUM | Address No. in ADRC | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | ERDAT | Date Record Created on (Date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | ERZEIT | Time Record Created at (Time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | ERNAM | User who Created Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | AEDAT | Date Record Changed on (Date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | AENAM | User who Changed Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | BLOIND | Block Indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | DELIND | Deletion indicator | char | 1 | 0 | | | | Allow NULL? |
| 21 | BLCODE | Business Location Blocking Indicator (IS-Oil MRN) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 23 | BRAND | Location brand | nvarchar | 5 | 0 | | | | Allow NULL? |
| 24 | LOCVALUE | Relative location value | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | LOCVDIFF | Location value differentiator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | LOCAA | Location area assignment | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | LOCMP | SSR Pricing - Margins procedure assigned to this location | char | 1 | 0 | | | | Allow NULL? |
| 28 | PCGROUP | Process control group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | AUTGR | Authorization group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | VALGP | SSR PC: Upload validation group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | OIRIPGRP | SSR SD/FI Invoice posting group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | CONVGR | SSR Interface conversion group definition (IS-Oil, SSR) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | LOGSYS | Logical system for EDI | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | TPLST_TXT | Description of transportation planning point | nvarchar | 20 | 0 | | | | Allow NULL? |
| 37 | LONGITUDE | Geo location longitude | decimal | 15 | 12 | | | | |
| 38 | LATITUDE | Geo location latitude | decimal | 15 | 12 | | | | |
| 39 | TIME_TO_ADD | Duration to Add at Base Location (in hours:minutes) | decimal | 11 | 0 | | | | |
| 40 | AVRG_STAYT | Duration of Stay at Remote Location (in hours:minutes) | decimal | 11 | 0 | | | | |
| 41 | KNOTE | Transportation Connection Points | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | KNOTE_BEZ | Node name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 43 | ROUTE | Shipment route | nvarchar | 6 | 0 | | | | Allow NULL? |
| 44 | TXROU | Description of Route | nvarchar | 40 | 0 | | | | Allow NULL? |
| 45 | R_CON_POINT | Radiobutton for connection point in RLM VMIS location | char | 1 | 0 | | | | Allow NULL? |
| 46 | R_ROUTE | Radiobutton for shipment route in RLM VMIS location | char | 1 | 0 | | | | Allow NULL? |
| 47 | XCOOR | X coordinate | float | 15 | 16 | | | | |
| 48 | YCOOR | Y coordinate | float | 15 | 16 | | | | |
