Transaction 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 |
BusinessID
varchar(50)
Account level unique identifier from the external provider
| 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 |