tables · table

vendorrating

The vendorrating table serves as a performance tracking and quality assurance ledger for vendor-supplied items. It aggregates production and quality dataâ€”including received, accepted (OK), rejected, and scrap quantitiesâ€”against specific vendors, items, and material receipt numbers (mrpno). This data is typically used to generate Vendor Rating Indexes (VRI) or supplier scorecards based on quality (Rejection Rate) and delivery (Scheduled vs. Received) performance.

Row count

Last entry

—

Source

tables

Columns

Column	Type	Nullable	Meaning
`index`	integer	NO	Primary Key
`compcode`	string	NO	Company Identifier
`jobno`	string	YES	Production Job Number
`vendcode`	string	NO	Unique Vendor ID
`itemcode`	string	NO	Unique Part/Item Identifier
`mrpno`	string	YES	Material Receipt/Process Number
`mrpdate`	string	YES	Date of Material Receipt
`chno`	string	YES	Delivery Challan Number
`chdate`	string	YES	Date of Delivery Challan
`recqty`	number	YES	Total Quantity Received
`okqty`	number	YES	Quality-Accepted Quantity
`rejqty`	number	YES	Quality-Rejected Quantity
`scrapqty`	number	YES	Quantity categorized as scrap
`schqty`	number	YES	Quantity scheduled/ordered

Full documentation

### 1. Overview
 The `vendorrating` table serves as a performance tracking and quality assurance ledger for vendor-supplied items. It aggregates production and quality dataâ€”including received, accepted (OK), rejected, and scrap quantitiesâ€”against specific vendors, items, and material receipt numbers (`mrpno`). This data is typically used to generate Vendor Rating Indexes (VRI) or supplier scorecards based on quality (Rejection Rate) and delivery (Scheduled vs. Received) performance.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key | Auto-incrementing ID | `WHERE index = 10` |
 | **compcode** | string | NO | Company Identifier | e.g., "DAS" | `JOIN dbo.company ON ...` |
 | **jobno** | string | YES | Production Job Number | e.g., "JOB/23-24/001" | `GROUP BY jobno` |
 | **vendcode** | string | NO | Unique Vendor ID | e.g., "RKI" | `JOIN dbo.vendmas ON ...` |
 | **itemcode** | string | NO | Unique Part/Item Identifier | e.g., "9027", "CP-002" | `JOIN dbo.itemmas ON ...` |
 | **mrpno** | string | YES | Material Receipt/Process Number | | `JOIN dbo.cmrrhdr ON ...` |
 | **mrpdate** | string | YES | Date of Material Receipt | ISO Date Strings | |
 | **chno** | string | YES | Delivery Challan Number | | `JOIN dbo.ChallanBinTrayHDR` |
 | **chdate** | string | YES | Date of Delivery Challan | | |
 | **recqty** | number | YES | Total Quantity Received | | `SUM(recqty)` |
 | **okqty** | number | YES | Quality-Accepted Quantity | | `SUM(okqty)` |
 | **rejqty** | number | YES | Quality-Rejected Quantity | | `(rejqty / recqty) * 100` |
 | **scrapqty** | number | YES | Quantity categorized as scrap | | |
 | **schqty** | number | YES | Quantity scheduled/ordered | | `(recqty / schqty) * 100` |
 
 ### 3. Relationships & Join Map
 
 The table acts as a centralized reporting hub for vendor metrics, linking procurement, quality, and production.
 
 #### Primary Joins (SCHEMA_MAP Verified):
 * **Vendor Master**: `vendorrating.vendcode` â†’ `dbo.vendmas.vendcode` (To retrieve vendor names and categories)
 * **Item Master**: `vendorrating.itemcode` â†’ `dbo.itemmas.itemcode` (To retrieve part names and specifications)
 * **Company**: `vendorrating.compcode` â†’ `dbo.company.compcode` (Multi-tenant filtering)
 * **Job Details**: `vendorrating.jobno` â†’ `dbo.job.jobno` (To link rating back to a specific production job)
 * **Challan Details**: `vendorrating.chno` â†’ `dbo.ChallanBinTrayHDR.chno` (To link to physical delivery documents)
 
 #### Logical/Inferred Joins:
 * **Material Receipts**: `vendorrating.mrpno` â†’ `dbo.cmrrhdr.mrpno` (Likely: To link rating to the specific MRR session)
 * **Schedules**: `vendorrating.itemcode` + `vendorrating.vendcode` â†’ `dbo.JoboaSch.itemcode` + `dbo.JoboaSch.VendCode` (To compare actual receipts against planned schedules)