14 RO Integration

The RO integration scheme is divided into two by location type, stores and warehouses.

Breaking the integration scheme serves two purposes:

It allows the optimization system to be implemented for stores and not warehouses while running a full implementation of AIP.
It allows AIP to be set up to run a Stores-first implementation that would not execute warehouse replenishment and therefore would not require optimization.

Store Measure Data

The data mapping in this section is for stores only.

File and Measure Summary

Table 14-1 displays the measure files AIP receives from RO.

Table 14-1 Measure Files AIP Receives from RO

File Name	Measures Loaded
STR_MINMAX.[txt\|csv]	sr0_minstk_i, sr0_maxstk_i, and sr0_rplmtd_i
STR_DYNAMIC.[txt\|csv]	sr0_svclvl_i, sr0_isd_i, and sr0_rplmtd_i
STR_TIMESUPPLY.[txt\|csv]	sr0_mints_day_i, sr0_maxts_day_i, sr0_ts_hzn_i, and sr0_rplmtd_i
STR_HYBRID.[txt\|csv]	sr0_mints_day_i, sr0_isd_i, and sr0_rplmtd_i
STR_POISSON.[txt\|csv]	sr0_svclvl_i, sr0_isd_i, and sr0_rplmtd_i
STR_MINSS.[txt\|csv]	sr0_minss_unt_i
STR_ROUpdate.[txt\|csv]	iproupdtstri

STR_MINMAX

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Store Min Stock	Measure at the SKU/Store/Day level; Used in MIN/MAX Replenishment Method. Min Stock is used in determining the inventory level at which replenishment is triggered.
Measure	Store Max Stock	Measure at the SKU/Store/Day level; set in MIN/MAX Replenishment Method. The receipt plan quantity is calculated to bring Net Inventory up to the max.
Measure	Store Repl Method	Measure at the SKU/Store/Day level; The Replenishment Method determines the type of calculations that will be used in generating a store replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	ro_export_to_aip.sh	exportMinMax.xml, createFile.xml, and transferFilePositions.xml	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	sr0_minstk_i, sr0_maxstk_i, and sr0_rplmtd_i
Source Object Name	STR_MINMAX.[txt\|csv]	Target Object Database	data/sr0_minstk_i, data/sr0_maxstk_i, and data/sr0_rplmtd_i
Required/Optional	Optional	Target Object Load Intersection	day_str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
STR_	Store	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
STR_	Store	String	"1001 "
SKU_	SKU	String	"123456 "
sr0_minstk_i	Store Min Stock	Real	"123.456 "
sr0_maxstk_i	Store Max Stock	Real	"123.456 "
sr0_rplmtd_i	Store Replenishment Method	Integer	"1 "

Examples

Example of STR_MINMAX.txt file:

"20081231 1001                123456              123.456   123.456   1         "

Example of STR_MINMAX.csv file:

”20081231,1001,123456,123.456,123.456,1”

STR_DYNAMIC

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Store Service Level	Measure at the SKU/Store/Day level; Used in Dynamic and Poisson Replenishment Methods. Specifies the target percentage level for customer service of a given item at a store. For example, if the goal is to carry enough safety stock to maintain a 90% customer service level, 0.90 should be entered.
Measure	Store Inventory Selling Days	Measure at the SKU/Store/Day level; Used to specify number of Days of forecasted quantity to be used when calculating the Receive Up To Level (RUTL). Used in Hybrid, Dynamic, Poisson, and Loaded SS Dynamic Replenishment Methods. For example, to ensure an order will contain at least 14 days of supply, 14 would be entered. Note: The greater of Inventory Selling Days, and Review Time will be used in the RUTL calculation.
Measure	Store Repl Method	Measure at the SKU/Store/Day level; The Replenishment Method determines the type of calculations that will be used in generating a store replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	ro_export_to_aip.sh	exportDynamic.xml, createFile.xml, and transferFilePositions.xml	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	sr0_svclvl_i, sr0_isd_i, and sr0_rplmtd_i
Source Object Name	STR_DYNAMIC.[txt\|csv]	Target Object Database	data/sr0_svclvl_i, data/sr0_isd_i, and data/sr0_rplmtd_i
Required/Optional	Optional	Target Object Load Intersection	day_str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
STR_	Store	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
STR_	Store	String	"1001 "
SKU_	SKU	String	"123456 "
sr0_svclvl_i	Store Service Level	Real	"123.456 "
sr0_isd_i	Store Inventory Selling Days	Real	"123.456 "
sr0_rplmtd_i	Store Replenishment Method	Integer	"3 "

