CSV Format Rejects file

Data Items

The CSV rejects file format is CSV (Comma Separated values). The first row contains column headers. These headers are described in the table below.

Column Name Title Description Format Example
submissionId Submission Id A unique reference that paygate gives to the submission UUID/V4 ff918652-bf64-4b6b-a905-5795c32234c2
fileNumber File Number In a single file submission will be 1, otherwise the number of the file within the submission: 1,2,3…n Integer 1
recordNumber Record Number The record number within a particular file. Starts at 1 and increases by 1 for each record. Integer 1, 56, 20034
paygateId paygate Id An id that identifies each paygate customer. UUID/V4 f5320035-6da8-4712-95a4-bcb8af53a509
thirdPartyAccountName Third-Party Account Name A BACS record - the Account Name of the third party in the transaction 18c BOBS Bearings
thirdPartyAccountNumber Third-Party Account Number A BACS record - the Account Number of the third party in the transaction 8n 12345678
thirdPartySortCode Third-Party Sort Code A BACS record - the Sort code of the third party in the transaction 6n 123456
thirdPartyAccountType Third Party Account Type A BACS record - the Account Type of the third party in the transaction 1n 1
transactionCode Transaction Code A BACS record - transaction code that identifies the type of transactions, credit, debit, etc 2c 99, 17, 1C
freeFormat Free Format A free format field that is often used for RTI data in payroll submissions 4c 0000, /YU4
amount Amount The amount of the transaction in UK pounds and pence. Decimal 1234.56
userReference User Reference A BACS record - the Service User Reference used in the transaction 18c
originatorAccountName Originator Account Name A BACS record - the Account Name of the originating party in the transaction 18c
originatorAccountNumber Originator Account Number A BACS record - the Account Number of the originating party in the transaction 8n 12345678
originatorSortCode Originator Sort Code A BACS record - the Sort code of the originating party in the transaction 6n 123456
processingDate Processing Date The requested BACS processing date of the transaction
removalReason Removal Reason A textual description of why the transaction was removed from the submission 1024c
messageSeverity Message Severity Indicates the severity of the issued that cause the transaction to be removed from the transaction 50c Info, Fix, Warning, Duplicate
messageSeverityValue Message Severity Value Same as ‘Message Severity’ but an integer amount is used to signify the severity Integer 0 (Info), 1 (Duplicate), 2 (Warning), 3 (Fix)
amountText Amount Text Extra formatting added to the amount field. 512c “1,234.56” “99.99” “1,234,567.89”

Example

submissionId,fileNumber,recordNumber,paygateId,thirdPartyAccountName,thirdPartyAccountNumber,thirdPartySortCode,thirdPartyAccountType,transactionCode,freeFormat,amount,userReference,originatorAccountName,originatorAccountNumber,originatorSortCode,processingDate,removalReason,messageSeverity,messageSeverityValue,amountText ff918652-bf64-4b6b-a905-5795c32234c2,1,1,f5320035-6da8-4712-95a4-bcb8af53a509,MISS R AAAAAA,11111116,300000,0,99,0000,1427.28,PAYE 1,GRANITE BANK,11111111,111111,,"The payment amount £1,427.28 exceeds the group Payment Limit of £1,000.00.",Fix,3,"1,427.28"