Regular Transactions Schema for Egress

Schema

FieldTypeOptionalDescription
seriesIdStringNoThe ID of the regular transaction series.
accountIdStringNoThe ID of the account the transactions belong to.
typeStringNoWhether the series contains income or payment transactions (one of: payment, income).
descriptionStringNoThe full description of the latest transaction in the series.
l3CounterpartyCounterpartyYesThe L3 counterparty of the latest transaction in the series. See Counterparty Schema.
frequencyStringNoThe frequency at which transactions occur in the series (one of: weekly, fortnightly, monthly, quarterly, yearly).
numberOfTransactionsIntegerNoThe number of transactions contained in the series.
numberOfReturnedTransactionsIntegerYesThe number of returned transactions (reversed or declined) contained in the series.
gapLengthIntegerYesIf the series contains a gap, the number of whole frequency units that are missing.
latestDateStringNoThe date of the latest transaction in the series.
predictedDateStringNoThe predicted date of the next transaction in the series.
predictedDateEarliestStringYesThe earliest predicted date at which the next transaction could occur in the series.
predictedDateLatestStringYesThe latest predicted date at which the next transaction could occur in the series.
isOverdueBooleanYesWhether the next predicted transaction is overdue.
predictedAmountAmountNoThe predicted amount of the next transaction in the series. See Amount Schema
predictedAmountLowerAmountYesThe lower bound of the amount predicted for the next transaction in the series. See Amount Schema
predictedAmountUpperAmountYesThe upper bound of the amount predicted for the next transaction in the series. See Amount Schema
predictedL2CategoryCategoryNoThe predicted category data for the next transaction in the series. See Category Schema.
transactionIdsArray<string>NoThe transaction IDs that make up the series.

Example

{
    "seriesId": "",
    "accountId": "",
    "type": "",
    "description": "skytv spt 79328525332",
    "l3Counterparty": {
        "l3CounterpartyId": "63ff776c-8de6-4d0e-8578-c441958b2867"
    },
    "frequency": "monthly",
    "numberOfTransactions": 6,
    "numberOfReturnedTransactions": 0,
    "gapLength": 0,
    "latestDate": "1970-01-01",
    "predictedDate": "1970-01-01",
    "predictedDateEarliest": "1970-01-01",
    "predictedDateLatest": "1970-01-01",
    "isOverdue": "TRUE",
    "predictedAmount": {
        "value": 3500,
        "currency": "GBP"
    },
    "predictedAmountLower": {
        "value": 3500,
        "currency": "GBP"
    },
    "predictedAmountUpper": {
        "value": 3500,
        "currency": "GBP"
    },
    "l2Category": {
        "l1CategoryId": "std:32746",
    },
    "transactionIds": [
        "e30f5e82-5c74-4adb-8a62-a0b488beef80",
        "2f9ad784-c1f7-47ea-87c0-aedd8c7d3945",
        "9874734b-a09a-4852-8755-57e1cc0b4326",
        "471813e1-1269-4341-91e6-37642b10fb12",
        "d928568c-8af8-44b4-b632-bd1d0d552e16",
        "03c80cb3-81e8-4ece-8c89-7e7f757802aa"
    ]
}
{
    "seriesId": "",
    "accountId": "",
    "type": "",
    "description": "skytv spt 79328525332",
    "l3Counterparty": {
        "l3CounterpartyId": "63ff776c-8de6-4d0e-8578-c441958b2867",
        "l3CounterpartyName": "Sky Sports",
        "parentId": "b3e0c142-1377-4e7d-b434-37b64d34a008",
        "parentName": "Sky Entertainment",
        "fullCompanyName": "Sky Entertainment Limited",
        "logoUrl": "examplelogo.com",
        "website": "example.com",
        "registeredLocation": null,
        "l2CategoryName": "Entertainment",
        "l3CounterpartyCategory": "Subscription",
        "l4LoanType": null
    },
    "frequency": "monthly",
    "numberOfTransactions": 6,
    "numberOfReturnedTransactions": 0,
    "gapLength": 0,
    "latestDate": "1970-01-01",
    "predictedDate": "1970-01-01",
    "predictedDateEarliest": "1970-01-01",
    "predictedDateLatest": "1970-01-01",
    "isOverdue": "TRUE",
    "predictedAmount": {
        "value": 3500,
        "currency": "GBP"
    },
    "predictedAmountLower": {
        "value": 3500,
        "currency": "GBP"
    },
    "predictedAmountUpper": {
        "value": 3500,
        "currency": "GBP"
    },
    "l2Category": {
        "l1CategoryId": "std:32746",
        "l1CategoryName": "Entertainment",
        "l2CategoryId": "std:26473",
        "l2CategoryName": "Entertainment"
    },
    "transactionIds": [
        "e30f5e82-5c74-4adb-8a62-a0b488beef80",
        "2f9ad784-c1f7-47ea-87c0-aedd8c7d3945",
        "9874734b-a09a-4852-8755-57e1cc0b4326",
        "471813e1-1269-4341-91e6-37642b10fb12",
        "d928568c-8af8-44b4-b632-bd1d0d552e16",
        "03c80cb3-81e8-4ece-8c89-7e7f757802aa"
    ]
}