JSON Format Rejects file
Data Items
The Simple JSON formatted rejects files is a standard JSON (JavaScript Object Notation) formatted file. Data items are descibed below.
| 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":"e6462e0c-a614-42b4-9347-aa2fa5e32499",
"fileNumber":1,
"recordNumber":1,
"paygateId":"f5320035-6da8-4712-95a4-bcb8af53a509",
"thirdPartyAccountName":"MISS R AAAAAA",
"thirdPartyAccountNumber":"11111116",
"thirdPartySortCode":"300000",
"thirdPartyAccountType":"0",
"transactionCode":"99",
"freeFormat":"0000",
"amount":1427.28,
"userReference":"PAYE 1",
"originatorAccountName":"GRANITE BANK",
"originatorAccountNumber":"11611488",
"originatorSortCode":"404113",
"processingDate":"",
"removalReason":"The payment amount £1,427.28 exceeds the group Payment Limit of £1,000.00.",
"messageSeverity":"Fix",
"messageSeverityValue":3,
"amountText":"1,427.28"
}
]