LookupOrderTypeIdByName
Summary
The LookupOrderTypeIdByName function returns the xactly.xc_order_type.order_type_id for the given string input parameter.
Syntax
LookupOrderTypeIdByName(<string>) |
Return Type
Long
Details
The function returns null if the input string does not match a name in the xactly.xc_order_type table.
Examples
eval LookupOrderTypeIdByName(‘Revenue’);
select order_type_name,
LookupOrderTypeIdByName(order_type_name),
count(*)
from staging.order_item;
Related Functions