Food Panda
Below is a list of where data are stored in VAL.
Name | Table Name | Solution |
|---|---|---|
Receipt Payments | Raw: Receipt Payments | Food Panda | Revenue Reconciliation |
Payment Advice | Raw: Receipt Payments | Food Panda | 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 | Food Panda | This query provides the transaction for a selected date range | Raw: Receipt Payments | Food Panda |
Adjustments - [Date Range] | Raw | Receipt Payments | Food Panda | This query provides the service recovery and wastage reimbursement transaction for a selected date range | Raw: Receipt Payments | Food Panda |
Campaign - [Date Range] | Raw | Receipt Payments | Food Panda | This query provides the marketing campaign transaction for a selected date range | Raw: Receipt Payments | Food Panda |
Other Fees - [Date Range] | Raw | Receipt Payments | Food Panda | This query provides the other fees transaction for a selected date range | Raw: Receipt Payments | Food Panda |
Raw | Payment Advice | Food Panda - [Date Range] | This query provides the payment transaction for a selected date range | Raw Payment Advice Food Panda |
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 02_Food Panda | Revenue Reconciliation |
Where and how to download
- Download transactions from: Invoices > Invoices > Bulk Download > Select all outlets > Select Month > Click Apply > Click All
Filename convention
YYYYMMDD_xxx.xls
Upload location
To be uploaded into VAL Drive -> RevRec -> 02_FoodPanda
Other notes
Not available
Where and how to download (Payment Advice)
- Download Payment Advice PDF from: Invoices > Payment Advice > Select all outlets > Select Month > Click Apply > Click All
Filename convention
PDF files starts with “PAYADV_”
PAYADV_YYYYMMDD_xxx.pdf
Upload location
To be uploaded into VAL Drive -> RevRec -> 02_FoodPanda
Other notes
Not available
