A Appendix: Exports

The tables in this appendix list the measures for the MFP Cloud Service exports.

MFP Cloud Service provides standard exports of multiple versions of approved and working plan data for all major workbook templates Merch Target, Merch Plan, Location Target, and Location Plan. Exported approved plans (Current Plan and Original Plan) data can be used by a retailer to interface with any other applications for reporting purposes or as input to other systems that need MFP Plan data. All exported files are in CSV format. All standard exports are copied to the Object Storage location from where the customer can download them.

For more information related to extracted measures, the approval process, and the administration process related to export, see the Oracle Retail Merchandise Financial Planning Retail Cloud Service User Guide and Oracle Retail Merchandise Financial Planning Cost Cloud Service User Guide

MFP Cloud Service Exports

This section lists the measures for the MFP Cloud Service exports. To standardize the exports between the MFP Retail and MFP Cost versions, the exported file format remains the same for both MFP Retail and MFP Cost versions. If a measure is not planned/used in MFP Retail or MFP Cost, that data will be exported as zero. The Retail/Cost column in the following table specifies in which version that measure is planned or used.

MFP Cloud Service Merch Plan - Current Plan Export

Export Version Name: Merch Plan - Current Plan

Export Version: mpcp

Export Mask Measure: MP Cp Export

Exported File: export_mpcp.dat

Table A-1 MFP Cloud Service Merch Plan - Current Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

scls

Subclass

 

chnc

Channel

 

mpcpbop1u

Cp BOP Reg+Promo U

real

pst

Retail/Cost

mpcpbop1r

Cp BOP Reg+Promo R

real

pst

Retail

mpcpbop1c

Cp BOP Reg+Promo C

real

pst

Cost

mpcpbop2u

Cp BOP Clr U

real

pst

Retail/Cost

mpcpbop2r

Cp BOP Clr R

real

pst

Retail

mpcpbop2c

Cp BOP Clr C

real

pst

Cost

mpcpbopu

Cp BOP U

real

pst

Retail/Cost

mpcpbopr

Cp BOP R

real

pst

Retail

mpcpbopc

Cp BOP C

real

pst

Retail/Cost

mpcpconsinvr

Cp Cons Inv R

real

total

Retail

mpcpconsinvc

Cp Cons Inv C

real

total

Cost

mpcpeop1u

Cp EOP Reg+Promo U

real

pet

Retail/Cost

mpcpeop1r

Cp EOP Reg+Promo R

real

pet

Retail

mpcpeop1c

Cp EOP Reg+Promo C

real

pet

Cost

mpcpeop2u

Cp EOP Clr U

real

pet

Retail/Cost

mpcpeop2r

Cp EOP Clr R

real

pet

Retail

mpcpeop2c

Cp EOP Clr C

real

pet

Cost

mpcpeopu

Cp EOP U

real

pet

Retail/Cost

mpcpeopr

Cp EOP R

real

pet

Retail

mpcpeopc

Cp EOP C

real

pet

Retail/Cost

mpcpgmr

Cp GM R

real

total

Retail/Cost

mpcpinvadju

Cp Inv Adj U

real

total

Retail/Cost

mpcpinvadjr

Cp Inv Adj R

real

total

Retail

mpcpinvadjc

Cp Inv Adj C

real

total

Cost

mpcpmiscadju

Cp Misc Adj U

real

total

Retail/Cost

mpcpmiscadjr

Cp Misc Adj R

real

total

Retail

mpcpmiscadjc

Cp Misc Adj c

real

total

Cost

mpcpmkd1r

Cp Markdown Reg+Promo R

real

total

Retail/Cost

mpcpmkd2r

Cp Markdown Clr R

real

total

Retail/Cost

mpcpmkdr

Cp Markdown R

real

total

Retail/Cost

mpcpmkdwfr

Cp Markdown due to W/F R

real

total

Retail/Cost

mpcpinvdv1r

Cp Inv Devaluation Reg+Promo R

real

total

Retail

mpcpinvdv2r

Cp Inv Devaluation Clr R

real

total

Retail

mpcpinvdvr

Cp Inv Devaluation R

real

total

Retail

mpcpmocu

Cp Move to Clr U

real

total

Retail/Cost

mpcpmocr

Cp Move to Clr R

real

total

Retail

mpcpmocc

Cp Move to Clr C

real

total

Cost

mpcpmosu

Cp MOS U

real

total

Retail/Cost

mpcpmosr

Cp MOS R

real

total

Retail

mpcpmosc

Cp MOS C

real

total

Retail/Cost

mpcpngmr

Cp Net GM R

real

total

Retail/Cost

mpcpnsls1u

Cp Net Sales Reg+Promo U

real

total

Retail/Cost

mpcpnsls1r

Cp Net Sales Reg+Promo R

real

total

Retail/Cost

mpcpnsls2u

Cp Net Sales Clr U

real

total

Retail/Cost

mpcpnsls2r

Cp Net Sales Clr R

real

total

Retail/Cost

mpcpnslsu

Cp Net Sales U

real

total

Retail/Cost

mpcpnslsr

Cp Net Sales R

real

total

Retail/Cost

mpcpnslsc

Cp Net Sales C

real

total

Cost

mpcprcptu

Cp Receipts U

real

total

Retail/Cost

mpcprcptr

Cp Receipts R

real

total

Retail/Cost

mpcprcptc

Cp Receipts C

real

total

Retail/Cost

mpcproyalr

Cp Royalties R

real

total

Retail/Cost

mpcprtn1u

Cp Returns Reg+Promo U

real

total

Retail/Cost

mpcprtn1r

Cp Returns Reg+Promo R

real

total

Retail/Cost

mpcprtn2u

Cp Returns Clr U

real

total

Retail/Cost

mpcprtn2r

Cp Returns Clr R

real

total

Retail/Cost

mpcprtnu

Cp Returns U

