PGI payment files

Header Record - record Type 0 - Initial 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-6 Alpha/numeric (5) Customer Nbr Cash Payment Format PGD and PGI

ElectronicPaymentOrganizationIdentifier in BankTransactionCode table

Customer number – assigned by bank account
3 7-12 Numeric (6) Production date System Date System Date in AP161 – YYMMDD.

Sender processing date

4 13-13 Alpha/numeric (1) Prod nbr SequenceNumber in PayablesElectronicTransferID 1-9 can be used. On several initial records with the same customer number and production date, the production number must be unique in each initial record. The production unit is perceived otherwise as already loaded.

The SequenceNumber increments by 1 for multiple runs of the same Electronic Payment Creation in the same day. Each new day resets the PayablesElectronicTransferID.SequenceNumber to 1 and PayablesElectronicTransferID.LastRunDate to system date. There is no edits that prevents running Electronic Payment Creation more than 9 times – not required. The Seq Nbr and Run date are only updated on the PayablesElectronicTransferID record that has the same payer acct nbr. Seq Nbr will also get incremented for every payee record type 2 when PaymentForm not = 0.

5 14-100 Alpha/numeric (87) Blank Blank

Header Record - record Type 1 - Sender Record

- The record header contains the records that are created once per cash code, pay group, payment code. Always listed as the first record per customer, account and code. Sender record should always precede a group of the record type 3, 4, 5, 6 and 6.

Number Position Data type/size Field Description Instructions Notes
1 1-1 Alpha/numeric (1) Record Type 1 Sender Record
2 2-6 Alpha/numeric (5) Customer Nbr ElectronicPaymentOrganizationIdentifier in BankTransactionCode table Customer number. Assigned by Bank Account.
3 7-16 Alpha/numeric (10) Sender Account

Electronic Transfer ID Number

