DDI payment files
- The files created will be stored in the work directory under a directory named AP161DI-PMT
- The name of the files will default to AP161DI-PMT. These names can be overridden by the names entered on the parameter screen. When running the program for multiple cash codes the file name will be suffixed with each cash code. For example, if running the program for cash code group that contains cash codes CAS1 and CAS2, the file name would be AP161DI-PMT-CAS1 and AP161DI-PMT-CAS2.
- One record is created for each payment or a summarization of all payments if credit memos exist. There are not separate header/detail/total records.
- Each payment processed will be written to a temporary work file
- If any of the payments are credit memos each payment is added to a total field and the payment with the largest amount will have its currency saved.
- After all payments have been written to the work file the program will process the work file. If no credit memos exist then a bank record is created for each payment. If any credit memos do exist then only one bank record is created containing the total amount of all payments and the currency from the payment with largest APP-TRAN-CHK-AMT
- Item Description Structure is the same in entering the batch and return information. Prohibited signs: * % = <> & $ @ # “ : ‘€ ü!
- If the first characters in the field are not allowed: -, spaces, and / spaces, we recommend that you use the letter U instead of the little ü
- The field I/R states where the field is used for transmission of the
batch or in the return information. The field is used for this reason:
- Only when the batch is sent to the bank (I)
- Only for return information (R)
- Both when the batch is sent to the bank and return information (IR)
- The fields that are reserved can be both numeric and alphanumeric
- The empty alphanumeric fields are filled in with spaces and the empty numeric fields with zeroes.
| Number | Position | Data type/size | Field | Description | Instructions | Additional Notes |
|---|---|---|---|---|---|---|
| 1 | 1-8 | Alpha/numeric (8) | Payment Record | CMUO | The command for creation of payment: CMUO | |
| 2 | 9-22 | Alpha/numeric (14) | From Electronic Transfer ID Number | ElectronicTransferID in PayablesElectronicTransferID | From Account number: 10 or 14-digit account number in Danske Bank, Denmark | |
| 3 | 23-57 | Alpha/numeric (35) | To | BankAccountNumber in Vendor/VendorLocation | Transfer: To account number/IBAN in foreign or domestic (foreign currency account, except EUR) financial institution. Check: CHECK |
|
| 4 | 58-60 | Alpha/numeric (3) | Currency | InvoiceCurrency in PayablesInvoicePayment | ISO code. Specify the currency in which the transfer will be made, or check must be denominated in. |
If any Credit memos exist value = InvoiceCurrency of payment with the largest NetPaymentAmount. otherwise value = InvoiceCurrency of payment |
| 5 | 61-74 | Numeric (14) | Amount | Sum of NetPaymentAmount in PayablesInvoicePayment | The amount must be less than DKK 1 mia or the equivalent thereof, max. 2 decimal places. Field length is included. Decimal point, comma, or period must not be used between | If any credit memos exist value = Total of all payments, else value = NetPaymentAmount |
| 6 | 75-77 | Alpha/numeric (3) | Currency Code for exchange | Blank |
ISO currency code for exchange. The field must be blank (“”), if field 5 has the desired currency. If field 5 shows the currency exchange, then field 6 must specify the ISO currency code for exchange. Check: Exchange rate value can only be in DKK |
|
| 7 | 78-85 | Numeric (8) | Date | Electronic Payment Creation Payment Date | Payment date/charge date in the format DDMMYYYY | |
| 8 | 86-86 | Alpha/numeric (1) | Transfer Type | NormalOrExpressCode in Vendor/VendorLocation N=Normal E= Express Translated under the comment |
Transfer Type: 1 = Normal 3= Express |
|
| 9 | 87-123 | Alpha/numeric (35) | Name and Address | RECEIVER ADDR-1: VendorName in
Vendor/VendorLocation PostalAddress from VendorAddress Line 1 = VendorName |
Name and address information for the recipient. | |
| 10 | 124-158 | Alpha/numeric (35) | Name and Address | Blank | ||
| 11 | 159-193 | Alpha/numeric (35) | Name and Address | Blank | No data | |
| 12 | 194-228 | Alpha/numeric (35) | Name and Address | Blank | ||
| 13 | 229-263 | Alpha/numeric (35) | Names and addresses of receiving bank | Name and address of the receiving bank. If the correct BIC/SWIFT address (Field 51) is specific then do not enter eve. Cash Code/Bank ID (Field 52-53) |
If SwiftId = spaces value of Line1=
BankEntity.BankName, Line2 = BankEntity.PostalAddress.DeliveryAddress.AddressLine1 Line 3 + BankEntity.PostalAddress.PostalCode Line 4 = BankEntity.PostalAddress.Municipality |
|
| 14 | 264-298 | Alpha/numeric (35) | Names and addresses of receiving bank | If SwiftId = spaces value of Line1=
BankEntity.BankName, Line2 = BankEntity.PostalAddress.DeliveryAddress.AddressLine1 Line 3 + BankEntity.PostalAddress.PostalCode Line 4 = BankEntity.PostalAddress.Municipality |
||
| 15 | 299-333 | Alpha/numeric (35) | Names and addresses of receiving bank | If SwiftId = spaces value of Line1=
BankEntity.BankName, Line2 = BankEntity.PostalAddress.DeliveryAddress.AddressLine1 Line 3 + BankEntity.PostalAddress.PostalCode Line 4 = BankEntity.PostalAddress.Municipality |
||
| 16 | Alpha/numeric (35) | Names and addresses of receiving bank | If SwiftId = spaces value of Line1=
BankEntity.BankName, Line2 = BankEntity.PostalAddress.DeliveryAddress.AddressLine1 Line 3 + BankEntity.PostalAddress.PostalCode Line 4 = BankEntity.PostalAddress.Municipality |
|||
| 17 | 369-369 | Alpha/numeric (1) | Fees | ChargeCode in Vendor/VendorLocation | Transfer: Fee: 1= Fees in Denmark are paid by the sender and the cross border fees are paid for by the recipient 2= All fees are paid by the sender 3 = All fees are paid by the recipient |
If code =5 value =1 If code =6 value = 2 If code = 7 value = 3 |
| 18 | 370-404 | Alpha/numeric (35) | Text to Recipient | Space | Text to the recipient. Check: You can only write a text to the recipient if the check is sent directly to the receipt amount (Field 43) |
If the Ref Type = F-Fik, this field must contain the invoice number. |
| 19 | 405-439 | Alpha/numeric (35) | Text to Recipient | Space | Text to the recipient. Check: You can only write a text to the recipient if the check is sent directly to the receipt amount (Field 43) |
|
| 20 | 440-474 | Alpha/numeric (35) | Text to Recipient | Space | Text to the recipient. Check: You can only write a text to the recipient if the check is sent directly to the receipt amount (Field 43) |
|
| 21 | 475-509 | Alpha/numeric (35) | Text to Recipient | Space | Text to the recipient. Check: You can only write a text to the recipient if the check is sent directly to the receipt amount (Field 43) |
|
| 22 | 510-544 | Alpha/numeric (35) | Notice to Danske Bank | Space | Additional payment instructions to Danske Bank for transfer. If this field is used there is no discount. | |
| 23 | 545-579 | Alpha/numeric (35) | Notice to Danske Bank | Space | Additional payment instructions to Danske Bank for transfer. If this field is used there is no discount. | |
| 24 | 580-614 | Alpha/numeric (35) | Notice to Danske Bank | Space | Additional payment instructions to Danske Bank for transfer. If this field is used there is no discount. | |
| 25 | 615-618 | Alpha/numeric (4) | Code for payment order | Space | Application to Danmark National Bank. The code for payment order is 1-4 characters. If there is a 1-digit code, specify additional text in fields 32-35 |
|
| 26 | 619-624 | Alpha/numeric (6) | Timing of Implementation | Space | Application Danmark National Bank. Timing of the entries in the format: MMYY or MMYYYY Field to be filled in for order codes on products: 1, 1100, 1200, 1300, or 1800 |
|
| 27 | 625-638 | Alpha/numeric (14) | Term Contract Rate | Space | Future Contract rate, for rate type, the future rate is used. Rate Type in field 46 | |
| 28 | 639-652 | Alpha/numeric (14) | Contract Rate | Space | Contract rate for rate type the contract rate is used. Rate Type in field 46 | |
| 29 | 653-662 | Alpha/numeric (10) | Receiver SE Number | Space | Application to Danmarks National Bank Recipient SE number (8 digits) or Org nbr (10 digits) issued when payment is made on behalf of another company |
|
| 30 | 663-664 | Alpha/numeric (2) | Country of destination | Space | Check: Specify the ISO country code for the country the check is physically sent to. The field is filled in and used only for the check |
|
| 31 | 665-665 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“”) separated by commas | |
| 32 | 666-679 | Alpha/numeric (14) | Description of payment order | Spaces | Application of Danmarks National Bank Further description of the payment order. The field must be used if, in field 25 a 1-digit order code was entered |
|
| 33 | 680-693 | Alpha/numeric (14) | Description of payment order | Spaces | Application of Danmarks National Bank Further description of the payment order. The field must be used if, in field 25 a 1-digit order code was entered |
|
| 34 | 694-707 | Alpha/numeric (14) | Description of payment order | Spaces | Application of Danmarks National Bank Further description of the payment order. The field must be used if, in field 25 a 1-digit order code was entered |
|
| 35 | 708-722 | Alpha/numeric (14) | Description of payment order | Spaces | Application of Danmarks National Bank Further description of the payment order. The field must be used if, in field 25 a 1-digit order code was entered |
|
| 36 | 723-723 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“”) separated by commas. | |
| 37 | 724-724 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“”) separated by commas. | |
| 38 | 725-725 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“”) separated by commas. | |
| 39 | 726-745 | Alpha/numeric (20) | Senders Reference | VendorName in Vendor/VendorLocation | Text on the sender’s account statements | |
| 40 | 746-769 | Alpha/numeric (24) | Note | Spaces | Internal notes. The text is not transferred to the bank | |
| 41 | 770-770 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“”) separated by commas | |
| 42 | 771-771 | Alpha/numeric (1) | Cross Check | Space | Check: Selection for the check to be verified: X = Yes “ “ (Blank) = No |
|
| 43 | 772-772 | Alpha/numeric (1) | Check sent to | Spaces | Check Sent to: 1 = Sender/account holder 2= Collected at the office 3 or “ “(blank) = directly to the check recipient If the check is collected at the office, enter reg no in box 47 |
|
| 44 | 773-773 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“”) separated by commas | |
| 45 | 774-774 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“”) separated by commas | |
| 46 | 775-775 | Alpha/numeric (1) | Rate Type | Space | Specify the Rate Type: 1 or “ “(blank) = selling rate 2 = Spot rate 3 = future rate * 4 = Contract rate. Can not be used for a check** *Future rate must be specified in field 27. ** Contract rate must be specified in field 28. If there is no change, leave blank (“ “). |
|
| 47 | 776-779 | Alpha/numeric (4) | Office | Spaces | Check: Registration number of the office to retrieve the check from. This field must be specified if selected 2 in field 43. |
|
| 48 | 780-780 | Alpha/numeric (1) | Fees | Space | Check: Select if the check amount is: X= including the fees of Danske Bank “ “ (Blank) = excluding fees of Danske Bank |
|
| 49 | 781-815 | Alpha/numeric (35) | Notice to sender | Space | Check:Text to the sender to indicate the bill from the bank | |
| 50 | 816-850 | Alpha/numeric (35) | Notice to sender | Space | Check:Text to the sender to indicate the bill from the bank | |
| 51 | 851-861 | Alpha/numeric (11) | BIC/SWIFT address | SwiftId in Vendor/VendorLocation of CrossBorderIdentifier = S in Vendor/VendorLocation | Transfer: BIC/SWIFT address: 8 or 11 characters. The correct BIC/SWIFT address is essential to get the full discount |
|
| 52 | 862-863 | Alpha/numeric (2) | Bank Code | Vendor/VendorLocation BankingCode |
Transfer: when the bank code is entered, the Bank ID
(field 53) is also entered. Bank code for recipient bank: AT= Bankleitzahl (Austria) BL= Bankleitzahl (Germany) CC= Canadian payment Association (Canada) CP=CHIPS participant ID (USA) CH=CHIPS code (UID no) (USA) FW= FEDWIRE (ABA no) (USA) SC= Sort Code (UK/Ireland) |
|
| 53 | 864-962 | Alpha/numeric (9) | Bank ID | Vendor/VendorLocation BankId |
Transfer: Bank ID to be completed if a bank code was
specified in field 52: Bankleitzahl (Austria): 5 digits Bankleitzahl (Germany): 8 digits Canadian payment Association (Canada): 9 digits CHIPS participant ID (USA): 6 digits CHIPS code (UID no) (USA): 4 digits FEDWIRE (ABA no) (USA): 9 digits Sort Code (UK/Ireland): 6 digits |
If BankId = 0 value = spaces else value = Bank ID |
| 54 | 963-964 | Alpha/numeric (2) | Country Code for bank | PostalAddress.Country in BankEntity | If SwiftId = spaces then value = BankEntity.PostalAddress.Country | |
| 55 | 965-965 | Alpha/numeric (1) | Filler | Blank | Not used. Set to blank (“ “) separated by commas | |
| 56 | 966-967 | Alpha/numeric (2) | Recipient’s country of origin | Blank | ISO country code for the recipient |