real

total

Retail/Cost

mpcprtnr

Cp Returns R

real

total

Retail/Cost

mpcpshrku

Cp Shrink U

real

total

Retail/Cost

mpcpshrkr

Cp Shrink R

real

total

Retail

mpcpshrkc

Cp Shrink C

real

total

Retail/Cost

mpcpsls1u

Cp Sales Reg+Promo U

real

total

Retail/Cost

mpcpsls1r

Cp Sales Reg+Promo R

real

total

Retail/Cost

mpcpsls2u

Cp Sales Clr U

real

total

Retail/Cost

mpcpsls2r

Cp Sales Clr R

real

total

Retail/Cost

mpcpslscmpr

Cp Comp Sales R

real

total

Retail/Cost

mpcpslsncpr

Cp Non-Comp Sales R

real

total

Retail/Cost

mpcpslsu

Cp Sales U

real

total

Retail/Cost

mpcpslsr

Cp Sales R

real

total

Retail/Cost

mpcpslsc

Cp Sales C

real

total

Retail/Cost

mpcpvndfndr

Cp Vendor Funds R

real

total

Retail/Cost

mpcpwfmkdr

Cp W/F Markdown R

real

total

Retail/Cost

mpcpwfmkur

Cp W/F Markup R

real

total

Retail/Cost

MFP Cloud Service Merch Plan - Original Plan Export

Export Version Name: Merch Plan - Original Plan

Export Version: mpop

Export Mask Measure: MP Op Export

Exported File: export_mpop.dat

Table A-2 MFP Cloud Service Merch Plan - Original Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

scls

Subclass

 

chnc

Channel

 

mpopbop1u

Op BOP Reg+Promo U

real

pst

Retail/Cost

mpopbop1r

Op BOP Reg+Promo R

real

pst

Retail

mpopbop1c

Op BOP Reg+Promo C

real

pst

Cost

mpopbop2u

Op BOP Clr U

real

pst

Retail/Cost

mpopbop2r

Op BOP Clr R

real

pst

Retail

mpopbop2c

Op BOP Clr C

real

pst

Cost

mpopbopu

Op BOP U

real

pst

Retail/Cost

mpopbopr

Op BOP R

real

pst

Retail

mpopbopc

Op BOP C

real

pst

Retail/Cost

mpopconsinvr

Op Cons Inv R

real

total

Retail

mpopconsinvc

Op Cons Inv C

real

total

Cost

mpopeop1u

Op EOP Reg+Promo U

real

pet

Retail/Cost

mpopeop1r

Op EOP Reg+Promo R

real

pet

Retail

mpopeop1c

Op EOP Reg+Promo C

real

pet

Cost

mpopeop2u

Op EOP Clr U

real

pet

Retail/Cost

mpopeop2r

Op EOP Clr R

real

pet

Retail

mpopeop2c

Op EOP Clr C

real

pet

Cost

mpopeopu

Op EOP U

real

pet

Retail/Cost

mpopeopr

Op EOP R

real

pet

Retail

mpopeopc

Op EOP C

real

pet

Retail/Cost

mpopgmr

Op GM R

real

total

Retail/Cost

mpopinvadju

Op Inv Adj U

real

total

Retail/Cost

mpopinvadjr

Op Inv Adj R

real

total

Retail

mpopinvadjc

Op Inv Adj C

real

total

Cost

mpopmiscadju

Op Misc Adj U

real

total

Retail/Cost

mpopmiscadjr

Op Misc Adj R

real

total

Retail

mpopmiscadjc

Op Misc Adj C

real

total

Cost

mpopmkd1r

Op Markdown Reg+Promo R

real

total

Retail/Cost

mpopmkd2r

Op Markdown Clr R

real

total

Retail/Cost

mpopmkdr

Op Markdown R

real

total

Retail/Cost

mpopmkdwfr

Op Markdown due to W/F R

real

total

Retail/Cost

mpopinvdv1r

Op Inv Devaluation Reg+Promo R

real

total

Retail

mpopinvdv2r

Op Inv Devaluation Clr R

real

total

Retail

mpopinvdvr

Op Inv Devaluation R

real

total

Retail

mpopmocu

Op Move to Clr U

real

total

Retail/Cost

mpopmocr

Op Move to Clr R

real

total

Retail

mpopmocc

Op Move to Clr C

real

total

Cost

mpopmosu

Op MOS U

real

total

Retail/Cost

mpopmosr

Op MOS R

real

total

Retail

mpopmosc

Op MOS C

real

total

Retail/Cost

mpopngmr

Op Net GM R

real

total

Retail/Cost

mpopnsls1u

Op Net Sales Reg+Promo U

real

total

Retail/Cost

mpopnsls1r

Op Net Sales Reg+Promo R

real

total

Retail/Cost

mpopnsls2u

Op Net Sales Clr U

real

total

Retail/Cost

mpopnsls2r

Op Net Sales Clr R

real

total

Retail/Cost

mpopnslsu

Op Net Sales U

real

total

Retail/Cost

mpopnslsr

Op Net Sales R

real

total

Retail/Cost

mpopnslsc

Op Net Sales C

real

total

Retail/Cost

mpoprcptu

Op Receipts U

real

total

Retail/Cost

mpoprcptr

Op Receipts R

real

total

Retail/Cost

mpoprcptc

Op Receipts C

real

total

Retail

mpoproyalr

Op Royalties R

real

total

Retail/Cost

mpoprtn1u

Op Returns Reg+Promo U

real

total

Retail/Cost

mpoprtn1r

Op Returns Reg+Promo R

real

total

Retail/Cost

mpoprtn2u

Op Returns Clr U

real

total

Retail/Cost

mpoprtn2r

Op Returns Clr R

real

total

Retail/Cost

mpoprtnu

Op Returns U

real

total

Retail/Cost

mpoprtnr

Op Returns R

