Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffDesc

XML-Schema Name:DiffDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiffDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description diff_id varchar210 1 1 This field will hold a unique number (identifier) of the differentiator. DIFF DIFF_ID RIB VARCHAR2(10 BYTE) Yes This field will hold a unique number (identifier) of the differentiator. diff_type varchar26 1 1 This field holds a value of all possible differential types. Valid values are stored in the code_detail table with the code_type of 'DIFF'. Valid values are also found in the diff_type table. DIFF DIFF_TYPE RIB VARCHAR2(6 BYTE) Yes This field holds a value of all possible differential type. diff_desc varchar2120 1 1 Not Yet Available DIFF DIFF_DESC RIB VARCHAR2(120 BYTE) Yes Diff Description industry_code varchar210 0 1 A unique number that represents all possible combinations of sizes according to the National Retail Federation. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. industry_subcode varchar210 0 1 A unique number that represents all different color range groups. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_type_desc varchar2120 0 1 This field holds the description of the diff type. DIFF DIFF_TYPE_DESC RIB VARCHAR2(120 BYTE) Yes This field holds the description of the diff type.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpDtlDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpDtlDesc

XML-Schema Name:DiffGrpDtlDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiffGrpDtlDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description diff_group_id varchar210 1 1 Contains the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table. DIFF_GRP_DTL DIFF_GROUP_ID RIB VARCHAR2(10 BYTE) Yes Contains the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table. diff_id varchar210 1 1 Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table. DIFF_GRP_DTL DIFF_ID RIB VARCHAR2(10 BYTE) Yes Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table. display_seq number4 0 1 This field contains the display sequence for the differential. DIFF_GRP_DTL DISPLAY_SEQ RIB NUMBER(4,0) No This field contains the display sequence for the differential.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpDtlRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpDtlRef

XML-Schema Name:DiffGrpDtlRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiffGrpDtlRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description diff_group_id varchar210 1 1 Contains the value of the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table. DIFF_GRP_DTL DIFF_GROUP_ID RIB VARCHAR2(10 BYTE) Yes Contains the value of the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table. diff_id varchar210 1 1 Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table. DIFF_GRP_DTL DIFF_ID RIB Fill column length. Yes Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpHdrDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpHdrDesc

XML-Schema Name:DiffGrpHdrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiffGrpHdrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description diff_group_id varchar210 1 1 Description is not available. DIFF_GRP DIFF_GROUP_ID RIB VARCHAR2(10 BYTE) Yes Identifier for the DIFF Group diff_group_type varchar26 1 1 Description is not available. DIFF_GRP DIFF_TYPE_ID RIB VARCHAR2(6 BYTE) Yes Identifer for the Diff Type diff_group_desc varchar2120 1 1 Description is not available. DIFF_GRP DIFF_GROUP_DESC RIB VARCHAR2(120 BYTE) Yes Description of the differentiator group diff_group_type_desc varchar2120 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpRef

XML-Schema Name:DiffGrpRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiffGrpRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description diff_group_id varchar210 1 1 This field holds a unique number (identifier) of the differential group. DIFF_GRP DIFF_GROUP_ID RIB VARCHAR2(10 BYTE) Yes Identifies the Diff Group

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffRef

XML-Schema Name:DiffRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiffRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description diff_id varchar210 1 1 Description is not available. DIFF DIFF_ID RIB VARCHAR2(10 BYTE) Yes Identifies a DIFF

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ISCDimRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ISCDimRef

XML-Schema Name:ISCDimRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ISCDimRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. origin_country varchar23 1 1 The country where the item was manufactured or significantly altered Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dim_object varchar26 1 1 Specific object whose dimensions are specified in this record. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemBOMRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemBOMRef

XML-Schema Name:ItemBOMRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemBOMRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description pack_no varchar225 1 1 mapped to AS_ITM_RTL_STR,RK_ITEM_SUPPLIER,RK_ITEM_SUPP_COUNTRY,CO_CLN_ITM,AS_ITM as well. Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item varchar225 1 1 mapped to AS_ITM_RTL_STR, RK_ITEM_SUPPLIER, RK_ITEM_SUPP_COUNTRY, CO_CLN_ITM, AS_ITM as well. Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemDesc ItemHdrDesc CustFlexAttriVo ItemHdrTlDesc ItemSupDesc CustFlexAttriVo ItemSupCtyDesc CustFlexAttriVo ISCDimDesc ItemUDALOVDesc ItemUDAFFDesc ItemUDADateDesc ItemImageDesc ItemUPCDesc ItemBOMDesc ItemTcktDesc ItemSupCtyMfrDesc RelatedItemDesc VatItemDesc ItemSupUomDesc

