Retail Integration Mappings Report Release:16.0.030

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

Application Advanced Inventory Planning 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

Retail Integration Mappings Report Release:16.0.030

(Advanced Inventory Planning)

Application Advanced Inventory Planning Target Name Space http://www.oracle.com/retail/integration/base/bo/XOrderDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure XOrderDesc XOrderDtl CustFlexAttriVo XOrdSkuDtl CustFlexAttriVo CustFlexAttriVo

XML-Schema Name:XOrderDesc 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 XOrderDesc in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description order_no varchar212 1 1 The unique identifier for the order. * * null null Yes The unique identifier for the order. supplier varchar210 0 1 The identifier of the supplier from which the order will be sourced. This cannot be modified if details exist for the PO. * * null null Yes The identifier of the supplier from which the order will be sourced. This cannot be modified if details exist for the PO. currency_code varchar23 0 1 The code of the order's currency. If not populated, the supplier's currency will be used. This field can be modified if the order status is worksheet or approved and the order has not been shipped. * * null null No The code of the order's currency. If not populated, the supplier's currency will be used. This field can be modified if the order status is worksheet or approved and the order has not been shipped. terms varchar215 0 1 The sales terms of the order. If not populated on the create message, will default to the supplier's terms. This can be modified in worksheet or approved status. * * null null No The sales terms of the order. If not populated on the create message, will default to the supplier's terms. This can be modified in worksheet or approved status. not_before_date xs:dateTime 0 1 The first date that delivery will be accepted. This can be modified in worksheet or approved status. * * null null No The first date that delivery will be accepted. This can be modified in worksheet or approved status. not_after_date xs:dateTime 0 1 The last date that delivery will be accepted. This can be modified in worksheet or approved status. * * null null No The last date that delivery will be accepted. This can be modified in worksheet or approved status. otb_eow_date xs:dateTime 0 1 The end of week date of the OTB bucket used. This can be modified in worksheet or approved status. * * null null No The end of week date of the OTB bucket used. This can be modified in worksheet or approved status. dept number4 0 1 The department in which are all the items on the order. This field is required if the system enforces single department ordering. This cannot be modified if details exist for the PO. * * null null No The department in which are all the items on the order. This field is required if the system enforces single department ordering. This cannot be modified if details exist for the PO. status varchar21 0 1 The code for the status of the order. Valid values are 'W' worksheet and 'A' approved for PO creation. It is also possible to modify the status to 'C' closed. * * null null No The code for the status of the order. Valid values are 'W' worksheet and 'A' approved for PO creation. It is also possible to modify the status to 'C' closed. exchange_rate number20_10 0 1 The rate of exchange for the PO used between the order and primary currencies. This field can be modified if the order status is worksheet or approved and the order has not been shipped.. * * null null No The rate of exchange for the PO used between the order and primary currencies. This field can be modified if the order status is worksheet or approved and the order has not been shipped.. include_on_ord_ind varchar21 0 1 Indicates if the order should be included in on-order calculations. This can be modified in worksheet or approved status. * * null null No Indicates if the order should be included in on-order calculations. This can be modified in worksheet or approved status. written_date xs:dateTime 0 1 The date the order was created. If this field is not populated on the message it will default to the time of creation in RMS. It cannot be modified. * * null null No The date the order was created. If this field is not populated on the message it will default to the time of creation in RMS. It cannot be modified. XOrderDtl * 0 unbounded Description is not available. XOrdSkuDtl * 0 unbounded Description is not available. orig_ind varchar21 0 1 Indicates where the order originated. Valid values include: 2 - Manual, 6 - AIP generated order, 7 , 8. * * null 2 - Manual, 6 - AIP generated order, 7 , 8. Yes Indicates where the order originated. Valid values include edi_po_ind varchar21 0 1 Indicates whether or not the order will be transmitted to the supplier via an Electronic Data Exchange transaction. Valid values are: Y = Submit via EDI, N = Do not use EDI. * * null Y = Submit via EDI, N = Do not use EDI. No Indicates whether or not the order will be transmitted to the supplier via an Electronic Data Exchange transaction. Valid values are pre_mark_ind varchar21 0 1 This field indicated whether or not a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores. * * null null No This field indicated whether or not a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores. user_id varchar230 0 1 Indicates where the order was approved. It will be the user ID of the person approving the order. * * null null No Indicates where the order was approved. It will be the user ID of the person approving the order. comment_desc varchar22000 0 1 Any comments pertaining to the order. * * null null No Any comments pertaining to the order. attempt_rms_load varchar26 0 1 This field indicates if the order will be created in RMS or the staging tables. Valid values are RMS or STG. If not defined, the default is STG. 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 for ordhead. NA NA NA NA NA NA

