temptotaloutvsinfromvendor

### 1) Overview
 The `temptotaloutvsinfromvendor` table is a summary or reconciliation table designed to track the flow of items sent to and received from specific vendors. It serves as a performance or inventory balance report, comparing the total quantity dispatched for processing ("Go Pieces") against the total quantity returned/received ("Received Pieces"). This is commonly used in manufacturing for subcontracted operations or job work tracking.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key | 0, 1, 2... | Internal row identifier. |
 | **compcode** | string | No | Company Identifier | e.g., "DAS" | Join anchor for company filtering. |
 | **vendcode** | string | No | Vendor unique code | e.g., "AE", "AGI" | Join anchor for vendor master data. |
 | **itemcode** | string | No | Part/Item unique code | e.g., "CP-192", "0094" | Join anchor for item master data. |
 | **uom** | string | Yes | Unit of Measure | PCS, KGS | Used for quantity context. |
 | **gopcs** | number | Yes | Total Outgoing Quantity | Positive numbers | Total pieces/weight sent out to vendor. |
 | **recpcs** | number | Yes | Total Received Quantity | Positive numbers | Total pieces/weight received from vendor. |
 
 ### 3) Relationships & Join Map
 
 This table acts as a bridge between vendor transactions and inventory status.
 
 #### Primary Join Anchors:
 * **compcode, vendcode**: Links to vendor profiles.
 * **compcode, itemcode**: Links to product and part definitions.
 
 #### Logical Joins (Strictly per SCHEMA_MAP):
 
 * **Vendor Master (`dbo.vendmas`)**: To retrieve vendor names and contact details.
  * `JOIN dbo.vendmas ON temptotaloutvsinfromvendor.vendcode = vendmas.vendcode AND temptotaloutvsinfromvendor.compcode = vendmas.compcode`
 * **Item Master (`dbo.itemmas`)**: To retrieve item descriptions and technical specs.
  * `JOIN dbo.itemmas ON temptotaloutvsinfromvendor.itemcode = itemmas.itemcode AND temptotaloutvsinfromvendor.compcode = itemmas.compcode`
 * **Vendor Item Operations (`dbo.itemvendopr`)**: To check standard rates or allowed operations for this vendor/item pair.
  * `JOIN dbo.itemvendopr ON temptotaloutvsinfromvendor.itemcode = itemvendopr.itemcode AND temptotaloutvsinfromvendor.vendcode = itemvendopr.vendcode AND temptotaloutvsinfromvendor.compcode = itemvendopr.compcode`
 * **Job Work (`dbo.job`)**: To find the specific transaction history (Challans) that contributed to the `gopcs` and `recpcs`.
  * `JOIN dbo.job ON temptotaloutvsinfromvendor.vendcode = job.vendcode AND temptotaloutvsinfromvendor.itemcode = job.itemcode AND temptotaloutvsinfromvendor.compcode = job.compcode`
 * **Material Receipt (`dbo.mrcirhdr`)**: To reconcile against specific vendor receipt documents.
  * `JOIN dbo.mrcirhdr ON temptotaloutvsinfromvendor.vendcode = mrcirhdr.vendcode AND temptotaloutvsinfromvendor.compcode = mrcirhdr.compcode`