IsValidUnitTypeName

Summary

The IsValidUnitTypeName function checks whether the input parameter corresponds to a valid unit type name value in the xactly.xc_unit_type table.

Syntax

IsValidUnitTypeName(<string>)

Return Type

Boolean

Details

The function returns true or false.

Examples

eval IsValidUnitTypeName(‘złoty’);

screen-shot-2016-10-14-at-1-42-49-pm

select amount_unit_type_name,
IsValidUnitTypeName(amount_unit_type_name)
from staging.order_item
limit 10;

screen-shot-2016-10-14-at-1-42-55-pm

Related Functions

LookupUnitTypeIdByName

LookupUnitTypeNameById

IsValidUnitTypeId

LookupOrderStageUnitTypeIdByOrderCodeItemCode