Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management 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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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 Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. add_1 varchar2240 1 1 Contains the first line of the address Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. add_2 varchar2240 0 1 Contains the second line of the address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. add_3 varchar2240 0 1 Contains the thirdline of the address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. city varchar2120 1 1 Contains the name of the city that is associated with the address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/ClrPrcChgDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ClrPrcChgDesc ClrPrcChgDtl

XML-Schema Name:ClrPrcChgDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_clearance_payload location number 10 Yes Unique identifier that indicates a Location (Store or Warehouse). loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_clearance_payload location_type varchar2 30 Yes Identifier that indicates whether a location is a Store (S) or a Warehouse (W). ClrPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:ClrPrcChgDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description clearance_id Number15 1 1 Clearance ID rpm_clearance_payload clearance_id number 15 Yes Clearance Id item varchar225 1 1 Unique identifier of the item in the clearance rpm_clearance_payload item varchar2 25 Yes Item Number effective_date xs:dateTime 1 1 The date the clearance becomes active rpm_clearance_payload effective_date date Fill column length. Yes Effective date of the clearance selling_unit_retail number20_4 1 1 Clearance selling unit retail rpm_clearance_payload selling_retail number 20 Yes Clearance selling retail selling_uom varchar24 1 1 Clearance selling UOM rpm_clearance_payload selling_retail_uom varchar2 25 Yes Clearance selling UOM selling_currency Varchar23 1 1 Clearance selling currency rpm_clearance_payload selling_retail_currency varchar2 25 Yes Clearance selling currency reset_clearance_id Number15 0 1 Clearance reset ID rpm_clearance_payload reset_clearance_id number 15 No Clearance reset id

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/ClrPrcChgRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ClrPrcChgRef ClrPrcChgDtlRef

XML-Schema Name:ClrPrcChgRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_clearance_payload location NUMBER 10 Yes Unique identifier that indicates a Location (Store or Warehouse). loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_clearance_payload location_type VARCHAR2 30 Yes Identifier that indicates whether a location is a Store (S) or a Warehouse (W). ClrPrcChgDtlRef * 1 unbounded Description is not available.

XML-Schema Name:ClrPrcChgDtlRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgDtlRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description clearance_id number15 1 1 Unique identifier of the clearance rpm_clearance_payload clearance_id NUMBER 15 Yes Clearance Id item varchar225 1 1 Unique identifier of the item rpm_clearance_payload item VARCHAR2 25 Yes Item Number

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/CreditRecColRBM/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure CreditRecColRBM CreditRecRBO

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

XML-Schema Name:CreditRecRBO Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CreditRecRBO in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description src_federal_tax_reg_id varchar225 0 1 Indicates the Federal Tax Registration Number of the Issuer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. dst_federal_tax_reg_id varchar225 1 1 Indicates the Federal Tax Registration Number of the Destination. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. src_ref_federal_tax_reg_id varchar225 0 1 Indicates the Federal Tax Registration Number of the Reference of Source. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_code varchar225 1 1 Indicates the item code of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_id varchar225 0 1 Indicates the item Id of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. document_series varchar225 0 1 Indicates the Series of Fiscal document. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. document_number varchar225 0 1 Indicates the Fiscal document number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fiscal_document_date xs:dateTime 0 1 Indicates the Fiscal Document Date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_document_series varchar225 0 1 Indicates the Series of Referenced Fiscal document. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_document_number varchar225 0 1 Indicates the Referenced Fiscal document number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_fiscal_document_date xs:dateTime 0 1 Indicates the Referenced Fiscal Document Date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. quantity number12_4 0 1 Indicates quantity of items. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. quantity_recovered number12_4 0 1 Indicates quantity recovered for ST. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_of_measure varchar225 0 1 Indicates unit of measurement of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. total_cost number20_4 0 1 Indicates total cost of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icms_taxable_basis_amount number20_4 0 1 Indicates ICMS taxable base value of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icms_tax_amount number20_4 0 1 Indicates ICMS tax amount of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsst_taxable_basis_amount number20_4 0 1 Indicates ICMS-ST taxable base value of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsst_tax_amount number20_4 0 1 Indicates ICMS-ST tax amount of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsste_taxable_basis_amount number20_4 0 1 Indicates ICMS-STE taxable base value of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsste_tax_amount number20_4 0 1 Indicates ICMS-STE tax amount of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

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

XML-Schema Name:CreditRecRBO Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CreditRecRBO in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description src_federal_tax_reg_id varchar225 0 1 Indicates the Federal Tax Registration Number of the Issuer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. dst_federal_tax_reg_id varchar225 1 1 Indicates the Federal Tax Registration Number of the Destination. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. src_ref_federal_tax_reg_id varchar225 0 1 Indicates the Federal Tax Registration Number of the Reference of Source. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_code varchar225 1 1 Indicates the item code of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_id varchar225 0 1 Indicates the item Id of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. document_series varchar225 0 1 Indicates the Series of Fiscal document. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. document_number varchar225 0 1 Indicates the Fiscal document number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fiscal_document_date xs:dateTime 0 1 Indicates the Fiscal Document Date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_document_series varchar225 0 1 Indicates the Series of Referenced Fiscal document. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_document_number varchar225 0 1 Indicates the Referenced Fiscal document number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_fiscal_document_date xs:dateTime 0 1 Indicates the Referenced Fiscal Document Date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. quantity number12_4 0 1 Indicates quantity of items. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. quantity_recovered number12_4 0 1 Indicates quantity recovered for ST. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_of_measure varchar225 0 1 Indicates unit of measurement of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. total_cost number20_4 0 1 Indicates total cost of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icms_taxable_basis_amount number20_4 0 1 Indicates ICMS taxable base value of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icms_tax_amount number20_4 0 1 Indicates ICMS tax amount of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsst_taxable_basis_amount number20_4 0 1 Indicates ICMS-ST taxable base value of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsst_tax_amount number20_4 0 1 Indicates ICMS-ST tax amount of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsste_taxable_basis_amount number20_4 0 1 Indicates ICMS-STE taxable base value of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. icmsste_tax_amount number20_4 0 1 Indicates ICMS-STE tax amount of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management 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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description name varchar230 1 1 Holds the attribute name. NA NA NA NA NA NA value varchar2250 0 1 Holds the numeric or string value of the attribute. NA NA NA NA NA NA value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/InvocationSuccess/v1 Version 1.0 Description XSD Structure InvocationSuccess

