Default integration task templates

Task type	Template	Description
Connector	CONNECTORTOOLBOX_GENERIC_PARAMETERS	Contains the Connector Toolbox database connection string, and is used as a parameter by other tasks through parameter binding.
Connector	FASHIONPLM_GENERIC_PARAMETERS	Contains generic Infor Fashion PLM parameters that are needed and consumed by other tasks through parameter binding.
Connector	GENERIC_TASK	Used to signify the end point of an integration flow.
Connector	ION_CONNECTOR_PARAMETERS	Contains ION-specific parameters that are needed and consumed by other tasks through parameter binding.
Connector	M3GENERICPARAMETERS	Contains necessary M3-specific parameters that are needed and consumed by other tasks through parameter binding.
Connector	MISCELLANEOUS	Contains all miscellaneous or generic parameters that are needed and consumed by other tasks through parameter binding.
Query	ION_INBOX_ENTRY	A query task template the queries an inbound BOD in the ION database.
Query	ION_INBOX_HEADER_BODTYPE	A query task template contain the metadata to get the BodType header value of COR_INBOX_HEADERS ION database table.
Query	ION_INBOX_HEADER_FROMLOGICALID	A query task template that contains metadata to get the BOD header FromLogicalId value from COR_ INBOX_HEADERS ION database table.
Query	ION_INBOX_HEADER_MESSAGEID	A query task template that contains the metadata to get the BOD header MessageId value from COR_INBOX_HEADERS ION database table.
Query	ION_INBOX_HEADER_TENANTID	A query task template that contains metadata to get the BOD header TenantId value from COR_INBOX_HEADERS ION database table.
Query	ION_INBOX_HEADER_TOLOGICALID	A query task template that contains metadata to get the BOD header ToLogicalId value from COR_INBOX_HEADERS ION database table.
Query	POLL_ACKNOWLEDGE_CODEDEFINITION	A polling query task template that periodically checks an ION Inbox for any received AcknowledgeCodeDefinition BOD.
Query	POLL_ACKNOWLEDGE_ITEMMASTER	A polling query task template that periodically checks an ION Inbox for any received AcknowledgeItemMaster BOD.
Query	QUERY_INBOX_VIEW	A query task template that obtains values from InboxView in the ION database.
Query	QUERY_INBOX_VIEW_BY_REFERENCE	A query task template that obtains values filtered by ReferenceID column from InboxView in the ION database.
Query	QUERY_M3_ITEM_TYPE	A query task template that contains metadata to obtain values for importing item types from M3 BE through MI Program/Transaction MMS200MI - SellItemType.
Query	QUERY_M3_SUPPLIER	A query task template that contains metadata to obtain values for importing suppliers from M3 BE through MI Program/Transaction CRS620 - LstSuppliers.
Query	QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_X	A query task template that contains metadata to get the equivalent M3 'X' features of a style in the Infor Fashion PLM database.
Query	QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_Y	A query task template that contains metadata to get the equivalent M3 'Y' features of a style in the Infor Fashion PLM database.
Query	QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_Y_FLOW2	A query task template that contains the metadata to get the Color records associated to a Style filtered by Style Id. Gets value from V_INTGSTYLECOLOR database view.
Query	QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_Z	A query task template that contains metadata to get the equivalent M3 'Z' features of a style in the Infor Fashion PLM database.
Query	QUERY_SEND_STYLE_SKU_WORKUNIT	A query task template that queries the SKU entity from the Infor Fashion PLM database
Query	QUERY_SEND_STYLE_WORKUNIT	A query task template that contains metadata to query the style entity from the Infor Fashion PLM database.
Query	QUERY_STYLE_BY_INTCODE	A query task template that contains the metadata to get SKU records (Features & Options) filtered by Interface Item number. Gets value from V_INTGSTYLESKU database view.
Query	QUERY_STYLE_BY_INTCODE	A query task template that contains the metadata to get Style records filtered by Interface Item number. Gets value from V_QRYSTYLE database view.
Integration	INSERT_ION_OUTBOX_ENTRY	A save-to-entity task template that contains metadata to insert a COR_OUTBOX_ENTRY entity. The C_XML parameter is the value responsible for the XML body of a particular BOD.
Integration	INSERT_ION_OUTBOX_HEADER_BODTYPE	A save-to-entity task template that contains metadata to insert the BOD header BodType value to COR_OUTBOX_HEADERS ION database table.
Integration	INSERT_ION_OUTBOX_HEADER_FROMLOGICALID	A save-to-entity task template that contains metadata to insert the BOD header FromLogicalId value to COR_OUTBOX_HEADERS ION database table.
Integration	INSERT_ION_OUTBOX_HEADER_MESSAGEID	A save-to-entity task template that contains the metadata to insert the BOD header MessageId value to COR_OUTBOX_HEADERS ION database table.
Integration	INSERT_ION_OUTBOX_HEADER_TENANTID	A save-to-entity task template that contains metadata to insert the BOD header TenantId value to COR_OUTBOX_HEADERS ION database table.
Integration	INSERT_ION_OUTBOX_HEADER_TOLOGICALID	A save-to-entity task template that contains metadata to insert the BOD header ToLogicalId value to COR_OUTBOX_HEADERS ION database table.
Integration	INSERT_PLM_ITEM_TYPE	A save-to-entity task template that contains the metadata to insert values to PLM table named OPITEMTEMP. This table holds the Item Type records.
	INSERT_PLM_SUPPLIER	A save-to-entity task template that contains the metadata to insert values to PLM table named SUPPLIER. This table holds the Supplier records.
