IV00108 - Item Price List
Stores actual item prices by currency, U of M, and price level. This is where GP looks up selling prices.
SQL Query Builder
10 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| ITEMNMBR | char(31) '' | |||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char(15) '' | ||
| PRCLEVEL | char(11) '' | |||
| UOFM | char(9) '' | |||
| TOQTY | numeric(19,5) 0.00 | |||
| FROMQTY | numeric(19,5) 0.00 | |||
| UOMPRICE | numeric(19,5) 0.00 | |||
| QTYBSUOM | numeric(19,5) 0.00 | |||
| DEX_ROW_TS | datetime (getutcdate()) | |||
| DEX_ROW_ID | int auto number (1,1) |
Reporting Tips
- - PRICMTHD defines the pricing method (Currency Amount, % Markup, % Margin, etc.)
- - UOFM here is the selling unit, not necessarily the base unit
Related Tables
Tables that share columns with IV00108. Click "Join" to add to your query.