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
Dispatch lot has no production
despadvicedtl.lotno not present in product1 (last 6 months)
Flagged
100
Hidden · annotated
0
Compute time
1735ms
As of
2026-05-18
Flagged records
100| Severity | Type | Key | Detail | Action |
|---|---|---|---|---|
| warn | adviceno |
1140542426
|
adviceno: 1140542426 advicedate: 2026-05-13T00:00:00 custcode: TAL-HYD itemcode: CP-499 partno: 1427C05801 lotno: CP-499111046 | |
| warn | adviceno |
1140542402
|
adviceno: 1140542402 advicedate: 2026-05-12T00:00:00 custcode: QHTL(M) itemcode: H047406 partno: 047406540BX lotno: H047406111047 | |
| warn | adviceno |
1140542387
|
adviceno: 1140542387 advicedate: 2026-05-11T00:00:00 custcode: HMC-N itemcode: 22810-ACJ-0000 partno: 22810-ACJ-0000 lotno: 22810-ACJ-0000111905 | |
| warn | adviceno |
1140542334
|
adviceno: 1140542334 advicedate: 2026-05-08T00:00:00 custcode: JTEKT(G) itemcode: FLANGEECCO partno: A080-9206 lotno: 27430/27160 | |
| warn | adviceno |
1140542347
|
adviceno: 1140542347 advicedate: 2026-05-08T00:00:00 custcode: QH(C) itemcode: 0436 partno: 0436 01 540 0A lotno: 0436111029 | |
| warn | adviceno |
1140542315
|
adviceno: 1140542315 advicedate: 2026-05-07T00:00:00 custcode: BP-H itemcode: CP-300 partno: 22813-028-3000 lotno: CP-300111110 | |
| warn | adviceno |
1140542283
|
adviceno: 1140542283 advicedate: 2026-05-06T00:00:00 custcode: HML(D) itemcode: ADC-2 partno: 40544-AAF-4000 lotno: ADC-2112044 | |
| warn | adviceno |
1140542264
|
adviceno: 1140542264 advicedate: 2026-05-05T00:00:00 custcode: HML(D) itemcode: COLLARSPLINE partno: 23942-KSP-9100 lotno: COLLARSPLINE111092 | |
| warn | adviceno |
1140542275
|
adviceno: 1140542275 advicedate: 2026-05-05T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140542169
|
adviceno: 1140542169 advicedate: 2026-04-30T00:00:00 custcode: TAL-HYD itemcode: CP-499 partno: 1427C05801 lotno: CP-499111046 | |
| warn | adviceno |
1140542164
|
adviceno: 1140542164 advicedate: 2026-04-30T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140542143
|
adviceno: 1140542143 advicedate: 2026-04-29T00:00:00 custcode: TAL-HYD itemcode: CP-499 partno: 1427C05801 lotno: CP-499111046 | |
| warn | adviceno |
1140542140
|
adviceno: 1140542140 advicedate: 2026-04-29T00:00:00 custcode: KOYO itemcode: IS-YHBHC partno: HUB-T-261 lotno: 29107P-7 | |
| warn | adviceno |
1140542141
|
adviceno: 1140542141 advicedate: 2026-04-29T00:00:00 custcode: HML-G itemcode: COLLARSPLINE partno: 23942-KSP-9100 lotno: COLLARSPLINE111092 | |
| warn | adviceno |
1140542149
|
adviceno: 1140542149 advicedate: 2026-04-29T00:00:00 custcode: JTEKT(D32) itemcode: VALVEBODY partno: 143F001005 lotno: 28254P- | |
| warn | adviceno |
1140542123
|
adviceno: 1140542123 advicedate: 2026-04-28T00:00:00 custcode: KOYO itemcode: IS-YHBHC partno: HUB-T-261 lotno: 29107P-7 | |
| warn | adviceno |
1140542008
|
adviceno: 1140542008 advicedate: 2026-04-23T00:00:00 custcode: KOYO itemcode: INNER partno: HUB-T-001 lotno: INNER111123 | |
| warn | adviceno |
1140542018
|
adviceno: 1140542018 advicedate: 2026-04-22T00:00:00 custcode: HMC-N itemcode: 22810-ACJ-0000 partno: 22810-ACJ-0000 lotno: 22810-ACJ-0000111905 | |
| warn | adviceno |
1140541960
|
adviceno: 1140541960 advicedate: 2026-04-21T00:00:00 custcode: HML-G itemcode: GPDNBOSF partno: 23111-ACL-BOSF lotno: GPDNBOSF111434 | |
| warn | adviceno |
1140541960
|
adviceno: 1140541960 advicedate: 2026-04-21T00:00:00 custcode: HML-G itemcode: GPDNBOSF partno: 23111-ACL-BOSF lotno: GPDNBOSF111518 | |
| warn | adviceno |
1140541963
|
adviceno: 1140541963 advicedate: 2026-04-21T00:00:00 custcode: QHTL(M) itemcode: H.096803 partno: 0968 03 000 0X lotno: H.096803111048 | |
| warn | adviceno |
1140541960
|
adviceno: 1140541960 advicedate: 2026-04-21T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140541933
|
adviceno: 1140541933 advicedate: 2026-04-20T00:00:00 custcode: QHTL(M) itemcode: BC9025 partno: 902500321 cX lotno: BC9025111040 | |
| warn | adviceno |
1140541950
|
adviceno: 1140541950 advicedate: 2026-04-20T00:00:00 custcode: HML-G itemcode: FCSP partno: 14105-GCC-3000 lotno: FCSP111514 | |
| warn | adviceno |
1140541929
|
adviceno: 1140541929 advicedate: 2026-04-19T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140541906
|
adviceno: 1140541906 advicedate: 2026-04-18T00:00:00 custcode: KOYO itemcode: ORYTB partno: 3DACF026F-69-IND lotno: 28450P-2M208340 | |
| warn | adviceno |
1140541906
|
adviceno: 1140541906 advicedate: 2026-04-18T00:00:00 custcode: KOYO itemcode: ISYTB partno: 3DACF026F-71-A-IND lotno: 27400P-4M205633 | |
| warn | adviceno |
1140541885
|
adviceno: 1140541885 advicedate: 2026-04-17T00:00:00 custcode: HML(D) itemcode: ADC-2 partno: 40544-AAF-4000 lotno: ADC-2112044 | |
| warn | adviceno |
1140541884
|
adviceno: 1140541884 advicedate: 2026-04-17T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140541860
|
adviceno: 1140541860 advicedate: 2026-04-16T00:00:00 custcode: HML(D) itemcode: ADC-2 partno: 40544-AAF-4000 lotno: ADC-2112044 | |
| warn | adviceno |
1140541856
|
adviceno: 1140541856 advicedate: 2026-04-16T00:00:00 custcode: QHTL(M) itemcode: 0323 partno: 0323 25 540 gX lotno: 0323111061 | |
| warn | adviceno |
1140541857
|
adviceno: 1140541857 advicedate: 2026-04-16T00:00:00 custcode: HML-G itemcode: FCSP partno: 14105-GCC-3000 lotno: FCSP111514 | |
| warn | adviceno |
1140541857
|
adviceno: 1140541857 advicedate: 2026-04-16T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140541833
|
adviceno: 1140541833 advicedate: 2026-04-15T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140541825
|
adviceno: 1140541825 advicedate: 2026-04-14T00:00:00 custcode: HMCLC itemcode: BOLTACPA partno: 90111-06012-0D lotno: BOLTACPA111084 | |
| warn | adviceno |
1140541799
|
adviceno: 1140541799 advicedate: 2026-04-14T00:00:00 custcode: KOYO itemcode: IS-YHBHC partno: HUB-T-261 lotno: 29107P-7 | |
| warn | adviceno |
1140541815
|
adviceno: 1140541815 advicedate: 2026-04-14T00:00:00 custcode: HML(D) itemcode: ADJUSTER partno: 4053A-AAN-B000 lotno: ADJUSTER111898 | |
| warn | adviceno |
1140541803
|
adviceno: 1140541803 advicedate: 2026-04-14T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140541798
|
adviceno: 1140541798 advicedate: 2026-04-13T00:00:00 custcode: HML-G itemcode: FB210 partno: 90105-KJ9-0000 lotno: FB210111846 | |
| warn | adviceno |
1140541798
|
adviceno: 1140541798 advicedate: 2026-04-13T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111904 | |
| warn | adviceno |
1140541783
|
adviceno: 1140541783 advicedate: 2026-04-13T00:00:00 custcode: HML(D) itemcode: COLLARSPLINE partno: 23942-KSP-9100 lotno: COLLARSPLINE111092 | |
| warn | adviceno |
1140541783
|
adviceno: 1140541783 advicedate: 2026-04-13T00:00:00 custcode: HML(D) itemcode: ADJUSTER partno: 4053A-AAN-B000 lotno: ADJUSTER111898 | |
| warn | adviceno |
1140541788
|
adviceno: 1140541788 advicedate: 2026-04-13T00:00:00 custcode: LLIPL itemcode: 90115-ABW-L000 partno: 90115-ABW-L000 lotno: 90115-ABW-L000111319 | |
| warn | adviceno |
1140541747
|
adviceno: 1140541747 advicedate: 2026-04-11T00:00:00 custcode: HML-G itemcode: GPDNBOSF partno: 23111-ACL-BOSF lotno: GPDNBOSF111536 | |
| warn | adviceno |
1140541747
|
adviceno: 1140541747 advicedate: 2026-04-11T00:00:00 custcode: HML-G itemcode: GPDNBOSF partno: 23111-ACL-BOSF lotno: GPDNBOSF111518 | |
| warn | adviceno |
1140541747
|
adviceno: 1140541747 advicedate: 2026-04-11T00:00:00 custcode: HML-G itemcode: FB210 partno: 90105-KJ9-0000 lotno: FB210111846 | |
| warn | adviceno |
1140541712
|
adviceno: 1140541712 advicedate: 2026-04-10T00:00:00 custcode: HML-G itemcode: FCSP partno: 14105-GCC-3000 lotno: FCSP111514 | |
| warn | adviceno |
1140541732
|
adviceno: 1140541732 advicedate: 2026-04-10T00:00:00 custcode: HMCLC itemcode: BOLTACPA partno: 90111-06012-0D lotno: BOLTACPA111084 | |
| warn | adviceno |
1140541725
|
adviceno: 1140541725 advicedate: 2026-04-10T00:00:00 custcode: JTEKT(D32) itemcode: VALVEBODY partno: 143F001005 lotno: 28254P- | |
| warn | adviceno |
1140541691
|
adviceno: 1140541691 advicedate: 2026-04-09T00:00:00 custcode: HMCLGPC itemcode: CP-310 partno: 90121-KCC-9000 lotno: CP310ODG010426 | |
| warn | adviceno |
1140541671
|
adviceno: 1140541671 advicedate: 2026-04-08T00:00:00 custcode: HMCLV itemcode: CP-037 partno: 44301-KTR-7000 lotno: CP-037111399 | |
| warn | adviceno |
1140541653
|
adviceno: 1140541653 advicedate: 2026-04-08T00:00:00 custcode: HML-G itemcode: GPDNBOSF partno: 23111-ACL-BOSF lotno: GPDNBOSF111518 | |
| warn | adviceno |
1140541653
|
adviceno: 1140541653 advicedate: 2026-04-08T00:00:00 custcode: HML-G itemcode: GPDN partno: 23111-AAG-0010 lotno: GPDN111537 | |
| warn | adviceno |
1140541653
|
adviceno: 1140541653 advicedate: 2026-04-08T00:00:00 custcode: HML-G itemcode: CP-068 partno: 22810-KVE-9000 lotno: CP-068111433 | |
| warn | adviceno |
1140541641
|
adviceno: 1140541641 advicedate: 2026-04-07T00:00:00 custcode: LLIPL itemcode: WSRAA partno: 50618-RAA-0000 lotno: WSRAA111469 | |
| warn | adviceno |
1140541642
|
adviceno: 1140541642 advicedate: 2026-04-07T00:00:00 custcode: JTEKT(C) itemcode: RACK690 partno: JGC51-000690-A lotno: PDF1111/ | |
| warn | adviceno |
1140541652
|
adviceno: 1140541652 advicedate: 2026-04-07T00:00:00 custcode: HMLNOIDA itemcode: 50500-ABV-0000 partno: 50500-ABV-0000-28 lotno: 50500-ABV-0000111531 | |
| warn | adviceno |
1140541652
|
adviceno: 1140541652 advicedate: 2026-04-07T00:00:00 custcode: HMLNOIDA itemcode: FORGEDCOLLARR partno: 50500-ABV-0000-27 lotno: FORGEDCOLLARR111532 | |
| warn | adviceno |
1140541636
|
adviceno: 1140541636 advicedate: 2026-04-07T00:00:00 custcode: JTEKT(G) itemcode: SPIDER partno: A014-3811-01/B021 lotno: 29331-P/ | |
| warn | adviceno |
1140541636
|
adviceno: 1140541636 advicedate: 2026-04-07T00:00:00 custcode: JTEKT(G) itemcode: OMNI partno: A020-2112-39-A lotno: 29897/ | |
| warn | adviceno |
1140541646
|
adviceno: 1140541646 advicedate: 2026-04-07T00:00:00 custcode: QHTL(M) itemcode: H047406 partno: 047406540BX lotno: H047406111520 | |
| warn | adviceno |
1140541645
|
adviceno: 1140541645 advicedate: 2026-04-07T00:00:00 custcode: HML(D) itemcode: AXABA partno: 42301-ABA-0000 lotno: AXABA111486 | |
| warn | adviceno |
1140541645
|
adviceno: 1140541645 advicedate: 2026-04-07T00:00:00 custcode: HML(D) itemcode: ADJUSTER partno: 4053A-AAN-B000 lotno: ADJUSTER111302 | |
| warn | adviceno |
1140541645
|
adviceno: 1140541645 advicedate: 2026-04-07T00:00:00 custcode: HML(D) itemcode: CP-483 partno: 4054A-AAN-B000 lotno: CP-483111500 | |
| warn | adviceno |
1140541645
|
adviceno: 1140541645 advicedate: 2026-04-07T00:00:00 custcode: HML(D) itemcode: AXLE partno: 42301-AAF-4000 lotno: AXLE111501 | |
| warn | adviceno |
1140541645
|
adviceno: 1140541645 advicedate: 2026-04-07T00:00:00 custcode: HML(D) itemcode: ADC-2 partno: 40544-AAF-4000 lotno: ADC-2111502 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: GPDNBOSF partno: 23111-ACL-BOSF lotno: GPDNBOSF111434 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: F.CAMSHAFT partno: 14105-ABF-0000 lotno: F.CAMSHAFT111503 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: COLLARSPLINE partno: 23942-KSP-9100 lotno: COLLARSPLINE111504 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: CP256-01 partno: 44301-AAW-0000 lotno: CP256-01111449 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: BINC partno: 90111-KPL-9000 lotno: BINC111505 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: GEARFINAL partno: 23432ABG2000010 lotno: GEARFINAL111507 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: BOLTFLANGE partno: 957010611500 lotno: BOLTFLANGE111508 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: BBO partno: 90107-AAY-0000 lotno: BBO111511 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: FD1 partno: 14117-ACA-0000 lotno: FD1111512 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: CP-423 partno: 90114-AAM-4000 lotno: CP-423111513 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: FCSP partno: 14105-GCC-3000 lotno: FCSP111514 | |
| warn | adviceno |
1140541646
|
adviceno: 1140541646 advicedate: 2026-04-07T00:00:00 custcode: QHTL(M) itemcode: 0474 02 540 eX partno: 0474 02 540 eX lotno: 0474 02 540 eX111522 | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: FLANGEBOLT partno: 95701-06117 lotno: FLANGEBOLT111509 | |
| warn | adviceno |
1140541649
|
adviceno: 1140541649 advicedate: 2026-04-07T00:00:00 custcode: JTEKT(D32) itemcode: VALVEBODY partno: 143F001005 lotno: 28254P- | |
| warn | adviceno |
1140541640
|
adviceno: 1140541640 advicedate: 2026-04-07T00:00:00 custcode: HML-G itemcode: SMS-AAW partno: 50503-AAW-D000 lotno: SMS-AAW111515 | |
| warn | adviceno |
1140541606
|
adviceno: 1140541606 advicedate: 2026-04-06T00:00:00 custcode: HMC-N itemcode: LEVERR4AA partno: R4AAE1N000000 lotno: LEVERR4AA111383 | |
| warn | adviceno |
1140541606
|
adviceno: 1140541606 advicedate: 2026-04-06T00:00:00 custcode: HMC-N itemcode: 14117-ACJ-0000 partno: 14117-ACJ-0000 lotno: 14117-ACJ-0000111384 | |
| warn | adviceno |
1140541608
|
adviceno: 1140541608 advicedate: 2026-04-06T00:00:00 custcode: HMCLV itemcode: AXABA partno: 42301-ABA-0000 lotno: AXABA111301 | |
| warn | adviceno |
1140541608
|
adviceno: 1140541608 advicedate: 2026-04-06T00:00:00 custcode: HMCLV itemcode: CP-037 partno: 44301-KTR-7000 lotno: CP-037111399 | |
| warn | adviceno |
1140541615
|
adviceno: 1140541615 advicedate: 2026-04-06T00:00:00 custcode: HMCLC itemcode: AXABA partno: 42301-ABA-0000 lotno: AXABA111400 | |
| warn | adviceno |
1140541605
|
adviceno: 1140541605 advicedate: 2026-04-06T00:00:00 custcode: KOYO itemcode: ISYTB partno: 3DACF026F-71-A-IND lotno: 27400P-4M205633 | |
| warn | adviceno |
1140541616
|
adviceno: 1140541616 advicedate: 2026-04-06T00:00:00 custcode: HML(D) itemcode: AXABA partno: 42301-ABA-0000 lotno: AXABA111412 | |
| warn | adviceno |
1140541631
|
adviceno: 1140541631 advicedate: 2026-04-06T00:00:00 custcode: BP-H itemcode: CP-010 partno: 28262-198-0000 lotno: CP-010111450 | |
| warn | adviceno |
1140541620
|
adviceno: 1140541620 advicedate: 2026-04-06T00:00:00 custcode: HML-G itemcode: CP-065 partno: 22810-KRM-B000 lotno: CP-065111432 | |
| warn | adviceno |
1140541620
|
adviceno: 1140541620 advicedate: 2026-04-06T00:00:00 custcode: HML-G itemcode: GPDNBOSF partno: 23111-ACL-BOSF lotno: GPDNBOSF111434 | |
| warn | adviceno |
1140541627
|
adviceno: 1140541627 advicedate: 2026-04-06T00:00:00 custcode: HMLNOIDA itemcode: 50500-ABV-0000 partno: 50500-ABV-0000-28 lotno: 50500-ABV-0000111436 | |
| warn | adviceno |
1140541604
|
adviceno: 1140541604 advicedate: 2026-04-06T00:00:00 custcode: QHTL(M) itemcode: H0788 partno: 0788 02 540 0X lotno: H0788111440 | |
| warn | adviceno |
1140541604
|
adviceno: 1140541604 advicedate: 2026-04-06T00:00:00 custcode: QHTL(M) itemcode: H023401 partno: HOUSING 023401 lotno: H023401111441 | |
| warn | adviceno |
1140541604
|
adviceno: 1140541604 advicedate: 2026-04-06T00:00:00 custcode: QHTL(M) itemcode: BC9025 partno: 902500321 cX lotno: BC9025111442 | |
| warn | adviceno |
1140541620
|
adviceno: 1140541620 advicedate: 2026-04-06T00:00:00 custcode: HML-G itemcode: CP256-01 partno: 44301-AAW-0000 lotno: CP256-01111445 | |
| warn | adviceno |
1140541620
|
adviceno: 1140541620 advicedate: 2026-04-06T00:00:00 custcode: HML-G itemcode: BINC partno: 90111-KPL-9000 lotno: BINC111446 | |
| warn | adviceno |
1140541620
|
adviceno: 1140541620 advicedate: 2026-04-06T00:00:00 custcode: HML-G itemcode: BBO partno: 90107-AAY-0000 lotno: BBO111447 | |
| warn | adviceno |
1140541630
|
adviceno: 1140541630 advicedate: 2026-04-06T00:00:00 custcode: BIL itemcode: UNION180 partno: BCBD0001AAF00 lotno: UNION180111443 | |
| warn | adviceno |
1140541630
|
adviceno: 1140541630 advicedate: 2026-04-06T00:00:00 custcode: BIL itemcode: UNION149 partno: ATO-CN-149 lotno: UNION149111444 |