Table of Contents
Sales Data
- File name: ACDSalesYYYYMM.txt
- File format: comma separated file (csv)
- File contains: Number of products (beer and non-beer) sold. Contains imports and domestic. Must multiply by the size (ml) of the product to obtain the volume sold.
- File frequency:
| Column Name | Column Description | |
|---|---|---|
| 1. | Site (store) | Store location, displayed as key and text. |
| 2. | Article | Product numbers, displayed as NSLC Product number. |
| 3. | EAN/UPS Article Number. | |
| 4. | Total (MTD) | Total sales quantity (Month to date). |
| 5. | Sales (YTD) | Currently not populated (0 default value) |
| 6. | Licensee Sales (MTD) | Counter for sales to customers grouped as ‘licensee’ (Month to date). |
| 7. | Agency Sales (MTD) | Counter for sales to customers grouped as ‘agency’ (Month to date). |
| 8. | General Sales (MTD) | Counter for sales to customers grouped as ‘general’ (Month to date). |
| 9. | Private Wine Specialty Stores Sales (MTD) | Counter for sales to customers grouped as ‘agency’ (Month to date). |
| 10. | Other Sales (MTD) | Counter for sales to customers grouped as ‘other’. Examples of “other” are, Ship Chandler, Hospital, Druggist, Other Liquor Boards…) (Month to date). |
| 11. | Licensee Sales (YTD) | 0 |
| 12. | Agency Sales (YTD) | 0 |
| 13. | General Sales (YTD) | 0 |
| 14. | Private Wine Specialty Stores Sales (YTD) | 0 |
| 15. | Other Sales (YTD) | 0 |
| 16. | Inventory (stores) | Total store On-hand. |
Article (Product) Data
- File name: CR_BRAND.txt
- File format:
- File contains: Contains all products (beer and non-beer).
- File usage: File is used to detect new
- File frequency: one-time. updated manually.
Brand Data
- File name: CR_BRAND.txt
- File format:
- File contains:
- File frequency: one-time
Store Data
- File name: CR_STORE.txt
- File format:
- File contains:
- File frequency: one-time
