rmjobrec1st

This table, **`rmjobrec1st`**, serves as the primary transaction log for the first stage of raw material receipt and processing for job cards within the production system. it tracks how raw materials (identified by `rmcode`) are converted into specific items (`itemcode`) under a Parent Job Card (`pjobcardno`) and a Material Requirement Planning number (`mrpno`). It captures critical metrics such as raw material weight, item quantity, gate pass details, and the specific operation code (`nOprCode`) applied at this stage.
 
 ### 1. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key | 0, 1, 2... | PK for identifying unique record. |
 | **compcode** | string | No | Company Identifier | e.g., "DAS", "RF2" | Part of Composite FK for almost all joins. |
 | **mrpno** | integer | No | MRP Transaction Number | 1419, 2291 | Primary reference for material tracking across stages. |
 | **mrpdate** | datetime | No | Date of MRP Entry | | Used for chronological reporting and aging. |
 | **pjobcardno** | number | No | Parent Job Card Number | 473, 1 | Links to the master production order. |
 | **pjobdate** | datetime | No | Date job card was created | | Used to track lead times. |
 | **custcode** | string | No | Customer Code | e.g., "BAP-M" | FK to `dbo.cust`. |
 | **rmcode** | string | No | Raw Material Code | e.g., "BR22", "ROD50" | FK to `dbo.rmmas`. |
 | **rmwt** | number | No | Total Raw Material Weight | | Used to calculate yield and material balance. |
 | **itemcode** | string | No | Produced Item Code | e.g., "BWAUTO", "GC1" | FK to `dbo.itemmas`. |
 | **itemqty** | number | No | Quantity of Items Produced | | Used for inventory updates. |
 | **lotno** | string | No | Production Batch/Lot Number | | Used for traceability (`ltrim` often required). |
 | **remarks** | string | Yes | Transaction Notes | "-" | Optional commentary. |
 | **useradd** | string | Yes | User who created the record | "system", "devender" | Audit trail. |
 | **addtime** | string | Yes | Timestamp of addition | | Audit trail. |
 | **usermod** | string | Yes | User who last modified record | | Audit trail. |
 | **modtime** | string | Yes | Timestamp of last modification | | Audit trail. |
 | **gpno** | integer | Yes | Gate Pass Number | | Links to inward gate entry logistics. |
 | **gpdate** | datetime | Yes | Gate Pass Date | | Used in gate entry reports. |
 | **wono** | number | Yes | Work Order Number | | Cross-reference to sales/planning. |
 | **wodate** | datetime | Yes | Work Order Date | | Cross-reference to sales/planning. |
 | **woyear** | integer | Yes | Work Order Year | 2014, 2015 | Used for partitioning data by fiscal year. |
 | **heatno** | string | Yes | Material Heat Number | | Quality and metallurgical traceability. |
 | **txntype** | string | Yes | Transaction Category | NULL | Likely for internal classification. |
 | **coilno** | string | Yes | Specific Coil identifier | | Used for wire/coil processing tracking. |
 | **noofcoil** | string | Yes | Count of coils received | | Bulk material tracking. |
 | **itemvalue** | number | Yes | Monetary value of the item | | Used for financial/valuation reporting. |
 | **location** | string | Yes | Physical Storage Location | | Links to `dbo.location`. |
 | **TraceNo** | string | Yes | Traceability Identifier | | Likely links to `dbo.rmincoming`. |
 | **nOprCode** | string | Yes | Next/Current Operation Code | "BC", "HOT" | FK to `dbo.oprmas` (oprcode). |
 | **chwt** | number | Yes | Charge Weight per Unit | 350.0, 250.0 | Weight of a single piece (in grams/units). |
 | **JobDoc** | string | Yes | Document Reference | | Often matches `pjobcardno`. |
 | **AdjQty** | string | Yes | Adjusted Quantity | | Used for stock corrections. |
 
 ### 2. Relationships & Join Map
 
 #### Authoritative Joins (via SCHEMA_MAP)
 * **`dbo.itemmas`**: Join via `compcode` and `itemcode`. Used to retrieve `itemname` and `itemrate`.
 * **`dbo.rmmas`**: Join via `compcode` and `rmcode`. Used to retrieve `rmname` and material properties.
 * **`dbo.cust`**: Join via `compcode` and `custcode`. Used to retrieve `custname`.
 * **`dbo.oprmas`**: Join via `compcode` and `nOprCode` (maps to `oprmas.oprcode`). Used to retrieve operation names.
 * **`dbo.desp1stjob`**: Join via `compcode` and `mrpno`. Used to track outward movement of items produced in this 1st stage.
 * **`dbo.rmreturncust`**: Join via `compcode` and `mrpno`. Tracks returns of material to the customer.
 * **`dbo.rmincoming`**: Join via `compcode` and `mrpno`. Tracks the source raw material purchase or stock entry.
 * **`dbo.mchdr`**: Join via `compcode` and `mrpno`. Links job receipt to in-house machine processing.
 
 #### Likely Joins (Logical Inference)
 * **`dbo.rmjobrec1stdtl`**: Join via `compcode`, `mrpno`, and `itemcode`. Likely contains operation-level rate details for this transaction.
 * **`dbo.location`**: Join via `compcode` and `location`.