MFP Cloud Service Input Measure List
The following table lists the input data for an MFP Cloud Service implementation:
Table 2-1 MFP Cloud Service Input Measure List
| Measure Name | Measure Label | Load Intersection | Data Type | File Name | Solution Type | Required or Optional? | Data Source |
|---|---|---|---|---|---|---|---|
|
drtyeop1c |
Ty EOP Reg+Promo C |
week/sku/stor |
real |
eopx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyeop1r |
Ty EOP Reg+Promo R |
week/sku/stor |
real |
eopx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyeop1u |
Ty EOP Reg+Promo U |
week/sku/stor |
real |
eopx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyeop2c |
Ty EOP Clr C |
week/sku/stor |
real |
eopx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyeop2r |
Ty EOP Clr R |
week/sku/stor |
real |
eopx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyeop2u |
Ty EOP Clr U |
week/sku/stor |
real |
eopx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrinva1c |
Ty RMF Shrink Inventory Adjust C |
week/sku/stor |
real |
inva.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrinva1r |
Ty RMF Shrink Inventory Adjust R |
week/sku/stor |
real |
inva.csv.ovr |
Retail |
required |
RI |
|
drtyrinva1u |
Ty RMF Shrink Inventory Adjust U |
week/sku/stor |
real |
inva.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrinva2c |
Ty RMF Non-Shrink Inventory Adjust C |
week/sku/stor |
real |
inva.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrinva2r |
Ty RMF Non-Shrink Inventory Adjust R |
week/sku/stor |
real |
inva.csv.ovr |
Retail |
required |
RI |
|
drtyrinva2u |
Ty RMF Non-Shrink Inventory Adjust U |
week/sku/stor |
real |
inva.csv.ovr |
Retail/Cost |
required |
RI |
|
drtymkdcanr |
Ty Markdown Cancel R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
required |
RI |
|
drtymkdclrr |
Ty Markdown Clear R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
required |
RI |
|
drtymkdpclr |
Ty Markdown Promo Clear R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
required |
RI |
|
drtymkdpror |
Ty Markdown POS Promo R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
required |
RI |
|
drtymkdregr |
Ty Markdown Reg R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
required |
RI |
|
drtymkupr |
Ty Markup R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyicmkdr |
Ty Inter-Company Markdown POS R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtyicmkur |
Ty Inter-CompanyMarkup R |
week/sku/stor |
real |
mkd.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfmkdr |
Ty W/F Markdown R |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfmkur |
Ty W/F Markup R |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfslsu |
Ty W/F Sales U |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfslsc |
Ty W/F Sales C |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfslsr |
Ty W/F Sales R |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfrtnu |
Ty W/F Returns U |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfrtnc |
Ty W/F Returns C |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtywfrtnr |
Ty W/F Returns R |
week/sku/stor |
real |
wfms.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtynslsclrc |
Ty Net Sales Clear C |
week/sku/stor |
real |
nsls.csv.ovr |
Cost |
required |
RI |
|
drtynslsclrr |
Ty Net Sales Clear R |
week/sku/stor |
real |
nsls.csv.ovr |
Retail/Cost |
required |
RI |
|
drtynslsclru |
Ty Net Sales Clear U |
week/sku/stor |
real |
nsls.csv.ovr |
Retail/Cost |
required |
RI |
|
drtynslsproc |
Ty Net Sales Promo C |
week/sku/stor |
real |
nsls.csv.ovr |
Cost |
required |
RI |
|
drtynslspror |
Ty Net Sales Promo R |
week/sku/stor |
real |
nsls.csv.ovr |
Retail/Cost |
required |
RI |
|
drtynslsprou |
Ty Net Sales Promo U |
week/sku/stor |
real |
nsls.csv.ovr |
Retail/Cost |
required |
RI |
|
drtynslsregc |
Ty Net Sales Reg C |
week/sku/stor |
real |
nsls.csv.ovr |
Cost |
required |
RI |
|
drtynslsregr |
Ty Net Sales Reg R |
week/sku/stor |
real |
nsls.csv.ovr |
Retail/Cost |
required |
RI |
|
drtynslsregu |
Ty Net Sales Reg U |
week/sku/stor |
real |
nsls.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrtnclrc |
Ty Returns Clear C |
week/sku/stor |
real |
rtn.csv.ovr |
Cost |
required |
RI |
|
drtyrtnclrr |
Ty Returns Clear R |
week/sku/stor |
real |
rtn.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrtnclru |
Ty Returns Clear U |
week/sku/stor |
real |
rtn.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrtnproc |
Ty Returns Promo C |
week/sku/stor |
real |
rtn.csv.ovr |
Cost |
required |
RI |
|
drtyrtnpror |
Ty Returns Promo R |
week/sku/stor |
real |
rtn.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrtnprou |
Ty Returns Promo U |
week/sku/stor |
real |
rtn.csv.ovr |
Retail/Cost |
required/optional |
RI |
|
drtyrtnregc |
Ty Returns Reg C |
week/sku/stor |
real |
rtn.csv.ovr |
Cost |
required |
RI |
|
drtyrtnregr |
Ty Returns Reg R |
week/sku/stor |
real |
rtn.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyrtnregu |
Ty Returns Reg U |
week/sku/stor |
real |
rtn.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyooc |
Ty On Order C |
week/sku/stor |
real |
oo.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyoor |
Ty On Order R |
week/sku/stor |
real |
oo.csv.ovr |
Retail |
required |
RI |
|
drtyoou |
Ty On Order U |
week/sku/stor |
real |
oo.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyporcptc |
Ty PO Receipt C |
week/sku/stor |
real |
rcpt.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyporcptr |
Ty PO Receipt R |
week/sku/stor |
real |
rcpt.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyporcptu |
Ty PO Receipt U |
week/sku/stor |
real |
rcpt.csv.ovr |
Retail/Cost |
required |
RI |
|
drtytraninbc |
Ty Transfers In Book C |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytraninbr |
Ty Transfers In Book R |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytraninbu |
Ty Transfers In Book U |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytraninic |
Ty Transfers In ICT C |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytraninir |
Ty Transfers In ICT R |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytraniniu |
Ty Transfers In ICT U |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytraninr |
Ty Transfers In R |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytraninc |
Ty Transfers In C |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtytraninu |
Ty Transfers In U |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtytranoutbc |
Ty Transfers Out Book C |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytranoutbr |
Ty Transfers Out Book R |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytranoutbu |
Ty Transfers Out Book U |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytranoutic |
Ty Transfers Out ICT C |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytranoutir |
Ty Transfers Out ICT R |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytranoutiu |
Ty Transfers Out ICT U |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
optional |
RI |
|
drtytranoutr |
Ty Transfers Out R |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtytranoutu |
Ty Transfers Out U |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtytranoutc |
Ty Transfers Out C |
week/sku/stor |
real |
tranx.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyvndfndr |
Ty Vendor Funds R |
week/sku/stor |
real |
tran.csv.ovr |
Retail/Cost |
required |
RI |
|
drtyroyalr |
Ty Royalties R |
week/sku/stor |
real |
tran.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtycogsr |
Ty COGS Adj R |
week/sku/stor |
real |
tran.csv.ovr |
Retail |
optional |
Internal |
|
drtyconsinvc |
Ty Cons Inv C |
week/sku/stor |
real |
tran.csv.ovr |
Cost |
optional |
Internal |
|
drtyconsinvr |
Ty Cons Inv R |
week/sku/stor |
real |
tran.csv.ovr |
Retail |
optional |
Internal |
|
drtymiscadjc |
Ty Misc Adj C |
week/sku/stor |
real |
tran.csv.ovr |
Cost |
optional |
Internal |
|
drtymiscadjr |
Ty Misc Adj R |
week/sku/stor |
real |
tran.csv.ovr |
Retail |
optional |
Internal |
|
drtymiscadju |
Ty Misc Adj U |
week/sku/stor |
real |
tran.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtybocancu |
Ty Backorder Cancel U |
week/sku/stor |
real |
fulfill.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtybofulfillu |
Ty Backorder Fulfilled U |
week/sku/stor |
real |
fulfill.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtycancu |
Ty Cancel U |
week/sku/stor |
real |
fulfill.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtydemandu |
Ty Demand U |
week/sku/stor |
real |
fulfill.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyfulfillu |
Ty Fulfilled U |
week/sku/stor |
real |
fulfill.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtytrafficu |
Ty Traffic U |
week/sku/stor |
real |
fulfill.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyims1r |
Ty Pick up in Store (Reg+Promo) R |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyims1u |
Ty Pick up in Store (Reg+Promo) U |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyims2r |
Ty Pick up in Store (Clr) R |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyims2u |
Ty Pick up in Store (Clr) U |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtymtd1r |
Ty Return Back to Online (Reg+Promo) R |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtymtd1u |
Ty Return Back to Online (Reg+Promo) U |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtymtd2r |
Ty Return Back to Online (Clr) R |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtymtd2u |
Ty Return Back to Online (Clr) U |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtystc1r |
Ty Ship to Customer (Reg+Promo) R |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtystc1u |
Ty Ship to Customer (Reg+Promo) U |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtystc2r |
Ty Ship to Customer (Clr) R |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtystc2u |
Ty Ship to Customer (Clr) U |
week/sku/stor |
real |
fulfill_x.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtybisscvp |
Ty Buy in Store Ship to Customer % |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtybopisvp |
Ty Buy Online Pick-Up in Store % |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyborisvp |
Ty Buy Online, Return to Store % |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyborovp |
Ty Buy Online, Return Online % |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyincngstku |
Ty Store to Warehouse Restocking $/ U |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtymtdvp |
Ty Return Back to Online % |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtyonstku |
Ty Warehouse Restocking $/ U |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
drtystrstku |
Ty Store Restocking $/ U |
week_scls_ccty |
real |
fulfill_a.csv.ovr |
Retail/Cost |
optional |
Internal |
|
addvlagl2t |
Lag Lly |
week |
text |
lag.csv.ovr |
Retail/Cost |
required |
Admin |
|
addvlaglyt |
Lag Ly |
week |
text |
lag.csv.ovr |
Retail/Cost |
required |
Admin |
|
addvvatcp |
VAT C % |
week_vatb |
real |
vat.csv.ovr |
Retail |
required |
Admin |
|
addvvatvp |
VAT % |
week_vatb |
real |
vat.csv.ovr |
Retail/Cost |
required |
Admin |
|
addvlikepocd |
Like Location End Date |
stor |
date |
stor_a.csv.ovr |
Retail/Cost |
optional |
Admin |
|
addvlikepoct |
Like Location |
stor |
text |
stor_a.csv.ovr |
Retail/Cost |
optional |
Admin |
|
addvlocopnd |
Location Open Dt |
stor |
date |
stor_a.csv.ovr |
Retail/Cost |
optional |
RI |
|
addvlocendd |
Location Close Dt |
stor |
date |
stor_a.csv.ovr |
Retail/Cost |
optional |
RI |
|
addvlocrefd |
Location Refurbrish Dt |
stor |
date |
stor_a.csv.ovr |
Retail/Cost |
optional |
RI |
|
addvwfpoct |
W/F Location Type |
stor |
text |
stor_a.csv.ovr |
Retail/Cost |
optional |
RI |
|
addvpocdesct |
Location Description |
stor |
text |
stor_a.csv.ovr |
Retail/Cost |
optional |
Admin |
|
addvchnlmapt |
Channel Type |
chnc |
text |
addvchnlmapt.csv.ovr |
Retail/Cost |
optional |
Admin |
|
addvlcratet |
Local Currency Symbol |
curc |
text |
addvlcratet.csv.ovr |
Retail/Cost |
optional |
Admin |
|
addvpocsqmv |
Location Square Meter |
dept_stor |
real |
addvpocsqmv.csv.ovr |
Retail/Cost |
optional |
Admin |
|
drtylcratex |
Ty Local Currency Rate |
day_curc |
real |
curr.csv.ovr |
Retail/Cost |
optional |
RI |
|
addvlocattt |
Location Attribute |
stor_satt |
text |
addvlocattt.csv.ovr |
Retail/Cost |
optional |
Admin |
All measure files that need to be loaded as data files need to be grouped based on the File Name; the files should contain the header for the measures to be loaded and should be in .csv format. Measures within a file can be grouped in any order as long as the header column is correctly marked. If a measure is optional in a file, the customer can ignore that measure and group the remaining measures which are available for the customer.
Example:
In the following example, if the customer is not using RAP integration, so only grouping the data which is required and not optional in a file for the data that the customer has.
File Name: tranx.csv.ovr
Base Intersection: week/sku/stor
Data Type: real
week,sku,stor,drtytraninr,drtytraninu,drtytranoutr,drtytranoutu w01_2021,100000,1000,30.96,31.52,0,0 w02_2021,100000,1000,169.13,112.61,1,37.85 w03_2021,100000,1000,233.54,50.26,1,35.09