BGI payment files
Header record - Record Type 0 - Initial Record
(Payer record) The record header contains the records that are created once per cash code, pay group, payment code
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Alpha/numeric (1) | Record Type | 0 | Initial Record | |
| 2 | 2-9 | Alpha/numeric (8) | Bank Account number Electronic Transfer ID number |
ElectronicTransferID in PayablesElectronicTransferID table | Sender Bank account number. Right aligned, zero filled | |
| 3 | 10-15 | Numeric (6) | Production date | System Date | Print date. YYMMDD | |
| 4 | 16-37 | Alpha/numeric (22) | Sender Name | Name in PayablesCompany | Name in capital letters or blank | |
| 5 | 38-72 | Alpha/numeric (35) | Sender’s Address | Space | Address in capital letters or blank | |
| 6 | 73-78 | Numeric (6) | Date | Space | Payment date, YYMMDD. If payment date is specified in the individual payment records field is left blank. | |
| 7 | 79-79 | Alpha/numeric (1) | New Code | 2 | Text = 2 (layout code) | |
| 8 | 80-80 | Alpha/numeric (1) | Bank | Blank |
Payee record - Record Type 2 - Name Record
The payee records are created once per vendor and when APP-INV-CURRENCY changes. When currency changes record type 4 is only created if value in bank account.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Alpha/numeric (1) | Record Type | 2 | Name | |
| 2 | 2-8 | Alpha/numeric (7) | Vendor Nbr | Serial number 7 last positions of the AP Vendor
number PayablesInvoicePayment.PayVendor |
Recipient, Vendor number. Right aligned, zero filled | |
| 3 | 9-38 | Alpha/numeric (30) | Name Line 1 | VendorName in Vendor/VendorLocation | Name 1 | |
| 4 | 39-73 | Alpha/numeric (35) | Name Line 2 | Space | Name 2 or Blank | |
| 5 | 74-80 | Alpha/numeric (7) | Blank |
Payee record - Record Type 3 - Address Record
The payee records are created once per vendor and when APP-INV-CURRENCY changes. When currency changes record type 4 is only created if value in bank account.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Alpha/numeric (1) | Record Type | 3 | Address Record | |
| 2 | 2-8 | Alpha/numeric (7) | Vendor Nbr | Serial number 7 last positions of the AP Vendor
Number PayablesInvoicePayment.PayVendor |
Recipient, Vendor number. Right aligned, zero filled | |
| 3 | 9-38 | Alpha/numeric (30) | Address Line 1 | PostalAddress.DeliveryAddress.AddressLine1 in VendorAddress | Street address in capital letters | |
| 4 | 39-73 | Alpha/numeric (35) | Address Line 2 | PostalAddress.PostalCode and
PostalAddress.Municipality in VendorAddress |
Postal address and country in capital letters | |
| 5 | 74-74 | Alpha/numeric (1) | Load | Vendor/VendorLocation DebitingSign |
Debiting Sign | |
| 6 | 75-76 | Alpha/numeric (2) | Country Code | Country VendorAddress | Categories | |
| 7 | 77-77 | Alpha/numeric (1) | Reserve | Blank | Reserve, use according to the Bank’s Instructions | |
| 8 | 78-78 | Alpha/numeric (1) | Charge Code | Vendor/VendorLocation ChargeCode | Code for charging fees | |
| 9 | 79-79 | Alpha/numeric (1) | Payment Form | PaymentForm from Vendor/VendorLocation foreign – reversed codes. When formatting for format BGI (PGI codes ok) | Code for payment form | If PaymentForm = 0 value =1. If PaymentForm = 9 value =0 |
| 10 | 80-80 | Alpha/numeric (1) | Payment method | NormalOrExpressCode from Vendor/VendorLocation | Code for method of payment | If code = E value =1 else value =0 |
Payment record - Record Type 4 - Bank - Optional
Created only if PMT-FORM not = 9 (position 2) - The payee records are created once per vendor and when APP-INV-CURRENCY changes. When currency changes record type 4 is only created if value in bank account.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Alpha/numeric (1) | Record Type | 4 | Bank | |
| 2 | 2-8 | Alpha/numeric (7) | Vendor Nbr | Serial Number 7 last positions of the AP Vendor
Number PayablesInvoicePayment.PayVendor |
Recipient, Vendor number. Right aligned, zero filled | |
| 3 | 9-20 | Alpha/numeric (12) | Swift Addr | SwiftId from Vendor/VendorLocation | Field to identify the recipient’s bank/bank account. Use according to the Bank’s instructions. | |
| 4 | 21-50 | Alpha/numeric (30) | Recipient Bank Account Number | BankAccountNumber from Vendor/VendorLocation | Field to identify the recipient’s bank /bank account. Use according to the Bank’s instructions | |
| 5 | 51-80 | Alpha/numeric (30) | Recipient’s Bank Name and Country | BankName from BankEntity | Field to identify the recipient’s bank. Use according to the Bank’s instructions | Pos 1-22 =BankEntity.BankName Pos 23-24 = BankEntity.PostalAddress.Country |
Credit record - Record Type 5 - Credit Note
Created for credit memos only. The payment records are created for each payment per vendor.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Alpha/numeric (1) | Record Type | 5 | Credit Note | |
| 2 | 2-8 | Alpha/numeric (7) | Vendor Nbr | 7 last positions of the AP Vendor Number PayablesInvoicePayment.PayVendor |
Recipient, Vendor number. Right Aligned, zero filled | |
| 3 | 9-33 | Alpha/numeric (25) | Reference | PayablesInvoice Invoice | Payment Specification | |
| 4 | 34-44 | Numeric (11) | SEK Amount | Invoice Amount PayablesInvoicePayment.NetPaymentAmount |
Customer Amount. Right aligned, zero filled. Invoice Amount equivalent in SEK/cents after default rate (00 for regular amounts) | If last decimal position = 0, value of pos 11 =
“-“ If last decimal position = 1, value of pos 11 = “J” If last decimal position = 2, value of pos 11 = “K” If last decimal position = 3, value of pos 11 = “L” If last decimal position = 4, value of pos 11 = “M” If last decimal position = 5, value of pos 11 = “N” If last decimal position = 6, value of pos 11 = “O” If last decimal position = 7, value of pos 11 = “P” If last decimal position = 8, value of pos 11 = “Q” If last decimal position = 9, value of pos 11 = “R” |
| 5 | 45-54 | Alpha/numeric (10) | Currency Account | “0000000000” | Currency Account, future transaction number, possibly zero | |
| 6 | 55-57 | Alpha/numeric (3) | Currency Code | PayablesInvoicePayment.InvoiceCurrency | Currency code, coinage, according to ISO standard or numeric code | |
| 7 | 58-63 | Alpha/numeric (6) | Last Accounting Date | Check Date | Last monitoring date YYMMDD | If PayablesInvoicePayment.DueDate<Electronic Payment Creation Payment Date value = Payment Date else value = PayablesInvoicePayment.DueDate |
| 8 | 64-64 | Alpha/numeric (1) | Text | Blank | Text = 0, optionally ending book code | |
| 9 | 65-65 | Alpha/numeric (1) | Reserve | Blank | Reserve. Use according to the Bank’s instructions. | |
| 10 | 66-78 | Numeric (13) | Amount | Invoice Amount PayablesInvoicePayment.NetPaymentAmount |
Invoice Amount. Right aligned, zero filled Note: All currencies have 2 decimal places (DD for regular amounts) | If last decimal position = 0, value of pos 13 =
“-“ If last decimal position = 1, value of pos 13 = “J” If last decimal position = 2, value of pos 13 = “K” If last decimal position = 3, value of pos 13 = “L” If last decimal position = 4, value of pos 13 = “M” If last decimal position = 5, value of pos 13 = “N” If last decimal position = 6, value of pos 13 = “O” If last decimal position = 7, value of pos 13 = “P” If last decimal position = 8, value of pos 13 = “Q” If last decimal position = 9, value of pos 13 = “R” |
| 11 | 79-79 | Alpha/numeric (1) | ID Code | Blank | Identification code for the category reporting | |
| 12 | 80-80 | Alpha/numeric (1) | Reserve | Blank | Reserve. Use according to the Bank’s Instructions. |
Payment record - Record Type 6 - Invoice
Created for debit amount payments. The payment records are created for each payment per vendor.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Alpha/numeric (1) | Record Type | 6 | Payment | |
| 2 | 2-8 | Alpha/numeric (7) | Vendor Nbr | 7 last positions of the AP Vendor Number PayablesInvoicePayment.PayVendor |
Recipient, Vendor number. Right Aligned, zero filled | |
| 3 | 9-33 | Alpha/numeric (25) | Reference | PayablesInvoice Invoice | Payment Specification | |
| 4 | 34-44 | Numeric (11) | SEK Amount | Invoice Amount PayablesInvoicePayment.NetPaymentAmount |
Customer Amount. Right aligned, zero filled. Invoice Amount equivalent in SEK/cents after default rate (00 for regular amounts). NOTE: must not contain minus signs | |
| 5 | 45-54 | Alpha/numeric (10) | Currency Account | “0000000000” | Currency Account, future transaction number, possibly zero | |
| 6 | 55-57 | Alpha/numeric (3) | Currency Code | PayablesInvoicePayment.InvoiceCurrency | Currency code, coinage, according to ISO standard or numeric code | |
| 7 | 58-63 | Alpha/numeric (6) | Payment Date | Check Date/DueDte | Payment date, YYMMDD. Leave blank if payment date specified in the opening record | If PayablesInvoicePayment.DueDate <
Electronic Payment Creation Payment Date Value = Payment Date else value = PayablesInvoicePayment.DueDate |
| 8 | 64-64 | Alpha/numeric (1) | Text | Blank | Reserve. Use according to the Bank’s Instructions | |
| 9 | 65-65 | Alpha/numeric (1) | Reserve | Blank | Reserve. Use according to the Bank’s instructions. | |
| 10 | 66-78 | Numeric (13) | Amount | Invoice Amount PayablesInvoicePayment.NetPaymentAmount |
Invoice Amount. Right aligned, zero filled Note: All currencies have 2 decimal places (DD for regular amounts). Must not contain minus signs |
|
| 11 | 79-79 | Alpha/numeric (1) | ID Code | 0 | Identification code for the category reporting | |
| 12 | 80-80 | Alpha/numeric (1) | Reserve | Blank | Reserve. Use according to the Bank’s Instructions. |
Payment record - Record Type 7 - Category code
The payment records are created for each payment per vendor.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Alpha/numeric (1) | Record Type | 7 | Category Code | |
| 2 | 2-8 | Alpha/numeric (7) | Vendor Nbr | 7 last positions of the AP Vendor Number PayablesInvoicePayment.PayVendor |
Recipient, Vendor number. Right aligned, zero filled | |
| 3 | 9-11 | Alpha/numeric (3) | Category Code | PaymentCategoryCode in Vendor/VendorLocation | Category Code | |
| 4 | 12-80 | Alpha/numeric (69) | Reserve | Blank |
Total record - Record Type 9
The trailer record is created once per Cash Code, Pay Group, Payment Code.
| Number | Position | Data type/size | Field | Description | Instructions | Notes |
|---|---|---|---|---|---|---|
| 1 | 1-1 | Record Type | 9 | Total Record | ||
| 2 | 2-9 | Electronic Transfer ID Number | ElectronicTransferID in PayablesElectronicTransferID table. | Sender Bank account number. Right aligned, zero filled | ||
| 3 | 10-21 | Total SEK Amount | Calculated Total PayablesInvoicePayment.NetPaymentAmount | Total Amount SEK. Possibly zeros. Right aligned, zero filled | ||
| 4 | 22-27 | Reserve | Blank | Reserved. Use according to the bank’s instructions | ||
| 5 | 28-31 | Blank | Blank | Blank | ||
| 6 | 32-43 | Blank | Blank | Blank | ||
| 7 | 44-55 | Blank | Blank | Blank | ||
| 8 | 56-63 | Blank | Blank | Blank | ||
| 9 | 64-78 | Total Amount | Calculated | Total invoice amount in foreign currency, total nonsense. Right aligned, zero filled | ||
| 10 | 79-80 | Blank | Blank | Blank |