XML-Schema Name:ItemDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description ItemHdrDesc:ItemHdrDesc * 1 1 It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemSupDesc:ItemSupDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemSupCtyDesc:ItemSupCtyDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ISCDimDesc:ISCDimDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUDALOVDesc:ItemUDALOVDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUDAFFDesc:ItemUDAFFDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUDADateDesc:ItemUDADateDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemImageDesc:ItemImageDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUPCDesc:ItemUPCDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemBOMDesc:ItemBOMDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemTcktDesc:ItemTcktDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemSupCtyMfrDesc:ItemSupCtyMfrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA RelatedItemDesc:RelatedItemDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA VatItemDesc:VatItemDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemSupUomDesc:ItemSupUomDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:ItemHdrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemHdrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique alphanumeric value that identifies the item. ITEM_HDR ITEM RIB VARCHAR2(25 BYTE) Yes Unique alphanumeric value that identifies the item. item_number_type varchar26 1 1 This type can hold a number of digits count umber_type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. format_id varchar21 0 1 This field will hold the format ID that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. prefix number2 0 1 This column holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. It is the clients responsibility to download this value to their Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_parent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. ITEM_HDR ITEM_PARENT RIB VARCHAR2(25 BYTE) No Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. item_grandparent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table. ITEM_HDR ITEM_GRANDPARENT RIB VARCHAR2(25 BYTE) No Alphanumeric value that uniquely identifies the item/group two levels above the item. pack_ind varchar21 0 1 Indicates if the item is a pack. A pack item is a collection of items that may be either ordered or sold as a unit. Packs require details (i.e. component items and qtys, etc.) that other items do not. This field is required by the database. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_level number1 0 1 Number indicating 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 item level also determines how the item may be used throughout the system. ITEM_HDR ITEM_LEVEL RIB NUMBER(1,0) Yes Number indicating 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 item level also determines how the item may be used throughout the system. tran_level number1 0 1 Number indicating which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's inventory is tracked in the system. The transaction level item will be counted, transferred, shipped, etc. The transaction level may be at the current item or up to 2 levels above or below the current item. Only one level of the hierarchy of an item family may contain transaction level items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_1 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Men's pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. ITEM_HDR DIFF_1 RIB VARCHAR2(10 BYTE) No Diff_group or diff_id that differentiates the current item from its item_parent. diff_1_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. ITEM_HDR DIFF_1_TYPE RIB VARCHAR2(6 BYTE) No This field will hold a value of all possible differential types. diff_2 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. ITEM_HDR DIFF_2 RIB VARCHAR2(10 BYTE) No Diff_group or diff_id that differentiates the current item from its item_parent. diff_2_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. ITEM_HDR DIFF_2_TYPE RIB VARCHAR2(6 BYTE) No This field will hold a value of all possible differential types. diff_3 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. ITEM_HDR DIFF_3 RIB VARCHAR2(10 BYTE) No Diff_group or diff_id that differentiates the current item from its item_parent. diff_3_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. ITEM_HDR DIFF_3_TYPE RIB VARCHAR2(6 BYTE) No This field will hold a value of all possible differential types. diff_4 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_4_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 0 1 Number identifying the department to which the item is attached. The item's department will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the deps table. ITEM_HDR DEPT RIB NUMBER(4,0) Yes Number identifying the department to which the item is attached. dept_name varchar2120 0 1 Contains the name of the department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. class varchar27 0 1 Number identifying the class to which the item is attached. The item's class will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the class table. ITEM_HDR CLASS RIB NUMBER(4,0) No Number identifying the class to which the item is attached. class_name varchar2120 0 1 Contains the name of the class. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. subclass varchar24 0 1 Number identifying the subclass to which the item is attached. The item's subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sub_name varchar2120 0 1 Contains the name of the subclass. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. status varchar21 0 1 Status of the item. Valid values are: W = Worksheet: item setup in progress, cannot be used in system; S = Submitted: item setup complete and awaiting approval, cannot be use in system; A = Approved: item is approved and can now be used throughout the system. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc varchar2250 0 1 Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null. ITEM_HDR DESCRIPTION RIB VARCHAR2(250 BYTE) Yes Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null. short_desc varchar2120 0 1 Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description will default to the parent's short description. For items without parents, this description will default to null. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. desc_up varchar2250 0 1 All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog, but is used in item list of value search processing through out the system. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_ref_item_ind varchar21 0 1 Indicates if the sub-transation 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'o. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. cost_zone_group_id number4 0 1 Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to 'Y' on the system_options table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. standard_uom varchar24 0 1 Unit of measure in which stock of the item is tracked at a corporate level. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uom_conv_factor number20_10 0 1 Conversion factor between an "Each" and the standard_uom when the standard_uom is not in the quantity class (e.g. if standard_uom = lb and 1 lb = 10 eaches, this factor will be 10). This factor will be 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. package_size number12_4 0 1 Holds the size of the product printed on any packaging (i.e. 24 ounces). This field is used for reporting purposes, as well as by Retek Price Mangement to determine same sized and different sized items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. package_uom varchar24 0 1 Holds the unit of measure associated with the package size. This field is used for reporting purposes and by Retek Price Management to determine same sized and different sized items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merchandise_ind varchar21 0 1 Indicates if the item is a merchandise item (Y, N). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_ord_mult varchar21 0 1 Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are:C = Cases; I = Inner; E = Eaches. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. forecast_ind varchar21 0 1 Indicates if this item will be interfaced to an external forecasting system (Y, N). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mfg_rec_retail number20_4 0 1 Manufacturer's recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. retail_label_type varchar26 0 1 This field indicates any special lable type assoctiated with an item (i.e. pre-priced or cents off). This field is used for reporting purposes only. Values for this field are defined by the 'RTLT' code on code detail. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. retail_label_type_desc varchar240 0 1 Contains the retail label type description corresponding to the retail_label_type value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. retail_label_value number20_4 0 1 This field represents the value associated with the retail label type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_temp varchar26 0 1 Holds the temperature information associated with the item. Valid values for this field are in the code type 'HTMP' on the code_head and code_detail tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_temp_desc varchar240 0 1 Contains the Handling temperature description corresponding to the handling_temp value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_sensitivity varchar26 0 1 Holds the sensitivity information associated with the item. Valid values for this field are in the code type 'HSEN' on the code_head and code_detail tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_sensitivity_desc varchar240 0 1 Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. catch_weight_ind varchar21 0 1 Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are 'Y' and 'N'. ITEM_HDR catch_weight_ind RIB VARCHAR2(1 BYTE) Yes Indicates whether the item should be weighed when it arrives at a location. waste_type varchar26 0 1 Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (i.e. fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (i.e. evaporation causes the product to weight less after a period of time). Valid values are: SP - spoilage; and SL - Sales. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. waste_type_desc varchar240 0 1 Contains the Waste Type description corresponding to the Waste_Type value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. waste_pct number12_4 0 1 Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_waste_pct number12_4 0 1 Default daily wastage percent for spoilage type wastage items. This value will default to all item locations and represents the average amount of wastage that occurs on a daily basis. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. const_dimen_ind varchar21 0 1 Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers will be defaulted to the primary supplier/primary country dimensions. Editing of dimensions for the item will only be allowed for the primary supplier/primiary country. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. simple_pack_ind varchar21 0 1 Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc). Valid values are:Y = Yes, this item is a simple pack; N = No if this is not a simple pack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contains_inner_ind varchar21 0 1 Indicates if pack item contains inner packs. Vendor packs will never contain inner packs and this field will be defaulted to 'N'. This field will only be available if the item is a pack item. Valid values are:Y = Yes, this pack contains inner packs; N = No, this pack does not contain inner packs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sellable_ind varchar21 0 1 Indicates if pack item may be sold as a unit. If it is 'Y' then the pack will have its own unique unit retail. If it is 'N' then the pack's unit retail is the sum of each individual item's total retail within the pack. This field will only be available if the item is a pack item. Value values are: Y = Yes, this pack may be sold as a unit; N = No, this pack man not be sold as a unit. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. orderable_ind varchar21 0 1 Indicates if pack item is orderable. If it is 'Y' then the suppliers of the pack must supply all components in the pack. If it is 'N' then the components may have different suppliers. This field will only be available if the item is a pack item. Valid values are: Y = Yes, this pack may be ordered, N = No, this pack may not be ordered. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pack_type varchar21 0 1 Indicates if 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 created for internal ease of use. 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 be available 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. order_as_type varchar21 0 1 Indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if 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). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. comments varchar22000 0 1 Holds any comments associated with the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_retail number20_4 0 1 This field holds the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_service_level varchar26 0 1 Holds a value that restricts the type of shipment methods that RCOM can select for an item. ITEM_HDR ITEM_SERVICE_LEVEL RIB VARCHAR2(6 BYTE) No Holds a value that restricts the type of shipment methods that RCOM can select for an item. gift_wrap_ind varchar21 0 1 This field will contain a value of 'Y' if the item is eligible to be gift wrapped. ITEM_HDR GIFT_WRAP_IND RIB VARCHAR2(1 BYTE) No This field will contain a value of 'Y' if the item is eligible to be gift wrapped. ship_alone_ind varchar21 0 1 This field will contain a value of 'Y' if the item should be shipped to the customer is a seperate package versus being grouped together in a box. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vendor_style varchar215 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. std_unit_weight number20_10 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. single_price_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. preticket_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. planned_residual varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sortable varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda1 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda2 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda3 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda4 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda5 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda6 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda7 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda8 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda9 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda10 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda11 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda12 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda13 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda14 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda15 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ship_alone varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. slottable varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. freight_class varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. new_item varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. brand varchar2120 0 1 This is used to associate a brand to an item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. break_case_ups varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. rigid varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. fragile varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. container_type varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. conveyable_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. hazard_matl_code varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. velocity number12_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. high_value_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_type varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. color varchar224 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. size1 varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. fit varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. shade varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. single_contain_bulk varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_pick_system_code varchar212 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. roundable_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. perishable_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. division number4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vendor_nbr varchar210 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. kitting_wip_code varchar29 0 1 Wip code used to designate the Kitting process used in item_master Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_ticket_qty number3 0 1 Item Master User Defined Attribute Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_length number12_4 0 1 Length of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_width number12_4 0 1 Width of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_height number12_4 0 1 Height of an individual Item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_weight number12_4 0 1 Weight of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_cube number12_4 0 1 Cubic dimension of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. std_unit_factor number6_2 0 1 Used for putaway by volume. The percentage of the standard number of units that will fit into a location type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. std_unit_qty number12_4 0 1 The number of items that normally fit on/in the container type Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expiration_days number4 0 1 The number of days before inventory is deemed to be no longer distributable Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. putaway_by_volume varchar26 0 1 If set to Y, putaway will be determined by cube or volume. If set to N, putaway will be determined by capacity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. putaway_plan varchar220 0 1 Plan used for putaway Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_type varchar26 0 1 Code specifying what type the item is. Valid values for this field are in the code type UPCT on the code_head and code_detail tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sorter_group varchar26 0 1 Sorter Group identifier Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sku_optimization varchar21 0 1 Indicator for inclusion in SKU optimization Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ext_source_system varchar26 0 1 Specifies what external system the data originated from. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_xform_ind varchar21 0 1 Indicator shows that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inventory_ind varchar21 0 1 Inventory Indicator ITEM_HDR INVENTORY_IND RIB VARCHAR2(1 BYTE) Yes Inventory Indicator order_type varchar29 0 1 Indicates the type of order and which Open To Buy bucket will be updated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sale_type varchar26 0 1 n/a Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. deposit_item_type varchar26 0 1 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. The possible values are - 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. container_item varchar225 0 1 This holds the container item number for a contents item. This field is only populated and required if the DEPOSIT_ITEM_TYPE = E. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. deposit_in_price_per_uom varchar26 0 1 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 - Include deposit amount E - Exclude deposit amount Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. transport_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. notional_pack_ind varchar21 0 1 Indicates in SIM if a sellable simple pack needs to be broken down to its component item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. soh_inquiry_at_pack_ind varchar21 0 1 Indicates in SIM if a notional simple pack item's inventory should be displayed in packs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar26 0 1 Indicates if an item is a normal, consignment or concession item - 'N' for normal, 'S' for consignment, 'C' for concession. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. product_classification varchar26 0 1 This contains item combinability codes (with code type 'PCLA') which provide a way to define which items can be combined (packed or boxed) together. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA item_aggregate_ind varchar21 0 1 Indicator to aggregate inventory and sales for the item. Currently, this indiactor is used by allocation and MFP to aggregate inventory for items. For staple items this indictor should be N. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_1_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_2_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_3_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for a fashion item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_4_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc_secondary varchar2250 0 1 Secondary descriptions of the item. This field can only be populated when system_options.secondary_desc_ind = Y. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. original_retail number20_4 0 1 The field indicated the original retail price of the item per unit.This field is stored in the primary currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. originalretailcurrencycode varchar23 0 1 The field indicates the currency code of the original retail price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mfgretailcurrencycode varchar23 0 1 The field indicates the currency code of the Manufacturer's retail price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. catch_weight_type varchar21 0 1 This column will hold 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 The column will be set only at the time of Item approval. It will be used by the ReIM Invoice Matching process. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. catch_weight_uom varchar24 0 1 Indicates the UOM for Catchweight Items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. brand_name varchar230 0 1 This field contains the brand associated to an item. ITEM_HDR BRAND_NAME RIB VARCHAR2(30 BYTE) No This field contains the brand associated to an item. unique_class number12 0 1 This field uniquely identify the class which the item belongs to.Class is not unique ID the merchandise hierarchy.The combination of Dept/Class is unique, but requires use of a composite key.The composite key is generally used in user interfaces.The unique ID can be used in back end processing or in systems that can not have a composite key in the merchandise hierarchy. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unique_subclass number12 0 1 This field uniquely identify the subclass which the item belongs to.Sublass is not unique ID the merchandise hierarchy.The combination of Dept/Class/Subclass is unique, but requires use of a composite key.The composite key is generally used in user interfaces.The unique ID can be used in back end processing or in systems that can not have a composite key in the merchandise hierarchy. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_1_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_1 is a group diff or a diff id. ITEM_HDR DIFF_1_LEVEL RIB VARCHAR2(6 BYTE) No This field will contain either ID or GROUP. diff_1_description varchar2120 0 1 This field will hold the description of differentiator. ITEM_HDR DIFF_1_DESC RIB VARCHAR2(120 BYTE) No This field will hold the description of differentiator. diff_2_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_2 is a group diff or a diff id. ITEM_HDR DIFF_2_LEVEL RIB VARCHAR2(6 BYTE) No This field will contain either ID or GROUP. diff_2_description varchar2120 0 1 This field will hold the description of differentiator. ITEM_HDR DIFF_2_DESC RIB VARCHAR2(120 BYTE) No This field will hold the description of differentiator. diff_3_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_3 is a group diff or a diff id. ITEM_HDR DIFF_3_LEVEL RIB VARCHAR2(6 BYTE) No This field will contain either ID or GROUP. diff_3_description varchar2120 0 1 This field will hold the description of differentiator. ITEM_HDR DIFF_3_DESC RIB VARCHAR2(120 BYTE) No This field will hold the description of differentiator. diff_4_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_4 is a group diff or a diff id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_4_description varchar2120 0 1 This field will hold the description of differentiator. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. prod_classification_desc varchar2120 0 1 This field will hold the description of the product classification. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemHdrTlDesc:ItemHdrTlDesc * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA primary_image_url varchar2375 0 1 This field will hold the primary item image url. It is only included for the ItemCre and ItemFulRep message types. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemHdrTlDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemHdrTlDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description lang number6 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. description varchar2120 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. iso_code varchar26 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc varchar2250 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc_secondary varchar2250 0 1 This field will hold the translated text of the primary description of the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. short_desc varchar2120 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemSupDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. An item can have one and only one primary supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vpn varchar230 0 1 This field contains the Vendor Product Number for the Item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_label varchar215 0 1 This field contains the supplier label. It will only be popluated if item is a style. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. consignment_rate number12_4 0 1 This field contains the consignment rate for this item for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_1 varchar2120 0 1 This field contains the first supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_2 varchar2120 0 1 This field contains the second supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_3 varchar2120 0 1 This field contains the third supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_4 varchar2120 0 1 This field contains the fourth supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pallet_name varchar26 0 1 Code referencing the name used to refer to the pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. case_name varchar26 0 1 Code referencing the name used to refer to the case. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inner_name varchar26 0 1 Code referencing the name used to refer to the inner. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_discontinue_date xs:dateTime 0 1 Date when the supplier discontinues an item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. direct_ship_ind varchar21 0 1 A value of 'Y'es in this field indicates that any item associated with this supplier is eligible for a direct shipment from the supplier to the customer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA primary_case_size varchar26 0 1 This field indicates the primary case size for the item supplier when an orderable item is configured for informal case types. Used only if AIP is interfaced. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemSupCtyDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. origin_country_id varchar23 1 1 The country where the item was manufactured or significantly altered. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. Each item can have one and only one primary supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_country_ind varchar21 1 1 This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination can have one and only one primary country. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_cost number20_4 1 1 This field contains the current corporate unit cost for the item from the supplier /origin country. This field is stored in the Supplier's currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. lead_time number4 0 1 This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pickup_lead_time number4 0 1 Contains the time that will be taken to get the item from the supplier to the initial receiving location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_pack_size number12_4 1 1 This field contains the quantity that orders must be placed in multiples of for the supplier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inner_pack_size number12_4 1 1 This field contains the break pack size for this item from the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_lvl varchar26 1 1 This column is used to determine how order quantities will be rounded to case, layer and pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. min_order_qty number12_4 0 1 This field contains the minimum quantity that can be ordered at one from the supplier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. max_order_qty number12_4 0 1 This field contains the maximum quantity that can be ordered at one from the supplier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. packing_method varchar26 0 1 This field indicates whether the packing method for the item in the container is flat or hanging. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_uop varchar26 0 1 Contains the default unit of purchase for the item/supplier/country. Valid values include 'C'ase and 'P'allet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ti number12_4 1 1 Number of shipping units (cases) that make up one tier of the pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. hi number12_4 1 1 Number of tiers that make up a complete pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. cost_uom varchar24 0 1 A cost UOM is held to allow costs to be managed in a separate UOM to the standard UOM. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tolerance_type varchar26 0 1 The unit of tolerance for catch weight simple packs. Valid values are: 'A'-actual 'P' - percent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. max_tolerance number12_4 0 1 The maximum tolerance value for the catch weight simple pack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA round_to_inner_pct number12_4 0 1 This column will hold the Inner Rounding Threshold value. During rounding, this value is used to determine whether to round partial Inner quantities up or down. If the Inner-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_to_case_pct number12_4 0 1 This column will hold the Case Rounding Threshold value. During rounding, this value is used to determine whether to round partial Case quantities up or down. If the Case-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_to_layer_pct number12_4 0 1 This column will hold the Layer Rounding Threshold value. During rounding, this value is used to determine whether to round partial Layer quantities up or down. If the Layer-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_to_pallet_pct number12_4 0 1 This column will hold the Pallet Rounding Threshold value. During rounding, this value is used to determine whether to round partial Pallet quantities up or down. If the Pallet -fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_type_1 varchar26 0 1 This field identifies partner type of supplier hierarchy level 1.This field will always have the partner type S1 which indicates manufacturer.. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_lvl_1 varchar210 0 1 Highest level of supplier hierarchy which is there to indicate a partner, such as a manufacturer, in the supply chain that gives rebates to the retailer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_type_2 varchar26 0 1 This field identifies partner type of supplier hierarchy level 2 . This field will always have the partner type S2 which indicates distributor. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_lvl_2 varchar210 0 1 Second highest level of supplier hierarchy which is there to indicate a partner, such as a distributor in the supply chain that gives rebates to the retailer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_type_3 varchar26 0 1 This field identifies partner type of supplier hierarchy level 3.This field will always have the partner type S3 which indicates wholesaler. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_lvl_3 varchar210 0 1 Third highest level of supplier hierarchy which is uder to indicate a partner, such as a wholesaler in the supply chain that gives rebates to the retailer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. negotiated_item_cost number20_4 0 1 This will hold the supplier negotiated item cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations negotiated item cost will be stored in this field. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. extended_base_cost number20_4 0 1 This will hold the extended base cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations extended base cost will be stored in this field. Extended base cost is the cost inclusive of all the taxes that affect the WAC. In case of GTAX , Extended Base Cost = Base Cost + Non-recoverable taxes. In case of VAT, Extended Base Cost = Base Cost. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inclusive_cost number20_4 0 1 This will hold the inclusive cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations inclusive cost will be stored in this field. This cost will have both the recoverable and non recoverable taxes included. In case of GTAX , Inclusive Cost = Base Cost + Non-recoverable taxes + Recoverable Taxes. In case of VAT, Inclusive Cost = Base Cost + VAT. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. base_cost number20_4 0 1 This field will hold the tax exclusive cost of the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar21 0 1 This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. calculation_basis varchar21 0 1 This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_rate number12_4 0 1 This column contains the percentage of the retail price which will determnie the cost paid to the supplier for a consignment or concession item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ISCDimDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ISCDimDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. origin_country varchar23 1 1 The country where the item was manufactured or significantly altered. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dim_object varchar26 1 1 Specific object whose dimensions are specified in this record. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. object_desc varchar240 0 1 Dim_object description fetched from the code_detail table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. presentation_method varchar26 0 1 Describes the packaging (if any) being taken into consideration in the specified dimensions. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. method_desc varchar240 0 1 Presentation method description fetched from the code_detail table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. length number12_4 0 1 Length of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. width number12_4 0 1 Width of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. height number12_4 0 1 Height of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. lwh_uom varchar24 0 1 Unit of measurement for length, width and height. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. weight number12_4 0 1 Weight of dim_object measured in units specified in weight_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. net_weight number12_4 0 1 Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. weight_uom varchar24 0 1 Unit of measurement for weight. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. liquid_volume number12_4 0 1 Liquid volume, or capacity, of dim_object measured in units specified in colume_uom. Liquid volumes are only convertible to other liquid volumes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. liquid_volume_uom varchar24 0 1 Unit of measurement for liquid volume. Liquid volumes are only convertible to other liquid volumes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stat_cube number12_4 0 1 Statistical value of the dim_object's dimensions to be used for loading purposes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tare_weight number12_4 0 1 Amount of weight to be subtracted for packaging materials. Used to calculate the true net weight of the dim_object. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tare_type varchar26 0 1 Indicates whether the tare weight for the dim_object is wet or dry. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemUDALOVDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDALOVDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Item ID Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains the unique identified of the Attribute Group being added or delete to the item list. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_value varchar230 1 1 Contains the value of the Attribute Group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_desc varchar2120 0 1 This field contains a description of the User-Defined Attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_value_desc varchar2250 0 1 This field contains a description of the UDA value. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemUDAFFDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDAFFDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_text varchar2250 0 1 This field contains the text value of the user-defined attribute for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemUDADateDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDADateDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_date xs:dateTime 1 1 This field contains the effective date for the Uda id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemImageDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemImageDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. ITEM_IMAGE ITEM RIB VARCHAR2(25 BYTE) Yes Unique identifier for the item. image_name varchar2120 1 1 Name of the image. ITEM_IMAGE IMAGE_NAME RIB VARCHAR2(120 BYTE) Yes Name of the image. image_addr varchar2255 1 1 Path where the image file is stored. ITEM_IMAGE IMAGE_ADDR RIB VARCHAR2(255 BYTE) Yes Path where the image file is stored. image_type varchar26 0 1 This field contains the type of the image of the item. Valid values are defined as member of IITD code type. ITEM_IMAGE IMAGE_TYPE RIB VARCHAR2(6 BYTE) Yes This field contains the type of the image of the item. Valid values are defined as member of IITD code type. primary_ind varchar21 0 1 Field indicating whether the record is a primary image or not. ITEM_IMAGE PRIMARY_IND RIB VARCHAR2(1 BYTE) Yes Field indicating whether the record is a primary image or not. display_priority number4 0 1 Field to specify the display sequence order of images associated to the item per priority. ITEM_IMAGE DISPLAY_PRIORITY RIB NUMBER(4,0) Yes Field to specify the display sequence order of images associated to the item per priority. image_desc varchar240 0 1 This field contains the description associated with the image of the item. ITEM_IMAGE IMAGE_DESC RIB VARCHAR2(40 BYTE) Yes This field contains the description associated with the image of the item.

