Requirements

The stored procedure name is derived from the Open Interface name or the Staging Table name, according to the following convention:

• At the root level:

  If the OPEN_INTERFACE tab has a Util_Name attribute, then this value is used: FN_CNT_<UTILNAME>. Otherwise, the value of the attribute Name is used: FN_CNT_<Open_Interface_Name>.

  For example:

  • Customer Item: FN_CNT_CUSTITEMS

  • Item Import: FN_CNT_ITEM_IMPORT

  At the staging table level:

  If the Interface_Table tag has a Util_Name attribute, then this value is used: FN_CNT_<UTILNAME>. Otherwise, the short name of the Name attribute is used: FN_CNT_<Short_Table_Name>.

  For example:

  • Customer Item: FN_CNT_MTL_CI_INTERFACE_INT

  • Item Import: FN_CNT_MTL_SYSTEM_ITEMS_INT