By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
rawmaterialid | dateofentry | receiptno | productid | manufacturedQty | usedQuantity | availableQty | mfg | inventory_rawmaterialQty | sum_waste |
---|---|---|---|---|---|---|---|---|---|
128 | 13990124 | 754 | 54 | 29475 | 29475 | 661668 | BBB | 708867 | 895 |
128 | 13990127 | 756 | 54 | 30720 | 30720 | 661668 | BBB | 708867 | 895 |
128 | 13990131 | 757 | 54 | 34560 | 34560 | 661668 | BBB | 708867 | 895 |
128 | 13990203 | 758 | 54 | 22276 | 22276 | 661668 | BBB | 708867 | 895 |
128 | 13990431 | 821 | 54 | 19203 | 19203 | 661668 | BBB | 708867 | 895 |
128 | 13990512 | 825 | 54 | 10464 | 10464 | 661668 | BBB | 708867 | 895 |
128 | 13990515 | 828 | 54 | 19200 | 19200 | 661668 | BBB | 708867 | 895 |
128 | 13990519 | 831 | 54 | 15360 | 15360 | 661668 | BBB | 708867 | 895 |
128 | 13990522 | 835 | 54 | 3827 | 3827 | 661668 | BBB | 708867 | 895 |
128 | 13990721 | 880 | 54 | 31363 | 31363 | 661668 | BBB | 708867 | 895 |
128 | 13990827 | 926 | 54 | 32961 | 32961 | 661668 | BBB | 708867 | 895 |
128 | 13990919 | 944 | 54 | 7683 | 7683 | 661668 | BBB | 708867 | 895 |
128 | 13990925 | 949 | 54 | 21563 | 21563 | 661668 | BBB | 708867 | 895 |
128 | 13991112 | 992 | 54 | 52803 | 52803 | 661668 | BBB | 708867 | 895 |
128 | 13991115 | 994 | 54 | 73890 | 73890 | 661668 | BBB | 708867 | 895 |
128 | 13991120 | 998 | 54 | 45360 | 45360 | 661668 | BBB | 708867 | 895 |
128 | 13991203 | 1012 | 54 | 52803 | 52803 | 661668 | BBB | 708867 | 895 |
128 | 13991205 | 1013 | 54 | 32473 | 32473 | 661668 | BBB | 708867 | 895 |
128 | 13991214 | 1019 | 54 | 24003 | 24003 | 661668 | BBB | 708867 | 895 |
128 | 13991218 | 1022 | 54 | 91200 | 91200 | 661668 | BBB | 708867 | 895 |
128 | 13991219 | 1024 | 54 | 10481 | 10481 | 661668 | BBB | 708867 | 895 |
143 | 13990124 | 754 | 54 | 29475 | 29475 | 661668 | BBB | 736000 | 432 |
143 | 13990127 | 756 | 54 | 30720 | 30720 | 661668 | BBB | 736000 | 432 |
143 | 13990131 | 757 | 54 | 34560 | 34560 | 661668 | BBB | 736000 | 432 |
143 | 13990203 | 758 | 54 | 22276 | 22276 | 661668 | BBB | 736000 | 432 |
143 | 13990431 | 821 | 54 | 19203 | 19203 | 661668 | BBB | 736000 | 432 |
143 | 13990512 | 825 | 54 | 10464 | 10464 | 661668 | BBB | 736000 | 432 |
143 | 13990515 | 828 | 54 | 19200 | 19200 | 661668 | BBB | 736000 | 432 |
143 | 13990519 | 831 | 54 | 15360 | 15360 | 661668 | BBB | 736000 | 432 |
143 | 13990522 | 835 | 54 | 3827 | 3827 | 661668 | BBB | 736000 | 432 |
143 | 13990721 | 880 | 54 | 31363 | 31363 | 661668 | BBB | 736000 | 432 |
143 | 13990827 | 926 | 54 | 32961 | 32961 | 661668 | BBB | 736000 | 432 |
143 | 13990919 | 944 | 54 | 7683 | 7683 | 661668 | BBB | 736000 | 432 |
143 | 13990925 | 949 | 54 | 21563 | 21563 | 661668 | BBB | 736000 | 432 |
143 | 13991112 | 992 | 54 | 52803 | 52803 | 661668 | BBB | 736000 | 432 |
143 | 13991115 | 994 | 54 | 73890 | 73890 | 661668 | BBB | 736000 | 432 |
143 | 13991120 | 998 | 54 | 45360 | 45360 | 661668 | BBB | 736000 | 432 |
143 | 13991203 | 1012 | 54 | 52803 | 52803 | 661668 | BBB | 736000 | 432 |
143 | 13991205 | 1013 | 54 | 32473 | 32473 | 661668 | BBB | 736000 | 432 |
143 | 13991214 | 1019 | 54 | 24003 | 24003 | 661668 | BBB | 736000 | 432 |
143 | 13991218 | 1022 | 54 | 91200 | 91200 | 661668 | BBB | 736000 | 432 |
143 | 13991219 | 1024 | 54 | 10481 | 10481 | 661668 | BBB | 736000 | 432 |
194 | 13990124 | 754 | 54 | 29475 | 55265.625 | 661668 | BBB | 10870 | null |
194 | 13990127 | 756 | 54 | 30720 | 57600 | 661668 | BBB | 10870 | null |
194 | 13990131 | 757 | 54 | 34560 | 64800 | 661668 | BBB | 10870 | null |
194 | 13990203 | 758 | 54 | 22276 | 41767.5 | 661668 | BBB | 10870 | null |
194 | 13990431 | 821 | 54 | 19203 | 36005.625 | 661668 | BBB | 10870 | null |
194 | 13990512 | 825 | 54 | 10464 | 19620 | 661668 | BBB | 10870 | null |
194 | 13990515 | 828 | 54 | 19200 | 36000 | 661668 | BBB | 10870 | null |
194 | 13990519 | 831 | 54 | 15360 | 28800 | 661668 | BBB | 10870 | null |
194 | 13990522 | 835 | 54 | 3827 | 7175.625 | 661668 | BBB | 10870 | null |
194 | 13990721 | 880 | 54 | 31363 | 58805.625 | 661668 | BBB | 10870 | null |
194 | 13990827 | 926 | 54 | 32961 | 61801.875 | 661668 | BBB | 10870 | null |
194 | 13990919 | 944 | 54 | 7683 | 14405.625 | 661668 | BBB | 10870 | null |
194 | 13990925 | 949 | 54 | 21563 | 40430.625 | 661668 | BBB | 10870 | null |
194 | 13991112 | 992 | 54 | 52803 | 99005.625 | 661668 | BBB | 10870 | null |
194 | 13991115 | 994 | 54 | 73890 | 138543.75 | 661668 | BBB | 10870 | null |
194 | 13991120 | 998 | 54 | 45360 | 85050 | 661668 | BBB | 10870 | null |
194 | 13991203 | 1012 | 54 | 52803 | 99005.625 | 661668 | BBB | 10870 | null |
194 | 13991205 | 1013 | 54 | 32473 | 60886.875 | 661668 | BBB | 10870 | null |
194 | 13991214 | 1019 | 54 | 24003 | 45005.625 | 661668 | BBB | 10870 | null |
194 | 13991218 | 1022 | 54 | 91200 | 171000 | 661668 | BBB | 10870 | null |
194 | 13991219 | 1024 | 54 | 10481 | 19651.875 | 661668 | BBB | 10870 | null |
dateofentry | receiptno | mfg | productid | product | manufacturedQty | availableQty | rawmaterialid | rawmaterial | usedQuantity | supplierid | inventory_rawmaterialID | inventory_rawmaterialQty |
---|---|---|---|---|---|---|---|---|---|---|---|---|
13991219 | 1024 | BBB | 54 | null | 10481 | 661668 | 128 | null | 10481 | 58 | 128 | 399340 |
13991219 | 1024 | BBB | 54 | null | 10481 | 661668 | 128 | null | 10481 | 65 | 128 | 309527 |
13991218 | 1022 | BBB | 54 | null | 91200 | 661668 | 128 | null | 91200 | 58 | 128 | 399340 |
13991218 | 1022 | BBB | 54 | null | 91200 | 661668 | 128 | null | 91200 | 65 | 128 | 309527 |
13991214 | 1019 | BBB | 54 | null | 24003 | 661668 | 128 | null | 24003 | 58 | 128 | 399340 |
13991214 | 1019 | BBB | 54 | null | 24003 | 661668 | 128 | null | 24003 | 65 | 128 | 309527 |
13991205 | 1013 | BBB | 54 | null | 32473 | 661668 | 128 | null | 32473 | 58 | 128 | 399340 |
13991205 | 1013 | BBB | 54 | null | 32473 | 661668 | 128 | null | 32473 | 65 | 128 | 309527 |
13991203 | 1012 | BBB | 54 | null | 52803 | 661668 | 128 | null | 52803 | 58 | 128 | 399340 |
13991203 | 1012 | BBB | 54 | null | 52803 | 661668 | 128 | null | 52803 | 65 | 128 | 309527 |
13991120 | 998 | BBB | 54 | null | 45360 | 661668 | 128 | null | 45360 | 58 | 128 | 399340 |
13991120 | 998 | BBB | 54 | null | 45360 | 661668 | 128 | null | 45360 | 65 | 128 | 309527 |
13991115 | 994 | BBB | 54 | null | 73890 | 661668 | 128 | null | 73890 | 58 | 128 | 399340 |
13991115 | 994 | BBB | 54 | null | 73890 | 661668 | 128 | null | 73890 | 65 | 128 | 309527 |
13991112 | 992 | BBB | 54 | null | 52803 | 661668 | 128 | null | 52803 | 58 | 128 | 399340 |
13991112 | 992 | BBB | 54 | null | 52803 | 661668 | 128 | null | 52803 | 65 | 128 | 309527 |
13990925 | 949 | BBB | 54 | null | 21563 | 661668 | 128 | null | 21563 | 58 | 128 | 399340 |
13990925 | 949 | BBB | 54 | null | 21563 | 661668 | 128 | null | 21563 | 65 | 128 | 309527 |
13990919 | 944 | BBB | 54 | null | 7683 | 661668 | 128 | null | 7683 | 58 | 128 | 399340 |
13990919 | 944 | BBB | 54 | null | 7683 | 661668 | 128 | null | 7683 | 65 | 128 | 309527 |
13990827 | 926 | BBB | 54 | null | 32961 | 661668 | 128 | null | 32961 | 58 | 128 | 399340 |
13990827 | 926 | BBB | 54 | null | 32961 | 661668 | 128 | null | 32961 | 65 | 128 | 309527 |
13990721 | 880 | BBB | 54 | null | 31363 | 661668 | 128 | null | 31363 | 58 | 128 | 399340 |
13990721 | 880 | BBB | 54 | null | 31363 | 661668 | 128 | null | 31363 | 65 | 128 | 309527 |
13990522 | 835 | BBB | 54 | null | 3827 | 661668 | 128 | null | 3827 | 58 | 128 | 399340 |
13990522 | 835 | BBB | 54 | null | 3827 | 661668 | 128 | null | 3827 | 65 | 128 | 309527 |
13990519 | 831 | BBB | 54 | null | 15360 | 661668 | 128 | null | 15360 | 58 | 128 | 399340 |
13990519 | 831 | BBB | 54 | null | 15360 | 661668 | 128 | null | 15360 | 65 | 128 | 309527 |
13990515 | 828 | BBB | 54 | null | 19200 | 661668 | 128 | null | 19200 | 58 | 128 | 399340 |
13990515 | 828 | BBB | 54 | null | 19200 | 661668 | 128 | null | 19200 | 65 | 128 | 309527 |
13990512 | 825 | BBB | 54 | null | 10464 | 661668 | 128 | null | 10464 | 58 | 128 | 399340 |
13990512 | 825 | BBB | 54 | null | 10464 | 661668 | 128 | null | 10464 | 65 | 128 | 309527 |
13990431 | 821 | BBB | 54 | null | 19203 | 661668 | 128 | null | 19203 | 58 | 128 | 399340 |
13990431 | 821 | BBB | 54 | null | 19203 | 661668 | 128 | null | 19203 | 65 | 128 | 309527 |
13990203 | 758 | BBB | 54 | null | 22276 | 661668 | 128 | null | 22276 | 58 | 128 | 399340 |
13990203 | 758 | BBB | 54 | null | 22276 | 661668 | 128 | null | 22276 | 65 | 128 | 309527 |
13990131 | 757 | BBB | 54 | null | 34560 | 661668 | 128 | null | 34560 | 58 | 128 | 399340 |
13990131 | 757 | BBB | 54 | null | 34560 | 661668 | 128 | null | 34560 | 65 | 128 | 309527 |
13990127 | 756 | BBB | 54 | null | 30720 | 661668 | 128 | null | 30720 | 58 | 128 | 399340 |
13990127 | 756 | BBB | 54 | null | 30720 | 661668 | 128 | null | 30720 | 65 | 128 | 309527 |
13990124 | 754 | BBB | 54 | null | 29475 | 661668 | 128 | null | 29475 | 58 | 128 | 399340 |
13990124 | 754 | BBB | 54 | null | 29475 | 661668 | 128 | null | 29475 | 65 | 128 | 309527 |
13991219 | 1024 | BBB | 54 | null | 10481 | 661668 | 143 | null | 10481 | 57 | 143 | 736000 |
13991219 | 1024 | BBB | 54 | null | 10481 | 661668 | 143 | null | 10481 | 66 | 143 | 0 |
13991218 | 1022 | BBB | 54 | null | 91200 | 661668 | 143 | null | 91200 | 57 | 143 | 736000 |
13991218 | 1022 | BBB | 54 | null | 91200 | 661668 | 143 | null | 91200 | 66 | 143 | 0 |
13991214 | 1019 | BBB | 54 | null | 24003 | 661668 | 143 | null | 24003 | 57 | 143 | 736000 |
13991214 | 1019 | BBB | 54 | null | 24003 | 661668 | 143 | null | 24003 | 66 | 143 | 0 |
13991205 | 1013 | BBB | 54 | null | 32473 | 661668 | 143 | null | 32473 | 57 | 143 | 736000 |
13991205 | 1013 | BBB | 54 | null | 32473 | 661668 | 143 | null | 32473 | 66 | 143 | 0 |
13991203 | 1012 | BBB | 54 | null | 52803 | 661668 | 143 | null | 52803 | 57 | 143 | 736000 |
13991203 | 1012 | BBB | 54 | null | 52803 | 661668 | 143 | null | 52803 | 66 | 143 | 0 |
13991120 | 998 | BBB | 54 | null | 45360 | 661668 | 143 | null | 45360 | 57 | 143 | 736000 |
13991120 | 998 | BBB | 54 | null | 45360 | 661668 | 143 | null | 45360 | 66 | 143 | 0 |
13991115 | 994 | BBB | 54 | null | 73890 | 661668 | 143 | null | 73890 | 57 | 143 | 736000 |
13991115 | 994 | BBB | 54 | null | 73890 | 661668 | 143 | null | 73890 | 66 | 143 | 0 |
13991112 | 992 | BBB | 54 | null | 52803 | 661668 | 143 | null | 52803 | 57 | 143 | 736000 |
13991112 | 992 | BBB | 54 | null | 52803 | 661668 | 143 | null | 52803 | 66 | 143 | 0 |
13990925 | 949 | BBB | 54 | null | 21563 | 661668 | 143 | null | 21563 | 57 | 143 | 736000 |
13990925 | 949 | BBB | 54 | null | 21563 | 661668 | 143 | null | 21563 | 66 | 143 | 0 |
13990919 | 944 | BBB | 54 | null | 7683 | 661668 | 143 | null | 7683 | 57 | 143 | 736000 |
13990919 | 944 | BBB | 54 | null | 7683 | 661668 | 143 | null | 7683 | 66 | 143 | 0 |
13990827 | 926 | BBB | 54 | null | 32961 | 661668 | 143 | null | 32961 | 57 | 143 | 736000 |
13990827 | 926 | BBB | 54 | null | 32961 | 661668 | 143 | null | 32961 | 66 | 143 | 0 |
13990721 | 880 | BBB | 54 | null | 31363 | 661668 | 143 | null | 31363 | 57 | 143 | 736000 |
13990721 | 880 | BBB | 54 | null | 31363 | 661668 | 143 | null | 31363 | 66 | 143 | 0 |
13990522 | 835 | BBB | 54 | null | 3827 | 661668 | 143 | null | 3827 | 57 | 143 | 736000 |
13990522 | 835 | BBB | 54 | null | 3827 | 661668 | 143 | null | 3827 | 66 | 143 | 0 |
13990519 | 831 | BBB | 54 | null | 15360 | 661668 | 143 | null | 15360 | 57 | 143 | 736000 |
13990519 | 831 | BBB | 54 | null | 15360 | 661668 | 143 | null | 15360 | 66 | 143 | 0 |
13990515 | 828 | BBB | 54 | null | 19200 | 661668 | 143 | null | 19200 | 57 | 143 | 736000 |
13990515 | 828 | BBB | 54 | null | 19200 | 661668 | 143 | null | 19200 | 66 | 143 | 0 |
13990512 | 825 | BBB | 54 | null | 10464 | 661668 | 143 | null | 10464 | 57 | 143 | 736000 |
13990512 | 825 | BBB | 54 | null | 10464 | 661668 | 143 | null | 10464 | 66 | 143 | 0 |
13990431 | 821 | BBB | 54 | null | 19203 | 661668 | 143 | null | 19203 | 57 | 143 | 736000 |
13990431 | 821 | BBB | 54 | null | 19203 | 661668 | 143 | null | 19203 | 66 | 143 | 0 |
13990203 | 758 | BBB | 54 | null | 22276 | 661668 | 143 | null | 22276 | 57 | 143 | 736000 |
13990203 | 758 | BBB | 54 | null | 22276 | 661668 | 143 | null | 22276 | 66 | 143 | 0 |
13990131 | 757 | BBB | 54 | null | 34560 | 661668 | 143 | null | 34560 | 57 | 143 | 736000 |
13990131 | 757 | BBB | 54 | null | 34560 | 661668 | 143 | null | 34560 | 66 | 143 | 0 |
13990127 | 756 | BBB | 54 | null | 30720 | 661668 | 143 | null | 30720 | 57 | 143 | 736000 |
13990127 | 756 | BBB | 54 | null | 30720 | 661668 | 143 | null | 30720 | 66 | 143 | 0 |
13990124 | 754 | BBB | 54 | null | 29475 | 661668 | 143 | null | 29475 | 57 | 143 | 736000 |
13990124 | 754 | BBB | 54 | null | 29475 | 661668 | 143 | null | 29475 | 66 | 143 | 0 |
13991219 | 1024 | BBB | 54 | null | 10481 | 661668 | 194 | null | 19651.875 | 79 | 194 | 10870 |
13991218 | 1022 | BBB | 54 | null | 91200 | 661668 | 194 | null | 171000 | 79 | 194 | 10870 |
13991214 | 1019 | BBB | 54 | null | 24003 | 661668 | 194 | null | 45005.625 | 79 | 194 | 10870 |
13991205 | 1013 | BBB | 54 | null | 32473 | 661668 | 194 | null | 60886.875 | 79 | 194 | 10870 |
13991203 | 1012 | BBB | 54 | null | 52803 | 661668 | 194 | null | 99005.625 | 79 | 194 | 10870 |
13991120 | 998 | BBB | 54 | null | 45360 | 661668 | 194 | null | 85050 | 79 | 194 | 10870 |
13991115 | 994 | BBB | 54 | null | 73890 | 661668 | 194 | null | 138543.75 | 79 | 194 | 10870 |
13991112 | 992 | BBB | 54 | null | 52803 | 661668 | 194 | null | 99005.625 | 79 | 194 | 10870 |
13990925 | 949 | BBB | 54 | null | 21563 | 661668 | 194 | null | 40430.625 | 79 | 194 | 10870 |
13990919 | 944 | BBB | 54 | null | 7683 | 661668 | 194 | null | 14405.625 | 79 | 194 | 10870 |
13990827 | 926 | BBB | 54 | null | 32961 | 661668 | 194 | null | 61801.875 | 79 | 194 | 10870 |
13990721 | 880 | BBB | 54 | null | 31363 | 661668 | 194 | null | 58805.625 | 79 | 194 | 10870 |
13990522 | 835 | BBB | 54 | null | 3827 | 661668 | 194 | null | 7175.625 | 79 | 194 | 10870 |
13990519 | 831 | BBB | 54 | null | 15360 | 661668 | 194 | null | 28800 | 79 | 194 | 10870 |
13990515 | 828 | BBB | 54 | null | 19200 | 661668 | 194 | null | 36000 | 79 | 194 | 10870 |
13990512 | 825 | BBB | 54 | null | 10464 | 661668 | 194 | null | 19620 | 79 | 194 | 10870 |
13990431 | 821 | BBB | 54 | null | 19203 | 661668 | 194 | null | 36005.625 | 79 | 194 | 10870 |
13990203 | 758 | BBB | 54 | null | 22276 | 661668 | 194 | null | 41767.5 | 79 | 194 | 10870 |
13990131 | 757 | BBB | 54 | null | 34560 | 661668 | 194 | null | 64800 | 79 | 194 | 10870 |
13990127 | 756 | BBB | 54 | null | 30720 | 661668 | 194 | null | 57600 | 79 | 194 | 10870 |
13990124 | 754 | BBB | 54 | null | 29475 | 661668 | 194 | null | 55265.625 | 79 | 194 | 10870 |