A Legacy Foundation File Reference
The following table provides a cross-reference for legacy application input files and the Retail Analytics and Planning files that replace them. This list covers foundation data flows which span multiple applications, such as MFP and RI. Other foundation files exist which do not replace multiple application files; those are specified in the Interfaces Guide in My Oracle Support.
| File Group | File Type | Legacy Planning Files | Legacy RI/AI Foundation Files | RAP Files |
|---|---|---|---|---|
|
Product |
Dimension |
prod.csv.dat |
W_PRODUCT_DS.dat W_PRODUCT_DS_TL.dat W_PROD_CAT_DHS.dat W_DOMAIN_MEMBER_DS_TL.dat W_RTL_PRODUCT_BRAND_DS.dat W_RTL_PRODUCT_BRAND_DS_TL.dat W_RTL_IT_SUPPLIER_DS.dat W_PARTY_ORG_DS.dat W_RTL_PRODUCT_IMAGE_DS.dat W_PRODUCT_ATTR_DS.dat W_RTL_ITEM_GRP1_DS.dat |
PRODUCT.csv |
|
Organization |
Dimension |
loc.csv.dat stor_metrics.csv.ovr |
W_INT_ORG_DS.dat W_INT_ORG_DS_TL.dat W_INT_ORG_DHS.dat W_DOMAIN_MEMBER_DS_TL.dat (for RTL_ORG) W_RTL_CHANNEL_DS.dat W_INT_ORG_ATTR_DS.dat |
ORGANIZATION.csv |
|
Calendar |
Dimension |
clnd.csv.dat |
W_MCAL_PERIOD_DS.dat |
CALENDAR.csv |
|
Exchange Rates |
Dimension |
curh.csv.dat curr.csv.ovr |
W_EXCH_RATE_GS.dat |
EXCH_RATE.csv |
|
Attributes |
Dimension |
patr.csv.dat patv.csv.ovr |
W_RTL_PRODUCT_ATTR_DS.dat W_RTL_PRODUCT_ATTR_DS_TL.dat W_DOMAIN_MEMBER_DS_TL.dat (for Diffs) W_RTL_PRODUCT_COLOR_DS.dat |
ATTR.csv |
|
Diff Groups |
Dimension |
sizh.hdr.csv.dat |
W_RTL_DIFF_GRP1_DS.dat W_RTL_DIFF_GRP1_DS_TL.dat |
DIFF_GROUP.csv |
|
Product Attribute Assignments |
Dimension |
prdatt.csv.ovr |
W_RTL_ITEM_GRP1_DS.dat |
PROD_ATTR.csv |
|
Sales |
Fact |
rsal.csv.ovr psal.csv.ovr csal.csv.ovr nsls.csv.ovr rtn.csv.ovr |
W_RTL_SLS_TRX_IT_LC_DY_FS.dat W_RTL_SLSPK_IT_LC_DY_FS.dat |
SALES.csv SALES_PACK.csv |
|
Inventory |
Fact |
eop.csv.ovr eopx.csv.ovr wsal.csv.ovr |
W_RTL_INV_IT_LC_DY_FS.dat |
INVENTORY.csv |
|
Markdown |
Fact |
mkd.csv.ovr |
W_RTL_MKDN_IT_LC_DY_FS.dat |
MARKDOWN.csv |
|
On Order |
Fact |
oo.csv.ovr |
W_RTL_PO_DETAILS_DS.dat W_RTL_PO_ONDORD_IT_LC_DY_FS.dat |
ORDER_HEAD.csv ORDER_DETAIL.csv |
|
PO Receipts |
Fact |
rcpt.csv.ovr |
W_RTL_INVRC_IT_LC_DY_FS.dat |
RECEIPT.csv |
|
Transfers |
Fact |
tranx.csv.ovr |
W_RTL_INVTSF_IT_LC_DY_FS.dat |
TRANSFER.csv |
|
Adjustments |
Fact |
tran.csv.ovr |
W_RTL_INVADJ_IT_LC_DY_FS.dat W_REASON_DS.dat |
ADJUSTMENT.csv REASON.csv |
|
RTVs |
Fact |
tran.csv.ovr |
W_RTL_INVRTV_IT_LC_DY_FS.dat |
RTV.csv |
|
Costs |
Fact |
slsprc.csv.ovr |
W_RTL_BCOST_IT_LC_DY_FS.dat W_RTL_NCOST_IT_LC_DY_FS.dat |
COST.csv |
|
Prices |
Fact |
slsprc.csv.ovr |
W_RTL_PRICE_IT_LC_DY_FS.dat |
PRICE.csv |
|
W/F Sales and Fees |
Fact |
tran.csv.ovr |
W_RTL_SLSWF_IT_LC_DY_FS.dat |
SALES_WF.csv |
|
Vendor Funds (TC 6/7) |
Fact |
tran.csv.ovr |
W_RTL_DEALINC_IT_LC_DY_FS.dat |
DEAL_INCOME.csv |
|
Reclass In/Out (TC 34/36) |
Fact |
tran.csv.ovr |
W_RTL_INVRECLASS_IT_LC_DY_FS.dat |
INV_RECLASS.csv |
|
Intercompany Margin (TC 39) |
Fact |
tran.csv.ovr |
W_RTL_ICM_IT_LC_DY_FS.dat |
IC_MARGIN.csv |