Transactions that have been paid-out as part of the payout run Transaction level detail file for customer payments, from all payout runs in the PayoutSummary file.
Field Name | Data Type | Field Description | Format/ Possible Field Values |
|---|---|---|---|
RunDate | date | Date of data extraction | YYYY-MM-DD |
BusinessID | varchar(50) | Account level unique identifier from the external provider | |
BusinessName | varchar(50) | Trading name of the business | |
BusinessAccount | varchar(50) | Business account name | |
ContractPrefix | char(6) | Contract Prefix associated to the business account | |
CustomerFirstName | varchar(40) | Customer's first name | |
CustomerLastName | varchar(40) | Customer's last name | |
DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
DocketNo | numeric(10, 0) | Unique Debitsuccess reference/ identifier for a collection attempt from a customer | |
TransactionGuid | uniqueidentifier | Unique Debitsuccess reference/ identifier for a transaction that aligns to client payout | |
Amount | numeric(8, 2) | Transaction amount | |
TransDate | datetime | Transaction date | YYYY-MM-DD HH:MM:SS [fractional seconds] |
TransType | char(1) | Indicator field to differentiate between receipt (+ve amount) and invoice (-ve amount) | |
PaymentTransaction | Transaction type | ||
PaymentMethod | Mode of payment for the transaction | ||
Particulars | |||
IncomeDesc | |||
PayoutDate | |||
PayoutBatchID |
...