XML-Schema Name:ItemUPCDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUPCDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item_id varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_parent varchar225 0 1 Unique identifier for the item/group at the level above the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_ref_item_ind varchar21 0 1 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'o. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. format_id varchar21 0 1 This field will hold the format id that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. prefix number2 0 1 This field holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_number_type varchar26 0 1 This type can hold a number of digits count umber_type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemBOMDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemBOMDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description pack_no varchar225 1 1 Unique identifier for the pack item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item varchar225 1 1 Unique identifier for the component item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pack_qty number12_4 1 1 Contains the quantity of each item in the pack item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemTcktDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTcktDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_type_id varchar24 1 1 This field uniquely identifies the ticket type which is associated with the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_type_desc varchar2120 0 1 This field contains a description of the ticket or label type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sel_ind varchar21 0 1 Indicates if the ticket type is a shelf edge label. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. po_print_type varchar21 0 1 This field indicates when the ticket type for the given item should be printed by default, upon the approval or receipt of the purchase order. Valid values are: A and R. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. print_on_pc_ind varchar21 0 1 This field indicates whether or not this type of ticket should be printed for this item when a permanent price change goes into effect. Valid values in this field are:Y - Yes N - No. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_over_pct number12_4 0 1 This field contains a percent which indicates the amount of tickets which should be printed for a given event. If the event causing tickets to be printed is approving or receiving a purchase order, then this field indicates the quantity of tickets which should be printed greater than the quantity of the purchase order. If the event causing the tickets to be printed is a permanent price change, this field would indicate the quantity of tickets which should be printed greater than the stock on hand. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. TicketTypeDtl * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc.

XML-Schema Name:ItemSupCtyMfrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyMfrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Item ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier number10 1 1 Supplier ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. manufacturer_ctry_id varchar23 1 1 Country ID of manufacturer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_manufacturer_ctry_ind varchar21 1 1 Primary country of manufacturer indicator. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:RelatedItemDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RelatedItemDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 The main item against which the relationship is defined. RELATED_ITEM ITEM RIB VARCHAR2(25 BYTE) Yes The main item against which the relationship is defined. relationship_id number15 1 1 A system generated numeric field that uniquely identifies the relationship record in related_item_head. RELATED_ITEM RELATIONSHIP_ID RIB NUMBER(20,0) Yes A system generated numeric field that uniquely identifies the relationship record in related_item_head. relationship_name varchar2120 1 1 This is the user entered name of the relationship. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. relationship_type varchar26 1 1 Describes the type of relationship. Valid values are in the codes table under code_type 'IREL'. RELATED_ITEM RELATIONSHIP_TYPE RIB VARCHAR2(6 BYTE) Yes Describes the type of relationship. Valid values are in the codes table under code_type 'IREL'. mandatory_ind mandatory_ind 1 1 Indicates whether the relationship is mandatory or not. Valid values: 'Y' (yes), 'N' (no). RELATED_ITEM MANDATORY_IND RIB VARCHAR2(1 BYTE) Yes Indicates whether the relationship is mandatory or not. RelatedItemDtl * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc.

XML-Schema Name:VatItemDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VatItemDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. VAT_ITEM ITEM RIB VARCHAR2(25 BYTE) Yes Unique identifier for the item. active_date xs:dateTime 1 1 This field holds the active date for record on future cost. VAT_ITEM ACTIVE_DATE RIB TIMESTAMP(6) Yes This field holds the active date for record on future cost. vat_type varchar21 1 1 This field indicates the type of vat either Retail or Cost or Both. VAT_ITEM VAT_TYPE RIB VARCHAR2(1 BYTE) Yes This field indicates the type of vat either Retail or Cost or Both. vat_code varchar26 1 1 This field indicates a code to uniquely identify a VAT rate. VAT_ITEM VAT_CODE RIB VARCHAR2(6 BYTE) Yes This field indicates a code to uniquely identify a VAT rate. vat_rate number20_10 1 1 This column contains vat rate associated with a given VAT code. VAT_ITEM VAT_RATE RIB NUMBER(20,10) Yes This column contains vat rate associated with a given VAT code. reverse_vat_ind varchar21 1 1 This field indicates if the item is subject to reverse charge VAT at the vat region. Valid values are Y and N. VAT_ITEM REVERSE_VAT_IND RIB VARCHAR2(1 BYTE) Yes This field indicates if the item is subject to reverse charge VAT at the vat region. Valid values are Y and N. vat_region number4 1 1 Contains the number of the Value Added Tax region a location belongs to. NA NA NA NA NA NA

XML-Schema Name:ItemSupUomDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupUomDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier number10 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uom varchar24 1 1 The unit of measure that the item is being measured in. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value number20_4 1 1 This field will store the equivalent value of the Item/Suppliers shipping carton in the associated unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ISCDimDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ISCDimDesc

XML-Schema Name:ISCDimDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ISCDimDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. origin_country varchar23 1 1 The country where the item was manufactured or significantly altered. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dim_object varchar26 1 1 Specific object whose dimensions are specified in this record. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. object_desc varchar240 0 1 Dim_object description fetched from the code_detail table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. presentation_method varchar26 0 1 Describes the packaging (if any) being taken into consideration in the specified dimensions. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. method_desc varchar240 0 1 Presentation method description fetched from the code_detail table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. length number12_4 0 1 Length of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. width number12_4 0 1 Width of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. height number12_4 0 1 Height of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. lwh_uom varchar24 0 1 Unit of measurement for length, width and height. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. weight number12_4 0 1 Weight of dim_object measured in units specified in weight_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. net_weight number12_4 0 1 Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. weight_uom varchar24 0 1 Unit of measurement for weight. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. liquid_volume number12_4 0 1 Liquid volume, or capacity, of dim_object measured in units specified in colume_uom. Liquid volumes are only convertible to other liquid volumes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. liquid_volume_uom varchar24 0 1 Unit of measurement for liquid volume. Liquid volumes are only convertible to other liquid volumes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stat_cube number12_4 0 1 Statistical value of the dim_object's dimensions to be used for loading purposes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tare_weight number12_4 0 1 Amount of weight to be subtracted for packaging materials. Used to calculate the true net weight of the dim_object. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tare_type varchar26 0 1 Indicates whether the tare weight for the dim_object is wet or dry. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemBOMDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemBOMDesc

XML-Schema Name:ItemBOMDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemBOMDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description pack_no varchar225 1 1 Unique identifier for the pack item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item varchar225 1 1 Unique identifier for the component item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pack_qty number12_4 1 1 Contains the quantity of each item in the pack item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemHdrDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemHdrDesc CustFlexAttriVo ItemHdrTlDesc