real

total

Retail/Cost

mpopshrku

Op Shrink U

real

total

Retail/Cost

mpopshrkr

Op Shrink R

real

total

Retail

mpopshrkc

Op Shrink C

real

total

Retail/Cost

mpopsls1u

Op Sales Reg+Promo U

real

total

Retail/Cost

mpopsls1r

Op Sales Reg+Promo R

real

total

Retail/Cost

mpopsls2u

Op Sales Clr U

real

total

Retail/Cost

mpopsls2r

Op Sales Clr R

real

total

Retail/Cost

mpopslscmpr

Op Comp Sales R

real

total

Retail/Cost

mpopslsncpr

Op Non-Comp Sales R

real

total

Retail/Cost

mpopslsu

Op Sales U

real

total

Retail/Cost

mpopslsr

Op Sales R

real

total

Retail/Cost

mpopslsc

Op Sales C

real

total

Retail/Cost

mpopvndfndr

Op Vendor Funds R

real

total

Retail/Cost

mpopwfmkdr

Op W/F Markdown R

real

total

Retail/Cost

mpopwfmkur

Op W/F Markup R

real

total

Retail/Cost

MFP Cloud Service Merch Plan - Submitted Plan Export

Export Version Name: Merch Plan - Submitted Plan

Export Version: mpwa

Export Mask Measure: MP Wa Export

Exported File: export_mpwa.dat

Table A-3 MFP Cloud Service Merch Plan - Submitted Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

scls

Subclass

 

chnc

Channel

 

mpwabop1u

Wa BOP Reg+Promo U

real

pst

Retail/Cost

mpwabop1r

Wa BOP Reg+Promo R

real

pst

Retail

mpwabop1c

Wa BOP Reg+Promo C

real

pst

Cost

mpwabop2u

Wa BOP Clr U

real

pst

Retail/Cost

mpwabop2r

Wa BOP Clr R

real

pst

Retail

mpwabop2c

Wa BOP Clr C

real

pst

Cost

mpwabopu

Wa BOP U

real

pst

Retail/Cost

mpwabopr

Wa BOP R

real

pst

Retail

mpwabopc

Wa BOP C

real

pst

Retail/Cost

mpwaconsinvr

Wa Cons Inv R

real

total

Retail/Cost

mpwaconsinvc

Wa Cons Inv C

real

total

Cost

mpwaeop1u

Wa EOP Reg+Promo U

real

pet

Retail/Cost

mpwaeop1r

Wa EOP Reg+Promo R

real

pet

Retail

mpwaeop1c

Wa EOP Reg+Promo C

real

pet

Cost

mpwaeop2u

Wa EOP Clr U

real

pet

Retail/Cost

mpwaeop2r

Wa EOP Clr R

real

pet

Retail

mpwaeop2c

Wa EOP Clr C

real

pet

Cost

mpwaeopu

Wa EOP U

real

pet

Retail/Cost

mpwaeopr

Wa EOP R

real

pet

Cost

mpwaeopc

Wa EOP C

real

pet

Retail/Cost

mpwagmr

Wa GM R

real

total

Retail/Cost

mpwainvadju

Wa Inv Adj U

real

total

Retail/Cost

mpwainvadjr

Wa Inv Adj R

real

total

Retail

mpwainvadjc

Wa Inv Adj C

real

total

Cost

mpwamiscadju

Wa Misc Adj U

real

total

Retail/Cost

mpwamiscadjr

Wa Misc Adj R

real

total

Retail

mpwamiscadjc

Wa Misc Adj C

real

total

Cost

mpwamkd1r

Wa Markdown Reg+Promo R

real

total

Retail/Cost

mpwamkd2r

Wa Markdown Clr R

real

total

Retail/Cost

mpwamkdr

Wa Markdown R

real

total

Retail/Cost

mpwamkdwfr

Wa Markdown due to W/F R

real

total

Retail/Cost

mpwainvdv1r

Wa Inv Devaluation Reg+Promo R

real

total

Retail

mpwainvdv2r

Wa Inv Devaluation Clr R

real

total

Retail

mpwainvdvr

Wa Inv Devaluation R

real

total

Retail

mpwamocu

Wa Move to Clr U

real

total

Retail/Cost

mpwamocr

Wa Move to Clr R

real

total

Retail

mpwamocc

Wa Move to Clr C

real

total

Cost

mpwamosu

Wa MOS U

real

total

Retail/Cost

mpwamosr

Wa MOS R

real

total

Retail

mpwamosc

Wa MOS C

real

total

Retail/Cost

mpwangmr

Wa Net GM R

real

total

Retail/Cost

mpwansls1u

Wa Net Sales Reg+Promo U

real

total

Retail/Cost

mpwansls1r

Wa Net Sales Reg+Promo R

real

total

Retail/Cost

mpwansls2u

Wa Net Sales Clr U

real

total

Retail/Cost

mpwansls2r

Wa Net Sales Clr R

real

total

Retail/Cost

mpwanslsu

Wa Net Sales U

real

total

Retail/Cost

mpwanslsr

Wa Net Sales R

real

total

Retail/Cost

mpwanslsc

Wa Net Sales C

real

total

Cost

mpwarcptu

Wa Receipts U

real

total

Retail/Cost

mpwarcptr

Wa Receipts R

real

total

Retail/Cost

mpwarcptc

Wa Receipts C

real

total

Retail/Cost

mpwaroyalr

Wa Royalties R

real

total

Retail/Cost

mpwartn1u

Wa Returns Reg+Promo U

real

total

Retail/Cost

mpwartn1r

Wa Returns Reg+Promo R

real

total

Retail/Cost

mpwartn2u

Wa Returns Clr U

real

total

Retail/Cost

mpwartn2r

Wa Returns Clr R

real

total

Retail/Cost

mpwartnu

Wa Returns U

real

total

Retail/Cost

