PayoutSummary

Summary of client’s payout run from yesterday. There may be more than one payout run per day but the PayoutBatchID is unique for each run. 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	ContractPrefix	char(6)	Contract Prefix associated with the business account
3	PayoutDate	datetime	Timestamp of payout run	YYYY-MM-DD HH:MM:SS [fractional seconds]
4	PayoutBatchID	int	Unique reference/identified for a payout run
5	BusinessGuid	varchar(40)	Unique reference/ identifier for the business provided by Debitsuccess
6	GymID	varchar(15)	Unique reference/ identifier for the gym (business)
7	BusinessName	varchar(50)	Trading name of the business
8	BusinessAccount	varchar(50)	Business account name
9	PaymentMethodCode	varchar(2)	Mode of payment for the transaction	Refer to description in Payment Method
10	FacilityGrossAmount	money	Total amount of payments collected by Debitsuccess less rebate fees, penalty fees, establishment fees, other fees, variation fees, debt miscellaneous fees and debt recall fees
11	Commission	money	Total amount deducted by Debitsuccess for our service
12	PaidToClub	money	Total Amount of payment paid directly to business
13	FacilityPaysAdminFee	money	Amount of administration fee charged by Debitsuccess which is paid by business rather than customer
14	DeductionsAmount	money	Total deductions taken at payout
15	FacilityShareOfAdminFees	money	Total amount of establishment fees paid to the business
16	DistributionAmount	money	Net payable amount to the business
17	Chargetype	int	Commission charge type	Refer to description in Charge Type
18	ChargeRate	numeric(8, 4)	Commission charge rate based on the charge type
19	TransCount	int	Total number of transactions per payment type
20	CurrencyCode	varchar(200)	Currency code
21	ServiceFeeDeductions	numeric(16,2)	Fee charged back to the Facility to be paid by the Facility (Note: This is when a facility chooses to charge back the fee, Debitsuccess won't charge back fees without authority)
22	ServiceFeeTrans	money	Fee charged to the Facility when a Default Fee is collected by Debitsuccess from the member
23	FacilityDefaultFees	money	Fee collected from member for unsuccessful transactions. This fee is collected on behalf of the facility.