XML-Schema Name:ItemHdrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemHdrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique alphanumeric value that identifies the item. ITEM_HDR ITEM RIB VARCHAR2(25 BYTE) Yes Unique alphanumeric value that identifies the item. item_number_type varchar26 1 1 This type can hold a number of digits count umber_type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. format_id varchar21 0 1 This field will hold the format ID that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. prefix number2 0 1 This column holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. It is the clients responsibility to download this value to their Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_parent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. ITEM_HDR ITEM_PARENT RIB VARCHAR2(25 BYTE) No Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. item_grandparent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table. ITEM_HDR ITEM_GRANDPARENT RIB VARCHAR2(25 BYTE) No Alphanumeric value that uniquely identifies the item/group two levels above the item. pack_ind varchar21 0 1 Indicates if the item is a pack. A pack item is a collection of items that may be either ordered or sold as a unit. Packs require details (i.e. component items and qtys, etc.) that other items do not. This field is required by the database. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_level number1 0 1 Number indicating 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 item level also determines how the item may be used throughout the system. ITEM_HDR ITEM_LEVEL RIB NUMBER(1,0) Yes Number indicating 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 item level also determines how the item may be used throughout the system. tran_level number1 0 1 Number indicating which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's inventory is tracked in the system. The transaction level item will be counted, transferred, shipped, etc. The transaction level may be at the current item or up to 2 levels above or below the current item. Only one level of the hierarchy of an item family may contain transaction level items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_1 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Men's pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. ITEM_HDR DIFF_1 RIB VARCHAR2(10 BYTE) No Diff_group or diff_id that differentiates the current item from its item_parent. diff_1_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. ITEM_HDR DIFF_1_TYPE RIB VARCHAR2(6 BYTE) No This field will hold a value of all possible differential types. diff_2 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. ITEM_HDR DIFF_2 RIB VARCHAR2(10 BYTE) No Diff_group or diff_id that differentiates the current item from its item_parent. diff_2_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. ITEM_HDR DIFF_2_TYPE RIB VARCHAR2(6 BYTE) No This field will hold a value of all possible differential types. diff_3 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. ITEM_HDR DIFF_3 RIB VARCHAR2(10 BYTE) No Diff_group or diff_id that differentiates the current item from its item_parent. diff_3_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. ITEM_HDR DIFF_3_TYPE RIB VARCHAR2(6 BYTE) No This field will hold a value of all possible differential types. diff_4 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_4_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 0 1 Number identifying the department to which the item is attached. The item's department will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the deps table. ITEM_HDR DEPT RIB NUMBER(4,0) Yes Number identifying the department to which the item is attached. dept_name varchar2120 0 1 Contains the name of the department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. class varchar27 0 1 Number identifying the class to which the item is attached. The item's class will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the class table. ITEM_HDR CLASS RIB NUMBER(4,0) No Number identifying the class to which the item is attached. class_name varchar2120 0 1 Contains the name of the class. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. subclass varchar24 0 1 Number identifying the subclass to which the item is attached. The item's subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sub_name varchar2120 0 1 Contains the name of the subclass. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. status varchar21 0 1 Status of the item. Valid values are: W = Worksheet: item setup in progress, cannot be used in system; S = Submitted: item setup complete and awaiting approval, cannot be use in system; A = Approved: item is approved and can now be used throughout the system. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc varchar2250 0 1 Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null. ITEM_HDR DESCRIPTION RIB VARCHAR2(250 BYTE) Yes Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null. short_desc varchar2120 0 1 Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description will default to the parent's short description. For items without parents, this description will default to null. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. desc_up varchar2250 0 1 All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog, but is used in item list of value search processing through out the system. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_ref_item_ind varchar21 0 1 Indicates if the sub-transation 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'o. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. cost_zone_group_id number4 0 1 Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to 'Y' on the system_options table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. standard_uom varchar24 0 1 Unit of measure in which stock of the item is tracked at a corporate level. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uom_conv_factor number20_10 0 1 Conversion factor between an "Each" and the standard_uom when the standard_uom is not in the quantity class (e.g. if standard_uom = lb and 1 lb = 10 eaches, this factor will be 10). This factor will be 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. package_size number12_4 0 1 Holds the size of the product printed on any packaging (i.e. 24 ounces). This field is used for reporting purposes, as well as by Retek Price Mangement to determine same sized and different sized items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. package_uom varchar24 0 1 Holds the unit of measure associated with the package size. This field is used for reporting purposes and by Retek Price Management to determine same sized and different sized items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merchandise_ind varchar21 0 1 Indicates if the item is a merchandise item (Y, N). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_ord_mult varchar21 0 1 Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are:C = Cases; I = Inner; E = Eaches. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. forecast_ind varchar21 0 1 Indicates if this item will be interfaced to an external forecasting system (Y, N). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mfg_rec_retail number20_4 0 1 Manufacturer's recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. retail_label_type varchar26 0 1 This field indicates any special lable type assoctiated with an item (i.e. pre-priced or cents off). This field is used for reporting purposes only. Values for this field are defined by the 'RTLT' code on code detail. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. retail_label_type_desc varchar240 0 1 Contains the retail label type description corresponding to the retail_label_type value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. retail_label_value number20_4 0 1 This field represents the value associated with the retail label type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_temp varchar26 0 1 Holds the temperature information associated with the item. Valid values for this field are in the code type 'HTMP' on the code_head and code_detail tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_temp_desc varchar240 0 1 Contains the Handling temperature description corresponding to the handling_temp value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_sensitivity varchar26 0 1 Holds the sensitivity information associated with the item. Valid values for this field are in the code type 'HSEN' on the code_head and code_detail tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. handling_sensitivity_desc varchar240 0 1 Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. catch_weight_ind varchar21 0 1 Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are 'Y' and 'N'. ITEM_HDR catch_weight_ind RIB VARCHAR2(1 BYTE) Yes Indicates whether the item should be weighed when it arrives at a location. waste_type varchar26 0 1 Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (i.e. fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (i.e. evaporation causes the product to weight less after a period of time). Valid values are: SP - spoilage; and SL - Sales. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. waste_type_desc varchar240 0 1 Contains the Waste Type description corresponding to the Waste_Type value in item_master. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. waste_pct number12_4 0 1 Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_waste_pct number12_4 0 1 Default daily wastage percent for spoilage type wastage items. This value will default to all item locations and represents the average amount of wastage that occurs on a daily basis. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. const_dimen_ind varchar21 0 1 Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers will be defaulted to the primary supplier/primary country dimensions. Editing of dimensions for the item will only be allowed for the primary supplier/primiary country. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. simple_pack_ind varchar21 0 1 Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc). Valid values are:Y = Yes, this item is a simple pack; N = No if this is not a simple pack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contains_inner_ind varchar21 0 1 Indicates if pack item contains inner packs. Vendor packs will never contain inner packs and this field will be defaulted to 'N'. This field will only be available if the item is a pack item. Valid values are:Y = Yes, this pack contains inner packs; N = No, this pack does not contain inner packs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sellable_ind varchar21 0 1 Indicates if pack item may be sold as a unit. If it is 'Y' then the pack will have its own unique unit retail. If it is 'N' then the pack's unit retail is the sum of each individual item's total retail within the pack. This field will only be available if the item is a pack item. Value values are: Y = Yes, this pack may be sold as a unit; N = No, this pack man not be sold as a unit. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. orderable_ind varchar21 0 1 Indicates if pack item is orderable. If it is 'Y' then the suppliers of the pack must supply all components in the pack. If it is 'N' then the components may have different suppliers. This field will only be available if the item is a pack item. Valid values are: Y = Yes, this pack may be ordered, N = No, this pack may not be ordered. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pack_type varchar21 0 1 Indicates if 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 created for internal ease of use. 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 be available 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. order_as_type varchar21 0 1 Indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if 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). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. comments varchar22000 0 1 Holds any comments associated with the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_retail number20_4 0 1 This field holds the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_service_level varchar26 0 1 Holds a value that restricts the type of shipment methods that RCOM can select for an item. ITEM_HDR ITEM_SERVICE_LEVEL RIB VARCHAR2(6 BYTE) No Holds a value that restricts the type of shipment methods that RCOM can select for an item. gift_wrap_ind varchar21 0 1 This field will contain a value of 'Y' if the item is eligible to be gift wrapped. ITEM_HDR GIFT_WRAP_IND RIB VARCHAR2(1 BYTE) No This field will contain a value of 'Y' if the item is eligible to be gift wrapped. ship_alone_ind varchar21 0 1 This field will contain a value of 'Y' if the item should be shipped to the customer is a seperate package versus being grouped together in a box. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vendor_style varchar215 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. std_unit_weight number20_10 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. single_price_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. preticket_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. planned_residual varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sortable varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda1 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda2 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda3 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda4 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda5 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda6 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda7 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda8 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda9 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda10 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda11 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda12 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda13 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda14 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_master_uda15 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ship_alone varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. slottable varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. freight_class varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. new_item varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. brand varchar2120 0 1 This is used to associate a brand to an item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. break_case_ups varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. rigid varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. fragile varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. container_type varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. conveyable_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. hazard_matl_code varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. velocity number12_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. high_value_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_type varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. color varchar224 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. size1 varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. fit varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. shade varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. single_contain_bulk varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_pick_system_code varchar212 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. roundable_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. perishable_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. division number4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vendor_nbr varchar210 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. kitting_wip_code varchar29 0 1 Wip code used to designate the Kitting process used in item_master Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_ticket_qty number3 0 1 Item Master User Defined Attribute Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_length number12_4 0 1 Length of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_width number12_4 0 1 Width of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_height number12_4 0 1 Height of an individual Item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_weight number12_4 0 1 Weight of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_cube number12_4 0 1 Cubic dimension of an individual item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. std_unit_factor number6_2 0 1 Used for putaway by volume. The percentage of the standard number of units that will fit into a location type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. std_unit_qty number12_4 0 1 The number of items that normally fit on/in the container type Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expiration_days number4 0 1 The number of days before inventory is deemed to be no longer distributable Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. putaway_by_volume varchar26 0 1 If set to Y, putaway will be determined by cube or volume. If set to N, putaway will be determined by capacity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. putaway_plan varchar220 0 1 Plan used for putaway Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_type varchar26 0 1 Code specifying what type the item is. Valid values for this field are in the code type UPCT on the code_head and code_detail tables. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sorter_group varchar26 0 1 Sorter Group identifier Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sku_optimization varchar21 0 1 Indicator for inclusion in SKU optimization Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ext_source_system varchar26 0 1 Specifies what external system the data originated from. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_xform_ind varchar21 0 1 Indicator shows that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inventory_ind varchar21 0 1 Inventory Indicator ITEM_HDR INVENTORY_IND RIB VARCHAR2(1 BYTE) Yes Inventory Indicator order_type varchar29 0 1 Indicates the type of order and which Open To Buy bucket will be updated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sale_type varchar26 0 1 n/a Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. deposit_item_type varchar26 0 1 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. The possible values are - 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. container_item varchar225 0 1 This holds the container item number for a contents item. This field is only populated and required if the DEPOSIT_ITEM_TYPE = E. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. deposit_in_price_per_uom varchar26 0 1 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 - Include deposit amount E - Exclude deposit amount Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. transport_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. notional_pack_ind varchar21 0 1 Indicates in SIM if a sellable simple pack needs to be broken down to its component item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. soh_inquiry_at_pack_ind varchar21 0 1 Indicates in SIM if a notional simple pack item's inventory should be displayed in packs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar26 0 1 Indicates if an item is a normal, consignment or concession item - 'N' for normal, 'S' for consignment, 'C' for concession. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. product_classification varchar26 0 1 This contains item combinability codes (with code type 'PCLA') which provide a way to define which items can be combined (packed or boxed) together. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA item_aggregate_ind varchar21 0 1 Indicator to aggregate inventory and sales for the item. Currently, this indiactor is used by allocation and MFP to aggregate inventory for items. For staple items this indictor should be N. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_1_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_2_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_3_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for a fashion item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_4_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc_secondary varchar2250 0 1 Secondary descriptions of the item. This field can only be populated when system_options.secondary_desc_ind = Y. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. original_retail number20_4 0 1 The field indicated the original retail price of the item per unit.This field is stored in the primary currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. originalretailcurrencycode varchar23 0 1 The field indicates the currency code of the original retail price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mfgretailcurrencycode varchar23 0 1 The field indicates the currency code of the Manufacturer's retail price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. catch_weight_type varchar21 0 1 This column will hold 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 The column will be set only at the time of Item approval. It will be used by the ReIM Invoice Matching process. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. catch_weight_uom varchar24 0 1 Indicates the UOM for Catchweight Items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. brand_name varchar230 0 1 This field contains the brand associated to an item. ITEM_HDR BRAND_NAME RIB VARCHAR2(30 BYTE) No This field contains the brand associated to an item. unique_class number12 0 1 This field uniquely identify the class which the item belongs to.Class is not unique ID the merchandise hierarchy.The combination of Dept/Class is unique, but requires use of a composite key.The composite key is generally used in user interfaces.The unique ID can be used in back end processing or in systems that can not have a composite key in the merchandise hierarchy. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unique_subclass number12 0 1 This field uniquely identify the subclass which the item belongs to.Sublass is not unique ID the merchandise hierarchy.The combination of Dept/Class/Subclass is unique, but requires use of a composite key.The composite key is generally used in user interfaces.The unique ID can be used in back end processing or in systems that can not have a composite key in the merchandise hierarchy. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_1_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_1 is a group diff or a diff id. ITEM_HDR DIFF_1_LEVEL RIB VARCHAR2(6 BYTE) No This field will contain either ID or GROUP. diff_1_description varchar2120 0 1 This field will hold the description of differentiator. ITEM_HDR DIFF_1_DESC RIB VARCHAR2(120 BYTE) No This field will hold the description of differentiator. diff_2_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_2 is a group diff or a diff id. ITEM_HDR DIFF_2_LEVEL RIB VARCHAR2(6 BYTE) No This field will contain either ID or GROUP. diff_2_description varchar2120 0 1 This field will hold the description of differentiator. ITEM_HDR DIFF_2_DESC RIB VARCHAR2(120 BYTE) No This field will hold the description of differentiator. diff_3_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_3 is a group diff or a diff id. ITEM_HDR DIFF_3_LEVEL RIB VARCHAR2(6 BYTE) No This field will contain either ID or GROUP. diff_3_description varchar2120 0 1 This field will hold the description of differentiator. ITEM_HDR DIFF_3_DESC RIB VARCHAR2(120 BYTE) No This field will hold the description of differentiator. diff_4_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_4 is a group diff or a diff id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_4_description varchar2120 0 1 This field will hold the description of differentiator. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. prod_classification_desc varchar2120 0 1 This field will hold the description of the product classification. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemHdrTlDesc:ItemHdrTlDesc * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA primary_image_url varchar2375 0 1 This field will hold the primary item image url. It is only included for the ItemCre and ItemFulRep message types. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemHdrTlDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemHdrTlDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description lang number6 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. description varchar2120 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. iso_code varchar26 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc varchar2250 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc_secondary varchar2250 0 1 This field will hold the translated text of the primary description of the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. short_desc varchar2120 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemHdrTlDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemHdrTlDesc

XML-Schema Name:ItemHdrTlDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemHdrTlDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description lang number6 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. description varchar2120 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. iso_code varchar26 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc varchar2250 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_desc_secondary varchar2250 0 1 This field will hold the translated text of the primary description of the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. short_desc varchar2120 0 1 This field will hold the language in which the translated text is maintained. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemImageDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemImageDesc

XML-Schema Name:ItemImageDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemImageDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. ITEM_IMAGE ITEM RIB VARCHAR2(25 BYTE) Yes Unique identifier for the item. image_name varchar2120 1 1 Name of the image. ITEM_IMAGE IMAGE_NAME RIB VARCHAR2(120 BYTE) Yes Name of the image. image_addr varchar2255 1 1 Path where the image file is stored. ITEM_IMAGE IMAGE_ADDR RIB VARCHAR2(255 BYTE) Yes Path where the image file is stored. image_type varchar26 0 1 This field contains the type of the image of the item. Valid values are defined as member of IITD code type. ITEM_IMAGE IMAGE_TYPE RIB VARCHAR2(6 BYTE) Yes This field contains the type of the image of the item. Valid values are defined as member of IITD code type. primary_ind varchar21 0 1 Field indicating whether the record is a primary image or not. ITEM_IMAGE PRIMARY_IND RIB VARCHAR2(1 BYTE) Yes Field indicating whether the record is a primary image or not. display_priority number4 0 1 Field to specify the display sequence order of images associated to the item per priority. ITEM_IMAGE DISPLAY_PRIORITY RIB NUMBER(4,0) Yes Field to specify the display sequence order of images associated to the item per priority. image_desc varchar240 0 1 This field contains the description associated with the image of the item. ITEM_IMAGE IMAGE_DESC RIB VARCHAR2(40 BYTE) Yes This field contains the description associated with the image of the item.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemImageRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemImageRef

XML-Schema Name:ItemImageRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemImageRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. ITEM_IMAGE ITEM RIB VARCHAR2(25 BYTE) Yes Unique identifier for the item. image_name varchar2120 1 1 Name of the image. ITEM_IMAGE IMAGE_NAME RIB VARCHAR2(120 BYTE) Yes Name of the image.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemLocDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemLocDesc ItemLocPhys ItemLocVirt CustFlexAttriVo ItemLocVirtRepl

XML-Schema Name:ItemLocDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Not Yet Available ITEM_LOC ITEM RIB VARCHAR2(25 BYTE) Yes Item Identifier ItemLocPhys * 1 unbounded Description is not available.

XML-Schema Name:ItemLocPhys Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocPhys in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description physical_loc number10 1 1 Identifier of the physical location where the item is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type varchar21 1 1 Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the physical_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the physical_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. returnable_ind varchar21 0 1 This field will contain a value of Yes when the item can be returned to the location. ITEM_LOC RETURNABLE_IND RIB VARCHAR2(1 BYTE) No Indicates if an item can be returned ItemLocVirt * 0 unbounded Description is not available. ItemLocVirtRepl * 0 unbounded Description is not available.