XML-Schema Name:InvocationSuccess Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvocationSuccess in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description success_message varchar2500 0 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/Nothing/v1 Version 1.0 Description XSD Structure Nothing

XML-Schema Name:Nothing Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Nothing in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description description varchar2500 0 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcChgDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PrcChgDesc PrcChg PrcChgDtl PrcChgRef

XML-Schema Name:PrcChgDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChgDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description PrcChg * 1 unbounded Description is not available.

XML-Schema Name:PrcChg Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChg in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Location Number RPM_PRICE_CHANGE LOCATION NUMBER 10 Yes Location ID loc_type varchar21 1 1 Location Type RPM_PRICE_CHANGE ZONE_NODE_TYPE NUMBER 6 Yes Location Type item varchar225 1 1 Unique Identification of the Item RPM_PRICE_CHANGE ITEM VARCHAR2 25 Yes Item ID change_type varchar26 1 1 Price Event Type - Price Change, Clearance or Promotion N/A N/A VARCHAR2 N/A Yes Valid values are PE (Regular), CL (Clearance) and PR (Promotion for Simple Promo only) PrcChgDtl * 0 unbounded Description is not available. PrcChgRef * 0 unbounded Description is not available.

XML-Schema Name:PrcChgDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChgDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description unit_retail number20_4 0 1 Selling Unit Retail RPM_PRICE_CHANGE CHANGE_AMOUNT NUMBER 20,4 Yes Fixed Amount Value - New Selling Unit Retail new_uom varchar24 0 1 Unit of Measure RPM_PRICE_CHANGE CHANGE_SELLING_UOM VARCHAR2 4 Yes Change Selling Unit Of Measure effective_date xs:dateTime 0 1 The date the price event will start RPM_PRICE_CHANGE EFFECTIVE_DATE DATE Fill column length. Yes The date the price event will take effect end_date xs:dateTime 0 1 The date the promotion will end or the reset date for clearance RPM_PROMO_DTL END_DATE DATE Fill column length. No The date the promotion will end

XML-Schema Name:PrcChgRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChgRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description change_id number15 1 1 Promotion Component Detail ID or Price Change ID or Clearance ID if the price event type is a promotion or price change or clearance, respectively RPM_PRICE_CHANGE PRICE_CHANGE_ID NUMBER 15 Yes Price Change ID promo_comp_id number10 0 1 Promotion Component ID if the price event type is a promotion RPM_PROMO_COMP PROMO_COMP_ID NUMBER 10 No Promotion Component ID promo_id number10 0 1 Promotion ID if the price event type is a promotion RPM_PROMO PROMO_ID NUMBER 10 No Promotion ID if the price event type is a promotion

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcInqCriVo/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PrcInqCriVo PrcInqCriDtl

XML-Schema Name:PrcInqCriVo Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqCriVo in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description PrcInqCriDtl * 1 unbounded Description is not available.

XML-Schema Name:PrcInqCriDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqCriDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item varchar225 1 1 Unique Identification of the Item RPM_FUTURE_RETAIL ITEM VARCHAR2 25 Yes Item Number location number10 1 1 Location Number RPM_FUTURE_RETAIL LOCATION NUMBER 10 Yes Location Number location_type varchar21 1 1 Location Type ('S'tore or 'W'arehouse) RPM_FUTURE_RETAIL ZONE_NODE_TYPE NUMBER 6 Yes Location Type pricing_date xs:dateTime 0 1 The date the price is effective RPM_FUTURE_RETAIL ACTION_DATE DATE Fill column length. Yes The date the price is effective

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcInqDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PrcInqDesc PrcInqDtl

XML-Schema Name:PrcInqDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description PrcInqDtl * 1 unbounded Description is not available.

XML-Schema Name:PrcInqDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description status_code varchar210 1 1 Status Code of the Price Inquiry (Success or Business Error) N/A N/A N/A N/A Yes Status Code of the Price Inquiry - success or error item varchar225 1 1 Unique Identification of the Item RPM_FUTURE_RETAIL ITEM VARCHAR2 25 Yes Item Number location number10 1 1 Location RPM_FUTURE_RETAIL LOCATION NUMBER 10 Yes Location Number location_type varchar21 1 1 Location Type ('S'tore or 'W'arehouse) RPM_FUTURE_RETAIL ZONE_NODE_TYPE NUMBER 6 Yes Location Type pricing_date xs:dateTime 1 1 The date the price is effective RPM_FUTURE_RETAIL ACTION_DATE DATE Fill column length. Yes The date the selling unit retail is effective selling_unit_retail number20_4 1 1 Selling Unit Retail RPM_FUTURE_RETAIL SELLING_RETAIL NUMBER 20,4 Yes Selling Unit Retail selling_uom varchar24 1 1 Selling Unit of Measure RPM_FUTURE_RETAIL SELLING_UOM VARCHAR2 4 Yes Selling Unit of Measure multi_units number12_4 0 1 Multi Units RPM_FUTURE_RETAIL MULTI_UNITS NUMBER 12,4 No Multi Units multi_unit_retail number20_4 0 1 Multi Unit Retail RPM_FUTURE_RETAIL MULTI_UNIT_RETAIL NUMBER 20,4 No Multi Unit Retail multi_selling_uom varchar24 0 1 Multi Selling UOM RPM_FUTURE_RETAIL MULTI_SELLING_UOM VARCHAR2 4 No Multi Selling Unit of Measure currency_code varchar23 1 1 Currency Code RPM_FUTURE_RETAIL SELLING_RETAIL_CURRENCY VARCHAR2 3 Yes Selling Retail Currency Code price_type VARCHAR26 1 1 Selling Unit Retail Type (Regular, Clearance or Promotion depending if the item is on clearance, promotion or not) N/A N/A N/A N/A Yes Selling Unit Retail Type (Regular, Clearance or Promotion)

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmCnlItemLocDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PrmCnlItemLocDesc CancelItemLoc

