Hello, I need some advice how to to create one big transactional table.
My table has following columns
person_id, trans_id, date, dep_id, material_id, input, outpu, total
I created procedure from which I will enter all transaction into that table. Problem is I don't have any idea how to achive following.
When I enter for example id for paper and input size of 0,5, everything I see is the same counter which is updated for each transaction no matter which material is being updated.
So I need some ideas abou following
1. How to keep old data in record no matter how many times
I enter some data ?
2. How to reduce number of input arguments, now I need to specify all values (output_size and total := 0) so I can calculate changes.
3. How can I add more rigid checks in if statement for example
(if total_size > 0 && output_size == 0) ?
I need something like SAP enviroment