Examples

Example of STR_DYNAMIC.txt file:

"20081231 1001               123456              123.456   123.456             3"

Example of STR_DYNAMIC.csv file:

"20081231 1001,123456,123.456,123.456,3"

STR_TIMESUPPLY

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Store Min Time Supply Days	Measure at the SKU/Store/Day level; Used in Time Supply Replenishment Method. It represents minimum stock level in Days that are desired on hand to satisfy demand. Min Time Supply Days is used in both safety stock and receipt point calculations. For example, to ensure a minimum inventory level is at least 14 Days of supply, 14 would be entered.
Measure	Store Max Time Supply Days	Measure at the SKU/Store/Day level; Used in the Time Supply Replenishment Method. It represents maximum stock level in Days that are desired on hand to satisfy demand. The receipt plan quantity is calculated to bring Net Inventory up to Maximum Time Supply Days. For example, to limit an order to bring the inventory level to no more than to 14 Days of supply, 14 would be entered.
Measure	Store Time Supply Horizon	Measure at the SKU/Store/Day level; The number of Days of forecast used to calculate an average forecast (rate of sale). The Rate of Sale (ROS) is then multiplied by the minimum time supply days to generate the safety stock. The Time Supply Horizon can be used to smooth spiky forecasts over a longer time period or extend forecasts if the forecasts are not generated throughout the desired days of supply. Used in Time Supply Replenishment Method. Note: When time supply horizon is specified, ROS is used instead of the actual forecast.
Measure	Store Repl Method	Measure at the SKU/Store/Day level; The Replenishment Method determines the type of calculations that will be used in generating a store replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	ro_export_to_aip.sh	exportTimeSupply.xml, createFile.xml, and transferFilePositions.xml	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	sr0_mints_day_i, sr0_maxts_day_i, sr0_ts_hzn_i, and sr0_rplmtd_i
Source Object Name	STR_TIMESUPPLY.[txt\|csv]	Target Object Database	data/sr0_mints_day_i, data/sr0_maxts_day_i, data/sr0_ts_hzn_i, and data/sr0_rplmtd_i
Required/Optional	Optional	Target Object Load Intersection	day_str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
STR_	Store	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aipreplAxP1_	Auxiliary Replenishment Parameter 1	70	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
STR_	Store	String	"1001 "
SKU_	SKU	String	"123456 "
sr0_mints_day_i	Store Min Time Supply Days	Real	"123.456 "
sr0_maxts_day_i	Store Max Time Supply Days	Real	"123.456 "
sr0_ts_hzn_i	Store Time Supply Horizon	Real	"123.456 "
sr0_rplmtd_i	Store Replenishment Method	Integer	"2 "

Examples

Example of STR_TIMESUPPLY.txt file:

”20081231 1001 123456 123.456 123.456 123.456 2”

Example of STR_TIMESUPPLY.csv file:

"20081231,1001,123456,123.456,123.456,123.456,2"

