NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Direct Debit Mandate Import.
|
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
|
A |
1 |
Mandate Code |
12 |
Character |
Yes |
Enter a unique code for the direct debit mandate. |
|
B |
2 |
Mandate Type |
8 |
Character |
Yes |
Enter SEPA if the direct debit mandate is for the Single Euro Payments Area (SEPA) in the European Union (EU), or Non-SEPA if it is not for SEPA. |
|
C |
3 |
Description |
250 |
Character |
No |
Enter a description of the direct debit mandate. |
|
D |
4 |
Active |
3 |
Yes/No |
No |
Enter Yes if the direct debit mandate is active, or No if the direct debit mandate is not active. Only one direct debit mandate can be marked as active for each combination of customer and customer bank account. |
|
E |
5 |
Mandate Signature Date |
10 |
99/99/9999 |
Yes |
Enter the date the direct debit mandate was signed by the debtor. |
|
F |
6 |
Mandate Reference Number |
35 |
Character |
Yes, only if SEPA is entered for the Mandate Type field (position 2) |
Enter the unique mandate reference number for the direct debit mandate if it is a SEPA direct debit mandate. |
|
G |
7 |
SEPA Direct Debit Scheme |
4 |
Character |
Yes, only if SEPA is entered for the Mandate Type field (position 2) |
Enter one of the following SEPA direct debit schemes for the direct debit mandate if it is a SEPA direct debit mandate:
|
|
H |
8 |
Mandate Sequence Type |
9 |
Character |
Yes, only if SEPA is entered for the Mandate Type field (position 2) |
Enter one of the following mandate sequence types for the direct debit mandate if it is a SEPA direct debit mandate:
|
|
I |
9 |
Creditor Name |
70 |
Character |
Yes |
Enter the name of the creditor for the direct debit mandate. |
|
J |
10 |
Creditor ID |
35 |
Character |
Yes, only if SEPA is entered for the Mandate Type field (position 2) |
Enter the ID of the creditor for the direct debit mandate. |
|
K |
11 |
Cash Account |
29 |
Character |
Yes |
Enter a valid cash general ledger account for the direct debit mandate. This should be unformatted (no hyphens, spaces, or periods). |
|
L |
12 |
Debtor Name |
70 |
Character |
Yes |
Enter the name of the debtor for the direct debit mandate. |
|
M |
13 |
Customer Code |
12 |
Character |
Yes |
Enter a valid paying customer code for the direct debit mandate. |
|
N |
14 |
Bank Account Number |
20 |
Character |
Yes |
Enter a valid customer bank account number of the debtor for the direct debit mandate. |
|
O |
15 |
Daily Account Limit |
15 |
>>>>>>>>>>>9.99 |
No |
Enter the limit that can be debited from the customer bank account for the direct debit mandate for each day if the customer has set up a limit. |
|
P |
16 |
Daily Account Limit Currency |
8 |
Character |
Yes, only if a daily account limit is entered for the Daily Account Limit field (position 15) |
Enter a valid currency code for the daily account limit of the customer bank account for the direct debit mandate. |
|
Q |
17 |
Direct Debit Mandate User Defined 1 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
R |
18 |
Direct Debit Mandate User Defined 2 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
S |
19 |
Direct Debit Mandate User Defined 3 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
T |
20 |
Direct Debit Mandate User Defined 4 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
U |
21 |
Direct Debit Mandate User Defined 5 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
V |
22 |
Direct Debit Mandate User Defined 6 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
W |
23 |
Direct Debit Mandate User Defined 7 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
X |
24 |
Direct Debit Mandate User Defined 8 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
Y |
25 |
Direct Debit Mandate User Defined 9 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
Z |
26 |
Direct Debit Mandate User Defined 10 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AA |
27 |
Direct Debit Mandate User Defined 11 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AB |
28 |
Direct Debit Mandate User Defined 12 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AC |
29 |
Direct Debit Mandate User Defined 13 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AD |
30 |
Direct Debit Mandate User Defined 14 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AE |
31 |
Direct Debit Mandate User Defined 15 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AF |
32 |
Direct Debit Mandate User Defined 16 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AG |
33 |
Direct Debit Mandate User Defined 17 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AH |
34 |
Direct Debit Mandate User Defined 18 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AI |
35 |
Direct Debit Mandate User Defined 19 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
|
AJ |
36 |
Direct Debit Mandate User Defined 20 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter the appropriate user-defined information for the direct debit mandate. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance. |
Before using this import, the following must be set up:
cash general ledger accounts
customers
bank account numbers