XML-Schema Name:PrmCnlItemLocDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmCnlItemLocDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description promo_id number10 1 1 Promotion ID rpm_promo_dtl_cil_payload promo_id number 10 Yes Promotion ID promo_comp_id number10 1 1 Promotion Component ID rpm_promo_dtl_cil_payload promo_comp_id number 10 Yes Promotion Component ID promo_dtl_id number10 1 1 Promotion Component Detail ID rpm_promo_dtl_cil_payload promo_dtl_id number 10 Yes Promotion Component Detail ID promo_comp_type number2 1 1 Promotion Component Type rpm_promo_dtl_cil_payload promo_comp_type number 2 Yes Promotion Component Type CancelItemLoc * 1 unbounded Description is not available. cancellation_date xs:dateTime 1 1 Specifies the date and time when the cancellation takes effect. rpm_promo_dtl_cil_payload cancellation_date date N/A Yes effective date for the cancellation

XML-Schema Name:CancelItemLoc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CancelItemLoc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item_num varchar225 1 1 The item of the item-location combination being cancelled rpm_promo_dtl_cil_item_payload item varchar2 25 Yes item number location number10 1 1 The location of the item-location combination being cancelled. rpm_promo_dtl_cil_loc_payload location number 10 Yes location number loc_type varchar22 1 1 Location Type rpm_promo_dtl_cil_loc_payload location_type varchar2 30 Yes location type

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmPrcChgDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PrmPrcChgDesc PrmPrcChgDtl PrmPrcChgSmp PrmPrcChgThr PrmPrcChgThrDtl PrmPrcChgBuyGet PrmPrcChgGetItem PrmPrcChgBuyItem

XML-Schema Name:PrmPrcChgDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_promo_location_payload location number 10 Yes Unique identifier that indicates a Location (Store or Warehouse) loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_promo_location_payload location_type number 30 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') PrmPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description promo_id number10 1 1 Promotion Id rpm_promo_dtl_payload promo_id number 10 Yes Promotion Id promo_name varchar240 0 1 Promotion Name rpm_promo_dtl_payload PROMO_NAME varchar2 160 * Promotion Name promo_description varchar2160 0 1 Promotion Description rpm_promo_dtl_payload PROMO_DESC varchar2 640 * Promotion Description promo_comp_id number10 1 1 Promotion Component Id rpm_promo_dtl_payload promo_comp_id number 10 Yes Promotion Component Id promo_comp_desc varchar240 0 1 Promotion Component Description rpm_promo_dtl_payload PROMO_COMP_DESC varchar2 160 * Promotion Component Description promo_comp_detail_id number10 1 1 Promotion Component Detail Id rpm_promo_dtl_payload promo_dtl_id number 10 Yes Promotion Component Detail Id apply_order number1 1 1 The order that this promotion component detail to be applied in case there is more than one promotion component details in one day for an item/location rpm_promo_dtl_payload apply_order number 6 * The order that this promotion component detail to be applied in case there is more than one promotion component details in one day for an item/location start_date xs:dateTime 1 1 Start date of the promotion component detail rpm_promo_dtl_payload start_date date Fill column length. Yes Start date of the promotion component detail end_date xs:dateTime 0 1 End date of the promotion component detail rpm_promo_dtl_payload end_date date Fill column length. No End date of the promotion component detail PrmPrcChgSmp * 0 unbounded Description is not available. PrmPrcChgThr * 0 unbounded Description is not available. PrmPrcChgBuyGet * 0 unbounded Description is not available.

XML-Schema Name:PrmPrcChgSmp Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgSmp in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item varchar225 1 1 Item number rpm_promo_dtl_merch_node item varchar2 25 * Item number promo_selling_retail number20 1 1 Simple Promotion selling retail rpm_future_retail simple_promo_retail number 20,4 * Simple Promotion selling retail promo_selling_uom xs:string 1 1 Simple promotion selling UOM rpm_future_retail simple_promo_uom varchar2 4 * Simple promotion selling UOM prm_chg_type varchar21 1 1 Simple Promotion change type rpm_promo_dtl_disc_ladder change_type number 2 * Buy Get discount change type prm_chg_value number20 1 1 Simple Promotion change value rpm_promo_dtl_disc_ladder change_amount or change_percent number 20,4 * Buy Get Discount Change Value prm_chg_uom varchar24 0 1 Simple Promotion change selling UOM rpm_promo_dtl_disc_ladder change_selling_uom varchar2 4 change_selling_uom Buy Get Change Selling UOM

