Transactions which have been paid-out as part of the payout run in the PayoutSummary fileTransaction level detail file for customer payments, from all payout runs in the PayoutSummary file which has happened yesterday. Transactions are paid out on a different date to the original transaction date. One customer may have multiple transactions recorded in a single day. This file will remain blank if there is no payout which has taken place yesterday.
Field Name | Data Type | Field Description | Format/ Possible Field Values | |
|---|---|---|---|---|
| 1 | RunDate | date | Date of data extraction | YYYY-MM-DD |
| 2 | BusinessName | varchar(50) | Trading name of the business | |
| 3 | BusinessAccount | varchar(50) | Business account name | |
| 4 | ContractPrefix | char(6) | Contract Prefix associated with the business account | |
| 5 | CustomerID | varchar(50) | Customer account identifier from the external provider | |
| 6 | AccountGuid | varchar(40) | Unique reference/ identifier for the account provided by Debitsuccess | |
| 7 | CustomerFirstName | varchar(40) | Customer's first name | |
| 8 | CustomerLastName | varchar(40) | Customer's last name | |
| 9 | DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
| 10 | DocketNo | numeric(10, 0) | Unique Debitsuccess reference/ identifier for a collection attempt from a customer | |
| 11 | TransactionGuid | varchar(40) | Unique Debitsuccess reference/ identifier for a transaction that aligns to client payout | |
| 12 | Amount | numeric(8, 2) | Transaction amount | |
| 13 | TransDate | datetime | Transaction date | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 14 | TransType | char(1) | Indicator field to differentiate between receipt (+ve amount) and invoice (-ve amount) | Refer to description in Trans Type |
| 15 | PaymentTransactionCode | char(2) | Transaction type | Refer to description in Payment Transaction |
| 16 | PaymentMethodCode | char(2) | Mode of payment for the transaction | Refer to description in Payment Method |
| 17 | ReversalReasonCode | char(2) | Reversed payment reason | Refer to description in Reversal Reason |
| 18 | IncomeDesc | varchar(500) | Indicator field to differentiate a transaction amount between Debitsuccess or Client Revenue | Debitsuccess Revenue, Facility Revenue |
| 19 | PayoutDate | datetime | Timestamp of payout run | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 20 | PayoutBatchID | int | Unique reference/identified for a payout run | |
| 21 | Commission | numeric(19, 2) | Amount of commission charged by Debitsuccess | |
| 22 | CurrencyCode | varchar(200) | Currency code |