IV10200 - Purchase Receipts Header
Stores purchase receipt layer headers used by FIFO/LIFO valuation methods to track cost layers.
SQL Query Builder
22 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ITEMNMBR | char(31) '' | ||||
| TRXLOCTN | char(11) '' | ||||
| DATERECD | datetime '1/1/1900' | ||||
| RCTSEQNM | int 0 | ||||
| RCPTSOLD | tinyint 0 | ||||
| QTYRECVD | numeric(19,5) 0.00 | ||||
| QTYSOLD | numeric(19,5) 0.00 | ||||
| QTYCOMTD | numeric(19,5) 0.00 | ||||
| QTYRESERVED | numeric(19,5) 0.00 | ||||
| FLRPLNDT | datetime '1/1/1900' | ||||
| PCHSRCTY | smallint 0 | ||||
Purchase Receipt Type values (8) 1 = Adjustment2 = Variance3 = Transfer4 = Override5 = Receipt6 = Return7 = Assembly8 = In-Transit | |||||
| RCPTNMBR | char(21) '' | ||||
| VENDORID | char(15) '' | ||||
| PORDNMBR | char(21) '' | ||||
| UNITCOST | numeric(19,5) 0.00 | ||||
| QTYTYPE | smallint 0 | ||||
Quantity Type values (5) 1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged | |||||
| Landed_Cost | tinyint 0 | ||||
| NEGQTYSOPINV | tinyint 0 | ||||
| VCTNMTHD | smallint 0 | ||||
Valuation Method values (5) 1 = FIFO Perpetual2 = LIFO Perpetual3 = Average Perpetual4 = FIFO Periodic5 = LIFO Periodic | |||||
| ADJUNITCOST | numeric(19,5) 0.00 | ||||
| QTYONHND | numeric(19,5) 0.00 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Reporting Tips
- - Quantities stored in base unit of measure
- - Original U of M from PO is in POP tables
Related Tables
Tables that share columns with IV10200. Click "Join" to add to your query.