rmpotabitemamnd

### 1) Overview
 The `rmpotabitemamnd` table serves as the historical or amendment-specific record for raw material items within a Purchase Order (PO). It tracks changes made to specific items (identified by `rmcode` and `sno`) for a given PO number (`pono`) and amendment sequence (`amndno`). This table is critical for auditing PO history and printing previous versions of Purchase Orders in the ERP system.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key identifier for the record | 0, 1, 2... | PK |
 | **compcode** | string | No | Unique identifier for the company | e.g., "DAS" | Join; Filter |
 | **pono** | integer | No | Purchase Order Number | e.g., 1 | Join; Filter |
 | **amndno** | integer | No | Amendment Number (0 = Original, >0 = Amendments) | 0, 1, 2... | Join; Versioning |
 | **rmcode** | string | No | Raw Material Item Code | e.g., "ROD27.50" | Join; Filter |
 | **uom** | string | Yes | Unit of Measure | e.g., "KGS" | Aggregate |
 | **qty** | number | Yes | Quantity of raw material ordered | e.g., 50.5 | Aggregate |
 | **rmrate** | number | Yes | Price per unit of the raw material | e.g., 50.0 | Aggregate |
 | **invyear** | integer | No | Inventory/Financial Year | e.g., 2013 | Join; Filter |
 | **br_code** | integer | Yes | Brand or Make Code | e.g., 1 | Join (brandmas) |
 | **hsn** | string | Yes | Harmonized System of Nomenclature code for taxation | e.g., "7214" | Reporting |
 | **sno** | string | Yes | Serial number/Line item number within the PO | e.g., "1" | Join; Ordering |
 | **rmexdetail** | string | Yes | Extended details or technical specifications for the RM | | Descriptive |
 
 ### 3) Relationships & Join Map
 
 The table is a child record of the Purchase Order Amendment Header and relates to master data for material and brand definitions.
 
 #### Primary Joins (Authoritative):
 * **dbo.rmpotabamnd**: Joins on `compcode`, `pono`, `invyear`, and `amndno`. This links the item amendment to its corresponding header amendment.
 * **dbo.rmmas**: Joins on `compcode` and `rmcode`. Used to retrieve raw material descriptions (`rmname`).
 * **dbo.brandmas**: Joins on `compcode` and `br_code`. Used to identify the specific brand/make of the raw material.
 
 #### Likely Joins (Inferred):
 * **dbo.rmpotabitem**: Joins on `compcode`, `pono`, and `rmcode`. Links the historical amendment to the current/active item record.
 * **dbo.rmindent**: Joins on `compcode` and `pono` (via `rmpotabamnd.indentno`) to track the source requirement.