STR_HYBRID

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Store Min Time Supply Days	Measure at the SKU/Store/Day level; Used in Time Supply Replenishment Method. It represents minimum stock level in Days that are desired on hand to satisfy demand. Min Time Supply Days is used in both safety stock and receipt point calculations. For example, to ensure a minimum inventory level is at least 14 Days of supply, 14 would be entered.
Measure	Store Inventory Selling Days	Measure at the SKU/Store/Day level; Used to specify number of Days of forecasted quantity to be used when calculating the Receive Up To Level (RUTL). Used in Hybrid, Dynamic, Poisson and Loaded SS Dynamic Replenishment Methods. For example, to ensure an order will contain at least 14 days of supply, 14 would be entered. Note: The greater of Inventory Selling Days and Review Time will be used in the RUTL calculation.
Measure	Store Repl Method	Measure at the SKU/Store/Day level; The Replenishment Method determines the type of calculations that will be used in generating a store replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	ro_export_to_aip.sh	exportHybrid.xml, createFile.xml, and transferFilePositions.xml	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	sr0_mints_day_i, sr0_isd_i, and sr0_rplmtd_i
Source Object Name	STR_HYBRID.[txt\|csv]	Target Object Database	sr0_mints_day_i, sr0_isd_i, and sr0_rplmtd_i
Required/Optional	Optional	Target Object Load Intersection	day_str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
STR_	Store	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
STR_	Store	String	"1001 "
SKU_	SKU	String	"123456 "
sr0_mints_day_i	Store Min Time Supply Days	Real	"123.456 "
sr0_isd_i	Store Inventory Selling Days	Real	"123.456 "
sr0_rplmtd_i	Store Replenishment Method	Integer	"5 "

Examples

Example of STR_HYBRID.txt file:

"20081231 1001                123456              123.456   123.456   5         "

Example of STR_HYBRID.csv file:

"20081231,1001,123456,123.456,123.456,5"

STR_POISSON

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Store Service Level	Measure at the SKU/Store/Day level; Used in Dynamic and Poisson Replenishment Methods. Specifies the target percentage level for customer service of a given item at a store. For example, if the goal is to carry enough safety stock to maintain a 90% customer service level, 0.90 should be entered.
Measure	Store Inventory Selling Days	Measure at the SKU/Store/Day level; Used to specify number of Days of forecasted quantity to be used when calculating the Receive Up To Level (RUTL). Used in Hybrid, Dynamic, Poisson, and Loaded SS Dynamic Replenishment Methods. For example, to ensure an order will contain at least 14 days of supply, 14 would be entered. Note: The greater of Inventory Selling Days and Review Time will be used in the RUTL calculation.
Measure	Store Repl Method	Measure at the SKU/Store/Day level; The Replenishment Method determines the type of calculations that will be used in generating a store replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	ro_export_to_aip.sh	exportPoisson.xml, createFile.xml, and transferFilePositions.xml	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	sr0_svclvl_i, sr0_isd_i, and sr0_rplmtd_i
Source Object Name	STR_POISSON.[txt\|csv]	Target Object Database	data/sr0_svclvl_i, data/sr0_isd_i, and data/sr0_rplmtd_i
Required/Optional	Optional	Target Object Load Intersection	day_str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
STR_	Store	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
STR_	Store	String	"1001 "
SKU_	SKU	String	"123456 "
sr0_svclvl_i	Store Service Level	Real	"123.456 "
sr0_isd_i	Store Inventory Selling Days	Real	"123.456 "
sr0_rplmtd_i	Store Replenishment Method	Integer	"7 "

Examples

Example of STR_POISSON.txt file:

"20081231 1001                123456              123.456   123.456   7         "

Example of STR_POISSON.csv file:

"20081231,1001,123456,123.456,123.456,7"

STR_MINSS

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Measure	Measure at the SKU/Store/Day level; Used in Minimum Safety Stock Boundaries calculation to specify the minimum number of Units to be kept on hand as safety stock. Used in Hybrid, Poisson, and Dynamic Replenishment Methods. For example, to ensure the number of units of safety stock is at least 10 Units, 10 would be entered.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	ro_export_to_aip.sh	exportMinSafetyStock.xml, createFile.xml, and transferFilePositions.xml	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	sr0_minss_unt_i
Source Object Name	STR_MINSS.[txt\|csv]	Target Object Database	data/minss_unt
Required/Optional	Optional	Target Object Load Intersection	day_str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
STR_	Store	10	20
ITEM	SKU	30	20
aipreplaxp2_	Auxiliary Replenishment Parameter 2	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
STR_	Store	String	"1001 "
SKU_	SKU	String	"123456 "
sr0_minss_unt_i	Store Min Safety Stock Units	Real	"123.456 "

Examples

Example of STR_MINSS.txt file:

