All tables
tables · table

ChallanBinTrayDTL

The ChallanBinTrayDTL table stores line-item details for Challans (movement documents) specifically related to the distribution and tracking of packing containers such as bins, trays, or mesh cages. It records the specific packing mode, descriptive details of the container used, and the quantities issued. It is primarily used for managing returnable or non-returnable packaging material inventory between the company and its partners (customers, vendors, or suppliers).

Row count
1
Last entry
Source
tables

Columns

7
ColumnTypeNullableMeaning
compcodestringNoUnique identifier for the company or business unit.
chnointegerNoChallan Number; unique identifier for the document within a year.
chyearintegerNoThe financial year associated with the Challan.
snointegerNoSerial number or line item sequence within a specific Challan.
PackModestringYesThe category or type of packing container used.
ExDetailstringYesDetailed description of the bin or tray material.
ChQtyintegerYesThe quantity of bins/trays issued in this line item.

Full documentation

### 1) Overview
 The `ChallanBinTrayDTL` table stores line-item details for Challans (movement documents) specifically related to the distribution and tracking of packing containers such as bins, trays, or mesh cages. It records the specific packing mode, descriptive details of the container used, and the quantities issued. It is primarily used for managing returnable or non-returnable packaging material inventory between the company and its partners (customers, vendors, or suppliers).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **compcode** | string | No | Unique identifier for the company or business unit. | e.g., "DAS" | Primary Join Key |
 | **chno** | integer | No | Challan Number; unique identifier for the document within a year. | e.g., 1 | Join Key |
 | **chyear** | integer | No | The financial year associated with the Challan. | e.g., 2020 | Join Key |
 | **sno** | integer | No | Serial number or line item sequence within a specific Challan. | 1, 2, 3... | Unique Line Identifier |
 | **PackMode** | string | Yes | The category or type of packing container used. | e.g., "TANKI", "IRON MESH BIN" | Categorization |
 | **ExDetail** | string | Yes | Detailed description of the bin or tray material. | e.g., "IRON MESH BIN FOR FORGING..." | Descriptive |
 | **ChQty** | integer | Yes | The quantity of bins/trays issued in this line item. | e.g., 20 | Quantitative Analysis |
 
 ### 3) Relationships & Join Map
 
 #### Parent Table
 * **dbo.ChallanBinTrayHDR**: This table acts as the header for these details.
  * **Join Condition**: `ChallanBinTrayDTL.compcode = ChallanBinTrayHDR.compcode` AND `ChallanBinTrayDTL.chno = ChallanBinTrayHDR.chno` AND `ChallanBinTrayDTL.chyear = ChallanBinTrayHDR.chyear`
 
 #### Reference Joins (Likely)
 * **dbo.packingmaster**: Used to validate or retrieve master settings for packing types.
  * **Join Condition**: `ChallanBinTrayDTL.PackMode = packingmaster.packmode` (Likely)
 * **dbo.CompanyConfig**: Used to retrieve company-specific configurations for challan processing.
  * **Join Condition**: `ChallanBinTrayDTL.compcode = CompanyConfig.compcode`