XML-Schema Name:PrmPrcChgThr Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgThr in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item varchar225 1 1 Item number rpm_promo_dtl_merch_node item varchar2 25 * Item number threshold_id number6 1 1 Threshold Id rpm_threshold threshold_id number 6 * Threshold Id threshold_name varchar230 0 1 Threshold Name rpm_threshold name varchar2 120 * Threshold Name qualification_type number1 1 1 Threshold Qualification Type rpm_threshold qualification_type number 1 * Threshold Qualification Type threshold_type varchar21 1 1 Threshold Type rpm_threshold_interval threshold_type number 1 * Threshold Type prm_chg_type varchar21 1 1 Threshold Discount Change Type rpm_promo_dtl_disc_ladder change_type number 2 * Buy Get discount change type PrmPrcChgThrDtl * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgThrDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgThrDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description threshold_value number20 1 1 Threshold Interval Value rpm_threshold_interval threshold_amount number 20,4 * Threshold Interval Value prm_chg_value number20 1 1 Threshold Change Value rpm_threshold_interval change_amt or change_percent number 20,4 * Threshold Change Value prm_chg_uom varchar24 0 1 Threshold Change Selling UOM rpm_threshold_interval change_uom varchar2 4 * Threshold Change Selling UOM

XML-Schema Name:PrmPrcChgBuyGet Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgBuyGet in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description prm_chg_type varchar21 1 1 Buy Get discount change type rpm_promo_dtl_disc_ladder change_type number 2 * Buy Get discount change type prm_chg_value number20 1 1 Buy Get Discount Change Value rpm_promo_dtl_disc_ladder change_amount or change_percent number 20,4 * Buy Get Discount Change Value prm_chg_uom varchar24 0 1 Buy Get Change Selling UOM rpm_promo_dtl_disc_ladder change_selling_uom varchar2 4 change_selling_uom Buy Get Change Selling UOM buy_qty number20 1 1 Buy quantity rpm_promo_dtl_disc_ladder qual_value number 20,4 * Buy quantity all_ind number1 1 1 Buy All Indicator rpm_promo_dtl_disc_ladder qual_type number 2 * All Indicator PrmPrcChgGetItem * 1 unbounded Description is not available. PrmPrcChgBuyItem * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgGetItem Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgGetItem in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item varchar225 1 1 Get Item rpm_promo_dtl_merch_node item varchar2 25 * Buy Item

XML-Schema Name:PrmPrcChgBuyItem Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgBuyItem in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item varchar225 1 1 Buy Item rpm_promo_dtl_merch_node item varchar2 25 * Buy Item

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmPrcChgRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PrmPrcChgRef PrmPrcChgDtlRef PrmPrcChgSmpDtlRe PrmPrcChgThrDtlRe

XML-Schema Name:PrmPrcChgRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Description is not available. rpm_future_retail location NUMBER 10 * Unique identifier that indicates a Location (Store or Warehouse) loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_future_retail zone_node_type NUMBER 6 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') PrmPrcChgDtlRef * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgDtlRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgDtlRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description promo_comp_detail_id 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. PrmPrcChgSmpDtlRe * 0 unbounded Description is not available. PrmPrcChgThrDtlRe * 0 unbounded Description is not available.

XML-Schema Name:PrmPrcChgSmpDtlRe Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgSmpDtlRe in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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.

XML-Schema Name:PrmPrcChgThrDtlRe Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgThrDtlRe in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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.

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PromotionDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PromotionDesc LocationList ListGroup ListDtl DiscountLadder ItemList ItemLocSimpleRet CreditDetail

XML-Schema Name:PromotionDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PromotionDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description promo_id number10 1 1 Promotion ID rpm_promo_dtl_payload promo_id number 10 Yes promotion ID promo_name varchar2160 0 1 Promotion Header Name rpm_promo_dtl_payload promo_name varchar2 160 * promotion header name promo_description varchar2640 0 1 Promotion Header Description rpm_promo_dtl_payload promo_desc varchar2 640 No promotion header description promo_comp_id number10 1 1 Promotion Component Id rpm_promo_dtl_payload promo_comp_id number 10 Yes promotion component ID promo_comp_desc varchar2160 0 1 Promotion Component Name rpm_promo_dtl_payload promo_comp_desc varchar2 160 No Promotion Component Description promo_comp_type number2 1 1 Promotion Component Type rpm_promo_dtl_payload promo_comp_type number 2 Yes promotion component type - (0) multi-buy, (1) simple, (2) threshold, (3) finance, (4) transaction promo_dtl_id number10 1 1 Promotion Component Detail Id rpm_promo_dtl_payload promo_dtl_id number 10 Yes promotion component detail ID apply_order number6 1 1 Application Order of the Promotion rpm_promo_dtl_payload apply_order number 6 Yes the order the promotion will be applied if there aremultiple promotions start_date xs:dateTime 1 1 Start Date of Promotion Component Detail rpm_promo_dtl_payload start_date date Fill column length. Yes start date of the promotion detail end_date xs:dateTime 0 1 End Date of Promotion Component Detail rpm_promo_dtl_payload end_date date Fill column length. No end date of the promotion component detail apply_to_code number1 0 1 Determines if the promo discount will be applied to regular, clearance retail or both RPM_PROMO_DTL_PAYLOAD APPLY_TO_CODE NUMBER 1 Yes Determines if the promotional discount will be applied to regular retail (0), clearance retail (1) or both (2) discount_limit number3 0 1 The number of times that the promotion can be applied to a transaction. RPM_PROMO_DTL_PAYLOAD DISCOUNT_LIMIT NUMBER 3 No Limit of the discount exception_parent_id number10 0 1 Parent promotion component detail ID if the detail isan exception rpm_promo_dtl_payload exception_parent_id number 10 No Parent promotion component detail ID if the detail isan exception LocationList * 1 unbounded Description is not available. ListGroup * 1 unbounded Description is not available. ItemLocSimpleRet * 0 unbounded Description is not available. customer_type_id number10 0 1 Customer Type rpm_promo_dtl_payload customer_type number 10 No the customer type of the promotion component CreditDetail * 0 unbounded Description is not available. threshold_qual_type number1 0 1 The Threshold qualification type. A value of 1 means threshold level and a value of 0 means item level. RPM_PROMO_DTL_PAYLOAD THRESH_QUALIFICATION_TYPE NUMBER 1 No indicates the level of threshold promos, valid values are 0 for item level and 1 for threshold level