mpwartnr

Wa Returns R

real

total

Retail/Cost

mpwashrku

Wa Shrink U

real

total

Retail/Cost

mpwashrkr

Wa Shrink R

real

total

Retail

mpwashrkc

Wa Shrink C

real

total

Retail/Cost

mpwasls1u

Wa Sales Reg+Promo U

real

total

Retail/Cost

mpwasls1r

Wa Sales Reg+Promo R

real

total

Retail/Cost

mpwasls2u

Wa Sales Clr U

real

total

Retail/Cost

mpwasls2r

Wa Sales Clr R

real

total

Retail/Cost

mpwaslscmpr

Wa Comp Sales R

real

total

Retail/Cost

mpwaslsncpr

Wa Non-Comp Sales R

real

total

Retail/Cost

mpwaslsu

Wa Sales U

real

total

Retail/Cost

mpwaslsr

Wa Sales R

real

total

Retail/Cost

mpwaslsc

Wa Sales C

real

total

Retail/Cost

mpwavndfndr

Wa Vendor Funds R

real

total

Retail/Cost

mpwawfmkdr

Wa W/F Markdown R

real

total

Retail/Cost

mpwawfmkur

Wa W/F Markup R

real

total

Retail/Cost

MFP Cloud Service Merch Plan - Working Plan Export

Export Version Name: Merch Plan - Working Plan

Export Version: mpwp

Export Mask Measure: MP Wp Export

Exported File: export_mpwp.dat

Table A-4 MFP Cloud Service Merch Plan - Working Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

scls

Subclass

 

chnc

Channel

 

mpwpbop1u

Wp BOP Reg+Promo U

real

pst

Retail/Cost

mpwpbop1r

Wp BOP Reg+Promo R

real

pst

Retail

mpwpbop1c

Wp BOP Reg+Promo C

real

pst

Cost

mpwpbop2u

Wp BOP Clr U

real

pst

Retail/Cost

mpwpbop2r

Wp BOP Clr R

real

pst

Retail

mpwpbop2c

Wp BOP Clr C

real

pst

Cost

mpwpbopu

Wp BOP U

real

pst

Retail/Cost

mpwpbopr

Wp BOP R

real

pst

Retail

mpwpbopc

Wp BOP C

real

pst

Retail/Cost

mpwpconsinvr

Wp Cons Inv R

real

total

Retail

mpwpconsinvc

Wp Cons Inv C

real

total

Cost

mpwpeop1u

Wp EOP Reg+Promo U

real

pet

Retail/Cost

mpwpeop1r

Wp EOP Reg+Promo R

real

pet

Retail

mpwpeop1c

Wp EOP Reg+Promo C

real

pet

Cost

mpwpeop2u

Wp EOP Clr U

real

pet

Retail/Cost

mpwpeop2r

Wp EOP Clr R

real

pet

Retail

mpwpeop2c

Wp EOP Clr C

real

pet

Cost

mpwpeopu

Wp EOP U

real

pet

Retail/Cost

mpwpeopr

Wp EOP R

real

pet

Retail

mpwpeopc

Wp EOP C

real

pet

Retail/Cost

mpwpgmr

Wp GM R

real

total

Retail/Cost

mpwpinvadju

Wp Inv Adj U

real

total

Retail/Cost

mpwpinvadjr

Wp Inv Adj R

real

total

Retail

mpwpinvadjc

Wp Inv Adj C

real

total

Cost

mpwpmiscadju

Wp Misc Adj U

real

total

Retail/Cost

mpwpmiscadjr

Wp Misc Adj R

real

total

Retail

mpwpmiscadjc

Wp Misc Adj C

real

total

Cost

mpwpmkd1r

Wp Markdown Reg+Promo R

real

total

Retail/Cost

mpwpmkd2r

Wp Markdown Clr R

real

total

Retail/Cost

mpwpmkdr

Wp Markdown R

real

total

Retail/Cost

mpwpmkdwfr

Wp Markdown due to W/F R

real

total

Retail/Cost

mpwpinvdv1r

Wp Inv Devaluation Reg+Promo R

real

total

Retail

mpwpinvdv2r

Wp Inv Devaluation Clr R

real

total

Retail

mpwpinvdvr

Wp Inv Devaluation R

real

total

Retail

mpwpmocu

Wp Move to Clr U

real

total

Retail/Cost

mpwpmocr

Wp Move to Clr R

real

total

Retail

mpwpmocc

Wp Move to Clr C

real

total

Cost

mpwpmosu

Wp MOS U

real

total

Retail/Cost

mpwpmosr

Wp MOS R

real

total

Retail

mpwpmosc

Wp MOS C

real

total

Retail/Cost

mpwpngmr

Wp Net GM R

real

total

Retail/Cost

mpwpnsls1u

Wp Net Sales Reg+Promo U

real

total

Retail/Cost

mpwpnsls1r

Wp Net Sales Reg+Promo R

real

total

Retail/Cost

mpwpnsls2u

Wp Net Sales Clr U

real

total

Retail/Cost

mpwpnsls2r

Wp Net Sales Clr R

real

total

Retail/Cost

mpwpnslsu

Wp Net Sales U

real

total

Retail/Cost

mpwpnslsr

Wp Net Sales R

real

total

Retail/Cost

mpwpnslsc

Wp Net Sales C

real

total

Cost

mpwprcptu

Wp Receipts U

real

total

Retail/Cost

mpwprcptr

Wp Receipts R

real

total

Retail/Cost

mpwprcptc

Wp Receipts C

real

total

Retail/Cost

mpwproyalr

Wp Royalties R

real

total

Retail/Cost

mpwprtn1u

Wp Returns Reg+Promo U

real

total

Retail/Cost

mpwprtn1r

Wp Returns Reg+Promo R

real

total

Retail/Cost

mpwprtn2u

Wp Returns Clr U

real

total

