IV10001 - Inventory Transaction Work Detail
Stores line detail for unposted inventory transactions.
SQL Query Builder
21 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| IVDOCNBR | char(17) '' | |||
| IVDOCTYP | smallint 0 | |||
| ITEMNMBR | char(31) '' | |||
| LNSEQNBR | numeric(19,5) 0 | |||
| UOFM | char(9) '' | |||
| QTYBSUOM | numeric(19,5) 0.00 | |||
| TRXQTY | numeric(19,5) 0.00 | |||
| UNITCOST | numeric(19,5) 0.00 | |||
| EXTDCOST | numeric(19,5) 0.00 | |||
| TRXLOCTN | char(11) '' | |||
| TRNSTLOC | char(11) '' | |||
| TRFQTYTY | smallint 0 | |||
| TRTQTYTY | smallint 0 | |||
| IVIVINDX | int 0 | |||
| IVIVOFIX | int 0 | |||
| IVWLNMSG | binary(4) 0 | |||
| DECPLCUR | smallint 0 | |||
| DECPLQTY | smallint 0 | |||
| USAGETYPE | smallint 0 | |||
| DEX_ROW_ID | int auto number (1,1) | |||
| Reason_Code | char '' |
Related Tables
Tables that share columns with IV10001. Click "Join" to add to your query.