"20081231 1001                123456              123.456   "

Example of STR_MINSS.csv file:

"20081231,1001,123456,123.456"

STR_ROUpdate

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Replenishment Optimization Update for Stores	Mask measure provided by the Replenishment Optimization (RO) system. This measure is used to limit what data will be extracted out of AIP for the purposes of updating values in RO. The mask also indicates which SKU/stores will be optimized in the next run of RO.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	ro_export_to_aip.sh	exportRoUpdate.xml, createFile.xml, and transferFilePositions.xml	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	iproupdtstri
Source Object Name	STR_ROUpdate.[txt\|csv]	Target Object Database	data/ro
Required/Optional	Optional	Target Object Load Intersection	str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
STR_	Store	1	20
ITEM	SKU	21	20
aipintxupd_	AIP Intersection Update	41	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
STR_	Store	String	"1001 "
SKU_	SKU	String	"123456 "
iproupdtstri	Replenishment Optimization Update for Stores	Boolean	"1 "

Examples

Example of STR_ROUpdate.txt file:

"1001                123456              1         "

Example of STR_ROUpdate.csv file:

"1001,123456,1"

Warehouse Data Interfaces

The mapping data in this section is for warehouses only. AIP supports the import of warehouse replenishment data; however, optimization of warehouse replenishment cannot be supported by the receiving application. Check the Oracle Retail Replenishment Optimization guides and the retailer's specific implementation to determine if warehouses can be optimized.

File and Measure Summary

Table 14-2 lists the measure files AIP receives from an optimization system that is capable of optimizing warehouses.

Table 14-2 Measure Files AIP Receives from an Optimization System

File Name	Measures Loaded
WH_MINMAX.[txt\|csv]	ipminstke, ipmaxstke, and iprplmtde
WH_DYNAMIC.[txt\|csv]	ipsvclvle, ipisde, and iprplmtde
WH_TIMESUPPLY.[txt\|csv]	ipmindaytse, ipmaxdaytse, iptshzne, and iprplmtde
WH_HYBRID.[txt\|csv]	ipmindaytse, ipisde, and iprplmtde
WH_MINSS.[txt\|csv]	ipssminunte
WH_ROUpdate.[txt\|csv]	iproupdtwhi

WH_MINMAX

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Minimum Stock Exception	Measure at the SKU/Dstk/Day level; Used in MIN/MAX Replenishment Method. Min Stock is used in determining the inventory level at which replenishment is triggered.
Measure	Maximum Stock Exception	Measure at the SKU/Dstk/Day level; set in MIN/MAX Replenishment Method. The receipt plan quantity is calculated to bring Net Inventory up to the max.
Measure	Replenishment Method Exception	Measure at the SKU/Dstk/Day level; The Replenishment Method determines the type of calculations that will be used in generating a warehouse replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	Unknown	Unknown	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	ipminstke, ipmaxstke, and iprplmtde
Source Object Name	WH_MINMAX.[txt\|csv]	Target Object Database	data/MinStk, data/MaxStk, and data/RplMtd
Required/Optional	Optional	Target Object Load Intersection	day_dstksku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
Unknown	Warehouse	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
WH__	Warehouse	String	"1001 "
SKU_	SKU	String	"123456 "
ipminstke	Minimum Stock Exception	Real	"123.456 "
ipmaxstke	Maximum Stock Exception	Real	"123.456 "
iprplmtde	Replenishment Method Exception	Integer	"1 "

Examples

Example of WH_MINMAX.txt file:

"20081231 1001                123456              123.456   123.456   1         "

Example of WH_MINMAX.csv file:

"20081231,1001,123456,123.456,123.456,1"

