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 […]

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

Show Email The SHOW EMAIL command shows metadata for the specific email domain object. The command returns a one row result set. Syntax show email <email_name>;  Parameters Parameter Description email_name (Required) Specifies […]

Show Emails The SHOW EMAILS command returns a result set listing all email domain object in the Connect environment. Syntax show emails;  Parameters None. Details   The command returns the following result […]