AZ Digital
Below is a list of where data are stored in VAL.
Name | Table Name | Solution |
|---|---|---|
Collection Reports | Raw: Collection Reports | AZ Digital | Revenue Reconciliation |
In our list of queries, you can identify [to be populated]
Table | Query Name | Description |
|---|---|---|
Raw: Collection Reports | AZ Digital | Raw | Collection Report | AZ Digital | Orders - [Date Range] | This query provides the transaction for a selected date range
|
Below is a list of workflow to trigger for performing various automation in VAL.
Name | Workflow Name | Solution |
|---|---|---|
Trigger upload of collection reports into VAL | [To be populated] | Revenue Reconciliation |
Where and how to download
- Head to Reports → Payment Reports → Select Summary and Consolidated and Period Type Order Closed
- Save In Excel 2007
- Please help to put the date of extraction, for reference
Filename convention
Ensure file name follows the convention Payment_Consolidate_YYYYMMDD
Upload location
To be uploaded into VAL Drive -> RevRec -> 01_SourceReports
Other notes
Not available