Integration	INSERT_STYLE	An update-entity task template that updates the NETWEIGHT, GROSSWEIGHT, FREECAPUNIT of a related PLM STYLE table record.
Integration	INSERT_SYNC_LOG	An integration task template that contains the metadata to save the data time of the Integration Flow for easier keeping track of sent items during integration. Saves in SCAH SYNCHLOG database table.
Integration	TRANSFORM_FROM_ACKNOWLEDGE_ITEMMASTER	A transform-from-XML task template that extracts the ResponseExpression and ID values of AcknowledgeItemMaster BOD.
Integration	TRANSFORM_FROM_ACKNOWLEDGE_ITEMMASTER_ON_REJECTED	A transform-from-XML task template that extracts the ResponseExpression and Reason values of AcknowledgeItemMaster BOD.
Integration	TRANSFORM_FROM_SYNCITEMMASTER	A transform-from-XML-element task template that extracts values from a SyncItemMaster BOD.
Integration	TRANSFORM_TO_BUYER_REFERENCE	A transform-to-XML-element task template that transforms its parameter values to an XML element-<BuyerReference> with its attribute 'IDs/ID@accountingEntity' defaulted to an accounting entity. The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemLocation/UserArea'.
Integration	TRANSFORM_TO_PROPERTY_AREA_PRINT_FEATURE	An integration task template that contains the metadata to transform the XML to a specific area in the BOD specifically placing the Property Area Print Feature value in the Code Definition element.
Integration	TRANSFORM_TO_PROPERTY_AREA_PRINT_OPTION	An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Print Option value in the Code Definition element.
Integration	TRANSFORM_TO_PROPERTY_AREA_FEATURE_TYPES	An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Feature Types value in the Code Definition element.
Integration	TRANSFORM_TO_ITEMMASTER	A transform-to-BOD task template that transforms its parameter values to ProcessItemMaster BOD.
Integration	TRANSFORM_TO_SPECIFICATION_ID	A transform-to-XML task template that transforms its parameter values to an XML element <Specification>. The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.
Integration	TRANSFORM_TO_SPECIFICATION_PURCHASEPRICE	A transform-to-XML-element task template that transforms its parameter values to an XML element <Specification>. The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.
Integration	TRANSFORM_TO_SPECIFICATION_SALESPRICE	A transform-to-XML-element task template that transforms its parameter values to an XML element <Specification>. The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.
Integration	TRANSFORM_FROM_SYNCSUPPLIERPARTYMASTER	A transform-from-XML- element task template that extracts values from a SyncSupplierPartyMaster BOD.
Integration	TRANSFORM FROM_SYNCITEMCODEDEF	A transform-from-XML-element task template that extracts values from a SyncCodeDefinitionBOD.
Integration	TRANSFORM_TO_CLASSIFICATION	A transform-to-XML-element task template that transforms its parameter values to an XML element <Classification>. The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.
Integration	TRANSFORM_TO_CLASSIFICATION_ITEMLOCATION	A transform-to-XML-element task template that transforms its parameter values to an XML element <ItemLocation>. The generated element will be appended to a BOD and to aspecified path 'DataArea/ItemMaster/ ItemLocation'.
Integration	TRANSFORM_TO_DESCRIPTION_SHORT_NAME	A transform-to-XML-element task template that transforms its parameter values to an XML element--<Description> with its attribute 'Description@type' set to 'ShortName'. The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.
Integration	TRANSFORM_TO_HTS_CUSTOMSTAT	A transform-to-XML element that transforms its parameter values to an XML element <Property> with NameValue@name-CustomsStatNumber. The generated element will be appended to BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.
Integration	TRANSFORM_TO_ITEMID	An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the ITEMID value.
Integration	TRANSFORM_TO_PLANNER_REFERENCE	A transform-to-XML-element task template that transforms its parameter values to an XML element <PlannerReference> with its attribute 'IDs/ID@accountingEntity' defaulted to an accounting entity. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.
Integration	TRANSFORM_TO_PROCESS_CODE_DEFINITION	A transform-to-BOD task template that transforms parameter values into ProcessCodeDefinition BOD.
Integration	TRANSFORM_TO_PROCESS_ITEMMASTER_ADD	A transform-to-BOD task template that transforms its parameter values to ProcessItemMaster BOD.
Integration	TRANSFORM_TO_PROCESS_ITEMMASTER_ADD_NW	An integration task template that contains the metadata to transform the xml for adding the ProcessItemMaster BOD for no warehouse.
Integration	TRANSFORM_TO_PROPERTY_AREA_FEATURE_TYPE	A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to StyleFeatureTypes. The generated element will be appended to ProcessCodeDefinition BOD to a specified path 'DataArea/ CodeDefinition'.
Integration	TRANSFORM_TO_PROPERTY_AREA_OPTION_FLOW2	An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Option values in the Code Definition element.
Integration	TRANSFORM_TO_SPECIFICATION	A transform-to-XML-element task template that transforms its parameter values to an XML element-<Specification> with its attribute 'ID@accountingEntity' defaulted to an accounting entity. The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.
Integration	TRANSFORM_TO_SUPPLIER	A transform-to-XML-element task template that transforms its parameter values to an XML element <DefaultSource> with its attribute 'SupplierParty/PartyIDs/ID@accountingEntity' defaulted to an accounting entity. The generated element will be appended to a BOD to a specified path: 'DataArea/ItemMaster/ItemLocation/ProcurementParameters'.
Integration	TRANSFORM_TO_SUPPLIER_NEW	A transform-to-XML-element task template that transforms its integration TRANSFORM_TOSUPPLIER parameter values to an XML element <DefaultSource> with its attribute 'SupplierParty/PartyIDs/ID@accountingEntity" that is defaulted to an accounting entity. The generated element will be appended to a BOD to this specified path: DataArea/ItemMaster/ItemMasterHeader/ProcurementParameters.
Integration	TRANSFORM_TO_USER_AREA	A transform-to-XML-element task template that transforms its parameter values to an XML element <Property>. The generated element will be appended to a BOD to path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_INTERFACE_STYLE_NUMBER	A transform-to-XML-element task template that transforms its parameter values to an XML element-<Property> with its attribute 'NameValue@name' defaulted to InterfaceStyleNumber. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SEASON_CODE	An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Season Code values in the Item-User Area element.
Integration	TRANSFORM_TO_USER_AREA_SEASON_CONTROL	A transform-to-xml-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to 'SeasonControl'. The generated element will be appended to a BOD with path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_FEATUREX	A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to 'StyleFeatureX'. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_FEATUREY	A transform-to-XML element that transforms equivalent Y features as parameter values to an XML element <Property> then appends them to <UserArea> in BOD.
Integration	TRANSFORM_TO_USER_AREA_SKU_FEATUREZ	A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with attribute 'NameValue@name' defaulted to 'StyleFeatureZ'. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_OPTIONX	A transform-to-XML element that translates equivalent X Options as parameter values to an XML element <Property>, which is then later appended to BOD path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_OPTIONX_SEQ	A transform-to-XML-element task template that transforms equivalent X Option sequence as parameter values to an XML element <Property>, which is then later appended to the BOD with a path DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_OPTIONY	A transform-to-XML-element task template that transforms equivalent Y Options as parameter values parameter values to an XML element-<Property> with its attribute 'NameValue@name' defaulted to 'StyleOptionY'. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_OPTIONY_SEQ	A transform-to-XML-element task template that transforms equivalent Y Options as parameter values parameter values to an XML element-<Property> with its attribute 'NameValue@name' defaulted to 'StyleOptionYSequence'. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_OPTIONZ	A transform-to-XML-element task template that transforms equivalent Z Options as parameter values to an XML element--<Property> with its attribute 'NameValue@name' defaulted to 'StyleOptionZ'. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_SKU_OPTIONZ_SEQ	A transform-to-XML-element task template that transforms equivalent Z Option Sequence as parameter values to an XML element--<Property>. The generated XML element will then be appended to a BOD with path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_STYLEFEATURE	A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@type' defaulted to StringType. The generated element will be appended to BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.
Integration	TRANSFORM_TO_USER_AREA_STYLEITEMTYPE	A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to 'StyleItemType'. The generated element will be appended to a BOD to path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.
Integration	TRANSFORM_TO_WAREHOUSE_LOCATION	A transform-to-XML element that translates the paramaters to an <ID> XML element, which is then later appended to a BOD path 'DataArea/ItemMaster/ItemLocation/WarehouseLocation'.
Integration	UPDATE_FAIL_ION_INBOX	An update-entity task template that changes the related ION table record COR_INBOX_ENTRY to C_WAS_PROCESSED = 2. This marks that the particular ION inbox entry has already been processed but failed.
Integration	UPDATE_FAIL_SEND_STYLE_SKU_WORKUNIT	An update-entity task template that changes the related PLM table record SKU to ISPHANTOM = 1. This marks that the particular SKU has been integrated.
Integration	UPDATE_FAIL_SEND_STYLE_WORKUNIT	An update-entity task template that changes the related PLM table record STYLE to INTGSTATUSMHS to Not Successful. This marks that the particular style has not been successfully integrated.
Integration	UPDATE_ION_INBOX	An update-entity task template that changes the related ION table record COR_INBOX_ENTRY to C_WAS_PROCESSED = 1. This marks that the particular ION inbox entry has already been processed.
Integration	UPDATE_SEND_STYLE_SKU_WORKUNIT	An update-entity task template that changes the related PLM table record SKU to ISPHANTOM to 0. This marks that the particular SKU has been integrated.
Integration	UPDATE_SEND_STYLE_WORKUNIT	An update-entity task template that changes the related PLM table record STYLE to ISPHANTOM to 0 and INTGSTATUSMHS to Successful. This marks that the particular style has been integrated.
Integration	UPDATE_STYLE_FROM_ACK	An integration task template that contains the metadata to update the Style record of the integration status. Updates value in STYLE database table.
Integration	UPDATE_TO_MHS001MI	An MI-call-task template that contains the metadata to update data by transacting to a MI Program/Transaction –MHS001MI/ChgIntItmMst. Note: This template is contained in an ION flow task. Any changes made to the current ION flow task must consider updating this template as well.
Integration	UPDATE_TO_MHS002MI	An MI-call-task template that contains the metadata to update data by transacting to a MI Program/Transaction –MHS002MI/ChgIntItmWhs. Note: This template is contained in an ION flow task. Any changes made to the current ION flow task must consider updating this template as well.
Integration	UPDATE_TO_PDS055MI	An integration task template that contains the metadata to update values through the M3 Api web service in MI Program PDS055MI.
QueryTransform	QUERY_TRANSFORM_TO_PROPERTY_AREA_STYLE_OPTIONS_SEND_STYLE_X	A Query Transform task template that contains the metadata to get Style Size values and transform them to Property areas in the BOD. Gets the value from V_INTGSTYLESIZE database table.
QueryTransform	QUERY_TRANSFORM_TO_PROPERTY_AREA_STYLE_OPTIONS_SEND_STYLE_Y	A Query Transform task template that contains the metadata to get Style Color values and transform them to Property areas in the BOD. Gets the value from V_INTGSTYLECOLOR database table.
QueryTransform	QUERY_TRANSFORM_TO_PROPERTY_AREA_STYLE_OPTIONS_SEND_STYLE_Z	A Query Transform task template that contains the metadata to get Style Characteristic values and transform them to Property areas in the BOD. Gets the value from V_INTGSTYLECHARACTERISTIC database table.
QueryTransform	QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREX	A Query Transform task template that contains the metadata to get Feature group X dimension values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLEFEATURE database table.
QueryTransform	QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREY	A Query Transform task template that contains the metadata to get Feature group Y dimension values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLEFEATURE database table.
QueryTransform	QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREY_FLOW_2	A Query Transform task template that contains the metadata to get Style Color Feature group values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLECOLOR database table.
QueryTransform	QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREZ	A Query Transform task template that contains the metadata to get Feature group Z dimension values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLEFEATURE database table.
Cleanup	CLEAN_UP_SYNC_ITEM_MASTER_WORKUNIT	A Clean up task template that contains the metadata to perform a clean-up operation or delete records in the ION database table. Deletes records in COR_INBOX_ENTRY table in ION database.

