LookupPeriodTypeByPeriodName The LookupPeriodTypeByPeriodName function returns the xactly.xc_period_type.name value for the corresponding period name given in the input parameter. Syntax LookupPeriodTypeByPeriodName(<string>) Return Type String Details The function returns null if the period name input parameter does not tie to […]

Show Keys The show keys command returns a result set listing any tables that have primary keys defined. Syntax show keys; Return Type Table result set Details Connect allows developers to create […]

Incent Diagnostic The incent diagnostic command returns summary log information for jobs submitted to Incent’s processing queue. Most queue events are submitted from the Incent application, not Connect. The command […]

LookupBatchTypeNameById The LookupBatchTypeNameById function takes a batch type id input parameter and returns the corresponding xactly.xc_batch_type.name. The batch type id input parameter should match a value in xactly.xc_batch_type.batch_type_id. Syntax LookupBatchTypeNameById(<string>) Return Type string Details Null […]

LookupBusinessGroupIdByName The LookupBusinessGroupIdByName function returns the xactly.xc_business_group.business_group_id associated with the given string input parameter. Syntax LookupBusinessGroupIdByName(<string>) Return Type Long Details The function returns null if the input parameter does not match a valid xactly.xc_business_group.name. Examples eval […]

LookupPeriodIdByBatchName Use the LookupPeriodIdByBatchName function to return the xactly.xc_period.period_id associated with the given sales order batch name input parameter. Syntax LookupPeriodNameById(<string>) Return Type Long Details The function returns null if […]

LookupBatchTypeNameByBatchName The LookupBatchTypeNameByBatchName function takes a batch name input parameter and returns the corresponding xactly.xc_batch_type.name. The batch name input parameter should match a value in xactly.xc_user_batch.name. Syntax LookupBatchTypeNameByBatchName(<string>) Return Type string Details Null is returned […]

LookupBatchTypeNameByBatchId The LookupBatchTypeNameByBatchId function takes a batch_id input parameter and returns the corresponding xactly.xc_batch_type.name. The batch_id should match a value in xactly.xc_user_batch.batch_id. Syntax LookupBatchTypeNameByBatchId(long) Return Type string Details Null is returned if the function […]

LookupBatchTypeIdByName The LookupBatchTypeIdByName function takes a batch type name string input parameter and returns the corresponding xactly.xc_batch_type.batch_type_id. Syntax LookupBatchTypeIdByName(<string>) Return Type string Details Null is returned if the function cannot find a matching value […]

ToTime The ToTime function converts the input parameter to the time data type. Syntax ToTime(<string>|<date_time>|<offset_date_time>|<zoned_date_time> [, <format_mask>] )   The optional format parameter defines the date time formatting mask to use […]