Data Sources
| System Name | Description | Ref | Data Access |
|---|---|---|---|
| SAP | Invoice Lines | Excel | |
| Potential Excel | Excel File containing the sales potentials | Sharepoint | |
| Locus | Warehouse Management System | ||
| Magento 2 | CMS System and Web Shop |
SAP is the corner stone. Locus and Magento 2 are connected:
For this project, we only use SAP and Excel.
Sales Invoice CSV
See
Everything is in EUR.
Some columns that are not self-explaining:
- E: sales region \(r\), according to provinces
- F: article group (item group) → accounting dimension
- J: Division
- K: Posting date of the invoice
- L: amount → can be fractional, because inventory is not always managed correctly
- N: margin of the invoice line, calculated by SAP
- O: turn over per Animal Unit of the specific customer
NOTE: Indufarm is based on Animal Unit.