Connector

CONNECTORTOOLBOX_GENERIC_PARAMETERS

Contains the Connector Toolbox database connection string, and is used as a parameter by other tasks through parameter binding.

Connector

FASHIONPLM_GENERIC_PARAMETERS

Contains generic Infor Fashion PLM parameters that are needed and consumed by other tasks through parameter binding.

Connector

GENERIC_TASK

Used to signify the end point of an integration flow.

Connector

ION_CONNECTOR_PARAMETERS

Contains ION-specific parameters that are needed and consumed by other tasks through parameter binding.

Connector

M3GENERICPARAMETERS

Contains necessary M3-specific parameters that are needed and consumed by other tasks through parameter binding.

Connector

MISCELLANEOUS

Contains all miscellaneous or generic parameters that are needed and consumed by other tasks through parameter binding.

Query

ION_INBOX_ENTRY

A query task template the queries an inbound BOD in the ION database.

Query

ION_INBOX_HEADER_BODTYPE

A query task template contain the metadata to get the BodType header value of COR_INBOX_HEADERS ION database table.

Query

ION_INBOX_HEADER_FROMLOGICALID

A query task template that contains metadata to get the BOD header FromLogicalId value from COR_ INBOX_HEADERS ION database table.

Query

ION_INBOX_HEADER_MESSAGEID