WH_DYNAMIC

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Service Level Exception	Measure at the SKU/Dstk/Day level; Used in Dynamic, and Poisson Replenishment Methods. Specifies the target percentage level for customer service of a given item at a warehouse. For example, if the goal is to carry enough safety stock to maintain a 90% customer service level, 0.90 should be entered.
Measure	Inventory Selling Days Exception	Measure at the SKU/Dstk/Day level; Used to specify number of Days of forecasted quantity to be used when calculating the Receive Up To Level (RUTL). Used in Hybrid, Dynamic, Poisson, and Loaded SS Dynamic Replenishment Methods. For example, to ensure an order will contain at least 14 days of supply, 14 would be entered. Note: The greater of Inventory Selling Days, and Review Time will be used in the RUTL calculation.
Measure	Replenishment Method Exception	Measure at the SKU/Dstk/Day level; The Replenishment Method determines the type of calculations that will be used in generating a warehouse replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	Unknown	Unknown	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	ipsvclvle, ipisde, and iprplmtde
Source Object Name	WH_DYNAMIC	Target Object Database	data/SvcLvl, data/Isd, and data/RplMtd
Required/Optional	Optional	Target Object Load Intersection	day_dstksku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
Unknown	Warehouse	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
WH__	Warehouse	String	"1001 "
SKU_	SKU	String	"123456 "
ipsvclvle	Service Level Exception	Real	"123.456 "
ipisde	Inventory Selling Days Exception	Real	"123.456 "
iprplmtde	Replenishment Method Exception	Integer	"3 "

Examples

Example of WH_DYNAMIC.txt file:

"20081231 1001                123456              123.456   123.456   1         "

Example of WH_DYNAMIC.csv file:

"20081231,1001,123456,123.456,123.456,1"

WH_TIMESUPPLY

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Minimum Time Supply Days Exception	Measure at the SKU/Dstk/Day level; Used in Time Supply Replenishment Method. It represents minimum stock level in Days that are desired on hand to satisfy demand. Min Time Supply Days is used in both safety stock and receipt point calculations. For example, to ensure a minimum inventory level is at least 14 Days of supply, 14 would be entered.
Measure	Maximum Time Supply Days Exception	Measure at the SKU/Dstk/Day level; Used in the Time Supply Replenishment Method. It represents maximum stock level in Days that are desired on hand to satisfy demand. The receipt plan quantity is calculated to bring Net Inventory up to Maximum Time Supply Days. For example, to limit an order to bring the inventory level to no more than to 14 Days of supply, 14 would be entered.
Measure	Time Supply Horizon Exception	Measure at the SKU/Dstk/Day level; The number of Days of forecast used to calculate an average forecast (rate of sale). The Rate of Sale (ROS) is then multiplied by the minimum time supply days to generate the safety stock. The Time Supply Horizon can be used to smooth spiky forecasts over a longer time period or extend forecasts if the forecasts are not generated throughout the desired days of supply. Used in Time Supply Replenishment Method. Note: When time supply horizon is specified, ROS is used instead of the actual forecast.
Measure	Replenishment Method Exception	Measure at the SKU/Dstk/Day level; The Replenishment Method determines the type of calculations that will be used in generating a warehouse replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	Unknown	Unknown	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	ipmindaytse, ipmaxdaytse, iptshzne, and iprplmtde
Source Object Name	WH_TIMESUPPLY	Target Object Database	data/MinDayTs, data/MaxDayTs, data/TsHzn, and data/RplMtd
Required/Optional	Optional	Target Object Load Intersection	day_dstksku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
Unknown	Warehouse	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aipreplAxP1_	Auxiliary Replenishment Parameter 1	70	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
WH__	Warehouse	String	"1001 "
SKU_	SKU	String	"123456 "
ipmindaytse	Minimum Time Supply Days Exception	Real	"123.456 "
ipmaxdaytse	Maximum Time Supply Days Exception	Real	"123.456 "
iptshzne	Time Supply Horizon Exception	Real	"123.456 "
iprplmtde	Replenishment Method Exception	Integer	"2 "

Examples

Example of WH_TIMESUPPLY.txt file:

"20081231 1001                123456              123.456   123.456   123.456   1"

Example of WH_TIMESUPPLY.csv file:

"20081231,1001,123456,123.456,123.456,123.456,1"

