| Oracle® Retail Xstore Suite 18.0/Merchandising 16.0.2 Implementation Guide Release 18.0 E99047-05 |
|
 Previous |
| Oracle® Retail Xstore Suite 18.0/Merchandising 16.0.2 Implementation Guide Release 18.0 E99047-05 |
|
Previous |
This appendix describes the mapping from the RMS and RPM flat file format to the Xstore database format. Details are provided for the following mappings:
Table B-1 describes the RMS Diff Group Detail mapping.
Table B-1 RMS Diff Group Detail Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always DIFFGRPDTL. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: DIFFGRPDTLCRE - Creation of diff group group header information. DIFFGRPDTLMOD - Modification of diff group header information. DIFFGRPDTLDEL - Deletion of diff group header information. Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
2 |
DiffGroupId |
This field holds the ID of the diff group. Data will always be present in this field. |
Character |
10 |
rms_diff_group_detail |
DIFF_GROUP_ID |
VARCHAR2(10 CHAR) |
NA |
|
|
3 |
DiffId |
This field holds a unique number ID for the diff. Data will always be present in this field. |
Character |
10 |
rms_diff_group_detail |
DIFF_ID |
VARCHAR2(10 CHAR) |
NA |
|
|
4 |
DisplaySeq |
Optional sequence to describe the order in which diffs within the diff group should be displayed in user interfaces. Data is optional in this field. |
Character |
4 |
rms_diff_group_detail |
DISPLAY_SEQ |
NUMBER(4) |
NA |
|
|
NA |
NA |
NA |
NA |
rms_diff_group_detail |
CREATE_DATE |
TIMESTAMP(6) |
now() |
NA |
|
|
NA |
NA |
NA |
NA |
rms_diff_group_detail |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
NA |
|
Table B-2 describes the RMS Diff Group Header mapping.
Table B-2 RMS Diff Group Header Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always DIFFGRPHDR. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: DIFFGRPHDRCRE - Creation of diff group group header information. DIFFGRPHDRMOD - Modification of diff group header information. DIFFGRPHDRDEL - Deletion of diff group header information. Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
2 |
DiffGroupId |
This field holds a unique number ID for the differentiator group. As primary ID, DiffGroupId cannot be modified. Data will always be present in this field. |
Character |
10 |
rms_diff_group_head |
DIFF_GROUP_ID |
VARCHAR2(10 CHAR) |
NA |
|
|
3 |
DiffGroupDesc |
Description of the differentiator group (for example: Men's Shirt Sizes, Women's Shoe Sizes, Girls Dress Sizes, Shower Gel Scents, Yogurt Flavors, and so on). Data will always be present in this field in the DIFFGRPHDRCRE and DIFFGRPHDRMOD records. |
Character |
120 |
rms_diff_group_head |
DIFF_GROUP_DESC |
VARCHAR2(120 CHAR) |
NA |
|
|
4 |
DiffTypeId |
This field holds a value of the types of differentiators contained in this differentiator group including, but not limited to: S - size C - color F - flavor E - scent P - pattern Data will always be present in this field in the DIFFGRPHDRCRE and DIFFGRPHDRMOD records. |
Character |
6 |
rms_diff_group_head |
DIFF_TYPE |
VARCHAR2(6 CHAR) |
NA |
|
|
5 |
DiffTypeDesc |
Contains the description of the differentiator type. Data will always be present in this field in the DIFFGRPHDRCRE and DIFFGRPHDRMOD records. |
Character |
120 |
NA |
NA |
NA |
Ignored. It is already captured in the diff id tab. |
|
|
NA |
NA |
NA |
NA |
rms_diff_group_head |
CREATE_DATE |
TIMESTAMP(6) |
NA |
||
|
NA |
NA |
NA |
NA |
rms_diff_group_head |
UPDATE_DATE |
TIMESTAMP(6) |
NA |
||
Table B-3 describes the RMS Diffs mapping.
Table B-3 RMS Diffs Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always DIFFS. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: DIFFCRE - Creation of diff information. DIFFMOD - Modification of diff information. DIFFDEL - Deletion of diff information. Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
2 |
DiffId |
Contains the unique ID of the diff. Data will always be present in this field. |
Character |
10 |
rms_diff_ids |
DIFF_ID |
VARCHAR2(10 CHAR) |
Also used to populate rms_diff_group_detail for the default Diff Group membership. |
|
|
3 |
DiffDesc |
Contains the text description of the diff. Data will always exist in this field for DIFFCRE and DIFFMOD. |
Character |
120 |
rms_diff_ids |
DIFF_DESC |
VARCHAR2(120 CHAR) |
NA |
|
|
4 |
DiffType |
Contains the type code for the diff. All diffs belong to one and only one type. Data will always exist in this field for DIFFCRE and DIFFMOD. |
Character |
6 |
rms_diff_ids |
DIFF_TYPE |
VARCHAR2(6 CHAR) |
Also used to populate rms_diff_group_head for the default Diff Group. |
|
|
5 |
DiffTypeDesc |
Contains the description of the diff. Data will always exist in this field for DIFFCRE and DIFFMOD. |
Character |
120 |
rms_diff_ids |
DIFF_TYPE_DESC |
VARCHAR2(120 CHAR) |
Also used to populate rms_diff_group_head for the default Diff Group. |
|
|
6 |
IndustryCode |
Can optionally hold the unique code used by industry standards to identify the differentiator. For example, in the US, the National Retail Federation defines a standard Color and Size Codes that gives retailers, vendors, and manufacturers a common language for product color and size identification for EDI purposes. This supplements the information conveyed by UPC codes. For example, mens pants size combination 32x32 has an NRF code number 10492. |
Character |
10 |
NA |
NA |
NA |
Ignored. |
|
|
7 |
IndustrySubgroup |
Can optionally hold a sub-grouping code used by industry standards to further identify the differentiator. For example, in the US, the National Retail Federation uses a subgroup for colors (for example, purple is defined as 500; dark purple represents a range from 501 to 509, medium purple represents a range from 510 to 519, bright purple represents a range from 520 to 529, and so on). |
Character |
10 |
NA |
NA |
NA |
Ignored. |
|
|
NA |
NA |
NA |
NA |
rms_diff_ids |
CREATE_DATE |
TIMESTAMP(6) |
now() |
NA |
|
|
NA |
NA |
NA |
NA |
rms_diff_ids |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
NA |
|
Table B-4 describes the RMS Item Header mapping.
Table B-4 RMS Item Header Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always ITEMS. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULLHDR when the program is run in full mode. In delta mode, valid values are: ITEMHDRCRE ITEMHDRMOD ITEMHDRDEL Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
2 |
Location |
For corporate level files, this field holds the string CORPORATE. In location specific files, this field holds the numeric ID of the store of WH. |
Character |
10 |
itm_item, itm_item_dimension_value, itm_item_dimension_type |
ORG_CODE, ORG_VALUE |
VARCHAR(30) |
"*" |
DimensionValue and DimensionType are only used for Style items. |
|
3 |
Item |
ID of the item. This field will always have data. |
Character |
25 |
itm_item, itm_item_dimension_value, itm_item_dimension_type |
ITEM_ID, DIMENSION_SYSTEM |
VARCHAR(60) |
DIMENSION_SYSTEM is populated with ItemID for Style items. |
|
|
4 |
ItemParent |
ID of the parent of the item. ItemParents can be used as a mechanism to group items together. The ItemParent will also exist as an Item in another row. Data is optional in this field for many items. |
Character |
25 |
itm_item, itm_item_cross_reference |
PARENT_ITEM_ID, ITEM_ID |
VARCHAR(60) |
If the record represents a UPC item, an itm_item_cross_reference record is created. Otherwise, the parent is stored in itm_item.parent_item_id. If a UPC item, ItemParent is set in itm_item_cross_reference.item_id, and the item is stored in itm_item_cross_reference.manufacturer_upc. |
|
|
5 |
ItemGrandparent |
ID of the grandparent of the Item. ItemGrandparents can be used as a mechanism to group items together. The ItemGrandparent will also exist as an Item in another row. Data is optional in this field for many items. |
Character |
25 |
NA |
NA |
NA |
Ignored. |
|
|
6 |
PackInd |
This field indicates if the item is a pack. A pack is a type of item that acts as a collection of other items. Packs have a Y value. Regular items have an N value. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
7 |
SimplePackInd |
This field indicates if the pack item is a simple pack. A simple pack is a collection that consists of multiple of the same item (for example, 10 pack of the same item). Only simple packs have a Y value. Both complex packs (which consist of a mixture of different items) and regular items have an N value. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
8 |
ItemLevel |
Number indicating in which of the three levels the item resides. The item level determines if the item stands alone or if it is part of a family of related items. The concept is best explained with the following typical (although not exhaustive) examples. Staple items generally have a item level = 1. UPCs for staple items generally have an item level = 2 (and the staple item is the UPC's parent item). Fashion styles generally have an item level = 1. Fashion skus generally have an item level = 2. UPCs for fashion skus generally have an item level = 3. Valid values are 1, 2, and 3. This field will always have data. |
Number |
1 |
NA |
NA |
NA |
Used to distinguish Item from Style, and UPC from Item. |
|
|
9 |
TranLevel |
Number indicating which of the three levels of transactions occur for the item's group. The transaction level is the level at which the items inventory is tracked in the system. The transaction level item will be inventoried, counted, transferred, shipped, and so on. Only one level of the hierarchy of an item family may contain transaction level items. The concept is best explained with the following typical (although not exhaustive) examples. Staple items generally have a TranLevel = 1. UPCs for staple items generally have a TranLevel = 1 (inventory transactions occur at the staple sku level; sales of the item roll up to the parent staple sku). Fashion styles generally have a TranLevel = 2 (the style itself is not sold/inventoried). Fashion skus generally have an TranLevel = 2 (the fashion sku is sold/inventoried). UPCs for fashion skus generally have a TranLevel = 2 (the fashion sku is sold/inventoried). |
Number |
1 |
NA |
NA |
NA |
Used to distinguish Item from Style, and UPC from Item. |
|
|
TranLevel (Continued) |
There are some rare cases in vendor-managed inventory where the TranLevel equals 3. Valid values are 1, 2, and 3. This field will always have data. |
||||||||
|
10 |
InventoryInd |
This indicator is used to determine if inventory is held for the item/item family. Inventory is not held (value = N) in some cases, such as: Concession items that are sold by independent in location concessions. Consignment items that are not owned by the retailer; financial and inventory processing occurs after the item is sold to a consumer. Containers sold/returned for deposit. Some items that are transformed for sale. Valid values are Y and N. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
itm_item |
NOT_INVENTORIED_FLAG |
NUMBER(1,0) |
When N, then 1; otherwise 0. |
|
|
11 |
Diff1Level |
This field describes whether the Diff1 information represents a Diff Group or Diff ID. A Diff Group is a collection of possible Diff IDs. When assigned to a parent item, the diffs in the diff group limit the possible diff IDs that can be assigned to a child of the parent item. Valid Values are GROUP and ID. Data is optional in this field for many items. |
Character |
6 |
NA |
NA |
NA |
Used to identify Style Item. When GROUP, DataLoader fetches RMS DIFF Group Details to create Dimension System information. When ID, DataLoader fetches the Default DIFF Group for the Diff1Type. |
|
|
12 |
Diff1Type |
This field contains the type of the Diff1 information. Valid values can be configured by the retailer. Common examples include: C - Color WS - Waist Sizes F - Flavor SC - Scent Note that these examples are not consistent or required. They are presented here simply to help explain the field. Data is optional in this field for many items. |
Character |
6 |
itm_item_dimension_type |
DIMENSION |
VARCHAR2(30 CHAR) |
Only used when Diff1Level is provided. |
|
|
13 |
Diff1 |
This field contains the ID of the Diff1 information. If the Diff1Level is GROUP, this field contains a Diff Group ID. If the Diff1Level is ID, it contains the ID of a diff (a size, color, and so on.) This field is optional. |
Character |
10 |
itm_item |
DIMENSION1 |
VARCHAR2(60 CHAR) |
NA |
|
|
14 |
Diff2Level |
This field describes whether the Diff2 information represents a Diff Group or Diff ID. A Diff Group is a collection of possible Diff IDs. When assigned to a parent item, the diffs in the diff group limit the possible diff IDs that can be assigned to a child of the parent item. Valid values are GROUP and ID. Data is optional in this field for many items. |
Character |
6 |
NA |
NA |
NA |
Used to identify Style Item. When GROUP, DataLoader fetches RMS DIFF Group Details to create Dimension System information. When ID, DataLoader fetches the Default DIFF Group for the Diff2Type. |
|
|
15 |
Diff2Type |
This field contains the type of the Diff2 information. Valid values can be configured by the retailer. Common examples include: C - Color WS - Waist Sizes F - Flavor SC - Scent Note that these examples are not consistent or required. They are presented here simply to help explain the field. Data is optional in this field for many items. |
Character |
6 |
itm_item_dimension_type |
DIMENSION |
VARCHAR2(30 CHAR) |
Only used when Diff2Level is provided. |
|
|
16 |
Diff2 |
This field contains the ID of the Diff2 information. If the Diff1Level is GROUP, this field contains a Diff Group ID. If the Diff1Level is ID, it contains the ID of a diff (a size, color, and so on). Data is optional in this field for many items. |
Character |
10 |
itm_item |
DIMENSION2 |
VARCHAR2(60 CHAR) |
NA |
|
|
17 |
Diff3Level |
This field describes whether the Diff3 information represents a Diff Group or Diff ID. A Diff Group is a collection of possible Diff IDs. When assigned to a parent item, the diffs in the diff group limit the possible diff IDs that can be assigned to a child of the parent item. Valid values are GROUP and ID. Data is optional in this field for many items. |
Character |
6 |
NA |
NA |
NA |
Used to identify Style Item. When GROUP, DataLoader fetches the RMS DIFF Group Details to create the Dimension System information. When ID, DataLoader fetches the Default DIFF Group for the Diff3Type. |
|
|
18 |
Diff3Type |
This field contains the type of the Diff3 information. Valid values can be configured by the retailer. Common examples include: C - Color WS - Waist Sizes F - Flavor SC - Scent Note that these examples are not consistent or required. They are presented here simply to help explain the field. Data is optional in this field for many items. |
Character |
6 |
itm_item_dimension_type |
DIMENSION |
VARCHAR2(30 CHAR) |
Only used when Diff3Level is provided. |
|
|
19 |
Diff3 |
This field contains the ID of the Diff3 information. If the Diff1Level is GROUP, this field contains a Diff Group ID. If the Diff1Level is ID, it contains the ID of a diff (a size, color, and so on). Data is optional in this field for many items. |
Character |
10 |
itm_item |
DIMENSION3 |
VARCHAR2(60 CHAR) |
NA |
|
|
20 |
Diff4Level |
This field describes whether the Diff4 information represents a Diff Group or Diff ID.A Diff Group is a collection of possible Diff IDs. When assigned to a parent item, the diffs in the diff group limit the possible diff IDs that can be assigned to a child of the parent item. Valid values are GROUP and ID. Data is optional in this field for many items. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
21 |
Diff4Type |
This field contains the type of the Diff4 information. Valid values can be configured by the retailer. Common examples include:C - Color WS - Waist Sizes F - Flavor SC - Scent Note that these examples are not consistent or required. They are presented here simply to help explain the field. Data is optional in this field for many items. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
22 |
Diff4 |
This field contains the ID of the Diff4 information. If the Diff1Level is GROUP, this field contains a Diff Group ID. If the Diff1Level is ID, it contains the ID of a diff (a size, color, and so on). Data is optional in this field for many items. |
Character |
10 |
NA |
NA |
NA |
Ignored. |
|
|
23 |
Dept |
Number identifying the department in the merchandise hierarchy to which the item belongs. If the item has a parent, the item's department will be the same as that of its parent. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Number |
4 |
itm_item |
MERCH_LEVEL_2 (or configured level) |
VARCHAR2(60 CHAR) |
D is always appended to the value. The value is used to look up the parent from the loc_org_hierarchy to populate merch_level_1. |
|
|
24 |
Class |
Number identifying the class in the merchandise hierarchy to which the item belongs. If the item has a parent, the item's class will be the same as that of its parent. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
25 |
UniqueClass |
Number uniquely identifying the class node to which the item belongs. Class ID is not unique in the level of the merchandise hierarchy. The combination of Dept/Class is unique, but requires the use of a composite key. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Number |
10 |
itm_item |
MERCH_LEVEL_3 (or configured level) |
VARCHAR2(60 CHAR) |
C is always appended to the value. |
|
|
26 |
Subclass |
Number identifying the subclass in the merchandise hierarchy to which the item belongs. Subclass ID is not unique in the level of the merchandise hierarchy. The combination of Dept/Class/Subclass is unique. If the item has a parent, the item's class will be the same as that of its parent. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
27 |
UniqueSubclass |
Number uniquely identifying the subclass node to which the item belongs. Subclass ID is not unique in the level of the merchandise hierarchy. The combination of Dept/Class/Subclass is unique, but requires the use of a composite key. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records |
Character |
10 |
itm_item |
MERCH_LEVEL_4 (or configured level) |
VARCHAR2(60 CHAR) |
S is always appended to the value. |
|
|
28 |
Status |
Item life cycle status of the item. For this release, this field always contains the character A as only approved items are exported. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
29 |
ItemDesc |
Long description of the item. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
250 |
com_translations |
TRANSLATION |
VARCHAR2(4000 CHAR) |
If Location is CORPORATE, the com_translations record is created using ItemDesc. |
|
|
30 |
SecondaryItemDesc |
Secondary description of the item. Data is optional in this field. |
Character |
250 |
NA |
NA |
NA |
Ignored. |
|
|
31 |
ShortDescription |
Shortened item description. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
120 |
NA |
NA |
NA |
Ignored. |
|
|
32 |
BrandName |
This field contains the brand associated to an item. Data is optional in this field. |
Character |
30 |
NA |
NA |
NA |
Ignored. |
|
|
33 |
MerchandiseInd |
Indicates if the item is a merchandise item (Y, N). Merchandise items are generally physical items (things that must be shipped/received and of which there is an inventory). Non-merchandise items are often items which do not have inventory. Common examples include extra fees for service (extended warranties, alterations) or endlessly available items (downloads, in-app purchases of bonus content, subscriptions). All items, both merchandise and non-merchandise, are exported from RMS. This field will always have data for all records. |
Character |
1 |
NA |
NA |
NA |
If N, then NON_PHYSICAL item so the record is skipped. |
|
|
34 |
PrimaryRefItemInd |
Indicates if the sub-transaction level item is designated as the primary sub-transaction level item. For transaction level items and above, the value in this field will be N. For sub-transaction level items, this field may be either Y (if the current record is a primary UPC) or N (if the current record is not the primary UPC). This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
35 |
CostZoneGroupId |
Cost zone group associated with the item for ELC calculations. Data is optional in this field. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
36 |
StandardUOM |
Unit of measure in which stock of the item is tracked at a corporate level. Unit of measure may have to be manually synchronized between the systems as this is foundation data that is not currently bulk integrated out of Merchandising. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
4 |
NA |
NA |
NA |
Ignored. |
|
|
37 |
UOMConvFactor |
Conversion factor between an Each and the standard_uom when the standard_uom is not in the quantity class (such as if standard_uom = lb and 1 lb = 10 eaches, this factor will be 10). This factor is used to convert sales and stock data when an item is retailed in eaches, but does not have eaches as its standard unit of measure. Data is optional in this field. |
Number |
20 |
NA |
NA |
NA |
Ignored. |
|
|
38 |
PackageSize |
Holds the size of the product printed on any packaging (for example, 24 ounces). This field can be used for reporting purposes and to determine same sized and different sized items. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
39 |
PackageUOM |
Holds the unit of measure associated with the package size. This field can be used for reporting purposes and to determine same sized and different sized items. Data is optional in this field. |
Character |
4 |
NA |
NA |
NA |
Ignored. |
|
|
40 |
StoreOrdMulti |
Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are: C = Cases; I = Inner; E = Eaches. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
41 |
ForecastInd |
Indicates if sales forecasts will be produced for this item. Valid values are: Y, N. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
42 |
OriginalRetail |
The original retail price of the item per unit. This field is stored in the primary currency of the Merchandising systems. Data is optional in this field. |
Number |
20 |
NA |
NA |
NA |
Ignored. |
|
|
43 |
OriginalRetailCurrencyCode |
The currency code of the OriginalRetail. Data is optional in this field. |
Character |
3 |
NA |
NA |
NA |
Ignored. |
|
|
44 |
MfgRecRetail |
Data is optional in this field. |
Number |
20 |
itm_item |
LIST_PRICE |
NUMBER(17,6) |
NA |
|
|
45 |
MfgRecRetailCurrencyCode |
The currency code of the MfgRecRetail. Data is optional in this field. |
Character |
3 |
NA |
NA |
NA |
Ignored. |
|
|
46 |
RetailLabelType |
This field indicates any special label type associated with an item (that is, pre-priced or cents off). This field is used in RMS for reporting purposes only. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
47 |
RetailLabelValue |
This field represents the value associated with the RetailLabelType. Data is optional in this field. |
Number |
20 |
NA |
NA |
NA |
Ignored. |
|
|
48 |
ItemAggregateInd |
This field holds an indicator of whether the retailer wants to aggregate inventory and sales for the item with the inventory and sales of other child items. For staple items, this indicator is N. For fashion items, this indicator may be Y. If this indicator is Y, the retailer may also define which diff positions should be aggregated into item/diff combinations. Aggregated sales and inventory planning data can be used for inventory decision making and other reporting. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
49 |
Diff1AggregateInd |
This field holds an indicator (Y/N) of whether the retailer wants to aggregate inventory and sales for the item by the first Diff defined for the item (such as Style/Color). Aggregated sales and inventory planning data can be used for inventory decision making and other reporting. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
50 |
Diff2AggregateInd |
This field holds an indicator (Y/N) of whether the retailer wants to aggregate inventory and sales for the item by the first Diff defined for the item (such as Style/Waist Size). Aggregated sales and inventory planning data can be used for inventory decision making and other reporting. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
51 |
Diff3AggregateInd |
This field holds an indicator (Y/N) of whether the retailer wants to aggregate inventory and sales for the item by the first Diff defined for the item (such as Style/Inseam). Aggregated sales and inventory planning data can be used for inventory decision making and other reporting. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
52 |
Diff4AggregateInd |
This field holds an indicator (Y/N) of whether the retailer wants to aggregate inventory and sales for the item by the first Diff defined for the item (such as Style/Pattern). Aggregated sales and inventory planning data can be used for inventory decision making and other reporting. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
53 |
ItemNumberType |
This field holds a code descriptor of the type of item number. Valid values for this field include, but are not limited to: ITEM - Oracle Retail Item Number UPC-A - UCC12 UPC-AS - UCC12 with Supplement UPC-E - UCC8 UPC-ES - UCC8 with Supplement EAN8 - EAN/UCC-8 EAN13 - EAN/UCC-13 EAN13S - EAN/UCC-13 with Supplement ISBN10 - SBN-10 ISBN13 - ISBN-13NDC - NDC/NHRIC - National Drug Code PLU - PLU VPLU - Variable Weight PLU SSCC - SSCC Shipper Carton UCC14 - EAN/UCC-14 MANL - Manual This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
54 |
FormatID |
This field holds the format ID that corresponds to the item's variable UPC. This value is only used for items with variable weight PLU/variable weight UPCs (ItemNumberType = VPLU). Valid values include, but are not limited to: A 1-4-6-1 B 1-5-5-1 C 1-4-6-1 D 1-5-5-1 E 2-4-5-1 F 2-4-5-1 G 2-5-4-1 H 2-5-5-1 I 2-4-6-1 J 2-4-6-1 K 2-5-5-1 In the case of a type A, this means the total barcode will be at least 6 digits. The prefix of the barcode will be 1 digit in the first position. The item ID is 4 digits and will be in digits 2 to 5 of the barcode. The variable weight will start in digit 6 of the barcode and be at least 1 (possibly more digits). Data is optional in this field, and can only exist for the ItemNumberType = VPLU. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
55 |
Prefix |
This column holds the prefix for variable weight UPCs. The size of the prefix (1 or 2 digits) depends on the FormatID. The prefix is used to standardize variable weight UPCs. Data is optional in this field, and can only exist for the ItemNumberType = VPLU. |
Number |
2 |
NA |
NA |
NA |
Ignored. |
|
|
56 |
RecHandlingTemp |
Holds the temperature information associated with the item. Valid values include, but are not limited to: FRIDGE - Keep Refrigerated at 35°F/1.6°C FROZEN - Keep Frozen at 0°F/-18C ROOM - Keep at Room Temperature Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
57 |
RecHandlingSens |
Holds the sensitivity information associated with the item. Valid values include, but are not limited to: AERO - Aerosol Container - flammable COMPUS - Combustible EXPLOD - Explosive FRAG - Fragile TOXIC - Toxic Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
58 |
PerishableInd |
Grocery item attribute used to indicate whether an item is perishable. Valid values are Y and N. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
59 |
WasteType |
Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (for example, fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (for example, evaporation causes the product to weigh less after a period of time). Valid values are: SP - Spoilage SL - Sales Wastage is not applicable to pack items. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
60 |
WastePct |
Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
61 |
DefaultWastePct |
Default daily wastage percent for spoilage type wastage items. This value defaults to all item locations and represents the average amount of wastage that occurs on a daily basis. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
62 |
ConstantDimInd |
This field will always have data. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
63 |
ContainsInnerInd |
Indicates that the dimensions of the product are always the same, regardless of the supplier. Valid values are Y and N. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
64 |
SellableInd |
Indicates if the item may be sold as a unit. If it is Y, the item will have its own unique unit retail. If it is N, the item will not have a unit retail. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
65 |
OrderableInd |
Indicates if the item may be ordered as a unit. Valid values are: Y - Yes, this item/pack may be ordered from a single supplier. N - No, this item/pack may not be ordered from a single supplier. Non-orderable items might be transformed or produced (in- house bakery items for example) by the retailer. Examples might include, but are not limited to: Ground beef item is not orderable because the retailer orders a side of beef and transforms it into ground beef. In-house bakery items are not orderable because the retailer produces them in house. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
66 |
PackType |
Indicates if a pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will use the vendor pack number. A buyer pack is a pack that a buyer has created for ease of use within the retail business. If the pack item is a buyer pack, communication with the supplier will explode the pack out to its component items. This field will only contain data if the item is a pack item. If the pack item is not orderable, this field must be NULL. Valid values are: V - Vendor, B - Buyer. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
67 |
OrderAsType |
Indicates if a pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if a pack item is an orderable buyer pack. This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item. Valid values are: E - Eaches (component level) P - Pack (buyer pack only) Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
68 |
ItemServiceLevel |
Default shipping option for consumers. Valid values include, but are not limited to: 2DAY - Second Day GRND - Ground OVRNT - Overnight POVRNT - Priority Overnight Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
69 |
GiftWrapInd |
This field contains a value of Y if the item is eligible to be gift wrapped. If not explicitly defined, this field defaults to N. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
70 |
ShipAloneInd |
This field contains a value of Y if the item must be shipped alone to consumers. If not explicitly defined, this field defaults to N. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
71 |
ItemXformInd |
This field contains a value of Y if the item is associated with an item transformation. The item will either be the sellable item or orderable item in the transformation process. Transformations include a side of beef (orderable transformation item) cut into steaks/ground beef and so on (sellable transformation items). This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
72 |
CatchWeightInd |
Indicates whether the item should be weighed when it arrives at a location. Valid values for this field are Y and N. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
itm_item |
MEASURE_REQ_FLAG |
NUMBER(1,0) |
If Y, then 1. |
|
|
73 |
CatchWeightType |
This field holds the catch weight type for a simple pack catch weight item. The value is based on the component items order_type and sale_type. 2 - order_type = Variable Weight, sale_type = Loose Weight 4 - order_type = Variable Weight, sale_type = Variable Weight Each Data is optional in this field and will only exist for catch weight, simple pack items. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
74 |
CatchWeightOrderType |
This field holds a code that indicates how catch weight items are ordered. Valid values are: F - Fixed weight V - Variable weight Data is optional in this field and will only exist for catch weight items. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
75 |
CatchWeightSaleType |
This field holds a code that indicates how catch weight items are sold in store locations. Valid values are: V - variable weight each L - Loose weight Data is optional in this field and will only exist for catch weight items. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
76 |
CatchWeightUOM |
UOM for Catchweight Items. Data is optional in this field and will only exist for catch weight items. |
Character |
4 |
NA |
NA |
NA |
Ignored. |
|
|
77 |
DepositItemType |
This is the deposit item component type. A NULL value in this field indicates that this item is not part of a deposit item relationship. Valid values include: E - Contents A - Container Z - Crate T - Returned Item (Empty bottle) P - Complex pack (with deposit items) The Returned Item is flagged only to enable these items to be mapped to a separate GL account if required. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
78 |
ContainerItem |
This field holds the container item number for a contents item. This field is only populated and required if the DepositItemType is E. It will hold an item number that has a DepositItemType of A. Data is optional in this field. |
Character |
25 |
NA |
NA |
NA |
Ignored. |
|
|
79 |
DepositInPricePerOUM |
This field indicates if the deposit amount is included in the price per UOM calculation for a contents item ticket. This value is only required if the DEPOSIT_ITEM_TYPE = E. Valid values are: I - Includes deposit amount E - Excludes deposit amount Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
80 |
SOHInquiryAtPackInd |
This field indicates if stock on hand inquiries from downstream systems should be allowed at the pack level for this item. It defaults to N for non-pack items. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
81 |
NotionalPackInd |
If this indicator is Y, SIM and other downstream systems should track pack inventory at the pack level. If the indicator is N, SIM and other downstream systems track inventory at the component level. It defaults to N for non-pack items. This field will always have data for the ITEMHDRCRE and ITEMHDRMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
82 |
Comments |
Holds any free-form comments associated with the item. Data is optional in this field. |
Character |
2000 |
NA |
NA |
NA |
Ignored. |
|
|
NA |
NA |
NA |
NA |
itm_item |
MERCH_LEVEL_1 |
VARCHAR2(60 CHAR) |
Populated by looking up the parent of the merch_level_2 value in loc_org_hierarchy. |
||
|
NA |
NA |
NA |
NA |
itm_item |
ITEM_TYPCODE |
VARCHAR2(30 CHAR) |
STANDARD |
NA |
|
|
NA |
NA |
NA |
NA |
itm_item |
DESCRIPTION |
VARCHAR2(254 CHAR) |
Contains synthesized Translation key following the pattern: "+item:[ITEM ID]:description". Key maps to the com_tranlsation record populated from RMS ItemLoc. |
||
|
NA |
NA |
NA |
NA |
itm_item |
NAME |
VARCHAR2(254 CHAR) |
Contains synthesized Translation key following pattern: "+item:[ITEM ID]:description". Key maps to com_tranlsation record populated from RMS ItemLoc. |
||
|
NA |
NA |
NA |
NA |
itm_item, itm_item_dimension_value, itm_item_dimension_type |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_dimension_value, itm_item_dimension_type |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =ITEMHDRMOD. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_dimension_value, itm_item_dimension_type |
CREATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when Type =ITEMHDRMOD. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_dimension_value, itm_item_dimension_type |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =FULLHDR. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_dimension_value, itm_item_dimension_type |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when Type =FULLHDR. |
|
Table B-5 describes the RMS Item Location mapping.
Table B-5 RMS Item Location Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always ITEMLOC. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULLITEMLOC when the program is run in full mode. In delta mode, valid values are: ITEMLOCCRE ITEMLOCMOD ITEMLOCDEL Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
2 |
LocType |
This field indicates whether the location is a Store or Warehouse. Valid values are: S - Store W - Warehouse E - External Finisher Data will always be present in this field. |
Character |
1 |
itm_item_options |
LEVEL_CODE |
VARCHAR2(30 CHAR) |
STORE |
If not S, entire record is ignored. |
|
3 |
Location |
This field holds the numeric ID of the store of WH. Data will always be present in this field. |
Number |
10 |
itm_item_options |
LEVEL_VALUE |
VARCHAR2(30 CHAR) |
NA |
|
|
4 |
Item |
ID of the item. Data will always be present in this field. |
Character |
25 |
itm_item_options |
ITEM_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
5 |
ItemParent |
ID of the parent of the item. Item parent does not vary by location, but is included in this feed as a denormalized convenience for downstream systems. Data is optional in this field for many items. |
Character |
25 |
NA |
NA |
NA |
Ignored, obtained from ItemHdr feed. |
|
|
6 |
ItemGrandparent |
ID of the grandparent of Item. Item grandparent does not vary by location, but is included in this feed as a denormalized convenience for downstream systems. Data is optional in this field for many items. |
Character |
25 |
NA |
NA |
NA |
Ignored, obtained from ItemHdr feed. |
|
|
7 |
InitialUnitRetail |
Initial Unit Retail of the item in the item's standard unit of measure. Data is optional in this field for some type of items. Data is only included in this field for the ITEMLOCCRE and FULLITEMLOC records. After initial item creation, unit retail and other pricing information should come from RPM. If this program is run in full mode and produces FULLITEMLOC records, a full extract from RPM of pricing should also be performed to update all price records. |
NA |
NA |
NA |
NA |
NA |
Ignored. |
|
|
8 |
SellingUnitRetail |
Data is optional in this field for some type of items. Data is only included in this field for the ITEMLOCCRE and FULLITEMLOC records. After initial item creation, unit retail and other pricing information should come from RPM. If this program is run in full mode and produces FULLITEMLOC records, a full extract from RPM of pricing should also be performed to update all price records. |
Number |
20 |
itm_item_prices |
PRICE |
NUMBER(17,6) |
When non-null, a Regular Price Event record will be created in itm_item_prices. |
|
|
9 |
CurrencyCode |
Currency Code of retail values. This field should be populated for the ITEMLOCCRE and FULLITEMLOC records that have InitialUnitRetail and SellingUnitRetail values. |
NA |
NA |
NA |
NA |
NA |
Ignored. |
|
|
10 |
SellingUOM |
Data is optional in this field for some type of items. Data is only included in this field for the ITEMLOCCRE and FULLITEMLOC records. |
Character |
4 |
itm_item_options |
UNIT_OF_MEASURE_CODE |
VARCHAR2(30 CHAR) |
NA |
|
|
11 |
TaxableInd |
Indicates if the item is taxable at the location. This field will always have data for FULLITEMLOC, ITEMLOCCRE, and ITEMLOCMOD. |
Character |
1 |
itm_item_options |
TAX_GROUP_ID |
VARCHAR2(60 CHAR) |
0 |
If N, then 0, or configured value, (dataloader-beans.xml). |
|
12 |
LocalItemDesc |
Contains the local description of the item. This may be the same as the primary description of the item, a regional description of the item (jimmies versus sprinkles in the US or roll versus bap versus cob versus bun in the UK), or a value in a local language (Overlay dress - true black knit at US stores versus Lagenkleid - Strick, tiefschwarz at stores in Germany). The intent is that this string is appropriate to print this description on signage/receipts at this location. This field will always have data. |
Character |
250 |
com_translations |
TRANSLATION |
VARCHAR2(4000 CHAR) |
If translated, ItemDescriptionsEnabled is true (see dataloader-beans.xml), and then com_translations record is created using ItemDesc. It is recommended that translated ItemDescriptionsEnabled be set to false when loading Xcenter because non-local descriptions are used in translation records when loading ItemHdr. |
|
|
13 |
LocalShorDesc |
May contain an abbreviated local description of the item. This may be the same as the primary abbreviated description of the item, an abbreviation of regional description of the item, or an abbreviation in a local language. The intent is that this string is appropriate to print this description on signage/receipts at this location. Data is optional in this field. |
Character |
120 |
NA |
NA |
NA |
Ignored. |
|
|
14 |
Ti |
Number of shipping units (cases) that make up one tier of a pallet of this item for this location. A location may use a local pallet configuration if there are special space or receiving configurations that make typical pallets impractical. Multiply TI by HI to get the total number of cases for a pallet. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
15 |
Hi |
Number of tiers that make up a complete pallet (height). A location may use a local pallet configuration if there are special space or receiving configurations that make typical pallets impractical. Multiply TI by HI to get the total number of cases for a pallet. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
16 |
StoreOrderMultiple |
Contains the multiple in which the item needs to be shipped from a warehouse to the location. This field will always have data for FULLITEMLOC, ITEMLOCCRE, and ITEMLOCMOD. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
17 |
Status |
Current status of item at the location. Valid values are: A - Active, item is valid and can be ordered and sold. I - Inactive, item is valid, but cannot be ordered or sold. C - Discontinued, item is valid and sellable, but no longer orderable .D - Delete, item is pending delete and cannot be ordered or sold.This field will always have data for FULLITEMLOC, ITEMLOCCRE, and ITEMLOCMOD. |
Character |
1 |
itm_item_options |
ITEM_AVAILABILITY_CODE, STOCK_STATUS |
VARCHAR2(30 CHAR, VARCHAR2(60 CHAR) |
If itemLoc:status=A or C, the item_availability_code is Available. If itemLoc:status=I or D, the item_availability_code is NA. If itemLoc:status=C, the stock_status is DISCONTINUED. Otherwise, stock_status is null. |
|
|
18 |
DailyWastePct |
Average percentage lost from inventory on a daily basis due to natural wastage. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
19 |
MeasureOfEach |
Size of an each in terms of the uom_of_price, for example, 12 oz. This information can be used in ticketing and display to consumers. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
20 |
MeasureOfPrice |
Size to be used on the ticket in terms of the uom_of_price. For example, if the user wants the ticket to have the label print the price per ounce, this value would be 1. If the user wants the price per 100 grams, this value would be 100. Used in ticketing. Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
21 |
UomOfPrice |
Unit of measure that is used on the ticket for this item. Data is optional in this field. |
Character |
4 |
NA |
NA |
NA |
Ignored. |
|
|
22 |
PrimaryVariant |
This field is used to address sales of PLUs (that is, above transaction level items) when inventory is tracked at a lower level (that is, UPC). This field only contains a value for items one level higher than the transaction level. Valid choices are any transaction level item that is a child of this item. In order to select a transaction level item as the primary variant, the item/location relationship must exist at the transaction level. When a transaction level item is specified as a primary variant for an item higher than the transaction level, an extra pos_mods record will be written. Both the transaction level item (that is, UPC) and the higher than transaction level item (that is, PLU) will be sent to the POS to allow the store to sell the PLU. The information sent for the PLU will be the same information sent for the transaction level item (that is, UPC). Data is optional in this field. |
Character |
25 |
NA |
NA |
NA |
Ignored. |
|
|
23 |
PrimaryCostPack |
This field contains an item number that is a simple pack containing the item in the item column for this record. If populated, the cost of the future cost table will be driven from the simple pack and the deals and cost changes for the simple pack. Data is optional in this field. |
Character |
25 |
NA |
NA |
NA |
Ignored. |
|
|
24 |
PrimarySupplier |
Numeric identifier of the supplier who will be considered the primary supplier for the specified item/loc. The supplier/origin country combination will determine the value of the unit cost field on item_loc. If the supplier is changed and ELC = N, the unit cost field on item_loc will be updated with the new supplier's cost. Data is optional in this field. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
25 |
PrimaryOriginCountry |
Contains the identifier of the origin country which will be considered the primary country for the specified item/location. Data is optional in this field. |
Character |
3 |
NA |
NA |
NA |
Ignored. |
|
|
26 |
ReceiveAsType |
This column determines whether the stock on hand for a pack component item or the buyer pack itself will be updated when a buyer pack is received at a warehouse. Valid values are Each or Pack. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
27 |
InboundHandlingDays |
This field indicates the number of inbound handling days for an item at a warehouse type location. Data is optional in this field. |
Number |
2 |
NA |
NA |
NA |
Ignored. |
|
|
28 |
SourceMethod |
This value is used to specify how the ad-hoc PO/TSF creation process should source the item/location request. If the value is Warehouse, the process will attempt to fill the request by creating a transfer from the warehouse in the source_wh field. If this warehouse does not have enough inventory to fill the request, a purchase order will be created for the item/location's primary supplier. For warehouses, it is used by Oracle Retail Allocation to determine the valid sources and destinations for warehouse to warehouse allocations. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
29 |
SourceWh |
This value is used by the ad-hoc PO/Transfer creation process to determine from which warehouse to fill the stores request. It is also used by the Allocation process to support warehouse to warehouse allocations. A value is required in this field if the sourcing method is Warehouse. Data is optional in this field. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
30 |
UinType |
This column contains the unique identification number (UIN) used to identify the instances of the item at the location. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Used to determine a Serialized Item. If empty, itm_item.serialized_item_flag is set to 0. Otherwise, itm_item.serialized_item_flag is set to 1. |
|
|
31 |
UinLabel |
This column contains the label for the UIN when displayed in SIM. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
32 |
CaptureTimeInProc |
This column indicates when the UIN should be captured for an item during transaction processing. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
33 |
ExtUinInd |
This Yes/No indicator indicates if the UIN is being generated in the external system. This field will always have data for FULLITEMLOC, ITEMLOCCRE, and ITEMLOCMOD. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
34 |
IntentionallyRangedInd |
Determines if the location is ranged intentionally by the user for replenishment/selling (Y) or incidentally ranged (N) by the RMS programs when the item is not ranged to a specific location on the transaction. This field will always have data for FULLITEMLOC, ITEMLOCCRE, and ITEMLOCMOD. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
35 |
CostingLocation |
Numeric identifier of the costing location for the franchise store. This field may contain a store or a warehouse. Data is optional in this field. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
36 |
CostingLocType |
This field holds the type of costing location in the CostingLocation field. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
37 |
LaunchDate |
Holds the date that the item should first be sold at the location; in the human readable format DD-MON-YYYY. Data is optional in this field. |
Character |
12 |
NA |
NA |
NA |
Ignored. |
|
|
38 |
QtyKeyOptions |
Determines whether the qty key on a POS should be used for this item at the location. Valid values include, but are not limited to: R - Required P - Prohibited O - Optional Data is optional in this field. |
Character |
6 |
itm_item_options |
PROMPT_FOR_QUANTITY_FLAG, FORCE_QUANTITY_OF_ONE_FLAG |
NUMBER(1,0) |
PROMPT_FOR_QUANTITY_FLAG - 1 if R, otherwise 0. FORCE_QUANTITY_OF_ONE_FLAG - 1 if P, otherwise 0. |
|
|
39 |
ManualPriceEntry |
Determines whether the price can/should be entered manually on a POS for this item at the location. Valid values include, but are not limited to: R - Required P - Prohibited O - Optional Data is optional in this field. |
Character |
6 |
itm_item_options |
PROMPT_FOR_PRICE_FLAG |
NUMBER(1,0) |
1 if R, othewise 0. |
|
|
40 |
DepositCode |
Indicates if a deposit is associated with this item at the location. Deposits are not subtracted from the retail of an item uploaded to RMS, and so on. This kind of processing is the responsibility of the client and should occur before sales are sent to ReSA and RMS. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
41 |
FoodStampInd |
Indicates whether the item is approved for food stamps at the location. This indicator does not impact processing in ReSA and RMS. Data is optional in this field. |
Character |
1 |
itm_item_options |
FOODSTAMP_ELIGIBLE_FLAG |
NUMBER(1,0) |
1 if Y, otherwise 0. |
|
|
42 |
WicInd |
Indicates whether the item is approved for WIC at the location. This indicator does not impact processing in ReSA and RMS. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
43 |
ProportionalTarePct |
Holds the value associated for the packaging in items sold by weight at the location. The proportional tare is the proportion of the total weight of a unit of an item that is packaging (that is, if the tare item is bulk candy, this is the proportional of the total weight of one piece of candy that is the candy wrapper). Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
44 |
FixedTareValue |
Holds the value associated for the packaging in items sold by weight at the location. Fixed tare is the tare of the packaging. This value is fixed, regardless of how much of the item is sold (that is, if the tare item is bulk candy, this is weight of the bag and twist tie). Data is optional in this field. |
Number |
12 |
NA |
NA |
NA |
Ignored. |
|
|
45 |
FixedTareUom |
Holds the unit of measure value associated with the tare value. Data is optional in this field. |
Character |
4 |
NA |
NA |
NA |
Ignored. |
|
|
46 |
RewardEligibleInd |
Holds whether the item is legally valid for various types of bonus point/award programs at the location. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
47 |
NatlBrandCompItem |
Holds the nationally branded item to which the current item should be compared. Data is optional in this field. |
Character |
25 |
NA |
NA |
NA |
Ignored. |
|
|
48 |
ReturnPolicy |
Holds the return policy for the item at the location. Retailers may configure any number of return policies. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
49 |
StopSaleInd |
Indicates that sale of the item should be stopped immediately at the location (that is, in case of recall, and so on). Data is optional in this field. |
Character |
1 |
itm_item_options |
ITEM_AVAILABILITY_CODE |
VARCHAR2(30 CHAR |
If stopSaleInd =Y, item_availability_code is RECALL. Otherwise, see the itemLoc:status mapping. |
|
|
50 |
ElectMtkClub |
Holds the code that represents the marketing clubs to which the item belongs at the location. Retailers may configure any number of marketing clubs. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
51 |
ReportCode |
Code to determine which reports the location should run. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
52 |
ReqShelfLifeOnSelection |
Holds the required shelf life for an item on selection in days. This field is not required. Data is optional in this field. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
53 |
ReqShelfLifeOnReceipt |
Holds the required shelf life for an item on receipt in days. Data is optional in this field. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
54 |
IBShelfLife |
Holds the Investment Buy-specific shelf life for the item/location in days. Data is optional in this field. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
55 |
StoreReorderableInd |
Indicates whether the store may reorder the item. This field is required to be either Y - yes or N - no. The field defaults to N. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
56 |
RackSize |
Indicates the rack size that should be used for the item. This field is not required. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
57 |
FullPalletItem |
Indicates whether a store must reorder an item in full pallets only. This field is required to be either Y - yes or N - no. The field defaults to N. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
58 |
InStoreMarketBasket |
Holds the in-store market basket code for this item/location combination. Data is optional in this field. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
59 |
StorageLocation |
Holds the current storage location or bin number for the item at the location. Data is optional in this field. |
Character |
7 |
NA |
NA |
NA |
Ignored. |
|
|
60 |
AltStorageLocation |
Holds the preferred alternate storage location or bin number for the item at the location. Data is optional in this field. |
Character |
7 |
NA |
NA |
NA |
Ignored. |
|
|
61 |
ReturnableInd |
This field contains a value of Yes when the item can be returned to the location. Data is optional in this field. |
Character |
1 |
itm_item_options |
NOT_RETURNABLE_FLAG |
NUMBER(1,0) |
1 if N, otherwise 0. |
|
|
62 |
RefundableInd |
This field contains a value of Yes when the item is refundable at the location. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
63 |
BackOrderInd |
This field contains a value of Yes when the item can be back-ordered to the location. Data is optional in this field. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
64 |
MerchandiseInd |
Note that the MerchandiseInd does not vary by locations (items are not physical entities in one location and fees in another). The MerchandiseInd is denormalized to the item/location level because it is a common use case for some downstream systems to care only about physical or non-physical items. This field is denormalized to assist those systems in their filtering logic. All items, both merchandise and non-merchandise, are exported from RMS. This field will always have data for all records. |
Character |
1 |
NA |
NA |
NA |
If N, then NON_PHYSICAL item so record is skipped. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_options |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_options |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =ITEMLOCMOD. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_options |
CREATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when Type =ITEMLOCMOD. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_options |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =FULLITEMLOC. |
|
|
NA |
NA |
NA |
NA |
itm_item, itm_item_options |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when Type =FULLITEMLOC. |
|
Table B-6 describes the RMS Merchandise Hierarchy mapping.
Table B-6 RMS Merchandise Hierarchy Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always MERCHHIERARCHY. |
Character |
20 |
ITM_MERCH_HEIRARCHY |
NA |
NA |
No need to store this information. This information is only consumed by the transformer to determine the feed type. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary, and be composed of the entity (DIVISION, GROUP, DEPT, CLASS, SUBCLASS) and the type of change (CRE, MOD, DEL). Examples include: DIVISIONCRE DIVISIONMOD DIVISIONDEL GROUPCRE GROUPMOD GROUPDEL DEPTCRE DEPTMOD DEPTDEL CLASSCRE CLASSMOD CLASSDEL SUBCLASSCRE SUBCLASSMOD SUBCLASSDEL Note: Deleting a node of the merchandise hierarchy is unusual, and can only be done if no items are associated with the node. |
Character |
15 |
ITM_MERCH_HEIRARCHY |
NA |
NA |
No need to store this information. This information is only consumed by the transformer to determine the action type. |
|
|
2 |
HierarchyLevel |
Value is always DIVISION, GROUP, DEPT, CLASS, SUBCLASS. This field cannot be null. This information identifies the level of the merchandise hierarchy that is described by this record. It is not possible to modify a HierarchyLevel on an existing record. |
Character |
10 |
ITM_MERCH_HEIRARCHY |
level_code |
VARCHAR2(30 CHAR) |
level |
|
|
3 |
HierarchyNodeId |
HierarchyNodeId is only unique within a HierarchyLevel (meaning it is possible, for example, that there is both a DIVISION 1 and a GROUP 1 in the full merchandise hierarchy). It is not possible to modify HierarchyNodeId on an existing record. |
Number |
10 |
ITM_MERCH_HEIRARCHY |
heirarchy_id |
VARCHAR2(60 CHAR) |
heirarchy id+first letter of hierarchy level. |
|
|
4 |
HierarchyNodeName |
Name of the organizational hierarchy entity. This field cannot be null. Description data is only sent in the primary integration language of the system. HierarchyNodename can be modified. |
Character |
150 |
ITM_MERCH_HEIRARCHY |
description |
VARCHAR2(254 CHAR) |
node name |
|
|
5 |
ParentLevel |
Level of the organizational hierarchy above the current node. Both ParentLevel and ParentId should be evaluated to correctly traverse the hierarchy. It is not possible to modify ParentLevel on an existing record. |
Character |
10 |
ITM_MERCH_HEIRARCHY |
NA |
NA |
This ID is used to validate the parent child relationship. It is not persisted into the database, but plays a key role in the parent child relationship validation of the merchandise hierarchy. |
|
|
6 |
ParentId |
ID of the level of the organizational hierarchy above the current node. Both ParentLevel and ParentId should be evaluated to correctly traverse the hierarchy. ParentId can be modified, meaning it is possible to change the division to which a group belongs. |
Number |
10 |
ITM_MERCH_HEIRARCHY |
parent_id |
VARCHAR2(60 CHAR) |
parent heirarchy id |
|
|
7 |
GrandparentMerchDisplayId |
Only populated for SUBCLASS entities. For subclasses, this column holds the department ID used for display purposes in RMS (department is the grandparent of subclass). Note that in RMS, dept, class, and subclass display IDs are combined to form a composite unique key. Every department can have a class 1. Every class in Department 1000 can have a subclass 1. Looking only at the display IDs, all three values are required for uniqueness. |
Number |
4 |
NA |
NA |
NA |
NA |
|
|
8 |
parentMerchDisplayId |
Only populated for CLASS and SUBCLASS entities. For classes, this column holds the department ID used for display purposes in RMS (department is the parent of class). For subclasses, this column holds the class ID used for display purposes in RMS. Note that in RMS, dept, class, and subclass display IDs are combined to form a composite unique key. Every department can have a class 1. Every class in Department 1000 can have a subclass 1. Looking only at the display IDs, all three values are required for uniqueness. |
Number |
4 |
NA |
NA |
NA |
NA |
|
|
9 |
merchDisplayId |
Only populated for DEPARTMENT, CLASS, and SUBCLASS entities. For departments, this column holds the department display ID. For classes, this column holds the class display ID. For subclasses, this column holds the subclass display ID. Note that in RMS, dept, class, and subclass display IDs are combined to form a composite unique key. Every department can have a class 1. Every class in Department 1000 can have a subclass 1. Looking only at the display IDs, all three values are required for uniqueness. |
Number |
4 |
NA |
NA |
NA |
NA |
|
|
NA |
NA |
NA |
NA |
ITM_MERCH_HEIRARCHY |
CREATE_DATE |
TIMESTAMP(6) |
NA |
||
|
NA |
NA |
NA |
NA |
ITM_MERCH_HEIRARCHY |
CREATE_USER_ID |
VARCHAR2(30 CHAR) |
NA |
||
|
NA |
NA |
NA |
NA |
ITM_MERCH_HEIRARCHY |
UPDATE_DATE |
TIMESTAMP(6) |
NA |
||
|
NA |
NA |
NA |
NA |
ITM_MERCH_HEIRARCHY |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
NA |
||
Table B-7 describes the RMS Organizational Hierarchy mapping.
Table B-7 RMS Organizational Hierarchy Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always ORGHIERARCHY. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary, and be composed of the entity (COMP, CHAIN, AREA, REGION, DISTRICT, STORE, WH) and the type of change (CRE, MOD, DEL). Examples include: COMPCRE - Creation of a Company node. COMPMOD - Modification of a Company node. CHAINCRE - Creation of Chain node. CHAINMOD - Modification of a Chain node. CHAINDEL - Delete of Chain node. AREACRE - Creation of an Area node. AREAMOD - Modification of Area node. AREADEL - Delete of Area node. REGIONCRE - Creation of Region node. REGIONMOD - Modification of Region node. REGIONDEL - Delete of Region node. DISTRICTCRE - Creation of District node. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
Type (Continued) |
DISTRICTMOD - Modification of District node. DISTRICTDEL - Delete of a District node. STORECRE - Creation of a Store node. STOREMOD - Modification of Store node. STOREDEL - Delete of Store node. WHCRE - Creation of WH node. WHMOD - Modification of WH node. WHDEL - Delete of WH node. Note: Deletion of Company node is not allowed. |
||||||||
|
2 |
HierarchyLevel |
Value is always COMPANY, CHAIN, AREA, REGION, DISTRICT, STORE, or WAREHOUSE. This field cannot be null. This information identifies the level of the organizational hierarchy that is described by this record. It is not possible to modify a HierarchyLevel on an existing record. |
Character |
10 |
loc_org_hierarchy |
org_code |
VARCHAR2(30 CHAR) |
For the root COMPANY node, the column is hard-coded as "*". |
|
|
3 |
HierarchyNodeId |
This information identifies the node of the organizational hierarchy that is described by this record. This field cannot be null. HierarchyNodeId is only unique within a HierarchyLevel (meaning it is possible, for example, that there is both a DISTRICT 1 and a REGION 1 in the full organizational hierarchy). It is not possible to modify HierarchyNodeId on an existing record. |
Number |
10 |
loc_org_hierarchy |
org_code |
VARCHAR2(60 CHAR) |
For the root COMPANY node, the column is hard-coded as "*". |
|
|
4 |
HierarchyNodeName |
Name of the organizational hierarchy entity. This field cannot be null. Description data is only sent in the primary integration language of the system. HierarchyNodename can be modified. |
Character |
150 |
loc_org_hierarchy |
description |
VARCHAR2(254 CHAR) |
NA |
|
|
5 |
ParentLevel |
Level of the organizational hierarchy above the current node. Both ParentLevel and ParentId should be evaluated to correctly traverse the hierarchy. ParentLevel is null for the COMPANY, but will exist for all other hierarchy levels. Warehouses always have the COMPANY node as their ParentLevel. It is not possible to modify ParentLevel on an existing record. |
Character |
10 |
loc_org_hierarchy |
parent_code |
VARCHAR2(30 CHAR) |
For the root COMPANY node, the column is hard-coded as null. For the second level CHAIN node, the column is hard-coded to "*". |
|
|
6 |
ParentId |
ID of the level of the organizational hierarchy above the current node. Both ParentLevel and ParentId should be evaluated to correctly traverse the hierarchy. ParentId is null for the COMPANY, but will exist for all other hierarchy levels. Warehouses always have the COMPANY node ID as their ParentId. ParentId can be modified, meaning it is possible to change the REGION ID that a DISTRICT ID belongs to (but a DISTRICT will always belong to a REGION as it is not possible to change the ParentLevel). |
Number |
10 |
loc_org_hierarchy |
parent_value |
VARCHAR2(60 CHAR) |
For the root COMPANY node, the column is hard-coded as null. For the second level CHAIN node, the column is hard-coded to "*". |
|
|
7 |
MgrName |
Manager of the current node of the hierarchy. MgrName is null for the COMPANY, and is optional for CHAIN, AREA, REGION, DISTRICT, and WAREHOUSE. It will always exist for STORE in Cre and Mod records. MrgName can be modified. |
Number |
10 |
loc_org_hierarchy |
level_mgr |
VARCHAR2(254 CHAR) |
NA |
|
|
8 |
CurrencyCode |
Currency of the current node of the hierarchy. CurrencyCode is null for the COMPANY and optional for CHAIN, AREA, REGION, DISTRICT, and WAREHOUSE. It will always exist for STORE in Cre and Mod records. CurrencyCode can be modified for a CHAIN, AREA, REGION, and DISTRICT. It cannot be modified for a STORE or Warehouse. |
Character |
3 |
NA |
NA |
NA |
NA |
Ignored. |
|
NA |
NA |
NA |
NA |
loc_org_hierarchy |
level_order |
NUMBER(10,0) |
0 - COMPANY 10 - CHAIN 20 - AREA30 - REGION 40 - DISTRICT 1000 - STORE 2000 - Warehouse |
||
|
NA |
NA |
NA |
NA |
loc_org_hierarchy |
sort_order |
NUMBER(10,0) |
Always set to 0. |
||
|
NA |
NA |
NA |
NA |
loc_org_hierarchy |
inactive_flag |
NUMBER(1,0) |
Use default 0. |
||
|
NA |
NA |
NA |
NA |
loc_org_hierarchy |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
NA |
loc_org_hierarchy |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type represents UPDATE. |
|
|
NA |
NA |
NA |
NA |
loc_org_hierarchy |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type represents CREATE. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Always set. |
|
Table B-8 describes the RMS Related Item Detail mapping.
Table B-8 RMS Related Item Detail Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always ITEMS. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULLRELITEMDET when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: RELITEMDETCRE RELITEMDETMOD RELITEMDETDEL Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines Action. RelationshipType is looked up from rms_related_item_head by RelationshipId, Location, and OrganizationId. |
|
|
2 |
RelationshipID |
Unique identifier for each relationship header. Data will always be present in this field. |
Number |
10 |
itm_substitute_items, itm_attached_items |
EXTERNAL_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
3 |
RelatedItem |
Item ID of the related item Data will always be present in this field. |
Character |
25 |
itm_substitute_items, itm_attached_items |
ATTACHED_ITEM_ID, SUBSTITUTE_ITEM_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
4 |
Location |
For corporate level files, this field holds the string CORPORATE. In location specific files, this field holds the numeric ID of the store of WH. Data will always be present in this field. |
Character |
10 |
itm_substitute_items, itm_attached_items |
LEVEL_VALUE |
VARCHAR2(60 CHAR) |
NA |
|
|
5 |
Priority |
Priority is only defined if the relationship is of the type SUBS at the related item header level. In the case of multiple related substitute items, this column could be used (optionally) to define relative priority. If there are multiple substitute items, it is possible not to define a priority, in which case all possible substitutions have the same relative priority. Data is optional in this field. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
6 |
StartDate |
Optional start date that the item should be used in the relationship in DD-MON-YYYY format. If defined, this date indicates the first date the item should be offered as an upsell, substitute, or cross sell. Data is optional in this field. |
Character |
11 |
itm_substitute_items, itm_attached_items |
BEGIN_DATETIME |
TIMESTAMP(6) |
NA |
|
|
7 |
EndDate |
Optional end date that the item should be used in the relationship; in DD-MON-YYYY format. If defined, this date indicates the last date the item should be offered as an upsell, substitute or cross sell. Data is optional in this field. |
Character |
11 |
itm_substitute_items, itm_attached_items |
END_DATETIME |
TIMESTAMP(6) |
NA |
|
|
NA |
NA |
NA |
NA |
itm_substitute_items, itm_attached_items |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
NA |
itm_substitute_items, itm_attached_items |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =RELITEMDETMOD. |
|
|
NA |
NA |
NA |
NA |
itm_substitute_items, itm_attached_items |
CREATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when Type =RELITEMDETMOD. |
|
|
NA |
NA |
NA |
NA |
itm_substitute_items, itm_attached_items |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =FULLRELITEMDET. |
|
|
NA |
NA |
NA |
NA |
itm_substitute_items, itm_attached_items |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when Type =FULLRELITEMDET. |
|
|
NA |
NA |
NA |
NA |
itm_attached_items |
PROMPT_TO_ADD_FLAG |
NUMBER(1,0) |
TRUE |
Configurable in dataloader-beans.xml. |
|
|
NA |
NA |
NA |
NA |
itm_attached_items |
PROMPT_TO_ADD_MSG_KEY |
VARCHAR2(254 CHAR) |
_commonAttachedItemsPrompt |
Configurable in dataloader-beans.xml. |
|
Table B-9 describes the RMS Related Item Header mapping.
Table B-9 RMS Related Item Header Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always ITEMS. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULLRELITEMHDR when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: RELITEMHEADCRE RELITEMHEADMOD RELITEMHEADDEL Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. MOD will move records between itm_substute_items and item_attached_items when the modified record represents a relationshiptype change between CRSL/UPSL and SUBS. |
|
|
2 |
RelationshipID |
Unique identifier for each relationship header. Data will always be present in this field. |
Number |
20 |
rms_related_item_head |
RELATIONSHIP_ID |
NUMBER(20,0) |
Used as externaId in itm_substute_items and item_attached_items records. |
|
|
3 |
Item |
Item for which the relationships are defined. Data will always be present in this field. |
Character |
25 |
rms_related_item_head |
ITEM |
VARCHAR2(25 CHAR) |
When SUBS, this is the primaryItem. When CRSL/UPSL, this is the soldItem. |
|
|
4 |
Location |
For corporate level files, this field holds the string CORPORATE. In location specific files, this field holds the numeric ID of the store of WH. Data will always be present in this field. |
Character |
10 |
rms_related_item_head |
LOCATION |
VARCHAR2(10 CHAR) |
Used as levelValue in itm_substute_items and item_attached_items records. |
|
|
5 |
RelationshipName |
Name given to the relationship. Data will always be present in this field for the RELITEMHEADCRE and RELITEMHEADMOD records, but will not be present for RELITEMHEADDEL records. |
Character |
255 |
rms_related_item_head |
RELATIONSHIP_NAME |
VARCHAR2(255 CHAR) |
Ignored. |
|
|
6 |
RelationshipType |
Describes the type of relationship. Valid values are: CRSL Cross Sell SUBS Substitution UPSL Up Sell Data will always be present in this field for the RELITEMHEADCRE and RELITEMHEADMOD records, but will not be present for RELITEMHEADDEL records. |
Character |
6 |
rms_related_item_head |
RELATIONSHIP_TYPE |
VARCHAR2(6 CHAR) |
Determines the .type of Xstore related item. SUBS = Xstore Substitute Items, CRSL/UPSL = Xstore Attached Items. |
|
|
7 |
MandatoryInd |
This field indicates whether the relationship should be mandatory. For example, an item such as a laptop may have a mandatory cross sell relationship. The related items could be power cords for the US, UK, Mainland Europe, India, and so on. When the laptop is sold, it should be mandatory that one of the related power cords also be selected. Note that RMS/ReSA do not validate that the mandatory related item is also sold. Generally, only cross sell relationships are mandatory. Substitution and upsell relationships can be defined as mandatory, but in those cases, the definition of mandatory is at the discretion of the client and generally means that substitution or upsell must, as business process, be offered to consumers. Data will always be present in this field for the RELITEMHEADCRE and RELITEMHEADMOD records, but will not be present for RELITEMHEADDEL records. |
Character |
1 |
rms_related_item_head |
MANDATORY_IND |
VARCHAR2(1 CHAR) |
No logic is based on this data. |
|
|
NA |
NA |
NA |
NA |
rms_related_item_head |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
NA |
rms_related_item_head |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =ITEMHDRMOD. |
|
|
NA |
NA |
NA |
NA |
rms_related_item_head |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type =FULLRELITEMHDR |
|
|
NA |
NA |
NA |
NA |
item_item_options |
ATTACHED_ITEMS_FLAG |
NUMBER(1,0) |
Set to 1 when CRSL or UPSL, otherwise 0 for Item. |
||
|
NA |
NA |
NA |
NA |
item_item_options |
SUBSTITUTE_AVAILABLE_FLAG |
NUMBER(1,0) |
Set to 1 when SUBS, otherwise 0 for Item. |
||
Table B-10 describes the RMS Store mapping.
Table B-10 RMS Store Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always STORES. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: STORECRE - Creation of an Area node STOREMOD - Modification of Area node STOREDEL - Delete of Area node Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
2 |
StoreId |
Contains the unique ID of the store. Data will always be present in this field. |
Number |
10 |
loc_rtl_loc, tax_rtl_loc_tax_mapping |
STORE_NBR, RTL_LOC_ID |
NUMBER(10,0) |
NA |
|
|
3 |
StoreName |
Contains the full name of the store. Data will always be present in this field for creation and modification records. |
Character |
150 |
loc_rtl_loc |
DESCRIPTION |
VARCHAR(254) |
NA |
|
|
4 |
StoreName10 |
Contains a shortened, no more than 10 character name, for the store. Data will always be present in this field for creation and modification records. |
Character |
10 |
loc_rtl_loc |
STORE_NAME |
VARCHAR(254) |
NA |
|
|
5 |
StoreNameAbbr |
Contains an abbreviation for the store name. Data will always be present in this field for creation and modification records. |
Character |
3 |
NA |
NA |
NA |
Ignored. |
|
|
6 |
StoreNameSec |
Contains an secondary name for this store. Data in this field is optional. |
Character |
150 |
NA |
NA |
NA |
Ignored. |
|
|
7 |
StoreClassId |
Contains the code letter indicating the class of which the store is a member. Valid values are A, B, C, D, E, and X. Data will always be present in this field for creation and modification records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
8 |
StoreClassDesc |
Contains the description of the store class. Data will always be present in this field for creation and modification records. |
Character |
250 |
NA |
NA |
NA |
Ignored. |
|
|
9 |
Manager |
Contains the name of the store manager. Data will always be present in this field. for creation and modification records. |
Character |
120 |
loc_rtl_loc |
STORE_MANAGER |
VARCHAR(254) |
NA |
|
|
10 |
OpenDate |
Contains the date on which the store opened. Data will always be present in this field for creation and modification records. Format is YYYYMMDD. |
Date |
8 |
NA |
NA |
NA |
Ignored. |
|
|
11 |
CloseDate |
Contains the date on which the store closed. Data in this field is optional. Format is YYYYMMDD. |
Date |
8 |
NA |
NA |
NA |
Ignored. |
|
|
12 |
AquireDate |
Contains the date on which the store was acquired. Data in this field is optional. Format is YYYYMMDD. |
Date |
8 |
NA |
NA |
NA |
Ignored. |
|
|
13 |
RemodelDate |
Contains the date on which the store was last remodeled. Data in this field is optional. Format is YYYYMMDD. |
Date |
8 |
NA |
NA |
NA |
Ignored. |
|
|
14 |
FaxNumber |
Contains the fax number for the store. Data in this field is optional. |
Character |
20 |
loc_rtl_loc |
TELEPHONE_2 |
VARCHAR(32) |
Optional fax number. |
|
|
15 |
PhoneNumber |
Contains the phone number for the store. Data in this field is optional. |
Character |
20 |
loc_rtl_loc |
TELEPHONE_1 |
VARCHAR(32) |
Optional phone number. |
|
|
16 |
|
Holds the email address for the location. Data in this field is optional. |
Character |
100 |
loc_rtl_loc |
EMAIL_ADDR |
VARCHAR(254) |
Optional email address. |
|
|
17 |
TotalSqFeet |
Contains the total square footage of the store. Data in this field is optional. |
Number |
8 |
NA |
NA |
NA |
Ignored. |
|
|
18 |
SellingSqFeet |
Contains the total square footage of the stores selling area. Data in this field is optional. |
Number |
8 |
NA |
NA |
NA |
Ignored. |
|
|
19 |
LinearDistance |
Holds the total merchandisable space of the location. Data in this field is optional. |
Number |
8 |
NA |
NA |
NA |
Ignored. |
|
|
20 |
VatRegion |
Contains the number of the Value Added Tax region in which this store is contained. Data in this field is optional. |
Number |
4 |
tax_rtl_loc_tax_mapping |
taxLocationId |
VARCHAR2(60) |
NA |
|
|
21 |
VatInclInd |
Indicates whether Value Added Tax will be included in the retail prices for the store. Valid values are Y or N. Data in this field is optional. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
22 |
StockHoldingIn |
This column indicates whether the store can hold inventory. Data will always be present in this field for creation and modification records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
23 |
ChannelId |
Contains the channel with which the store is associated. Data in this field is optional. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
24 |
ChannelName |
Contains the name of the channel. Data in this field is optional. |
Character |
120 |
NA |
NA |
NA |
Ignored. |
|
|
25 |
StoreFormat |
Contains the number indicating the format of the store. Data in this field is optional. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
26 |
StoreFormatName |
Contains the description of the format of the store (for example, mall, standalone, city express, and so on). Data in this field is optional. |
Character |
60 |
NA |
NA |
NA |
Ignored. |
|
|
27 |
MallName |
Contains the name of the mall in which the store is located. Data in this field is optional. |
Character |
120 |
NA |
NA |
NA |
Ignored. |
|
|
28 |
District |
Contains the number of the district in which the store is a member. Data will always be present in this field. for creation and modification records. Further organizational hierarchy information is available in the Organizational Hierarchy Extract. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
29 |
TransferZone |
NA |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
30 |
DefaultWh |
Contains the number of the warehouse that may be used as the default for creating cross-dock masks. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
31 |
StopOrderDays |
Contains the number of days before a store closing when the store will stop accepting orders. This column is used when the store_close_date is defined. |
Number |
3 |
NA |
NA |
NA |
Ignored. |
|
|
32 |
StartOrderDays |
Contains the number of days before the store_open_date that the store will begin accepting orders. Data will always be present in this field. for creation and modification records. |
Number |
3 |
NA |
NA |
NA |
Ignored. |
|
|
33 |
CurrencyCode |
This field contains the currency code under which the store operates. Data will always be present in this field. for creation and modification records. |
Character |
3 |
loc_rtl_loc |
CURRENCY_ID |
VARCHAR(3) |
ISO Currency Code. |
|
|
34 |
StoreLangISOCode |
This column identifies the language to be used for the given store. Data will always be present in this field for creation and modification records. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
35 |
TranNoGenerate |
Contains the level at which unique POS transaction numbers are generated. If the store has one sequence number that is used for all registers, then the value in this column will be S (Store). Otherwise, the store has unique sequence numbers for each register and the value in this column will be R (Register). Data will always be present in this field for creation and modification records. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
36 |
IntPOSInd |
Indicates whether or not the POS system at the store is integrated. Data will always be present in this field for creation and modification records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
37 |
DunsNumber |
This field holds the Dun and Bradstreet (D&B) number to identify the store. A D&B number is a unique identification number for each physical location of a business. A DUNS number may be issued to any business worldwide, and is required by many credit reporting, national government, and trade organizations. Data in this field is optional. |
Character |
9 |
NA |
NA |
NA |
Ignored. |
|
|
38 |
DunsLoc |
Legacy, generally not used. Data in this field is optional. |
Character |
4 |
NA |
NA |
NA |
Ignored. |
|
|
39 |
SisterStore |
This field holds a store number which is used to relate the current store to the historical data of an existing store. Data in this field is optional. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
40 |
TsfEntityId |
Data in this field is optional. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
41 |
OrgUnitId |
Column contains the organizational unit ID value. Data in this field is optional. |
Number |
15 |
NA |
NA |
NA |
Ignored. |
|
|
42 |
AutoRcv |
This column indicates whether the client is allowing automatic receipt for the store. Valid values are Y (Yes), N (No), and D (System Default). Default value should be D. Data will always be present in this field for creation and modification records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
43 |
RemerchInd |
Identifies stores that are undergoing a significant re-merchandising effort. Defaults to N. Other values may be present if AIP is integrated with RMS. Data will always be present in this field for creation and modification records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
44 |
StoreType |
This indicates whether a particular store is a franchise (F) or company store (C). Data will always be present in this field for creation and modification records. |
Character |
6 |
NA |
NA |
NA |
Ignored. |
|
|
45 |
WFCustomer |
Numeric ID of the customer. Data in this field is optional. |
Number |
10 |
NA |
NA |
NA |
Ignored. |
|
|
46 |
Timezone |
Indicates the time zone of the store. For example, America/New_York. Data will always be present in this field for creation and modification records. |
Character |
64 |
NA |
NA |
NA |
Ignored. |
|
|
47 |
CustomerOrderLocInd |
This column determines whether the location is a customer order location. If the indicator is Y, the location can be used by OMS for sourcing/ fulfillment or both. Otherwise, it cannot be used. It is used only for the company stores. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
STORE_NBR |
VARCHAR(254) |
Always RMS StoreId. |
||
|
NA |
NA |
NA |
NA |
loc_rtl_loc, tax_rtl_loc_tax_mapping |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses the default value. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
LOCATION_TYPE |
VARCHAR(60) |
STORE |
Value can be configured in dataloader-beans-xml. If not configured, then null. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
use_till_accountability_flag |
NUMBER(1,0) |
FALSE |
Value can be configured in dataloader-beans-xml. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type = STOREMOD. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
CREATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when Type = STOREMOD. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Always set. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Always set. |
|
Table B-11 describes the Store Address mapping.
Table B-11 RMS Store Address Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always STORES. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: STOREDTLCRE Creation of store address information. STOREDTLMOD Modification of store address information. STOREDTLDEL Deletion of store address information. Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. FULL, STOREDTLCRE, and STOREDTLMOD are all interpreted as updates to an existing loc_rtl_loc record. STOREDTLDEL results in the setting of all non-PK address mapped fields with an empty string. |
|
|
2 |
StoreId |
Contains the unique ID of the store. Data will always be present in this field. |
Number |
10 |
loc_rtl_loc |
RTL_LOC_ID |
NUMBER(10,0) |
NA |
|
|
3 |
AddrType |
Contains the code used to identify the address type. Data will always be present in this field. |
Character |
2 |
NA |
NA |
NA |
Must match the configurable AddrType code, otherwise record is ignored. |
|
|
4 |
AddrTypeDesc |
Description of the address type code. Common examples include: 01 - Business, 02 - Postal, 03 - Returns, 04 - Order, 05 - Invoice, 06 - Remittance Optional. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
5 |
PrimaryAddrInd |
Indicates whether the address is the primary address for the address type. Valid values are Y and N. Data will always be present in this field. |
Character |
1 |
NA |
NA |
NA |
If not Y, the entire record is ignored. |
|
|
6 |
Add1 |
Contains the first line of the address. Data will always be present in this field for STOREDTLCRE and STOREDTLMOD. |
Character |
240 |
loc_rtl_loc |
ADDRESS1 |
VARCHAR2(254 CHAR) |
NA |
|
|
7 |
Add2 |
Contains the second line of the address. Optional. |
Character |
240 |
loc_rtl_loc |
ADDRESS2 |
VARCHAR2(254 CHAR) |
NA |
|
|
8 |
Add3 |
Contains the third line of the address. Optional. |
Character |
240 |
loc_rtl_loc |
ADDRESS3 |
VARCHAR2(254 CHAR) |
NA |
|
|
9 |
City |
Contains the name of the city that is associated with the address. Data will always be present in this field for STOREDTLCRE and STOREDTLMOD. |
Character |
120 |
loc_rtl_loc |
CITY |
VARCHAR2(30 CHAR) |
NA |
|
|
10 |
County |
Contains the county name for the location. Optional. |
Character |
250 |
NA |
NA |
NA |
NA |
|
|
11 |
State |
Contains the state abbreviation for the address. Optional. |
Character |
3 |
loc_rtl_loc |
STATE |
VARCHAR2(30 CHAR) |
NA |
|
|
12 |
Country |
Contains the country where the address exists, using ISO 3166-1 alpha-2. Data will always be present in this field for STOREDTLCRE and STOREDTLMOD. |
Character |
3 |
loc_rtl_loc |
COUNTRY |
VARCHAR2(254 CHAR) |
NA |
|
|
13 |
PostCode |
Contains the postal code name for the location. Optional. |
Character |
30 |
loc_rtl_loc |
POSTAL_CODE |
VARCHAR2(30 CHAR) |
NA |
|
|
14 |
JurisdictionCode |
Contains the tax jurisdiction code for the location. Optional. |
Character |
10 |
NA |
NA |
NA |
Ignored. |
|
|
15 |
ContactName |
Contains the name of the contact person at this address. Optional. |
Character |
120 |
NA |
NA |
NA |
Ignored. |
|
|
16 |
ContactPhone |
Contains a phone number of the contact person at this address. Optional. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
17 |
ContactFax |
Contains a fax number of the contact person at this address. Optional. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
18 |
ContactEmail |
Contains an email for the contact person at this address. Optional. |
Character |
100 |
NA |
NA |
NA |
Ignored. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
NA |
|
|
NA |
NA |
NA |
NA |
loc_rtl_loc |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
NA |
|
Table B-12 describes the RMS VAT mapping.
Table B-12 RMS VAT Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always VAT. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: VATCRE - Creation of VAT information. VATMOD - Modification of VAT information. VATDEL - Deletion of VAT information. Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines action. |
|
|
2 |
VatRegion |
ID of the VAT region. Stores are assigned to a VAT region (if VAT is used in RMS). This field will always have data. |
Number |
4 |
tax_tax_loc, tax_tax_authority, tax_tax_group_rule, tax_tax_rate_rule |
TAX_LOC_ID, TAX_AUTHORITY_ID |
VARCHAR2(60 CHAR) |
Use RMS VAT region ID as the tax authority ID in Xstore. |
|
|
3 |
VatRegionName |
This field contains the alphanumeric identification for the VAT code. Valid values include, but are not limited to: S - Standard C - Composite Z - Zero E - Exempt This field will always have data. |
Character |
120 |
tax_tax_loc, tax_tax_authority |
NAME, DESCRIPTION |
VARCHAR(254) |
Use RMS VAT region name as the tax authority name in Xstore. |
|
|
4 |
VatCode |
This field contains the description of the VAT Code. This field will always have data in the VATCRE and VATMOD records. |
Character |
6 |
tax_tax_group, tax_tax_group_rule, tax_tax_rate_rule |
TAX_GROUP_ID |
VARCHAR(60) |
NA |
|
|
5 |
VatCodeDesc |
This field contains the description of the VAT Code. This field will always have data in the VATCRE and VATMOD records. |
Character |
120 |
tax_tax_group, tax_tax_group_rule |
NAME, DESCRIPTION |
VARCHAR(254) |
For the root COMPANY node, the column is hard-coded as null. For the second level CHAIN node, the column is hard-coded to "*". |
|
|
6 |
ActiveDate |
This field is the date the VAT code is active for the VAT region, in human readable format DD-MON-YYYY. This field will always have data. |
Character |
12 |
tax_tax_rate_rule |
PERCENTAGE |
NUMBER(8,6) |
NA |
|
|
7 |
VatRate |
VAT rate for the VAT code/VAT region. This field will always have data in the VATCRE and VATMOD records. |
Number |
20 |
tax_tax_rate_rule |
EFFECTIVE_DATETIME |
TIMESTAMP(6) |
NA |
|
|
NA |
NA |
NA |
NA |
tax_tax_group_rule |
TAX_TYPCODE |
VARCHAR(30) |
VAT |
Always uses default value. |
|
|
NA |
NA |
NA |
NA |
tax_tax_group_rule |
TAX_RULE_SEQ_NBR |
NUMBER(10,0) |
1 |
Always uses default value. The assumption is that there can only be one tax rule per VAT region/VAT code combination. |
|
|
NA |
NA |
NA |
NA |
tax_tax_group_rule |
TAXED_AT_TRANS_LEVEL_FLAG |
NUMBER(1,0) |
TRUE |
A configuration spring loaded by the transformer. The out-of-box default is TRUE. |
|
|
NA |
NA |
NA |
NA |
tax_tax_rate_rule |
EXPR_DATETIME |
TIMESTAMP(6) |
This has to be derived by the integration layer. During a CRE/FULL, if there is a subsequent rate rule as sorted by effective date, expire this rate rule by setting its expiration date to be 1 millisecond less than the effective date of the subsequent rate rule; otherwise do not expire this rate rule by setting its expiration date to NULL. During a CRE/FULL, if there is a prior rate rule as sorted by effective date, expire the prior rate rule by setting its expiration date to be 1 millisecond less than this effective date. |
||
|
EXPR_DATETIME (Continued) |
During a DEL, if there is a prior rate rule as sorted by effective date, extend the prior rate rule by setting its expiration date to be the expiration date of this rate rule. |
||||||||
|
NA |
NA |
NA |
NA |
tax_tax_rate_rule |
TAX_RULE_SEQ_NBR |
1 |
Always uses the default value. The assumption is that there can only be one tax rule per VAT region/VAT code combination. |
||
|
NA |
NA |
NA |
NA |
tax_tax_rate_rule |
TAX_RATE_RULE_SEQ |
NUMBER(10,0) |
This has to be derived by the integration layer. For a newly created VAT rate, its sequence number is one after the maximum rate rule sequence number in the table. |
||
|
NA |
NA |
NA |
NA |
tax_tax_authority |
ROUNDING_CODE |
VARCHAR(30) |
HALF_UP |
A configuration spring loaded by the transformer. The out-of-box default is HALF_UP. |
|
|
NA |
NA |
NA |
NA |
tax_tax_authority |
ROUNDING_DIGITS_QUANTITY |
NUMBER(10,0) |
2 |
A configuration spring loaded by the transformer. The out-of-box default is 2. |
|
|
NA |
NA |
NA |
NA |
tax_tax_loc, tax_tax_authority, tax_tax_group, tax_tax_group_rule, tax_tax_rate_rule |
EXTERNAL_SYSTEM |
VARCHAR(30) |
RMS |
Always uses the default value. |
|
|
NA |
NA |
NA |
NA |
tax_tax_loc, tax_tax_authority, tax_tax_group, tax_tax_group_rule, tax_tax_rate_rule |
ORG_CODE |
VARCHAR(30) |
* |
Always uses the default value. |
|
|
NA |
NA |
NA |
NA |
tax_tax_loc, tax_tax_authority, tax_tax_group, tax_tax_group_rule, tax_tax_rate_rule |
ORG_VALUE |
VARCHAR(60) |
* |
Always uses the default value. |
|
|
NA |
NA |
NA |
NA |
tax_tax_loc, tax_tax_authority, tax_tax_group, tax_tax_group_rule, tax_tax_rate_rule |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses the default value. |
|
|
NA |
NA |
NA |
NA |
tax_tax_loc, tax_tax_authority, tax_tax_group, tax_tax_group_rule, tax_tax_rate_rule |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type represents UPDATE. |
|
|
NA |
NA |
NA |
NA |
tax_tax_loc, tax_tax_authority, tax_tax_group, tax_tax_group_rule, tax_tax_rate_rule |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Not set when Type represents CREATE. |
|
Table B-13 describes the RMS VAT Item mapping.
|
Note: Do not import a.dat file containing multiple VATITEM records with the same item ID. More than one record for the same item ID could result in an undesired outcome. |
Table B-13 RMS VAT Item Mapping
| RMS | Xstore | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Max Width | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Family |
Value is always VATITEM. Data will always be present in this field. |
Character |
20 |
NA |
NA |
NA |
Ignored. |
|
|
1 |
Type |
Value is always FULL when the program is run in full mode. If the program is run in delta mode, the type will vary based on the type of change (CRE, MOD, DEL). Valid values are: VATITEMCRE- Creation of VAT Item information. VATITEMMOD - Modification of VAT Item information. VATITEMDEL - Deletion of VAT Item information. Data will always be present in this field. |
Character |
15 |
NA |
NA |
NA |
Determines actions. |
|
|
2 |
Item |
ID of the item. Data will always be present in this field. |
Character |
25 |
itm_item_options |
item_id |
VARCHAR(60 CHAR) |
NA |
|
|
3 |
VatRegion |
ID of the VAT region. Stores are assigned to a VAT region if VAT is used in RMS. Additional information about VAT Regions is stored in RMS, but is not integrated out of the system. VAT region information may need to the synchronized to downstream systems as a manual process. This field will always have data. |
Number |
4 |
NA |
NA |
NA |
Ignored. |
|
|
4 |
ActiveDate |
Date that the VAT rate becomes active, in DD-MON-YYYY format. This field will always have data in the VATITEMCRE and VATITEMMOD records. |
Character |
11 |
NA |
NA |
NA |
Ignored. |
|
|
5 |
VatType |
The field describes what the VAT rate applies to: C - Cost values R - Retail values B - Both Cost and Retail values This field will always have data. |
Character |
1 |
NA |
NA |
NA |
Record ignored when VatType=C. |
|
|
6 |
VatCode |
This field contains the alphanumeric identification for the VAT code. Valid values include, but are not limited to: S - Standard C - Composite Z - Zero E - Exempt If additional VAT Codes are defined in RMS, the VAT code information may need to the synchronized to downstream systems as a manual process. This field will always have data. |
Character |
6 |
itm_item_options |
tax_group_id |
VARCHAR(60) |
Column tax_group_id is set to null if Type is VATITEMDEL. Column tax_group_id is unchanged when VatType is C. Otherwise, column tax_group_id is set to the value of the VatCode. |
|
|
7 |
VatRate |
VAT rate for the item/VAT region. This field will always have data in the VATITEMCRE and VATITEMMOD records. |
Number |
20 |
NA |
NA |
NA |
Ignored. |
|
|
8 |
ReverseVatInd |
Indicates if the item is subject to reverse charge VAT at the VAT region. VAT reversal can apply to invoices on some items in some VAT regions. Valid values are Y and N. This field will always have data in the VATITEMCRE and VATITEMMOD records. |
Character |
1 |
NA |
NA |
NA |
Ignored. |
|
|
NA |
NA |
NA |
NA |
itm_item_options |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
NA |
|
|
NA |
NA |
NA |
NA |
itm_item_options |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
NA |
|
The following tables describe the RPM Clearance Price mapping.
Table B-14 describes the Clearance Price FDETL record mapping. FDETL records are interpreted as Create or Update events.
Table B-14 RPM Clearance Price FDETL Record Mapping
| RPM | Xstore | |||||||
|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Record Descriptor |
File Detail Marker (1 per clearance create/modify) |
Char(5) |
NA |
NA |
NA |
Used to determine unit type. |
|
|
1 |
Line Id |
Unique line identification |
Number(10) |
NA |
NA |
NA |
Ignored. |
|
|
2 |
Event Type |
CRE = Create, MOD = Modify |
Char(3) |
NA |
NA |
NA |
Used to determine the action type. |
|
|
3 |
Id |
Clearance identifier |
Number(15) |
itm_item_prices |
EXTERNAL_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
4 |
Item |
Item identifier |
Char(25) |
itm_item_prices |
ITEM_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
5 |
Effective Date |
Clearance Effective Date (YYYYMMDDHH24MISS) |
Date |
itm_item_prices |
EFFECTIVE_DATE |
TIMESTAMP(6) |
NA |
|
|
6 |
Selling Retail |
Selling retail with price change applied |
Number(20,4) |
itm_item_prices |
PRICE |
NUMBER(17,6) |
NA |
|
|
7 |
Selling Retail UOM |
Selling retail unit of measure |
Char(4) |
NA |
NA |
NA |
Ignored |
|
|
8 |
Selling Retail Currency |
Selling retail currency |
Char(3) |
NA |
NA |
NA |
Ignored (assumed to be base Currency). |
|
|
9 |
Reset Clearance ID |
Clearance reset identification |
Number(15) |
NA |
NA |
NA |
Used to detect clearance reset. Clearance reset is when this value exactly matches the ID field's value. |
|
|
NA |
NA |
NA |
itm_item_prices |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
itm_item_prices |
PROPERTY_CODE |
VARCHAR2(60 CHAR) |
CLEARANCE_PRICE when Clearance event, or REGULAR_PRICE when Clearance Reset event. |
||
|
NA |
NA |
NA |
itm_item_prices |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Not set when EventType = Mod. |
|
|
NA |
NA |
NA |
itm_item_prices |
CREATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Not set when EventType = Mod. |
|
|
NA |
NA |
NA |
itm_item_prices |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Always set. |
|
|
NA |
NA |
NA |
itm_item_prices |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
Always set. |
|
|
NA |
NA |
NA |
itm_item_prices |
EXTERNAL_SYSTEM |
VARCHAR2(60 CHAR) |
RPM-CLRPC |
NA |
|
Table B-15 describes the Clearance Price FDELE record mapping. FDELE records are interpreted as Delete events.
Table B-15 RPM Clearance Price FDELE Record Mapping
| RPM | Xstore | |||||||
|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Record Descriptor |
File Detail Delete Marker (1per clearance delete) |
Char(5) |
NA |
NA |
NA |
Used to determine unit type. |
|
|
1 |
Line Id |
Unique line identification |
Number(10) |
NA |
NA |
NA |
Ignored. |
|
|
2 |
Id |
Clearance identifier |
Number(15) |
itm_item_prices |
EXTERNAL_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
3 |
Item |
Item identifier |
Char(25) |
itm_item_prices |
ITEM_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
NA |
NA |
NA |
itm_item_prices |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses default value. |
|
|
NA |
NA |
NA |
itm_item_prices |
EXTERNAL_SYSTEM |
VARCHAR2(60 CHAR) |
RPM-CLRPC |
NA |
|
The following tables describe the RPM Regular Price mapping.
Table B-16 describes the Regular Price FDETL record mapping. FDETL records are interpreted as Create or Update events.
Table B-16 RPM Regular Price FDETL Record Mapping
| RPM | Xstore | |||||||
|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Record Descriptor |
File Detail Marker (1 per price change create or modify) |
Char(5) |
NA |
NA |
NA |
Type of event. |
|
|
1 |
Line Id |
Unique line identification |
Number(10) |
NA |
NA |
NA |
Ignored. |
|
|
2 |
Event Type |
CRE = Create, MOD = Modify |
Char(3) |
NA |
NA |
NA |
Used by the transformer to determine the type of event. |
|
|
3 |
Id |
Price change identifier |
Number(15) |
itm_item_prices |
EXTERNAL_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
4 |
Item |
Item identifier |
Char(25) |
itm_item_prices |
ITEM_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
5 |
Effective Date |
Effective Date of the price change (YYYYMMDDHH24MISS) |
NA |
itm_item_prices |
EFFECTIVE_DATE |
TIMESTAMP(6) |
NA |
|
|
6 |
Selling Unit Change Ind |
Indicates whether the selling unit retail changed with this price event (0 = no change, 1 = changed). |
Number(1) |
NA |
NA |
NA |
This field need not be persisted in the Xstore database. This field is used in transformer logic. |
|
|
7 |
Selling Retail |
Selling retail with price change applied |
Number(20,4) |
itm_item_prices |
PRICE |
NUMBER(17,6) |
NA |
|
|
8 |
Selling Retail UOM |
Selling retail unit of measure |
Char(4) |
itm_item |
UNIT_OF_MEASURE_CODE |
VARCHAR2(30 BYTE) |
Ignored. |
|
|
9 |
Selling Retail Currency |
Selling retail currency |
Char(3) |
NA |
NA |
NA |
Ignored (assumed to be base Currency). |
|
|
10 |
Multi-Unit Change Ind |
Did multi-unit retail change with this price event (0 = no change, 1 = changed) |
Number(1) |
NA |
NA |
NA |
NA |
|
|
11 |
Multi-Units |
NA |
Number(12,4) |
NA |
NA |
NA |
NA |
|
|
12 |
Multi-Unit Retail |
Number of multi-units |
Number(20,4) |
NA |
NA |
NA |
NA |
|
|
13 |
Multi-Unit UOM |
Multi-Unit Retail unit of measure |
Char(4) |
NA |
NA |
NA |
NA |
|
|
14 |
Multi-Unit Currency |
Multi-Unit Retail Currency |
Char(3) |
NA |
NA |
NA |
NA |
|
|
NA |
NA |
NA |
itm_item_prices |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
Always uses the default value. |
|
|
NA |
NA |
NA |
itm_item_prices |
PROPERTY_CODE |
VARCHAR2(60 CHAR) |
REGULAR_PRICE will be the value. |
||
|
NA |
NA |
NA |
itm_item_prices |
CREATE_DATE |
TIMESTAMP(6) |
now() |
Current time stamp. Not set when the event type =MOD. |
|
|
NA |
NA |
NA |
itm_item_prices |
CREATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
This is the user ID stored in the database.Not set when event type = Mod. |
|
|
NA |
NA |
NA |
itm_item_prices |
UPDATE_DATE |
TIMESTAMP(6) |
now() |
Current time stamp. Field value only set when event type=MOD. |
|
|
NA |
NA |
NA |
itm_item_prices |
UPDATE_USER_ID |
VARCHAR2(30 CHAR) |
DATALOADER |
DATALOADER will be the user ID stored in the database. Set only when the event type=MOD. |
|
|
NA |
NA |
NA |
itm_item_prices |
EXTERNAL_SYSTEM |
VARCHAR2(60 CHAR) |
RPM-REGPC |
NA |
|
Table B-17 describes the Regular Price FDELE record mapping. FDELE records are interpreted as Delete events.
Table B-17 RPM Regular Price FDELE Record Mapping
| RPM | Xstore | |||||||
|---|---|---|---|---|---|---|---|---|
| Field Name | Description | Field Type | Table | Column | Data Type | Default Value | Comment | |
|
0 |
Record Descriptor |
File Detail Delete Marker (1per price change delete) |
Char(5) |
NA |
NA |
NA |
Used by the transformer to determine the unit type. |
|
|
1 |
Line Id |
Unique line identification |
Number(10) |
NA |
NA |
NA |
Ignored. |
|
|
2 |
Id |
Price change identifier |
Number(15) |
itm_item_prices |
EXTERNAL_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
3 |
Item |
Item identifier |
Char(25) |
itm_item_prices |
ITEM_ID |
VARCHAR2(60 CHAR) |
NA |
|
|
NA |
NA |
NA |
itm_item_prices |
ORGANIZATION_ID |
NUMBER(10,0) |
${dtv.location.organizationId} |
NA |
|
|
NA |
NA |
NA |
itm_item_prices |
EXTERNAL_SYSTEM |
VARCHAR2(60 CHAR) |
RPM-CLRPC |
NA |
|
Table B-18 describes the RPM Promotions mapping.
Table B-18 RPM Promotions Record Mappings
| RPM | Xstore | ||||||
|---|---|---|---|---|---|---|---|
| Record Name | Field Name | Field Type | Default Value | Description | Table | Field | Comment |
|
FHEAD |
Record Descriptor |
Char(5) |
FHEAD |
File head marker |
NA |
NA |
NA |
|
Line ID |
Number(10) |
1 |
Unique line identifier |
NA |
NA |
NA |
|
|
File Type |
Char(5) |
PROMO |
Promotions |
NA |
NA |
NA |
|
|
Export Timestamp |
Number(10) |
System clock timestamp (YYYYMMDDHHMISS) |
NA |
NA |
NA |
||
|
Format Version |
Char(5) |
1.0 |
File Format Version |
NA |
NA |
NA |
|
|
Location |
Number(10) |
Location identifier |
NA |
NA |
NA |
||
|
Location Type |
Char(1) |
S = Store, W = Warehouse |
NA |
NA |
NA |
||
|
TIMBPE |
Record Descriptor |
Char(5) |
TIMPBE |
Promotion (transaction head). Defines an action associated with a promotion. |
NA |
NA |
NA |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
NA |
||
|
Event Type |
Char(3) |
CRE = Create, MOD = Modify |
NA |
NA |
NA |
||
|
TPDTL |
Record Descriptor |
Char(5) |
TPDTL |
Promotion Detail Component. Defines a new component. |
NA |
NA |
Ignored. |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
Promo ID |
Number(10) |
Promotion identifier |
prc_deal |
deal_id (partially) |
NA |
||
|
Promo Comp ID |
Number(10) |
Promotion Component Id |
prc_deal |
deal_id (partially) |
NA |
||
|
Promo Name |
Char(160) |
Promotion Header Name |
NA |
NA |
Ignored. |
||
|
Promo Desc |
Char(640) |
Promotion Header Description |
NA |
NA |
Ignored. |
||
|
Promo Comp Desc |
Char(160) |
Promotion Component Name |
prc_deal |
description |
NA |
||
|
Promo Type |
Number(2) |
Valid values: 0 = Multi-Buy Promotion 1=- Simple Promotion 2 = Threshold Promotion 3 = Finance Promotion (formerly tied to a value of 6) 4 = Transaction Promotion |
NA |
NA |
Determines structure of resulting deal |
||
|
Promo Comp Detail ID |
Number(10) |
Promotion Component Detail identifier |
prc_deal |
deal_id (partially) |
NA |
||
|
Date Start |
Date |
Start Date of Promotion Component Detail (YYYYMMDDHH24MISS) |
prc_deal |
effective_date |
NA |
||
|
End Date |
Date |
End Date of Promotion Component Detail (YYYYMMDDHH24MISS) |
prc_deal |
end_date |
NA |
||
|
Apply to Code |
Number(1) |
Holds the Apply to Code for the promotion detail. Determines if the promotion is applied to regular retail only (no clearances in effect), clearance retail only (only when a clearance is in effect), or both regular and clearance retail. Valid values: 0 = Regular Only 1 = Clearance Only 2 = Regular and Clearance |
prc_field_test |
NA |
ApplyTo is mapped to an additional field test (PRICE BETWEEN X Y). |
||
|
Discount Limit |
Number(3) |
The number of times that the promotion can be applied to a transaction. |
prc_deal |
iterationCap |
NA |
||
|
Apply Order |
Number(1) |
Application Order of the Promotion |
NA |
NA |
Ignored. |
||
|
Threshold ID |
Number(6) |
Threshold identifier |
NA |
NA |
Ignored. |
||
|
Customer Type ID |
Number(10) |
Customer Type identifier |
NA |
NA |
Ignored. |
||
|
Threshold Qualification Type |
Number(1) |
The qualification type for the threshold. Will only be populated for threshold promotions. Valid values are 0 for item level and 1 for threshold level. |
NA |
NA |
Ignored. |
||
|
TPGRP |
Record Descriptor |
Char(5) |
TPGRP |
Promotion Detail Group |
NA |
NA |
Ignored. |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
Group ID |
Number(10) |
Group Number |
prc_deal_item |
ordinal |
Mapped structurally, not by value. |
||
|
TGLIST |
Record Descriptor |
Char(5) |
TGLIST |
Promotion Group List. Defines an item list. |
NA |
NA |
Ignored. |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
List ID |
Number(10) |
List identifier |
NA |
NA |
Ignored. |
||
|
Reward Application |
Number(1) |
How this reward is applied to the promotion detail. |
NA |
NA |
Not mapped directly, but rather used to determine whether an action from the underlying TPDSC record should be used. |
||
|
Description |
Char(120) |
Description |
NA |
NA |
Ignored. |
||
|
Price Range Min |
Number(20,4) |
Contains price range promotion minimum valid retail value. |
prc_deal_field_test |
NA |
Mapped to an additional field test (PRICE BETWEEN X Y). |
||
|
Price Range Max |
Number(20,4) |
Contains price range promotion maximum valid retail value. |
prc_deal_field_test |
NA |
Mapped to an additional field test (PRICE BETWEEN X Y). |
||
|
TLITM |
Record Descriptor |
Char(5) |
TLITM |
Promotion Group List. RPM defines lists by providing SKUs of eligible items. |
NA |
NA |
Ignored. |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
Item ID |
Char(25) |
Transaction Item Identifier |
prc_deal_field_test |
value1 |
Mapped as SKU EQUAL field test. |
||
|
TPDSC |
Record Descriptor |
Char(5) |
TPDSC |
Discount Detail for List. Defines a discount to apply to a preceding list of items. |
NA |
NA |
Ignored. |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
Change Type |
Number(2) |
Change Type Valid values: -1 = No Change 0 = Percent Off 1 = Amount Off 2 = Fixed Price |
prc_deal_item |
action |
Type of action: AMOUNT_OFF > CURRENCY_OFF PERCENT_OFF > PERCENT_OFF FIXED_PRICE > NEW_PRICE |
||
|
Change Amount |
Number(20,4) |
Change Amount |
prc_deal_item |
action_arg |
Discount amount when Change Type is AMOUNT_OFF or FIXED_PRICE. Negated for AMOUNT_OFF. |
||
|
Change Currency |
Char(3) |
Change Currency |
NA |
NA |
Ignored. |
||
|
Change Percent |
Number(20,4) |
Change Percent |
prc_deal_item |
action_arg |
Discount amount when Change Type is PERCENT_OFF. Negated. |
||
|
Change Selling UOM |
Char(4) |
Change Selling UOM |
NA |
NA |
Ignored. |
||
|
Qual Type |
Number(2) |
Qualification Type |
NA |
NA |
Affects where the Qual Value goes. |
||
|
Qual Value |
Number(2) |
Qualification Value |
prc_deal_item |
min_qty / max_qty or min_item_total |
Target field is picked based on the Qual Type value. PRC_DEAL_ITEM.max_qty either gets the same value or receives some big number depending on the deal type. |
||
|
Change Duration |
Number(20,4) |
Change Duration |
NA |
NA |
Ignored. |
||
|
TPISR |
Record Descriptor |
Char(5) |
TPISR |
This record type is ignored for now. |
NA |
NA |
Ignored. |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
Item ID |
Char(25) |
Transaction Item Identifier |
NA |
NA |
Ignored. |
||
|
Selling Retail |
Number(20,4) |
Selling retail of the item |
NA |
NA |
Ignored. |
||
|
Selling UOM |
Char(4) |
Selling UOM of the item |
NA |
NA |
Ignored. |
||
|
Effective Date |
Date |
Effective Date of the selling retail - YYYYMMDDHH24MISS |
NA |
NA |
Ignored. |
||
|
Selling Retail Currency |
Char(3) |
Selling retail currency |
NA |
NA |
Ignored. |
||
|
TPCDT |
Record Descriptor |
Char(5) |
TPCDT |
Credit Detail |
NA |
NA |
Ignored. |
|
Credit Detail ID |
Number(10) |
Credit Detail Identifier |
NA |
NA |
Ignored. |
||
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
Credit Type |
Char(40) |
Credit Type |
NA |
NA |
Ignored. |
||
|
binNumberFrom |
Number(10) |
Bin Number From |
NA |
NA |
Ignored. |
||
|
binNumberTo |
Number(10) |
Bin Number To |
NA |
NA |
Ignored. |
||
|
Commission Rate |
Number(10) |
Commission Rate |
NA |
NA |
Ignored. |
||
|
Comments |
Char(160) |
Comments |
NA |
NA |
Ignored. |
||
|
TPCIL |
Record Descriptor |
Char(5) |
TPCIL |
Cancel Item Loc |
NA |
NA |
Ignored. |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
Ignored. |
||
|
Promo ID |
Number(10) |
Identifier of the promotion |
NA |
NA |
Ignored. |
||
|
Promo Comp ID |
Number(10) |
Promotion Component Identifier |
NA |
NA |
Ignored. |
||
|
Promo Comp Detail ID |
Number(10) |
Promotion Component Detail identifier |
NA |
NA |
Ignored. |
||
|
Item ID |
Char(25) |
Transaction Item Identifier for item |
NA |
NA |
Ignored. |
||
|
Cancellation Date |
Date |
Cancellation effective date - YYYYMMDDHH24MISS |
NA |
NA |
Ignored. |
||
|
TTAIL |
Record Descriptor |
Char(5) |
TTAIL |
Transaction Tail |
NA |
NA |
NA |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
NA |
||
|
FPDEL |
Record Descriptor |
Char(5) |
FPDEL |
Delete Promotion |
NA |
NA |
NA |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
NA |
||
|
Promo ID |
Number(10) |
The ID of the promotion |
NA |
NA |
NA |
||
|
Promo Comp ID |
Number(10) |
Promotion Component Identifier |
NA |
NA |
NA |
||
|
Promo Comp Detail ID |
Number(10) |
Promotion Component Detail identifier |
NA |
NA |
NA |
||
|
Group ID |
Number(10) |
Group Number |
NA |
NA |
NA |
||
|
List ID |
Number(10) |
List identifier |
NA |
NA |
NA |
||
|
Item ID |
Char(25) |
Transaction Item Identifier for item |
NA |
NA |
NA |
||
|
FTAIL |
Record Descriptor |
Char(5) |
FTAIL |
File tail marker |
NA |
NA |
NA |
|
Line ID |
Number(10) |
Unique line identifier |
NA |
NA |
NA |
||
|
Number of lines |
Number(10) |
Number of lines in the file not including FHEAD and FTAIL |
NA |
NA |
NA |
||