XML-Schema Name:LocationList Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocationList in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Location Number RPM_PROMO_ITEM_LOC_SR_PAYLOAD LOCATION NUMBER 10 No Location loc_type varchar22 1 1 Location Type rpm_promo_location_payload location_type varchar2 30 Yes location type

XML-Schema Name:ListGroup Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListGroup in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description listgroup_id number10 1 1 Promotion Detail List Group ID rpm_promo_dtl_list_grp_payload promo_dtl_list_grp_id number 10 Yes Promotion Detail List Group ID ListDtl * 1 unbounded Description is not available.

XML-Schema Name:ListDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description listdtl_id number10 1 1 Promotion Detail List ID RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id reward_application number1 0 1 Reward Application RPM_PROMO_DTL_LIST_PAYLOAD REWARD_APPLICATION NUMBER 1 No determine whether the reward is embedded in this list or is shared among all lists for the group description varchar2160 0 1 Description for the promo detail list RPM_PROMO_DTL_LIST_PAYLOAD DESCRIPTION VARCHAR2 120 No Description DiscountLadder * 0 unbounded Description is not available. ItemList * 1 unbounded Description is not available. price_range_min number20_4 0 1 Contains price range promotion minimum valid retail value RPM_PROMO_DTL_PRC_RNG_PAYLOAD BUY_LIST_MIN, GET_LIST_MIN NUMBER 20, 4 No Minimum promotion price for the buy/get list item price_range_max number20_4 0 1 Contains price range promotion maximum valid retail value RPM_PROMO_DTL_PRC_RNG_PAYLOAD BUY_LIST_MAX GET_LIST_MAX NUMBER 20, 4 No Maximum promotion price for the buy/get list item

XML-Schema Name:DiscountLadder Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiscountLadder in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description chg_type number2 0 1 Change Type RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_TYPE NUMBER 2 No Change Type chg_amt number20_4 0 1 Change Amount RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_AMOUNT NUMBER 20 No Change Amount chg_currency varchar23 0 1 Currency Code RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_CURRENCY VARCHAR2 3 No Change Currency chg_percent number20_4 0 1 Change Percent RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_PERCENT NUMBER 20 No Change Percent chg_selling_uom varchar24 0 1 Change Selling UOM RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_SELLING_UOM VARCHAR2 4 No Selling UOM qual_type number2 0 1 Qualification Type RPM_PROMO_DISC_LDR_PAYLOAD QUAL_TYPE NUMBER 2 No Qualification Type - (0) all, (1) amount, (2) quantity qual_value number20_4 0 1 Qualification Value RPM_PROMO_DISC_LDR_PAYLOAD QUAL_VALUE NUMBER 20 No Qualification Value chg_duration number20_4 0 1 Change duration RPM_PROMO_DISC_LDR_PAYLOAD DURATION NUMBER 10 No Change Duration

XML-Schema Name:ItemList Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemList in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item_num varchar225 1 1 Item Number RPM_PROMO_ITEM_PAYLOAD ITEM VARCHAR2 25 Yes Item Number

XML-Schema Name:ItemLocSimpleRet Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocSimpleRet in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item_num varchar225 1 1 Transaction Item Identifier RPM_PROMO_ITEM_LOC_SR_PAYLOAD ITEM VARCHAR2 25 No Item Number location number10 1 1 Store ID RPM_PROMO_ITEM_LOC_SR_PAYLOAD LOCATION NUMBER 10 No Location selling_retail number20_4 0 1 Selling retail of the item RPM_PROMO_ITEM_LOC_SR_PAYLOAD selling_retail NUMBER 20 No Selling Retail selling_uom varchar24 0 1 Selling UOM of the item RPM_PROMO_ITEM_LOC_SR_PAYLOAD selling_uom VARCHAR2 4 No Selling UOM effective_date xs:dateTime 0 1 Specifies when the given selling retail is to take effect for the given item and location. RPM_PROMO_ITEM_LOC_SR_PAYLOAD EFFECTIVE_DATE DATE Fill column length. Yes Specifies when the given selling retail is to take effect for the given item and location. selling_currency varchar23 1 1 Contains the currency code that should match the store's currency code. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ref_promo_dtl_id number15 0 1 Referenced Promotion Detail ID

XML-Schema Name:CreditDetail Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CreditDetail in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description credit_detail_id number10 1 1 N/A Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. credit_type varchar240 1 1 Credit Card Type RPM_PROMO_FIN_DTL_PAYLOAD CARD_TYPE VARCHAR2 25 No Credit Card Type bin_number_from number10 1 1 BIN Number From Value RPM_PROMO_FIN_DTL_PAYLOAD BIN_FROM_VALUE NUMBER 16 No Bin From Value. bin_number_to number10 1 1 BIN Number To Value RPM_PROMO_FIN_DTL_PAYLOAD BIN_TO_VALUE NUMBER 16 No Bin To Value commision_rate number10 1 1 Commission Rate RPM_PROMO_FIN_DTL_PAYLOAD COMMISSION_RATE NUMBER 20 No Commission Rate comments varchar2160 1 1 Comments RPM_PROMO_FIN_DTL_PAYLOAD COMMENTS VARCHAR2 1000 No Comments

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/PromotionRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PromotionRef LocationListRef ListGroupRef ListDtlRef ItemListRef

