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| Column | Type | Nullable | Meaning |
|---|---|---|---|
compcode | string | No | Unique identifier for the company or business unit. |
chno | integer | No | Challan Number; unique identifier for the document within a year. |
chyear | integer | No | The financial year associated with the Challan. |
sno | integer | No | Serial number or line item sequence within a specific Challan. |
PackMode | string | Yes | The category or type of packing container used. |
ExDetail | string | Yes | Detailed description of the bin or tray material. |
ChQty | integer | Yes | The 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`