packingmaster

### 1) Overview
 The `packingmaster` table serves as a central registry for defining various packaging modes (e.g., "TANKI", "BOX", "TRAY") and their associated standard weights. This master data is referenced across sales, shipping, and inventory modules to calculate total weights and standardize packaging descriptions on documents like invoices and delivery challans.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Unique internal identifier for the record. | Primary Key | `WHERE index = 0` |
 | **compcode** | string | No | The unique identifier for the company/organization unit. | e.g., "DAS" | `JOIN ... ON p.compcode = i.compcode` |
 | **packmode** | string | No | The name or code of the packaging method. | e.g., "TANKI", "BOX" | `JOIN ... ON p.packmode = i.packmode` |
 | **packweight** | number | Yes | The standard weight associated with this specific packaging mode. | e.g., 0.00, 15.50 | `SELECT packweight FROM ...` |
 
 ### 3) Relationships & Join Map
 
 The `packmode` defined here is a high-priority reference used throughout the ERP system for logistics and invoicing.
 
 #### Physical Joins (Authoritative)
 - **dbo.invdtl** (Sales Invoice Details)
  - Join on: `compcode`, `packmode`
 - **dbo.Performainvdtl** (Proforma Invoice Details)
  - Join on: `compcode`, `packmode`
 - **dbo.Debitdtl** (Debit Note Details)
  - Join on: `compcode`, `packmode`
 - **dbo.ChallanBinTrayDTL** (Inventory/Bin Details)
  - Join on: `compcode`, `PackMode` (Case-insensitive match)
 
 #### Logical/Inferred Joins (Likely)
 - **dbo.itemmas** (Item Master)
  - Join on: `compcode` and `packingmaster.packmode = itemmas.modepack` (Standardizes default packaging for items).
 - **dbo.job** (Job Card/Production)
  - Join on: `compcode` and `packingmaster.packmode = job.modepack`.
 - **dbo.podtl** (Purchase/Sales Order Details)
  - Join on: `compcode` and `packingmaster.packmode = podtl.modepack`.
 - **dbo.ScrapChallan** (Waste Management)
  - Join on: `compcode` and `packingmaster.packmode = ScrapChallan.modepack`.