Retail/Cost

mpwprtn2r

Wp Returns Clr R

real

total

Retail/Cost

mpwprtnu

Wp Returns U

real

total

Retail/Cost

mpwprtnr

Wp Returns R

real

total

Retail/Cost

mpwpshrku

Wp Shrink U

real

total

Retail/Cost

mpwpshrkr

Wp Shrink R

real

total

Retail

mpwpshrkc

Wp Shrink C

real

total

Retail/Cost

mpwpsls1u

Wp Sales Reg+Promo U

real

total

Retail/Cost

mpwpsls1r

Wp Sales Reg+Promo R

real

total

Retail/Cost

mpwpsls2u

Wp Sales Clr U

real

total

Retail/Cost

mpwpsls2r

Wp Sales Clr R

real

total

Retail/Cost

mpwpslscmpr

Wp Comp Sales R

real

total

Retail/Cost

mpwpslsncpr

Wp Non-Comp Sales R

real

total

Retail/Cost

mpwpslsu

Wp Sales U

real

total

Retail/Cost

mpwpslsr

Wp Sales R

real

total

Retail/Cost

mpwpslsc

Wp Sales C

real

total

Retail/Cost

mpwpvndfndr

Wp Vendor Funds R

real

total

Retail/Cost

mpwpwfmkdr

Wp W/F Markdown R

real

total

Retail/Cost

mpwpwfmkur

Wp W/F Markup R

real

total

Retail/Cost

mpwpooadju

Wp On Order Adj U

real

total

Retail/Cost

mpwpooadjr

Wp On Order Adj R

real

total

Retail

mpwpooadjc

Wp On Order Adj C

real

total

Retail/Cost

mpwpoou

Wp On Order U

real

total

Retail/Cost

mpwpoor

Wp On Order R

real

total

Retail

mpwpooc

Wp On Order C

real

total

Retail/Cost

MFP Cloud Service Merch Target - Target Plan Export

Export Version Name: Merch Target - Target Plan

Export Version: mttg

Export Mask Measure: MT Tgt Export

Exported File: export_mttg.dat

Table A-5 MFP Cloud Service Merch Target - Target Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

dept

Department

 

chnc

Channel

 

mttgbop1u

Tgt BOP Reg+Promo U

real

pst

Retail/Cost

mttgbop1r

Tgt BOP Reg+Promo R

real

pst

Retail

mttgbop1c

Tgt BOP Reg+Promo C

real

pst

Cost

mttgbop2u

Tgt BOP Clr U

real

pst

Retail/Cost

mttgbop2r

Tgt BOP Clr R

real

pst

Retail

mttgbop2c

Tgt BOP Clr C

real

pst

Cost

mttgbopu

Tgt BOP U

real

pst

Retail/Cost

mttgbopr

Tgt BOP R

real

pst

Retail

mttgbopc

Tgt BOP C

real

pst

Retail/Cost

mttgconsinvr

Tgt Cons Inv R

real

total

Retail

mttgconsinvc

Tgt Cons Inv C

real

total

Cost

mttgeop1u

Tgt EOP Reg+Promo U

real

pet

Retail/Cost

mttgeop1r

Tgt EOP Reg+Promo R

real

pet

Retail

mttgeop1c

Tgt EOP Reg+Promo C

real

pet

Cost

mttgeop2u

Tgt EOP Clr U

real

pet

Retail/Cost

mttgeop2r

Tgt EOP Clr R

real

pet

Retail

mttgeop2c

Tgt EOP Clr C

real

pet

Cost

mttgeopu

Tgt EOP U

real

pet

Retail/Cost

mttgeopr

Tgt EOP R

real

pet

Retail

mttgeopc

Tgt EOP C

real

pet

Retail/Cost

mttggmr

Tgt GM R

real

total

Retail/Cost

mttginvadju

Tgt Inv Adj U

real

total

Retail/Cost

mttginvadjr

Tgt Inv Adj R

real

total

Retail

mttginvadjc

Tgt Inv Adj C

real

total

Cost

mttgmiscadju

Tgt Misc Adj U

real

total

Retail/Cost

mttgmiscadjr

Tgt Misc Adj R

real

total

Retail

mttgmiscadjc

Tgt Misc Adj C

real

total

Cost

mttgmkd1r

Tgt Markdown Reg+Promo R

real

total

Retail/Cost

mttgmkd2r

Tgt Markdown Clr R

real

total

Retail/Cost

mttgmkdr

Tgt Markdown R

real

total

Retail/Cost

mttgmkdwfr

Tgt Markdown due to W/F R

real

total

Retail/Cost

mttginvdv1r

Tgt Inv Devaluation Reg+Promo R

real

total

Retail

mttginvdv2r

Tgt Inv Devaluation Clr R

real

total

Retail

mttginvdvr

Tgt Inv Devaluation R

real

total

Retail

mttgmocu

Tgt Move to Clr U

real

total

Retail/Cost

mttgmocr

Tgt Move to Clr R

real

total

Retail

mttgmocc

Tgt Move to Clr C

real

total

Cost

mttgmosu

Tgt MOS U

real

total

Retail/Cost

mttgmosr

Tgt MOS R

real

total

Retail

mttgmosc

Tgt MOS C

real

total

Retail/Cost

mttgngmr

Tgt Net GM R

real

total

Retail/Cost

mttgnsls1u

Tgt Net Sales Reg+Promo U

real

total

Retail/Cost

mttgnsls1r

Tgt Net Sales Reg+Promo R

real

total

Retail/Cost

mttgnsls2u

Tgt Net Sales Clr U

real

total

Retail/Cost

mttgnsls2r

Tgt Net Sales Clr R

real

total

Retail/Cost

mttgnslsu

Tgt Net Sales U

real

total

Retail/Cost

mttgnslsr

Tgt Net Sales R

real

total

Retail/Cost

