I Appendix: Data Seeding Process Flows

Data Seeding Process Flows from Merchandising to EICS

The following list shows the Data Seeding Process Flows from Merchandising to EICS with Groups.

Table I-1 Data Seeding Process Flow Dependencies List

Group# Process Flow Notes

1

MerchHier_Fnd_ProcessFlow_From_RMS

Merchandise Hierarchy foundation data seed from Merchandising Foundation Data System.

Run once for initial full data seed.

1

Supplier_Fnd_ProcessFlow_From_RMS

Supplier foundation data seed from Merchandising Foundation Data System.

Run once for initial full data seed.

1

SupplierAddr_Fnd_ProcessFlow_From_RMS

Supplier address foundation data seed from Merchandising Foundation Data System.

1

Partner_Fnd_ProcessFlow_From_RMS

Partner foundation data seed from Merchandising Foundation Data System.

1

PartnerAddr_Fnd_ProcessFlow_From_RMS

Partner address foundation data seed from Merchandising Foundation Data System.

1

Wh_Fnd_ProcessFlow_From_RMS

Run once for initial full warehouse foundation data seed from Merchandising Foundation Data System.

1

WhAddr_ProcessFlow_From_RMS

Run once for initial full warehouse address foundation data seed from Merchandising Foundation Data System.

2

PartOrgUnit_Fnd_ProcessFlow_From_RMS

Run once for initial full partner Org Unit foundation data seed from Merchandising Foundation Data System.

2

ItemHdr_Fnd_ProcessFlow_From_RMS

Run once for initial full item foundation data seed from Merchandising Foundation Data System.

2

Uda_Fnd_ProcessFlow_From_RMS

Run once for initial full User Defined Attribute (UDA) foundation data seed from Merchandising Foundation Data System.

2

DiffGrp_Fnd_ProcessFlow_From_RMS

Run once for initial full foundation data seed from Merchandising Foundation Data System.

2

CodeHead_Fnd_ProcessFlow_From_RMS

Run once for initial full Code Head foundation data seed from Merchandising Foundation Data System.

3

PckitemBrkout_Fnd_ProcessFlow_From_RMS

Run once for initial full Pack Item Breakout foundation data seed from Merchandising Foundation Data System.

3

RelatedItem_Fnd_ProcessFlow_From_RMS

Run once for initial full Related Item foundation data seed from Merchandising Foundation Data System.

4

ItemSupplier_Fnd_ProcessFlow_From_RMS

Run once for initial full Item Supplier foundation data seed from Merchandising Foundation Data System.

4

ItSupCtryDim_Fnd_ProcessFlow_From_RMS

Run once for initial full Item Supplier Country Dimension foundation data seed from Merchandising Foundation Data System.

4

ItSupCtry_Fnd_ProcessFlow_From_RMS

Run once for initial full Item Supplier Country foundation data seed from Merchandising Foundation Data System.

4

ItSupCtryManCtry_Fnd_ProcessFlow_From_RMS

Run once for initial full Item Supplier Manufacturing Country foundation data seed from Merchandising Foundation Data System.

4

ItemSuppUom_Fnd_ProcessFlow_From_RMS

Run once for initial full Item Supplier Unit of Measure foundation data seed from Merchandising Foundation Data System.

5

Store_Fnd_ProcessFlow_From_RMS

Run once for initial full store foundation data seed from Merchandising Foundation Data System.

5

StoreAddr_Fnd_ProcessFlow_From_RMS

Run once for initial full store address foundation data seed from Merchandising Foundation Data System.

6

ItemLoc_Fnd_ProcessFlow_From_RMS

Run once for initial full item location foundation data seed from Merchandising Foundation Data System.

6

InvAvailStore_Tx_ProcessFlow_From_RMS

Run once for initial full store available inventory foundation data seed from Merchandising Foundation Data System.

7

ReplItemLoc_Fnd_ProcessFlow_From_RMS

Run once for initial full replenishment item location inventory foundation data seed from Merchandising Foundation Data System.

7

PriceHist_Fnd_ProcessFlow_From_RMS

Run once for initial full item pricing history foundation data seed from Merchandising Foundation Data System.