XML-Schema Name:XOrderDtl 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 XOrderDtl in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description item varchar225 0 1 An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). This is required if the ref_item field is not populated.An item/location may be added to the order in worksheet or approved status. * * null null No An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). This is required if the ref_item field is not populated.An item/location may be added to the order in worksheet or approved status. location number10 1 1 An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. An item/location may be added to the order in worksheet or approved status. * * null null Yes An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. An item/location may be added to the order in worksheet or approved status. unit_cost number20_4 0 1 The cost of the item from the supplier in the order's currency. This can be modified if the status is worksheet or approved, but not if any portion of the item's order quantity is in transit or has been received. If it is not specified on the message, it will default from the item supplier cost for this location. * * null null No The cost of the item from the supplier in the order's currency. This can be modified if the status is worksheet or approved, but not if any portion of the item's order quantity is in transit or has been received. If it is not specified on the message, it will default from the item supplier cost for this location. ref_item varchar225 0 1 The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required. A ref item/location may be added to the order in worksheet or approved status. * * null null No The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required. A ref item/location may be added to the order in worksheet or approved status. origin_country_id varchar23 0 1 The identifier of the country from which the item is being sourced. This field cannot be modified. * * null null No The identifier of the country from which the item is being sourced. This field cannot be modified. supp_pack_size number12_4 0 1 The supplier pack size for the item on the order. This may be updated in worksheet or approved status. * * null null No The supplier pack size for the item on the order. This may be updated in worksheet or approved status. qty_ordered number12_4 0 1 The quantity ordered of item. This can be updated in worksheet or approved status to adjust the quantity of an item/location or cancel an item/location from the order. * * null null Yes The quantity ordered of item. This can be updated in worksheet or approved status to adjust the quantity of an item/location or cancel an item/location from the order. location_type varchar21 0 1 The location type of the location. Valid values are 'S' store and 'W' warehouse. This field cannot be modified. * * null null Yes The location type of the location. Valid values are 'S' store and 'W' warehouse. This field cannot be modified. cancel_ind varchar21 0 1 Indicates if the detail record's quantity should be cancelled. Valid values are 'Y'es and 'N'o. * * null null No Indicates if the detail record's quantity should be cancelled. Valid values are 'Y'es and 'N'o. reinstate_ind varchar21 0 1 Indicates if a detail record which was previously cancelled should be reinstated. This will reinstate in the order quantity the amount in the cancelled bucket. Valid values are 'Y'es and 'N'o. * * null null No Indicates if a detail record which was previously cancelled should be reinstated. This will reinstate in the order quantity the amount in the cancelled bucket. Valid values are 'Y'es and 'N'o. delivery_date xs:dateTime 0 1 The date by which goods are to be delivered. There can be multiple item-locations on the order with different delivery dates. 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 for ordloc. 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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:XOrdSkuDtl 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 XOrdSkuDtl in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description item varchar225 0 1 An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). This is required if the ref_item field is not populated.An item/location may be added to the order in worksheet or approved status. * * null null No An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). This is required if the ref_item field is not populated.An item/location may be added to the order in worksheet or approved status. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes for ordsku. 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

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

XML-Schema Name:XOrderRef 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 XOrderRef in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description order_no varchar212 1 1 The unique identifier for the order. * * null null Yes The unique identifier for the order. XOrderDtlRef * 0 unbounded Description is not available. attempt_rms_load varchar26 0 1 This field indicates if the order will be created in RMS or the staging tables. Valid values are RMS or STG. If not defined, the default is STG. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:XOrderDtlRef 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 XOrderDtlRef in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description item varchar225 0 1 An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). * * null null No An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). location number10 1 1 An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. * * null null Yes An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. ref_item varchar225 0 1 The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required. * * null null No The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required.