A query task template that contains the metadata to get the BOD header MessageId value from COR_INBOX_HEADERS ION database table.

Query

ION_INBOX_HEADER_TENANTID

A query task template that contains metadata to get the BOD header TenantId value from COR_INBOX_HEADERS ION database table.

Query

ION_INBOX_HEADER_TOLOGICALID

A query task template that contains metadata to get the BOD header ToLogicalId value from COR_INBOX_HEADERS ION database table.

Query

POLL_ACKNOWLEDGE_CODEDEFINITION

A polling query task template that periodically checks an ION Inbox for any received AcknowledgeCodeDefinition BOD.

Query

POLL_ACKNOWLEDGE_ITEMMASTER

A polling query task template that periodically checks an ION Inbox for any received AcknowledgeItemMaster BOD.

Query

QUERY_INBOX_VIEW

A query task template that obtains values from InboxView in the ION database.

Query

QUERY_INBOX_VIEW_BY_REFERENCE

A query task template that obtains values filtered by ReferenceID column from InboxView in the ION database.

Query

QUERY_M3_ITEM_TYPE

A query task template that contains metadata to obtain values for importing item types from M3 BE through MI Program/Transaction MMS200MI - SellItemType.

Query

QUERY_M3_SUPPLIER

A query task template that contains metadata to obtain values for importing suppliers from M3 BE through MI Program/Transaction CRS620 - LstSuppliers.

