IV30300 - Inventory Transaction Amounts History
Stores line-level amounts for historical inventory transactions.
SQL Query Builder
23 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| TRXSORCE | char(13) '' | ||||
| DOCTYPE | smallint 0 | ||||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| DOCNUMBR | char(21) '' | ||||
| DOCDATE | datetime '1/1/1900' | ||||
| HSTMODUL | char(3) '' | ||||
| CUSTNMBR | char(15) '' | ||||
| ITEMNMBR | char(31) '' | ||||
| LNSEQNBR | numeric(19,5) 0 | ||||
| UOFM | char(9) '' | ||||
| 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 | ||||
| DECPLCUR | smallint 0 | ||||
| DECPLQTY | smallint 0 | ||||
| QTYBSUOM | numeric(19,5) 0.00 | ||||
| Reason_Code | char '' | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with IV30300. Click "Join" to add to your query.