| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | BLART | Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | MONAT | Fiscal Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | CPUTM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | AEDAT | Date of the Last Document Change by Transaction | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | UPDDT | Date of the Last Document Update | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | WWERT | Translation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | USNAM | User name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | TCODE | Transaction Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | BVORG | Number of Cross-Company Code Posting Transaction | nvarchar | 16 | 0 | | | | Allow NULL? |
| 19 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 20 | DBBLG | Recurring Entry Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | STBLG | Reverse Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | STJAH | Reverse document fiscal year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | BKTXT | Document Header Text | nvarchar | 25 | 0 | | | | Allow NULL? |
| 24 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | KURSF | Exchange rate | decimal | 9 | 5 | | | | |
| 26 | KZWRS | Currency Key for the Group Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | KZKRS | Group Currency Exchange Rate | decimal | 9 | 5 | | | | |
| 28 | BSTAT | Document Status | char | 1 | 0 | | | | Allow NULL? |
| 29 | XNETB | Indicator: Document posted net ? | char | 1 | 0 | | | | Allow NULL? |
| 30 | FRATH | Unplanned delivery costs | decimal | 13 | 2 | | | | |
| 31 | XRUEB | Indicator: Document is posted to a previous period | char | 1 | 0 | | | | Allow NULL? |
| 32 | GLVOR | Business Transaction | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | GRPID | Batch Input Session Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | DOKID | Document Name in the Archive System | nvarchar | 40 | 0 | | | | Allow NULL? |
| 35 | ARCID | Extract ID Document Header | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | IBLAR | Internal Document Type for Document Control | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | | | | Allow NULL? |
| 38 | AWKEY | Reference Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 39 | FIKRS | Financial Management Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 40 | HWAER | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 41 | HWAE2 | Currency Key of Second Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 42 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 43 | KURS2 | Exchange Rate for the Second Local Currency | decimal | 9 | 5 | | | | |
| 44 | KURS3 | Exchange Rate for the Third Local Currency | decimal | 9 | 5 | | | | |
| 45 | BASW2 | Source Currency for Currency Translation | char | 1 | 0 | | | | Allow NULL? |
| 46 | BASW3 | Source Currency for Currency Translation | char | 1 | 0 | | | | Allow NULL? |
| 47 | UMRD2 | Translation Date Type for Second Local Currency | char | 1 | 0 | | | | Allow NULL? |
| 48 | UMRD3 | Translation Date Type for Third Local Currency | char | 1 | 0 | | | | Allow NULL? |
| 49 | XSTOV | Indicator: Document is flagged for reversal | char | 1 | 0 | | | | Allow NULL? |
| 50 | STODT | Planned Date for the Reverse Posting | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | XMWST | Calculate tax automatically | char | 1 | 0 | | | | Allow NULL? |
| 52 | CURT2 | Currency Type of Second Local Currency | nvarchar | 2 | 0 | | | | Allow NULL? |
| 53 | CURT3 | Currency Type of Third Local Currency | nvarchar | 2 | 0 | | | | Allow NULL? |
| 54 | KUTY2 | Exchange Rate Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 55 | KUTY3 | Exchange Rate Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 56 | XSNET | G/L account amounts entered exclude tax | char | 1 | 0 | | | | Allow NULL? |
| 57 | AUSBK | Source Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | XUSVR | Indicator: US taxes changed at detail level ? | char | 1 | 0 | | | | Allow NULL? |
| 59 | DUEFL | Status of Data Transfer into Subsequent Release | char | 1 | 0 | | | | Allow NULL? |
| 60 | AWSYS | Logical System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 61 | TXKRS | Exchange Rate for Taxes | decimal | 9 | 5 | | | | |
| 62 | LOTKZ | Lot Number for Documents | nvarchar | 10 | 0 | | | | Allow NULL? |
| 63 | XWVOF | Indicator: Customer bill of exchange payment before due date | char | 1 | 0 | | | | Allow NULL? |
| 64 | STGRD | Reason for Reversal | nvarchar | 2 | 0 | | | | Allow NULL? |
| 65 | PPNAM | Name of User Who Parked this Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 66 | BRNCH | Branch Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 67 | NUMPG | Number of pages of invoice | nvarchar | 3 | 0 | | | | Allow NULL? |
| 68 | ADISC | Indicator: entry represents a discount document | char | 1 | 0 | | | | Allow NULL? |