mttgnslsc

Tgt Net Sales C

real

total

Cost

mttgrcptu

Tgt Receipts U

real

total

Retail/Cost

mttgrcptr

Tgt Receipts R

real

total

Retail/Cost

mttgrcptc

Tgt Receipts C

real

total

Retail/Cost

mttgroyalr

Tgt Royalties R

real

total

Retail/Cost

mttgrtn1u

Tgt Returns Reg+Promo U

real

total

Retail/Cost

mttgrtn1r

Tgt Returns Reg+Promo R

real

total

Retail/Cost

mttgrtn2u

Tgt Returns Clr U

real

total

Retail/Cost

mttgrtn2r

Tgt Returns Clr R

real

total

Retail/Cost

mttgrtnu

Tgt Returns U

real

total

Retail/Cost

mttgrtnr

Tgt Returns R

real

total

Retail/Cost

mttgshrku

Tgt Shrink U

real

total

Retail/Cost

mttgshrkr

Tgt Shrink R

real

total

Retail

mttgshrkc

Tgt Shrink C

real

total

Retail/Cost

mttgsls1u

Tgt Sales Reg+Promo U

real

total

Retail/Cost

mttgsls1r

Tgt Sales Reg+Promo R

real

total

Retail/Cost

mttgsls2u

Tgt Sales Clr U

real

total

Retail/Cost

mttgsls2r

Tgt Sales Clr R

real

total

Retail/Cost

mttgslsu

Tgt Sales U

real

total

Retail/Cost

mttgslsr

Tgt Sales R

real

total

Retail/Cost

mttgslsc

Tgt Sales C

real

total

Retail/Cost

mttgslscmpr

Tgt Comp Sales R

real

total

Retail/Cost

mttgslsncpr

Tgt Non-Comp Sales R

real

total

Retail/Cost

mttgvndfndr

Tgt Vendor Funds R

real

total

Retail/Cost

mttgwfmkdr

Tgt W/F Markdown R

real

total

Retail/Cost

mttgwfmkur

Tgt W/F Markup R

real

total

Retail/Cost

MFP Cloud Service Merch Target - Working Plan Export

Export Version Name: Merch Target - Working Plan

Export Version: mtwp

Export Mask Measure: MT Wp Export

Exported File: export_mtwp.dat

Table A-6 MFP Cloud Service Merch Target - Working Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

dept

Department

 

chnc

Channel

 

mtwpbop1u

Wp BOP Reg+Promo U

real

pst

Retail/Cost

mtwpbop1r

Wp BOP Reg+Promo R

real

pst

Retail

mtwpbop1c

Wp BOP Reg+Promo C

real

pst

Cost

mtwpbop2u

Wp BOP Clr U

real

pst

Retail/Cost

mtwpbop2r

Wp BOP Clr R

real

pst

Retail

mtwpbop2c

Wp BOP Clr C

real

pst

Cost

mtwpbopu

Wp BOP U

real

pst

Retail/Cost

mtwpbopr

Wp BOP R

real

pst

Retail

mtwpbopc

Wp BOP C

real

pst

Retail/Cost

mtwpconsinvr

Wp Cons Inv R

real

total

Retail

mtwpconsinvc

Wp Cons Inv C

real

total

Cost

mtwpeop1u

Wp EOP Reg+Promo U

real

pet

Retail/Cost

mtwpeop1r

Wp EOP Reg+Promo R

real

pet

Retail

mtwpeop1c

Wp EOP Reg+Promo C

real

pet

Cost

mtwpeop2u

Wp EOP Clr U

real

pet

Retail/Cost

mtwpeop2r

Wp EOP Clr R

real

pet

Retail

mtwpeop2c

Wp EOP Clr C

real

pet

Cost

mtwpeopu

Wp EOP U

real

pet

Retail/Cost

mtwpeopr

Wp EOP R

real

pet

Retail

mtwpeopc

Wp EOP C

real

pet

Retail/Cost

mtwpgmr

Wp GM R

real

total

Retail/Cost

mtwpinvadju

Wp Inv Adj U

real

total

Retail/Cost

mtwpinvadjr

Wp Inv Adj R

real

total

Retail

mtwpinvadjc

Wp Inv Adj C

real

total

Cost

mtwpmiscadju

Wp Misc Adj U

real

total

Retail/Cost

mtwpmiscadjr

Wp Misc Adj R

real

total

Retail

mtwpmiscadjc

Wp Misc Adj C

real

total

Cost

mtwpmkd1r

Wp Markdown Reg+Promo R

real

total

Retail/Cost

mtwpmkd2r

Wp Markdown Clr R

real

total

Retail/Cost

mtwpmkdr

Wp Markdown R

real

total

Retail/Cost

mtwpmkdwfr

Wp Markdown due to W/F R

real

total

Retail/Cost

mtwpinvdv1r

Wp Inv Devaluation Reg+Promo R

real

total

Retail

mtwpinvdv2r

Wp Inv Devaluation Clr R

real

total

Retail

mtwpinvdvr

Wp Inv Devaluation R

real

total

Retail

mtwpmocu

Wp Move to Clr U

real

total

Retail/Cost

mtwpmocr

Wp Move to Clr R

real

total

Retail

mtwpmocc

Wp Move to Clr C

real

total

Cost

mtwpmosu

Wp MOS U

real

total

Retail/Cost

mtwpmosr

Wp MOS R

real

total

Retail

mtwpmosc

Wp MOS C

real

total

Retail/Cost

mtwpngmr

Wp Net GM R

real

total

Retail/Cost

mtwpnsls1u

Wp Net Sales Reg+Promo U

real

total

Retail/Cost

mtwpnsls1r

Wp Net Sales Reg+Promo R

real

total

Retail/Cost

mtwpnsls2u

Wp Net Sales Clr U

real

total

Retail/Cost

mtwpnsls2r

