assemblyproddtl

### 1) Overview
 The `assemblyproddtl` table serves as the **line-item detail for assembly production transactions**. It records the specific components (`itemcode`) and their respective quantities (`itemqty`) consumed during a production run defined in the header table. This table is critical for inventory reconciliation, calculating Work-in-Progress (WIP), and determining Finished Goods (FG) stock levels by tracking how many child components were subtracted from stock to produce a parent assembly.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Internal unique identifier for the record. | e.g., 0, 1, 2 | Primary Key |
 | **compcode** | string | No | The unique code identifying the specific company or branch. | e.g., "DAS", "BPL" | Join key to `assemblyprodhdr`, `itemmas` |
 | **prodno** | integer | No | Reference number of the assembly production transaction. | e.g., 1, 2, 8 | Join key to `assemblyprodhdr` |
 | **assycode** | string | No | The code representing the parent assembly item being produced. | e.g., "LEVERKVE", "SPROCKET" | Join key to `assemblyprodhdr` (assycode) |
 | **itemcode** | string | No | The unique code for the child component/item consumed in the assembly. | e.g., "CP-300", "SPF" | Join key to `itemmas` (itemcode) |
 | **itemqty** | integer | No | The quantity of the specific component item used in this production run. | e.g., 0, 765, 3263 | Aggregated in WIP/Stock reports |
 
 ### 3) Relationships & Join Map
 
 The table serves as the "Many" side in a Master-Detail relationship with the assembly header.
 
 #### Primary Joins (Authoritative):
 * **dbo.assemblyprodhdr**: Joined via (`compcode`, `prodno`) and (`assycode`). This provides the production date, shift, and total quantity of the parent item produced.
 * **dbo.itemmas**: Joined via (`compcode`, `itemcode`) to retrieve part numbers, item names, and unit of measures (UOM) for the components.
 
 #### Logical Joins (Likely):
 * **dbo.goodreceipt**: Linked via (`compcode`, `itemcode`) to track the deduction of components from received inventory during assembly.
 * **dbo.onlinerej_dtl**: Linked via (`compcode`, `itemcode`) to compare consumed quantities against rejected components during the same production run.
 
 ---