E Appendix: Publication Tables and Triggers

MFQUEUE Triggers

The following table contains the list of MFQUEUE triggers in Merchandising, as well as the queue tables that are written to if the triggers are not disabled. As noted above, you should disable these triggers prior to converting Merchandising data and re-enable once conversion is complete. If triggers are not disabled, then the queue tables must be cleared prior to lift and shift.

Merchandising Base Table	Trigger Name	Queue Table
ADDR	EC_TABLE_ADR_AIUDR DE_TABLE_ADDR_AIUDR	SUPPLIER_MFQUEUE WH_MFQUEUE STORE_MFQUEUE PARTNER_MFQUEUE
ADDR_CFA_EXT	EC_TABLE_ACE_AIUR	SUPPLIER_MFQUEUE WH_MFQUEUE STORE_MFQUEUE PARTNER_MFQUEUE
ALLOC_DETAIL	EC_TABLE_ALD_AIUDR	ALLOC_MFQUEUE
ALLOC_HEADER	EC_TABLE_ALH_AIUDR	ALLOC_MFQUEUE
AREA	EC_TABLE_ARE_AIUDR DE_TABLE_AREA_AIUDR	ORGHIER_MFQUEUE
BANNER	EC_TABLE_BAN_AIUDR	BANNER_MFQUEUE
BRAND	EC_TABLE_BRAND_AIUDR	BRAND_MFQUEUE
CHAIN	EC_TABLE_CHA_AIUDR DE_TABLE_CHA_AIUDR	ORGHIER_MFQUEUE
CHANNELS	EC_TABLE_CHN_AIUDR	BANNER_MFQUEUE
CLASS	EC_TABLE_CLA_AIUDR DE_TABLE_CLS_AIUDR	MERCHHIER_MFQUEUE
CLASS_CFA_EXT	EC_TABLE_CCE_AIUR	MERCHHIER_MFQUEUE
CODE_DETAIL	EC_TABLE_CODEDTL_AIUDR	CODES_MFQUEUE
CODE_HEAD	EC_TABLE_CODEHD_AIUDR	CODES_MFQUEUE
COMPANY_CLOSED	EC_TABLE_CO_CLOSE_AIUDR	COMPANY_CLOSED_MFQUEUE
COMPANY_CLOSED_EXCEP	EC_TABLE_CCEXP_AIUDR	COMPANY_CLOSED_EXCEP_MFQUEUE
COMPHEAD	DE_TABLE_CO_AIUR
COUNTRY	EC_TABLE_CNT_AIUDR	SEEDOBJ_MFQUEUE
DELIVERY_SLOT	EC_TABLE_DLVY_AIUDR	DELIVERY_SLOT_MFQUEUE
DEPS	EC_TABLE_DEP_AIUDR DE_TABLE_DEPT_AIUDR	MERCHHIER_MFQUEUE
DEPS_CFA_EXT	EC_TABLE_DCE_AIUR	MERCHHIER_MFQUEUE
DIFF_GROUP_DETAIL	EC_TABLE_DGD_AIUDR DE_TABLE_DGDTL_AIUDR	DIFFGRP_MFQUEUE
DIFF_GROUP_HEAD	EC_TABLE_DGH_AIUDR DE_TABLE_DGHEAD_AIUDR	DIFFGRP_MFQUEUE
DIFF_IDS	EC_TABLE_DID_AIUDR DE_TABLE_DIFF_AIUDR	DIFFID_MFQUEUE
DIFF_TYPE	EC_TABLE_DIFF_TYPE_AIUDR	DIFFTYPE_MFQUEUE
DISTRICT	EC_TABLE_DIS_AIUDR DE_TABLE_DIS_AIUDR	ORGHIER_MFQUEUE
DIVISION	EC_TABLE_DIV_AIUDR DE_TABLE_DIVI_AIUDR	MERCHHIER_MFQUEUE
GROUPS	EC_TABLE_GRO_AIUDR DE_TABLE_GRP_AIUDR	MERCHHIER_MFQUEUE
ITEM_IMAGE	EC_TABLE_IIM_AIUDR	ITEM_MFQUEUE
ITEM_LOC	EC_TABLE_ITL_AIUDR DE_TABLE_IL_AIUDR	ITEMLOC_MFQUEUE
ITEM_LOC_CFA_EXT	EC_TABLE_ILE_AIUR	ITEMLOC_MFQUEUE
ITEM_LOC_SOH	EC_TABLE_ILS_AUR	ITEM_LOC_SOH_MFQUEUE
ITEM_LOC_TRAITS	EC_TABLE_ILT_AIUDR DE_TABLE_ILT_AIUDR	ITEMLOC_MFQUEUE
ITEM_MASTER	EC_TABLE_IEM_AIUDR DE_TABLE_IM_AIUDR	ITEM_MFQUEUE
ITEM_MASTER_CFA_EXT	EC_TABLE_IME_AIUR	ITEM_MFQUEUE
ITEM_SUPP_COUNTRY	EC_TABLE_ISC_AIUDR	ITEM_MFQUEUE
ITEM_SUPP_COUNTRY_CFA_EXT	EC_TABLE_ICE_AIUR	ITEM_MFQUEUE
ITEM_SUPP_COUNTRY_DIM	EC_TABLE_ISD_AIUDR	ITEM_MFQUEUE
ITEM_SUPP_MANU_COUNTRY	EC_TABLE_ISMC_AIUDR	ITEM_MFQUEUE
ITEM_SUPP_UOM	EC_TABLE_ISU_AIUDR	ITEM_MFQUEUE
ITEM_SUPPLIER	EC_TABLE_ISP_AIUDR	ITEM_MFQUEUE
ITEM_SUPPLIER_CFA_EXT	EC_TABLE_ISE_AIUR	ITEM_MFQUEUE
ITEM_TICKET	EC_TABLE_ITK_AIDR	ITEM_MFQUEUE
LOCATION_CLOSED	EC_TABLE_LCLS_AIUDR	LOCATION_CLOSED_MFQUEUE
ORDCUST	EC_TABLE_ORC_AUR	TSF_MFQUEUE
ORDCUST_PUB_TEMP	EC_TABLE_ORP_AIR
ORDHEAD	EC_TABLE_OHE_AIUDR	ORDER_MFQUEUE
ORDHEAD_CFA_EXT	EC_TABLE_OCE_AIUR	ORDER_MFQUEUE
ORDLOC	EC_TABLE_OLO_AIUDR	ORDER_MFQUEUE
ORDLOC_CFA_EXT	EC_TABLE_OLE_AIUR	ORDER_MFQUEUE
ORDSKU_CFA_EXT	EC_TABLE_ORE_AIUR	ORDER_MFQUEUE
OWNERSHIP_PUB_GTT	EC_TABLE_OPT_AIR
PACKITEM_BREAKOUT	EC_TABLE_PKS_AIUDR EC_TABLE_PKS_IUDS	ITEM_MFQUEUE
PARTNER	EC_TABLE_PRT_AIUDR	PARTNER_MFQUEUE
PARTNER_CFA_EXT	EC_TABLE_PCE_AIUR	PARTNER_MFQUEUE
PARTNER_ORG_UNIT	EC_TABLE_POU_AIUDR	SUPPLIER_MFQUEUE
PHASES	EC_TABLE_PHS_AIUDR	SEASON_MFQUEUE
REGION	EC_TABLE_REG_AIUDR DE_TABLE_REG_AIUDR	ORGHIER_MFQUEUE
RELATED_ITEM_DETAIL	EC_TABLE_RID_AIUDR DE_TABLE_RID_AIUDR	ITEM_MFQUEUE
RELATED_ITEM_HEAD	EC_TABLE_RIH_AIUDR DE_TABLE_RIH_AIUDR	ITEM_MFQUEUE
REPL_ITEM_LOC	EC_TABLE_RIL_AIUDR	ITEMLOC_MFQUEUE
RTV_DETAIL	EC_TABLE_RDT_AIUDR	RTVREQ_MFQUEUE
RTV_HEAD	EC_TABLE_RHD_AIUDR	RTVREQ_MFQUEUE
RTV_HEAD_CFA_EXT	EC_TABLE_RCE_AIUR	RTVREQ_MFQUEUE
RUA_RIB_INTERFACE	EC_TABLE_RUA_AIR	RUA_MFQUEUE
SEASONS	EC_TABLE_SSN_AIUDR	SEASON_MFQUEUE
SHIPMENT_PUB_TEMP	EC_TABLE_SPT_AIR
STORE	EC_TABLE_STR_AIUDR DE_TABLE_STORE_AIUDR	STORE_MFQUEUE
STORE_CFA_EXT	EC_TABLE_STE_AIUR	STORE_MFQUEUE
STORE_HOURS	EC_TABLE_STHR_AIUR	STORE_MFQUEUE
SUBCLASS	EC_TABLE_SCL_AIUDR DE_TABLE_SCLS_AIUDR	MERCHHIER_MFQUEUE
SUBCLASS_CFA_EXT	EC_TABLE_SCL_AIUR	MERCHHIER_MFQUEUE
SUPS	EC_TABLE_SUP_AIUDR	SUPPLIER_MFQUEUE
SUPS_CFA_EXT	EC_TABLE_SCE_AIUR	SUPPLIER_MFQUEUE
TSFDETAIL	EC_TABLE_TDT_AIUDR	TSF_MFQUEUE
TSFHEAD	EC_TABLE_THD_AIUDR	TSF_MFQUEUE WOOUT_MFQUEUE
TSFHEAD_CFA_EXT	EC_TABLE_TCE_AIUR	TSF_MFQUEUE
UDA	EC_TABLE_UDA_AIUDR	UDA_MFQUEUE
UDA_ITEM_DATE	EC_TABLE_UIT_AIUDR	ITEM_MFQUEUE
UDA_ITEM_FF	EC_TABLE_UIF_AIUDR	ITEM_MFQUEUE
UDA_ITEM_LOV	EC_TABLE_UIL_AIDR	ITEM_MFQUEUE
UDA_VALUES	EC_TABLE_UDV_AIUDR	UDA_MFQUEUE
VAT_CODE_RATES	DE_TABLE_VCR_AIUDR
VAT_CODES	DE_TABLE_VC_AUDR
VAT_ITEM	EC_TABLE_VI_AIUDR DE_TABLE_VI_AIUDR	ITEM_MFQUEUE
VAT_REGION	DE_TABLE_VR_AIUDR
WH	EC_TABLE_WH_AIUDR DE_TABLE_WHOUSE_AIUDR	WH_MFQUEUE
WH_ADD	EC_TABLE_WHA_AIUR	WH_MFQUEUE
WH_CFA_EXT	EC_TABLE_WCE_AIUR	WH_MFQUEUE
WO_DETAIL	EC_TABLE_WDL_AIUDR	WOIN_MFQUEUE

