| 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 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | No | | VTREF_KK | Allow NULL? |
| 3 | MVLNR | Dunning Procedure Sequence Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | MVLNR_VK | Allow NULL? |
| 4 | BEARS | Editing Step in Dunning History | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BEARS_VK | Allow NULL? |
| 5 | SLNR | Record no. in dunning procedure processing step | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SLNR_VK | Allow NULL? |
| 6 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | FKKMAKO | GPART_KK | Allow NULL? |
| 7 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | FKKMAKO | VKONT_KK | Allow NULL? |
| 8 | MAHNV | Dunning Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MAHNV_KK | Allow NULL? |
| 9 | MVTYP | Dunning Procedure Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MVTYP_KK | Allow NULL? |
| 10 | MVART | Type of dunning procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | MVART_VK | Allow NULL? |
| 11 | MAHNS | Dunning Level | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | MAHNS_KK | Allow NULL? |
| 12 | MSTYP | Dunning Level Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MSTYP_KK | Allow NULL? |
| 13 | MSNEU | New Dunning Level | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | MSNEU_VK | Allow NULL? |
| 14 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 15 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 16 | MVSTA | Dunning Procedure Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | MVSTA_VK | Allow NULL? |
| 17 | MSDAT | Execution Date of Dunning Level | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MSDAT_VK | Allow NULL? |
| 18 | MNDAT | Earliest Execution Date of Next Dunning Run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MNDAT_VK | Allow NULL? |
| 19 | MVVON | Dunning Procedure Start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MVVON_VK | Allow NULL? |
| 20 | MVBIS | Dun Procedure End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MVBIS_VK | Allow NULL? |
| 21 | PRGRP | Product Group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PRGRP_VK | Allow NULL? |
| 22 | VSARK | Insurance Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | VSARL_VX | Allow NULL? |
| 23 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 24 | MSALM | Dunning Balance | decimal | 13 | 2 | CURR | ((0)) | Yes | | MSALM_KK | |
| 25 | MSALH | Not used (formerly dunned amount in local currency) | decimal | 13 | 2 | DEC | ((0)) | Yes | | UNUSED_KK | |
| 26 | ASALM | Down Payment Balance | decimal | 13 | 2 | CURR | ((0)) | Yes | | ASALM_VK | |
| 27 | ASALH | Not used (formerly dunned amount in local currency) | decimal | 13 | 2 | DEC | ((0)) | Yes | | UNUSED_KK | |
| 28 | RGEBM | Graduated charge for returns | decimal | 13 | 2 | CURR | ((0)) | Yes | | RLGEB_KK | |
| 29 | RGEBH | Not used (formerly dunned amount in local currency) | decimal | 13 | 2 | DEC | ((0)) | Yes | | UNUSED_KK | |
| 30 | GGEBM | Business Charge in Dunning Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | GGEBM_VK | |
| 31 | GGEBH | Not used (formerly dunned amount in local currency) | decimal | 13 | 2 | DEC | ((0)) | Yes | | UNUSED_KK | |
| 32 | AUSBL | Document Number that Triggers Dunning (Leading) Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | DFKKOP | AUSBL_VK | Allow NULL? |
| 33 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | DFKKOP | OPUPK_KK | Allow NULL? |
| 34 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | DFKKOP | OPUPZ_KK | Allow NULL? |
| 35 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | DFKKOP | OPUPW_KK | Allow NULL? |
| 36 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 37 | FAEVON | Net due date of first current premium dunned | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEVON_VK | Allow NULL? |
| 38 | FAEBIS | Net due date of most recently dunned current premium | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEBIS_VK | Allow NULL? |
| 39 | LAUFD | Date ID | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | FKKMAKO | LAUFD_KK | Allow NULL? |
| 40 | LAUFI | Additional Identification Characteristic | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | FKKMAKO | LAUFI_KK | Allow NULL? |
| 41 | MAZAE | Counter for several dunning notices to a business partner | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | FKKMAKO | MAZAE_KK | Allow NULL? |
| 42 | ROPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | OPBEL_KK | Allow NULL? |
