| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EVENT | Event for export of business data | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | | | Allow NULL? |
| 4 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | HWMET | Method with Which the Local Currency Amount Was Determined | char | 1 | 0 | | | | Allow NULL? |
| 9 | GLUPM | Update Method for FM - FI-CA Integration | char | 1 | 0 | | | | Allow NULL? |
| 10 | XRAGL | Indicator: Clearing was Reversed | char | 1 | 0 | | | | Allow NULL? |
| 11 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | LOKKT | Alternative account number in company code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | FISTL | Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 14 | GEBER | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | STBUK | Tax Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | TXBH2 | Tax Base/Original Tax Base in Second Local Currency | decimal | 13 | 2 | | | | |
| 17 | TXBH3 | Tax Base/Original Tax Base in Third Local Currency | decimal | 13 | 2 | | | | |
| 18 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | XREF1 | Business partner reference key | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | XREF2 | Business partner reference key | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | KBLNR | Document Number for Earmarked Funds | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | STTAX | Tax amount as statistical information in document currency | decimal | 13 | 2 | | | | |
| 24 | FKBER | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 25 | OBZEI | Number of Line Item in Original Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | XNEGP | Indicator: Negative posting | char | 1 | 0 | | | | Allow NULL? |
| 27 | RFZEI | Payment Card Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | KKBER | Credit control area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | EMPFB | Payee/Payer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | | | Allow NULL? |
| 32 | DTWS1 | Instruction key 1 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | DTWS2 | Instruction key 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | DTWS3 | Instruction key 3 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | DTWS4 | Instruction key 4 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 36 | GRICD | Activity Code for Gross Income Tax | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | GRIRG | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | GITYP | Distribution Type for Employment Tax | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | XPYPR | Indicator: Items from Payment Program Blocked | char | 1 | 0 | | | | Allow NULL? |
| 40 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | | | Allow NULL? |
| 41 | ABSBT | Credit management: Hedged amount | decimal | 13 | 2 | | | | |
| 42 | IDXSP | Inflation Index | nvarchar | 5 | 0 | | | | Allow NULL? |
| 43 | LINFV | Last Adjustment Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | KONTT | Account Assignment Category for Industry Solution | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | | | Allow NULL? |
| 46 | TXDAT | Date for defining tax rates | nvarchar | 8 | 0 | | | | Allow NULL? |
| 47 | WERTST | Value Date for Currency Translation | nvarchar | 8 | 0 | | | | Allow NULL? |