XML-Schema Name:ItemLocVirt Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocVirt in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description loc number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. ITEM_LOC LOCATION RIB NUMBER(10,0) Yes Location where the item is to be found. This field may contain a store or a warehouse. loc_type varchar21 1 1 Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). ITEM_LOC LOC_TYPE RIB VARCHAR2(1 BYTE) Yes The Location Type local_item_desc varchar2250 1 1 NA ITEM_LOC LOCAL_ITEM_DESC RIB VARCHAR2(250 BYTE) Yes Item Description local_short_desc varchar2120 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. status varchar21 1 1 Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). ITEM_LOC STATUS RIB VARCHAR2(1 BYTE) No Current status of the item at the store primary_supp number10 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_cntry varchar23 0 1 Contains the origin country which will be considered the primary country for the item/location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. receive_as_type varchar21 0 1 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 'E'ach or 'P'ack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. taxable_ind varchar21 1 1 Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). ITEM_LOC TAXABLE_IND RIB VARCHAR2(1 BYTE) No Indicates whether the item is taxable at the store. source_method varchar21 0 1 Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. source_wh number10 0 1 If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_retail number20_4 0 1 Unit retail of the item in the selling Unit of Measure. Only published for create not modify. ITEM_LOC INITIAL_UNIT_RETAIL RIB NUMBER(20,4) No Unit retail of the item in the selling Unit of Measure. selling_unit_retail number20_4 0 1 Selling unit retail in selling unit of measure. Only published for create, not update ITEM_LOC SELLING_UNIT_RETAIL RIB NUMBER(20,4) No Selling unit retail in selling unit of measure. selling_uom varchar24 0 1 Selling Unit of measure. Only published for Create not update. ITEM_LOC SELLING_UOM RIB NUMBER(20,4) No The selling unit of measure store_price_ind varchar21 0 1 Indicates if the location can modify the item's price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar26 0 1 Purchase Type Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uin_type varchar26 0 1 This attribute will contain the type of the unique identification number (UIN) used to identify instances of the item at the location. Valid values for this attribute should be user-definable on the RMS code tables. This attribute should be nullable. ITEM_LOC UIN_TYPE RIB VARCHAR2(6 BYTE) No This attribute will contain the type of the unique identification number (UIN) used to identify instances of the item at the location. uin_label varchar26 0 1 This attribute will contain the label for the UIN when displayed in SIM. Valid values should be user-definable on the RMS code tables. This attribute should be nullable but a value is required when a UIN Type is specified. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. capture_time varchar26 0 1 This attribute will indicate when the UIN should be captured for an item during transaction processing. There are 2 valid values for this field which should be stored on the RMS code tables: Sale and Store Receiving. This attribute should be nullable. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ext_uin_ind varchar21 0 1 This Yes/No indicator indicates if UIN is being generated in the external system (e.g. SIM). This value will always be N (no) when the Capture Time attribute is set to Sale. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ranged_ind varchar21 1 1 An indicator to differentiate between user ranged locations and RMS program ranged locations. Values are 'Y' or 'N'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA item_parent varchar225 0 1 ID identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_grandparent varchar225 0 1 ID identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ti number12_4 0 1 Number of shipping units (cases) that make up one tier of a pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. hi number12_4 0 1 Number of tiers that make up a complete pallet (height). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_ord_mult varchar21 0 1 This column contains the multiple in which the item needs to be shipped from a warehouse to the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. daily_waste_pct number12_4 0 1 Average percentage lost from inventory on a daily basis due to natural wastage. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. meas_of_each number12_4 0 1 Size of an each in terms of the uom_of_price. For example 12 oz. Used in ticketing. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. meas_of_price number12_4 0 1 Size to be used on the ticket in terms of the uom_of_price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uom_of_price varchar24 0 1 Unit of measure that will be used on the ticket for this item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_variant varchar225 0 1 This field is used to address sales of PLUs (i.e. above transaction level items) when inventory is tracked at a lower level (i.e. UPC). This field will only contain a value for items one level higher than the transaction level. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_cost_pack varchar225 0 1 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inbound_handling_days number2 0 1 This field indicates the number of inbound handling days for an item at a warehouse type location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. regular_unit_retail number20_4 0 1 This field holds the unit retail in the standard unit of measure for the item/location (zone) combination. This field is stored in the local currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. multi_units number12_4 0 1 This field contains the multi-units for the item/location (zone) combination. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. multi_unit_retail number20_4 0 1 This field holds the multi-unit retail in the multi-selling unit of measure for the item/location (zone) combination. This field is stored in teh local currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. multi_selling_uom varchar24 0 1 This field holds the selling unit of measure for this item/location (zone) combinations multi-unit retail. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. clear_ind varchar21 0 1 "Indicates if item is on clearance at the store. Valid values are: Y = Yes, the item is on clearance N = No, the item is not on clearance". Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. costing_loc number10 0 1 Numeric identifier of the costing location for the franchise store.This field may contain a store or a warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. costing_loc_type varchar21 0 1 This field holds the type of costing location in the costing location field. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. currency_code varchar23 0 1 This field contains the currency code under which the store/wh operates. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. launch_date xs:dateTime 0 1 Holds the date that they item should first be sold at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. qty_key_options varchar26 0 1 Determines whether the qty key on a POS should be used for this item at the location. ITEM_LOC QTY_KEY_OPTIONS RIB VARCHAR2(6 BYTE) No Determines whether the qty key on a POS should be used for this item at the location. manual_price_entry varchar26 0 1 Determines whether the price can/should be entered manually on a POS for this item at the location. ITEM_LOC MANUAL_PRICE_ENTRY RIB VARCHAR2(6 BYTE) No Determines whether the price can/should be entered manually on a POS for this item at the location. deposit_code varchar26 0 1 Indicates whether a deposit is associated with this item at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. food_stamp_ind varchar21 0 1 Indicates whether the item is approved for food stamps at the location. This value will be downloaded to the POS. ITEM_LOC FOOD_STAMP_IND RIB VARCHAR2(1 BYTE) No Indicates whether the item is approved for food stamps at the location. wic_ind varchar21 0 1 Indicates whether the item is approved for WIC at the location. This value will be downloaded to the POS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. proportional_tare_pct number12_4 0 1 Holds the value associated of the packaging in items sold by weight at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. fixed_tare_value number12_4 0 1 Holds the value associated of the packaging in items sold by weight at the location. ITEM_LOC FIXED_TARE_VALUE RIB NUMBER(12,4) No Holds the value associated of the packaging in items sold by weight at the location. fixed_tare_uom varchar24 0 1 Holds the unit of measure value associated with the tare value. The only processing RMS does involving the fixed tare value and UOM is downloading it to the POS. ITEM_LOC FIXED_TARE_UOM RIB VARCHAR2(4 BYTE) No Holds the unit of measure value associated with the tare value. reward_eligible_ind varchar21 0 1 Holds whether the item is legally valid for various types of bonus point/award programs at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. natl_brand_comp_item varchar225 0 1 Holds the nationally branded item to which you would like to compare the current item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. return_policy varchar26 0 1 Holds the return policy for the item at the location. Valid values for this field belong to the code_type RETP. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stop_sale_ind varchar21 0 1 Indicates that sale of the item should be stopped immediately at the location (i.e. in case of recall etc). ITEM_LOC STOP_SALE_IND RIB VARCHAR2(1 BYTE) No Indicates that sale of the item should be stopped immediately at the location. elect_mtk_clubs varchar26 0 1 Holds the code that represents the marketing clubs to which the item belongs at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. report_code varchar26 0 1 Code to determine which reports the location should run. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. req_shelf_life_on_selection number4 0 1 Holds the required shelf life for an item on receipt in days. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. req_shelf_life_on_receipt number4 0 1 Holds the required shelf life for an item on receipt in days. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_reorderable_ind varchar21 0 1 This field indicates whether the store may re-order the item.This field is required to be either= Y - yes or N - no. The field will default to N. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. rack_size varchar26 0 1 Indicates the rack size that should be used for the item. This field is not required. Valid values for the field can be found and defined in the code_type RACK. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. full_pallet_item varchar21 0 1 Indicates whether a store must reorder an item in full pallets only. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. in_store_market_basket varchar26 0 1 Holds the in store market basket code for this item/location combination. Valid values for the field can be found in the code_type STMB. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. storage_location varchar27 0 1 Holds the current storage location or bin number for the item at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. alt_storage_location varchar27 0 1 Holds the preferred alternate storage location or bin number for the item at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. refundable_ind varchar21 0 1 This field will contain a value of Yes when the item is refundable at the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. back_order_ind varchar21 0 1 This field will contain a value of Yes when the item can be back ordered to the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. promotable_ind varchar21 0 1 This field will indicates,if the item can be included on promotions or not. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_cost number20_4 0 1 This field contains the current unit cost of the item Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pickup_lead_time number4 0 1 Contains the time it takes to get the item from the Supplier to the Initial Receiving Location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. cost_uom varchar24 0 1 Unit of measure associated with the item cost. It is held to allow costs to be managed in a separate UOM from the standard UOM. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. calculation_basis varchar21 0 1 This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_rate number12_4 0 1 This column contains the percentage of the retail price which will determnie the cost paid to the supplier for a consignment or concession item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. rfid_ind varchar21 0 1 This indicates if the item is RFID tagged or not. Valid values are Yes (Y) and No (N). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemLocVirtRepl Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocVirtRepl in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description loc number10 1 1 Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type varchar21 1 1 Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_repl_supplier number10 0 1 Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location. Used for items on Direct to Store/Warehouse or Cross-docked replenishment. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. repl_method varchar26 0 1 Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include 'C'onstant, 'M'in/Max, 'F'loating point, 'T'ime Supply, 'D'ynamic, 'SO' Store Orders. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. reject_store_order_ind varchar21 0 1 Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is 'N', then store orders for all need dates are valid. If 'Y', store orders with needs date on or after the NEXT_DELIVERY_DATE are valid." Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. next_delivery_date xs:dateTime 0 1 Contains the next delivery date calculated for the next review cycle. If, for the next review cycle, an order will be created that is calculated to arrive on Thursday, this field will be updated with Thursday's date. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. multiple_runs_per_day_ind varchar21 0 1 Indicates if the item-location is replenished multiple times per day. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemLocRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemLocRef ItemLocPhysRef ItemLocVirtRef

XML-Schema Name:ItemLocRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemLocPhysRef * 1 unbounded Description is not available.

XML-Schema Name:ItemLocPhysRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocPhysRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description physical_loc number10 1 1 Identifier of the physical location where the item is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type varchar21 0 1 Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the physical_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the physical_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemLocVirtRef * 1 unbounded Description is not available.

XML-Schema Name:ItemLocVirtRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocVirtRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description loc number10 1 1 Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupCtyDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupCtyDesc CustFlexAttriVo

XML-Schema Name:ItemSupCtyDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. origin_country_id varchar23 1 1 The country where the item was manufactured or significantly altered. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. Each item can have one and only one primary supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_country_ind varchar21 1 1 This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination can have one and only one primary country. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_cost number20_4 1 1 This field contains the current corporate unit cost for the item from the supplier /origin country. This field is stored in the Supplier's currency. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. lead_time number4 0 1 This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pickup_lead_time number4 0 1 Contains the time that will be taken to get the item from the supplier to the initial receiving location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_pack_size number12_4 1 1 This field contains the quantity that orders must be placed in multiples of for the supplier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inner_pack_size number12_4 1 1 This field contains the break pack size for this item from the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_lvl varchar26 1 1 This column is used to determine how order quantities will be rounded to case, layer and pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. min_order_qty number12_4 0 1 This field contains the minimum quantity that can be ordered at one from the supplier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. max_order_qty number12_4 0 1 This field contains the maximum quantity that can be ordered at one from the supplier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. packing_method varchar26 0 1 This field indicates whether the packing method for the item in the container is flat or hanging. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_uop varchar26 0 1 Contains the default unit of purchase for the item/supplier/country. Valid values include 'C'ase and 'P'allet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ti number12_4 1 1 Number of shipping units (cases) that make up one tier of the pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. hi number12_4 1 1 Number of tiers that make up a complete pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. cost_uom varchar24 0 1 A cost UOM is held to allow costs to be managed in a separate UOM to the standard UOM. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tolerance_type varchar26 0 1 The unit of tolerance for catch weight simple packs. Valid values are: 'A'-actual 'P' - percent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. max_tolerance number12_4 0 1 The maximum tolerance value for the catch weight simple pack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA round_to_inner_pct number12_4 0 1 This column will hold the Inner Rounding Threshold value. During rounding, this value is used to determine whether to round partial Inner quantities up or down. If the Inner-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_to_case_pct number12_4 0 1 This column will hold the Case Rounding Threshold value. During rounding, this value is used to determine whether to round partial Case quantities up or down. If the Case-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_to_layer_pct number12_4 0 1 This column will hold the Layer Rounding Threshold value. During rounding, this value is used to determine whether to round partial Layer quantities up or down. If the Layer-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. round_to_pallet_pct number12_4 0 1 This column will hold the Pallet Rounding Threshold value. During rounding, this value is used to determine whether to round partial Pallet quantities up or down. If the Pallet -fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_type_1 varchar26 0 1 This field identifies partner type of supplier hierarchy level 1.This field will always have the partner type S1 which indicates manufacturer.. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_lvl_1 varchar210 0 1 Highest level of supplier hierarchy which is there to indicate a partner, such as a manufacturer, in the supply chain that gives rebates to the retailer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_type_2 varchar26 0 1 This field identifies partner type of supplier hierarchy level 2 . This field will always have the partner type S2 which indicates distributor. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_lvl_2 varchar210 0 1 Second highest level of supplier hierarchy which is there to indicate a partner, such as a distributor in the supply chain that gives rebates to the retailer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_type_3 varchar26 0 1 This field identifies partner type of supplier hierarchy level 3.This field will always have the partner type S3 which indicates wholesaler. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_hier_lvl_3 varchar210 0 1 Third highest level of supplier hierarchy which is uder to indicate a partner, such as a wholesaler in the supply chain that gives rebates to the retailer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. negotiated_item_cost number20_4 0 1 This will hold the supplier negotiated item cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations negotiated item cost will be stored in this field. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. extended_base_cost number20_4 0 1 This will hold the extended base cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations extended base cost will be stored in this field. Extended base cost is the cost inclusive of all the taxes that affect the WAC. In case of GTAX , Extended Base Cost = Base Cost + Non-recoverable taxes. In case of VAT, Extended Base Cost = Base Cost. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inclusive_cost number20_4 0 1 This will hold the inclusive cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations inclusive cost will be stored in this field. This cost will have both the recoverable and non recoverable taxes included. In case of GTAX , Inclusive Cost = Base Cost + Non-recoverable taxes + Recoverable Taxes. In case of VAT, Inclusive Cost = Base Cost + VAT. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. base_cost number20_4 0 1 This field will hold the tax exclusive cost of the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar21 0 1 This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. calculation_basis varchar21 0 1 This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_rate number12_4 0 1 This column contains the percentage of the retail price which will determnie the cost paid to the supplier for a consignment or concession item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupCtyMfrDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupCtyMfrDesc

