F 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.