Deliveroo
Below is a list of where data are stored in VAL.
Name | Table Name | Solution |
|---|---|---|
Receipt Payments | Raw: Receipt Payments | Deliveroo | Revenue Reconciliation |
In our list of queries, you can identify everything from disputes, refunds, marketing campaign, transactions and fees.
Query Name | Description | Table |
|---|---|---|
Orders - [Date Range] | Raw | Receipt Payments | Deliveroo | This query provides the transaction for a selected date range | Raw: Receipt Payments | Deliveroo |
Adjustments - [Date Range] | Raw | Receipt Payments | Deliveroo | This query provides the service recovery and wastage reimbursement transaction for a selected date range | Raw: Receipt Payments | Deliveroo |
Campaign - [Date Range] | Raw | Receipt Payments | Deliveroo | This query provides the marketing campaign transaction for a selected date range | Raw: Receipt Payments | Deliveroo |
Other Fees - [Date Range] | Raw | Receipt Payments | Deliveroo | This query provides the other fees transaction for a selected date range | Raw: Receipt Payments | Deliveroo |
Below is a list of workflow to trigger for performing various automation in VAL.
Description | Workflow Name | Solution |
|---|---|---|
Trigger upload of receipt payments into VAL | VD-RR 01_Source Reports 12_Market Place Deliveroo | Revenue Reconciliation |
Where and how to download
- Download from: Invoices > Click on All documents button to download 1 single zip file for all brands for last week
Filename convention
Ensure file name follows the convention all_companies_xxx.zip
Note: no need to change the file names, just upload the whole zipped file
Upload location
To be uploaded into VAL Drive -> RevRec -> 01_SourceReports
Other notes
Not available