XML-Schema Name:ItemSupCtyMfrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyMfrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Item ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier number10 1 1 Supplier ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. manufacturer_ctry_id varchar23 1 1 Country ID of manufacturer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_manufacturer_ctry_ind varchar21 1 1 Primary country of manufacturer indicator. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupCtyMfrRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupCtyMfrRef

XML-Schema Name:ItemSupCtyMfrRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyMfrRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Item ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier number10 1 1 Supplier ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. manufacturer_ctry_id varchar23 1 1 Country ID of manufacturer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupCtyRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupCtyRef

XML-Schema Name:ItemSupCtyRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. origin_country_id varchar23 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupDesc CustFlexAttriVo

XML-Schema Name:ItemSupDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. An item can have one and only one primary supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vpn varchar230 0 1 This field contains the Vendor Product Number for the Item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_label varchar215 0 1 This field contains the supplier label. It will only be popluated if item is a style. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. consignment_rate number12_4 0 1 This field contains the consignment rate for this item for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_1 varchar2120 0 1 This field contains the first supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_2 varchar2120 0 1 This field contains the second supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_3 varchar2120 0 1 This field contains the third supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_diff_4 varchar2120 0 1 This field contains the fourth supplier differentiator and/or description. This field may only contain a value for items with an item_parent. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pallet_name varchar26 0 1 Code referencing the name used to refer to the pallet. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. case_name varchar26 0 1 Code referencing the name used to refer to the case. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inner_name varchar26 0 1 Code referencing the name used to refer to the inner. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supp_discontinue_date xs:dateTime 0 1 Date when the supplier discontinues an item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. direct_ship_ind varchar21 0 1 A value of 'Y'es in this field indicates that any item associated with this supplier is eligible for a direct shipment from the supplier to the customer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA primary_case_size varchar26 0 1 This field indicates the primary case size for the item supplier when an orderable item is configured for informal case types. Used only if AIP is interfaced. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupRef

XML-Schema Name:ItemSupRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupUomDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupUomDesc

XML-Schema Name:ItemSupUomDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupUomDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier number10 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uom varchar24 1 1 The unit of measure that the item is being measured in. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value number20_4 1 1 This field will store the equivalent value of the Item/Suppliers shipping carton in the associated unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemSupUomRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemSupUomRef

XML-Schema Name:ItemSupUomRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupUomRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. supplier number10 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uom varchar24 1 1 The unit of measure that the item is being measured in. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemTcktDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemTcktDesc TicketTypeDtl

XML-Schema Name:ItemTcktDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTcktDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_type_id varchar24 1 1 This field uniquely identifies the ticket type which is associated with the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_type_desc varchar2120 0 1 This field contains a description of the ticket or label type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sel_ind varchar21 0 1 Indicates if the ticket type is a shelf edge label. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. po_print_type varchar21 0 1 This field indicates when the ticket type for the given item should be printed by default, upon the approval or receipt of the purchase order. Valid values are: A and R. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. print_on_pc_ind varchar21 0 1 This field indicates whether or not this type of ticket should be printed for this item when a permanent price change goes into effect. Valid values in this field are:Y - Yes N - No. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_over_pct number12_4 0 1 This field contains a percent which indicates the amount of tickets which should be printed for a given event. If the event causing tickets to be printed is approving or receiving a purchase order, then this field indicates the quantity of tickets which should be printed greater than the quantity of the purchase order. If the event causing the tickets to be printed is a permanent price change, this field would indicate the quantity of tickets which should be printed greater than the stock on hand. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. TicketTypeDtl * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc.

XML-Schema Name:TicketTypeDtl Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TicketTypeDtl in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description ticket_item_id varchar24 0 1 This field contains a character string which uniquely identifies an attribute which will appear on a ticket or label such as retail price or price per unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_item_id_desc varchar2250 0 1 This field contains the description of the ticket_item_id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 0 1 This field contains a number which uniquely defines a user-defined attribute which is to be printed on this ticket type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemTcktRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemTcktRef

XML-Schema Name:ItemTcktRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTcktRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ticket_type_id varchar24 1 1 This field uniquely identifies the ticket type which is associated with the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUDADateDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUDADateDesc

XML-Schema Name:ItemUDADateDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDADateDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_date xs:dateTime 1 1 This field contains the effective date for the Uda id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUDADateRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUDADateRef

XML-Schema Name:ItemUDADateRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDADateRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains a unique number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_date xs:dateTime 0 1 Functional key that uniquely identifies the change to the item_master, item_supplier, item_supp_country, item_supp_country_dim, packitem, item_image, uda_item tables that caused the record to be written to the ITEM_MFQUEUE. Item, uda_id and uda_date uniquely identify an uda_item_date. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUDAFFDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUDAFFDesc

XML-Schema Name:ItemUDAFFDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDAFFDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_text varchar2250 0 1 This field contains the text value of the user-defined attribute for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUDAFFRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUDAFFRef

XML-Schema Name:ItemUDAFFRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDAFFRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_text varchar2250 0 1 Functional key that uniquely identifies the change to the item_master, item_supplier, item_supp_country, item_supp_country_dim, packitem, item_image, uda_item tables that caused the record to be written to the ITEM_MFQUEUE. Item, uda_id and uda_text uniquely identify an uda_item_ff. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUDALOVDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUDALOVDesc

XML-Schema Name:ItemUDALOVDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDALOVDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Item ID Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains the unique identified of the Attribute Group being added or delete to the item list. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_value varchar230 1 1 Contains the value of the Attribute Group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_desc varchar2120 0 1 This field contains a description of the User-Defined Attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_value_desc varchar2250 0 1 This field contains a description of the UDA value. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUDALOVRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUDALOVRef

XML-Schema Name:ItemUDALOVRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDALOVRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uda_value varchar230 1 1 This field contains value of the user-defined attribute for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUPCDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUPCDesc

XML-Schema Name:ItemUPCDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUPCDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item_id varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_parent varchar225 0 1 Unique identifier for the item/group at the level above the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_ref_item_ind varchar21 0 1 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'o. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. format_id varchar21 0 1 This field will hold the format id that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. prefix number2 0 1 This field holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. item_number_type varchar26 0 1 This type can hold a number of digits count umber_type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUPCRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUPCRef ItemRef

XML-Schema Name:ItemUPCRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUPCRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description ItemRef:ItemRef * 1 1 It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:ItemRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Mapped to ,RK_ITEM_SUPPLIER,RK_ITEM_SUPP_COUNTRY,AS_ITM_RTL_STR,AS_ITM as well. Not Yet Available ITEM_HDR ITEM RIB VARCHAR2(25 BYTE) Yes Item Identifier

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemRef

XML-Schema Name:ItemRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Mapped to ,RK_ITEM_SUPPLIER,RK_ITEM_SUPP_COUNTRY,AS_ITM_RTL_STR,AS_ITM as well. Not Yet Available ITEM_HDR ITEM RIB VARCHAR2(25 BYTE) Yes Item Identifier

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrClsDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrClsDesc CustFlexAttriVo

XML-Schema Name:MrchHrClsDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrClsDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description class number4 1 1 Contains the number which uniquely identifies the class within the department. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Contains the number which uniquely identifies the class within the system. class_name varchar2120 1 1 Contains the name of the class which, along with the class number, identifies the class. MERCH_HIER HIERARCHY_NODE_NAME RIB VARCHAR2(150 BYTE) Yes The name of the class class_vat_ind varchar21 0 1 This field determines if retail is displayed and held with or with out vat. This field is only editable when vat is turned on in the system and defined at the class level, when that is the case the field can vary between 'Y' and 'N' by class. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 1 1 Contains the number of the department of which the class is a member. MERCH_HIER PARENT_NODE_ID RIB NUMBER(10,0) Yes Department ID CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA unique_class_id number10 0 1 Contains the unique class id within the system. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrClsRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrClsRef

XML-Schema Name:MrchHrClsRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrClsRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description class number4 1 1 Contains the number which uniquely identifies the class within the department. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Identifies the CLASS dept number4 1 1 Contains the number of the department of which the class is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unique_class_id number10 0 1 Contains the unique class id within the system. NA NA NA NA NA NA

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDeptDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDeptDesc CustFlexAttriVo

XML-Schema Name:MrchHrDeptDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrDeptDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description dept number4 1 1 Contains the number which uniquely identifies the department. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes The department identifier dept_name varchar2120 0 1 Not used by SIM MERCH_HIER HIERARCHY_NODE_NAME RIB VARCHAR2(150 BYTE) Yes The department name buyer number4 0 1 Contains the number which uniquely identifies the buyer for that department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar26 0 1 Contains a code which indicates whether items in this department are normal merchandise or consignment stock. Valid values are:0 = Normal Merchandise1 = Consignment Stock. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. total_market_amt number24_4 0 1 Contains the total market amount that is expected for the department. The field can be used for analytics or reporting. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merch number4 0 1 Contains the number which uniquely describes the merchandiser for that department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. group_no number4 0 1 Contains the number of the group in which the department exists. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bud_mkup number12_4 0 1 Contains the Budgeted Markup percentage. This term is synonymous with the term Markup Percent of Cost. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. profit_calc_type number1 0 1 Contains a number which indicates whether profit will be calculated by Direct Cost or by Retail Inventory. Valid values are:1 = Direct Cost, 2 = Retail Inventory Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. markup_calc_type varchar22 0 1 Contains the code letter which determines how markup is calculated in this department. Valid values are:C = Cost, R = Retail Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. otb_calc_type varchar21 0 1 Contains the code letter which determines how OTB is calculated in this department. Valid values are:C = Cost, R = Retail Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. max_avg_counter number5 0 1 A maximum average counter will hold the maximum count of days with acceptable data to include in an avarage for items within the department. Although not required on the table, if the RPM_ind column is 'Y' (yes) on the system_options table, then this field will be required when maintaining departments online. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. avg_tolerance_pct number12_4 0 1 A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data and constrain outliers. This column will hold 70% as 70 - not 0.70. Although not required on the table, if the RPM_ind column Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bud_int number12_4 0 1 Contains the Budgeted Intake percentage. Budgeted Intake is the percent of total take that is income and is synonymous with the term Markup Percent of Retail. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept_vat_incl_ind varchar21 0 1 This indicator will be be used only to default to the class level indicator when classes are initially set up for the department and will only be available when the system level class vat option is on. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDeptRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDeptRef

XML-Schema Name:MrchHrDeptRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrDeptRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description dept number4 1 1 Contains the number which uniquely identifies the department. MERCH_HIER DEPT RIB NUMBER(10,0) Yes Department Identifier

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDivDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDivDesc

XML-Schema Name:MrchHrDivDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrDivDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description division number4 1 1 Contains the number which uniquely identifies the division of the company. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Contains the number which uniquely identifies the division of the company. div_name varchar2120 1 1 Contains the name which, along with the division number, identifies the division of the company. MERCH_HIER HIERARCHY_NODE_NAME RIB VARCHAR2(150 BYTE) Yes Name of Division buyer number4 0 1 Contains the number of the buyer associated with the division. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merch number4 0 1 Contains the number of the merchandiser associated with the division. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. total_market_amt number24_4 0 1 Contains the total market amount that is expected for the division. The field can be used for analytics or reporting. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDivRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDivRef

XML-Schema Name:MrchHrDivRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrDivRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description division number4 1 1 Contains the number which uniquely identifies the division of the company. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Contains the number which uniquely identifies the division of the company.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrGrpDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrGrpDesc

XML-Schema Name:MrchHrGrpDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrGrpDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description group_no number4 1 1 Contains the number which uniquely identifies the group. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Contains the number which uniquely identifies the group. group_name varchar2120 1 1 Contains the description which, along with the group number, identifies the group. MERCH_HIER HIERARCHY_NODE_NAME RIB VARCHAR2(150 BYTE) Yes Contains the description which, along with the group number, identifies the group. buyer number4 0 1 Contains the number of the buyer associated with the group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merch number4 0 1 Contains the number of the merchandiser associated with the group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. division number4 1 1 Contains the number of the division of which the group is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrGrpRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrGrpRef

XML-Schema Name:MrchHrGrpRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrGrpRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description group_no number4 1 1 Contains the number which uniquely identifies the group. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Contains the number which uniquely identifies the group.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrSclsDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrSclsDesc CustFlexAttriVo

