| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KUNNR | Customer number RF-VV | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | BUSAB | Accounting clerk | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | AKONT | Reconciliation Account in General Ledger | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | KNRZE | Head office account number (in branch accounts) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | KNRZB | Account number of an alternative payer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | ZAMIM | Indicator: Payment notice to customer (with cleared items)? | char | 1 | 0 | | | | Allow NULL? |
| 11 | ZAMIV | Indicator: payment notice to sales department? | char | 1 | 0 | | | | Allow NULL? |
| 12 | ZAMIR | Indicator: payment notice to legal department? | char | 1 | 0 | | | | Allow NULL? |
| 13 | ZAMIB | Indicator: Payment notice to the accounting department ? | char | 1 | 0 | | | | Allow NULL? |
| 14 | ZAMIO | Indicator: payment notice to customer (w/o cleared items)? | char | 1 | 0 | | | | Allow NULL? |
| 15 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | XVERR | Indicator: Clearing between customer and vendor ? | char | 1 | 0 | | | | Allow NULL? |
| 17 | ZAHLS | Block Key for Payment | char | 1 | 0 | | | | Allow NULL? |
| 18 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | WAKON | Terms of payment key for bill of exchange charges | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | VZSKZ | Interest calculation indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | ZINDT | Key date of the last interest calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | ZINRT | Interest Frequency in Months (Batch Input) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | EIKTO | Our account number at customer | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | ZSABE | User at customer | nvarchar | 15 | 0 | | | | Allow NULL? |
| 25 | KVERM | Memo | nvarchar | 30 | 0 | | | | Allow NULL? |
| 26 | FDGRV | Planning group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | PERKZ | Collective invoice variant | char | 1 | 0 | | | | Allow NULL? |
| 28 | XDEZV | Indicator: Local processing? | char | 1 | 0 | | | | Allow NULL? |
| 29 | XAUSZ | Indicator for periodic account statements | char | 1 | 0 | | | | Allow NULL? |
| 30 | WEBTR | Bill of exchange limit (in local curr.)(batch input field) | nvarchar | 16 | 0 | | | | Allow NULL? |
| 31 | REMIT | Next payee | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | DATLZ | Date of the last interest calculation run | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | XZVER | Indicator: Record Payment History ? | char | 1 | 0 | | | | Allow NULL? |
| 34 | TOGRU | Tolerance group for the business partner/G/L account | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | KULTG | Probable Time until Check is Paid (Batch Input) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | | | | Allow NULL? |
| 37 | XPORE | Indicator: Pay all items separately ? | char | 1 | 0 | | | | Allow NULL? |
| 38 | BLNKZ | Subsidy indicator for determining the reduction rates | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | ALTKN | Previous Master Record Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | ZGRUP | Key for Payment Grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | LOEVM | Deletion Flag for Master Record (Company Code Level) | char | 1 | 0 | | | | Allow NULL? |
| 42 | SPERR | Posting block for company code | char | 1 | 0 | | | | Allow NULL? |
| 43 | MGRUP | Key for dunning notice grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | URLID | Short Key for Known/Negotiated Leave | nvarchar | 4 | 0 | | | | Allow NULL? |