Publication Tables

Below tables contain publish indicators used for setting up the converted data for future publication to downstream systems for any changes after you start using Merchandising in production. For tables that end in *_PUB_INFO or *DETAILS_PUBLISHED, records must be loaded into these tables for the converted data with a published flag set to Y. In other cases, the entity table itself (for example, ADDR) holds the publication flag. If this was not already set to Y as part of your conversion, this should be updated.

Functional Area	Publication Table
Address	ADDR
Allocations	ALLOC_PUB_INFO ALLOC_DETAILS_PUBLISHED
Items	ITEM_PUB_INFO
Partners	PARTNER_PUB_INFO
Purchase Orders	ORDER_PUB_INFO ORDER_DETAILS_PUBLISHED ORDCUST_PUB_INFO
RTVs	RTVREQ_PUB_INFO RTV_DETAIL
Shipments	SHIPMENT_PUB_INFO
Stores	STORE_PUB_INFO
Transfers	TRANSFERS_PUB_INFO TSFDETAIL ORDCUST_PUB_INFO TSF_PACKING TSF_WO_DETAIL TSF_XFORM_DETAIL WOOUT_PUB_INFO
Warehouses	WH_PUB_INFO
Purchase Order Work Orders	WO_DETAIL

Note: Data Conversion for most inventory transactions is not support by the tool. It is expected transactions such as RTVs, transfers and allocations are closed in legacy before cutover. However, if you migrate inventory transaction using custom conversion scripts, you are required to clear the queue tables and load PUB_INFO* tables with the published flag set to Y.