XML-Schema Name:PromotionRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PromotionRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description promo_id number10 1 1 Promotion ID RPM_PROMO_DTL_PAYLOAD PROMO_ID NUMBER 10 Yes Promotion Id promo_comp_id number10 1 1 Promotion Component ID RPM_PROMO_DTL_PAYLOAD PROMO_COMP_ID NUMBER 10 Yes Promotion Component Id promo_dtl_id number10 1 1 Promotion Component Detail ID RPM_PROMO_DTL_PAYLOAD PROMO_DTL_ID NUMBER 10 Yes Promotion Detail Id LocationListRef * 1 unbounded Description is not available. ListGroupRef * 1 unbounded Description is not available.

XML-Schema Name:LocationListRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocationListRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Store ID RPM_PROMO_LOCATION_PAYLOAD LOCATION NUMBER 10 Yes Location Id

XML-Schema Name:ListGroupRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListGroupRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description listgroup_id number10 1 1 Promotion Detail List Group ID RPM_PROMO_DTL_LIST_GRP_PAYLOAD PROMO_DTL_LIST_GRP_ID NUMBER 10 Yes Promotion Detail List Group Id ListDtlRef * 1 unbounded Description is not available.

XML-Schema Name:ListDtlRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListDtlRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description listdtl_id number10 1 1 Promotion Detail List ID RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id ItemListRef * 1 unbounded Description is not available.

XML-Schema Name:ItemListRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemListRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description item_num varchar225 1 1 Item ID RPM_PROMO_ITEM_PAYLOAD ITEM VARCHAR2 25 * Item Number

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/ReferenceId/v1 Version 1.0 Description XSD Structure ReferenceId Pair

XML-Schema Name:ReferenceId Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReferenceId in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description id varchar2255 0 1 N/A N/A N/A N/A N/A N/A Pair * 0 unbounded

XML-Schema Name:Pair Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Pair in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description name varchar2255 1 1 N/A N/A N/A N/A N/A N/A value varchar2255 1 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/RegPrcChgDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure RegPrcChgDesc RegPrcChgDtl

XML-Schema Name:RegPrcChgDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_price_chg_payload location NUMBER 10 Yes Unique identifier that indicates a Location (Store or Warehouse) loc_type varchar21 1 1 Indicates the type of location which has requested tickets. Valid values for this field are: 'W' (for warehouse) and 'S' (for store). rpm_price_chg_payload location_type VARCHAR2 30 Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') RegPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:RegPrcChgDtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDtl in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description price_change_id number15 1 1 Contains the ID of the price change that initiated the ticket request. rpm_price_chg_payload price_change_id NUMBER 15 Yes Price Change Id item varchar225 1 1 Alphanumeric value that identifies the item for which tickets have been requested. rpm_price_chg_payload item VARCHAR2 25 Yes Item number effective_date xs:dateTime 1 1 Price Change Effective Date rpm_price_chg_payload effective_date DATE null Yes Price Change Effective Date selling_retail_changed_ind number1 1 1 Indicates whether the selling retail price has been changed. Valid values are '0' - no change or '1' - retail is changed. rpm_price_chg_payload selling_unit_change_ind NUMBER 6 Yes Indicate whether the regular selling retail is change by the Price Change selling_unit_retail number20_4 1 1 This field contains the unit retail for the item at the indicated location. rpm_price_chg_payload selling_retail NUMBER 20,4 Yes Regular selling retail selling_uom varchar24 1 1 Holds the selling unit of measure for an item's single-unit retail. rpm_price_chg_payload selling_retail_uom VARCHAR2 25 Yes Regular Selling UOM selling_currency varchar23 1 1 Contains the currency code that should match the store's or warehouse's currency code. rpm_price_chg_payload selling_retail currency VARCHAR2 25 Yes Regular Selling Retail Currency multi_unit_changed_ind number1 1 1 Indicates whether the retail for multi units has been changed. Valid values are '0' - no change or '1' - retail is changed. rpm_price_chg_payload multi_unit_changed_ind NUMBER 6 Yes Indicate whether the Multi Unit Selling Retail is changed by the Price Change multi_units number12_4 0 1 The number that indicate how many item is priced in the multi unit selling retail rpm_price_chg_payload multi_units NUMBER 18, 4 No The number that indicate how many item is priced in the multi unit selling retail multi_unit_retail number20_4 0 1 This field contains the multi-unit retail for the item at the indicated location. rpm_price_chg_payload multi_units_retail NUMBER 20,4 No Multi Unit Selling Retail multi_unit_retail_currency varchar23 0 1 Contains the currency code that should match the store's or warehouse's currency code. rpm_price_chg_payload multi_units_currency VARCHAR2 25 No Multi Unit Retail Currency multi_selling_uom varchar24 0 1 Multi Unit Selling UOM rpm_price_chg_payload multi_units_uom VARCHAR2 25 No Multi Unit Selling UOM

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/RegPrcChgRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure RegPrcChgRef RegPrcChgDtlRef

XML-Schema Name:RegPrcChgRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description location number10 1 1 Unique identifier of the location rpm_price_chg_payload location NUMBER 10 Yes Unique identifier that indicates a Location (Store or Warehouse) loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_price_chg_payload location_type NUMBER 30 Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') RegPrcChgDtlRef * 1 unbounded NA

