RM_SF_Purchase_Bill

### 1) Overview
 The `RM_SF_Purchase_Bill` table serves as a financial sub-ledger for Raw Material (RM) and Semi-Finished (SF) purchase transactions. It records supplier invoices (bills), tax breakdowns (CGST, SGST, IGST), and voucher authorization statuses. Each record typically represents a line item or a header summary of a purchase bill that links physical material receipts to financial accounting.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key (internal) | Auto-incrementing | `WHERE index = 10` |
 | **CompCode** | string | NO | Company Identifier | e.g., "DAS" | `ON a.CompCode = b.compcode` |
 | **MRPDate** | datetime | YES | Material Receipt/Plan Date | | `ORDER BY MRPDate DESC` |
 | **VouNo** | number | YES | Internal Accounting Voucher Number | | `JOIN on VouNo` |
 | **VouDesc** | string | YES | Human-readable voucher reference | e.g., "SF/92024/1" | `LIKE 'SF%'` |
 | **VouDate** | datetime | YES | Date the voucher was generated | | `WHERE VouDate >= '2024-01-01'` |
 | **BillNo** | number | YES | Supplier's Invoice Number | | `WHERE BillNo = 481.0` |
 | **BillDate** | string | YES | Date on the supplier's invoice | ISO Date Strings | |
 | **SupCode** | string | YES | Supplier/Vendor Unique Code | e.g., "SI", "VSSL" | `JOIN dbo.suppmas (supcode)` |
 | **AccountCode** | string | YES | General Ledger account code | | Likely for GL mapping |
 | **Amount** | number | YES | Total bill amount (including taxes) | | `SUM(Amount)` |
 | **Dr_Cr** | string | YES | Debit or Credit indicator | "Dr", "Cr" | `WHERE Dr_Cr = 'Cr'` |
 | **Taxable_Amt**| string | YES | Net amount before tax | | `CAST(Taxable_Amt AS DECIMAL)` |
 | **cgst_amt** | string | YES | Central GST Amount | | |
 | **sgst_amt** | string | YES | State GST Amount | | |
 | **igst_amt** | string | YES | Integrated GST Amount | | |
 | **Other_Amt** | string | YES | Miscellaneous charges (freight, etc) | | |
 | **Narration** | string | YES | Remarks or combined bill/date string | e.g., "481/10.09.2024" | |
 | **Line_No** | integer | YES | Line sequence within the voucher | | `WHERE Line_No = 1` |
 | **Vou_Auth_Flag**| string | YES | Voucher Authorization status | "Y" (Yes), "N" (No) | `WHERE Vou_Auth_Flag = 'N'` |
 
 ### 3) Relationships & Join Map
 
 The table connects financial billing data to supplier masters and material receipt headers.
 
 #### Primary Joins (SCHEMA_MAP Verified):
 * **dbo.suppmas**: Join via `SupCode` to `supcode` (and `CompCode` to `compcode`) to retrieve supplier names and tax details.
 * **dbo.vendmas**: Join via `SupCode` to `vendcode` (and `CompCode` to `compcode`) for vendor contact information.
 * **dbo.rmincoming**: Join via `VouNo` to `vouno` (and `CompCode` to `compcode`) to link the bill to the specific Raw Material receipt.
 * **dbo.fghdr**: Join via `VouNo` to `vouno` (and `CompCode` to `compcode`) for Semi-Finished/Finished goods receipt tracking.
 * **dbo.incomconitem**: Join via `VouNo` to `vouno` (and `CompCode` to `compcode`) to link incoming consumable items to their billing record.
 
 #### Likely Joins (Inferred):
 * **dbo.financialyear**: Likely filtered by `CompCode` to determine the fiscal period for `VouDate`.
 
 ---