IV00300 - Lot Number Master
Stores lot number records for lot-tracked inventory items.
SQL Query Builder
17 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ITEMNMBR | char(31) '' | ||||
| LOCNCODE | char(11) '' | ||||
| DATERECD | datetime '1/1/1900' | ||||
| DTSEQNUM | numeric(19,5) 0.00 | ||||
| LOTNUMBR | char(21) '' | ||||
| QTYRECVD | numeric(19,5) 0.00 | ||||
| QTYSOLD | numeric(19,5) 0.00 | ||||
| ATYALLOC | numeric(19,5) 0.00 | ||||
| UNITCOST | numeric(19,5) 0.00 | ||||
| RCTSEQNM | int 0 | ||||
| VNDRNMBR | char(25) '' | ||||
| LTNUMSLD | tinyint 0 | ||||
| QTYTYPE | smallint 0 | ||||
Quantity Type values (5) 1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged | |||||
| BIN | char(15) '' | ||||
| MFGDATE | datetime '1/1/1900' | ||||
| EXPNDATE | datetime '1/1/1900' | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with IV00300. Click "Join" to add to your query.