CSV
Purpose
Paygate can automatically remove errors in submission files during the pre-submission validation stage. You can export lines that have been removed from a submission file in a CSV formayed file.
This page describes the format of the CSV file.
General
Header: Yes Delimited: comma Line Delimiter: Windows style CRLF
Header
submissionId,fileNumber,recordNumber,paygateId,thirdPartyAccountName,thirdPartyAccountNumber,thirdPartySortCode,thirdPartyAccountType,transactionCode,freeFormat,amount,userReference,originatorAccountName,originatorAccountNumber,originatorSortCode,processingDate,removalReason,messageSeverity,messageSeverityValue,amountText
Column Format
| Name | Description | Type | Format | Notes |
|---|---|---|---|---|
| submissionId | Submission ID | UUID | 36a | The unique ID of the submission assigned by Paygate |
| fileNumber | File Number | Int | 4n | The number of the block or file within the submission |
| recordNumber | Record Number | Int | 7n | The record number within the file |
| paygateId | Paygate ID | UUID | 36a | A unique ID the represents the customer |
| thirdPartyAccountName | Third Party Account Name | String | 18a | |
| thirdPartyAccountNumber | Third Party Account Number | String | 8n | 11223344 |
| thirdPartySortCode | Third Party Sort Code | String | 6n | 112233 |
| thirdPartyAccountType | Third Party Account Type | Int | 1n | 0 |
| transactionCode | Transaction Code | String | 2a | The BACS Transaction code: 99, 17, etc |
| freeFormat | Free Format | String | 4a | Usually 0000 or space filled. |
| amount | Amount | Number | Decimal amount of the transaction | |
| userReference | Service User Reference | String | 18a | |
| originatorAccountName | Originator Account Name | String | 18a | |
| originatorAccountNumber | Originator Account Number | String | 8a | |
| originatorSortCode | Originator SortCode | String | 6a | |
| processingDate | Processing Date | String | Optional | |
| removalReason | Removal Reason | String | 1024a | The message created by the validation engine provided the removal reason |
| messageSeverity | Message Severity | String | 8a | The validation engine severity level. Fix, Warning |
| messageSeverityValue | Message Severity Value | Int | ||
| amountText | Amount Text | String | 64a | Can be ignored |