| 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 | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | HKONT | Allow NULL? |
| 4 | ZUONR | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | | DZUONR | Allow NULL? |
| 5 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 7 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 8 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 9 | SAKNR | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 10 | UMSKZ | Special G/L Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | UMSKZ | Allow NULL? |
| 11 | UMSKS | Special G/L Transaction Type | char | 1 | 0 | CHAR | (N' ') | Yes | | UMSKS | Allow NULL? |
| 12 | BSCHL | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 13 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 14 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 15 | WRBTR | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 16 | DMBTR | Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBTR | |
| 17 | ZFBDT | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZFBDT | Allow NULL? |
| 18 | WELGF | Life of a bill of exchange | decimal | 3 | 0 | DEC | ((0)) | Yes | | WELGF | |
| 19 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLART | Allow NULL? |
| 20 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 21 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR1 | Allow NULL? |
| 22 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 23 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 24 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUPLA | Allow NULL? |
| 25 | WVERW | Bill of exchange usage type | char | 1 | 0 | CHAR | (N' ') | Yes | | WVERW | Allow NULL? |
| 26 | DISBN | Number of Bill of Exchange Usage Document (Discount Doc.) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | DISBN | Allow NULL? |
| 27 | DISBJ | Fiscal Year of Bill of Exchange Usage Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | DISBJ | Allow NULL? |
| 28 | DISBZ | Line Item within the Bill of Exchange Usage Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DISBZ | Allow NULL? |
| 29 | BSCHLDIS | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 30 | HKONTDIS | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 31 | GSBERDIS | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 32 | VBUNDDIS | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 33 | ZUONRDIS | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 34 | BUDATDIS | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 35 | DMBE2 | Amount in Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE2 | |
| 36 | DMBE3 | Amount in Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE3 | |
| 37 | KKBER | Credit control area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KKBER | Allow NULL? |
| 38 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 39 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PPRCTR | Allow NULL? |
| 40 | PRCTRDIS | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 41 | PPRCTDIS | Partner Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PPRCTR | Allow NULL? |
