A Appendix: Integration with MFP Cloud Service
Assortment Planning Cloud Service can be integrated with MFP Cloud Service to interface the Plan data. This appendix provides details about the integration.
APCS needs MFPCS data to use Merchandise Financial Planning data as a target to align with final assortments. If both MFPCS and APCS are co-deployed in the same environment and both are using the GA version, then all integrated MFPCS measures will be readily available in APCS. When plans are approved in MFPCS, it will be readily available in APCS. No separate batch or integration is needed to interface the MFP Plan data.
Integration with MFP Cloud Service
The following table shows the list of measures shared between MFPCS and APCS pre-configured applications. All the ML measures are at the Week/Sub-Class/Store level and the LP measures are at the Week/Department/Store level. ML measures are directly used in the AP planning process templates but LP (Location Plan) measures are used only in the batch process which spreads Warehouse data to the location level if the customer uses the option to spread using Location Plan from MFP instead of last year actuals.
MFP Cloud Service to Assortment Planning Cloud Service
MFP Measure | MFPCS Label | APCS Label | File Name |
---|---|---|---|
mlcpeopc |
ML Cp EOP C |
MFP Loaded CP EOP C |
mfp_mpcp.csv.ovr |
mlcpeopr |
ML Cp EOP R |
MFP Loaded CP EOP R |
mfp_mpcp.csv.ovr |
mlcpeopu |
ML Cp EOP U |
MFP Loaded CP EOP U |
mfp_mpcp.csv.ovr |
mlcprcptc |
ML Cp Receipts C |
MFP Loaded CP Receipts C |
mfp_mpcp.csv.ovr |
mlcprcptr |
ML Cp Receipts R |
MFP Loaded CP Receipts R |
mfp_mpcp.csv.ovr |
mlcprcptu |
ML Cp Receipts U |
MFP Loaded CP Receipts U |
mfp_mpcp.csv.ovr |
mlcprtn1r |
ML Cp Returns Reg+Promo R |
MFP Loaded CP Returns Reg+Promo R |
mfp_mpcp.csv.ovr |
mlcprtn1u |
ML Cp Returns Reg+Promo U |
MFP Loaded CP Returns Reg+Promo U |
mfp_mpcp.csv.ovr |
mlcprtn2r |
ML Cp Returns Clr R |
MFP Loaded CP Returns Clear R |
mfp_mpcp.csv.ovr |
mlcprtn2u |
ML Cp Returns Clr U |
MFP Loaded CP Returns Clear U |
mfp_mpcp.csv.ovr |
mlcpsls1r |
ML Cp Sales Reg+Promo R |
MFP Loaded CP Sales Reg+Promo R |
mfp_mpcp.csv.ovr |
mlcpsls1u |
ML Cp Sales Reg+Promo U |
MFP Loaded CP Sales Reg+Promo U |
mfp_mpcp.csv.ovr |
mlcpsls2r |
ML Cp Sales Clr R |
MFP Loaded CP Sales Clr R |
mfp_mpcp.csv.ovr |
mlcpsls2u |
ML Cp Sales Clr U |
MFP Loaded CP Sales Clr U |
mfp_mpcp.csv.ovr |
mlcpslsc |
ML Cp Sales C |
MFP Loaded CP Sales Reg+Promo C |
mfp_mpcp.csv.ovr |
mlwpooadjc |
ML Wp On Order Adj C |
MFP Loaded WP On Order Adj C |
mfp_otb.csv.rpl |
mlwpooadjr |
ML Wp On Order Adj R |
MFP Loaded WP On Order Adj R |
mfp_otb.csv.rpl |
mlwpooadju |
ML Wp On Order Adj U |
MFP Loaded WP On Order Adj U |
mfp_otb.csv.rpl |
mlwpotbc |
ML Wp OTB C |
MFP Loaded WP OTB C |
mfp_otb.csv.rpl |
mlwpotbr |
ML Wp OTB R |
MFP Loaded WP OTB R |
mfp_otb.csv.rpl |
mlwpotbu |
ML Wp OTB U |
MFP Loaded WP OTB U |
mfp_otb.csv.rpl |
lplaeopc |
Ap EOP C |
LP AP EOP C |
mfp_lpap.csv.ovr |
lplapeopr |
Ap EOP R |
LP AP EOP R |
mfp_lpap.csv.ovr |
lplapeopu |
Ap EOP U |
LP AP EOP U |
mfp_lpap.csv.ovr |
lplaprcptc |
Ap Receipts C |
LP AP Receipts C |
mfp_lpap.csv.ovr |
lplaprcptr |
Ap Receipts R |
LP AP Receipts R |
mfp_lpap.csv.ovr |
lplaprcptu |
Ap Receipts U |
LP AP Receipts U |
mfp_lpap.csv.ovr |
lplaprtnr |
Ap Returns R |
LP AP Returns R |
mfp_lpap.csv.ovr |
lplaprtnu |
Ap Returns U |
LP AP Returns U |
mfp_lpap.csv.ovr |
lplaslsc |
Ap Sales C |
LP AP Sales C |
mfp_lpap.csv.ovr |
lplaslsr |
Ap Sales R |
LP AP Sales R |
mfp_lpap.csv.ovr |
lplaslsu |
Ap Sales U |
LP AP Sales U |
mfp_lpap.csv.ovr |
If the customer is using their own customized MFP, they can provide the MFP Plan data in csv file format with the measures grouped by File Name as defined in the above table interface with headers as the measure names.