Query

QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_X

A query task template that contains metadata to get the equivalent M3 'X' features of a style in the Infor Fashion PLM database.

Query

QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_Y

A query task template that contains metadata to get the equivalent M3 'Y' features of a style in the Infor Fashion PLM database.

Query

QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_Y_FLOW2

A query task template that contains the metadata to get the Color records associated to a Style filtered by Style Id. Gets value from V_INTGSTYLECOLOR database view.

Query

QUERY_SEND_STYLE_ADD_FEATURE_WORKUNIT_Z

A query task template that contains metadata to get the equivalent M3 'Z' features of a style in the Infor Fashion PLM database.

Query

QUERY_SEND_STYLE_SKU_WORKUNIT

A query task template that queries the SKU entity from the Infor Fashion PLM database

Query

QUERY_SEND_STYLE_WORKUNIT

A query task template that contains metadata to query the style entity from the Infor Fashion PLM database.

Query

QUERY_STYLE_BY_INTCODE

A query task template that contains the metadata to get SKU records (Features & Options) filtered by Interface Item number. Gets value from V_INTGSTYLESKU database view.

Query

QUERY_STYLE_BY_INTCODE

A query task template that contains the metadata to get Style records filtered by Interface Item number. Gets value from V_QRYSTYLE database view.

Integration

INSERT_ION_OUTBOX_ENTRY

A save-to-entity task template that contains metadata to insert a COR_OUTBOX_ENTRY entity.

The C_XML parameter is the value responsible for the XML body of a particular BOD.

Integration

INSERT_ION_OUTBOX_HEADER_BODTYPE

A save-to-entity task template that contains metadata to insert the BOD header BodType value to COR_OUTBOX_HEADERS ION database table.

Integration

INSERT_ION_OUTBOX_HEADER_FROMLOGICALID

A save-to-entity task template that contains metadata to insert the BOD header FromLogicalId value to COR_OUTBOX_HEADERS ION database table.

Integration

INSERT_ION_OUTBOX_HEADER_MESSAGEID

A save-to-entity task template that contains the metadata to insert the BOD header MessageId value to COR_OUTBOX_HEADERS ION database table.

Integration

INSERT_ION_OUTBOX_HEADER_TENANTID

