BGD payment files
Header Record - record Type 11 - Initial Record
The record header contains the records that are created once per cash code, pay group, payment code (aka Bank Inst Code).
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 11 | ||
| 2 | 3-12 | Alpha/numeric (10) | Electronic Transfer ID Number | ElectronicTransferID in PayablesElectronicTransferID table | Right aligned, zero filled | |
| 3 | 13-18 | Numeric (6) | Print Date | WS-FILE-DATE | System Date in Electronic Payment Creation – YYMMDD | |
| 4 | 19-40 | Alpha/numeric (22) | Text | VENDOR PAYMENTS | ||
| 5 | 41-46 | Numeric (6) | Payment Date | Spaces | Text = VENDOR PAYMENTS | |
| 6 | 47-59 | Alpha/numeric (13) | Blank | Blank | ||
| 7 | 60-62 | Alpha/numeric (3) | Currency Code | Currency in CashCode table | Cash Code from Electronic Payment Creation screen | |
| 8 | 63-80 | Alpha/numeric (18) | Blank | Blank |
Header Record - record Type 12 - Fixed Information - Optional
The record header contains the records that are created once per cash code, pay group, payment code (aka Bank Inst Code).
Only created if CBI-PMT-INSTUCT1 is populated. Here you can specify a generic message printed on notification to payees. The user can also specify a deadline to this information must be included in the slips.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 12 | ||
| 2 | 3-52 | Alpha/numeric (50) | Info Test | ElectronicPaymentInstruction1 in BankTransactionCode table | The record is used for information directed to all payees. | |
| 3 | 53-58 | Numeric (6) | Print Date | Electronic Payment Creation Payment Date | Date that determines how long information should be provided. Must be a business day. When the entry used, the field is mandatory. | |
| 4 | 59-80 | Alpha/numeric (22) | Blank | Blank |
Header Record - record Type 13 - Heading - Optional
The record header contains the records that are created once per cash code, pay group, payment code (aka Bank Inst Code).
Only created if CBI-PMT-INSTUCT2 has values in positions 1-23. Payments are usually specified with reference number or invoice number. In order to facilitate the payee must report on the paper can be made more readable by the user writes headers on it, for example, “Invoice Number” and “Amount.”
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 13 | ||
| 2 | 3-27 | Alpha/numeric (25) | Heading1 | ElectronicPaymentInstruction2 in BankTransactionCode table | Positions 1-23 | |
| 3 | 28-39 | Alpha/numeric (12) | Heading2 | ElectronicPaymentInstruction2 in BankTransactionCode table | Positions 24-36 | |
| 4 | 40-80 | Alpha/numeric (41) | Blank | Blank |
Payment record – Record Type 14
Only created for debit amount payments. Information for the Payee.
The payment records are created for each payment per vendor.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 14 | ||
| 2 | 3-12 | Alpha/numeric (10) | Recipients Bank Account | BankAccountNumber from Vendor/VendorLocation or BankAccountNumber from CashLedgerPayment (not used until further notice) | Recipient’s bank or payment number. Right aligned, zero filled | If Pos 1-10 Blank or VEN/VLO-VBANK-IDENT is not equal to Q then value = 10 spaces, followed by “00”, followed by the number of pmt records with VEN/VLO-VBANK-IDENT = K and C. Else Value = pos 1-10 of Bank Acct |
| 3 | 13-37 | Alpha/numeric (25) | Reference | PayablesInvoice Invoice | Payment Specification. Recipient’s reference, invoice number, etc, must be specified in this field. If self-reference, verification number or similar, or other information is provided, use information in record type 25 Personal information can also be specified in positions 61-80 of this record. | |
| 4 | 38-49 | Alpha/numeric (12) | Amount | Invoice Amount PayablesInvoicePayment.NetPaymentAmount |
Amount in cents, right aligned, zero filled. Enter “00” for regular kroon. Must not contain non-numeric characters or negative numbers | |
| 5 | 50-55 | Numeric (6) | Payment Date | Date of Payment in PaymentOption = “P” in table BankTransactionCode otherwise due date | YYMMDD | If APP-DUE-DATE < AP161 Payment Date or CBI-PAYMENT-OPT = P value = AP161 Payment Date Else Value = APP-DUE-DATE |
| 6 | 56-60 | Alpha/numeric (5) | Blank | Blank | ||
| 7 | 61-80 | Alpha/numeric (20) | Sender Information | PayablesInvoice.VoucherNumber | Sender information. Not required |
Payment record– Record Type 15
Only created for credit Memos if CBI-PAYMENT-OPT = P. Deduction on a specific date
The payment records are created for each payment per vendor.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 15 | ||
| 2 | 3-12 | Alpha/numeric (00) | Recipients Bank Account | BankAccountNumber from Vendor/VendorLocation or BankAccountNumber from CashLedgerPayment (not used until further notice) | Recipient’s bank or payment number. Right aligned, zero filled. | If Pos 1-10 Blank or Vendor or VendorLocation BankAccountValidationType is =B then value = 10 spaces, followed by “00”, followed by the number of pmt records with BankAccountValidationType = K and C. Else Value = pos 1-10 of Bank Acct |
| 3 | 13-37 | Alpha/numeric (25) | Reference | PayablesInvoice Invoice | Payment Specification. Recipient’s reference, invoice number, etc, must be specified in this field. If self-reference, verification number or similar, or other information is provided, use information in record type 25 Personal information can also be specified in positions 61-80 of this record. | |
| 4 | 38-49 | Numeric (12) | Amount | Invoice Amount PayablesInvoicePayment.NetPaymentAmount |
Deduction Amount in cents, right aligned, zero filled. Enter “00” for regular kronos. Must not contain non-numeric characters or negative numbers | |
| 5 | 50-55 | Alpha/numeric (6) | Due Date | Electronic Payment Creation Payment Date | YYMMDD | If BankTransactionCode.PaymentOption = P, Value = Electronic Payment Creation Payment Date and Rec Type 15 creation ELSE Rec Type 16 created and value = PayablesInvoicePayment.DueDate + 340 days |
| 6 | 56-60 | Alpha/numeric (5) | Blank | Blank | ||
| 7 | 61- | Alpha/numeric (20) | Sender Information | PayablesInvoice.VoucherNumber | Sender Information. Not required |
Payment record - Record Type 16
Only created for credit Memos if CBI-PAYMENT - OPT not equal P. Credit Note with monitoring
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 16 | ||
| 2 | 3-12 | Alpha/numeric (10) | Recipients Bank Account | BankAccountNumber from Vendor/VendorLocation or BankAccountNumber from CashLedgerPayment (not used until further notice) | Recipient’s bank or payment number. Right aligned, zero filled. | |
| 3 | 13-37 | Alpha/numeric (25) | Reference | PayablesInvoice Invoice | Payment Specification. Recipient’s reference, invoice number, etc, must be specified in this field. If self-reference, voucher number or similar, or other information is provided, use information in record type 25 Personal information can also be specified in positions 61-80 of this record. | |
| 4 | 38-49 | Numeric (12) | Amount | Invoice Amount PayablesInvoicePayment.NetPaymentAmount |
Deduction Amount in cents, right aligned, zero filled. . Must not contain non-numeric characters or negative numbers | |
| 5 | 50-55 | Alpha/numeric (6) | Due Date | PayablesInvoicePayment.DueDate + 340 days Payment Date + 340 days |
YYMMDD Final monitoring date |
|
| 6 | 56-60 | Alpha/numeric (5) | Blank | Blank | ||
| 7 | 61-80 | Alpha/numeric (20) | Sender Information | PayablesInvoice.VoucherNumber | Sender information. Not required |
Payment record - Record Type 25
– Records created from API comments. One record for each comment with a max of 29. Records only created if the CBI-PG-WITH-BG not equal Y. Information record is placed directly after the invoice or deduction /credit note to which it belongs. If the user needs to enter information other than a reference number / invoice number use the information items. These can contain any text. It is possible to transmit at up to 90 items of information with each payment order. The payment records are created for each payment per vendor.
| Number | Position | Data type/sizez | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 25 | ||
| 2 | 3-12 | Alpha/numeric (10) | Recipients Bank Account | BankAccountNumber from Vendor/VendorLocation | Recipient’s bank or payment number. Right aligned, zero filled. | |
| 3 | 13-62 | Alpha/numeric (50) | Payment Specification | PayablesInvoiceComment | Payment Specification. Record is used when the corresponding field in a payment, deduction or credit note record is insufficient to specify the payment order. | |
| 4 | 63-80 | Alpha/numeric (18) | Blank | Blank |
Payee record - Record Type 26
Records created when VEN/VLO-VBANK-IDENT = C. Name, cash payment or deposit account with notice. Name and address reocrds should be placed immediately before the payment records they belong to. Meaning before Rec types 54, 14, 15, 25, 65. The payee records are created once per vendor.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 26 | ||
| 2 | 3-6 | Alpha/numeric (4) | Text | Text = 0000 | ||
| 3 | 7-12 | Alpha/numeric (6) | Payment Number | Serial Number | Payment Number. Right aligned, zero filled. Pos
1-5 = numbers Pos 6 = space |
A counter that gets incremented for every payee record whose Vendor or VendorLocation BankAccountValidationType = C or K |
| 4 | 13-47 | Alpha/numeric (35) | Recipient’s Name | VendorName in Vendor/VendorLocation | Recipient’s name in capital letters | |
| 5 | 48-80 | Alpha/numeric (33) | Extra name field | Spaces | Extra Name field |
Payee record - Record Type 27
Records created when VEN/VLO-VBANK-IDENT = C. The payee records are created once per vendor. Address, cash payment or deposit account with notice. (Note: Not for Euro) Name and address records should be placed immediately before the payment records they belong to. Meaning before Rec types 54, 14, 15, 25, 65
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 27 | ||
| 2 | 3-6 | Alpha/numeric (4) | Text | Text = 0000 | ||
| 3 | 7-12 | Alpha/numeric (6) | Payment Number | Serial Number | Payment Number. Right aligned, zero filled. Pos
1-5 = numbers Pos 6 = space |
A counter that gets incremented for every payee record whose endor or VendorLocation BankAccountValidationType = C or K |
| 4 | 13-47 | Alpha/numeric (35) | Recipient’s Name | PostalAddress.DeliveryAddress.AddressLine1 from Vendor or VendorLocation | Recipient’s street address in capital letters | |
| 5 | 48-52 | Alpha/numeric (5) | Recipients postal Code | PostalAddress.DeliveryAddress.Postal Code from Vendor or VendorLocation | Recipient’s postal code, not edited | |
| 6 | 53-72 | Alpha/numeric (20) | Recipient Address City | PostalAddress.Municipality from Vendor or VendorLocation | Recipient address city in capital letters | |
| 7 | 73-80 | Alpha/numeric (8) | Blank | Blank |
Payee record - Record Type 40
- Records created when VEN/VLO-VBANK-IDENT = K and BANK-ACCT is populated. Account number, account, payroll deposit. These records should be placed immediately before the name and address record it is linked to. The account, payroll deposit without notification, the entry is placed immediately before the payment records (Record type 14) they belong to. Meaning before Rec types 54, 14, 15, 25, 65. The payee records are created once per vendor.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 40 | ||
| 2 | 3-6 | Alpha/numeric (4) | Text | Text = 0000 | ||
| 3 | 7-12 | Numeric (5) Alpha/numeric (1) |
Payment Number | Serial Number | Payment Number. Right aligned, zero filled. Pos
1-5 = numbers Pos 6 = space |
A counter that gets incremented for every payee record whose endor or VendorLocation BankAccountValidationType = C or K |
| 4 | 13-28 | Alpha/numeric (16) | Recipient’s Bank account number | BankAccountNumber from Vendor/VendorLocation Account Type = K |
Recipient’s bank account number. Pos 13-16 clearing number, Pos 17-28 account codes other figures, right aligned, zero filled |
|
| 5 | 29-40 | Alpha/numeric (2) | Reference | PayablesInvoice Invoice | Blank or any reference to Bank Acct sends to the recipient’s bank for printing account statement. Use only with the account, payroll deposit without notice | |
| 6 | 41-41 | Alpha/numeric (1) | Text | Space | Blank | |
| 7 | 42-80 | Alpha/numeric (39) | Blank | Blank |
Total Record - Record Type 29
The trailer record is created once per Cash Code, Pay Group, Payment Code
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-2 | Alpha/numeric (2) | Record Type | 29 | ||
| 2 | 3-12 | Alpha/numeric (10) | Sender Bank Account | ElectronicTransferID in PayablesElectronicTransferID | The sender’s bank acct number. Right aligned, zero filled | |
| 3 | 13-20 | Numeric (8) | Number of Records | Calculated | Number of records. Numeric field (Record Type 14-17). Right aligned, zero filled | |
| 4 | 21-32 | Alpha/numeric (12) | Total Amount | Calculated | Total amount per section (Record Type 14-17) Right aligned, zero filled. Note: Rounding off the Swedish kroon or euros is not allowed! | |
| 5 | 33-79 | Alpha/numeric (47) | Blank | Blank |