tables · table
srntemp
The srntemp table serves as a temporary transaction repository for Supplementary Receipt Note (SRN) line items. It stores granular data for incoming materials, including quantities (received, accepted, rejected), pricing, and discounts. Uniquely, this table also captures non-inventory financial overheads such as Freight, IGST, and Round-off values, typically identified by specific line number ranges (e.g., Line 100+).
Row count
9
Last entry
—
Source
tables
Columns
17| Column | Type | Nullable | Meaning |
|---|---|---|---|
index | integer | NO | Primary Key; Internal row identifier |
compcode | string | NO | Company Code |
line | integer | NO | Line sequence number. 1-99 for items; 100+ for taxes/charges |
srnno | number | NO | Supplementary Receipt Note Number |
Itemname | string | YES | Description of the item, service, or tax head |
uom | string | YES | Unit of Measure |
Make | string | YES | Manufacturer or Brand name |
recqty | number | YES | Received Quantity |
acptqty | number | YES | Accepted Quantity |
rejqty | number | YES | Rejected Quantity |
rate | number | YES | Unit Price / Rate |
discount | number | YES | Discount percentage applied to the line |
chqty | number | YES | Challan (Invoiced) Quantity |
amount | number | YES | Calculated net amount for the line |
amount1 | number | YES | Secondary/Adjusted amount field |
oldrate | number | YES | Previous rate (used for price revision tracking) |
olddisc | number | YES | Previous discount (used for revision tracking) |
Full documentation
### 1) Overview The `srntemp` table serves as a temporary transaction repository for **Supplementary Receipt Note (SRN)** line items. It stores granular data for incoming materials, including quantities (received, accepted, rejected), pricing, and discounts. Uniquely, this table also captures non-inventory financial overheads such as Freight, IGST, and Round-off values, typically identified by specific line number ranges (e.g., Line 100+). ### 2) Column Dictionary | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage | | :--- | :--- | :--- | :--- | :--- | :--- | | **index** | integer | NO | Primary Key; Internal row identifier | | PK | | **compcode** | string | NO | Company Code | e.g., "DAS" | FK / Filter | | **line** | integer | NO | Line sequence number. 1-99 for items; 100+ for taxes/charges | 1, 100, 999 | Sort / Group | | **srnno** | number | NO | Supplementary Receipt Note Number | e.g., 54156 | Join / Filter | | **Itemname** | string | YES | Description of the item, service, or tax head | e.g., "IGST", "FREIGHT" | Display | | **uom** | string | YES | Unit of Measure | NOS, KGS | Conversion | | **Make** | string | YES | Manufacturer or Brand name | | Filter | | **recqty** | number | YES | Received Quantity | | Calculation | | **acptqty** | number | YES | Accepted Quantity | | Calculation | | **rejqty** | number | YES | Rejected Quantity | | Calculation | | **rate** | number | YES | Unit Price / Rate | | Calculation | | **discount** | number | YES | Discount percentage applied to the line | | Calculation | | **chqty** | number | YES | Challan (Invoiced) Quantity | | Audit | | **amount** | number | YES | Calculated net amount for the line | | Aggregate | | **amount1** | number | YES | Secondary/Adjusted amount field | | Aggregate | | **oldrate** | number | YES | Previous rate (used for price revision tracking) | | Audit | | **olddisc** | number | YES | Previous discount (used for revision tracking) | | Audit | ### 3) Relationships & Join Map The `srntemp` table acts as the detail (child) table for SRN transactions. It is frequently joined with header tables and duty breakdown tables to reconstruct a full voucher. #### Joins (Authoritative via SCHEMA_MAP): * **srnhdrtemp**: (Likely Join) Joined on `compcode`. Note: While `srnno` is used here, it typically maps to `vouno` or `mrpno` in the header table `srnhdrtemp` to retrieve invoice dates and supplier details. * **srnduty**: (Likely Join) Joined on `compcode`. Used to fetch specific duty/tax breakdowns associated with the receipt note. * **semidtl**: (Logical Mirror) This table shares nearly identical structure (`line`, `itemname`, `recqty`, `acptqty`, `rate`) and is often used in parallel workflows for semi-finished goods receipts. * **UoMMaster**: Joined on `uom` (srntemp) = `PUoM` (UoMMaster) to validate or convert units.