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.
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 |