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