Add manual data/values to script with data load from database
I have a scipt where I load all revenue/volumes/categories from our booking systems database. I'm now trying to add an variable price to this and need to do this manually since it does not exist in the booking system. What I want to trigger is when cargo A in harbour X is being transported this triggers an varible cost of Y$.
So my question is how can I add the cost of Y$ to the existing categories I have loaded from the database and create relationship between them, transported cargo A x Y$ = total variable cost for cargo / customer