C Appendix: Standard Exports
Assortment Planning Cloud Service provides multiple standard exports that retailers can use to integrate with other systems that need AP 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 Planning 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 Planning Cloud Service Administration Guide.
Assortment Planning Cloud Service Exports
This section lists the different Assortment 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.
In APCS, Assortment Plans are approved at the Style-Color/Week/Store level, but before export, those approved plans are spread down to the Item/Week/Store level for Item Plan level exports.
Item Plan - Pre-Season
Export Set Name: Item Plan - Pre-Season
Export Set: ip_ipop
Exported File: ipop_strc_plan.txt
Export Criteria: All approved Pre-Season Item Plans for all un-elapsed time periods.
Table C-1 Item Plan - Pre-Season Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
week |
Week |
|
|
|
sku |
Item |
|
|
|
stor |
Store |
|
|
|
IEOPSls1U |
Op Sales Reg + Promo U |
real |
Total |
|
IEOPSls1R |
Op Sales Reg + Promo R |
real |
Total |
|
IEOPSls1C |
Op Sales Reg + Promo C |
real |
Total |
|
IEOPEOPU |
Op EOP U |
real |
Total |
|
IEOPEOPR |
Op EOP R |
real |
Total |
|
IEOPEOPC |
Op EOP C |
real |
Total |
|
IEOPRcptU |
Op Receipts U |
real |
Total |
|
IEOPRcptR |
Op Receipts R |
real |
Total |
|
IEOPRcptC |
Op Receipts C |
real |
Total |
Item Plan - In-Season
Export Set Name: Item Plan - In-Season
Export Set: ip_ipcp
Exported File: ipcp_strc_plan.txt
Export Criteria: All approved In-Season Item Plans for all un-elapsed time periods.
Table C-2 Item Plan - In-Season Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
week |
Week |
|
|
|
skup |
Item |
|
|
|
stor |
Store |
|
|
|
IECPSls1U |
Cp Sales Reg + Promo U |
real |
Total |
|
IECPSls1R |
Cp Sales Reg + Promo R |
real |
Total |
|
IECPSls1C |
Cp Sales Reg + Promo C |
real |
Total |
|
IECPEOPU |
Cp EOP U |
real |
Total |
|
IECPEOPR |
Cp EOP R |
real |
Total |
|
IECPEOPC |
Cp EOP C |
real |
Total |
|
IECPRcptU |
Cp Receipts U |
real |
Total |
|
IECPRcptR |
Cp Receipts R |
real |
Total |
|
IECPRcptC |
Cp Receipts C |
real |
Total |
Item Plan - OTB
Export Set Name: Item Plan - OTB
Export Set: ip_otb
Exported File: ipwp_otb.txt
Export Criteria: Planned OTB for all un-elapsed time periods.
Table C-3 Item Plan - OTB Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
week |
Week |
|
|
|
skup |
Style/Color |
|
|
|
stor |
Store |
|
|
|
ISWPOTBU |
WP OTB U |
real |
Total |
|
ISWPOTBR |
WP OTB R |
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 C-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 C-5 New Product Attributes Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
sku |
Item |
|
|
|
patt |
Product Attribute |
String |
|
|
ADDVPrdAttT |
Product Attribute Value |
String |
|
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 Item/Store.
Table C-6 Base Unit Price Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
sku |
Item |
|
|
|
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 Criteria: Approved Receipt Quantities for Allocation
Table C-7 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 plitpt.0l (for Style/Color) files by the batch process by calling the custom function ap_exp_alloc.