# Script that generates SAP Vendor file

## Steps to run
* run the snowflake query and download results as CSV file
* save CSV file in the data/ directory
* in app.ts, you can see how the class is being initialized
  * ```
    const transformer = new TransformerV1({
        queryVersion: '1.0',
        csvFile: 'data/knr-vendors.csv',
        templateVersion: '1.0',
        templateFile: 'vendor-master-template.xlsx'
    });
    ```
* make sure you have access to the AWS Location service
* run the script, `ts-node src/app`

## Versioning
Currently, the template file and the transfomer are set to version 1.
If the template file changes, it is recommended to create a new class like `v1.ts` and extend the `BaseTransformer` class


## Payments File
```
ts-node src/app.ts generate-payments
```

Inputs: statement period, Abacus payment file, period
