| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LAUFD | Date on Which the Program Is to Be Run | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | LAUFI | Additional Identification | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | KOART | Account Type | char | 1 | 0 | | | | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | CPDKY | Sort field for one-time accounts | nvarchar | 16 | 0 | | | | Allow NULL? |
| 9 | SKNRZE | Head office account number (in branch accounts) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | SMABER | Dunning Area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | SMAHSK | Dunning level | char | 1 | 0 | | | | Allow NULL? |
| 12 | BUSAB | Dunning clerk | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | VERSN | Consecutive change number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | AUSDT | Dunning date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | GRDAT | Posting date up to which documents are included | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | KNRMA | Account number of the dunning recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | GMVDT | Date of the legal dunning proceedings | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | MAHNA | Dunning Procedure | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | MAHNS | Dunning level | char | 1 | 0 | | | | Allow NULL? |
| 20 | VZSKZ | Interest calculation indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | SALDO | Balance in dunning area in dunning currency | decimal | 15 | 2 | | | | |
| 23 | SALHW | Balance in dunning area local currency | decimal | 15 | 2 | | | | |
| 24 | GSFBT | Total of blocked and due items | decimal | 15 | 2 | | | | |
| 25 | GSNBT | Total balance of blocked items not due | decimal | 15 | 2 | | | | |
| 26 | FAEBT | Total of line items due | decimal | 15 | 2 | | | | |
| 27 | FAEHW | Total of due items in local currency | decimal | 15 | 2 | | | | |
| 28 | XMFLG | Indicator: Is a dunning notice sent? | char | 1 | 0 | | | | Allow NULL? |
| 29 | MANSP | Dunning block | char | 1 | 0 | | | | Allow NULL? |
| 30 | MAHSK | Highest dunning level for account in dunning area | char | 1 | 0 | | | | Allow NULL? |
| 31 | ZINBT | Interest total for dunning notice in dunning currency | decimal | 15 | 2 | | | | |
| 32 | ZINHW | Interest total for dunning notice in company code currency | decimal | 15 | 2 | | | | |
| 33 | XZINS | Indicator: Do not display interest in the dunning notice | char | 1 | 0 | | | | Allow NULL? |
| 34 | VERTN | Contract Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 35 | VERTT | Contract Type | char | 1 | 0 | | | | Allow NULL? |
| 36 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | FAMSM | Total due itemsin dunning currency from dunning level | decimal | 15 | 2 | | | | |
| 38 | FAMSH | Total due items in local currency from dunning level | decimal | 15 | 2 | | | | |
| 39 | PSTLZ | Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | ORT01 | City | nvarchar | 35 | 0 | | | | Allow NULL? |
| 41 | STRAS | House number and street | nvarchar | 35 | 0 | | | | Allow NULL? |
| 42 | PFACH | PO Box | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