Wp Net Sales Clr R

real

total

Retail/Cost

mtwpnslsu

Wp Net Sales U

real

total

Retail/Cost

mtwpnslsr

Wp Net Sales R

real

total

Retail/Cost

mtwpnslsc

Wp Net Sales C

real

total

Cost

mtwprcptu

Wp Receipts U

real

total

Retail/Cost

mtwprcptr

Wp Receipts R

real

total

Retail/Cost

mtwprcptc

Wp Receipts C

real

total

Retail/Cost

mtwproyalr

Wp Royalties R

real

total

Retail/Cost

mtwprtn1u

Wp Returns Reg+Promo U

real

total

Retail/Cost

mtwprtn1r

Wp Returns Reg+Promo R

real

total

Retail/Cost

mtwprtn2u

Wp Returns Clr U

real

total

Retail/Cost

mtwprtn2r

Wp Returns Clr R

real

total

Retail/Cost

mtwprtnu

Wp Returns U

real

total

Retail/Cost

mtwprtnr

Wp Returns R

real

total

Retail/Cost

mtwpshrku

Wp Shrink U

real

total

Retail/Cost

mtwpshrkr

Wp Shrink R

real

total

Retail

mtwpshrkc

Wp Shrink C

real

total

Retail/Cost

mtwpsls1u

Wp Sales Reg+Promo U

real

total

Retail/Cost

mtwpsls1r

Wp Sales Reg+Promo R

real

total

Retail/Cost

mtwpsls2u

Wp Sales Clr U

real

total

Retail/Cost

mtwpsls2r

Wp Sales Clr R

real

total

Retail/Cost

mtwpslsu

Wp Sales U

real

total

Retail/Cost

mtwpslsr

Wp Sales R

real

total

Retail/Cost

mtwpslsc

Wp Sales C

real

total

Retail/Cost

mtwpslscmpr

Wp Comp Sales R

real

total

Retail/Cost

mtwpslsncpr

Wp Non-Comp Sales R

real

total

Retail/Cost

mtwpvndfndr

Wp Vendor Funds R

real

total

Retail/Cost

mtwpwfmkdr

Wp W/F Markdown R

real

total

Retail/Cost

mtwpwfmkur

Wp W/F Markup R

real

total

Retail/Cost

mtwpooadju

Wp On Order Adj U

real

total

Retail/Cost

mtwpooadjr

Wp On Order Adj R

real

total

Retail

mtwpooadjc

Wp On Order Adj C

real

total

Retail/Cost

mtwpoou

Wp On Order U

real

total

Retail/Cost

mtwpoor

Wp On Order R

real

total

Retail

mtwpooc

Wp On Order C

real

total

Retail/Cost

MFP Cloud Service Location Plan - Current Plan Export

Export Version Name: Location Plan - Current Plan

Export Version: lpcp

Export Mask Measure: LP Cp Export

Exported File: export_lpcp.dat

Table A-7 MFP Cloud Service Location Plan - Current Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

dept

Department

stor

Location

lpcpbopu

Cp BOP U

real

pst

Retail/Cost

lpcpbopr

Cp BOP R

real

pst

Retail

lpcpbopc

Cp BOP C

real

pst

Retail/Cost

lpcpeopu

Cp EOP U

real

pet

Retail/Cost

lpcpeopr

Cp EOP R

real

pet

Retail

lpcpeopc

Cp EOP C

real

pet

Retail/Cost

lpcpmkdr

Cp Markdown R

real

total

Retail/Cost

lpcpmkdwfr

Cp Markdown due to W/F R

real

total

Retail/Cost

lpcpinvdvr

Cp Inv Devaluation R

real

total

Retail

lpcpnslsu

Cp Net Sales U

real

total

Retail/Cost

lpcpnslsr

Cp Net Sales R

real

total

Retail/Cost

lpcpnslsc

Cp Net Sales C

real

total

Cost

lpcprcptu

Cp Receipts U

real

total

Retail/Cost

lpcprcptr

Cp Receipts R

real

total

Retail/Cost

lpcprcptc

Cp Receipts C

real

total

Retail/Cost

lpcprtnu

Cp Returns U

real

total

Retail/Cost

lpcprtnr

Cp Returns R

real

total

Retail/Cost

lpcpshrku

Cp Shrink U

real

total

Retail/Cost

lpcpshrkr

Cp Shrink R

real

total

Retail

lpcpshrkc

Cp Shrink C

real

total

Retail/Cost

lpcpslsu

Cp Sales U

real

total

Retail/Cost

lpcpslsr

Cp Sales R

real

total

Retail/Cost

lpcpslsc

Cp Sales C

real

total

Retail/Cost

lpcptraniou

Cp Transfers In/Out U

real

total

Retail/Cost

lpcptranior

Cp Transfers In/Out R

real

total

Retail

lpcptranioc

Cp Transfers In/Out C

real

total

Cost

lpcpwfmkdr

Cp W/F Markdown R

real

total

Retail/Cost

lpcpwfmkur

Cp W/F Markup R

real

total

Retail/Cost

MFP Cloud Service Location Plan - Original Plan Export

Export Version Name: Location Plan - Original Plan

Export Version: lpop

Export Mask Measure: LP Op Export

Exported File: export_lpop.dat

Table A-8 MFP Cloud Service Location Plan - Original Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

dept

Department

 

stor

Location

 

lpopbopu

Op BOP U

real

pst

Retail/Cost

lpopbopr

Op BOP R

real

pst

Retail

lpopbopc

Op BOP C

real

pst

Retail/Cost

lpopeopu

Op EOP U

real

pet

Retail/Cost

lpopeopr

Op EOP R

real

pet

Retail

lpopeopc

Op EOP C

real

pet

Retail/Cost

lpopmkdr

Op Markdown R

real

total

Retail/Cost

lpopmkdwfr

Op Markdown due to W/F R

real

