PayoutTransactions

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

	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