A save-to-entity task template that contains metadata to insert the BOD header TenantId value to COR_OUTBOX_HEADERS ION database table.

Integration

INSERT_ION_OUTBOX_HEADER_TOLOGICALID

A save-to-entity task template that contains metadata to insert the BOD header ToLogicalId value to COR_OUTBOX_HEADERS ION database table.

Integration

INSERT_PLM_ITEM_TYPE

A save-to-entity task template that contains the metadata to insert values to PLM table named OPITEMTEMP.

This table holds the Item Type records.

INSERT_PLM_SUPPLIER

A save-to-entity task template that contains the metadata to insert values to PLM table named SUPPLIER.

This table holds the Supplier records.

Integration

INSERT_STYLE

An update-entity task template that updates the NETWEIGHT, GROSSWEIGHT, FREECAPUNIT of a related PLM STYLE table record.

Integration

INSERT_SYNC_LOG

An integration task template that contains the metadata to save the data time of the Integration Flow for easier keeping track of sent items during integration. Saves in SCAH SYNCHLOG database table.

Integration

TRANSFORM_FROM_ACKNOWLEDGE_ITEMMASTER

A transform-from-XML task template that extracts the ResponseExpression and ID values of AcknowledgeItemMaster BOD.

Integration

TRANSFORM_FROM_ACKNOWLEDGE_ITEMMASTER_ON_REJECTED

A transform-from-XML task template that extracts the ResponseExpression and Reason values of AcknowledgeItemMaster BOD.

Integration

TRANSFORM_FROM_SYNCITEMMASTER

A transform-from-XML-element task template that extracts values from a SyncItemMaster BOD.

Integration

TRANSFORM_TO_BUYER_REFERENCE

A transform-to-XML-element task template that transforms its parameter values to an XML element-<BuyerReference> with its attribute 'IDs/ID@accountingEntity' defaulted to an accounting entity.

The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemLocation/UserArea'.

Integration

TRANSFORM_TO_PROPERTY_AREA_PRINT_FEATURE

An integration task template that contains the metadata to transform the XML to a specific area in the BOD specifically placing the Property Area Print Feature value in the Code Definition element.

Integration

TRANSFORM_TO_PROPERTY_AREA_PRINT_OPTION

An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Print Option value in the Code Definition element.

Integration

TRANSFORM_TO_PROPERTY_AREA_FEATURE_TYPES

An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Feature Types value in the Code Definition element.

Integration

TRANSFORM_TO_ITEMMASTER

A transform-to-BOD task template that transforms its parameter values to ProcessItemMaster BOD.

Integration

TRANSFORM_TO_SPECIFICATION_ID

A transform-to-XML task template that transforms its parameter values to an XML element <Specification>.

The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.

Integration

TRANSFORM_TO_SPECIFICATION_PURCHASEPRICE

A transform-to-XML-element task template that transforms its parameter values to an XML element <Specification>.

The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.

Integration

TRANSFORM_TO_SPECIFICATION_SALESPRICE

A transform-to-XML-element task template that transforms its parameter values to an XML element <Specification>.

The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.

Integration

TRANSFORM_FROM_SYNCSUPPLIERPARTYMASTER

A transform-from-XML- element task template that extracts values from a SyncSupplierPartyMaster BOD.

Integration

TRANSFORM FROM_SYNCITEMCODEDEF

A transform-from-XML-element task template that extracts values from a SyncCodeDefinitionBOD.

Integration

TRANSFORM_TO_CLASSIFICATION

A transform-to-XML-element task template that transforms its parameter values to an XML element <Classification>.

The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.

Integration

TRANSFORM_TO_CLASSIFICATION_ITEMLOCATION

A transform-to-XML-element task template that transforms its parameter values to an XML element <ItemLocation>.

The generated element will be appended to a BOD and to aspecified path 'DataArea/ItemMaster/ ItemLocation'.

Integration

TRANSFORM_TO_DESCRIPTION_SHORT_NAME

A transform-to-XML-element task template that transforms its parameter values to an XML element--<Description> with its attribute 'Description@type' set to 'ShortName'.

The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.

Integration

TRANSFORM_TO_HTS_CUSTOMSTAT

A transform-to-XML element that transforms its parameter values to an XML element <Property> with NameValue@name-CustomsStatNumber.

The generated element will be appended to BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.

Integration

TRANSFORM_TO_ITEMID

An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the ITEMID value.

Integration

TRANSFORM_TO_PLANNER_REFERENCE

A transform-to-XML-element task template that transforms its parameter values to an XML element <PlannerReference> with its attribute 'IDs/ID@accountingEntity' defaulted to an accounting entity.

The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.