total

Retail/Cost

lpopinvdvr

Op Inv Devaluation R

real

total

Retail

lpopnslsu

Op Net Sales U

real

total

Retail/Cost

lpopnslsr

Op Net Sales R

real

total

Retail/Cost

lpopnslsc

Op Net Sales C

real

total

Cost

lpoprcptu

Op Receipts U

real

total

Retail/Cost

lpoprcptr

Op Receipts R

real

total

Retail/Cost

lpoprcptc

Op Receipts C

real

total

Retail/Cost

lpoprtnu

Op Returns U

real

total

Retail/Cost

lpoprtnr

Op Returns R

real

total

Retail/Cost

lpopshrku

Op Shrink U

real

total

Retail/Cost

lpopshrkr

Op Shrink R

real

total

Retail

lpopshrkc

Op Shrink C

real

total

Retail/Cost

lpopslsu

Op Sales U

real

total

Retail/Cost

lpopslsr

Op Sales R

real

total

Retail/Cost

lpopslsc

Op Sales C

real

total

Retail/Cost

lpoptraniou

Op Transfers In/Out U

real

total

Retail/Cost

lpoptranior

Op Transfers In/Out R

real

total

Retail

lpoptranioc

Op Transfers In/Out C

real

total

Cost

lpopwfmkdr

Op W/F Markdown R

real

total

Retail/Cost

lpopwfmkur

Op W/F Markup R

real

total

Retail/Cost

MFP Cloud Service Location Plan - Working Plan Export

Export Version Name: Location Plan - Working Plan

Export Version: lpwp

Export Mask Measure: LP Wp Export

Exported File: export_lpwp.dat

Table A-9 MFP Cloud Service Location Plan - Working Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

Retail/Cost

dept

Department

Retail/Cost

stor

Location

Retail/Cost

lpwpbopu

Wp BOP U

real

pst

Retail/Cost

lpwpbopr

Wp BOP R

real

pst

Retail

lpwpbopc

Wp BOP C

real

pst

Retail/Cost

lpwpeopu

Wp EOP U

real

pet

Retail/Cost

lpwpeopr

Wp EOP R

real

pet

Retail

lpwpeopc

Wp EOP C

real

pet

Retail/Cost

lpwpmkdr

Wp Markdown R

real

total

Retail/Cost

lpwpmkdwfr

Wp Markdown due to W/F R

real

total

Retail/Cost

lpwpinvdvr

Wp Inv Devaluation R

real

total

Retail

lpwpnslsu

Wp Net Sales U

real

total

Retail/Cost

lpwpnslsr

Wp Net Sales R

real

total

Retail/Cost

lpwpnslsc

Wp Net Sales C

real

total

Cost

lpwprcptu

Wp Receipts U

real

total

Retail/Cost

lpwprcptr

Wp Receipts R

real

total

Retail/Cost

lpwprcptc

Wp Receipts C

real

total

Retail/Cost

lpwprtnu

Wp Returns U

real

total

Retail/Cost

lpwprtnr

Wp Returns R

real

total

Retail/Cost

lpwpshrku

Wp Shrink U

real

total

Retail/Cost

lpwpshrkr

Wp Shrink R

real

total

Retail

lpwpshrkc

Wp Shrink C

real

total

Retail/Cost

lpwpslsu

Wp Sales U

real

total

Retail/Cost

lpwpslsr

Wp Sales R

real

total

Retail/Cost

lpwpslsc

Wp Sales C

real

total

Retail/Cost

lpwptraniou

Wp Transfers In/Out U

real

total

Retail/Cost

lpwptranior

Wp Transfers In/Out R

real

total

Retail

lpwptranioc

Wp Transfers In/Out C

real

total

Cost

lpwpwfmkdr

Wp W/F Markdown R

real

total

Retail/Cost

lpwpwfmkur

Wp W/F Markup R

real

total

Retail/Cost

lpwpooadju

Wp On Order Adj U

real

total

Retail/Cost

lpwpooadjr

Wp On Order Adj R

real

total

Retail

lpwpooadjc

Wp On Order Adj C

real

total

Cost

lpwpoou

Wp On Order U

real

total

Retail/Cost

lpwpoor

Wp On Order R

real

total

Retail

lpwpooc

Wp On Order C

real

total

Cost

MFP Cloud Service Location Target - Target Plan Export

Export Version Name: Location Target - Target Plan

Export Version: lttg

Export Mask Measure: LT Tgt Export

Exported File: export_lttg.dat

Table A-10 MFP Cloud Service Location Target - Target Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

cmpp

Company

 

stor

Location

 

lttgnslsu

Tgt Net Sales U

real

total

Retail/Cost

lttgnslsr

Tgt Net Sales R

real

total

Retail/Cost

lttgrtnu

Tgt Returns U

real

total

Retail/Cost

lttgrtnr

Tgt Returns R

real

total

Retail/Cost

lttgslsu

Tgt Sales U

real

total

Retail/Cost

lttgslsr

Tgt Sales R

real

total

Retail/Cost

MFP Cloud Service Location Target - Working Plan Export

Export Version Name: Location Target - Working Plan

Export Version: ltwp

Export Mask Measure: LT Wp Export

Exported File: export_ltwp.dat

Table A-11 MFP Cloud Service Location Target - Working Plan Export Measures

Measure Measure Label Data Type Aggregation Type Retail/Cost

week

Week

 

cmpp

Company

 

stor

Location

 

ltwpnslsu

Wp Net Sales U

real

total

Retail/Cost

ltwpnslsr

Wp Net Sales R

real

total

Retail/Cost

ltwprtnu

Wp Returns U

real

total

Retail/Cost

ltwprtnr

Wp Returns R

real

total

Retail/Cost

ltwpslsu

Wp Sales U

real

total

Retail/Cost

ltwpslsr

Wp Sales R

real

total

Retail/Cost