WH_HYBRID

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Minimum Time Supply Days Exception	Measure at the SKU/Dstk/Day level; Used in Time Supply Replenishment Method. It represents minimum stock level in Days that are desired on hand to satisfy demand. Min Time Supply Days is used in both safety stock and receipt point calculations. For example, to ensure a minimum inventory level is at least 14 Days of supply, 14 would be entered.
Measure	Inventory Selling Days Exception	Measure at the SKU/Dstk/Day level; Used to specify number of Days of forecasted quantity to be used when calculating the Receive Up To Level (RUTL). Used in Hybrid, Dynamic, Poisson, and Loaded SS Dynamic Replenishment Methods. For example, to ensure an order will contain at least 14 days of supply, 14 would be entered. Note: The greater of Inventory Selling Days and Review Time will be used in the RUTL calculation.
Measure	Replenishment Method Exception	Measure at the SKU/Dstk/Day level; The Replenishment Method determines the type of calculations that will be used in generating a warehouse replenishment plan. The default is No Replenishment.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	Unknown	Unknown	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measures
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	ipmindaytse, ipisde, and iprplmtde
Source Object Name	WH_HYBRID	Target Object Database	data/MinDayTs, data/Isd, and data/RplMtd
Required/Optional	Optional	Target Object Load Intersection	day_dstksku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
Unknown	Warehouse	10	20
ITEM	SKU	30	20
aipreplpval1_	Replenishment Parameter 1	50	10
aipreplpval2_	Replenishment Parameter 2	60	10
aiprplmtd_	Replenishment Method	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
WH__	Warehouse	String	"1001 "
SKU_	SKU	String	"123456 "
ipmindaytse	Minimum Time Supply Days Exception	Real	"123.456 "
ipisde	Inventory Selling Days Exception	Real	"123.456 "
iprplmtde	Replenishment Method Exception	Integer	"5 "

Examples

Example of WH_HYBRID.txt file:

"20081231 1001                123456              123.456   123.456   5         "

Example of WH_HYBRID.csv File

"20081231,1001,123456,123.456,123.456,1"

WH_MINSS

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Minimum Safety Stock Units Exception	Measure at the SKU/Dstk/Day level; Used in Minimum Safety Stock Boundaries calculation to specify the minimum number of Units to be kept on hand as safety stock. Used in Hybrid, Poisson, and Dynamic Replenishment Methods. For example, to ensure the number of Units of safety stock is at least 10 Units, 10 would be entered. Note: If both Min SS Days and Min SS Units are entered, the larger of min SS units and demand over min SS days is used.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	Unknown	Unknown	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	ipssminunte
Source Object Name	WH_MINSS	Target Object Database	data/SsMinUnt
Required/Optional	Optional	Target Object Load Intersection	day_dstksku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
aipefctvdate_	Effective date	1	9
Unknown	Warehouse	10	20
ITEM	SKU	30	20
aipreplaxp2_	Auxiliary Replenishment Parameter 2	80	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY_	Day	String	"20081231 "
WH__	Warehouse	String	"1001 "
SKU_	SKU	String	"123456 "
ipssminunte	Minimum Safety Stock Units Exception	Real	"123.456 "

Examples

Example of WH_MINSS.txt file:

"20081231 1001                123456              123.456   "

Example of WH_MINSS.csv file:

"20081231,1001,123456,123.456"

WH_ROUpdate

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Replenishment Optimization Update for Stores	Mask measure provided by the Replenishment Optimization (RO) system. This measure is used to limit what data will be extracted out of AIP for the purposes of updating values in RO. The mask also indicates which SKU/stores will be optimized in the next run of RO.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	Unknown	Unknown	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	RO	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File or Comma Separated Values File	Target Object Name	iproupdtwhi
Source Object Name	STR_ROUpdate	Target Object Database	data/ro
Required/Optional	Optional	Target Object Load Intersection	dstksku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
Unknown	Warehouse	1	20
ITEM	SKU	21	20
aipintxupd_	AIP Intersection Update	41	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
WH__	Warehouse	String	"1001 "
SKU_	SKU	String	"123456 "
iproupdtwhi	Replenishment Optimization Update for Stores	Boolean	"1 "

Examples

Example of WH_ROUpdate.txt file:

"1001                123456              1         "

Example of WH_ROUpdate.csv file:

"1001,123456,1"