| Oracle® Retail Advanced Inventory Planning Implementation Guide Release 14.1 E64951-02 |
|
 Previous |
 Next |
| Oracle® Retail Advanced Inventory Planning Implementation Guide Release 14.1 E64951-02 |
|
Previous |
Next |
This chapter describes the hierarchy and measure data accepted into AIP.
External System data is data that AIP is able to load but that is not provided to AIP by any available extract. There are three types of external data that are accepted as inputs into AIP:
The following table lists the hierarchy files that AIP receives from External System. Details for these files are in the section, Hierarchy Data File Details.
Table 12-1 lists the measure files that AIP receives from External System.Details for these files are in the section, Measure Data Details.
|
Note: Files with (*) are coming from External System to AIP-Oracle and are not loaded into AIP-RPAS; files with (**) are coming from External System to AIP-Oracle and are also loaded into AIP-RPAS. |
Table 12-1 Measure Files that AIP Receives from External System
| File Name | Description | Source |
|---|---|---|
|
|
Default Warehouse |
External** |
|
direct_store_format_pack_size.txt |
Direct Store Format Pack Size |
External* |
|
|
Direct Store Pack Size |
External* |
|
|
Receiving Supplier / Ship-to |
External |
|
|
Ad/Rollout Notes |
External |
|
|
Store Ad End Date |
External |
|
|
Store Ad Start Date |
External |
|
|
Total Store Average Rate-of-Sales |
External |
|
|
Week-to-Day Forecast Percentage Default |
External |
|
|
Store Week-to-Day Forecast Percentage Override |
External |
|
|
Hold Back Quantity |
External |
|
|
Warehouse Independent ARS |
External |
|
|
Inbound Capacity Cases for Reporting |
External |
|
|
Loaded Safety Stock |
External |
|
|
Outbound Capacity Cases for Reporting |
External |
|
|
SPQ Order Commit Quantity |
External |
|
|
Replenishment Subtype Code |
External |
|
|
Replenishment Type Code |
External |
|
|
Historical Weekly Sales |
External |
|
|
Total Held Stock |
External |
|
|
Stocking Point Holding Capacity |
External |
|
|
Item Attribute |
External* |
|
|
Item Attribute Type |
External* |
|
|
Available Purchase Order Number |
External* |
|
|
Sister Store |
External** |
|
|
Sister Warehouse |
External** |
|
|
Store Ads |
External |
|
|
Store Ads Grand Opening |
External |
|
|
Store Ads Inserts |
External |
|
|
Store Ads Others |
External |
|
|
Store Ads Run On Press |
External |
|
|
Store Adjusted Sales |
External |
|
|
Store Average Weekly Rate-of-Sale Loaded |
External |
|
|
Store Customer Orders |
External |
|
|
Daily Short Code Sales |
External |
|
|
Store Expected Write-off |
External |
|
|
Store Historical Lost Sales |
External |
|
|
Inventory Adjustments |
External |
|
|
Store Known Demand |
External |
|
|
Run Overstock Alert Flag |
External |
|
|
Store Replenishment Type Code |
External |
|
|
Store Replenishment Subtype Code |
External |
|
|
Store Loaded Safety Stock |
External |
|
|
Store Trading Days |
External |
|
|
Loaded Weekly Base Sales Forecast |
External |
|
|
Waste Adjustments |
External |
|
|
SRP Poisson Distribution Lookup |
External |
|
|
SKU Retail Price |
External |
|
|
Store Format Pack Size |
External* |
|
|
Store Pack Size |
External* |
|
|
SKU Cost |
External* |
|
|
SKU Weight and Volume |
External* |
This section provides information on these topics:
Details for these files are in the section, External DM Data Load Files.
A set of AIP-Oracle external data load interfaces are built as part of an effort to reduce the Total Cost of Ownership (TCO) of AIP with the objective of increasing the speed of setup of Supply Chain data.
As shown in Figure 12-1, it is expected that these loads are performed after incrementing the AIP virtual date (VDATE) and before executing the process that extracts data out of AIP-Oracle database (cron_export.sh). Refer to Chapter 4, "System Configuration" for more details on VDATE and the cron_export.sh process.
There are two ways to load this set of data into AIP-Oracle:
Use this method for all loading purposes unless there is a need to test a specific load.
Perform the following steps:
A compressed and tarred file, dm_external.tar.Z, containing the externally loadable data files must be made available to the <AIP-ORACLE-HOME>/data directory.
Data files contained in tar file must conform to the published format in this guide.
Batch shell script, cron_import.sh, must be performed with a parameter dm_external. For example:
cd <AIP-ORACLE-HOME>
cron_import.sh dm_external
Executing cron_import.sh this way ensures that data files are loaded in the correct order. This is achieved by the use of configuration file, import_dm_external.config, in the <AIP-ORACLE-HOME>/config directory.
Use this method when there is a need to test a specific load.
Perform the following steps:
The individual data file or the set of individual data files should be made available in <AIP-ORACLE-HOME>/inbound directory. Again the file must conform to the published standard
Individual batch shell scripts corresponding to the loading data files should be performed directly from <AIP-ORACLE-HOME>/scripts/import directory.
For example:
cd <AIP-ORACLE-HOME>/scripts/import
ext_order_multiple_in.sh
Executing load this way assumes that you are familiar with the required order published in configuration file, <AIP_INSTALL_DIR>/config/import_dm_external.config.
File <AIP-ORACLE->/config/import_dm_external.config specifies the correct order of executing shell scripts for loading data from external data files into AIP-Oracle. Table 12-2 lists the order. Details for these files are in the section, External DM Data Load Files.
Table 12-2 Order of External DM Data Loads
| # |
Load Entity | Data File Loaded by Shell Script | Shell script |
|---|---|---|---|
|
1 |
Last Day of Week |
|
ext_last_day_of_week_in.sh |
|
2 |
Order Cycle |
|
ext_order_cycle_in.sh |
|
3 |
SKU Store Order Cycle Associations |
|
ext_profile_in.sh |
|
4 |
Store and Warehouse Receiving Calendar |
ext_receiving_calendar.dat and ext_receiving_cal_exc.dat |
ext_receiving_calendar_in.sh |
|
5 |
Order Group Assignment |
ext_order_group_assignment.dat |
ext_order_group_assignment_in.sh |
|
6 |
Order Multiple |
|
ext_order_multiple_in.sh |
|
7 |
Pallet Multiple |
|
ext_pallet_multiple_in.sh |
|
8 |
Orderable Units |
ext_warehouse_orderable_unit.dat |
ext_warehouse_orderable_unit_in.sh |
|
9 |
Ranging |
|
ext_wh_ranging_in.sh |
|
10 |
Supplier Store Format Combinations |
ext_direct_store_format_pack_size.dat |
ext_dir_store_frmt_pksz_in.sh |
|
11 |
Supplier Store Combinations |
ext_direct_store_pack_size.dat |
ext_dir_store_pksz_in.sh |
|
12 |
Store Format Combinations |
ext_store_format_pack_size.dat |
ext_store_frmt_pksz_in.sh |
|
13 |
Store Order Pack Size |
|
ext_store_pksz_in.sh |
|
14 |
SKU Store Source |
|
ext_store_source_in.sh |
|
15 |
SKU Promotion Data |
ext_sku_promotion.dat |
ext_sku_promotion_in.sh |
|
Note: The start and end dates for store promotional events are part of the external loads and not part of the standardcron_import process. Therefore, users should be aware that in order to load this promotional data either the cron_import_dm_external script must be run or the ext_sku_promotion_in script must be run. |
AIP Oracle nightly automation is available in addition to new external load batch interfaces. Automation logic is controlled by AUTO_ system parameters. If the automation system parameters are not switched off (that is, not set to N), automation runs as part of the overnight data import from AIP-RPAS to AIP-Oracle irrespective of whether external load is done or not. Similarly, whether the automation system parameters are switched on or off, external load processes if the required data files are provided and the process is performed.
You determine what data you want to load directly into AIP-Oracle through external data load interfaces and what data you want to automate from existing automation functionality. Note that some automation (such as profile automation on AIP-RPAS side) is required to be switched ON for the system to work properly and should not be turned Off unless a thorough impact analysis is done.
Table 12-3 lists the system parameters influence performance of external load interfaces.
|
Note: Some of these parameters are turned off by default to ensure out-of-the-box integration. They can be switched on for improved performance depending upon batch requirements, risk tolerance and other technical factors. Contact your DBA to perform update statements to change default value. |
As an example, following statement when run in SQL-Plus session will update value of system parameter RETL_LOAD_METHOD to direct:
sqlplus> UPDATE system_parameters SET value = direct WHERE name = RETL_LOAD_METHOD;
sqlplus> COMMIT;
Table 12-3 System Parameters
| Parameter Name | Default Value | Description |
|---|---|---|
|
PDDL_PARALLEL_DEGREE |
8 |
This parameter controls the degree of parallelism when executing a DDL. This value should be set based on DB CPUs available and timing of batch. |
|
INDEX_LOGGING |
Y |
This parameter determines whether indexes are rebuild or recreated in regular LOGGING (Y) or NOLOGGING (N) mode. If you can tolerate a window where recovery of the index requires it to be re-created, then consider setting this to N for faster performance. |
|
DROP_INDEX_THRESHOLD_PERCENT |
50 |
This parameter is a percentage of incoming data versus existing data in a table used to decide if indexes should be dropped before load. If calculated percent is more than this value, indexes are dropped during merge load. |
|
TABLE_PARALLEL_DEGREE |
8 |
Controls the degree of parallelism for a table. Valid values are 0 (equivalent to Oracle DEFAULT degree), 1 (equivalent to NOPARALLEL) and > 1 (MANUAL). Set this value based on DB CPUs available and timing of batch if manual degree is desired. |
|
RETL_NUM_LOADERS |
16 |
Number of Parallel SQL*Loaders to perform for loads |
|
RETL_LOAD_METHOD |
conventional |
Load method, conventional or direct. Direct: load directly into the Oracle data files, avoiding the use of the conventional path (standard INSERTs). Consider setting this variable to direct for faster load performance. However direct option requires Lock Any Table system privilege if RETL batch user (as defined in RETL Wallet alias) is different from AIP table owner. |
Logging and tracking information is logged at following places:
RETL Log file — Records that fail basic RETL validations such as date format etc. when loading data from file into interface table. For additional information, refer to the Oracle Retail Extract Transform and Load Programmer's Guide.
SQL-Plus .bad file — Records that fail SQL-Plus validation such as NOT NULL constraints etc when loading data from file into interface table. For additional information, refer to the Oracle Retail Extract Transform and Load Programmer's Guide.
BSA log file —This file contains the log messages generated from loading shell script and/or PLSQL program units. This file is located inside logs directory of AIP Oracle integration home. System parameters PLSQL_LOG_LEVEL and PLSQL_LOG_TARGETS control the logging of PLSQL messages in this file.
Table plsql_log — This table contains all log/progress tracking messages from PLSQL program units. System parameters PLSQL_LOG_LEVEL and PLSQL_LOG_TARGETS control the logging of PLSQL messages in this table.
| Column Name | Data Type | Description |
|---|---|---|
| SESSIONID | VARCHAR2(30) | Session ID established by the DB connection. Each sql-plus call from shell script creates a new session. |
| TIMESTAMP | NUMBER | Unix epoch time; that is, seconds elapsed since Jan 1, 1970. |
| LOG_LEVEL | VARCHAR2(12) | Indicates PLSQL logging level. Valid values are:
While Debug level is the most informative, Error level is the least informative logging. Error type log messages must not be ignored. |
| AIP_VDATE | VARCHAR2(8) | VDATE in YYYYMMDD format. |
| LOG_DATE | DATE | SYSDATE without the timestamp part. |
| PROGRAM_NAME | VARCHAR2(64) | PLSQL package from where this message is logged. |
| PROGRAM_LINE_NUMBER | NUMBER | Line number in PLSQL package that is logged in this record. |
| LOG_MESSAGE | VARCHAR2(256) | Message logged. |
| SESSION_USER | VARCHAR2(30) | Database user who is logged on. Remains the same during the entire session. |
Table ext_load_exceptions — This table holds all records that failed validations performed inside PLSQL program units such as failed primary key, failed foreign key validation, and so on.
| Column Name | Data Type | Description |
|---|---|---|
| I_ROWID | ROWID | Interface table ROWID that failed PLSQL validation. |
| TIMESTAMP | NUMBER | Unix epoch time; that is, seconds elapsed since Jan 1, 1970. |
| TABLE_NAME | VARCHAR2(30) | Interface table name that is being validated. |
| MESSAGE | VARCHAR2(250) | Validation failure message. |
V_ERR Views —These are a set of views that conveniently display the PLSQL validation failures recorded in ext_load_exceptions table. There is one view for each supported load.
General structure of V_ERR view = Structure of underlying base interface table plus two additional columns; Message and Timestamp of the ext_load_exceptions table.
Example 12-1 Structure of V_ERR_STORE_SOURCE
STORE : STORE column from I_EXT_STORE_SOURCE interface table SKU : SKU column from I_EXT_STORE_SOURCE interface table SOURCE_TYPE : SOURCE_TYPE column from I_EXT_STORE_SOURCE interface table STORE_SOURCE : STORE_SOURCE column from I_EXT_STORE_SOURCE interface table START_DATE : START_DATE column from I_EXT_STORE_SOURCE interface table END_DATE : END_DATE column from I_EXT_STORE_SOURCE interface table DAY_OF_WEEK : DAY_OF_WEEK column from I_EXT_STORE_SOURCE interface table MESSAGE : MESSAGE column from EXT_LOAD_EXCEPTIONS table TIMESTAMP : TIMESTAMP column from EXT_LOA_EXCEPTIONS table
The following table shows the list of supported views and their underlying base interface tables:
| Load Entity | View Name | Base Interface Table Name |
|---|---|---|
| Source-SKU-WH Order Cycle | V_ERR_ORDER_GROUP_ASSIGNMENT | I_EXT_ORDER_GROUP_ASSIGNMENT |
| Valid SKUPS-WH Ranging combinations | V_ERR_WH_RANGING | I_EXT_WH_RANGING |
| SKU Store Order Cycle associations | V_ERR_PROFILE | I_EXT_PROFILE |
| WH SKUPS store format combinations | V_ERR_STORE_FORMAT_PACK_SIZE | I_STORE_FORMAT_PACK_SIZE |
| WH SKUPS store combinations | V_ERR_STORE_PACK_SIZE | I_STORE_PACK_SIZE |
| Supplier SKUPS store format combinations | V_ERR_DIR_STORE_FORMAT_PCKSIZE | I_DIRECT_STORE_FORMAT_PCKSIZE |
| Supplier SKUPS store combinations | V_ERR_DIR_STORE_PACK_SIZE | I_DIRECT_STORE_PACK_SIZE |
| Source-SKUPS-WH Pallet Multiple | V_ERR_PALLET_MULTIPLE | I_EXT_PALLET_MULTIPLE |
| Order Cycle | V_ERR_ORDER_CYCLE | I_EXT_ORDER_CYCLE |
| Source-SKUPS-WH Orderable Unit | V_ERR_WAREHOUSE_ORDERABLE_UNIT | I_EXT_WAREHOUSE_ORDERABLE_UNIT |
| SKU Store sources | V_ERR_STORE_SOURCE | I_EXT_STORE_SOURCE |
| Source-SKUPS-WH Order Multiple | V_ERR_ORDER_MULTIPLE | I_EXT_ORDER_MULTIPLE |
| Store and WH receiving calendar | V_ERR_RECEIVING_CALENDAR | I_EXT_RECEIVING_CALENDAR |
This section lists the details for the hierarchy data files.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Foundation | Advertisement Hierarchy | Contains Ad and Ad description. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | had.txt |
| Source Object Name | had.txt | Target Object Database | Global |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Ad | Ad | 1 | 20 |
| Ad Label | Ad Description | 21 | 120 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Ad | Ad | String | "A23456789100ABCDE00Q" |
| Ad Label | Ad Description | String | "NEW ADVERTISEMENT BB "
NaVal = '' |
Formatting Conditions
None.
Example of had.txt extract file format:
A23456789100ABCDE00QNEW ADVERTISEMENT A B23456789100ABCDE00QNEW ADVERTISEMENT BB
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Foundation | Interval Hierarchy | Contains Interval Code and description. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | intv.txt |
| Source Object Name | intv.txt | Target Object Database | Global |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Interval | Interval | 1 | 20 |
| Interval Description | Interval Description | 21 | 40 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| INT | Interval Code | String | "A23456789100ABCDE00Q" |
| INT-Label | Interval Description | String | "NEW INTERVAL AA "
NaVal = '' |
Formatting Conditions
None.
Example of intv.txt extract file format:
A23456789100ABCDE00QNEW INTERVAL B23456789100ABCDE00QNEW INTERVAL BB
This section lists the details for the measure data files.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Default Warehouses | Contains Store, default warehouse, and default warehouse CSC. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measures and
Oracle Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | dmx_defwh_ & dmx_defwh_csc &
Warehouse Type |
| Source Object Name | default_wh.txt | Target Object Database | data/dmx_defwh_ & data/dmx_defwh_csc &
Oracle Database |
| Required/Optional | Optional | Target Object Load Intersection | str_ |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| STR | Store | 1 | 20 |
| VALUE 1 | Default Warehouse | 21 | 20 |
| VALUE 2 | Default Warehouse Customer Service Center | 41 | 20 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| STR | Store | String | "s348 " |
| Value 1 | Default Warehouse | String | "w1090 " NaVal = '' |
| Value 2 | Default Warehouse Customer Service Center | String | "w1090 " NaVal = '' |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Warehouses | w |
| Stores | s |
Example of default_wh.txt extract file format:
s348 w1090 w109 s402 w1105 w1150
Load Notes
AIP-RPAS batch processes split this data file into two flat files that are loaded into two AIP-RPAS measures. Then the original file is packaged for transfer to and load by AIP Oracle batch processes.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| not applicable
This information is not loaded into an RPAS measure. It is loaded into an Oracle table only. |
Direct Store Format Pack Size | Contains the pack size that should be ordered when the store is ordering the SKU from the Direct Supplier. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Oracle Data point |
| Source Object Type | Fixed-length Text File | Target Object Name | Direct Store Format Pack Size |
| Source Object Name | direct_store_format_pack_size.txt | Target Object Database | Oracle DB |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Store Format Code | Store Format | 1 | 20 |
| Commodity Code | AIP SKU | 21 | 20 |
| Pack Size | Pack Size | 41 | 4 |
| Supplier Code | Supplier | 45 | 20 |
| Start Date | Start Date | 65 | 8 |
| End Date | End Date | 73 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Store Format Code | Store Format | String | "1 " |
| Commodity Code | AIP SKU | String | "100053003 " |
| Pack Size | Pack Size | Integer | "36 " |
| Supplier Code | Supplier | String | "V505 " |
| Start Date | Start Date | String | "20050101" |
| End Date | End Date | String | "20051201" |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
Example of direct_store_format_pack_size.txt file format:
1 100053003 36 V505 2005010120051201
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Direct Store Pack Size | Contains Store, Commodity Code, Pack Size, Supplier, Start and End dates. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Oracle Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | Direct Store Pack Size |
| Source Object Name | direct_store_pack_size.txt | Target Object Database | Oracle Database |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Store Code | Store | 1 | 20 |
| Commodity Code | AIP SKU | 21 | 20 |
| Pack Size | Pack Size | 41 | 4 |
| Supplier Code | Supplier | 45 | 20 |
| Start Date | Start Date | 65 | 8 |
| End Date | End Date | 73 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| STR | Store | String | "S303 " |
| Commodity Code | AIP SKU | String | "100053003 " |
| Pack Size | Pack Size | Integer | "36 " |
| Supplier Code | Supplier | String | "V505 " |
| Start Date | Start Date | String | "20050101" |
| End Date | End Date | String | "20051201" |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Stores | S |
Example of direct_store_pack_size.txt file format:
S303 100053003 1 V505 2005010120051201
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Receiving Supplier / Ship-to | Contains Supplier and Ship-to values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | dmx_shpto_ |
| Source Object Name | dmx_shpto_.txt | Target Object Database | data/dmx_shpto_ |
| Required/Optional | Required | Target Object Load Intersection | splr |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Supplier | Supplier | 1 | 20 |
| Value | Ship-to | 21 | 24 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Supplier | SPLR Dimension | String | "V166 " |
| Ship-to | Ship-to Code | String | "XD_GS "
NaVal = '' |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Even though the width of the value field is 24, only 6 characters can be utilized by this field. The export of this data to AIP-Oracle contains only 6 characters of values.
Example of dmx_shpto_.txt extract file format:
V166 CS_RG V505 XD_GS
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Ad/Rollout Notes | Simple Parameter |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipadrltntsi |
| Source Object Name | ipadrltntsi.txt | Target Object Database | data/adrltnts |
| Required/Optional | Optional | Target Object Load Intersection | week_skug |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| WEEK | Week | 1 | 8 |
| SKUG | SKU Group | 9 | 20 |
| VALUE | Ad/Rollout Notes | 29 | 24 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Week | Week | String | "W44_2006" |
| SKUG | SKU Group | String | "100117118A " |
| Value | Ad/Rollout Notes | String | "Example Notes "
NaVal = '' |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Weeks | W |
Example of ipadrltntsi.txt extract file format:
W44_2006100117118A Example Notes
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Ad End Date | Defines the end date of a Store Ad |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | not applicable |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipadendi |
| Source Object Name | ipadendi.txt | Target Object Database | data/ad |
| Required/Optional | Optional | Target Object Load Intersection | ad |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| AD | Advertisement | 1 | 20 |
| Value | Store Ad End Date | 21 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Ad | AD Dimension | String | "201CU50505 " |
| Value | Store Ad End Date | Date | "20060225" |
Formatting Conditions
None.
Example of ipadendi.txt extract file format:
201CU50505 20060225
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Ad Start Date | Defines the start date of a Store Ad |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | not applicable |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipadstai |
| Source Object Name | ipadstai.txt | Target Object Database | data/ad |
| Required/Optional | Optional | Target Object Load Intersection | ad |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| AD | Advertisement | 1 | 20 |
| VALUE | Store Ad Start Date | 21 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| AD | Advertisement | String | "201CU50505 " |
| Value | Store Ad Start Date | Date | "20060225" |
Formatting Conditions
None.
Example of ipadstai.txt extract file format:
201CU50505 20060225
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Total Store Average Rate-of-Sales | Contains destination stocking point, SKU, and Subtype code. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipavgrtslsi |
| Source Object Name | ipavgrtslsi.txt | Target Object Database | data/avgrtsls |
| Required/Optional | Optional | Target Object Load Intersection | dstk_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DSTK | Destination Stocking Point | 1 | 20 |
| SKU | SKU | 21 | 20 |
| Value | Total Store Average Rate-of-Sales | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DSTK | Destination Stocking Point | String | "W1090 " |
| SKU | SKU | String | "100048001 " |
| Value | Total Store Average Rate-of-Sales | Real | "123.5678"
NaVal= -1 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipavgrtslsi.txt exact file format:
W1090 100048001 123.5678
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Week-to-Day Forecast Percentage Default | Contains day-of-week, chain, department, and Week-to-Day forecast percentage default values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipfctwkprfd |
| Source Object Name | ipfctwkprfd.txt | Target Object Database | data/ipfctwkprfd |
| Required/Optional | Optional | Target Object Load Intersection | dow_chn_dept |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DOW | Day-of-week | 1 | 8 |
| CHN | Chain | 9 | 20 |
| DEPT | Department | 29 | 20 |
| Value | Week-to-Day Forecast Percentage Default | 49 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DOW | Day-of-week | String | "MON " |
| CHN | Chain | String | "1 " |
| DEPT | Department | String | "5 " |
| Value | Week-to-Day Forecast Percentage Default | Real | "0.14 "
NaVal = 0 |
Formatting Conditions
None.
Example of ipfctwkprfd.txt extract file format:
MON 1 5 0.14 TUE 1 5 0.14
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Week-to-Day Forecast Percentage Override (Un-Normalized) | Contains day, chain, subclass, and Week-to-Day forecast percentage override values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipfctwkprfe |
| Source Object Name | ipfctwkprfe.txt | Target Object Database | data/ipfctwkprfe |
| Required/Optional | Optional | Target Object Load Intersection | day_chn_scls |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| CHN | Chain | 10 | 20 |
| SCLS | Subclass | 30 | 20 |
| VALUE | Store Week-to-Day Forecast Percentage Override | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20090101" |
| CHN | Chain | String | "1 " |
| SCLS | Subclass | String | "5 " |
| VALUE | Store Week-to-Day Forecast Percentage Override | Real | "0.14 " NaVal = 0 |
Formatting Conditions
None.
Example of ipfctwkprfe.txt extract file format:
D200901011 5 0.14 D200901021 5 0.14
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Hold Back Quantity | Contains day, destination stocking point, SKU, and Hold Back Quantity values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | iphldbckqtyi |
| Source Object Name | iphldbckqtyi.txt | Target Object Database | data/hldbckqty |
| Required/Optional | Optional | Target Object Load Intersection | day_dstk_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| DSTK | Destination Stocking Point | 10 | 20 |
| SKU | SKU | 30 | 20 |
| VALUE | Hold Back Quantity | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050820" |
| DSTK | Destination Stocking Point | String | "W1090 " |
| SKU | SKU | String | "100048001 " |
| Value | Hold Back Quantity | Real | "280 "
NaVal = -1 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of iphldbckqtyi.txt extract file format:
D20050820W1090 100048001 280
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Warehouse Independent ARS | Represents the externally loaded Average Rate of Sale (ARS) assigned to the warehouse |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipiavgrtslsi |
| Source Object Name | ipiavgrtslsi.txt | Target Object Database | data/iavgrtsls |
| Required/Optional | Optional | Target Object Load Intersection | dstk_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DSTK | Destination Stocking Point | 1 | 20 |
| SKU | SKU | 21 | 20 |
| VALUE | Warehouse Independent ARS | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DSTK | Destination Stocking Point | String | "W1090 " |
| SKU | SKU | String | "100048001 " |
| VALUE | Warehouse Independent ARS | Real | "99.75"
NaVal=0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipiavgrtslsi.txt extract file format:
W1090 100048001 99.75
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Inbound Capacity Cases for Reporting | Indicates the inbound capacity in cases at a warehouse. This value is used for reporting. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipibcpcco |
| Source Object Name | ipibcpcco.txt | Target Object Database | data/ibcpcc |
| Required/Optional | Optional | Target Object Load Intersection | day_wh |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| WH | Warehouse | 10 | 20 |
| Value | Inbound Capacity Cases Value | 30 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20060401" |
| WH | Warehouse | String | "W1090 " |
| Value | Inbound Capacity Cases Value | Integer | "120 "
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipibcpcco.txt extract file format:
D20060401W1090 120
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Loaded Safety Stock | Contains destination stocking point, SKU, and Loaded safety stock values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipldssi |
| Source Object Name | ipldssi.txt | Target Object Database | data/ldss |
| Required/Optional | Optional | Target Object Load Intersection | dstk_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DSTK | Destination Stocking Point | 1 | 20 |
| SKU | SKU | 21 | 20 |
| Value | Loaded Safety Stock Value | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DSTK | Destination Stocking Point | String | "W1090 " |
| SKU | SKU | String | "100048001 " |
| Value | Loaded Safety Stock Value | Real | "520.50000"
NaVal =0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipldssi.txt extract file format:
W1090 100048001 520.5000 W3066 100049004 520.5000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Outbound Capacity Cases | Indicates the outbound capacity in cases at a warehouse. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipobcpcco |
| Source Object Name | ipobcpcco.txt | Target Object Database | data/obcpcc |
| Required/Optional | Optional | Target Object Load Intersection | day_wh |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| WH | Warehouse | 10 | 20 |
| Value | Outbound Capacity Cases Value | 30 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20060401" |
| WH | Warehouse | String | "W1090 " |
| Value | Outbound Capacity Cases Value | Integer | "120 "
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipobcpcco.txt extract file format:
D20060401W1090 120
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | SPQ Order Commit Quantity | Contains the Fixed or Capped Purchase Quantity agreed upon with the Vendor. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipodcmti |
| Source Object Name | ipodcmti.txt | Target Object Database | data/odcmt |
| Required/Optional | Optional | Target Object Load Intersection | week_sstk_skug |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| WEEK | Week of the Year | 1 | 8 |
| SSTK | Source Stocking Point | 9 | 20 |
| SKUG | SKU Group | 29 | 20 |
| Value | Order Commit | 49 | 24 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| WEEK | Week | String | "W25_2005" |
| SSTK | Source Stocking Point | String | "V1001 " |
| SKUG | SKU Group | String | "100117118A " |
| Value | Order Commit Quantity | Real | "1200.000"
NaVal= -1 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipodcmti.txt extract file format:
W25_2005V1001 100055017A 1200.000 W26_2005V1001 100055017A 1200.000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Replenishment Subtype Code | Contains destination stocking point, SKU, and Subtype code. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | iprplstcdi |
| Source Object Name | iprplstcdi.txt | Target Object Database | data/rplstcd |
| Required/Optional | Optional | Target Object Load Intersection | dstk_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DSTK | Destination Stocking Point | 1 | 20 |
| SKU | SKU | 21 | 20 |
| Value | Replenishment Type Code Value | 41 | 24 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DSTK | Destination Stocking Point | String | "W1090 " |
| SKU | SKU | String | "100046031 " |
| Value | Replenishment Type Code Value | String | "H "
NaVal = '' |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of iprplstcdi.txt extract file format:
W1090 100046031 H W3066 100033002 O
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Replenishment Type Code | Contains destination stocking point, SKU, and Type code values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | iprpltcdi |
| Source Object Name | iprpltcdi.txt | Target Object Database | data/rpltcd |
| Required/Optional | Optional | Target Object Load Intersection | dstk_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DSTK | Destination Stocking Point | 1 | 20 |
| SKU | SKU | 21 | 20 |
| Value | Replenishment Type Code Value | 41 | 24 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DSTK | Destination Stocking Point | String | "W1090 " |
| SKU | SKU | String | "100033002 " |
| Value | Replenishment Type Code Value | String | "A "
NaVal = '' |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of iprpltcdi.txt extract file format:
W1090 100046031 A W3066 100033002 O
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Historical Weekly Sales | Contains weekly sales history to be used when replenishing by the Sales Week Range or Average Weekly Sales replenishment methods. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Online Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | ipslsi |
| Source Object Name | ipslsi.txt | Target Object Database | data/sls |
| Required/Optional | Optional | Target Object Load Intersection | week_dstk_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| WEEK | Week | 1 | 8 |
| DSTK | 9 | 20 | |
| SKU | SKU | 29 | 20 |
| Value | Historical Weekly Sales | 49 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| WEEK | Week | String | "W31_2005" |
| DSTK | Unique identifier of a Warehouse | String | "W1090 " |
| SKU | SKU | String | "100048001 " |
| Value | Historical Weekly Sales value | Real | "105.0000"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipslsi.txt extract file format:
W31_2005W1090 100076002 105.0000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Total Held Stock | Simple Parameter |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipttlhlstki |
| Source Object Name | ipttlhlstki.txt | Target Object Database | data/ttlhlstk |
| Required/Optional | Optional | Target Object Load Intersection | day_dstk_skps |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| DSTK | Destination Stocking Point | 10 | 20 |
| SKPS | Commodity Pack Size | 30 | 20 |
| VALUE | Total Held Stock | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Day | Day | String | "D20060123" |
| DSTK | Destination Stocking Point | String | "W1090 " |
| SKPS | Commodity Pack Size | String | "118525_1 " |
| Value | Total Held Stock | Integer | "2000 "
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipttlhlstki.txt extract file format:
D20060123W1090 118525_1 2000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Stocking Point Holding Capacity | Simple Parameter |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | ipwhhldcpci |
| Source Object Name | ipwhhldcpci.txt | Target Object Database | data/whhldcpc |
| Required/Optional | Optional | Target Object Load Intersection | dstknwgp |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DSTK | Destination Stocking Point | 1 | 20 |
| NWGP | Network Group | 21 | 8 |
| Value | Stocking Point Holding Capacity | 29 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DSTK | Destination Stocking Point | String | "W4110 " |
| NWGP | Network Group Position | String | "001 " |
| Value | Stocking Point Holding Capacity | Integer | "1000 "
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of ipwhhldcpci.txtextract file format:
W4110 001 1000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Item Attribute | Contains SKU, Order Multiple, Pack Quantity, Attribute Type, and Attribute values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Online Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | Item Attributes |
| Source Object Name | item_attribute.txt | Target Object Database | Online Database |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| RMS SKU | RMS SKU | 1 | 20 |
| Order Multiple | Order Multiple | 21 | 4 |
| Pack Quantity | Pack Quantity | 25 | 4 |
| Attribute Type | Attribute Type | 29 | 6 |
| Attribute Value | Attribute Value | 35 | 40 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| RMS SKU | RMS SKU | String | "100048001 " |
| Order Multiple | Order Multiple | Integer | "1 " |
| Pack Quantity | Pack Quantity | String | "0 " |
| Attribute Type | Attribute Type | String | "WHSED " |
| Attribute Value | Attribute Value | String | "Y" |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of item_attribute.txt extract file format:
100048001 1 0 WHSED Y 100049004 1 0 WHSED Y
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Item Type | Contains SKU, Order Multiple, Pack Quantity, Attribute Type, and Attribute values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Online Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | Item Attribute Types |
| Source Object Name | item_attribute_type.txt | Target Object Database | Online Database |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Attribute Type | Attribute Type | 1 | 6 |
| Attribute Type Description | Attribute Type Description | 7 | 40 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Attribute Type | Attribute Type | String | "WHSED " |
| Attribute Type Description | Attribute Type Description | String | "Warehouse Indicator " |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of item_attribute_type.txt extract file format:
WHSED Warehouse Indicator VKSTK Viking Stocked Indicator
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| not applicable
This data is not loaded into an RPAS measures. It is loaded into an Oracle table. |
Purged Purchase Order Numbers | Contains AIP purchase order numbers that have been purged from the order execution system. The PO numbers can be assigned to new POs. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Oracle Table |
| Source Object Type | Fixed-length Text File | Target Object Name | available_PO_num |
| Source Object Name | rmse_order_purge.dat | Target Object Database | AIP Online Schema |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| ORDER_NUMBER | Available Purchase Order Number | 1 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| ORDER_NO | Available Purchase Order Number | Number(8) | "123456 " |
Formatting Conditions
None
Example of rmse_order_purge.dat extract file format:
123456
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Sister Store | Contains Sister Store, Existing
Store, and Open Date. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measures and
Online Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | dmx_sst &
dmx_stropndt_ & Sister Store |
| Source Object Name | sister_store.txt | Target Object Database | data/dmx_sst &
data/dmx_stropndt & Online Database |
| Required/Optional | Optional | Target Object Load Intersection | str &
str & not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Sister/New Store | Sister/New Store | 1 | 20 |
| Existing Store | Existing Store | 21 | 20 |
| Open Date | Open Date | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Sister/New Store | Sister/New Store | String | "S303 " |
| Existing Store | Existing Store | String | "S402 " |
| Open Date | Open Date | String | "20051201" |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of sister_store.txt extract file format:
S303 S402 20051201 S348 S309 20051201
Load Notes
The AIP-RPAS Batch process splits this data file into two flat files that are loaded into two AIP-RPAS measures. The original data file is exported to AIP Oracle and loaded by the AIP Oracle Batch processes.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Sister Warehouse | Contains Sister Warehouse, Existing Warehouse, and Open Date. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measures and
Online Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | dmx_swh &
dmx_wh_opndt_ & Sister Warehouse |
| Source Object Name | sister_wh.txt | Target Object Database | data/dmx_swh &
data/dmx_wh_opndt_ & Online Database |
| Required/Optional | Optional | Target Object Load Intersection | wh &
wh & not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Sister/New Warehouse | Sister/New Warehouse | 1 | 20 |
| Existing Warehouse | Existing Warehouse | 21 | 20 |
| Open Date | Open Date | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Sister/New Warehouse | Sister/New Warehouse | String | "W1090 " |
| Existing Warehouse | Existing Warehouse | String | "W1091 " |
| Open Date | Open Date | String | "20051201" |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of sister_wh.txt extract file format:
W1090 W1091 20051201 W1105 W1170 20051201
Load Notes
The AIP-RPAS Batch process splits this data file into two flat files that are loaded into two AIP-RPAS measures. The original data file is exported to AIP Oracle and loaded by the AIP Oracle Batch processes.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Ads | Contains Store, SKU, Ad, and Store Ads Boolean flag. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_ad_ |
| Source Object Name | sr0_ad_.txt | Target Object Database | data/sr0_ad_ |
| Required/Optional | Optional | Target Object Load Intersection | str_sku_ad |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| STR | Store | 1 | 20 |
| SKU | SKU | 21 | 20 |
| AD | Advertisement | 41 | 20 |
| Value | Store Ads | 61 | 1 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| STR | Store | String | "S348 " |
| SKU | SKU | String | "100055017 " |
| AD | Advertisement | String | "IC0604051 " |
| Value | Store Ads | Boolean | "1"
NaVal = false |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_ad_.txt extract file format:
S348 100055017 IC0604051 1
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Ads Grand Opening | Contains Store, SKU, Ad, and Store Ads grand opening values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_ad_go_ |
| Source Object Name | sr0_ad_go_.txt | Target Object Database | data/sr0_ad_go_ |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| VALUE | Store Ads Grand Opening | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S348 " |
| SKU | SKU | String | "100055017 " |
| Value | Store Ads Grand Opening | Real | "123.5678"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_ad_go_.txt extract file format:
D20050801S348 100055017 123.5678
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Ads Inserts | Contains Store, SKU, Ad, and Store Ads Inserts values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_ad_irt |
| Source Object Name | sr0_ad_irt.txt | Target Object Database | data/sr0_ad_irt |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| VALUE | Store Ads Inserts | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S348 " |
| SKU | SKU | String | "100055017 " |
| Value | Store Ads Inserts | Real | "1.000000"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_ad_irt.txt extract file format:
D20050801S348 100055017 1.000000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Ads Others | Contains Store, SKU, Ad, and Store Ads Others values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_ad_oth |
| Source Object Name | sr0_ad_oth.txt | Target Object Database | data/sr0_ad_oth |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| VALUE | Store Ads Others | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S348 " |
| SKU | SKU | String | "100055017 " |
| VALUE | Store Ads Others | Real | "1.000000"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_ad_oth.txt extract file format:
D20050801S348 100055017 1
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Ads run on press | Contains Store, SKU, Ad, and Store Ads run on press values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_ad_rop |
| Source Object Name | sr0_ad_rop.txt | Target Object Database | data/sr0_ad_rop |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Store Ads run on press | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S348 " |
| SKU | SKU | String | "100055017 " |
| VALUE | Store Ads run on press | Real | "1.000000"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_ad_rop.txt extract file format:
D20050801S348 100055017 1.000000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Adjusted Sales | Contains Store, SKU, Day, and Store Adjusted Sales values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_adjsls |
| Source Object Name | sr0_adjsls.txt | Target Object Database | data/sr0_adjsls |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Store Adjusted Sales | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S348 " |
| SKU | SKU | String | "100055017 " |
| Value | Store Adjusted Sales | Real | "1.000000"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_adjsls.txt extract file format:
D20050820S441105 100057004 5
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Average Weekly Rate-of-Sale Loaded | Contains Store, SKU, and Store average week Rate-of-Sale loaded. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_avgrosld_ |
| Source Object Name | sr0_avgrosld_.txt | Target Object Database | data/sr0_avgrosld_ |
| 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 |
| SKU | SKU | 21 | 20 |
| VALUE | Store Average Weekly Rate-of-Sale Loaded | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| STR | Store | String | "S441090 " |
| SKU | SKU | String | "100076002 " |
| Value | Store Average Weekly Rate-of-Sale Loaded | Real | "200.0000"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_avgrosld_.txt extract file format:
S441090 100076002 200.0000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Customer Orders | Contains Store, SKU, Ad, and Store Customer Orders quantity. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_co_ |
| Source Object Name | sr0_co_.txt | Target Object Database | data/sr0_co_ |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| VALUE | Store Customer Orders | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050820" |
| STR | Store | String | "S441105 " |
| SKU | SKU | String | "100057004 " |
| Value | Store Customer Orders | Real | "1 "
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_co_.txt extract file format:
D20050820S441105 100057004 1
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Daily Short Code Sales | Contains Day, Store, SKU, and Daily Short Code Sales quantity. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_dyscsls |
| Source Object Name | sr0_dyscsls.txt | Target Object Database | data/sr0_dyscsls |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Daily Short Code Sales | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20060125" |
| STR | Store | String | "S303 " |
| SKU | SKU | String | "118525 " |
| Value | Daily Short Code Sales | Real | "123.4500"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_dyscsls.txt extract file format:
D20060125S303 118525 123.4500
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Expected Write-Off | Contains Day, Store, SKU, and Store Expected Write-Off values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_expwrtoff |
| Source Object Name | sr0_expwrtoff.txt | Target Object Database | data/sr0_expwrtoff |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Store Expected Write-Off | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S303 " |
| SKU | SKU | String | "100055009 " |
| Value | Store Expected Write-Off | Real | "5 "
NaVal = -1 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_expwrtoff.txt extract file format:
D20050801S303 100055009 5
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Historical Lost Sales | Contains Day, Store, SKU, and Store historical lost sales values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_hstls_ |
| Source Object Name | sr0_hstls_.txt | Target Object Database | data/sr0_hstls_ |
| Required/Optional | Required | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Store Historical Lost Sales | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S303 " |
| SKU | SKU | String | "100055009 " |
| Value | Store Historical Lost Sales | Real | "1000.500" NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_hstls_.txt extract file format:
D20050801S303 100055009 1000.500
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Inventory Adjustments | Contains Day, Store, SKU, and Inventory Adjustments values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_invadj |
| Source Object Name | sr0_invadj.txt | Target Object Database | data/sr0_invadj |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Inventory Adjustments | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20060123" |
| STR | Store | String | "S303 " |
| SKU | SKU | String | "163460 " |
| Value | Inventory Adjustments | Real | "123.4500"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_invadj.txt extract file format:
D20060124S303 163460 123.4500
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Known Demand | Contains Day, Store, SKU, and Store known demand values. |
FIXED-LENGTHExtracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_knowndemand |
| Source Object Name | sr0_knowndemand.txt | Target Object Database | data/sr0_knowndemand |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Store Known Demand | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| DAY | Day | String | "D20050801" |
| STR | Store | String | "S303 " |
| SKU | SKU | String | "100055009 " |
| Value | Store Known Demand | Real | "1000.500" NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_knowndemand.txt extract file format:
D20050801S303 100055009 1000.500
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Run Overstock Alert Flag | Indicates whether or not the stores is to be included in Overstock Alert calculation. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_ovrstkflg |
| Source Object Name | sr0_ovrstkflg.txt | Target Object Database | data/sr0_ovrstkflg |
| Required/Optional | Optional | Target Object Load Intersection | str_ |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| STR | Store | 1 | 20 |
| Value | Run Overstock Alert Flag | 21 | 1 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| STR | Store | String | "S303 " |
| Value | Run Overstock Alert Flag | Boolean | "1"
NaVal=false |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouse | W |
| Stores | S |
Example of sr0_ovrstkflg.txt extract file format:
S303 1
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Repl Type Code | Contains Store, SKU, and Replenishment Type Code. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_rplcde |
| Source Object Name | sr0_rplcde.txt | Target Object Database | data/sr0_rplcde |
| 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 |
| SKU | SKU | 21 | 20 |
| Value | Store Replenishment Type Code | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| STR | Store | String | "S303 " |
| SKU | SKU | String | "100048001 " |
| Value | Store Replenishment Type Code | String | "A "
NaVal =0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_rplcde.txt extract file format:
S303 100046031 A S348 100033002 M
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Replenishment Subtype Code | Contains Store, SKU, and Replenishment Subtype Code. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_rplsubcde |
| Source Object Name | sr0_rplsubcde.txt | Target Object Database | data/sr0_rplsubcde |
| 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 |
| SKU | SKU | 21 | 20 |
| Value | Store Replenishment Subtype Code | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| STR | Store | String | "S303 " |
| SKU | SKU | String | "100048001 " |
| Value | Store Replenishment Subtype Code | String | "A "
NaVal =0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_rplsubcde.txt extract file format:
S303 100046031 A S348 100033002 J
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Loaded Safety Stock | Contains Store, SKU, and Loaded Safety Stock values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_ss_ld_ |
| Source Object Name | sr0_ss_ld_.txt | Target Object Database | data/sr0_ss_ld_ |
| 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 |
| SKU | SKU | 21 | 20 |
| VALUE | Store Loaded Safety Stock Value | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Store | Store | String | "S441090 " |
| SKU | SKU | String | "100048001 " |
| Value | Store Loaded Safety Stock Value | Real | "155.0000"
NaVal =0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_ss_ld_.txt extract file format:
S441090 100048001 155.0000 S348 100049004 155.0000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Trading Days | Contains Day, Store, and Store Trading days flag. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_tdgday |
| Source Object Name | sr0_tdgday.txt | Target Object Database | data/ssldat |
| Required/Optional | Optional | Target Object Load Intersection | STR_day_ |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| Value | Store Trading Days | 30 | 1 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Day | Day | String | "D20050620" |
| Store | Store | String | "S303 " |
| Value | Store Trading Days | Boolean | "1"
NaVal = true |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of sr0_tdgday.txt extract file format:
D20050620S303 1 D20050621S303 1
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Loaded Weekly Base Sales Forecast | Loaded measure at SKU/str/week to indicate the weekly base sales forecast.
This measure comes from external legacy systems, not from RDF. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_wkbsf_ld |
| Source Object Name | sr0_wkbsf_ld.txt | Target Object Database | data/sr0_wkbsf_ld |
| Required/Optional | Optional | Target Object Load Intersection | week_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| WEEK | Week | 1 | 8 |
| STR | Store | 9 | 20 |
| SKU | SKU | 29 | 20 |
| Value | Loaded Weekly Base Sales Forecast | 49 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Week | Week | String | "W05_2006" |
| Store | Store | String | "S303 " |
| SKU | SKU | String | "118525 " |
| Value | Loaded Weekly Base Sales Forecast | Real | "1.00000"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_wkbsf_ld.txt extract file format:
W05_2006S303 118525 1.00000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Waste Adjustments | Contains Day, Store, SKU, and Waste Adjustments values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | sr0_wstadj |
| Source Object Name | sr0_wstadj.txt | Target Object Database | data/sr0_wstadj |
| Required/Optional | Optional | Target Object Load Intersection | day_str_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| DAY | Day | 1 | 9 |
| STR | Store | 10 | 20 |
| SKU | SKU | 30 | 20 |
| Value | Waste Adjustments | 50 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Day | Day | String | "D20060126" |
| Store | Store | String | "S303 " |
| SKU | SKU | String | "168941 " |
| Value | Waste Adjustments | Real | "123.4500"
NaVal = 0 |
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Stores | S |
Example of sr0_wstadj.txt extract file format:
D20060126S303 168941 123.4500
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | SRP Poisson Distribution Lookup | Loaded Poisson distribution table. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | srx_poidst |
| Source Object Name | srx_poidst.txt | Target Object Database | data/srx_poidst |
| Required/Optional | Optional | Target Object Load Intersection | seq_int_ |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| SEQ | Sequence Number | 1 | 20 |
| INT | Interval | 21 | 20 |
| Value | SRP Poisson Distribution Lookup | 41 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| SEQ | Sequence Number | String | "0016 " |
| INT | Interval | String | "121000 " |
| Value | SRP Poisson Distribution Lookup | Real | "33.3 "
NaVal = 0 |
Formatting Conditions
None.
Example of srx_poidst.txt extract file format:
0016 121000 33.3
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | SKU Retail Price | Contains Week, Company, SKU, and Retail Price values. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | srx_prdrpr |
| Source Object Name | srx_prdrpr.txt | Target Object Database | data/srx_prdrpr |
| Required/Optional | Optional | Target Object Load Intersection | week_cmpn_sku |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| WEEK | Week | 1 | 8 |
| COMPANY | Company | 9 | 20 |
| SKU | SKU | 29 | 20 |
| Value | SKU Retail Price | 49 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Week | Week | String | "W32_2005" |
| Company | Company | String | "1 " |
| SKU | SKU | String | "100048001 " |
| Value | SKU Retail Price | Real | "6.460000"
NaVal = 0 |
Formatting Conditions
None.
Example of srx_prdrpr.txt extract file format:
W32_20051 100048001 6.460000 W32_20051 100048001 6.460000
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Format Pack Size | Contains Store Format, AIP SKU, pack size, Warehouse, Start Date, and End Date. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | RPAS Measure |
| Source Object Type | Fixed-length Text File | Target Object Name | Store Format Pack Size |
| Source Object Name | store_format_pack_size.txt | Target Object Database | Online Database |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Store Format Code | Store Format | 1 | 20 |
| Commodity Code | AIP SKU | 21 | 20 |
| Pack Size | Pack Size | 41 | 4 |
| Stocking Point Number | Warehouse | 45 | 20 |
| Start Date | Start Date | 65 | 8 |
| End Date | End Date | 73 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Store Format | Store Format | String | "1 " |
| Commodity Code | AIP SKU | String | "100052001 " |
| Pack Size | Pack Size | Integer | "36 " |
| Stocking Point Number | Warehouse | String | "W3066 " |
| Start Date | Start Date | String | "20050101" |
| End Date | End Date | String | "20051201" |
Filtering Conditions
The SKU-pack size should have an AIP ranging status of Profile Ranged, Exception Ranged, or Pending De-ranged at the warehouse before it is loaded into AIP as the store-ordering pack size.
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of store_format_pack_size.txt extract file format:
1 100052001 36 W3066 2005010120051201
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | Store Pack Size | Contains the preferred ordering pack size when ordering the SKU from the warehouse to the store during a particular time period. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Online Data Point |
| Source Object Type | Fixed-length Text File | Target Object Name | Store Pack Size |
| Source Object Name | store_pack_size.txt | Target Object Database | Online Database |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Store Code | Store | 1 | 20 |
| Commodity Code | AIP SKU | 21 | 20 |
| Pack Size | Pack Size | 41 | 4 |
| Stocking Point Number | Warehouse | 45 | 20 |
| Start Date | Start Date | 65 | 8 |
| End Date | End Date | 73 | 8 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| Store Code | Store | String | "S303 " |
| Commodity Code | AIP SKU | String | "100052001 " |
| Pack Size | Pack Size | Integer | "36 " |
| Stocking Point Number | Warehouse | String | "W3066 " |
| Start Date | Start Date | String | "20050101" |
| End Date | End Date | String | "20051201" |
Filtering Conditions
The SKU-pack size should have an AIP ranging status of Profile Ranged, Exception Ranged, or Pending De-ranged at the warehouse before it is loaded into AIP as the store-ordering pack size.
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
| Stores | S |
Example of store_pack_size.txt extract file format:
S303 100052001 1 W3066 2005010120051201
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | SKU Cost | Contains the unit cost of a SKU from a supplier to a warehouse. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Oracle Database |
| Source Object Type | Fixed-length Text File | Target Object Name | commodity_cost |
| Source Object Name | sku_cost.dat | Target Object Database | not applicable |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Commodity Code | AIP SKU | 1 | 25 |
| Supplier Code | Supplier | 26 | 20 |
| Warehouse Number | Warehouse | 46 | 20 |
| Commodity Cost | SKU Cost | 66 | 20 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| commodity_code | Unique AIP SKU identifier | String | "100052001 " |
| supplier_code | Unique Supplier identifier | String | "V11111 " |
| stocking_point_number | Unique Warehouse identifier | String | "W36 " |
| commodity_cost | SKU Cost | Sfloat | "15.9900 " |
Filtering Conditions
None.
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
| Warehouses | W |
Example of sku_cost.dat extract file format:
"100052001 V11111 W36 15.9900 "
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Measure | SKU Weight and Volume | Contains the unit weight and/or volume of a SKU from a supplier. |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| not applicable | not applicable | not applicable | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | External Systems | Target Object Type | Oracle Database |
| Source Object Type | Fixed-length Text File | Target Object Name | commodity_weight_volume |
| Source Object Name | sku_weight_volume.dat | Target Object Database | not applicable |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
Field Level Mapping - Source
| Source Fields | Source Field Description | Field Start Position | Field Width |
|---|---|---|---|
| Commodity Code | AIP SKU | 1 | 25 |
| Supplier Code | Supplier | 26 | 20 |
| Commodity Weight | SKU weight | 46 | 20 |
| Commodity Volume | SKU volume | 66 | 20 |
Field Level Mapping - Target
| Target Data Field Name | Target Field Description | Target Field Data Type | Condition/Format |
|---|---|---|---|
| commodity_code | Unique AIP SKU identifier | String | "100052001 " |
| supplier_code | Unique Supplier identifier | String | "V11111 " |
| commodity_weight | SKU weight | Sfloat | "3.0000 " |
| commodity_volume | SKU volume | Sfloat | "0.9560 " |
Filtering Conditions
None.
Formatting Conditions
| Value | Prefix (Case Sensitive) |
|---|---|
| Supplier | V |
Example of sku_weight_volume.dat extract file format:
"100052001 V11111 3.0000 0.9560 "
This section lists the details for the external DM Data Load files.
The following sections detail the text file containing a calendar day to be used as the last day of week on the system. This file is sent one time only upon system configuration. Loading this file is optional. A default value of Saturday is used otherwise.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Last day of Week for the system | Last day of week to be used as reference when loading day values |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| Shell | ext_last_day_of_week_in.sh | None | One time |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | One string Text File | Target Object Name | INTERFACE_PARAMETERS |
| Source Object Name | ext_last_day_of_week.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Single column value update |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | (None) | Last day of week in English | String | 1 | 10 | At least the first three letters of the calendar day | For example: Sun or Sunday |
Example of ext_last_day_of_week.dat data file format:
1234567890 Sunday
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | INTERFACE_PARAMETERS.last_day_of_week | Stores the last day of week and assigned a 0 to 6 value. 0 represents a Sunday and 6 represent a Saturday value in the system. | NUMBER(1) | N |
Special Processing
None
Database External Load Parameters
None
The following sections detail the text file necessary for the Order Cycle External Load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Order Cycle | New/Updated Order Cycles (Store or Warehouse) |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_order_cycle_in.sh | ext_order_cycle.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | ORDER_CYCLE ORDER |
| CYCLE_LEAD_TIME STORE_ | |||
| ORDER_CYCLE STORE_ | |||
| ORDER_CYCLE_LEAD_TIME | |||
| Source Object Name | ext_order_cycle.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | ORDER_CYCLE_TYPE | String | 1 | 1 | Mandatory S/W | S | |
| 2 | ORDER_CYCLE_CODE | String | 2 | 20 | Mandatory | FULLC | |
| 3 | ORDER_CYCLE_NAME | String | 22 | 120 | Mandatory | Full Calendar Order Cycle | |
| 4 | ORDER_CYCLE_LENGTH | Integer | 142 | 2 | Mandatory
7,14,28 |
28 | |
| 5 | DAY_OF_CYCLE | Integer | 142 | 2 | Mandatory
1-7 1-14 1-28 |
1 | |
| 6 | LEAD_TIME | Integer | 146 | 3 | Mandatory
>= -1 |
3 |
|
Note: Undefined lead time is represented by a value of -1. |
Example of ext_order_cycle.dat data file format (fixed width 148):
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678 SFULLC Full Calendar Order Cycle 281 3
Field Level Mapping - Target
Table 12-4 Store Order Cycles
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
|
1 |
STORE_ORDER_CYCLE.store_order_cycle_id |
Unique AIP Database Identifier for Store Order Cycle |
NUMBER(12) |
N |
|
2 |
STORE_ORDER_CYCLE.store_order_cycle_code |
Store Order Cycle short code |
VARCHAR2(20) |
N |
|
3 |
STORE_ORDER_CYCLE.store_order_cycle_name |
Store Order Cycle full name |
VARCHAR2(120) |
Y |
|
4 |
STORE_ORDER_CYCLE.store_order_cycle_length |
Length in Days: 7, 14 or 28 |
NUMBER |
N |
|
5 |
STORE_ORDER_CYCLE_LEAD_TIME.store_order_cycle_id |
Unique AIP Database Identifier for Store Order Cycle |
NUMBER(12) |
N |
|
6 |
STORE_ORDER_CYCLE_LEAD_TIME.store_order_cycle_seq |
Contains the cycle day-of-week, can range between 1 and 7, 14, or 28 |
NUMBER |
N |
|
7 |
STORE_ORDER_CYCLE_LEAD_TIME.release_lead_time |
Release lead time in days |
NUMBER(3) |
Y |
|
8 |
STORE_ORDER_CYCLE_LEAD_TIME.placement_lead_time |
Placement lead time in days |
NUMBER(3) |
Y |
Table 12-5 Warehouse Order Cycles
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
|
1 |
ORDER_CYCLE.store_order_cycle_id |
Unique AIP Database Identifier for Warehouse Order Cycle |
NUMBER(12) |
N |
|
2 |
ORDER_CYCLE.store_order_cycle_code |
Warehouse Order Cycle short code |
VARCHAR2(20) |
N |
|
3 |
ORDER_CYCLE.store_order_cycle_name |
Warehouse Order Cycle full name |
VARCHAR2(120) |
Y |
|
4 |
ORDER_CYCLE.store_order_cycle_length |
Length in Days 7, 14 or 28 |
NUMBER |
N |
|
5 |
ORDER_CYCLE_LEAD_TIME.order_cycle_id |
Unique AIP Database Identifier for Warehouse Order Cycle |
NUMBER(12) |
N |
|
6 |
ORDER_CYCLE_LEAD_TIME.order_cycle_seq |
Contains the cycle day-of-week, can range between 1 and 7, 14, or 28 |
NUMBER |
N |
|
7 |
ORDER_CYCLE_LEAD_TIME.order_lead_time |
Order lead time in days |
NUMBER(3) |
Y |
Special Processing
Mapping to the internal database identifier: store_order_cycle_id or order_cycle_id is performed.
The following sections detail the text file necessary for the Profile External Load process:
ext_profile.dat
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Profile | New Profiles |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_profile_in.sh | ext_profile.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | STORE_SKU_RELEASE_SCHEDULE_EXC |
| Source Object Name | ext_profile.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | SKU | Unique identifier for the product (item) | String | 1 | 20 | Mandatory and must already exist in AIP | 400000 |
| 2 | STORE_CODE | String | 21 | 20 | Mandatory and must already exist in AIP | 2000 | |
| 3 | STORE_ORDER_CYCLE_CODE | String | 41 | 20 | Mandatory | 200 | |
| 4 | START_DATE | Effective Date YYYYMMDD | Date | 61 | 8 | Optional | 20121030 |
| 5 | END_DATE | To Date YYYYMMDD | Date | 69 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_profile.dat data file format (fixed width 76):
1234567890123456789012345678901234567890123456789012345678901234567890123456 400000 2000 200 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | STORE_SKU_RELEASE_SCHEDULE_EXC.store_id | Unique AIP Database Identifier for Store | NUMBER(12) | N |
| 2 | STORE_SKU_RELEASE_SCHEDULE_EXC.commodity_id | Unique AIP Database Identifier for Product | NUMBER(10) | N |
| 3 | STORE_SKU_RELEASE_SCHEDULE_EXC.store_order_cycle_id | Unique AIP Database Identifier for Store Order Cycle | NUMBER(12) | N |
| 4 | STORE_SKU_RELEASE_SCHEDULE_EXC.start_date | Effective Date YYYYMMDD | Date | Y |
| 5 | STORE_SKU_RELEASE_SCHEDULE_EXC.end_date | To Date YYYYMMDD | Date | Y |
Special Processing
Mappings to internal database identifiers: store_id, commodity_id and store_order_cycle_id are performed.Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
The following sections detail the text files necessary for the Receiving Calendar External Load process:
ext_receiving_calendar.dat
ext_receiving_cal_exc.dat
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Receiving Calendar | Days on which a destination is open to receive deliveries |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_receiving_calendar_in.sh | ext_receiving_calendar.xml | Daily |
| RETL | ext_receiving_calendar_in.sh | ext_receiving_calendar.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | RECEIVING_CALENDAR |
| Source Object Name | ext_receiving_calendar.dat and ext_receiving_cal_exc.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
Table 12-6 Source for Regular Load
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
|
1 |
DESTINATION_TYPE |
Store or Warehouse |
String |
1 |
1 |
Mandatory S/W |
S |
|
2 |
DESTINATION_CODE |
Store or Warehouse Code, already mapped in AIP RPAS |
String |
2 |
20 |
Mandatory and must already exist in AIP |
7777 |
|
3 |
SKU_TYPE_CODE |
Retailer's SKU Type identifier |
String |
22 |
20 |
Mandatory and must already exist in AIP |
2000 |
|
4 |
DAY_OF_WEEK |
Valid Integer Values from 1 to 7 |
Integer |
42 |
1 |
Mandatory and must already exist in AIP |
4 |
|
5 |
RECEIVING_INDICATOR |
Indicates if the destination can receive deliveries on the day of week |
Integer |
43 |
1 |
Mandatory must be Y / N |
Y |
|
6 |
START_DATE |
Effective Date YYYYMMDD |
Date |
44 |
8 |
Optional |
20121030 |
|
7 |
END_DATE |
To Date YYYYMMDD |
Date |
52 |
8 |
Optional |
20121101 |
|
Note: Validation for existence of seven records for one combination of destination_type, destination_code,sku_type_code and start_date in the source is done.The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_receiving_calendar.dat and ext_receiving_cal_exc.dat data file format (fixed width 59):
12345678901234567890123456789012345678901234567890123456789 W2000 0 3Y2012103020121101
Table 12-7 Source for Exception Load
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
|
1 |
DESTINATION_TYPE |
Store or Warehouse |
String |
1 |
1 |
Mandatory S/W |
S |
|
2 |
DESTINATION_CODE |
Store or Warehouse Code, already mapped in AIP RPAS |
String |
2 |
20 |
Mandatory and must already exist in AIP |
7777 |
|
3 |
SKU_TYPE_CODE |
Retailer's SKU Type identifier |
String |
22 |
20 |
Mandatory and must already exist in AIP |
2000 |
|
4 |
RECEIVING_INDICATOR |
Indicates if the destination can receive deliveries on the day of week |
Integer |
42 |
1 |
Mandatory must be Y / N |
Y |
|
5 |
EXCEPTION_DATE |
Date of exception Receiving Calendar value YYYYMMDD |
Date |
43 |
8 |
Mandatory |
20121030 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_pallet_multiple.dat data file format (fixed width 50):
12345678901234567890123456789012345678901234567890 W2000 0 Y20121030
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | RECEIVING_CALENDAR.destination_type | Store or Warehouse (S / W) | VARCHAR2(1) | N |
| 2 | RECEIVING_CALENDAR.product_type_id | Unique AIP Database identifier for Product Type | NUMBER(12) | N |
| 3 | RECEIVING_CALENDAR.destination_id | Unique AIP Database Identifier for Source Vendor or Warehouse | NUMBER(12) | N |
| 4 | RECEIVING_CALENDAR.start_date | Start Date | DATE | N |
| 5 | RECEIVING_CALENDAR.end_date | End date | DATE | N |
| 6 | RECEIVING_CALENDAR.receiving_pattern | String Constituting Receiving Indicators for a week | VARCHAR2(7) | N |
| 7 | RECEIVING_CALENDAR.is_exception | Y / N | VARCHAR2(1) | N |
| 8 | RECEIVING_CALENDAR.timestamp | TIMESTAMP | NUMBER(38) | N |
Special Processing
Mappings to internal database identifiers: stocking_point_id / store_id and product_type_id are performed.
Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
The following sections detail the text file necessary for the Order Group Assignment External Load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Order Group Assignment | New Order Group Assignments |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_order_group_assignment_in.sh | ext_order_group_assignment.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | ORDER_GROUP_ASSIGNMENT |
| Source Object Name | ext_order_group_assignment.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | SOURCE_TYPE | Source Location Type – V for Vendor, W for Warehouse | String | 1 | 1 | Mandatory V/W | V |
| 2 | SOURCE_CODE | Supplier Code or Source Warehouse | String | 2 | 20 | Mandatory and must already exist in AIP. No V or W prefix | 10000 |
| 3 | COMMODITY_CODE | Unique identifier for the product (item) | String | 22 | 20 | Mandatory and must already exist in AIP | 400000 |
| 4 | WAREHOUSE_CODE | Unique Identifier for the Destination Warehouse with any AIP prefixes removed | String | 42 | 20 | Mandatory and must already exist in AIP. No W prefix. | 2000 |
| 5 | ORDER_CYCLE_CODE | Order cycle code that must be either already loaded or already existing in AIP-Oracle | String | 62 | 20 | Mandatory | OC12 |
| 6 | START_DATE | Effective Date YYYYMMDD | Date | 82 | 8 | Optional | 20121030 |
| 7 | END_DATE | To Date YYYYMMDD | Date | 90 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_order_group_assignment.dat data file format (fixed width 97):
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567 V10000 400000 2000 OC12 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | ORDER_GROUP_ASSIGNMENT.order_group_id | Unique identifier for internal logical construct in AIP. This is derived using order_cycle_code and existing data in order_group table. | NUMBER(12) | N |
| 2 | ORDER_GROUP_ASSIGNMENT.source_id | Unique AIP Database Identifier for Source Vendor or Warehouse | NUMBER(12) | N |
| 3 | ORDER_GROUP_ASSIGNMENT.source_type | Source Type – V for Vendor, W for Warehouse | VARCHAR2(1) | N |
| 4 | ORDER_GROUP_ASSIGNMENT.demand_group_id | Unique identifier for internal logical construct in AIP. This is constructed using commodity_code existing data in dmg_assignment table. | NUMBER(12) | N |
| 5 | ORDER_GROUP_ASSIGNMENT.stocking_point_id | Unique AIP Database Identifier for Destination Warehouse Chamber | NUMBER(12) | N |
| 6 | ORDER_GROUP_ASSIGNMENT.start_date | Effective From Date | Date | N |
| 7 | ORDER_GROUP_ASSIGNMENT.end_date | Effective To Date | Date | N |
| 8 | ORDER_GROUP_ASSIGNMENT.timestamp | Timestamp | NUMBER | N |
Special Processing
Mappings to internal database identifiers: stocking_point_id, source_id and commodity_id are performed.
Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
Database External Load Parameters
In addition to the load parameters common to all of the external loads, the following parameter (also stored in Table 5-4, "Configuration Parameters Contained in the SYSTEM_PARAMETERS Database Table") can be used to affect the behavior of the Order Group Assignment load:
AUTO_CREATION_OF_ORDER_GROUPS
Parameter set to N indicates the Order Group Assignment data would be expected in a data load and no automation occurs
Parameter set to Y indicates the Order Group Assignment data would still be loaded if a file was made available but automation will also occur (even if data is already loaded)
The following sections detail the text file necessary for the Order Multiple External Load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Order Multiple | New Order Multiples |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_order_multiple_in.sh | ext_order_multiple.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | ORDER_MULTIPLE |
| Source Object Name | ext_order_multiple.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | SOURCE_CODE | Supplier Code or Source Warehouse | String | 1 | 20 | Mandatory and must already exist in AIP. No V or W prefix | 10000 |
| 2 | SOURCE_TYPE | Source Location Type – V for Vendor, W for Warehouse | String | 21 | 1 | Mandatory V/W | V |
| 3 | WAREHOUSE | Unique Identifier for the Destination Warehouse with any AIP prefixes removed | String | 22 | 20 | Mandatory and must already exist in AIP. No W prefix. | 2000 |
| 4 | SKU | Unique identifier for the product (item) | String | 42 | 20 | Mandatory. Can be either a pack item or a sellable component item | 400000 |
| 5 | PACK_SIZE | Pack Size for product | Integer | 62 | 4 | Mandatory | 6 |
| 6 | ORDER_MULTIPLE | Multiple of the number of whole packs that must be ordered | Integer | 66 | 8 | Mandatory | 2 |
| 7 | START_DATE | Effective Date YYYYMMDD | Date | 74 | 8 | Optional | 20121030 |
| 8 | END_DATE | To Date YYYYMMDD | Date | 82 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_order_multiple.dat data file format (fixed width 89):
12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789 10000 V2000 400000 6 2 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | ORDER_MULTIPLE.stocking_point_id | Unique AIP Database Identifier for Destination Warehouse | NUMBER(12) | N |
| 2 | ORDER_MULTIPLE.source_id | Unique AIP Database Identifier for Source Vendor or Warehouse | NUMBER(12) | N |
| 3 | ORDER_MULTIPLE.source_type | Source Type – V for Vendor, W for Warehouse | VARCHAR2(1) | N |
| 4 | ORDER_MULTIPLE.commodity_id | Unique identifier for the product | NUMBER(10) | N |
| 5 | ORDER_MULTIPLE.pack_size | Pack Size for product | NUMBER(4) | N |
| 6 | ORDER_MULTIPLE.order_multiple | Multiple of the number of whole packs that must be ordered | NUMBER(8) | N |
| 7 | ORDER_MULTIPLE.start_date | Effective Date YYYYMMDD | Date | N |
| 8 | ORDER_MULTIPLE.end_date | To Date YYYYMMDD | Date | N |
Special Processing
Mappings to internal database identifiers: stocking_point_id, source_id and commodity_id are performed.
Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
The incoming SKU (pack item or sellable component item) is mapped to the correct AIP SKU.
Database External Load Parameters
In addition to the load parameters common to all of the external loads, the following parameter (also stored in Table 5-4, "Configuration Parameters Contained in the SYSTEM_PARAMETERS Database Table") can be used to affect the behavior of the Order Multiple load:
AUTO_ASSIGN_ORDER_MULTIPLES
Parameter set to N indicates the Order Multiple data would be expected in a data load and no automation occurs
Parameter set to Y indicates the Order Multiple data would still be loaded if a file was made available but automation will also occur (even if data is already loaded)
The following sections detail the text file necessary for the Pallet Multiple External Load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Pallet Multiple | New Pallet Multiples |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_pallet_multiple_in.sh | ext_pallet_multiple.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | PALLET_MULTIPLE |
| Source Object Name | ext_pallet_multiple.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | SOURCE_CODE | Supplier Code or Source Warehouse | String | 1 | 20 | Mandatory and must already exist in AIP | |
| 2 | SOURCE_TYPE | Source Location Type – V for Vendor, W for Warehouse | String | 21 | 1 | Mandatory V/W | V |
| 3 | WAREHOUSE | Unique Identifier for the Destination Warehouse with any AIP prefixes removed | String | 22 | 20 | Mandatory and must already exist in AIP | 2000 |
| 4 | SKU | Unique identifier for the product (item) | String | 42 | 20 | Mandatory. Can be either a pack item or a sellable component item | 400000 |
| 5 | PACK_SIZE | Pack Size for product | Integer | 62 | 4 | Mandatory | 6 |
| 6 | PALLET_MULTIPLE | Number of whole packs (cases) that fit on one pallet | Integer | 66 | 8 | Mandatory | 2 |
| 7 | START_DATE | Effective Date YYYYMMDD | Date | 74 | 8 | Optional | 20121030 |
| 8 | END_DATE | To Date YYYYMMDD | Date | 82 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_pallet_multiple.dat data file format (fixed width 89):
12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789 10000 V2000 400000 6 2 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | PALLET_MULTIPLE.stocking_point_id | Unique AIP Database Identifier for Destination Warehouse | NUMBER(12) | N |
| 2 | PALLET_MULTIPLE.source_id | Unique AIP Database Identifier for Source Vendor or Warehouse | NUMBER(12) | N |
| 3 | PALLET _MULTIPLE.source_type | Source Type – V for Vendor, W for Warehouse | VARCHAR2(1) | N |
| 4 | PALLET_MULTIPLE.commodity_id | Unique identifier for the product | NUMBER(10) | N |
| 5 | PALLET_MULTIPLE.pack_size | Pack Size for product | NUMBER(4) | N |
| 6 | PALLET_MULTIPLE.pallet_multiple | Multiple of the number of whole packs in one pallet | NUMBER(8) | N |
| 7 | PALLET_MULTIPLE.start_date | Effective Date YYYYMMDD | Date | N |
| 8 | PALLET_MULTIPLE.end_date | To Date YYYYMMDD | Date | N |
Special Processing
Mappings to internal database identifiers: stocking_point_id, source_id and commodity_id are performed.
Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
The incoming SKU (pack item or sellable component item) is mapped to the correct AIP SKU.
Database External Load Parameters
In addition to the load parameters common to all of the external loads, the following parameter (also stored in Table 5-4, "Configuration Parameters Contained in the SYSTEM_PARAMETERS Database Table") can be used to affect the behavior of the Pallet Multiple load:
AUTO_ASSIGN_PALLET_MULT –
Parameter set to N indicates the Pallet Multiple data would be expected in a data load and no automation occurs
Parameter set to Y indicates the Pallet Multiple data would still be loaded if a file was made available but automation will also occur (even if data is already loaded)
The following sections detail the text file necessary for the Warehouse Orderable Unit External Load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Warehouse Orderable Unit | New Warehouse Orderable Units |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_warehouse_orderable_unit_in.sh | ext_warehouse_orderable_unit.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | WAREHOUSE_ORDERABLE_UNIT |
| Source Object Name | ext_warehouse_orderable_unit.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | SOURCE_TYPE | Source Location Type – V for Vendor, W for Warehouse | String | 1 | 1 | Mandatory V/W | V |
| 2 | SOURCE_CODE | Supplier Code or Source Warehouse | String | 2 | 20 | Mandatory and must already exist in AIP. No V or W prefix | 10000 |
| 3 | COMMODITY_CODE | SKU | String | 20 | 20 | Mandatory. Can be either a pack item or a sellable component item | 400000 |
| 4 | WAREHOUSE_CODE | Unique Identifier for the Destination Warehouse with any AIP prefixes removed | String | 42 | 20 | Mandatory and must already exist in AIP. No W prefix | 2000 |
| 5 | PACK_SIZE | Value of the warehouse orderable unit | Integer | 62 | 4 | Mandatory. Must be a valid pack size for the SKU | 6 |
| 6 | START_DATE | Effective Date YYYYMMDD | Date | 66 | 8 | Optional | 20121030 |
| 7 | END_DATE | To Date YYYYMMDD | Date | 74 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_warehouse_orderable_unit.dat data file format (fixed width 81):
123456789012345678901234567890123456789012345678901234567890123456789012345678901 V10000 400000 2000 6 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | WAREHOUSE_ORDERABLE_UNIT.stocking_point_id | Unique AIP Database Identifier for Destination Warehouse | NUMBER(12) | N |
| 2 | WAREHOUSE_ORDERABLE_UNIT.source_id | Unique AIP Database Identifier for Source Vendor or Warehouse | NUMBER(12) | N |
| 3 | WAREHOUSE_ORDERABLE_UNIT.source_type | Source Type – V for Vendor, W for Warehouse | VARCHAR2(1) | N |
| 4 | WAREHOUSE_ORDERABLE_UNIT.demand_group_id | Unique identifier for internal logical construct in AIP. This is constructed using commodity_id and pack_size fields and the mapping data in dmg_assignment table | NUMBER(12) | N |
| 5 | WAREHOUSE_ORDERABLE_UNIT.start_date | Effective From Date | Date | N |
| 6 | WAREHOUSE_ORDERABLE_UNIT.end_date | Effective To Date | Date | N |
| 7 | WAREHOUSE_ORDERABLE_UNIT.commodity_id | Unique AIP Database identifier for the product | NUMBER(10) | N |
| 8 | WAREHOUSE_ORDERABLE_UNIT.pack_size | Pack Size representing warehouse orderable unit | NUMBER(4) | N |
| 9 | WAREHOUSE_ORDERABLE_UNIT.timestamp | Timestamp | NUMBER | N |
Special Processing
Mappings to internal database identifiers: stocking_point_id, source_id and commodity_id are performed.
The incoming commodity_code (pack item or sellable component item) is mapped to the correct AIP SKU.
Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
Database External Load Parameters
In addition to the load parameters common to all of the external loads, the following parameter (also stored in Table 5-4, "Configuration Parameters Contained in the SYSTEM_PARAMETERS Database Table") can be used to affect the behavior of the Warehouse Orderable Unit load:
AUTO_ASSIGN_ORDERABLE_UNITS
Parameter set to N indicates the Warehouse Orderable Unit data would be expected in a data load and no automation occurs.
Parameter set to Y indicates the Warehouse Orderable Unit data would still be loaded if a file was made available but automation will also occur (even if data is already loaded).
The following sections detail the text file necessary for ranging SKU-pack_sizes to warehouses from an external load.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Warehouse Ranging | Maps sku-pack_sizes to warehouses |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_wh_ranging_in.sh | ext_wh_ranging.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | RANGED_COMMODITY_PACK_SIZE |
| Source Object Name | ext_wh_ranging.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | SKU | Unique identifier for the product (item) | String | 1 | 20 | Mandatory and must already exist in AIP | Client specific |
| 2 | PACK_SIZE | Pack Size for product | Integer | 21 | 4 | Mandatory | Whole number up to 4 digits |
| 3 | WAREHOUSE | Unique Identifier for the Destination Warehouse with any AIP prefixes removed | String | 25 | 20 | Mandatory and must already exist in AIP | Client specific |
Example of ext_wh_ranging.dat data file format (fixed width 44):
123456789012345678901234567890123456789012345678901234567890123456789012345678 SKU123 9999WH1001
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | RANGED_COMMODITY_PACK_SIZE.stocking_point_id | Internal AIP Database identifier for destination warehouse | NUMBER(12) | N |
| 2 | RANGED_COMMODITY_PACK_SIZE.commodity_id | Internal AIP Database identifier for the SKU | NUMBER(10) | N |
| 3 | RANGED_COMMODITY_PACK_SIZE.pack_size | Pack Size of commodity | NUMBER(4) | N |
| 4 | RANGED_COMMODITY_PACK_SIZE.is_seasonal | Y or N valued and assigned an N for records found in data file | VARCHAR2(1) | N |
| 5 | RANGED_COMMODITY_PACK_SIZE.ranging_status | Assigned an internal AIP representation of ranging status translating to any of the following values: Profile Ranged, Exception Ranged, Pending Deranged or Deranged.
All records from data file are assigned an Exception Ranged status if they are new or were previously set to Pending Deranged or Deranged. |
NUMBER(1) | N |
Special Processing
Mappings to internal database identifiers: stocking_point_id and commodity_id are performed.
The load also checks if the warehouse has chambers that can store the SKU/product type. An alert is created if the product type is not support and the record with such error does not get ranged.
Database External Load Parameters
No additional parameters on top of load parameters common to all of the external loads.
The following sections detail the text file necessary for the Direct Store Format Pack Size External Load process:
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Direct Store Format Pack Size | New Direct Store Format Pack Sizes |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_dir_store_frmt_pksz_in.sh | ext_dir_store_frmt_pksz.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | DIRECT_STORE_FORMAT_PACK_SIZE |
| Source Object Name | ext_direct_store_format_pack_size.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Merge |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | STORE_FORMAT_CODE | Store Format Code | String | 1 | 20 | Mandatory and must already exist in AIP. | 10 |
| 2 | COMMODITY_CODE | SKU | String | 21 | 20 | Mandatory. Can be either a pack item or a sellable component item. | 400000 |
| 3 | PACK_SIZE | Pack Size for product | Integer | 41 | 4 | Mandatory | 6 |
| 4 | SUPPLIER_CODE | Supplier/Vendor | String | 45 | 20 | Mandatory and must already exist in AIP. No V prefix. | 30000 |
| 5 | START_DATE | Effective Date YYYYMMDD | Date | 65 | 8 | Optional | 20121030 |
| 6 | END_DATE | To Date | YYYYMMDD | 73 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_direct_store_pack_size.dat data file format (fixed width 80):
12345678901234567890123456789012345678901234567890123456789012345678901234567890 10 400000 6 30000 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | DIRECT_STORE_FORMAT_PACK_SIZE.store_format_id | Unique AIP Database Identifier for Store Format | NUMBER(12) | N |
| 2 | DIRECT_STORE_FORMAT_PACK_SIZE.commodity_id | Unique AIP Database identifier for the product | NUMBER(10) | N |
| 3 | DIRECT_STORE_FORMAT_PACK_SIZE.pack_size | Pack Size for product | NUMBER(4) | N |
| 4 | DIRECT_STORE_FORMAT_PACK_SIZE.supplier_id | Unique AIP Database Identifier for Supplier/Vendor | NUMBER(12) | N |
| 5 | DIRECT_STORE_FORMAT_PACK_SIZE.start_date | Effective Date YYYYMMDD | Date | Y |
| 6 | DIRECT_STORE_FORMAT_PACK_SIZE.end_date | To Date YYYYMMDD | Date | Y |
Special Processing
Mappings to internal database identifiers: store_format_id, commodity_id and supplier_id are performed.
The incoming commodity_code (pack item or sellable component item) is mapped to the correct AIP SKU.
Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
The following sections detail the text file necessary for the Direct Store Pack Size External Load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Direct Store Pack Size | New Direct Store Pack Sizes |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_dir_store_pksz_in.sh | ext_dir_store_pksz.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | DIRECT_STORE_PACK_SIZE |
| Source Object Name | ext_direct_store_pack_size.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Merge |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | STORE_CODE | Store Code | String | 1 | 20 | Mandatory and must already exist in AIP. No S prefix | 10000 |
| 2 | COMMODITY_CODE | SKU | String | 21 | 20 | Mandatory. Can be either a pack item or a sellable component item | 400000 |
| 3 | PACK_SIZE | Pack Size for product | Integer | 41 | 4 | Mandatory | 6 |
| 4 | SUPPLIER_CODE | Supplier/Vendor | String | 45 | 20 | Mandatory and must already exist in AIP. No V prefix. | 30000 |
| 5 | START_DATE | Effective Date YYYYMMDD | Date | 65 | 8 | Optional | 20121030 |
| 6 | END_DATE | To Date YYYYMMDD | Date | 73 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_direct_store_pack_size.dat data file format (fixed width 80):
12345678901234567890123456789012345678901234567890123456789012345678901234567890 10000 400000 6 30000 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | DIRECT_STORE_PACK_SIZE.store_id | Unique AIP Database Identifier for Store | NUMBER(12) | N |
| 2 | DIRECT_STORE_PACK_SIZE.commodity_id | Unique AIP Database identifier for the product | NUMBER(10) | N |
| 3 | DIRECT_STORE_PACK_SIZE.pack_size | Pack Size for product | NUMBER(4) | N |
| 4 | DIRECT_STORE_PACK_SIZE.supplier_id | Unique AIP Database Identifier for Supplier/Vendor | NUMBER(12) | N |
| 5 | DIRECT_STORE_PACK_SIZE.start_date | Effective Date YYYYMMDD | Date | Y |
| 6 | DIRECT_STORE_PACK_SIZE.end_date | To Date YYYYMMDD | Date | Y |
Special Processing
Mappings to internal database identifiers: store_id, commodity_id and supplier_id are performed.The incoming commodity_code (pack item or sellable component item) are mapped to the correct AIP SKU.Default values of v_date and System High Date are provided for null values of start_date and end_date respectively
The following sections detail the text file necessary for the Store Format Pack Size External Load process:
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Store Format Pack Size | New Store Format Pack Sizes |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_store_frmt_pksz_in.sh | ext_store_frmt_pksz.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | STORE_FORMAT_PACK_SIZE |
| Source Object Name | ext_store_format_pack_size.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | STORE_FORMAT_CODE | Store Format Code | String | 1 | 20 | Mandatory and must already exist in AIP. | 10 |
| 2 | COMMODITY_CODE | SKU | String | 21 | 20 | Mandatory. Can be either a pack item or a sellable component item. | 400000 |
| 3 | PACK_SIZE | Pack Size for product | Integer | 41 | 4 | Mandatory | 6 |
| 4 | STOCKING_POINT_NUMBER | Warehouse | String | 45 | 20 | Mandatory and must already exist in AIP. No W prefix | 20000 |
| 5 | START_DATE | Effective Date YYYYMMDD | Date | 65 | 8 | Optional | 20121030 |
| 6 | END_DATE | To Date YYYYMMDD | Date | 73 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_store_pack_size.dat data file format (fixed width 80):
12345678901234567890123456789012345678901234567890123456789012345678901234567890 10 400000 6 20000 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | STORE_FORMAT_PACK_SIZE.store_format_id | Unique AIP Database Identifier for Store Format | NUMBER(12) | N |
| 2 | STORE_FORMAT_PACK_SIZE.commodity_id | Unique AIP Database identifier for the product | NUMBER(10) | N |
| 3 | STORE_FORMAT_PACK_SIZE.pack_size | Pack Size for product | NUMBER(4) | N |
| 4 | STORE_FORMAT_PACK_SIZE.stocking_point_id | Unique AIP Database Identifier for Warehouse | NUMBER(12) | N |
| 5 | STORE_FORMAT_PACK_SIZE.start_date | Effective Date YYYYMMDD | Date | Y |
| 6 | STORE_FORMAT_PACK_SIZE.end_date | To Date YYYYMMDD | Date | Y |
Special Processing
Mappings to internal database identifiers: store_format_id, commodity_id and stocking_point_id are performed.The incoming commodity_code (pack item or sellable component item) is mapped to the correct AIP SKU.Default values of v_date and System High Date are provided for null values of start_date and end_date respectively.
The following sections detail the text file necessary for the Store Pack Size External Load process:
ext_store_pack_size.dat
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Store Pack Size | New Store Pack Sizes |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_store_pksz_in.sh | ext_store_pksz.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | STORE_PACK_SIZE |
| Source Object Name | ext_store_pack_size.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Merge |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | STORE_CODE | Store Code | String | 1 | 20 | Mandatory and must already exist in AIP. No S prefix | 10000 |
| 2 | COMMODITY_CODE | SKU | String | 21 | 20 | Mandatory and must already exist in AIP. No S prefix | 10000 |
| 3 | PACK_SIZE | Pack Size for product | Integer | 41 | 4 | Mandatory | 6 |
| 4 | STOCKING_POINT_NUMBER | Warehouse | String | 45 | 20 | Mandatory and must already exist in AIP. No W prefix | 20000 |
| 5 | START_DATE | Effective Date YYYYMMDD | Date | 65 | 8 | Optional | 20121030 |
| 6 | END_DATE | To Date YYYYMMDD | Date | 73 | 8 | Optional | 20121101 |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system used to generate the data feed. |
Example of ext_store_pack_size.dat data file format (fixed width 80):
12345678901234567890123456789012345678901234567890123456789012345678901234567890 10000 400000 6 20000 2012103020121101
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | STORE_PACK_SIZE.store_id | Unique AIP Database Identifier for Store | NUMBER(12) | N |
| 2 | STORE_PACK_SIZE.commodity_id | Unique AIP Database identifier for the product | NUMBER(10) | N |
| 3 | STORE_PACK_SIZE.pack_size | Pack Size for product | NUMBER(4) | N |
| 4 | STORE_PACK_SIZE.stocking_point_id | Unique AIP Database Identifier for Warehouse | NUMBER(12) | N |
| 5 | STORE_PACK_SIZE.start_date | Effective Date YYYYMMDD | Date | Y |
| 6 | STORE_PACK_SIZE.end_date | To Date YYYYMMDD | Date | Y |
Special Processing
Mappings to internal database identifiers: store_id, commodity_id and stocking_point_id are performed.
The incoming commodity_code (pack item or sellable component item) are mapped to the correct AIP SKU.
Default values of v_date and System High Date are provided for null values of start_date and end_date respectively
The following sections detail the text file necessary for the external store source load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Store sources | All valid store-product sources |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_store_source_in.sh | ext_store_source.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | User-Determined/Generated | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | STORE_SOURCE |
| Source Object Name | ext_store_source.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | STORE | Store identifier | String | 1 | 20 | Mandatory Exists on AIP | Client specific |
| 2 | SKU | SKU (product) identifier | String | 21 | 20 | Mandatory Exists on AIP | Client specific |
| 3 | SOURCE_TYPE | Indicates the type of source | String | 41 | 1 | Mandatory Valid values are V for supplier or W for warehouse | Upper-case V or W only |
| 4 | STORE_SOURCE | Supplier or warehouse identifier | String | 42 | 20 | Exists in AIP and not expected to include any AIP specific pre/post fixes | Client specific |
| 5 | START_DATE | Start date when SKU can be provided by source | Date | 62 | 8 | Optional | YYYYMMDD |
| 6 | END_DATE | Last date when SKU can be provided by source | Date | 70 | 8 | Optional | YYYYMMDD |
| 7 | DAY_OF_WEEK | Numeric day of week representation | Number | 78 | 1 | Optional Valid values:
[1,2,3,4,5,6,7] 1 digit number only |
1 digit number only |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system |
Example of ext_store_source.dat data file format (fixed width 78):
123456789012345678901234567890123456789012345678901234567890123456789012345678 STORE1000 SKU123 VSUPPLIER1 20120101201202017
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | STORE_SOURCE. STORE_ID | Internal AIP Database identifier for a store | NUMBER(12) | N |
| 2 | STORE_SOURCE.STOCKING_POINT_ID | Internal AIP Database Identifier for Warehouse. Only populated if incoming source_type is W | NUMBER(12) | Y |
| 3 | STORE_SOURCE.SUPPLIER_ID | Internal AIP Database Identifier for Vendor Only populated if incoming source_type is V | NUMBER(10) | Y |
| 4 | STORE_SOURCE.COMMODITY_ID | Internal AIP Database identifier for the product | NUMBER(10) | Y |
| 5 | STORE_SOURCE.START_DATE | Start date when commodity can be provided by either the stocking point_id or supplier_id | Date | Y |
| 6 | STORE_SOURCE.END_DATE | Last date when commodity can be provided by either the stocking point_id or supplier_id | Date | Y |
| 7 | STORE_SOURCE.DAY_OF_WEEK | Internal AIP Database day of week identifier | NUMBER(1) | Y |
Special Processing
Mappings to internal database identifiers: stocking_point_id, store_id, supplier_id and commodity_id are performed.
Default values of v_date and System High Date is provided for null values of start_date and end_date respectively.
Database External Load Parameters
INTERFACE_PARAMETERS.last_day_of_week is used to determine internal AIP Database value for STORE_SOURCE.day_of_week if it comes with the data file.
In addition to the load parameters common to all of the external loads, the following environment variable (also stored in Table 4-1, "Environment Variables for aip_env_rpas.sh") controls the AIP-RPAS automation of store source:
AUTOMATIC_STORE_SOURCE_ASSIGNMENT
The default value is ON.
Environment variable set to OFF indicates the store source data would be expected in a data load and no automation occurs.
Environment variable set to ON indicates the store source data would still be loaded if a file was made available but automation will also occur (even if data is already loaded).
The following sections detail the text file necessary for the external SKU promotion load process.
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Store sources | All valid store-product sources |
External Load Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ext_sku_promotion_in.sh | ext_sku_promotion.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | RMS | Target Object Type | Database Table |
| Source Object Type | Fixed Width Text File | Target Object Name | I_SKU_PROMOTION |
| Source Object Name | ext_sku_promotion.dat | Target Object Database | AIP |
| Required/Optional | Optional | Target Refresh Type | Full Refresh |
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Data Field Name | Source Field Description | Field Data Type | Field Start Position | Maximum Field Length | Condition | Format |
|---|---|---|---|---|---|---|---|
| 1 | SKU_NUMBER | Promotional (New) SKU Number | CHAR | 1 | 20 | Mandatory Exists on AIP | ”SKU123456 ” |
| 2 | STORE_CODE | Internal AIP Database identifier for the store location | CHAR | 21 | 20 | Mandatory Exists on AIP | ”987654 ” |
| 3 | START_DATE | Date indicating when a promotion on the SKU/Store begins. | DATE | 41 | 8 | Mandatory Exists in AIP Calendar | YYYYMMDD |
| 4 | END_DATE | Date indicating when a promotion on the SKU/Store ends. | DATE | 50 | 8 | Mandatory Exists in AIP Calendar | YYYYMMDD |
|
Note: The expectation is that date validation, other than formatting (for example, START_DATE before END_DATE), is set on the source system |
Example of ext_sku_promotion.dat data file format (fixed width 57):
123456789012345678901234567890123456789012345678901234567 123456789 S98765 20120101201202017
Field Level Mapping - Target
| # |
Target Field Name | Target Field Description | Field Data Type | NULL |
|---|---|---|---|---|
| 1 | SKU_NUMBER | Promotional (New) SKU Number | VARCHAR2(20) | N |
| 2 | STORE_CODE | Internal AIP Database identifier for the store location. | VARCHAR2(20) | N |
| 3 | START_DATE | Date indicating when a promotion on the SKU/Store begins. | Date | N |
| 4 | END_DATE | Date indicating when a promotion on the SKU/Store ends. | Date | N |