8

ItemImage_Fnd_ProcessFlow_From_RMS

Run once for initial full item image foundation data seed from Merchandising Foundation Data System.

8

UomClass_Fnd_ProcessFlow_From_RMS

Run once for initial full Unit Of Measure foundation data seed from Merchandising Foundation Data System.

8

UdaItemDate_Fnd_ProcessFlow_From_RMS

Run once for initial full UDA Item Date foundation data seed from Merchandising Foundation Data System.

8

UdaItemFF_Fnd_ProcessFlow_From_RMS

Run once for initial full UDA Item Free Form foundation data seed from Merchandising Foundation Data System.

8

UdaItemLov_Fnd_ProcessFlow_From_RMS

Run once for initial full UDA Item LOV foundation data seed from Merchandising Foundation Data System.

8

UdaValues_Fnd_ProcessFlow_From_RMS

Run once for initial full UDA Values foundation data seed from Merchandising Foundation Data System.

9

CodeDetail_Fnd_ProcessFlow_From_RMS

Run once for initial full Code Detail foundation data seed from Merchandising Foundation Data System.

9

DeliverySlot_Fnd_ProcessFlow_From_RMS

Run once for initial full Delivery Slot foundation data seed from Merchandising Foundation Data System.

9

Diff_Fnd_ProcessFlow_From_RMS

Run once for initial full Differentiators foundation data seed from Merchandising Foundation Data System.

9

UomConversion_Fnd_ProcessFlow_From_RMS

Run once for initial full UOM Conversion foundation data seed from Merchandising Foundation Data System.


Data Seeding Mapping Tables between SIOCS and BDI

The table below specifies the Data Seeding Mapping tables Between SIOCS and BDI.

Table I-2 Data Seeding Mapping Tables between SIOCS and BDI

SIOCS Table BDI Interface Table

ADDRESS

STORE_ADDR_IN

PARTNER_ADDR_IN

WH_ADDR_IN

SUPPLIER_ADDR_IN

DIFFERENTIATOR

DIFF_IN

DIFFERENTIATOR_TYPE

DIFF_IN

ITEM

ITEM_HDR_IN

ITEM_COMPONENT

PACKITEM_BREAKOUT_IN

ITEM_HIERARCHY

MERCH_HIER_IN

ITEM_IMAGE

ITEM_IMAGE_IN

ITEM_PRICE

ITEM_LOC_IN

(LOC_TYPE = 'S')

ITEM_PRICE_HISTORY

PRICE_HIST_IN

ITEM_UDA

UDA_ITEM_LOV_IN

UDA_ITEM_FF_IN

UDA_ITEM_DATE_IN

PARTNER

PARTNER_IN

PARTNER_ITEM

ITEM_LOC_IN

(LOC_TYPE = 'E')

RELATED_ITEM

RELATED_ITEM_IN

RELATED_ITEM_TYPE

RELATED_ITEM_TYPE

STORE

STORE_IN

STORE_ITEM

ITEM_LOC_IN

(LOC_TYPE = 'S')

REPL_ITEM_LOC_IN

STORE_ITEM_STOCK

INV_AVAIL_STORE_IN

STORE_TRANSFER_ZONE

STORE_IN

SUPPLIER

SUPS_IN

SUPPLIER_ITEM

ITEM_SUPPLIER_IN

SUPPLIER_ITEM_COUNTRY

ITEM_SUPP_COUNTRY_IN

SUPPLIER_ITEM_COUNTRY_DIM

ITEM_SUP_CTY_DIM_IN

SUPPLIER_ITEM_MANUFACTURE

ITEM_SUP_MAN_CTY_IN

SUPPLIER_ITEM_UOM

ITEM_SUPP_UOM_IN

SUPPLIER_ORGANIZATION

PARTNER_ORG_UNIT_IN

UDA

UDA_IN

UDA_LOV

UDA_VALUES_IN

UOM_CLASS

UOM_CLASS_IN

UOM_CONVERSION

UOM_CONVERSION_IN

WAREHOUSE

WH_IN

WAREHOUSE_ITEM

ITEM_LOC_IN

(LOC_TYPE = 'W')