XML-Schema Name:MrchHrSclsDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrSclsDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description subclass number4 1 1 Contains the number which uniquely identifies the subclass within the department and class. MERCH_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Contains the number which uniquely identifies the subclass. subclass_name varchar2120 1 1 Contains the name of the subclass which, along with the subclass number, uniquely identifies the subclass. MERCH_HIER HIERARCHY_NODE_NAME RIB VARCHAR2(150 BYTE) Yes Contains the name of the subclass which, along with the subclass number, uniquely identifies the subclass. class number4 1 1 Contains the class number of which the subclass is a member. MERCH_HIER PARENT_NODE_ID RIB NUMBER(10,0) Yes Class ID dept number4 1 1 Contains the department number of which the subclass is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA unique_subclass_id number10 0 1 Contains the unique subclass id within the system. NA NA NA NA NA NA unique_class_id number10 0 1 Contains the unique class id the subclass is part of. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrSclsRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrSclsRef

XML-Schema Name:MrchHrSclsRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MrchHrSclsRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description subclass number4 1 1 Contains the number which uniquely identifies the subclass within the department and class. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. class number4 1 1 Contains the class number of which the subclass is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 1 1 Contains the department number of which the subclass is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unique_subclass_id number10 0 1 Contains the unique subclass id within the system. NA NA NA NA NA NA

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/OrgHierDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure OrgHierDesc

XML-Schema Name:OrgHierDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OrgHierDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description hier_level varchar22 1 1 The level of the Organizational Hierarchy of the message. Valid values are; Chain, Area, Region, District ORG_HIER HIERARCHY_LEVEL RIB VARCHAR2(10 BYTE) Yes The level in the hiearchy hier_value number10 1 1 Hierarchy value. ORG_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Hierarchy value. hier_desc varchar2120 0 1 Hierarchy description. ORG_HIER HIERARCHY_NODE_NAME RIB VARCHAR2(150 BYTE) Yes The Node description mgr_name varchar2120 0 1 Manager name of the hierarchy. ORG_HIER MGR_NAME RIB VARCHAR2(120 BYTE) No Manager name of the hierarchy. currency_code varchar23 0 1 The currency code for the Hierarchy entity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. parent_id number10 0 1 Contains the number that identifies the Hierarchy level. ORG_HIER PARENT_ID RIB NUMBER(10,0) No Contains the number that identifies the Hierarchy level. parent_level varchar22 0 1 Contains the parent level of the current Organizational Hierarchy level. Valid values are; for Area parent - Chain, for Region parent - Area, for District parent - Region. ORG_HIER PARENT_LEVEL RIB VARCHAR2(10 BYTE) No Contains the parent level of the current Organizational Hierarchy level.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/OrgHierRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure OrgHierRef

XML-Schema Name:OrgHierRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OrgHierRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description hier_level varchar22 1 1 The level of the Organizational Hierarchy of the message. Valid values are; Chain, Area, Region, District ORG_HIER HIERARCHY_LEVEL RIB VARCHAR2(10 BYTE) Yes The level of the Organizational Hierarchy hier_value number10 1 1 Contains the number which uniquely identifies the hierarchy within the system. ORG_HIER HIERARCHY_NODE_ID RIB NUMBER(10,0) Yes Contains the number which uniquely identifies the hierarchy within the system. parent_id number10 0 1 Contains the number that identifies the Hierarchy level above. ORG_HIER PARENT_ID RIB NUMBER(10,0) No Contains the number that identifies the Hierarchy level above. parent_level varchar22 0 1 Contains the parent level of the current Organizational Hierarchy level. Valid values are; for Area parent - Chain, for Region parent - Area, for District parent - Region. ORG_HIER PARENT_LEVEL RIB VARCHAR2(10 BYTE) No Contains the parent level of the current Organizational Hierarchy level

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RelatedItemDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure RelatedItemDesc RelatedItemDtl

XML-Schema Name:RelatedItemDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RelatedItemDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 The main item against which the relationship is defined. RELATED_ITEM ITEM RIB VARCHAR2(25 BYTE) Yes The main item against which the relationship is defined. relationship_id number15 1 1 A system generated numeric field that uniquely identifies the relationship record in related_item_head. RELATED_ITEM RELATIONSHIP_ID RIB NUMBER(20,0) Yes A system generated numeric field that uniquely identifies the relationship record in related_item_head. relationship_name varchar2120 1 1 This is the user entered name of the relationship. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. relationship_type varchar26 1 1 Describes the type of relationship. Valid values are in the codes table under code_type 'IREL'. RELATED_ITEM RELATIONSHIP_TYPE RIB VARCHAR2(6 BYTE) Yes Describes the type of relationship. Valid values are in the codes table under code_type 'IREL'. mandatory_ind mandatory_ind 1 1 Indicates whether the relationship is mandatory or not. Valid values: 'Y' (yes), 'N' (no). RELATED_ITEM MANDATORY_IND RIB VARCHAR2(1 BYTE) Yes Indicates whether the relationship is mandatory or not. RelatedItemDtl * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc.

XML-Schema Name:RelatedItemDtl Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RelatedItemDtl in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description related_item varchar225 1 1 Item for which related items are defined. Valid transaction level/sellable item. Multiple items can be defined for a relationship. RELATED_ITEM_DTL RELATED_ITEM RIB VARCHAR2(25 BYTE) Yes Item for which related items are defined. Valid transaction level/sellable item. Multiple items can be defined for a relationship. priority number4 0 1 Relationship priority. Applicable only for relationship type SUBS. RELATED_ITEM_DTL PRIORITY RIB NUMBER(4,0) No Relationship priority effective_date xs:dateTime 0 1 The related item can be used on transactions starting this date. RELATED_ITEM_DTL EFFECTIVE_DATE RIB TIMESTAMP(6) No The related item can be used on transactions starting this date. end_date xs:dateTime 0 1 The related item can be used on transactions until this date. A value of null means that it is always effective. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RelatedItemRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure RelatedItemRef

XML-Schema Name:RelatedItemRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RelatedItemRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 The main item for which the relationship is defined. RELATED_ITEM ITEM RIB VARCHAR2(25 BYTE) Yes The main item for which the relationship is defined relationship_id number15 1 1 Unique identifier for each relationship header. RELATED_ITEM RELATIONSHIP_ID RIB NUMBER(20,0) Yes Identifies the relationship related_item varchar225 0 1 Item id of the related item. RIB or/and RSB Fill column length. Yes

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure StoreDesc AddrDesc CustFlexAttriVo CustFlexAttriVo StoreHoursDesc

XML-Schema Name:StoreDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description store number10 1 1 Contains the number to uniquely identify the store. STORE STORE_ID RIB NUMBER(10,0) Yes Contains the number to uniquely identify the store. store_type varchar21 1 1 This will indicate whether a particular store is a franchise or company store. STORE STORE_TYPE RIB VARCHAR2(6 BYTE) No This will indicate whether a particular store is a franchise or company store. store_name varchar2150 1 1 Contains the name of the store. STORE STORE_NAME RIB VARCHAR2(150 BYTE) No Contains the name of the store. store_name10 varchar210 0 1 Contains a ten character abbreviation of the store name. STORE STORE_NAME_10 RIB VARCHAR2(10 BYTE) No Contains a ten character abbreviation of the store name. store_name3 varchar23 0 1 Contains a three character abbreviation of the store name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_add1 varchar2240 0 1 Holds the store primary address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_add2 varchar2240 0 1 Holds the store primary address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_city varchar2120 0 1 Holds the city of the store primary address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 Holds the county of the store primary address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state varchar23 0 1 Holds the state of the store primary address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_id varchar23 0 1 Holds the country of the store primary address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_pcode varchar230 0 1 Holds the postal code of the store primary address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_class varchar21 0 1 Contains the code letter indicating the class of which the store is a member. Valid values are A through E. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_mgr_name varchar2120 0 1 Contains the name of the store manager. STORE MANAGER RIB VARCHAR2(120 BYTE) No Contains the name of the store manager. store_open_date xs:dateTime 0 1 Contains the date on which the store opened. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_close_date xs:dateTime 0 1 Contains the date on which the store closed. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. acquired_date xs:dateTime 0 1 Contains the date on which the store was acquired. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. remodel_date xs:dateTime 0 1 Contains the date on which the store was last remodeled. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. fax_number varchar220 0 1 Contains the fax number for the store. STORE FAX_NUMBER RIB VARCHAR2(20 BYTE) No Contains the fax number for the store. phone_number varchar220 0 1 Contains the phone number for the store. STORE PHONE_NUMBER RIB VARCHAR2(20 BYTE) No Contains the phone number for the store. email varchar2100 0 1 Contains the email address for the location. STORE EMAIL RIB VARCHAR2(100 BYTE) No Contains the email address for the location. total_square_ft number8 0 1 Contains the total square footage of the store. STORE TOTAL_SQ_FEET RIB NUMBER(8,0) No Contains the total square footage of the store. selling_square_ft number8 0 1 Contains the total square footage of the store's selling area. STORE SELLING_SQ_FEET RIB NUMBER(8,0) No Contains the total square footage of the store's selling area. linear_distance number8 0 1 Contains the total space of the location that can be used for merchandise. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. channel_id number4 0 1 In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_format number4 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mall_name varchar2120 0 1 Contains the name of the mall in which the store is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. district number10 0 1 Contains the number of the district in which the store is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. district_name varchar2120 0 1 Contains the name of the district. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. promo_zone number4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. promo_desc varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. transfer_zone number4 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. STORE TRANSFER_ZONE RIB NUMBER(4,0) No Contains the transfer zone in which the store is located description varchar21000 0 1 Contains the name of the transfer zone. STORE TRANSFER_ZONE_DESC RIB VARCHAR2(120 BYTE) No Contains the name of the transfer zone. default_wh varchar210 0 1 Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines which stores are associated with or sourced from a warehouse. Will hold only virtual warehouses in a multi-channel environment. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stop_order_days number3 0 1 Contains the number of days before a store closing that the store will stop accepting orders. This column will be used when the store_close_date is defined. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. start_order_days number3 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. currency_code varchar23 0 1 This field contains the currency code under which the store operates. STORE CURRENCY_CODE RIB VARCHAR2(3 BYTE) No This field contains the currency code under which the store operates. lang number6 0 1 This column identifies the language to be used for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. integrated_pos_ind varchar21 0 1 Indicates whether the POS system at the store is integrated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_number varchar29 0 1 This type can hold a number of digits count umber. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_loc varchar24 0 1 This field contains the Dun and Bradstreet number to identify the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA pricing_loc number10 0 1 If this field is null, the new store will not be added to RPM_ZONE_LOCATION table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pricing_loc_curr varchar23 0 1 This is the currency code of the pricing_loc store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_unit_id number15 0 1 Column will contain the organizational unit ID value. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. timezone_name varchar264 0 1 Indicates the time zone of the store. For example, 'America/New_York'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA store_name_secondary varchar2150 0 1 Contains the secondary name of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_class_description varchar2150 0 1 Contains the description of the class of which the store is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vat_region number4 0 1 Contains the number of the Value Added Tax region in which this store is contained. STORE VAT_REGION RIB NUMBER(4,0) No Contains the number of the Value Added Tax region in which this store is contained. vat_include_ind varchar21 0 1 Indicates whether or not Value Added Tax will be included in the retail prices in the POS files coming from the store. Valid values are Y or N. STORE VAT_INCL_IND RIB VARCHAR2(1 BYTE) No Indicates whether or not Value Added Tax will be included in the retail prices in the POS files coming from the store. Valid values are Y or N. channel_name varchar2120 0 1 Indicates the channel description with which the store is associated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_format_name varchar2120 0 1 Contains the name or description of the store format. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. sister_store number10 0 1 This field will hold a store number which will be used to relate the current store to the historical data of an existing store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tsf_entity_id number10 0 1 This field will hold id of the transfer entity with which a store is associated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. auto_rcv varchar21 0 1 This column will indicate whether the client is allowing automatic receipt for the store. Valid Values are Y (Yes), N (No), D (System Default). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. remerch_ind varchar21 0 1 This field identifies stores that are undergoing a significant remerchandising effort. Used only when AIP is integrated with RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wf_customer_id number10 0 1 This field identifies numeric id of the customer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. customer_order_loc_ind varchar21 0 1 This Column determines whether the location is customer order location or not.If the indicator is Y then the location can be used by OMS for sourcing/ fulfillment or both else it cannot be used.It is enabled only for the company stores. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. gift_wrapping_ind varchar21 0 1 This field indicates weathere a gift wrapping needs to be done or not. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. customer_order_ship_ind varchar21 0 1 This field indicates wheather the customer order has been been shipped from Warehouse or not. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. StoreHoursDesc:StoreHoursDesc * 0 unbounded References a collection of store hours details. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description city_id varchar210 0 1 Indicates the City Id or Code. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States STORE_ADDR COUNTRY RIB VARCHAR2(3 BYTE) Yes Indicates the Country Name. For e.g Brazil,United States addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_addr_type_ind varchar21 0 1 Description is not available. STORE_ADDR PRIMARY_ADDR_TYPE_IND RIB VARCHAR2(1 BYTE) No Type of primary address primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type STORE_ADDR PRIMARY_ADDR_IND RIB VARCHAR2(1 BYTE) Yes Indicates whether this address is the primary address for this address type add_1 varchar2240 1 1 Contains the first line of the address STORE_ADDR ADD_1 RIB VARCHAR2(240 BYTE) Yes Contains the first line of the address add_2 varchar2240 0 1 Contains the second line of the address. STORE_ADDR ADDR_2 RIB VARCHAR2(240 BYTE) No Contains the second line of the address. add_3 varchar2240 0 1 Contains the thirdline of the address. STORE_ADDR ADD_3 RIB VARCHAR2(240 BYTE) No Contains the thirdline of the address. city varchar2120 1 1 Contains the name of the city that is associated with the address. STORE_ADDR CITY RIB VARCHAR2(120 BYTE) Yes Contains the name of the city that is associated with the address. state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. STORE_ADDR STATE RIB VARCHAR2(3 BYTE) No Contains the postal abbreviation for the state in which the warehouse is located. country_id varchar23 1 1 Contains the country where the address exists. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. post varchar230 0 1 Contains the zip code for the address. STORE_ADDR POST_CODE RIB VARCHAR2(30 BYTE) No Contains the zip code for the address. contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. STORE_ADDR CONTACT_NAME RIB VARCHAR2(120 BYTE) No Contains the name of the contact for the supplier at this address. contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 Contains the county name for the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:StoreHoursDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description store_id number10 1 1 Unique ID of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. day_no number1 1 1 This field indicates the day of the week for which store timing is being stored. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_open_time varchar28 0 1 Contains the open time for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_close_time varchar28 0 1 Contains the close time for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreHoursDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure StoreHoursDesc