Integration

TRANSFORM_TO_PROCESS_CODE_DEFINITION

A transform-to-BOD task template that transforms parameter values into ProcessCodeDefinition BOD.

Integration

TRANSFORM_TO_PROCESS_ITEMMASTER_ADD

A transform-to-BOD task template that transforms its parameter values to ProcessItemMaster BOD.

Integration

TRANSFORM_TO_PROCESS_ITEMMASTER_ADD_NW

An integration task template that contains the metadata to transform the xml for adding the ProcessItemMaster BOD for no warehouse.

Integration

TRANSFORM_TO_PROPERTY_AREA_FEATURE_TYPE

A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to StyleFeatureTypes.

The generated element will be appended to ProcessCodeDefinition BOD to a specified path 'DataArea/ CodeDefinition'.

Integration

TRANSFORM_TO_PROPERTY_AREA_OPTION_FLOW2

An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Option values in the Code Definition element.

Integration

TRANSFORM_TO_SPECIFICATION

A transform-to-XML-element task template that transforms its parameter values to an XML element-<Specification> with its attribute 'ID@accountingEntity' defaulted to an accounting entity.

The generated element will be appended to a BOD to a specified path 'DataArea/ItemMaster/ItemMasterHeader'.

Integration

TRANSFORM_TO_SUPPLIER

A transform-to-XML-element task template that transforms its parameter values to an XML element <DefaultSource> with its attribute 'SupplierParty/PartyIDs/ID@accountingEntity' defaulted to an accounting entity.

The generated element will be appended to a BOD to a specified path: 'DataArea/ItemMaster/ItemLocation/ProcurementParameters'.

Integration

TRANSFORM_TO_SUPPLIER_NEW

A transform-to-XML-element task template that transforms its integration TRANSFORM_TOSUPPLIER parameter values to an XML element <DefaultSource> with its attribute 'SupplierParty/PartyIDs/ID@accountingEntity" that is defaulted to an accounting entity.

The generated element will be appended to a BOD to this specified path: DataArea/ItemMaster/ItemMasterHeader/ProcurementParameters.

Integration

TRANSFORM_TO_USER_AREA

A transform-to-XML-element task template that transforms its parameter values to an XML element <Property>.

The generated element will be appended to a BOD to path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_INTERFACE_STYLE_NUMBER

A transform-to-XML-element task template that transforms its parameter values to an XML element-<Property> with its attribute 'NameValue@name' defaulted to InterfaceStyleNumber.

The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SEASON_CODE

An integration task template that contains the metadata to transform the xml to a specific area in the BOD specifically placing the Property Area Season Code values in the Item-User Area element.

Integration

TRANSFORM_TO_USER_AREA_SEASON_CONTROL

A transform-to-xml-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to 'SeasonControl'.

The generated element will be appended to a BOD with path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_FEATUREX

A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to 'StyleFeatureX'. The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_FEATUREY

A transform-to-XML element that transforms equivalent Y features as parameter values to an XML element <Property> then appends them to <UserArea> in BOD.

Integration

TRANSFORM_TO_USER_AREA_SKU_FEATUREZ

A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with attribute 'NameValue@name' defaulted to 'StyleFeatureZ'.

The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_OPTIONX

A transform-to-XML element that translates equivalent X Options as parameter values to an XML element <Property>, which is then later appended to BOD path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_OPTIONX_SEQ

A transform-to-XML-element task template that transforms equivalent X Option sequence as parameter values to an XML element <Property>, which is then later appended to the BOD with a path DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_OPTIONY

A transform-to-XML-element task template that transforms equivalent Y Options as parameter values parameter values to an XML element-<Property> with its attribute 'NameValue@name' defaulted to 'StyleOptionY'.

The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_OPTIONY_SEQ

A transform-to-XML-element task template that transforms equivalent Y Options as parameter values parameter values to an XML element-<Property> with its attribute 'NameValue@name' defaulted to 'StyleOptionYSequence'.

The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_OPTIONZ

A transform-to-XML-element task template that transforms equivalent Z Options as parameter values to an XML element--<Property> with its attribute 'NameValue@name' defaulted to 'StyleOptionZ'.

The generated element will be appended to the BOD to a path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_SKU_OPTIONZ_SEQ

A transform-to-XML-element task template that transforms equivalent Z Option Sequence as parameter values to an XML element--<Property>.

The generated XML element will then be appended to a BOD with path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_STYLEFEATURE

A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@type' defaulted to StringType.

The generated element will be appended to BOD to a path 'DataArea/ItemMaster/ItemLocation/UserArea'.

Integration

