...
Field Name | Data Type | Field Description | Format/ Possible Field Values |
|---|---|---|---|
RunDate | date | Date of data extraction | YYYY-MM-DD |
ContractPrefix | char(6) | Contract Prefix associated with the business account | |
PayoutDate | datetime | Timestamp of payout run | YYYY-MM-DD HH:MM:SS [fractional seconds] |
PayoutBatchID | int | Unique reference/identified for a payout run | |
BusinessGuiduniqueidentifier | varchar(40) | Unique reference/ identifier for the business provided by Debitsuccess | |
GymID | varchar(15) | Unique reference/ identifier for the gym (business) | |
BusinessName | varchar(50) | Trading name of the business | |
BusinessAccount | varchar(50) | Business account name | |
PaymentMethodCode | varchar(2) | Mode of payment for the transaction | Refer to description in Payment Method |
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 | |
Commission | money | Total amount deducted by Debitsuccess for our service | |
PaidToClub | money | Total Amount of payment paid directly to business | |
FacilityPaysAdminFee | money | Amount of administration fee charged by Debitsuccess which is paid by business rather than customer | |
DeductionsAmount | money | Total deductions taken at payout | |
FacilityShareOfAdminFees | money | Total amount of establishment fees paid to the business | |
DistributionAmount | money | Net payable amount to the business | |
Chargetype | int | Commission charge type | Refer to description in Charge Type |
ChargeRate | numeric(8, 4) | Commission charge rate based on the charge type | |
TransCount | int | Total number of transactions per payment type |
...