| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | NETNUM | Exchange - netting document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | ITMNO | Exchange - netting document item number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SELKZ | Selection flag | char | 1 | 0 | | | | Allow NULL? |
| 7 | OIEXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | ITCAT | Exchange - netting document item type | char | 1 | 0 | | | | Allow NULL? |
| 9 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | MJAHR | Material Document Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | ZEILE | Item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 13 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | OIVBELN | Delivery | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | OIPOSNR | Delivery Item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | DMBTR | Amount in local currency | decimal | 13 | 2 | | | | |
| 24 | WRBTR | Amount in document currency | decimal | 13 | 2 | | | | |
| 25 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | | | | Allow NULL? |
| 27 | CLRNO | Doc. number of the netting document clearing the item/cycle | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | OIBASPROD | Base product number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 29 | BOMCON | Indicator: BOM continuation item | char | 1 | 0 | | | | Allow NULL? |
| 30 | OICLRDCYC | Item already cleared in all cycles under process (X/ ) | char | 1 | 0 | | | | Allow NULL? |
| 31 | OIMATREF | Material group reference for exchange balance reporting | nvarchar | 20 | 0 | | | | Allow NULL? |
| 32 | OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | char | 1 | 0 | | | | Allow NULL? |
| 33 | OIC_LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | OIC_DCITYC | Destination city code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | OIC_DCOUNC | Destination county code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | OIC_DREGIO | Destination region | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | OIC_DLAND1 | Destination country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | OIC_OCITYC | Origin city code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 39 | OIC_OCOUNC | Origin county code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 40 | OIC_OREGIO | Origin region | nvarchar | 3 | 0 | | | | Allow NULL? |
| 41 | OIC_OLAND1 | Origin country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 42 | OIC_PORGIN | Tax origin | nvarchar | 15 | 0 | | | | Allow NULL? |
| 43 | OIC_PDESTN | Tax destination | nvarchar | 15 | 0 | | | | Allow NULL? |
| 44 | OIC_PTRIP | Pipeline trip number (external) | nvarchar | 16 | 0 | | | | Allow NULL? |
| 45 | OIC_PBATCH | Pipeline operator´s external batch number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 46 | OIC_MOT | IS-OIL MAP external details mode of transport | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | OIC_AORGIN | Alternate origin | nvarchar | 15 | 0 | | | | Allow NULL? |
| 48 | OIC_ADESTN | Alternate destination | nvarchar | 15 | 0 | | | | Allow NULL? |
| 49 | OIC_TRUCKN | Truck number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | OIA_BASELO | Base location | nvarchar | 15 | 0 | | | | Allow NULL? |
| 51 | OID_EXTBOL | External bill of lading | nvarchar | 16 | 0 | | | | Allow NULL? |
| 52 | OID_MISCDL | Miscellaneous delivery number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 53 | OIAOBAL | Opening exchange balance | decimal | 15 | 3 | | | | |
| 54 | BASEPMEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 55 | MENGE | Movement quantity | decimal | 13 | 3 | | | | |
| 56 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
