LookupUnitTypeIdByName
Summary
The LookupUnitTypeIdByName function returns the unit_type_id from the xactly.xc_unit_type table corresponding to the given unit_type_name input parameter.
Syntax
LookupUnitTypeIdByName(<string>) |
Return Type
Long
Details
Returns null if input parameter has no matching value in the xactly.xc_unit_type table.
Examples
eval LookupUnitTypeIdByName(‘USD’);
select amount_unit_type_name,
LookupUnitTypeIdByName(amount_unit_type_name)
from staging.order_item
limit 10;
Related Functions
LookupUnitTypeIdById