GP Tables

IV00105 - Item Currency Master

Stores currency-specific pricing information for items in multicurrency environments.

SQL Query Builder

5 Columns

Column Description Type Length
ITEMNMBR Item Number String 32
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
CURRNIDX Currency Index Integer 2
DECPLCUR Decimal Places Currency Integer 2
LISTPRCE List Price Currency 10

Related Tables

Tables that share columns with IV00105. Click "Join" to add to your query.

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

LISTPRCE