XML-Schema Name:RegPrcChgDtlRef Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDtlRef in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description price_change_id number15 1 1 Unique identifier of the price change rpm_price_chg_payload price_change_id NUMBER 15 Yes Price Change ID item varchar225 1 1 Unique identifier of the item rpm_price_chg_payload item VARCHAR2 25 Yes Item number

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/ShipInfoDesc/v1 Version 1.2 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ShipInfoDesc ShipInfoDistro ShipInfoCtn ShipInfoItem ShipInfoUin

XML-Schema Name:ShipInfoDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipInfoDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description to_location varchar210 0 1 Contains the location that the shipment will be delivered to. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_location varchar210 1 1 For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_loc_type varchar22 0 1 Contains the to_location type. Valid values are SU, ST, WH. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_loc_type varchar22 1 1 Contains the from_location type. Valid values are SU, ST, WH. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. asn_nbr varchar230 0 1 Holds the bill of lading number associated with a shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. asn_type varchar21 0 1 Not used by RMS. Set to C for container when ship to location is a store, T for tare when ship to location is a warehouse. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_qty number6 0 1 Contains the number of boxes associated with the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bol_nbr varchar217 1 1 Holds the transaction sequence number on the message from the transfer shipment confirmation process. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. shipment_date xs:dateTime 0 1 This field contains the date the transfer or PO was shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. est_arr_date xs:dateTime 0 1 This field contains the estimated arrival date of a vendor PO shipment. It is updated by EDIUP856. It is used for vendor/lead time analysis. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_address1 varchar2240 0 1 Value of addr.add_1 for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_address2 varchar2240 0 1 Value of addr.add_2 for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_address3 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_address4 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_address5 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_city varchar2120 0 1 Value of addr.city for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_state varchar23 0 1 Value of addr.state for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_zip varchar230 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_country_id varchar23 0 1 Value of addr.country_id for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. trailer_nbr varchar212 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. seal_nbr varchar212 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. carrier_code varchar24 0 1 Contains the courier that will deliver the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. carrier_service_code varchar26 0 1 Contains the service level code for the courier that will deliver the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. printer_id varchar2120 0 1 Contains the valid printer id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. print_pkg_stn_req varchar230 0 1 Indicates NF needs to be printed at packing station. Also indicates that container number needs to be printed on NF. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. home_dlvry_ind varchar21 1 1 Indicates whether the shipment is slated for home delivery or not. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ShipInfoDistro * 0 unbounded Description is not available. comments varchar22000 0 1 Contains any miscellaneous comments about the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ShipInfoDistro Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipInfoDistro in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description distro_nbr varchar212 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. distro_doc_type varchar21 1 1 Specifies what the distro_nbr field corresponds to in RMS: V, D, and T specify transfer, A specifies Allocation. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cust_order_nbr varchar248 1 1 This is the customer order number that was generated by OMS and contains multiple fulfillment numbers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_nbr varchar248 1 1 Based on a customer order - OMS will generate fulfillments to specific locations based on availability. RMS will generate Transfers based on the fulfillment request. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. consumer_direct varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. comments varchar22000 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ShipInfoCtn * 1 unbounded Description is not available.

XML-Schema Name:ShipInfoCtn Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipInfoCtn in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description final_location varchar210 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_id varchar220 1 1 Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments. This field will be zero for all shipments that are not at a carton level. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_weight number12_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_length number12_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_width number12_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_height number12_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_cube number12_2 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. expedite_flag varchar21 0 1 Indicates if the shipment should be expedited. For transfers, the value will be 'Y' if the transfer's freight_code is 'E'; otherwise 'N'. For allocations, the field is mapped to alloc_detail.rush_flag. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. in_store_date xs:dateTime 0 1 For transfers, the value is always NULL. For allocations, the value is alloc_detail.in_store_date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tracking_nbr varchar2120 0 1 This is a unique tracking number that is used to track containers through carriers system. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. freight_charge number20_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. master_container_id varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. comments varchar22000 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. weight number12_4 0 1 Actual weight shipped for the container. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) that was shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ShipInfoItem * 1 unbounded Description is not available.

XML-Schema Name:ShipInfoItem Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipInfoItem in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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 or/and RSL Fill column length. Yes Fill this description. unit_qty number12_4 1 1 Contains the number of items expected to be received based on the supplier's advance shipment notification for this item/shipment combination. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. priority_level number1 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. order_line_nbr number4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. lot_nbr varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. container_qty number6 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. weight number12_4 0 1 Actual weight shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ShipInfoUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:ShipInfoUin Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipInfoUin in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description uin varchar2128 1 1 Universal Identification Number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.030

(Retail Price Management)

