Records Used for Transferring Dunning
Data
Definition
In order to send dunning items to a collection agency, the system creates three different records, containing:
· Header data
· Customer/vendor data
· Open item data
Structure
Header (All Files)
Field |
Description |
Length |
Type |
Field name |
1 |
Record type (01) |
2 |
NUMC |
|
2 |
Date |
8 |
DATS |
F150V-AUSDT |
3 |
|
1 |
CHAR |
|
Customer/Vendor Records
Field |
Description |
Length |
Type |
Field name |
1 |
Record type (02) |
2 |
NUMC |
|
2 |
Customer ID at collection agency |
48 |
CHAR |
T001Z-PAVAL |
3 |
Company code |
4 |
CHAR |
T001-BUKRS |
4 |
Account type (K or D) |
1 |
CHAR |
MHND-KOART |
5 |
Customer/vendor number |
10 |
CHAR |
MHND-KUNNR |
6 |
Alternative dunning recipient |
10 |
CHAR |
KNB5-KNRMA |
7 |
Customer/vendor name 1 |
35 |
CHAR |
KNA1-NAME1 |
8 |
Customer/vendor name 2 |
35 |
CHAR |
KNA1-NAME2 |
9 |
Customer/vendor name 3 |
35 |
CHAR |
KNA1-NAME3 |
10 |
Customer/vendor name 4 |
35 |
CHAR |
KNA1-NAME4 |
11 |
Customer/vendor house number and street |
35 |
CHAR |
KNA1-STRAS |
12 |
Customer/vendor P.O. box |
10 |
CHAR |
KNA1-PFACH |
13 |
Customer/vendor postal code |
10 |
CHAR |
KNA1-PSTLZ |
14 |
Customer/vendor P.O. box postal code |
10 |
CHAR |
KNA1-PSTL2 |
15 |
Customer/vendor city |
35 |
CHAR |
KNA1-ORT01 |
16 |
Customer/vendor ISO country key |
3 |
CHAR |
KNA1-LAND1 |
17 |
Customer/vendor VAT registration number |
20 |
CHAR |
KNA1-STCEG |
18 |
Customer/vendor telephone number 1 |
16 |
CHAR |
KNA1-TELF1 |
19 |
Customer/vendor telephone number 2 |
16 |
CHAR |
KNA1-TELF2 |
20 |
Customer/vendor fax number |
31 |
CHAR |
KNA1-TELFX |
Open Items
Field |
Description |
Length |
Type |
Field name |
1 |
Record type (03) |
2 |
NUMC |
|
2 |
Item type In files sent to collection agency, this field is left blank. In files sent back by the collection agency: I: interest C: charges |
1 |
CHAR |
|
3 |
Document number |
10 |
CHAR |
BSEG-BELNR |
4 |
Posting date |
8 |
NUMC |
BSEG-BUDAT |
5 |
Reference document number at collection agency (left blank in files sent to the collection agency) |
12 |
CHAR |
BSEG-XREF1 |
6 |
Payment reference number |
30 |
CHAR |
BSEG-KIDNO |
7 |
Line item number |
3 |
NUMC |
BSEG-BUZEI |
8 |
Fiscal year |
4 |
NUMC |
BSEG-GJAHR |
9 |
Baseline date for calculating due date |
8 |
NUMC |
BSEG-ZFBDT |
10 |
Due date |
8 |
NUMC |
MHND-FAEDT |
11 |
Local currency key |
5 |
CHAR |
T001-WAERS |
12 |
Amount in local currency |
13 |
NUMC |
|
13 |
Debit/credit indicator: S: debit H: credit |
1 |
CHAR |
MHND-SHKZG |
14 |
Foreign currency key |
5 |
CHAR |
MHND-WAERS |
15 |
Amount in foreign currency |
13 |
NUMC |
|
· The system stores the amounts in a numerical character field (that is, without any decimal points). The number of the decimal places depends on which currency fields are used.
· In step 1, all the fields are filled out for all customers except for one-time customers.
· In step 2, the following fields must be filled out:
Record |
Fields |
Header |
All |
Customer/vendor |
1, 5, 6 |
Line item |
1, 2, 6, 11–15 |
· In step 3, all the fields are filled out for all customers other than one-time customers. If an alternative dunning recipient has been specified, fields 7–20 in the customer/vendor record are left blank.
See also: