All tables
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
ColumnTypeNullableMeaning
indexintegerNOPrimary Key; Internal row identifier
compcodestringNOCompany Code
lineintegerNOLine sequence number. 1-99 for items; 100+ for taxes/charges
srnnonumberNOSupplementary Receipt Note Number
ItemnamestringYESDescription of the item, service, or tax head
uomstringYESUnit of Measure
MakestringYESManufacturer or Brand name
recqtynumberYESReceived Quantity
acptqtynumberYESAccepted Quantity
rejqtynumberYESRejected Quantity
ratenumberYESUnit Price / Rate
discountnumberYESDiscount percentage applied to the line
chqtynumberYESChallan (Invoiced) Quantity
amountnumberYESCalculated net amount for the line
amount1numberYESSecondary/Adjusted amount field
oldratenumberYESPrevious rate (used for price revision tracking)
olddiscnumberYESPrevious 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.