| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KOART | Account Type | char | 1 | 0 | | | | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | KONTO | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | EMPFG | Payee code | nvarchar | 16 | 0 | | | | Allow NULL? |
| 9 | UMSKS | Special G/L Transaction Type | char | 1 | 0 | | | | Allow NULL? |
| 10 | UMSAT | Special G/L Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | HKONT | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | AUGBL | Document Number of the Clearing Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | BUPEM | Posting Period Month in Form MM | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | BLART | Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | AUGCP | Clearing Entry Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 22 | ALTKZ | Full audit trail:ID:Altern.acct no. filled with credit acct | char | 1 | 0 | | | | Allow NULL? |
| 23 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | USNAM | User name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | STAKZ | Indicator. object is statistical | char | 1 | 0 | | | | Allow NULL? |
| 26 | DBBLG | Recurring Entry Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | UPDDT | Date of the Last Document Update | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | BKTXT | Document Header Text | nvarchar | 25 | 0 | | | | Allow NULL? |
| 30 | XKRES | Indicator: Can Line Items Be Displayed by Account? | char | 1 | 0 | | | | Allow NULL? |
| 31 | XOPVW | Indicator: Open Item Management? | char | 1 | 0 | | | | Allow NULL? |
| 32 | BSCHL | Posting Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | UMSKZ | Special G/L Indicator | char | 1 | 0 | | | | Allow NULL? |
| 34 | XUMSW | Indicator: Sales-related item ? | char | 1 | 0 | | | | Allow NULL? |
| 35 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | | | | Allow NULL? |
| 36 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | DMBTR | Amount in Local Currency | decimal | 13 | 2 | | | | |
| 38 | WRBTR | Amount in document currency | decimal | 13 | 2 | | | | |
| 39 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | | | |
| 40 | WMWST | Tax amount in document currency | decimal | 13 | 2 | | | | |
| 41 | MWSHB | Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign | decimal | 13 | 2 | | | | |
| 42 | XZAHL | Indicator: Is the posting key used in a payment transaction? | char | 1 | 0 | | | | Allow NULL? |
| 43 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | SAKNR | G/L Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 46 | FILKD | Account Number of the Branch | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | | | |
| 48 | WSKTO | Cash discount amount in document currency | decimal | 13 | 2 | | | | |
| 49 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 50 | NETDT | Due Date for Net Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | ZFBDT | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | SKFBT | Amount Eligible for Cash Discount in Document Currency | decimal | 13 | 2 | | | | |
| 53 | MDSHB | Tax on Sales/Purchases amount in Local Curr. with +/- Sign | decimal | 13 | 2 | | | | |
| 54 | HWBAS | Tax Base Amount in Local Currency | decimal | 13 | 2 | | | | |
| 55 | VALUT | Value date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | FWBAS | Tax Base Amount in Document Currency | decimal | 13 | 2 | | | | |
| 57 | BSTNR | Purchase Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 58 | SGTXT | Item Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 59 | GKART | Offsetting Account Type | char | 1 | 0 | | | | Allow NULL? |
| 60 | GKONT | Offsetting Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 61 | ZLSCH | Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 62 | MSCHL | Dunning key | char | 1 | 0 | | | | Allow NULL? |
| 63 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 64 | ZBD1T | Cash discount days 1 | decimal | 3 | 0 | | | | |
| 65 | ZBD1P | Cash Discount Percentage 1 | decimal | 5 | 3 | | | | |
| 66 | ZBD2T | Cash discount days 2 | decimal | 3 | 0 | | | | |
| 67 | ZBD2P | Cash Discount Percentage 2 | decimal | 5 | 3 | | | | |
| 68 | ZBD3T | Net Payment Terms Period | decimal | 3 | 0 | | | | |
| 69 | NEBTR | Net Payment Amount | decimal | 13 | 2 | | | | |
| 70 | QSSKZ | Withholding Tax Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 71 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | | | Allow NULL? |
| 72 | REBZZ | Line Item in the Relevant Invoice | nvarchar | 3 | 0 | | | | Allow NULL? |
| 73 | XCPDK | Indicator: Is the account a one-time account? | char | 1 | 0 | | | | Allow NULL? |
| 74 | BVORG | Number of Cross-Company Code Posting Transaction | nvarchar | 16 | 0 | | | | Allow NULL? |
| 75 | XNEGP | Indicator: Negative posting | char | 1 | 0 | | | | Allow NULL? |
