Context

—to be develop

Dimensions

NameFile nameImplementation by fileImplementation by MFCS integration
CalendarCALENDAR.csvCalendar initialization using MFCS integration
Exchange ratesEXCH_RATE.csv

Facts

File nameImplementation by fileImplementation by MFCS integration
Allocations (header)W_RTL_ALC_IT_LC_DY_FS.dat
Allocations (details)W_RTL_ALC_DETAILS_DS.dat
ClearancesW_RTL_PRICE_CLR_IT_LC_DS.dat
Deal incomeDEAL_INCOME.csv
Inter company marginIC_MARGIN.csv
Inventory adjustmentsADJUSTMENT.csv
Inventory hsitoryINVENTORY.csv
Inventory transfersTRANSFER.csv
Markdown historyMARKDOWN.csv
Price HistoryPRICE.csv
Promotions
ReceiptsRECEIPT.csv
SalesSALES.csv
Sales discountW_RTL_SLSDSC_TRX_IT_LC_DY_FS.dat
Sales tenderW_RTL_TRX_TNDR_LC_DY_FS.dat
Shift Calendar
Shipments
Store compSTORE_COMP.csv
Store trafficW_RTL_STTRFC_LC_DY_MI_FS.dat
Supplier invoicesW_RTL_SUPP_IVC_PO_IT_FS.dat
Transfers (Details)W_RTL_TSF_DETAILS_DS.dat

To populate the staging tables using MFCS Integration, check How to seed all staging tables using MFCS integration


Reference