Application Retail Price Management 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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description store number10 1 1 Contains the number to uniquely identify the store. rpm_zone_location location null null Yes * store_type varchar21 1 1 This will indicate whether a particular store is a franchise or company store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_name varchar2150 1 1 Contains the name of the store. * * varchar2 150 * * store_name10 varchar210 0 1 Contains a ten character abbreviation of the store name. * * varchar2 10 * * store_name3 varchar23 0 1 Contains a three character abbreviation of the store name. * * varchar2 3 * * store_add1 varchar2240 0 1 Not used by RMS. * * varchar2 240 * * store_add2 varchar2240 0 1 Not used by RMS. * * varchar2 240 * * store_city varchar2120 0 1 Not used by RMS. * * varchar2 120 * * county varchar2250 0 1 Not used by RMS. * * varchar2 250 * * state varchar23 0 1 Not used by RMS. * * varchar2 3 * * country_id varchar23 0 1 Not used by RMS. * * varchar2 3 * * store_pcode varchar230 0 1 Not used by RMS. * * varchar2 30 * * 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. * * varchar2 1 * * store_mgr_name varchar2120 0 1 Contains the name of the store manager. * * varchar2 120 * * store_open_date xs:dateTime 0 1 Contains the date on which the store opened. * * RIBDate * * * store_close_date xs:dateTime 0 1 Contains the date on which the store closed. * * RIBDate * * * acquired_date xs:dateTime 0 1 Contains the date on which the store was acquired. * * RIBDate * * * remodel_date xs:dateTime 0 1 Contains the date on which the store was last remodeled. * * RIBDate * * * fax_number varchar220 0 1 Contains the fax number for the store. * * varchar2 20 * * phone_number varchar220 0 1 Contains the phone number for the store. * * varchar2 20 * * email varchar2100 0 1 Contains the email address for the location. * * varchar2 100 * * total_square_ft number8 0 1 Contains the total square footage of the store. * * number 8 * * selling_square_ft number8 0 1 Contains the total square footage of the store's selling area. * * number 8 * * linear_distance number8 0 1 Contains the total space of the location that can be used for merchandise. * * number 8 * * stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be * * varchar2 1 * * 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. * * number 4 * * store_format number4 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. * * number 4 * * mall_name varchar2120 0 1 Contains the name of the mall in which the store is located. * * varchar2 120 * * district number10 0 1 Contains the number of the district in which the store is a member. * * number 10 * * district_name varchar2120 0 1 Contains the name of the district. * * varchar2 120 * * promo_zone number4 0 1 Not used by RMS. * * number 4 * * promo_desc varchar220 0 1 Not used by RMS. * * varchar2 20 * * transfer_zone number4 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. * * number 4 * * description varchar21000 0 1 Contains the name of the transfer zone. * * varchar2 1000 * * 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. * * varchar2 10 * * 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. * * number 3 * * start_order_days number3 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. * * number 3 * * currency_code varchar23 0 1 This field contains the currency code under which the store operates. * * varchar2 3 * * lang number6 0 1 This column identifies the language to be used for the store. * * number 6 * * integrated_pos_ind varchar21 0 1 Indicates whether the POS system at the store is integrated. * * varchar2 1 * * orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency * * varchar2 3 * * duns_number varchar29 0 1 This type can hold a number of digits count umber. * * varchar2 9 * * duns_loc varchar24 0 1 This field contains the Dun and Bradstreet number to identify the location. * * varchar2 4 * * 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. * * null null Yes If this field is null, the new store will not be added to RPM_ZONE_LOCATION table. pricing_loc_curr varchar23 0 1 This is the currency code of the pricing_loc store. * * varchar2 3 * * 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. store_class_description varchar2150 0 1 Contains the description of the class of which the store is a member. vat_region number4 0 1 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. channel_name varchar2120 0 1 Indicates the channel description with which the store is associated. store_format_name varchar2120 0 1 Contains the name or description of the store format. 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. tsf_entity_id number10 0 1 This field will hold id of the transfer entity with which a store is associated. 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). remerch_ind varchar21 0 1 This field identifies stores that are undergoing a significant remerchandising effort. Used only when AIP is integrated with RMS. wf_customer_id number10 0 1 This field identifies numeric id of the customer. 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. gift_wrapping_ind varchar21 0 1 This field indicates weathere a gift wrapping needs to be done or not. customer_order_ship_ind varchar21 0 1 This field indicates wheather the customer order has been been shipped from Warehouse or not. StoreHoursDesc:StoreHoursDesc * 0 unbounded References a collection of store hours details. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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 Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. add_1 varchar2240 1 1 Contains the first line of the address Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. add_2 varchar2240 0 1 Contains the second line of the address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. add_3 varchar2240 0 1 Contains the thirdline of the address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. city varchar2120 1 1 Contains the name of the city that is associated with the address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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:16.0.030

(Retail Price Management)

Application Retail Price Management 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:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM'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:16.0.030

(Retail Price Management)

Application Retail Price Management Target Name Space http://www.oracle.com/retail/integration/base/bo/TaxLineDesc/v1 Version 1.0 Description XSD Structure TaxLineDesc

XML-Schema Name:TaxLineDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TaxLineDesc in RPM application. RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and BDI) RPM's Column Length Is Column Required in RPM's API? RPM's API Description line_no number4 1 1 A number that uniquely identifies a tax line within an order line item. NA NA NA NA NA NA tax_authority_id varchar222 1 1 ID_ATHY_TX Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_group_id number22 1 1 The order item's tax group id Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_type_code number22 1 1 A tax type code Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_holiday_flag flag 1 1 A boolean flag indicating if it is a tax holiday.The possible values are "Y" or "N". Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. currency_code varchar23 1 1 The currency ISO code Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. taxable_amount number20_4 1 1 The order item's taxable amount Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_amount number20_4 1 1 The order item's tax amount Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_tax_amount number20_4 1 1 The tax amount applied to item units that have been picked up or shipped. This is to support partial pickup/ship of an order item. NA NA NA NA NA NA cancelled_tax_amount number20_4 1 1 The tax amount applied to item units that have been cancelled. This is to support partial cancellation of an order item. NA NA NA NA NA NA returned_tax_amount number20_4 1 1 The tax amount applied to item units that have been returned. This is to support partial return of an order item. NA NA NA NA NA NA inclusive_tax_flag flag 1 1 A boolean flag indicating if the tax is already included in the item price. The possible values are "Y" or "N". Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_mode enum_tax_mode 1 1 A enum indicating if the order item is nottaxable, tax is applied in standard mode, or modified manually by the operator. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_mod_reason_code varchar220 0 1 A reason code indicating why the order item's tax is manually modified. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_mod_scope enum_tax_mod_scope 0 1 A enum indicating if the tax is modified at the order level or order item level. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_rate number8_5 0 1 The tax rate Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_rule_name varchar2120 0 1 The tax rule name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_authority_name varchar2120 0 1 The tax authority name NA NA NA NA NA NA