Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Cod | Tipo | NumeroNota | Quantidade | DataEmissao | Material
- 1 | S | 12312 | 1 | 2019-05-16 | 1
- 2 | S | 12313 | 4 | 2019-05-17 | 1
- 3 | E | 12316 | 10 | 2019-05-17 | 1
- 4 | S | 12317 | 9 | 2019-05-18 | 1
- 5 | S | 12323 | 6 | 2019-05-20 | 1
- 6 | S | 12325 | 12 | 2019-05-20 | 1
- 7 | E | 12333 | 3 | 2019-05-24 | 1
- Cod | DataEstoque | Quantidade | Material
- 1 | 2019-05-16 | 24 | 1 -> Antes da data tinha 25
- 2 | 2019-05-17 | 30 | 1
- 3 | 2019-05-18 | 21 | 1
- 4 | 2019-05-19 | 21 | 1
- 5 | 2019-05-20 | 3 | 1
- ... -> repete a mesma quantidade para os dias sem movimentação
- 9 | 2019-05-24 | 6 | 1
- Material|DataEmissao|Quantidade|EstoqueAtual
- 1 |2019-05-16 | - | 24
- 1 |2019-05-17 | -4 | 20
- 1 |2019-05-17 | 10 | 30
- 1 |2019-05-18 | -9 | 21
- 1 |2019-05-20 | -6 | 15
- 1 |2019-05-20 | -12 | 3 -> Ultima linha tenha ser o estoque atual
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement