tables · table

sfindentitem

The sfindentitem table serves as the line-item detail repository for Semi-Finished (SF) Material Indents. It stores specific requirements for items, including requested quantities, estimated rates, and units of measure, linked to a parent indent header (sfindent). This table is a critical component in the procurement and inventory planning workflow, used to track balance quantities between what was requested (indent) and what has been ordered via Purchase Orders (sfpo).

Row count

220

Last entry

—

Source

tables

Columns

Column	Type	Nullable	Meaning
`index`	integer	NO	Internal primary key / row identifier.
`compcode`	string	NO	Company identifier code.
`indentno`	integer	NO	The unique identifier for the Indent document.
`itemcode`	string	NO	The physical code of the SF item or product.
`uom`	string	YES	Unit of Measure for the item.
`indentqty`	number	YES	The quantity of material requested in the indent.
`itemrate`	number	YES	Estimated or standard rate per unit for the item.
`Lock`	string	YES	Status flag indicating if the line item is locked.

Full documentation

### 1) Overview
 The `sfindentitem` table serves as the line-item detail repository for **Semi-Finished (SF) Material Indents**. It stores specific requirements for items, including requested quantities, estimated rates, and units of measure, linked to a parent indent header (`sfindent`). This table is a critical component in the procurement and inventory planning workflow, used to track balance quantities between what was requested (indent) and what has been ordered via Purchase Orders (`sfpo`).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Internal primary key / row identifier. | | PK |
 | **compcode** | string | NO | Company identifier code. | e.g., "DAS" | Join Key |
 | **indentno** | integer | NO | The unique identifier for the Indent document. | | Join Key / FK |
 | **itemcode** | string | NO | The physical code of the SF item or product. | e.g., "CP-179", "LCBS2" | Join Key / FK |
 | **uom** | string | YES | Unit of Measure for the item. | e.g., "PCS", "KGS" | Informational |
 | **indentqty** | number | YES | The quantity of material requested in the indent. | | Aggregation |
 | **itemrate** | number | YES | Estimated or standard rate per unit for the item. | | Calculation |
 | **Lock** | string | YES | Status flag indicating if the line item is locked. | "N", "Y", NULL | Filter |
 
 ### 3) Relationships & Join Map
 
 The table functions as a child to the indent header and a reference to the item master. It is also used to reconcile requirements against purchase orders.
 
 #### Primary Joins (Authoritative)
 * **sfindent (Header)**: Joined on `compcode` and `indentno`. This link provides the indent date and purpose.
 * **itemmas (Item Master)**: Joined on `compcode` and `itemcode`. Used to retrieve the descriptive `itemname` and `partno`.
 * **sfpo (SF Purchase Order Header)**: Joined on `compcode` and `indentno` (Likely). Used to track which purchase orders were raised against this specific indent.
 
 #### Indirect Joins (Logical)
 * **sfpoitem (SF PO Details)**: Joined via a bridge through `sfpo` or directly on `compcode` and `itemcode` to calculate `poqty` (Ordered Quantity) vs `indentqty` (Requested Quantity).
 
 ---