IV00107 - Item Price List Options
Contains price list configuration options per item.
SQL Query Builder
11 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) '' | |||
| RNDGAMNT | numeric(19,5) 0.00 | |||
| ROUNDHOW | smallint 0 | |||
| ROUNDTO | smallint 0 | |||
| UMSLSOPT | smallint 0 | |||
| QTYBSUOM | numeric(19,5) 0.00 | |||
| DEX_ROW_TS | datetime (getutcdate()) | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with IV00107. Click "Join" to add to your query.