| CustomerID |
Deposit, Withdrawal, Activity, Adjustment, Correction |
Consumer ID |
Yes |
|
| DepositMethod |
Deposit |
Deposit Method |
Yes |
Deposit Method should be one matching the available methods in DIM. The link to the methods can be found in the Deposit/Withdrawal Methods Tab.
If the value in the CSV does not match we will default to ‘Other’ |
| Deposits |
Deposit |
Deposit Amount |
Yes |
If the transaction id already exists and the transaction is a deposit and the deposit amount is not provided ie 0 then this is considered as an Adjustment Type Chargeback |
| DepositFee |
Deposit |
Deposit Fee |
No |
|
| WithdrawalMethod |
Withdrawal |
Withdrawal Method |
Yes |
Withdrawal Method should be one matching the available methods in DIM. The link to the methods can be found in the Deposit/Withdrawal Methods Tab.
If the value in the CSV does not match we will default to ‘Other’ |
| Withdrawals |
Withdrawal |
Withdrawal Amount |
Yes |
|
| WithdrawalFee |
Withdrawal |
Withdrawal Fee |
No |
|
| Turnover |
Activity, Correction, Adjustment |
Wager |
Yes |
If the transaction id already exists and the transaction is an activity and the Turnover is not provided ie 0 and GrossRevenue is not provided ie 0 and Bonus is not provided ie 0 then this is considered as an Adjustment Type BetVoid
If the transaction id already exists and the transaction is an activity and the Turnover is provided ie not 0 or the GrossRevenue is provided ie not 0 or the Bonus is provided ie not 0 then this is considered as an Correction |
| GrossRevenue |
Activity, Correction, Adjustment |
Gross Gaming Revenue |
Yes |
If the transaction id already exists and the transaction is an activity and the Turnover is not provided ie 0 and GrossRevenue is not provided ie 0 and Bonus is not provided ie 0 then this is considered as an Adjustment Type BetVoid
If the transaction id already exists and the transaction is an activity and the Turnover is provided ie not 0 or the GrossRevenue is provided ie not 0 or the Bonus is provided ie not 0 then this is considered as an Correction
|
| Bonus |
Activity, Correction, Adjustment |
Bonus |
Yes |
If the transaction id already exists and the transaction is an activity and the Turnover is not provided ie 0 and GrossRevenue is not provided ie 0 and Bonus is not provided ie 0 then this is considered as an Adjustment Type BetVoid
If the transaction id already exists and the transaction is an activity and the Turnover is provided ie not 0 or the GrossRevenue is provided ie not 0 or the Bonus is provided ie not 0 then this is considered as an Correction |
| ProductID |
Activity |
Product ID |
Yes |
|
| SubProductID |
Activity |
Sub Product ID |
No |
|
| BrandID |
Deposit, Withdrawal, Activity, Adjustment, Correction, Adjustment |
Brand ID |
Yes |
|
| CustomerSourceID |
Activity |
Source |
No |
|
| SourceURL |
Activity |
Source URL |
No |
|
| TransactionID |
Deposit, Withdrawal, Activity, Correction, Adjustment |
Transaction ID |
Yes |
|
| ConsumerCurrencyID |
Deposit, Withdrawal, Correction |
Consumer Currency ID |
Yes |
If this is not provided we will take the default Currency Id from PMP |
| ActivityDate |
Deposit, Withdrawal, Activity, Adjustment, Correction, Adjustment |
Timestamp |
Yes |
|