B Appendix: Standard Exports

Assortment & Item Planning Cloud Service provides multiple standard exports that retailers can use to integrate with other systems that need A&IP Plan data. It also exports new Placeholder items and new Product Attributes that can be used to interface them to their source systems.

For more information related to extracted measures, the approval process, and the administration process related to exports, see the Oracle Retail Assortment & Item Planning for Fashion/Softlines Cloud Service User Guide. For more details about executing the export using Online Administration Tools using the Admin task Export Data, see the Oracle Retail Assortment & Item Planning for Fashion/Softlines Cloud Service Administration Guide.

Assortment & Item Planning Cloud Service Exports

This section lists the different Assortment & Item Planning Cloud Service standard exports and the list of measures exported. All exported files will be in CSV format. A few exports are available for export only if the particular solution is enabled.

Item Plan - Pre-Season - Cluster Level

Export Set Name: Item Plan - Pre-Season - Cluster Level

Export Set: ip_ipop

Exported File: ipop_strc_plan.txt

Export from Solution: IPCS (Item Planning)

Export Criteria: All approved Cluster Level Pre-Season Item Plans for all un-elapsed time periods.

Table B-1 Item Plan - Pre-Season - Cluster Level Export Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
skup	Style/Color
stor	Store
ISOPSlsRegU	Op Sales Reg U	real	Total
ISOPSlsRegR	Op Sales Reg R	real	Total
ISOPSlsProU	Op Sales Promo U	real	Total
ISOPSlsProR	Op Sales Promo R	real	Total
ISOPSlsClrU	Op Sales Clr U	real	Total
ISOPSlsClrR	Op Sales Clr R	real	Total
ISOPSlsC	Op Sales C	real	Total
ISOPEOPU	Op EOP U	real	Total
ISOPEOPC	Op EOP C	real	Total
ISOPRcptU	Op Receipts U	real	Total
ISOPRcptC	Op Receipts C	real	Total
ISOPRtnU	Op Customer Returns U	real	Total
ISOPRtnR	Op Customer Returns R	real	Total
ISOPRtnC	Op Customer Returns C	real	Total

Item Plan - In-Season - Cluster Level

Export Set Name: Item Plan - In-Season - Cluster Level

Export Set: ip_ipcp

Exported File: ipcp_st_plan.txt

Export from Solution: IPCS (Item Planning)

Export Criteria: All approved Cluster Level In-Season Item Plans for all un-elapsed time periods.

Table B-2 Item Plan - In-Season - Cluster Level Export Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
skup	Style/Color
stor	Store
ISCPSlsRegU	Cp Sales Reg U	real	Total
ISCPSlsRegR	Cp Sales Reg R	real	Total
ISCPSlsProU	Cp Sales Promo U	real	Total
ISCPSlsProR	Cp Sales Promo R	real	Total
ISCPSlsClrU	Cp Sales Clr U	real	Total
ISCPSlsClrR	Cp Sales Clr R	real	Total
ISCPSlsC	Cp Sales C	real	Total
ISCPEOPU	Cp EOP U	real	Total
ISCPEOPC	Cp EOP C	real	Total
ISCPRcptU	Cp Receipts U	real	Total
ISCPRcptC	Cp Receipts C	real	Total
ISCPRtnU	Cp Customer Returns U	real	Total
ISCPRtnR	Cp Customer Returns R	real	Total
ISCPRtnC	Cp Customer Returns C	real	Total
ISWPOTBU	Wp OTB U	real	Total
ISWPOTBC	Wp OTB C	real	Total

Item Plan - Store Level

Export Set Name: Item Plan - Store Level

Export Set: ip_iecp

Exported File: ipcp_stor_plan.txt

Export from Solution: IPCS (Item Planning)

Export Criteria: All approved Store Level Item Plans for all un-elapsed time periods.

