Data Quality
Eight cross-table checks for inconsistencies the ERP can't catch.
Each check runs a specific query and lists records that fail it. Mark records as reviewed, explained, or ignored to remove them from the list. Annotations live in twin_state.db — nothing is written back to the ERP.
All checks
Material qty leak
Aged Returnable Gate Pass
Stale Order Acceptance
Aged Production Hold
Production without inspection
Negative qty in production
Dispatch lot has no production
Invoice without lot detail
Refresh
Material qty leak
pmchdr2 issued vs product1 (acpt+rej+scrap) — gap > 5%, last 90d
Flagged
100
Hidden · annotated
0
Compute time
7626661ms
As of
2026-05-18
Flagged records
100| Severity | Type | Key | Detail | Action |
|---|---|---|---|---|
| error | issueno |
839960
|
issueno: 839960 prdate: 2026-03-09T00:00:00 itemcode: CP-042 lotno: 29780 issued_pcs: 50000.0 accounted_pcs: 0.0 gap: 50000.0 | |
| error | issueno |
875504
|
issueno: 875504 prdate: 2026-05-14T00:00:00 itemcode: YPYSD lotno: 30693J-1 issued_pcs: 71076.0 accounted_pcs: 23692.0 gap: 47384.0 | |
| error | issueno |
843873
|
issueno: 843873 prdate: 2026-03-16T00:00:00 itemcode: NUTSPL lotno: 30011 issued_pcs: 92000.0 accounted_pcs: 46000.0 gap: 46000.0 | |
| error | issueno |
847408
|
issueno: 847408 prdate: 2026-03-23T00:00:00 itemcode: NUTSPL lotno: 30143 issued_pcs: 89600.0 accounted_pcs: 44800.0 gap: 44800.0 | |
| error | issueno |
833747
|
issueno: 833747 prdate: 2026-02-17T00:00:00 itemcode: NUTSPL lotno: 29734 issued_pcs: 89400.0 accounted_pcs: 44700.0 gap: 44700.0 | |
| error | issueno |
838566
|
issueno: 838566 prdate: 2026-03-03T00:00:00 itemcode: NUTSPL lotno: 29839 issued_pcs: 89400.0 accounted_pcs: 44700.0 gap: 44700.0 | |
| error | issueno |
839798
|
issueno: 839798 prdate: 2026-03-06T00:00:00 itemcode: NUTSPL lotno: 29839 issued_pcs: 89400.0 accounted_pcs: 44700.0 gap: 44700.0 | |
| error | issueno |
840763
|
issueno: 840763 prdate: 2026-03-09T00:00:00 itemcode: NUTSPL lotno: 29839 issued_pcs: 89400.0 accounted_pcs: 44700.0 gap: 44700.0 | |
| error | issueno |
835009
|
issueno: 835009 prdate: 2026-02-23T00:00:00 itemcode: NUTSPL lotno: 29781 issued_pcs: 89300.0 accounted_pcs: 44650.0 gap: 44650.0 | |
| error | issueno |
835010
|
issueno: 835010 prdate: 2026-02-23T00:00:00 itemcode: NUTSPL lotno: 29781 issued_pcs: 89200.0 accounted_pcs: 44600.0 gap: 44600.0 | |
| error | issueno |
833695
|
issueno: 833695 prdate: 2026-02-18T00:00:00 itemcode: NUTSPL lotno: 29734 issued_pcs: 88560.0 accounted_pcs: 44280.0 gap: 44280.0 | |
| error | issueno |
852855
|
issueno: 852855 prdate: 2026-04-03T00:00:00 itemcode: SPIDER02 lotno: 29584-P issued_pcs: 88376.0 accounted_pcs: 44188.0 gap: 44188.0 | |
| error | issueno |
871630
|
issueno: 871630 prdate: 2026-05-07T00:00:00 itemcode: NUTSPL lotno: 30570 issued_pcs: 87844.0 accounted_pcs: 43922.0 gap: 43922.0 | |
| error | issueno |
842263
|
issueno: 842263 prdate: 2026-03-12T00:00:00 itemcode: NUTSPL lotno: 29970 issued_pcs: 84000.0 accounted_pcs: 42000.0 gap: 42000.0 | |
| error | issueno |
866810
|
issueno: 866810 prdate: 2026-04-28T00:00:00 itemcode: NUTSPL lotno: 30528 issued_pcs: 82936.0 accounted_pcs: 41468.0 gap: 41468.0 | |
| error | issueno |
858580
|
issueno: 858580 prdate: 2026-04-13T00:00:00 itemcode: NUTSPL lotno: 30378 issued_pcs: 82600.0 accounted_pcs: 41300.0 gap: 41300.0 | |
| error | issueno |
847011
|
issueno: 847011 prdate: 2026-03-21T00:00:00 itemcode: NUTSPL lotno: 30143 issued_pcs: 82000.0 accounted_pcs: 41000.0 gap: 41000.0 | |
| error | issueno |
869296
|
issueno: 869296 prdate: 2026-05-02T00:00:00 itemcode: NUTSPL lotno: 30544 issued_pcs: 81200.0 accounted_pcs: 40600.0 gap: 40600.0 | |
| error | issueno |
845491
|
issueno: 845491 prdate: 2026-03-19T00:00:00 itemcode: NUTSPL lotno: 30020 issued_pcs: 80000.0 accounted_pcs: 40000.0 gap: 40000.0 | |
| error | issueno |
862436
|
issueno: 862436 prdate: 2026-04-20T00:00:00 itemcode: NUTSPL lotno: 30433 issued_pcs: 77600.0 accounted_pcs: 38800.0 gap: 38800.0 | |
| error | issueno |
860518
|
issueno: 860518 prdate: 2026-04-16T00:00:00 itemcode: NUTSPL lotno: 30378 issued_pcs: 77200.0 accounted_pcs: 38600.0 gap: 38600.0 | |
| error | issueno |
870499
|
issueno: 870499 prdate: 2026-05-05T00:00:00 itemcode: NUTSPL lotno: 30544 issued_pcs: 77136.0 accounted_pcs: 38568.0 gap: 38568.0 | |
| error | issueno |
847985
|
issueno: 847985 prdate: 2026-03-24T00:00:00 itemcode: NUTSPL lotno: 30143 issued_pcs: 77000.0 accounted_pcs: 38500.0 gap: 38500.0 | |
| error | issueno |
861774
|
issueno: 861774 prdate: 2026-04-18T00:00:00 itemcode: NUTSPL lotno: 30414 issued_pcs: 76000.0 accounted_pcs: 38000.0 gap: 38000.0 | |
| error | issueno |
858038
|
issueno: 858038 prdate: 2026-04-11T00:00:00 itemcode: NUTSPL lotno: 30363 issued_pcs: 72800.0 accounted_pcs: 36400.0 gap: 36400.0 | |
| error | issueno |
843980
|
issueno: 843980 prdate: 2026-03-14T00:00:00 itemcode: NUTSPL lotno: 30011 issued_pcs: 71132.0 accounted_pcs: 35566.0 gap: 35566.0 | |
| error | issueno |
846135
|
issueno: 846135 prdate: 2026-03-20T00:00:00 itemcode: NUTSPL lotno: 30020 issued_pcs: 68592.0 accounted_pcs: 34296.0 gap: 34296.0 | |
| error | issueno |
843837
|
issueno: 843837 prdate: 2026-03-16T00:00:00 itemcode: CSPLATE lotno: 29073J-2 issued_pcs: 38192.0 accounted_pcs: 4774.0 gap: 33418.0 | |
| error | issueno |
855359
|
issueno: 855359 prdate: 2026-04-07T00:00:00 itemcode: BINC lotno: 30299 issued_pcs: 32188.0 accounted_pcs: 0.0 gap: 32188.0 | |
| error | issueno |
863617
|
issueno: 863617 prdate: 2026-04-22T00:00:00 itemcode: NUTSPL lotno: 30454 issued_pcs: 64226.0 accounted_pcs: 32113.0 gap: 32113.0 | |
| error | issueno |
858037
|
issueno: 858037 prdate: 2026-04-12T00:00:00 itemcode: NUTSPL lotno: 30363 issued_pcs: 62000.0 accounted_pcs: 31000.0 gap: 31000.0 | |
| error | issueno |
834178
|
issueno: 834178 prdate: 2026-02-20T00:00:00 itemcode: NUTSPL lotno: 29781 issued_pcs: 57980.0 accounted_pcs: 28990.0 gap: 28990.0 | |
| error | issueno |
861777
|
issueno: 861777 prdate: 2026-04-19T00:00:00 itemcode: NUTSPL lotno: 30414 issued_pcs: 56820.0 accounted_pcs: 28410.0 gap: 28410.0 | |
| error | issueno |
863034
|
issueno: 863034 prdate: 2026-04-21T00:00:00 itemcode: NUTSPL lotno: 30363 issued_pcs: 56776.0 accounted_pcs: 28388.0 gap: 28388.0 | |
| error | issueno |
868583
|
issueno: 868583 prdate: 2026-05-01T00:00:00 itemcode: NUTSPL lotno: 30514 issued_pcs: 56000.0 accounted_pcs: 28000.0 gap: 28000.0 | |
| error | issueno |
842767
|
issueno: 842767 prdate: 2026-03-13T00:00:00 itemcode: NUTSPL lotno: 29970 issued_pcs: 53782.0 accounted_pcs: 26891.0 gap: 26891.0 | |
| error | issueno |
868953
|
issueno: 868953 prdate: 2026-05-02T00:00:00 itemcode: NUTSPL lotno: 30544 issued_pcs: 53544.0 accounted_pcs: 26772.0 gap: 26772.0 | |
| error | issueno |
864753
|
issueno: 864753 prdate: 2026-04-24T00:00:00 itemcode: NUTSPL lotno: 30470 issued_pcs: 52000.0 accounted_pcs: 26000.0 gap: 26000.0 | |
| error | issueno |
865460
|
issueno: 865460 prdate: 2026-04-25T00:00:00 itemcode: NUTSPL lotno: 30470 issued_pcs: 51026.0 accounted_pcs: 25513.0 gap: 25513.0 | |
| error | issueno |
864050
|
issueno: 864050 prdate: 2026-04-23T00:00:00 itemcode: NUTSPL lotno: 30470 issued_pcs: 50000.0 accounted_pcs: 25000.0 gap: 25000.0 | |
| error | issueno |
866148
|
issueno: 866148 prdate: 2026-04-27T00:00:00 itemcode: NUTSPL lotno: 30484 issued_pcs: 49336.0 accounted_pcs: 24668.0 gap: 24668.0 | |
| error | issueno |
840146
|
issueno: 840146 prdate: 2026-03-07T00:00:00 itemcode: NUTSPL lotno: 29839 issued_pcs: 45600.0 accounted_pcs: 22800.0 gap: 22800.0 | |
| error | issueno |
833822
|
issueno: 833822 prdate: 2026-02-18T00:00:00 itemcode: FLANGE47647001 lotno: 29443J-1 issued_pcs: 25890.0 accounted_pcs: 4315.0 gap: 21575.0 | |
| error | issueno |
833330
|
issueno: 833330 prdate: 2026-02-19T00:00:00 itemcode: FLANGE47647001 lotno: 29443J-1 issued_pcs: 25392.0 accounted_pcs: 4232.0 gap: 21160.0 | |
| error | issueno |
832761
|
issueno: 832761 prdate: 2026-02-17T00:00:00 itemcode: FLANGE47647001 lotno: 29443J-1 issued_pcs: 24390.0 accounted_pcs: 4065.0 gap: 20325.0 | |
| error | issueno |
834698
|
issueno: 834698 prdate: 2026-02-21T00:00:00 itemcode: CSPLATE lotno: 28253J-1 issued_pcs: 23358.0 accounted_pcs: 3893.0 gap: 19465.0 | |
| error | issueno |
832838
|
issueno: 832838 prdate: 2026-02-17T00:00:00 itemcode: LEVERCBS lotno: 28307P-12 issued_pcs: 22614.0 accounted_pcs: 3194.0 gap: 19420.0 | |
| error | issueno |
855435
|
issueno: 855435 prdate: 2026-04-07T00:00:00 itemcode: SPF lotno: SPRO01042026 issued_pcs: 19200.0 accounted_pcs: 0.0 gap: 19200.0 | |
| error | issueno |
844437
|
issueno: 844437 prdate: 2026-03-17T00:00:00 itemcode: LEVERCBS lotno: 28806P-14 issued_pcs: 22225.0 accounted_pcs: 3175.0 gap: 19050.0 | |
| error | issueno |
853971
|
issueno: 853971 prdate: 2026-04-01T00:00:00 itemcode: CP-301 lotno: WIRE01042026 issued_pcs: 19000.0 accounted_pcs: 0.0 gap: 19000.0 | |
| error | issueno |
833926
|
issueno: 833926 prdate: 2026-02-20T00:00:00 itemcode: CSPLATE lotno: 29374J-2 issued_pcs: 28338.0 accounted_pcs: 9446.0 gap: 18892.0 | |
| error | issueno |
862455
|
issueno: 862455 prdate: 2026-04-16T00:00:00 itemcode: SPF lotno: SPRO01042026 issued_pcs: 18600.0 accounted_pcs: 0.0 gap: 18600.0 | |
| error | issueno |
852176
|
issueno: 852176 prdate: 2026-04-01T00:00:00 itemcode: NUTSPL lotno: 30223 issued_pcs: 34196.0 accounted_pcs: 17098.0 gap: 17098.0 | |
| error | issueno |
842562
|
issueno: 842562 prdate: 2026-03-13T00:00:00 itemcode: LEVERCBS lotno: 28806P-15 issued_pcs: 19458.0 accounted_pcs: 3243.0 gap: 16215.0 | |
| error | issueno |
853581
|
issueno: 853581 prdate: 2026-04-04T00:00:00 itemcode: LEVERCBS lotno: 29754-P issued_pcs: 19290.0 accounted_pcs: 3215.0 gap: 16075.0 | |
| error | issueno |
853173
|
issueno: 853173 prdate: 2026-04-03T00:00:00 itemcode: LEVERCBS lotno: 29754-P issued_pcs: 19242.0 accounted_pcs: 3207.0 gap: 16035.0 | |
| error | issueno |
876097
|
issueno: 876097 prdate: 2026-05-15T00:00:00 itemcode: CP-010 lotno: 29542J-2 issued_pcs: 23991.0 accounted_pcs: 7997.0 gap: 15994.0 | |
| error | issueno |
842539
|
issueno: 842539 prdate: 2026-03-13T00:00:00 itemcode: LEVERCBS lotno: 28806P-15 issued_pcs: 18786.0 accounted_pcs: 3131.0 gap: 15655.0 | |
| error | issueno |
850069
|
issueno: 850069 prdate: 2026-03-27T00:00:00 itemcode: 0162 lotno: 29236J-2 issued_pcs: 23073.0 accounted_pcs: 7691.0 gap: 15382.0 | |
| error | issueno |
875637
|
issueno: 875637 prdate: 2026-05-14T00:00:00 itemcode: YPYSD lotno: 30693J-1 issued_pcs: 30716.0 accounted_pcs: 15358.0 gap: 15358.0 | |
| error | issueno |
840678
|
issueno: 840678 prdate: 2026-03-10T00:00:00 itemcode: LEVERCBS lotno: 28806P-12 issued_pcs: 18162.0 accounted_pcs: 3027.0 gap: 15135.0 | |
| error | issueno |
851946
|
issueno: 851946 prdate: 2026-04-01T00:00:00 itemcode: LEVERCBS lotno: 30217 issued_pcs: 17976.0 accounted_pcs: 2996.0 gap: 14980.0 | |
| error | issueno |
862398
|
issueno: 862398 prdate: 2026-04-21T00:00:00 itemcode: LEVERCBS lotno: 30217-P issued_pcs: 17826.0 accounted_pcs: 2971.0 gap: 14855.0 | |
| error | issueno |
841354
|
issueno: 841354 prdate: 2026-03-11T00:00:00 itemcode: LEVERCBS lotno: 28806P-13 issued_pcs: 16488.0 accounted_pcs: 2748.0 gap: 13740.0 | |
| error | issueno |
876854
|
issueno: 876854 prdate: 2026-05-16T00:00:00 itemcode: CP-010 lotno: 29542J-2 issued_pcs: 27300.0 accounted_pcs: 13650.0 gap: 13650.0 | |
| error | issueno |
842015
|
issueno: 842015 prdate: 2026-03-12T00:00:00 itemcode: LEVERCBS lotno: 28806P-13 issued_pcs: 16242.0 accounted_pcs: 2707.0 gap: 13535.0 | |
| error | issueno |
876857
|
issueno: 876857 prdate: 2026-05-16T00:00:00 itemcode: CP-010 lotno: 29542J-2 issued_pcs: 26210.0 accounted_pcs: 13105.0 gap: 13105.0 | |
| error | issueno |
834042
|
issueno: 834042 prdate: 2026-02-20T00:00:00 itemcode: FLANGE47647001 lotno: 29443J-1 issued_pcs: 16280.0 accounted_pcs: 3256.0 gap: 13024.0 | |
| error | issueno |
842039
|
issueno: 842039 prdate: 2026-03-12T00:00:00 itemcode: LEVERCBS lotno: 28806P-13 issued_pcs: 15414.0 accounted_pcs: 2569.0 gap: 12845.0 | |
| error | issueno |
862459
|
issueno: 862459 prdate: 2026-04-15T00:00:00 itemcode: 1-N010501110 lotno: 29895 issued_pcs: 14400.0 accounted_pcs: 1715.0 gap: 12685.0 | |
| error | issueno |
843849
|
issueno: 843849 prdate: 2026-03-16T00:00:00 itemcode: CSPLATE lotno: 29073J-2 issued_pcs: 16516.0 accounted_pcs: 4129.0 gap: 12387.0 | |
| error | issueno |
853532
|
issueno: 853532 prdate: 2026-04-04T00:00:00 itemcode: SPROCKETBAR lotno: 30055 issued_pcs: 14664.0 accounted_pcs: 2444.0 gap: 12220.0 | |
| error | issueno |
876264
|
issueno: 876264 prdate: 2026-05-16T00:00:00 itemcode: SPIDER02 lotno: 29799P-9 issued_pcs: 23432.0 accounted_pcs: 11716.0 gap: 11716.0 | |
| error | issueno |
843742
|
issueno: 843742 prdate: 2026-03-16T00:00:00 itemcode: FLANGE47647001 lotno: 29700J-1 issued_pcs: 14450.0 accounted_pcs: 2890.0 gap: 11560.0 | |
| error | issueno |
843762
|
issueno: 843762 prdate: 2026-03-16T00:00:00 itemcode: SPROCKETBAR lotno: 28723J-1 issued_pcs: 13698.0 accounted_pcs: 2283.0 gap: 11415.0 | |
| error | issueno |
834622
|
issueno: 834622 prdate: 2026-02-21T00:00:00 itemcode: SPROCKETBAR lotno: 28723J-1 issued_pcs: 13500.0 accounted_pcs: 2250.0 gap: 11250.0 | |
| error | issueno |
860433
|
issueno: 860433 prdate: 2026-04-16T00:00:00 itemcode: SPROCKETBAR lotno: 29429J-3 issued_pcs: 13446.0 accounted_pcs: 2241.0 gap: 11205.0 | |
| error | issueno |
834616
|
issueno: 834616 prdate: 2026-02-21T00:00:00 itemcode: SPROCKETBAR lotno: 28723J-1 issued_pcs: 13068.0 accounted_pcs: 2178.0 gap: 10890.0 | |
| error | issueno |
866025
|
issueno: 866025 prdate: 2026-04-27T00:00:00 itemcode: CP-010 lotno: 29542-J issued_pcs: 21442.0 accounted_pcs: 10721.0 gap: 10721.0 | |
| error | issueno |
834048
|
issueno: 834048 prdate: 2026-02-20T00:00:00 itemcode: SPROCKETBAR lotno: 28723J-1 issued_pcs: 12798.0 accounted_pcs: 2133.0 gap: 10665.0 | |
| error | issueno |
835053
|
issueno: 835053 prdate: 2026-02-23T00:00:00 itemcode: SPROCKETBAR lotno: 28723J-1 issued_pcs: 12456.0 accounted_pcs: 2076.0 gap: 10380.0 | |
| error | issueno |
855827
|
issueno: 855827 prdate: 2026-04-09T00:00:00 itemcode: LEVERCBS lotno: 28307P-7 issued_pcs: 12840.0 accounted_pcs: 2568.0 gap: 10272.0 | |
| error | issueno |
835112
|
issueno: 835112 prdate: 2026-02-23T00:00:00 itemcode: CSPLATE lotno: 28253J-1 issued_pcs: 12282.0 accounted_pcs: 2047.0 gap: 10235.0 | |
| error | issueno |
859291
|
issueno: 859291 prdate: 2026-04-14T00:00:00 itemcode: HUBL lotno: 30247P-7 issued_pcs: 12282.0 accounted_pcs: 2047.0 gap: 10235.0 | |
| error | issueno |
847167
|
issueno: 847167 prdate: 2026-03-23T00:00:00 itemcode: LEVERCBS lotno: 29754P-10 issued_pcs: 20000.0 accounted_pcs: 10000.0 gap: 10000.0 | |
| error | issueno |
855358
|
issueno: 855358 prdate: 2026-04-07T00:00:00 itemcode: BINC lotno: 30041/0 issued_pcs: 10000.0 accounted_pcs: 0.0 gap: 10000.0 | |
| error | issueno |
833824
|
issueno: 833824 prdate: 2026-02-18T00:00:00 itemcode: SPROCKETBAR lotno: 28723J-1 issued_pcs: 11808.0 accounted_pcs: 1968.0 gap: 9840.0 | |
| error | issueno |
832805
|
issueno: 832805 prdate: 2026-02-17T00:00:00 itemcode: SPROCKETBAR lotno: 28457J-1 issued_pcs: 11790.0 accounted_pcs: 1965.0 gap: 9825.0 | |
| error | issueno |
851145
|
issueno: 851145 prdate: 2026-02-19T00:00:00 itemcode: SPF lotno: 29600 issued_pcs: 9600.0 accounted_pcs: 0.0 gap: 9600.0 | |
| error | issueno |
851146
|
issueno: 851146 prdate: 2026-02-19T00:00:00 itemcode: SPF lotno: 29655 issued_pcs: 9600.0 accounted_pcs: 0.0 gap: 9600.0 | |
| error | issueno |
851149
|
issueno: 851149 prdate: 2026-03-13T00:00:00 itemcode: SPF lotno: 29810 issued_pcs: 9600.0 accounted_pcs: 0.0 gap: 9600.0 | |
| error | issueno |
851152
|
issueno: 851152 prdate: 2026-03-24T00:00:00 itemcode: SPF lotno: 29952 issued_pcs: 9600.0 accounted_pcs: 0.0 gap: 9600.0 | |
| error | issueno |
832898
|
issueno: 832898 prdate: 2026-02-17T00:00:00 itemcode: CSPLATE lotno: 28539J-2 issued_pcs: 12480.0 accounted_pcs: 3120.0 gap: 9360.0 | |
| error | issueno |
833350
|
issueno: 833350 prdate: 2026-02-19T00:00:00 itemcode: SPROCKETBAR lotno: 28417J-1 issued_pcs: 11088.0 accounted_pcs: 1848.0 gap: 9240.0 | |
| error | issueno |
851151
|
issueno: 851151 prdate: 2026-03-19T00:00:00 itemcode: SPF lotno: 29811 issued_pcs: 9180.0 accounted_pcs: 0.0 gap: 9180.0 | |
| error | issueno |
844969
|
issueno: 844969 prdate: 2026-03-18T00:00:00 itemcode: LEVERCBS lotno: 28806P-11 issued_pcs: 11420.0 accounted_pcs: 2284.0 gap: 9136.0 | |
| error | issueno |
839004
|
issueno: 839004 prdate: 2026-03-07T00:00:00 itemcode: LEVERCBS lotno: 28271P-8 issued_pcs: 8928.0 accounted_pcs: 0.0 gap: 8928.0 | |
| error | issueno |
876557
|
issueno: 876557 prdate: 2026-05-16T00:00:00 itemcode: CP-010 lotno: 29542J-2 issued_pcs: 8823.0 accounted_pcs: 0.0 gap: 8823.0 | |
| error | issueno |
834055
|
issueno: 834055 prdate: 2026-02-20T00:00:00 itemcode: SPROCKETBAR lotno: 28457J-1 issued_pcs: 10560.0 accounted_pcs: 1760.0 gap: 8800.0 | |
| error | issueno |
834374
|
issueno: 834374 prdate: 2026-02-21T00:00:00 itemcode: CP-030 lotno: 28916J-1 issued_pcs: 17480.0 accounted_pcs: 8740.0 gap: 8740.0 |