Retail Integration Mappings Report Release:16.0.030

(Advanced Inventory Planning)

Application Advanced Inventory Planning Target Name Space http://www.oracle.com/retail/integration/base/bo/XTsfDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure XTsfDesc XTsfDtl CustFlexAttriVo

XML-Schema Name:XTsfDesc 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 XTsfDesc in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description tsf_no number12 1 1 Number that uniquely identifies the transfer. * * null null Yes Number that uniquely identifies the transfer. from_loc_type varchar21 1 1 The location type of the from location. * * null null Yes The location type of the From location. from_loc varchar210 1 1 The location number of the from location. * * null null Yes The location number of the From location. to_loc_type varchar21 1 1 The location type of the to location. * * null null Yes The location type of the To location. to_loc varchar210 1 1 The location number of the to location. * * null null Yes The location number of the To location. delivery_date xs:dateTime 0 1 The earliest date the transfer can be delivered. * * null null No The earliest date on which the transfer can be delivered. dept number4 0 1 The department number associated with the transfer. * * null null No The department number associated with the transfer. routing_code varchar21 0 1 If the freight status is expedite, this is a code indicating more detailed freight info. * * null null No If the freight status is expedite, this code indicates more detailed freight information. freight_code varchar21 0 1 A code indicating the freight status of the transfer (e.g. normal, expedite, etc.). * * null null No A code indicating the freight status of the transfer (such as normal and expedite.). tsf_type varchar26 0 1 A code indicating the type of transfer (e.g. store requisition, book transfer, etc.). * * null null No A code indicating the type of transfer (for example, store requisition and book transfer). XTsfDtl * 0 unbounded Child node - see layout below. status varchar21 0 1 A code indicating the status of the transfer (e.g. approved, closed, etc.). * * null null No A code indicating the status of the transfer (such as Approved and Closed). user_id varchar230 0 1 The userid of the user who created the transfer. * * null null No The userid of the user who created the transfer. comment_desc varchar22000 0 1 Comments associated with the transfer. * * null null No Comments associated with the transfer. context_type varchar26 0 1 This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. context_value varchar225 0 1 This field holds the value relating to the context type like Promotion number. 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:XTsfDtl 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 XTsfDtl in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description item varchar225 1 1 The unique identifier of the item being transferred. * * null null Yes The unique identifier of the item being transferred. tsf_qty number12_4 1 1 The total quantity of the item reserved for this transfer at the from location. * * null null Yes The total quantity of the item reserved for this transfer at the from location. supp_pack_size number12_4 0 1 The supplier pack size for this item/transfer. * * null null No The supplier pack size for this item/transfer. inv_status number2 0 1 A code indicating the inventory status for this transfer detail; valid values are found on the inv_status_types table. * * null null No A code indicating the inventory status for this transfer detail. Valid values are in the inv_status_types table. unit_cost number20_4 0 1 Not mapped to a database field. Sometimes used to calculate retail price. * * null null No Not mapped to a database field. Sometimes used to calculate retail price. adjustment_type varchar26 0 1 Not mapped to a database field. Sometimes used to calculate retail price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. adjustment_value number20_4 0 1 Not mapped to a database field. Sometimes used to calculate retail price. 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 AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP'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

(Advanced Inventory Planning)

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

XML-Schema Name:XTsfRef 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 XTsfRef in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description tsf_no number12 1 1 The transfer number where info is being deleted. * * null null Yes The transfer number where information is being deleted. XTsfDtlRef * 0 unbounded Child node - see below.

XML-Schema Name:XTsfDtlRef 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 XTsfDtlRef in AIP application. AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and BDI) AIP's Column Length Is Column Required in AIP's API? AIP's API Description item varchar225 1 1 The item for which transfer info is being deleted. * * null null Yes The item for which transfer information is being deleted.