Table B-3 Item Plan - Store Level Export Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
skup	Style/Color
stor	Store
IECPSlsRegU	Cp Sales Reg U	real	Total
IECPSlsRegR	Cp Sales Reg R	real	Total
IECPSlsProU	Cp Sales Promo U	real	Total
IECPSlsProR	Cp Sales Promo R	real	Total
IECPSlsClrU	Cp Sales Clr U	real	Total
IECPSlsClrR	Cp Sales Clr R	real	Total
IECPSlsC	Cp Sales C	real	Total
IECPEOPU	Cp EOP U	real	Total
IECPEOPC	Cp EOP C	real	Total
IECPRcptU	Cp Receipts U	real	Total
IECPRcptC	Cp Receipts C	real	Total
IECPRtnU	Cp Customer Returns U	real	Total
IECPRtnR	Cp Customer Returns R	real	Total
IECPRtnC	Cp Customer Returns C	real	Total
ISWPOTBU	Wp OTB U	real	Total
ISWPOTBC	Wp OTB C	real	Total

New Place-holder Items

Export Set Name: New Place-holder Items

Export Set: ph_item

Exported File: as_new_item.txt

Export Criteria: All newly created placeholder items which are not formalized. It also exports additional product rollup information for that item.

Table B-4 New Place-holder Items Export Measures

Measure	Measure Label	Data Type	Aggregation Type
sku	Item
DRDVPSKUL	Place-holder Item Label	String
DRDVPSKUPT	Style-Color Identifier	String
DRDVPSKUPL	Style-Color Label	String
DRDVPSKUGT	Style-Color Label	String
DRDVPSKUGL	Style Identifier	String
DRDVPSCLST	Style Label	String
DRDVPSCLSL	Subclass Identifier	String
DRDVPCLSST	Subclass Label	String
DRDVPCLSSL	Class Identifier	String
DRDVPDEPTT	Class Label	String
DRDVPDEPTL	Department Identifier	String
DRDVPDEPTL	Department Label	String

New Product Attributes

Export Set Name: New Product Attributes

Export Set: ph_patt

Exported File: as_new_patt.txt

Export Criteria: All Item - Product Attribute association for newly created product attributes in Assortment Planning.

Table B-5 New Product Attributes Export Measures

Measure	Measure Label	Data Type	Aggregation Type
sku	Item
patt	Product Attribute	String
ADDVPrdAttT	Product Attribute Value	String

Build Wedge Plan

Export Set Name: Build Wedge Plan

Export Set: af_bwcp

Exported File: ap_bwcp_plan.txt

Export from Solution: APFA (Assortment Planning for Fashion/Softlines)

Export Criteria: Approved Build Wedge Plans.

Table B-6 Build Wedge Plan Export Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
skup	Style/Color
stor	Store
BWCBWkSlsU	Cp Sales U	real	Total
BWCBWkSlsR	Cp Sales R	real	Total
BWCBRcptU	Cp Receipts U	real	Total

Base Unit Price

Export Set Name: Base Unit Price

Export Set: as_sprc

Exported File: as_base_price.txt

Export Criteria: Base Unit Retail and Cost set for all StyleColor/Store.

Table B-7 Base Unit Price Export Measures

Measure	Measure Label	Data Type	Aggregation Type
skup	Style/Color
stor	Store
ADDVSlsPrcR	Retail Price	real	Average
ADDVSlsPrcC	Cost	real	Average

Export to Allocation

Export Set Name: Export to Allocation

Export Set: af_alloc

Exported File: ap_to_alloc.txt

Export from Solution: APFA (Assortment Planning for Fashion/Softlines)

Export Criteria: Approved Receipt Quantities for Allocation.

Table B-8 Export to Allocation Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
skup	Style/Color
stor	Store
APDVWeek2DayTx	EOW Date	real	Total
APDVStyleLblTx	Style Label	real	Total
APDVColorTx	Color Code	real	Total
APCPRcptU	Cp Receipts U	real	Total

Note: For Allocation, the standard exported file is further formatted as p0itpt.0l (Style only items) or plitpt.0l (for Style/Color) files by the batch process by calling the custom function ap_exp_alloc.