TRANSFORM_TO_USER_AREA_STYLEITEMTYPE

A transform-to-XML-element task template that transforms its parameter values to an XML element <Property> with its attribute 'NameValue@name' defaulted to 'StyleItemType'.

The generated element will be appended to a BOD to path 'DataArea/ItemMaster/ItemMasterHeader/UserArea'.

Integration

TRANSFORM_TO_WAREHOUSE_LOCATION

A transform-to-XML element that translates the paramaters to an <ID> XML element, which is then later appended to a BOD path 'DataArea/ItemMaster/ItemLocation/WarehouseLocation'.

Integration

UPDATE_FAIL_ION_INBOX

An update-entity task template that changes the related ION table record COR_INBOX_ENTRY to C_WAS_PROCESSED = 2.

This marks that the particular ION inbox entry has already been processed but failed.

Integration

UPDATE_FAIL_SEND_STYLE_SKU_WORKUNIT

An update-entity task template that changes the related PLM table record SKU to ISPHANTOM = 1.

This marks that the particular SKU has been integrated.

Integration

UPDATE_FAIL_SEND_STYLE_WORKUNIT

An update-entity task template that changes the related PLM table record STYLE to INTGSTATUSMHS to Not Successful.

This marks that the particular style has not been successfully integrated.

Integration

UPDATE_ION_INBOX

An update-entity task template that changes the related ION table record COR_INBOX_ENTRY to C_WAS_PROCESSED = 1.

This marks that the particular ION inbox entry has already been processed.

Integration

UPDATE_SEND_STYLE_SKU_WORKUNIT

An update-entity task template that changes the related PLM table record SKU to ISPHANTOM to 0.

This marks that the particular SKU has been integrated.

Integration

UPDATE_SEND_STYLE_WORKUNIT

An update-entity task template that changes the related PLM table record STYLE to ISPHANTOM to 0 and INTGSTATUSMHS to Successful.

This marks that the particular style has been integrated.

Integration

UPDATE_STYLE_FROM_ACK

An integration task template that contains the metadata to update the Style record of the integration status. Updates value in STYLE database table.

Integration

UPDATE_TO_MHS001MI

An MI-call-task template that contains the metadata to update data by transacting to a MI Program/Transaction –MHS001MI/ChgIntItmMst.

Note: This template is contained in an ION flow task. Any changes made to the current ION flow task must consider updating this template as well.

Integration

UPDATE_TO_MHS002MI

An MI-call-task template that contains the metadata to update data by transacting to a MI Program/Transaction –MHS002MI/ChgIntItmWhs.

Note: This template is contained in an ION flow task. Any changes made to the current ION flow task must consider updating this template as well.

Integration

UPDATE_TO_PDS055MI

An integration task template that contains the metadata to update values through the M3 Api web service in MI Program PDS055MI.

QueryTransform

QUERY_TRANSFORM_TO_PROPERTY_AREA_STYLE_OPTIONS_SEND_STYLE_X

A Query Transform task template that contains the metadata to get Style Size values and transform them to Property areas in the BOD. Gets the value from V_INTGSTYLESIZE database table.

QueryTransform

QUERY_TRANSFORM_TO_PROPERTY_AREA_STYLE_OPTIONS_SEND_STYLE_Y

A Query Transform task template that contains the metadata to get Style Color values and transform them to Property areas in the BOD. Gets the value from V_INTGSTYLECOLOR database table.

QueryTransform

QUERY_TRANSFORM_TO_PROPERTY_AREA_STYLE_OPTIONS_SEND_STYLE_Z

A Query Transform task template that contains the metadata to get Style Characteristic values and transform them to Property areas in the BOD. Gets the value from V_INTGSTYLECHARACTERISTIC database table.

QueryTransform

QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREX

A Query Transform task template that contains the metadata to get Feature group X dimension values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLEFEATURE database table.

QueryTransform

QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREY

A Query Transform task template that contains the metadata to get Feature group Y dimension values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLEFEATURE database table.

QueryTransform

QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREY_FLOW_2

A Query Transform task template that contains the metadata to get Style Color Feature group values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLECOLOR database table.

QueryTransform

QUERY_TRANSFORM_TO_USER_AREA_STYLEFEATUREZ

A Query Transform task template that contains the metadata to get Feature group Z dimension values and transform them to User areas in the BOD. Gets the value from V_INTGSTYLEFEATURE database table.

Cleanup

CLEAN_UP_SYNC_ITEM_MASTER_WORKUNIT

A Clean up task template that contains the metadata to perform a clean-up operation or delete records in the ION database table. Deletes records in COR_INBOX_ENTRY table in ION database.