Module · job_work
Job Work (External)
Vendor job-work cycle: out, return, RGP closure, billing reconciliation.
Source tables: jobhdr / job / vendmas / rmjobrec / rgphdr / cmrrhdr / billagainstwo
Overall hygiene score
73.7/100
Band
watch
60-79 — needs attention
Metrics
4
checks against source tables
Trend (8 snapshots)
2026-03-18 → 2026-05-18
AI assessment
What the data is telling us
Asking Claude (Haiku) for a focused assessment of this module…
Metric breakdown
4Vendor in master
Job cards whose vendcode exists in vendmas.
100.0/100
959 of 959 records pass
Job return rate
2nd-op jobs (>30d old) that have a return entry in rmjobrec2nd.
2.7/100
214 of 8,006 records pass
7,792 bad records
7,792 bad records
RGP closure
RGPs (>30d old) that have a return entry in cmrrhdr.
98.6/100
4,241 of 4,301 records pass
60 bad records
60 bad records
Vendor bill matched
Jobs (>15d old) with at least one billagainstwo entry.
81.8/100
14,469 of 17,686 records pass
3,217 bad records
3,217 bad records