DownTime100DTL

### 1. Overview
 The `DownTime100DTL` table serves as a granular detail repository for downtime events recorded during specific production runs. It is primarily used in manufacturing analytics to calculate **OEE (Overall Equipment Effectiveness)** and generate downtime distribution reports. 
 
 As a child table to `DownTime100HDR`, it decomposes total production downtime into specific reason codes and durations. Data in the `downtime` column is typically stored in an **HH.MM** format, which requires mathematical conversion (e.g., `(floor(downtime)*60 + (downtime - floor(downtime))*100)`) to calculate total minutes for reporting.
 
 ### 2. Column Dictionary
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key. Unique identifier for the detail record. | Auto-incrementing | `WHERE index = 10` |
 | **compcode** | string | NO | Company Code. Acts as a multi-tenant partition key. | e.g., "DAS", "HFL" | `JOIN ... ON p.compcode = q.compcode` |
 | **prodno** | integer | NO | Production Number. Links the downtime to a specific production header record. | e.g., 567, 570 | `JOIN ... ON p.prodno = q.prodno` |
 | **downtimereason** | integer | NO | Foreign Key to `downtimemas`. Numeric code identifying why the machine stopped. | e.g., 3, 40 | `JOIN downtimemas ON downtimereason = downcode` |
 | **downtime** | number | YES | Duration of the downtime. Stored in HH.MM format (Likely). | e.g., 11.3 (11h 30m) | `SUM(floor(downtime)*60 + (downtime-floor(downtime))*100)` |
 
 ### 3. Relationships & Join Map
 
 #### Parent Table
 * **DownTime100HDR**: `DownTime100DTL` is a child table. 
  * *Join Logic:* `DownTime100DTL.prodno = DownTime100HDR.prodno` AND `DownTime100DTL.compcode = DownTime100HDR.compcode`.
 
 #### Reference Tables
 * **downtimemas**: Provides the descriptive labels for `downtimereason`.
  * *Join Logic:* `DownTime100DTL.downtimereason = downtimemas.downcode` AND `DownTime100DTL.compcode = downtimemas.compcode`.
 * **oprstationmas**: Linked via `downtimemas` to identify the machine station.
  * *Join Logic:* `downtimemas.stationcode = oprstationmas.stationcode`.
 
 #### Production Links
 * **product1 / product2**: Linked via `prodno` to correlate machine downtime with specific production yields and batches.
  * *Join Logic:* `DownTime100DTL.prodno = product2.prodno` (Confirmed via `DownTimeReport_Concise`).
 
 #### Recommended Join Map
 ```sql
 SELECT 
  h.proddate,
  h.mccode AS machine_code,
  m.downreason,
  d.downtime
 FROM dbo.DownTime100DTL d
 INNER JOIN dbo.DownTime100HDR h 
  ON d.prodno = h.prodno 
  AND d.compcode = h.compcode
 LEFT JOIN dbo.downtimemas m 
  ON d.downtimereason = m.downcode 
  AND d.compcode = m.compcode
 ```