As part of nerc-project/operations#831, we want to create an invoice that contains our Bare Metal usage. The invoice should have the following columns:

Many of the BM Usage columns will be empty but the ones below will be filled

• Invoice Month is the previous month in this format "2024-10"
• Project - Allocation comes from ESI project
• Project - Allocation ID same as Project - Allocation
• Manager (PI) comes from the Project Table above
• Invoice Email is "[email protected]" for now
• Institution comes from the Project Table above
• Institution - Specific Code
• SU Hours (GBhr or SUhr) comes from the summation we did above
• SU Type
• Rate comes from Server Types or nerc-rates whichever we decided to hold this info
• Cost Rate * SU Hours
• Credit
• Credit Code
• Balance Cost-Credit (which is zero so basically just cost again)

A sample table can be found here

@joachimweyl Let me know if any of our requirements change!