AMEX
Below is a list of where data are stored in VAL.
Name | Table Name | Solution |
|---|---|---|
Receipt Payments | Raw: Receipt Payments | Amex | Revenue Reconciliation |
In our list of queries, you can identify transactions for specific time periods
Query Name | Description | Table |
|---|---|---|
Orders - [Date Range] | Raw | Receipt Payments | AMEX | This query provides the transaction for a selected date range | Raw Receipt Payments AMEX |
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 14_Banks Payment AMEX | Revenue Reconciliation |
Please ensure that the file downloaded and file naming convention is correct
Where and how to download
- Download from: Payments > Transactions > All Merchant IDs > Select date range > Format=XLS > Currency Symbols=No
Filename convention
Ensure file name follows the convention Transactions_search_resultsMMDDYYYY_xxxxxx.xls
Filenames: Starts with Transactions_search_results
Upload location
To be uploaded into VAL Drive -> RevRec -> 01_SourceReports
Not sure where VAL Drive is?
You can find the instructions on how to upload report into VAL Drive at VDrive
Other notes
Not available
