Grab
Below is a list of where data are stored in VAL.
Name | Table Name | Solution |
|---|---|---|
Receipt Payments | Raw: Receipt Payments | Grab | 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 | Grab | This query provides the transaction for a selected date range | Raw: Receipt Payments | Grab |
Adjustments - [Date Range] | Raw | Receipt Payments | Grab | This query provides the service recovery and wastage reimbursement transaction for a selected date range | Raw: Receipt Payments | Grab |
Campaign - [Date Range] | Raw | Receipt Payments | Grab | This query provides the marketing campaign transaction for a selected date range | Raw: Receipt Payments | Grab |
Orders Not Settled - [Date Range] | Raw | Receipt Payments | Grab | This query provides the transaction for a selected date range with no settlement date. Typically this is due to payables to Grab with insufficient sales to offset the payments. To check in portal for these date range on when the settlement will be done | Raw: Receipt Payments | Grab |
Below is a list of workflow to trigger for performing various automation in VAL.
Name | Workflow Name | Solution |
|---|---|---|
Trigger upload of receipt payments into VAL | VD-RR 01_Source Reports 12_Market Place Grab | Revenue Reconciliation |
Where and how to download (CSV Current Period)
- Download from: Finance > Transactions > Select Date Range > Download.
- For the date range, only download up till yesterday Else, there will be missing transfer date (which is the date that Grab pays to client for the orders)
- Select the option “All transaction details”
Filename convention
Filename starts with Transaction_Store
Transaction_Store_YYYY-MM-DD_to_YYYY-MM-DD_xxx.csv
Upload location
To be uploaded into VAL Drive /RevRec/01_SourceReports/ folder
Other notes
Not available
Where and how to download (Weekly Merchant Report)
For historical more than 2 months ago
- Download from: Finance > Reports > Select Date Range > Download.
Filename convention
Ensure file name follows the convention
Filename starts with GrabMerchant_Reports_
GrabMerchant_Reports_DD-MMM-YYYY_to_DD-MMM-YYYY.xlsx
Upload location
To be uploaded into VAL Drive -> RevRec -> 01_SourceReports
Other notes
Not available