ElectronicTransferID in PayablesElectronicTransferID table Right aligned and blank filled. Bank account or currency account
4 17-18 Alpha/numeric (2) Sender code Space Determined by the sender. Alphanumeric or blank. An account can have multiple sender codes to separate account to order the payment and audit report
5 19-45 Alpha/numeric (27)) Sender Line1 Name in PayablesCompany Usually the sender’s address.
6 46-72 Alpha/numeric (27) Sender Line2 PostalAddress.DeliveryAddress.AddressLine1 in PayablesProcessLevel (Address not available for Payables Company) Usually the sender’s address.
7 73-87 Alpha/numeric (15) Sender Line3 PostalAddress.Municipality in PayablesProcessLevel (Address not available for Payables Company) Usually the sender’s location
8 88-88 Alpha/numeric (1) Cross Border Code 2 Cross Border Code = 2
9 89-89 Alpha/numeric (1) Layout Code 2 Layout Code = 2
10 90-90 Alpha/numeric (1) Currency Currency in CashCode table Currency from which payment is made. E= EUR; S=SEK (Not ISO standard due to space restrictions. Position 1 of Cash Code from Electronic Payment Creation
11 91-100 Alpha/numeric (10) ElectronicPaymentUserField1 from BankTransactionCode ElectronicPaymentUserField1 from BankTransactionCode Sender organization number

Payee record - Record Type 2 - Recipient Name Record

The payee records are created once per vendor.

Number Position Data type/size Field Description Instructions Notes
1 1-1 Alpha/numeric (1) Record Type 2 Recipient Record
2 2-2 Alpha/numeric (1) Payment Method PaymentForm on Vendor/VendorLocation

0 = Deposit

9 = Check

Payment method 0 = deposit; 9 = Check Position 1 of Vendor/VendorLocation PaymentForm
3 3-17 Alpha/numeric (15) Recipient ID Payment method = 0

BankAccountNumber Vendor/VendorLocation or Payment method = 9 serial number

Set option, but the current recipient unique, alphanumeric Recipient ID. Right or left aligned and blank filled If PaymentForm = 0 value = BankAccountNumber Else value =PayablesElectronicTransferID.SequenceNumber (incremented by 1 from Type 1 record)
4 18-22 Alpha/numeric (5) Blank Blank
5 23-23 Alpha/numeric (1) Recipient Code Priority Code

Payment method = 0 (1 or 2)

Payment method = 9 (1)

The Deposit shall apply: 1 Normal, 2 Express

The check is always 1 Normal

If PaymentForm= 9 and NormalOrExpressCode = E value =2
6 24-56 Alpha/numeric (33) Recipient Line1 Payment method = 0

BankAccountNumber Vendor/VendorLocation (IBAN nbr) or Payment method = 9 VendorName Vendor/VendorLocation

At Deposit: Enter the recipient’s account number. If possible, in the IBAN format. At Check: Enter the recipient’s name If PaymentForm not = 9 value = Vendor/VendorLocation BankAccountNumber else Value = Vendor/VendorLocation VendorName
7 57-89 Alpha/numeric (33) Recipient Line2 Payment method = 0 VendorName Vendor/VendorLocation or payment method = 9 PostalAddress.DeliveryAddress.AddressLine1 in VendorAddress At Deposit: Enter the recipient’s name If PaymentForm not = 9 Value = Vendor/VendorLocation VendorName else value = VendorAddress.PostalAddress.DeliveryAddress.AddressLine1
8 90-92 Alpha/numeric (3) Payment Category PaymentCategoryCode in Vendor/VendorLocation Payment code according to the Swedish tax office applies to subsequent payment to the same recipient unless the code is not different that the code referred to on the amount records. Is entered in the record amount. Not required for payment code indicated in amount records.
9 93-100 Alpha/numeric (8) Blank Space Blank

Payee record - Record Type 3 - Recipient Address Record

The payee records are created once per vendor.

Number Position Data type/size Field Description Instructions Notes
1 1-1 Alpha/numeric (1) Record Type 3 Recipient Address Record
2 2-2 Alpha/numeric (1) Payment Method Payment method Same as record type 2, position 2
3 3-17 Alpha/numeric (15) Recipient ID Payment method = 0 BankAccountNumber Vendor/VendorLocation Payment method = 9 serial number Same record type as 2, position 3-17 If PaymentForm = 0 value = BankAccountNumber Else value = PayablesElectronicTransferID.SequenceNumber (incremented by 1 from Type 1 record)
4 18-50 Alpha/numeric (33) Recipient Line3 Payment method = 0

Vendor/VendorLocation Bank Code, Bank ID.

Sweden Plusgiro In Sort Codes

Payment method = 9

The payment method 9, check, specific recipient;s address. For recipients in Europe the IBAN is referenced in record type 2, position 24-56. This field shouldn’t be left blank. For certain countries outside Euripe a special code is needed. Australia: The code is called BSB (Bank/State/Branch) and has 6 digits. On the invoice often states the branch 123-456. The payment assignment recorded in the field for bank account code as //AU123456

Canada: The code is called Payment Routing Number and consists of 9 digits and always starts with 0. Register as //CC012345678

South Africa: The code is called sort code and has 6 digits. There are sometimes 8 digits, even then, only the first 6 are used. Register as //ZA123456

USA: The code is called Fedwire Routing Number (Alt ABA) and consists of 9 digits. Register as //FW123456789

If PMT-FORM = 0 value = 11, Bank Code, Bank ID (No commas)
5 51-72 Alpha/numeric (22) Recipient Location City Payment method = 0 Bank Location on screen AP16 (CBE) or Payment method =9 Town in VendorAddress The Deposit: Enter the receiving bank location

The Check: Enter the recipient’s location

If = value = BankEntity.PostalAddres.Municipality

Else value = VendorAddress.PostalAddress.Municipality

6 73-82 Alpha/numeric (10) Recipient Record Postal Code Payment method = 0 Bank Postal Code from Bank Entity or Payment method =9 Postal Code in VendorAddress Alphanumeric, right or left aligned and blank filled If 0 value = BankEntity.PostalAddres.PostalCode else Value = VendorAddress.PostalAddress.PostalCode
7 83-84 Alpha/numeric (2) Recipients Country BankEntity Bank Country code ISO standard. The country that the money will be sent. It need not be the same country as the recipient lives in. If PaymentForm = 0 and BankEntity.PostalAddress.Country = spaces value = VendorAddress.PostalAddress.Country

If PaymentForm = 0 and BankEntity.PostalAddress.Country not = spaces value = VendorAddress.PostalAddress.Country

If PaymentForm not = 0 value = VendorAddress.PostalAddress.Country

8 85-97 Alpha/numeric (13) Internal reference PayablesInvoice.VoucherNumber The sender’s internal reference
9 98-100 Alpha/numeric (3) Blank Blank

Payment record - Record Type 5 - Message record – Debit Amount record

Created only for debit amount payments and messages up to 4 message records can be created. 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 Debit Amount Record
2 2-2 Alpha/numeric (1) Payment Method Payment Method Same as record type 2, position 2
3 3-17 Alpha/numeric (15) Recipient ID Payment method = 0

BankAccountNumber Vendor/VendorLocation or payment method =9 serial number

Same as record type 2, positions 3-17
4 18-50 Alpha/numeric (33) Message Payment method = 0

Line 1 = BIC Code/Swiftnr

Line 2 = Invoice Number

Line 3 = OUR on Charge Code =0

Line 4 = Comments or Payment method =9

Line 1 = Invoice in Payables Invoice

Line 2 = OUR on charge Code =0 in Vendor/VendorLocation

Lines 3 and 4 = Comments

Message to the payment recipient. If additional space is needed for the message, as long as the debit amount record is not repeated more than 3 times per payment without any further information, ie blank in position 51-2100. Message Records precede amount records. OUR in this field indicates that the recipient’s expenses are paid by the sender. If not specified, each pays their own expenses. If PaymentForm = 0 value = Vendor/VendorLocation SwiftId

If Vendor/VendorLocation ChargeCode = 0 value = “:OUR”

If API comments value comment text

If payment value = PayablesInvoice.Invoice

5 51-52 Alpha/numeric (2) Blank Comment in PayablesInvoice Blank
6 53-63 Numeric (11) SEK Amount

Amount in SEK or EURO

NetPaymentAmount in PayblesInvoicePayment Amount in Base/Co currency (including penny/cent, currency is currently SEK or EUR)

Right aligned and zero filled without signs or decimal points (Positions 87-89)

7 64-69 Numeric (6) Due Date Check Date /Due Date YYMMDD. The day the sender’s account will be charged. If PayablesInvoicePayment.DueDate < Electronic Payment Creation Payment Date value = Electronic Payment Creation Payment Date

Else value = PayablesInvoicePayment.DueDate

8 70-71 Alpha/numeric (2) Blank Blank
9 72-86 Numeric (15) Amount Zero/Invoice NetPaymentAmount in PayablesInvoicePayment Amount in currency other than the base/co. Entered with decimal places, but without signs and decimal points. Right-aligned and zero filled. If the invoice amount is in currency other than the base/co state it here, otherwise zero filled. The amount is dispensed in the currency specified in the Currency Code field below. If PayablesInvoicePayment.InvoiceCurrency = SEK value = 0 else value = NetPaymentAmount
10 87-89 Alpha/numeric (3) Currency Code InvoiceCurrency in PayablesInvoicePayment ISO standard. Currency in which payment is to be dispensed in
11 90-90 Alpha/numeric (1) Amount Code 1 or NOTE! Specifies the amount for the basis for the payment.

1= If the amount is in another currency than the base/co currency specified.

2= If only the amount of base/co currency specified

If PayablesInvoicePayment.InvoiceCurrency = SEK value = 2 else value =1
12 91-91 Alpha/numeric (1) Merging BankTransactionCode.SortOption Payment in the same currency and with the same accounting date to the same recipient can be combined into one payment.

1= no merging. Each payment is sent separately.

2= merging of all methods of payment. Intermediate specified.

13 92-94 Alpha/numeric (3) Payment Category PaymentCategoryCode in Vendor/VendorLocation Indicated if different from payment code in record type 2, otherwise blank. If a payment includes installments with different payment codes these would be reported separately
14 95-100 Alpha/numeric (6) Blank Space Blank

Payment record - Record Type 6 - Amount record - credit

Created for credit memos only. No Record type 5 messages created for credit memos. 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 Amounts record, credit
2 2-2 Alpha/numeric (1) Payment Method Vendor/VendorLocationPayment Form Must be the same as in the debit record as the credit note will be deducted against
3 3-17 Alpha/numeric (15) Recipient ID Payment Method = 0

BankAccountNumber Vendor/VendorLocation or Payment method = 9 serial number

Must be the same as in the debit record as the credit note will be deducted against
4 18-50 Alpha/numeric (33) Message Invoice in PayablesInvoice Messages to the payee
5 51-52 Alpha/numeric (2) Blank Blank
6 53-63 Numeric (11) SEK Amount NetPaymentAmount in PayablesInvoicePayment

SEK/EURO

Amounts in the Base/Co currency (including cents, the currency is currently SEK/EUR). Right aligned and zero filled without signs or decimal points. Stated in the same way as the debit record as credit note is deducted against.
7 64-69 Numeric (6) Accounting Date Check Date/Due Date First accounting date (YYMMDD). Earliest date of that the settlement of credit note may take place. Same as debit record
8 70-75 Numeric (6) Last Accounting Date Check Date + 340 days The last accounting date (YYMMDD). The last date for settlement of the credit note can take place. First accounting date should be at least + 10 days. Payment Date /Due Date + 340 days
9 76-77 Alpha/numeric (2) Blank Blank
10 78-92 Numeric (15) Amount NetPaymentAmount in PayablesInvoicePayment Amount in currency other than the base.co. Right aligned and zero filled without signs or decimal point. Displayed in the same way for the debit records.
11 93-95 Alpha/numeric (3) Currency Code InvoiceCurrency In PayablesInvoicePayment Must be the same for the debit record as for the credit note in order to deduct the credit. ISO standard
12 96-96 Alpha/numeric (1) Amount Code 2 if InvCurrency = SEK otherwise 1 The same for the debit record as the credit note to offset. Specifies the amount of base for the payment.

1= If the amount is in another currency than the Base/Co.

2= If only the amount of currency out of Base/Co

13 97-99 Alpha/numeric (3) Payment Category Invoice Payment Category Payment Code
14 100-100 Alpha/numeric (1) Blank Space Blank

Total Record - Record Type 7

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 Alpha/numeric (1) Record Type 7 Total Record
2 2-6 Alpha/numeric (5) Customer Nbr ElectronicPaymentOrganizationIdentifier in BankTransactionCode table Same as record type 0
3 7-16 Alpha/numeric (10) Sender Account

Electronic Transfer ID Nbr

ElectronicTransferID in PayablesElectronicTransferID table Same as record type 1
4 17-18 Alpha/numeric (2) Sender Code Space Determined by the sender. An account can have multiple sender codes to have separate account in the accounting payment orders and audit report. Not required
5 19-19 Alpha/numeric (1) Currency Code Currency in CashCode table Currency base/co from which payment is made.

E=EUR

S=SEK

Cash Code from ElectronicPaymentCreation
6 20-20 Alpha/numeric (1) Blank Blank
7 21-33 Numeric (13) Total Amt Calculated Total amount in base/Co currency. Net amounts, ie debits summed as positive and credits as negative. Indicated by signs (+or-) in position 33. Zero filled if position 80 is blank. Total NetPaymentAmount

If Total NetPaymentAmount < 0 value = “-“ else value = “+”

8 34-35 Alpha/numeric (2) Blank Blank Blank If Total NetPaymentAmount < 0 value = “-“ else value = “+”
9 36-52 Numeric (17) Nonsense Total Blank Total Nonsense in currencies other than Base/Co. Net summary of all amounts regardless of currency. Indicated by signs (+ or -) in position 52. Zero filled if position 80 is blank
10 53-89 Alpha/numeric (27) Blank Blank Blank
11 80-80 Alpha/numeric (1) Payment Execution 1 1 = The payments are implemented
12 81-87 Numeric (7) Number of Records Calculated Number of records, excluding the initial record. Right aligned and zero filled.
13 88-88 Alpha/numeric (1) Cross Border Code 2 Cross Border Code = 2
14 89-100 Alpha/numeric (12) Blank Blank