| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | APPL | Business Partner: Application Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ERDAT | Date on which the Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | SPERR | Posting block for company code | char | 1 | 0 | | | | Allow NULL? |
| 7 | LOEVM | Deletion Flag for Master Record (Company Code Level) | char | 1 | 0 | | | | Allow NULL? |
| 8 | ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | AKONT | Reconciliation Account in General Ledger | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | VZSKZ | Interest calculation indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | XVERR | Indicator: Clearing between customer and vendor? | char | 1 | 0 | | | | Allow NULL? |
| 14 | ZAHLS | Block Key for Payment | char | 1 | 0 | | | | Allow NULL? |
| 15 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | EIKTO | Our account number with the vendor | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | ZSABE | Clerk at vendor | nvarchar | 15 | 0 | | | | Allow NULL? |
| 18 | KVERM | Memo | nvarchar | 30 | 0 | | | | Allow NULL? |
| 19 | FDGRV | Planning group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | BUSAB | Accounting clerk | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | LNRZE | Head office account number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | LNRZB | Account number of the alternative payee | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | ZINDT | Key date of the last interest calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | ZINRT | Interest calculation frequency in months | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | DATLZ | Date of the last interest calculation run | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | XDEZV | Indicator: Local processing? | char | 1 | 0 | | | | Allow NULL? |
| 27 | WEBTR | Bill of exchange limit (in local currency) | decimal | 13 | 2 | | | | |
| 28 | KULTG | Probable time until check is paid | decimal | 3 | 0 | | | | |
| 29 | REPRF | Check Flag for Double Invoices or Credit Memos | char | 1 | 0 | | | | Allow NULL? |
| 30 | TOGRU | Tolerance group for the business partner/G/L account | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | | | | Allow NULL? |
| 32 | XPORE | Indicator: Pay all items separately ? | char | 1 | 0 | | | | Allow NULL? |
| 33 | QSZNR | Certificate Number of the Withholding Tax Exemption | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | QSZDT | Validity Date for Withholding Tax Exemption Certificate | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | QSSKZ | Withholding Tax Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 36 | BLNKZ | Subsidy indicator for determining the reduction rates | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | MINDK | Minority Indicators | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | ALTKN | Previous Master Record Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | ZGRUP | Key for Payment Grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | MGRUP | Key for dunning notice grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | QSREC | Vendor Recipient Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | QSBGR | Authority for Exemption from Withholding Tax | char | 1 | 0 | | | | Allow NULL? |
| 44 | QLAND | Withholding Tax Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | XEDIP | Indicator: Send Payment Advices by EDI | char | 1 | 0 | | | | Allow NULL? |
| 46 | FRGRP | Release Approval Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 47 | TOGRR | Tolerance group; Invoice Verification | nvarchar | 4 | 0 | | | | Allow NULL? |
| 48 | TLFXS | Accounting clerk's fax number at the customer/vendor | nvarchar | 31 | 0 | | | | Allow NULL? |
| 49 | INTAD | Internet address of partner company clerk | nvarchar | 130 | 0 | | | | Allow NULL? |
| 50 | XLFZB | Indicator: Alternative payee using account number | char | 1 | 0 | | | | Allow NULL? |
| 51 | GUZTE | Payment Terms Key for Credit Memos | nvarchar | 4 | 0 | | | | Allow NULL? |
| 52 | GRICD | Activity Code for Gross Income Tax | nvarchar | 2 | 0 | | | | Allow NULL? |
| 53 | GRIDT | Distribution Type for Employment Tax | nvarchar | 2 | 0 | | | | Allow NULL? |
| 54 | XAUSZ | Indicator for periodic account statements | char | 1 | 0 | | | | Allow NULL? |
| 55 | CERDT | Certification date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | CONFS | Status of Change Authorization (Company Code Level) | char | 1 | 0 | | | | Allow NULL? |
| 57 | UPDAT | Date on Which the Changes Were Confirmed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 58 | UPTIM | Time of Last Change Confirmation | nvarchar | 6 | 0 | | | | Allow NULL? |
| 59 | NODEL | Deletion bock for master record (company code level) | char | 1 | 0 | | | | Allow NULL? |
| 60 | TLFNS | Accounting clerk's telephone number at business partner | nvarchar | 30 | 0 | | | | Allow NULL? |
