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

Aged Returnable Gate Pass

RGP issued > 30 days ago, no return entry in cmrrhdr
Flagged
70
Hidden · annotated
0
Compute time
68ms
As of
2026-05-18

Flagged records

70
SeverityTypeKeyDetailAction
warn rgp 2014150 rgpno: 2014150  rgpdate: 2014-07-23T00:00:00  vendcode: HE001  remarks: FOR INfSPECTION  through: MR.PARVEEN NAGAR  
warn rgp 2014196 rgpno: 2014196  rgpdate: 2014-08-20T00:00:00  vendcode: BAPRODUCT  remarks: -BY HAND AJAY (CLG FORMAN).  through: KAMAL KHANNA  
warn rgp 2014507 rgpno: 2014507  rgpdate: 2015-03-03T00:00:00  vendcode: BPHARIDWAR  remarks: RECIEVED BY MR.SATBIR.  through: KAMAL KHANNA  
warn rgp 2017111 rgpno: 2017111  rgpdate: 2017-05-22T00:00:00  vendcode: SYNETICS01  remarks: FOR REPAIRING/REPLACEMENT ONLY.  through: KRISHAN JANGRA  
warn rgp 2018991 rgpno: 2018991  rgpdate: 2019-03-18T00:00:00  vendcode: RFPL  remarks: ORDER BY MR.KRISHAN JI.  through: KRISHAN JANGRA  
warn rgp 2018987 rgpno: 2018987  rgpdate: 2019-03-18T00:00:00  vendcode: RFPL  remarks: ORDER MR.KRISHAN JI.  through: KRISHAN JANGRA  
warn rgp 2019140 rgpno: 2019140  rgpdate: 2019-05-10T00:00:00  vendcode: RFPL  remarks: ORDER BY MR. KAMAL KHANNA JI.  through: KRISHAN JANGRA  
warn rgp 2019336 rgpno: 2019336  rgpdate: 2019-06-23T00:00:00  vendcode: QHT01  remarks: FOR MATERAIL INSPACTION.  through: VED PARKASH YADAV  
warn rgp 2019470 rgpno: 2019470  rgpdate: 2019-07-31T00:00:00  vendcode: SCARLO01  remarks: FOR REPAIRING ONLY.  through: MAHESH(C.L.G.)  
warn rgp 20191207 rgpno: 20191207  rgpdate: 2020-03-04T00:00:00  vendcode: RIYA  remarks: FOR NUT SPECIAL.  through: KAMAL KHANNA  
warn rgp 202410123 rgpno: 202410123  rgpdate: 2024-11-05T00:00:00  vendcode: EMTOOL1  remarks: FOR REPAIRING (UNDER WARRANTY F.O.C.).  through: XXX  
warn rgp 202410484 rgpno: 202410484  rgpdate: 2024-11-11T00:00:00  vendcode: SEVENTH01  remarks: FOR REPAIRING.  through: XXX  
warn rgp 202410483 rgpno: 202410483  rgpdate: 2024-11-11T00:00:00  vendcode: SEVENTH01  remarks: FOR REPAIRING.(RE-ISUE AGAINST RGP.NO.202316221 DATED 04.03.2024).  through: XXX  
warn rgp 202411437 rgpno: 202411437  rgpdate: 2024-11-28T00:00:00  vendcode: MITSUBIS02  remarks: FOR REPAIRING PURPOSE ONLY.  through: XXX  
warn rgp 202415327 rgpno: 202415327  rgpdate: 2025-02-12T00:00:00  vendcode: HMT01  remarks: FOR NUT FITTING PURPOSE.  through: XXX  
warn rgp 202416838 rgpno: 202416838  rgpdate: 2025-03-12T00:00:00  vendcode: MISTARI  remarks: FOR REPAIRING PURPOSE ONLY.  through: XXX  
warn rgp 20254066 rgpno: 20254066  rgpdate: 2025-06-26T00:00:00  vendcode: MEW  remarks: FOR REPAIRING PURPOSE ONLY.  through: XXX  
warn rgp 20254105 rgpno: 20254105  rgpdate: 2025-06-27T00:00:00  vendcode: BPPL  remarks: FOR MACHINING USE.  through: XXX  
warn rgp 20254104 rgpno: 20254104  rgpdate: 2025-06-27T00:00:00  vendcode: BPPL  remarks: AGAINST RGP.NO.15452 RE-ISSUE AGAIN RE-ISSUE AGAINST RGP NO.3662 DT.22.06.2024  through: XXX  
warn rgp 20254175 rgpno: 20254175  rgpdate: 2025-06-28T00:00:00  vendcode: AE01  remarks: FOR REWORK. (BY HAND)  through: XXX  
warn rgp 20254432 rgpno: 20254432  rgpdate: 2025-07-03T00:00:00  vendcode: SRI06  remarks: FOR JOB WORK.  through: XXX  
warn rgp 20258350 rgpno: 20258350  rgpdate: 2025-09-10T00:00:00  vendcode: SHIVAMFAST  remarks: FOR MATERIAL INSPECTION.  through: XXX  
warn rgp 20258828 rgpno: 20258828  rgpdate: 2025-09-18T00:00:00  vendcode: DARS01  remarks: FOR REPAIRING PURPOSE ONLY.  through: XXX  
warn rgp 202512604 rgpno: 202512604  rgpdate: 2025-11-25T00:00:00  vendcode: G.KENGG  remarks: FOR MACHINING.  through: XXX  
warn rgp 202513278 rgpno: 202513278  rgpdate: 2025-12-06T00:00:00  vendcode: OIPL06  remarks: FOR MACHINING (Mount Gard Engine Top Component 05 pcs & ARM De-Comp 10 pcs).  through: XXX  
warn rgp 202513672 rgpno: 202513672  rgpdate: 2025-12-13T00:00:00  vendcode: RIDHISIDHI  remarks: FOR SAMPLE.  through: XXX  
warn rgp 202514567 rgpno: 202514567  rgpdate: 2025-12-27T00:00:00  vendcode: EMTOOL1  remarks: FOR REPAIRING PURPOSE ONLY.  through: XXX  
warn rgp 202514695 rgpno: 202514695  rgpdate: 2025-12-30T00:00:00  vendcode: LMWL01  remarks: For Repairing Purpose Only (Fanuc Oi Mate TD- BRG ID-80).  through: XXX  
warn rgp 202514910 rgpno: 202514910  rgpdate: 2026-01-04T00:00:00  vendcode: SUPERTHERM  remarks: For Repairing (Re-Issue Against Rgp.NO.11439/7299/15864/14168/2793Date.02.12.2023/10.9.2024/21.02.20  through: XXX  
warn rgp 202515516 rgpno: 202515516  rgpdate: 2026-01-13T00:00:00  vendcode: BFW  remarks: As Discussed With Mr.Rahul For Replacement Purpose Only (Required In 12V Supply).  through: XXX  
warn rgp 202516608 rgpno: 202516608  rgpdate: 2026-01-31T00:00:00  vendcode: DAI08  remarks: For Modification Purpose Only (With Electrical Items).  through: XXX  
warn rgp 202516600 rgpno: 202516600  rgpdate: 2026-01-31T00:00:00  vendcode: RI09  remarks: F.G.Shift Component For Pad Grinding (Ok Pc-24Pc & Reject Pc-17Pcs).  through: XXX  
warn rgp 202516596 rgpno: 202516596  rgpdate: 2026-01-31T00:00:00  vendcode: AE  remarks: FOR SLEEVE 5118.  through: XXX  
warn rgp 202516702 rgpno: 202516702  rgpdate: 2026-02-03T00:00:00  vendcode: G.KENGG  remarks: FOR REISSUE AGAUNST RGP.NO 2204/16702  through: XXX  
warn rgp 202518031 rgpno: 202518031  rgpdate: 2026-02-24T00:00:00  vendcode: RAVIENTERP  remarks: For Machining Re Issue RGP.4747 DT./11747  through: XXX  
warn rgp 202518277 rgpno: 202518277  rgpdate: 2026-02-27T00:00:00  vendcode: HTIS  remarks: MIR NO 1025075 FOR PULLER REWORK & RESHARPENING.  through: XXX  
warn rgp 202518519 rgpno: 202518519  rgpdate: 2026-03-06T00:00:00  vendcode: PASUPATI01  remarks: FOR SAMPLE PURPOSE ONLY.  through: XXX  
warn rgp 202518503 rgpno: 202518503  rgpdate: 2026-03-06T00:00:00  vendcode: RECO  remarks: UV Led Lamp shed(reissue RGP no 6691 DT.12/08/25) D magnet coil for repairng purpose.  through: XXX  
warn rgp 202518860 rgpno: 202518860  rgpdate: 2026-03-12T00:00:00  vendcode: RECO  remarks: FOR TESTING PURPOSE ONLY.  through: XXX  
warn rgp 202518829 rgpno: 202518829  rgpdate: 2026-03-12T00:00:00  vendcode: HTIS  remarks: Puller repair reissue against RGP 13517 date 11-12-2025.  through: XXX  
warn rgp 202518892 rgpno: 202518892  rgpdate: 2026-03-13T00:00:00  vendcode: AMIND01  remarks: FOR REPAIRING PURPOSE ONLY.  through: XXX  
warn rgp 202518971 rgpno: 202518971  rgpdate: 2026-03-14T00:00:00  vendcode: SMW01  remarks: For Rework Purpose Only (Locator Base Com#,Jaw Insert Com#,Work Rest Com#,Base Jaw Com#Clamping Slee  through: XXX  
warn rgp 202519060 rgpno: 202519060  rgpdate: 2026-03-17T00:00:00  vendcode: HTIS  remarks: Mir no 2602278 for puller makeing.  through: XXX  
warn rgp 202519178 rgpno: 202519178  rgpdate: 2026-03-19T00:00:00  vendcode: HTIS  remarks: Reissue against RGP no 13927 dated 17/12/2025.  through: XXX  
warn rgp 202519265 rgpno: 202519265  rgpdate: 2026-03-20T00:00:00  vendcode: SNE01  remarks: 01 For Rerubbershing & 01 For Rerubbershing & One Side Shaft Making.  through: XXX  
warn rgp 202519368 rgpno: 202519368  rgpdate: 2026-03-21T00:00:00  vendcode: RMSL  remarks: FOR REPAIRING.(OLP40 KIT REISSUE Against RGP. NO.20252960)  through: XXX  
warn rgp 202519364 rgpno: 202519364  rgpdate: 2026-03-21T00:00:00  vendcode: SMW01  remarks: Damaged Collet For Inspection/Replacement Purpose Only.  through: XXX  
warn rgp 202519535 rgpno: 202519535  rgpdate: 2026-03-24T00:00:00  vendcode: STARINDIA  remarks: For Neck Repair + Resharp Purpose Only Mir No.6247.  through: XXX  
warn rgp 202519781 rgpno: 202519781  rgpdate: 2026-03-28T00:00:00  vendcode: SRE  remarks: For Stud Re-issue Against RGP No.13961 Dt.18/12/2025.  through: XXX  
warn rgp 202519889 rgpno: 202519889  rgpdate: 2026-03-30T00:00:00  vendcode: DAI03  remarks: For Repairing Purpose Only.  through: XXX  
warn rgp 20262 rgpno: 20262  rgpdate: 2026-04-01T00:00:00  vendcode: SHERPUNJAB  remarks: For Repairing Purpose Only.  through: XXX  
warn rgp 202679 rgpno: 202679  rgpdate: 2026-04-03T00:00:00  vendcode: RKI  remarks: Gauge reissue against RGP 20253637 date 18-06-25 For Housing 0474/0162.  through: XXX  
warn rgp 202675 rgpno: 202675  rgpdate: 2026-04-03T00:00:00  vendcode: RAVIENTERP  remarks: For Machining Purpose Only.  through: XXX  
warn rgp 2026112 rgpno: 2026112  rgpdate: 2026-04-03T00:00:00  vendcode: MIIPL  remarks: PUMP BODY ASSY(PUMP BODY 5PCS,FLANGE 5 PCS,SLEEVE 5PCS)FOR MACHINE TRIAL ONLY.  through: XXX  
warn rgp 2026111 rgpno: 2026111  rgpdate: 2026-04-03T00:00:00  vendcode: FINEARCSYS  remarks: PUMP BODY ASSY(PUMP BODY 5PCS,FLANGE 5PCS,SLEEVE 5 PCS) FOR INSPECTION PUPPOSE.  through: XXX  
warn rgp 2026175 rgpno: 2026175  rgpdate: 2026-04-05T00:00:00  vendcode: SMT01  remarks: %Endmill 10 R0.5(FOC Recoating)Endmill 10 6f &Step Drill 6.70(Remake)Drill 8.20(Refluting).  through: XXX  
warn rgp 2026218 rgpno: 2026218  rgpdate: 2026-04-06T00:00:00  vendcode: RAVIENTERP  remarks: For Machining Purpose Only.  through: XXX  
warn rgp 2026262 rgpno: 2026262  rgpdate: 2026-04-07T00:00:00  vendcode: MATRUMAL  remarks: For Repairing Purpose Only.  through: XXX  
warn rgp 2026431 rgpno: 2026431  rgpdate: 2026-04-10T00:00:00  vendcode: MINDS  remarks: For Shaft Main Stand AAWA & S.M.S. ABV (Length Gauge With Sanp Gauge 9.75/10.25mm).  through: XXX  
warn rgp 2026528 rgpno: 2026528  rgpdate: 2026-04-11T00:00:00  vendcode: SMW01  remarks: For Reconditioning Purpose Only (F.C.S. 170 TS PD-FX-MS-50/77190117 & GPDN 210 TS N2761).  through: XXX  
warn rgp 2026502 rgpno: 2026502  rgpdate: 2026-04-11T00:00:00  vendcode: SMT01  remarks: For F.O.C. Rework Purpose Only  through: XXX  
warn rgp 2026561 rgpno: 2026561  rgpdate: 2026-04-12T00:00:00  vendcode: AIRTORQ01  remarks: FOR REPAIRING(15NOS).  through: XXX  
warn rgp 2026695 rgpno: 2026695  rgpdate: 2026-04-14T00:00:00  vendcode: NEELIN  remarks: FOR HOUSING 22203/202/1181  through: XXX  
warn rgp 2026767 rgpno: 2026767  rgpdate: 2026-04-15T00:00:00  vendcode: MAKINO05  remarks: Pump Body (Part No.FH.0232463/AB) For Machining Trial Purpose Only.  through: XXX  
warn rgp 2026723 rgpno: 2026723  rgpdate: 2026-04-15T00:00:00  vendcode: NSH01  remarks: FOR CHAIN ADJUSTER TRIMMING.  through: XXX  
warn rgp 2026830 rgpno: 2026830  rgpdate: 2026-04-16T00:00:00  vendcode: MITSUBISHI  remarks: For Repairing Purpose Only (SER K2YX5N175).  through: XXX  
warn rgp 2026819 rgpno: 2026819  rgpdate: 2026-04-16T00:00:00  vendcode: DAI03  remarks: FOR REPAIRING PURPOSE ONLY.  through: XXX  
warn rgp 2026812 rgpno: 2026812  rgpdate: 2026-04-16T00:00:00  vendcode: PI  remarks: FOR GEAR 2ND/3RD/4TH DRIVE/HOUSING-0361,0149  through: XXX  
warn rgp 2026804 rgpno: 2026804  rgpdate: 2026-04-16T00:00:00  vendcode: PI  remarks: FOR GEAR 2ND/3RD/4TH DRIVE/HOUSING-0361,0149  through: XXX  
warn rgp 2026846 rgpno: 2026846  rgpdate: 2026-04-17T00:00:00  vendcode: PI  remarks: FOR GEAR 2ND/3RD/4TH DRIVE/HOUSING-0361,0149  through: XXX