transptmas

### 1. Overview
 The `transptmas` table serves as the central **Transporter Master** for the ERP system. It stores organizational details, contact information, physical addresses, and statutory identification (GSTIN/TransportID) for various logistics and freight service providers. It is heavily referenced across sales, invoicing, and job work modules to populate transport-related metadata for E-Way bill generation and physical documentation.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Internal surrogate primary key. | Auto-incrementing | `PRIMARY KEY` |
 | **compcode** | string | No | Company identifier for multi-tenant data partitioning. | e.g., "DAS" | `JOIN`, `WHERE` |
 | **tpcode** | string | No | Unique functional code for the transporter. | e.g., "TCI", "DTDC" | `JOIN`, `GROUP BY` |
 | **tpname** | string | Yes | Full registered name of the transport company. | e.g., "TCI EXPRESS" | `SELECT` |
 | **address1** | string | Yes | Primary address line (Building/Street). | | `SELECT` |
 | **address2** | string | Yes | Secondary address line (Area/City). | | `SELECT` |
 | **address3** | string | Yes | Tertiary address line (State/Pincode). | | `SELECT` |
 | **contact** | string | Yes | Name of the primary contact person. | | `SELECT` |
 | **resiphone** | string | Yes | Residential or personal phone number. | | `SELECT` |
 | **offphone** | string | Yes | Official or office phone number. | | `SELECT` |
 | **fax** | string | Yes | Fax number for documentation. | | `SELECT` |
 | **username** | string | Yes | The user who created or last modified the entry. | e.g., "system" | `AUDIT` |
 | **TransportID** | string | Yes | The GST Registration Number or E-Way Bill Transporter ID. | e.g., "06AADCT0663J4Z9" | `SELECT` |
 
 ### 3. Relationships & Join Map
 
 The `transptmas` table is a foundational master referenced by almost every header table involving the movement of goods.
 
 #### Critical Joins (Based on SCHEMA_MAP)
 * **Sales & Invoicing:**
  * `dbo.invhdr` (tpcode, compcode): To retrieve transporter details for outbound sales invoices.
  * `dbo.invdesphdr` (tpcode, compcode): Used in dispatch-specific invoicing logic.
  * `dbo.Performainvhdr` (tpcode, compcode): For transporter info on proforma documents.
 * **Job Work & Logistics:**
  * `dbo.jobhdr` (tpcode, compcode): Links transporters to primary job card headers.
  * `dbo.job` (tpcode, compcode): Links transporters to specific job records.
  * `dbo.desp1stjob` / `dbo.desp2job` (tpcode, compcode): Tracks which transporter handled specific job dispatches.
 * **Returns & Challans:**
  * `dbo.rgphdr` (tpcode, compcode): Links transporters to Returnable Gate Pass documents.
  * `dbo.ScrapChallan` (tpcode, compcode): Links transporters to scrap movement.
 * **Financials:**
  * `dbo.Debithdr` (tpcode, compcode): Used when freight charges or transport-related debits are processed.
  * `dbo.transentry` (tpcode, compcode): Detailed log of transporter bill entries.
 
 #### Join Example (SQL)
 ```sql
 SELECT 
  h.invno, 
  t.tpname, 
  t.TransportID as Transporter_GSTIN 
 FROM dbo.invhdr h
 INNER JOIN dbo.transptmas t 
  ON h.tpcode = t.tpcode 
  AND h.compcode = t.compcode;
 ```