vendbillcomproforma

### 1) Overview
 The `vendbillcomproforma` table serves as a staging or calculation ledger for vendor proforma billing. It captures the intersection of material receipts (`mrpno`), job work (`jobno`), and vendor invoices. It tracks accepted quantities, scrap, and billing rates for specific items provided by or processed by a vendor. This table is critical for reconciling work-in-progress (WIP) jobs against vendor claims before final billing is posted.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key for the record. | | PK |
 | **compcode** | string | YES | Company identifier code. | e.g., "DAS" | FK |
 | **mrpno** | string | YES | Material Receipt Process/Note number. | | FK |
 | **mrpdate** | string | YES | Date associated with the MRP receipt. | | Filter |
 | **billno** | string | YES | Vendor's proforma bill or invoice number. | | FK / Filter |
 | **billdate** | string | YES | Date of the vendor bill. | | Filter |
 | **itemcode** | string | YES | Unique identifier for the item/part. | e.g., "S15C37.10" | FK |
 | **rwqty** | string | YES | Rework quantity associated with the bill. | | Math |
 | **qtyacpt** | number | YES | Quantity accepted after inspection. | | Math |
 | **qtyscrap** | number | YES | Quantity identified as scrap during processing. | | Math |
 | **amount** | number | YES | Calculated net amount for the line item. | | Math |
 | **amountbill** | string | YES | Total billed amount (as string). | | Reporting |
 | **vendcode** | string | YES | Unique identifier for the Vendor. | e.g., "PRSU" | FK |
 | **flag** | integer | YES | Status or processing flag. | 1, 0 | Logic |
 | **jobno** | integer | YES | Job card or work order number linked to the bill. | | FK |
 | **jobdate** | datetime | YES | Date the job card was created/processed. | | Filter |
 | **exciseno** | integer | YES | Excise record number (legacy tax reference). | | Filter |
 | **billdisplay** | string | YES | UI flag to determine if the bill should be visible. | "Y", "N" | Logic |
 | **rejper** | number | YES | Rejection percentage calculated for the lot. | e.g., 1.0 | Math |
 | **qtyrec** | number | YES | Total quantity received from the vendor. | | Math |
 | **wotype** | string | YES | Work Order Type. | e.g., "I " (In-house) | Logic |
 | **chwt** | number | YES | Challan weight or check weight. | | Math |
 | **rmrate** | number | YES | Raw material rate applicable. | | Math |
 | **uom** | string | YES | Unit of Measure. | e.g., "PCS", "KG" | Filter |
 | **ItemRate** | string | YES | Standard rate for the item. | | Math |
 | **wooprqty** | string | YES | Work order operation quantity. | | Math |
 | **JobRate** | string | YES | Rate specific to the job work performed. | | Math |
 
 ### 3) Relationships & Join Map
 
 #### Parent Tables (Authoritative Joins)
 * **vendmas**: Join on `vendcode` and `compcode` to retrieve vendor details (name, address, GST).
 * **itemmas**: Join on `itemcode` and `compcode` to retrieve part specifications and standard unit information.
 * **company**: Join on `compcode` to identify the legal entity.
 
 #### Child/Related Tables (Transactional Joins)
 * **billagainstwo**: Join on `billno`, `vendcode`, and `compcode` to see final posted billing status.
 * **jobhdr**: Join `jobno` to `jobcardno` (Likely) to track production details related to the billing.
 * **cmrrhdr**: Join on `mrpno` and `compcode` to link billing back to the original material receipt record.
 * **mrci_rep**: Join on `mrpno` and `itemcode` to reconcile against vendor inspection reports.