XML-Schema Name:StoreHoursDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description store_id number10 1 1 Unique ID of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. day_no number1 1 1 This field indicates the day of the week for which store timing is being stored. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_open_time varchar28 0 1 Contains the open time for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_close_time varchar28 0 1 Contains the close time for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure StoreRef AddrRef StoreHoursRef

XML-Schema Name:StoreRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description store number10 1 1 The store number for the store or address being deleted. STORE STORE_ID RIB NUMBER(10,0) Yes The store number for the store store_type varchar21 0 1 Indicates the store type of the store. Valid values are: 'C' = company store, 'F' = franchise store. STORE STORE_TYPE RIB VARCHAR2(6 BYTE) No Indicates the store type of the store. stockholding_ind varchar21 0 1 Indicates if the store is stockholding or not. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. AddrRef:AddrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA StoreHoursRef:StoreHoursRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:AddrRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. STORE_ADDR ADDR RIB NUMBER(11,0) Yes Address Identifier

XML-Schema Name:StoreHoursRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description store_id number10 1 1 Unique ID of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. day_no number1 1 1 This field indicates the day of the week for which store timing is being stored. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreHoursRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure StoreHoursRef

XML-Schema Name:StoreHoursRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description store_id number10 1 1 Unique ID of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. day_no number1 1 1 This field indicates the day of the week for which store timing is being stored. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/VatItemColRef/v1 Version 1.0 Description XSD Structure VatItemColRef VatItemRef

XML-Schema Name:VatItemColRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VatItemColRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description collection_size number4 1 1 Number of records to be returned in one call. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. VatItemRef:VatItemRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:VatItemRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VatItemRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. VAT_ITEM ITEM RIB VARCHAR2(25 BYTE) Yes Unique identifier for the item. active_date xs:dateTime 1 1 This field holds the active date for record on future cost. VAT_ITEM ACTIVE_DATE RIB TIMESTAMP(6) Yes This field holds the active date for record on future cost. vat_type varchar21 1 1 This field indicates the type of vat either Retail or Cost or Both.. VAT_ITEM VAT_TYPE RIB NUMBER(20,10) Yes The type of vat vat_region number4 1 1 Contains the number of the Value Added Tax region a location belongs to. NA NA NA NA NA NA

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/WHRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure WHRef AddrRef

XML-Schema Name:WHRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WHRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description wh number10 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. AddrRef:AddrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:AddrRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. STORE_ADDR ADDR RIB NUMBER(11,0) Yes Address Identifier

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/AddrRef/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure AddrRef

XML-Schema Name:AddrRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. STORE_ADDR ADDR RIB NUMBER(11,0) Yes Address Identifier

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/VatItemDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure VatItemDesc

XML-Schema Name:VatItemDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VatItemDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. VAT_ITEM ITEM RIB VARCHAR2(25 BYTE) Yes Unique identifier for the item. active_date xs:dateTime 1 1 This field holds the active date for record on future cost. VAT_ITEM ACTIVE_DATE RIB TIMESTAMP(6) Yes This field holds the active date for record on future cost. vat_type varchar21 1 1 This field indicates the type of vat either Retail or Cost or Both. VAT_ITEM VAT_TYPE RIB VARCHAR2(1 BYTE) Yes This field indicates the type of vat either Retail or Cost or Both. vat_code varchar26 1 1 This field indicates a code to uniquely identify a VAT rate. VAT_ITEM VAT_CODE RIB VARCHAR2(6 BYTE) Yes This field indicates a code to uniquely identify a VAT rate. vat_rate number20_10 1 1 This column contains vat rate associated with a given VAT code. VAT_ITEM VAT_RATE RIB NUMBER(20,10) Yes This column contains vat rate associated with a given VAT code. reverse_vat_ind varchar21 1 1 This field indicates if the item is subject to reverse charge VAT at the vat region. Valid values are Y and N. VAT_ITEM REVERSE_VAT_IND RIB VARCHAR2(1 BYTE) Yes This field indicates if the item is subject to reverse charge VAT at the vat region. Valid values are Y and N. vat_region number4 1 1 Contains the number of the Value Added Tax region a location belongs to. NA NA NA NA NA NA

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/VatItemRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure VatItemRef

XML-Schema Name:VatItemRef Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VatItemRef in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description item varchar225 1 1 Unique identifier for the item. VAT_ITEM ITEM RIB VARCHAR2(25 BYTE) Yes Unique identifier for the item. active_date xs:dateTime 1 1 This field holds the active date for record on future cost. VAT_ITEM ACTIVE_DATE RIB TIMESTAMP(6) Yes This field holds the active date for record on future cost. vat_type varchar21 1 1 This field indicates the type of vat either Retail or Cost or Both.. VAT_ITEM VAT_TYPE RIB NUMBER(20,10) Yes The type of vat vat_region number4 1 1 Contains the number of the Value Added Tax region a location belongs to. NA NA NA NA NA NA

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/WHDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure WHDesc AddrDesc CustFlexAttriVo CustFlexAttriVo

XML-Schema Name:WHDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WHDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description wh number10 1 1 The number which uniquely identifies the warehouse. The wh table stores all warehouses in the system, both virtual and physical. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_name varchar2150 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_add1 varchar2240 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_add2 varchar2240 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_city varchar2120 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state varchar23 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_id varchar23 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_pcode varchar230 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. email varchar2100 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the warehouse is a stock holding location. In a non-multichannel environment, this will always be 'Y'. In a multichannel environment it will be 'N' for a physical warehouse and 'Y' for a virtual warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. currency_code varchar23 1 1 The code for the currency which the warehouse uses. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_number varchar29 0 1 This type can hold a number of digits count umber. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. physical_wh number10 0 1 The number of the physical warehouse corresponding to this warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. break_pack_ind varchar21 0 1 Indicates whether or not the warehouse is capable of distributing less than the supplier case quantity. Valid values are 'Y' or 'N' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. redist_wh_ind varchar21 0 1 Indicates whether the warehouse is a 'Re-Distribution' warehouse. Used as a location on Purchase Orders in place of actual locations that are unknown at the time of purchase order creation. Used by Redistribution report. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. delivery_policy varchar26 0 1 The delivery policy of the warehouse. Next day indicates that the if a location is closed, the warehouse will deliver on the next day. Next Valid Delivery Day indicates that the warehouse will wait until the next scheduled delivery day. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_person varchar2120 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dest_fax varchar220 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. phone_nbr varchar220 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_carrier_code varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_service_code varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_carrier_code varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_service_code varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bol_upload_type varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bol_print_type varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. lead_time number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. distance_to_dest number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. drop_trailers_accepted_flag varchar21 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. rcv_dock_available_flag varchar21 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. container_type varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mld_default_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_pick_container_type varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dest_seq_nbr number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. owning_dc varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA pricing_loc number10 0 1 The location for which pricing info was copied for this warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_unit_id number15 0 1 This field holds the Org Unit id of the Warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA wh_name_secondary varchar2150 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vat_region number4 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_hier_type number4 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_hier_value number10 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_vwh number10 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. channel_desc varchar2120 0 1 The channel description for which the virtual warehouse will be assigned. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. restricted_ind varchar21 0 1 This field's indicator is used to restrict virtual warehouses from receiving stock during an inbound type transaction. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. protected_ind varchar21 0 1 This field's indicator is used to determine if the virtual warehouse is affected last in transactions where inventory is removed or affected first in short-shipment type transactions where inventory is being added. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. forecast_wh_ind varchar21 0 1 This indicator determines if a warehouse is forecastable. The intent of this indicator is to restrict the information being sent to RDF against which to generate forecasts. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. tsf_entity_id number10 0 1 This field stores, id of the transfer entity with which this warehouse is associated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. finisher_ind varchar21 0 1 This field indicates weather a virtual warehouse is an internal finisher or not. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. inbound_handling_days number2 0 1 This field indicated the number of days that the warehouse requires to receive any item and get it to the shelf so that it is ready to pick. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. vwh_type varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_entity_type varchar21 0 1 This field will specify if the warehouse is a legal entity (Importer, Exporter) or a regular warehouse. Valid values are: R - regular warehouse (including finisher); M - importer; X - exporter. Default value is R. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. customer_order_loc_ind varchar21 0 1 This field indicates if the location is customer order location or not.It is enabled only for virtual WH. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_wh number10 0 1 This field contains the default warehouse linked to the virtual warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. gift_wrapping_ind varchar21 0 1 This field indicates weathere a gift wrapping needs to be done or not. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. customer_order_ship_ind varchar21 0 1 This field indicates wheather the customer order has been been shipped from Warehouse or not. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:AddrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description city_id varchar210 0 1 Indicates the City Id or Code. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States STORE_ADDR COUNTRY RIB VARCHAR2(3 BYTE) Yes Indicates the Country Name. For e.g Brazil,United States addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_addr_type_ind varchar21 0 1 Description is not available. STORE_ADDR PRIMARY_ADDR_TYPE_IND RIB VARCHAR2(1 BYTE) No Type of primary address primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type STORE_ADDR PRIMARY_ADDR_IND RIB VARCHAR2(1 BYTE) Yes Indicates whether this address is the primary address for this address type add_1 varchar2240 1 1 Contains the first line of the address STORE_ADDR ADD_1 RIB VARCHAR2(240 BYTE) Yes Contains the first line of the address add_2 varchar2240 0 1 Contains the second line of the address. STORE_ADDR ADDR_2 RIB VARCHAR2(240 BYTE) No Contains the second line of the address. add_3 varchar2240 0 1 Contains the thirdline of the address. STORE_ADDR ADD_3 RIB VARCHAR2(240 BYTE) No Contains the thirdline of the address. city varchar2120 1 1 Contains the name of the city that is associated with the address. STORE_ADDR CITY RIB VARCHAR2(120 BYTE) Yes Contains the name of the city that is associated with the address. state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. STORE_ADDR STATE RIB VARCHAR2(3 BYTE) No Contains the postal abbreviation for the state in which the warehouse is located. country_id varchar23 1 1 Contains the country where the address exists. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. post varchar230 0 1 Contains the zip code for the address. STORE_ADDR POST_CODE RIB VARCHAR2(30 BYTE) No Contains the zip code for the address. contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. STORE_ADDR CONTACT_NAME RIB VARCHAR2(120 BYTE) No Contains the name of the contact for the supplier at this address. contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 Contains the county name for the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/AddrDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure AddrDesc CustFlexAttriVo

XML-Schema Name:AddrDesc Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description city_id varchar210 0 1 Indicates the City Id or Code. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States STORE_ADDR COUNTRY RIB VARCHAR2(3 BYTE) Yes Indicates the Country Name. For e.g Brazil,United States addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_addr_type_ind varchar21 0 1 Description is not available. STORE_ADDR PRIMARY_ADDR_TYPE_IND RIB VARCHAR2(1 BYTE) No Type of primary address primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type STORE_ADDR PRIMARY_ADDR_IND RIB VARCHAR2(1 BYTE) Yes Indicates whether this address is the primary address for this address type add_1 varchar2240 1 1 Contains the first line of the address STORE_ADDR ADD_1 RIB VARCHAR2(240 BYTE) Yes Contains the first line of the address add_2 varchar2240 0 1 Contains the second line of the address. STORE_ADDR ADDR_2 RIB VARCHAR2(240 BYTE) No Contains the second line of the address. add_3 varchar2240 0 1 Contains the thirdline of the address. STORE_ADDR ADD_3 RIB VARCHAR2(240 BYTE) No Contains the thirdline of the address. city varchar2120 1 1 Contains the name of the city that is associated with the address. STORE_ADDR CITY RIB VARCHAR2(120 BYTE) Yes Contains the name of the city that is associated with the address. state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. STORE_ADDR STATE RIB VARCHAR2(3 BYTE) No Contains the postal abbreviation for the state in which the warehouse is located. country_id varchar23 1 1 Contains the country where the address exists. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. post varchar230 0 1 Contains the zip code for the address. STORE_ADDR POST_CODE RIB VARCHAR2(30 BYTE) No Contains the zip code for the address. contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. STORE_ADDR CONTACT_NAME RIB VARCHAR2(120 BYTE) No Contains the name of the contact for the supplier at this address. contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 Contains the county name for the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:19.0.000

(Omni Channel Data Service)

Application Omni Channel Data Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustFlexAttriVo/v1 Version 1.0 Description This object is used to communicate customer flexible attributes defined for various entities using RMS's CFAS (Customer Flexiable Attribute) structure. XSD Structure CustFlexAttriVo

XML-Schema Name:CustFlexAttriVo Version:19.0.000 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in OCDS application. OCDS's Table Name OCDS's Column Name Integration API(RIB or/and RSB or/and BDI) OCDS's Column Length Is Column Required in OCDS's API? OCDS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.