Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderDesc/v1 Version 1.0 Description XSD Structure CustOrderDesc

XML-Schema Name:CustOrderDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_id varchar248 1 1 The customer order id. TR_OR_ORD ID_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. external_ref_id varchar2120 0 1 The id from an external source that is linked to this order. This is used for integration purpose. 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. TR_OR_ORD ID_CNY_ICD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. lcl:LocaleDesc * 1 1 The order's original receipt locale. NA NA NA NA NA NA order_desc varchar2250 0 1 The order description in its original receipt locale. TR_OR_ORD DESC_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. order_status order_status 1 1 A enum indicating the order status. The possible values are "NEW", "PARTIAL", "CANCELED", or "COMPLETED". TR_OR_ORD ST_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. initiate_loc_type initiate_loc_type 1 1 A enum indicating the location type where the order is initiated. The possible values are "O" for online or "S" for store. TR_OR_ORD TY_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. initiate_loc_id number10 1 1 The location id where the order is initiated. TR_OR_ORD ID_STR_RT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. initiate_country_code varchar23 1 1 The country code where the order is initiated. TR_RTL CD_CO_ISO RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. grand_total number20_4 0 1 The grand total order amount that includes discount, tax, and shipping charges. TR_OR_ORD TOT_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. sub_total number20_4 0 1 The subtotal order amount that does not include discount, tax, and shipping charges. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_total number20_4 0 1 Total amount of sales tax paid for this order Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. inclusive_tax_total number20_4 0 1 Total amount of VAT tax paid for this order. The VAT tax is already included in the item price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. shipping_charge_total number20_4 0 1 The total amount of shipping charge paid for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_total number20_4 0 1 The total amount of discount for this order. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_amount number20_4 0 1 The total amount picked up or shipped for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_amount number20_4 0 1 The total amount cancelled for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_amount number20_4 0 1 The total amount returned for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_discount_amount number20_4 0 1 The discount amount applied to order items that have been picked up or shipped. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_discount_amount number20_4 0 1 The discount amount applied to order items that have been cancelled. RIB or/and RSB or/and RSL Fill column length. No Fill this description. returned_discount_amount number20_4 0 1 The discount amount applied to order items that have been returned. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_tax_amount number20_4 0 1 The tax amount applied to order items that have been picked up or shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_tax_amount number20_4 0 1 The tax amount applied to order items that have been cancelled. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_tax_amount number20_4 0 1 The tax amount applied to order items that have been returned. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been picked up or shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been cancelled. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been returned. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. paid_amount number20_4 0 1 The total paid amount for this order. This amount plus the rounding_adjustment is the actual payment amount that the customer made for the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. rounding_adjustment number20_4 0 1 The rounding adjustment for this order. It can be positive or negative. This amount plus the paid_amount is the actual payment amount that the customer made for the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cst:CustomerDesc * 0 1 The linked customer for this order. NA NA NA NA NA NA gift_receipt_assigned gift_receipt_assigned 1 1 A boolean flag indicating if a gift receipt is assigned to this order. The possible values are "Y" or "N". TR_RTL FL_RCP_GF_TRN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. default_gift_registry_id varchar214 0 1 The default gift registry id of the order if there is one. TR_RTL ID_REGISTRY RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. age_restricted_dob xs:dateTime 0 1 The birthday of the customer if the order has restrictive items. TR_RTL DT_AG_RST_DOB RIB or/and RSB or/and RSL Date No The date of birth of the Customer. The Transaction needs to preserve Date of Birth when Item age restriction is in effect. create_timestamp xs:dateTime 1 1 The order creation timestamp. TR_OR_ORD TS_MDF_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. update_timestamp xs:dateTime 1 1 The order update timestamp. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. itm:CustOrdItmColDesc * 0 1 A collection of order items. NA NA NA NA NA NA ful:CustOrdFulColDesc * 0 1 A collection of order fulfillment details. A fulfullment detail defines how a group of items will be fulfilled: in store pick up or ship. NA NA NA NA NA NA del:CustOrdDelColDesc * 0 1 A collection of order delivery records. NA NA NA NA NA NA pay:PaymentColDesc * 0 1 A collection of order payments. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RetMsgExtDesc/v1 Version 1.0 Description XSD Structure RetMsgExtDesc ExtensionEntry

XML-Schema Name:RetMsgExtDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetMsgExtDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ExtensionEntry * 0 unbounded Return Message Extensions.

XML-Schema Name:ExtensionEntry Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ExtensionEntry in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description name varchar250 1 1 Name of the extension. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. value varchar250 1 1 Value of the Extension. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RetAuthResDesc/v1 Version 1.0 Description XSD Structure RetAuthResDesc ReturnResponse ReceiptMessageDesc RetStoreLangDesc ItemReturnResponse RetItemIdentDesc ResponseDescription ShortResponseDesc RetStoreLangDesc LongResponseDesc RetStoreLangDesc ReceiptMessageDesc RetStoreLangDesc RefundTenders RetTendTypeDesc

XML-Schema Name:RetAuthResDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetAuthResDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ReturnResponse * 1 1 Return Response Information.

XML-Schema Name:ReturnResponse Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReturnResponse in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description return_ticket_id varchar230 1 1 Generated Return ticket ID. RM_RTN_TKT AI_RTN_TKT Integer Fill column length. Yes Fill this description. response_approve_deny_code approve_deny_code 1 1 Response approve deny code. RM_LTM_RTN_TKT ID_RSPS_RC Integer Fill column length. Yes Fill this description. avail_cust_service_override xs:boolean 0 1 Available customer service overrides. RM_CT_SV_OVRD ID_CT_SV_OVRD Integer Yes Fill this description. receipt_message_number number8 0 1 Receipt Message number. RM_RCP_MSG NA_MSG_RCP_ID Integer Fill column length. Yes Fill this description. ReceiptMessageDesc * 0 1 Receipt message description. ItemReturnResponse * 1 unbounded Item return response.

XML-Schema Name:ReceiptMessageDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptMessageDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetStoreLangDesc:RetStoreLangDesc * 1 1 Contains store languages information. NA NA NA NA NA NA

XML-Schema Name:RetStoreLangDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetStoreLangDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_locale varchar2255 0 1 Contains the language information used at the store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. operator_locale varchar2255 0 1 Operator language. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_locale varchar2255 0 1 Receipt language. 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:ItemReturnResponse Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemReturnResponse in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetItemIdentDesc:RetItemIdentDesc * 1 1 Item Return Response information. NA NA NA NA NA NA approved_quantity number11 0 1 Approved quantity. RM_LE_SMY_RTN QU_RTN_ITM_AP Integer Fill column length. Yes Fill this description. response_code number8 1 1 Response code. RM_RSPS_RC ID_RSPS_RC Integer Fill column length. Yes Fill this description. approve_deny_code approve_deny_code 1 1 Approve deny code. RM_LTM_RTN_TKT ID_RSPS_RC Integer Fill column length. Yes Fill this description. ResponseDescription * 1 1 Response Description. receipt_message_number number8 0 1 Receipt Message number. RM_RCP_MSG NA_MSG_RCP_ID Integer Fill column length. Yes Fill this description. ReceiptMessageDesc * 0 1 Receipt Message Description. RefundTenders * 0 1 Refund Tenders. item_disposition_code varchar210 0 1 Item disposition code. OR_LTM DP_ORD_LN_ITM Varchar 4 Yes Fill this description. restocking_fee number15 0 1 Restocking fee. TR_LTM_SLS_RTN MO_FE_RSTK Decimal 13 Yes Fill this description. customer_info_required xs:boolean 0 1 Flag to determine if customer information is required. 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:RetItemIdentDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetItemIdentDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item_id varchar214 1 1 Item Id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_description varchar2250 0 1 Item Description. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_type varchar220 0 1 Item Type. 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:ResponseDescription Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ResponseDescription in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ShortResponseDesc * 1 1 Short Response description. LongResponseDesc * 1 1 Long Response description.

XML-Schema Name:ShortResponseDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShortResponseDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetStoreLangDesc:RetStoreLangDesc * 1 1 Contains description for the all the store languages. NA NA NA NA NA NA

XML-Schema Name:RetStoreLangDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetStoreLangDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_locale varchar2255 0 1 Contains the language information used at the store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. operator_locale varchar2255 0 1 Operator language. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_locale varchar2255 0 1 Receipt language. 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:LongResponseDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LongResponseDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetStoreLangDesc:RetStoreLangDesc * 1 1 Contains description for the all the store languages. NA NA NA NA NA NA

XML-Schema Name:RetStoreLangDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetStoreLangDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_locale varchar2255 0 1 Contains the language information used at the store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. operator_locale varchar2255 0 1 Operator language. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_locale varchar2255 0 1 Receipt language. 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:ReceiptMessageDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptMessageDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetStoreLangDesc:RetStoreLangDesc * 1 1 Contains store languages information. NA NA NA NA NA NA

XML-Schema Name:RetStoreLangDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetStoreLangDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_locale varchar2255 0 1 Contains the language information used at the store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. operator_locale varchar2255 0 1 Operator language. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_locale varchar2255 0 1 Receipt language. 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:RefundTenders Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RefundTenders in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetTendTypeDesc:RetTendTypeDesc * 0 unbounded Tender Type information. NA NA NA NA NA NA

XML-Schema Name:RetTendTypeDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetTendTypeDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description type varchar220 1 1 Tender Type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. amount number15 0 1 Tender amount. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. amount_in_base_cur number15 0 1 Tender amount in base currency. Not required to pass this data. Calculated at the RM application using the base currency conversion. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. card_number varchar220 0 1 Masked card number details. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ASNOutDesc/v1 Version 1.2 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ASNOutDesc ASNOutDistro ASNOutCtn ASNOutItem

XML-Schema Name:ASNOutDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description schedule_nbr number8 0 1 Contains the Schedule identifier number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. auto_receive varchar21 0 1 Contains the flag to enable auto_receiving at SIM Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this 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. to_loc_type varchar21 0 1 This field contains the location type of the to_location field. Valid values are 'S' = store, 'E' = finisher, and 'W' = warehouse. RWMS publishes data on this field but does not use it. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_store_type varchar21 0 1 Indicates the store type of the to_location. This will only be populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. RWMS publishes data on this field but does not use it. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_stockholding_ind varchar21 0 1 Indicates if the to_location is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. RWMS publishes data on this field but does not use it. 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. from_loc_type varchar21 0 1 This field contains the location type of the from_location field. Valid values are 'S' = store and 'W' = warehouse. RWMS publishes data on this field but does not use it. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_store_type varchar21 0 1 Indicates the store type of the from_location. This will only be populated if from_location is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Publications from RWMS will always be NULL for this field. RWMS publishes data on this field but does not use it. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_stockholding_ind varchar21 0 1 Indicates if the from_location is stockholding or not. Only populated if from_location is 'S'. Valid values are: 'Y' = yes, 'N' = no. Publications from RWMS will always be NULL for this field. RWMS publishes data on this field but does not use it. 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. transshipment_nbr 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. ASNOutDistro * 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. 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.

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

XML-Schema Name:ASNOutCtn Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutCtn in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS'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 Contains the date to be included in the RMS publication to the RIB for communication to the warehouse. 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. ASNOutItem * 1 unbounded Description is not available. comments varchar22000 0 1 Contains any comments about the shipment container. 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. carrier_shipment_nbr varchar2120 0 1 This field represents the shipment number that manifest systems use to group multi-container shipments for a carrier. Typically a 1 of 4 type message. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. original_item_id varchar225 0 1 The ID of the item being replaced. Populated only when this record is for a substitute item on a customer order. 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:ASNOutItem Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutItem in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS'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. gross_cost number20_4 0 1 Contains the gross cost. 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. 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. from_disposition varchar24 0 1 This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_disposition varchar24 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. voucher_number varchar216 0 1 Contains the voucher number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. voucher_expiration_date xs:dateTime 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. comments varchar22000 0 1 Contains any comment about the item in the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_cost number20_4 0 1 Contains the unit cost of the item in the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. base_cost number20_4 0 1 This value will be used to get the base cost (BC) from RFM for a transfer, which will flow into 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.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustomerCriVo/v1 Version 1.0 Description XSD Structure CustomerCriVo CustomerInfoCriteria BusinessInfoCriteria

XML-Schema Name:CustomerCriVo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustomerCriVo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description search_type customer_search_type 1 1 Can be one of the following: by customer id, by employee id, by tax id, by customer info or by business info. These are mutually exclusive NA NA RSB NA Yes NA customer_id varchar214 0 1 If search by customer id, it contains the customer id; otherwise is empty NA NA RSB NA Yes NA employee_id varchar210 0 1 If search by employee id, it contains the employee id linked with a customer; otherwise it is empty. NA NA RSB NA Yes NA tax_id varchar21000 0 1 If search by tax id, it contains the customer tax id; otherwise it is empty NA NA RSB NA Yes NA phone_number varchar230 0 1 If search by phone number, it contains the phone number; otherwise it is empty NA NA RSB NA Yes NA CustomerInfoCriteria * 0 1 If regular customer, and search by customer info, contains the customer information search criteria.Otherwise it is empty BusinessInfoCriteria * 0 1 If business customer, and search by business info, it contains the business information search criteria. Otherwise the field is empty. wildcard_search flag 1 1 Indicates if a wildcard search needs to be performed; always true for ORPOS NA NA RSB NA Yes NA ignore_case_search flag 1 1 Indicates if an igonore case search needs to be performed; always true for ORPOS NA NA RSB NA Yes NA max_record number4 0 1 If multiple matches found, it indicates how many records need to be returned for this search NA NA RSB NA Yes NA

XML-Schema Name:CustomerInfoCriteria Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustomerInfoCriteria in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description first_name varchar2120 0 1 Contains customer's first name used for searching. NA NA RSB NA Yes NA last_name varchar2120 0 1 Contains customer's last name used for searching. NA NA RSB NA Yes NA postal_code varchar230 0 1 Contains customer's postal code used for searching. NA NA RSB NA Yes NA address_1 varchar2240 0 1 Contains Address Line 1. NA NA RSB NA Yes NA phone_number varchar230 0 1 Contains customer's phone number used for searching. NA NA RSB NA Yes NA

XML-Schema Name:BusinessInfoCriteria Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for BusinessInfoCriteria in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description company_name varchar2120 0 1 Contains the business name used for searching. NA NA RSB NA Yes NA postal_code varchar230 0 1 Contains the business postal code used for searching. NA NA RSB NA Yes NA address_1 varchar2240 0 1 Contains Address Line 1. NA NA RSB NA Yes NA phone_number varchar230 0 1 Contains the business phone number used for searching. NA NA RSB NA Yes NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service 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:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TaxLineDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description line_no number4 1 1 A number that uniquely identifies a tax line within an order line item. TR_LTM_SLS_RTN_TX AI_LN_ITM RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_authority_id number22 1 1 ID_ATHY_TX TR_LTM_SLS_RTN_TX_ORD ID_ATHY_TX 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 TR_LTM_SLS_RTN_TX_ORD ID_GP_TX RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_type_code number22 1 1 A tax type code TR_LTM_SLS_RTN_TX_ORD TY_TX 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". TR_LTM_SLS_RTN_TX FLG_TX_HDY 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 TR_LTM_SLS_RTN_TX MO_TXBL_RTN_SLS 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 TR_LTM_SLS_RTN_TX MO_TX_TOT 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. TR_LTM_SLS_RTN_TX_ORD MO_TX_COMPL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. 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. TR_LTM_SLS_RTN_TX_ORD MO_TX_CANCL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. 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. TR_LTM_SLS_RTN_TX_ORD MO_TX_RTRN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. 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". TR_LTM_SLS_RTN_TX FL_TX_INC 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. TR_LTM_SLS_RTN_TX TX_MOD 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 TR_LTM_SLS_RTN_TX PE_TX RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_rule_name varchar2120 0 1 The tax rule name TR_LTM_SLS_RTN_TX NM_RU_TX RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RetTendTypeDesc/v1 Version 1.0 Description XSD Structure RetTendTypeDesc

XML-Schema Name:RetTendTypeDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetTendTypeDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description type varchar220 1 1 Tender Type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. amount number15 0 1 Tender amount. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. amount_in_base_cur number15 0 1 Tender amount in base currency. Not required to pass this data. Calculated at the RM application using the base currency conversion. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. card_number varchar220 0 1 Masked card number details. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrdItmDesc/v1 Version 1.0 Description XSD Structure CustOrdItmDesc AlterationItem GiftCardItem

XML-Schema Name:CustOrdItmDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrdItmDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description line_item_no number4 1 1 A number that uniquely identifies an order line item within an order in OMS. During an order create, it is initiated by an order capture application such as ORPOS. Once an order is created, OMS owns the order. OMS is responsible to manage or alter line_item_no in any way it deems appropriate. In addition, OMS is responsible of maintaining a mapping between line_item_no and captured_line_item_no. TR_LTM_SLS_RTN AI_LN_ITM RSB Yes captured_line_item_no number4 1 1 A number that uniquely identifies an order line item within an order in an order capture application such as ORPOS. This is a number assigned by the order capture application, and should never be altered by OMS. NA NA NA NA Yes NA item_id varchar225 1 1 The order item id TR_LTM_SLS_RTN id_itm RSB Yes item_upc varchar225 1 1 The order item UPC. NA NA RSB NA Yes NA item_description varchar2250 1 1 The order item description in its original receipt locale. 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 1 1 The total item quantity ordered TR_LTM_SLS_RTN_ORD QU_ITM_ORD RSB Yes available_quantity number12_4 1 1 The item quantity available to be picked up or shipped to a customer or store. TR_LTM_SLS_RTN_ORD QU_ITM_AVL RSB Yes completed_quantity number12_4 1 1 The item quantity that has been picked up or shipped. TR_LTM_SLS_RTN_ORD QU_ITM_PCK/QU_ITM_SHP RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_quantity number12_4 1 1 The item quantity that has been cancelled. TR_LTM_SLS_RTN_ORD QU_ITM_CAL RSB Yes returned_quantity number12_4 1 1 The item quantity that has been returned. TR_LTM_SLS_RTN_ORD QU_ITM_RTN RSB Yes unit_of_measure varchar24 0 1 The unit of measure of the order item. NA NA RSB NA Yes NA currency_code varchar23 1 1 The currency ISO code NA NA RSB NA Yes NA item_total number20_4 0 1 The total extended price of an item with discount and tax applied. TR_LTM_SLS_RTN MO_EXTN_LN_ITM_RTN(calculated) RSB Yes unit_sell_price number20_4 1 1 The sell unit price of the item. This reflects the promotional or manually overriden price. TR_LTM_SLS_RTN MO_PRN_PRC(calculated) RSB Yes unit_regular_price number20_4 1 1 The regular unit price of the item. NA NA RSB NA Yes NA completed_amount number20_4 1 1 The amount that has been picked up or shipped for the item. TR_LTM_SLS_RTN_ORD MO_ORD_COMPL RSB Yes cancelled_amount number20_4 1 1 The amount that has been cancelled for the item. TR_LTM_SLS_RTN_ORD MO_ORD_CANCL RSB Yes returned_amount number20_4 1 1 The amount that has been returned for the item. TR_LTM_SLS_RTN_ORD MO_ORD_RETRN RSB Yes paid_amount number20_4 1 1 The amount already paid for the item TR_LTM_SLS_RTN MO_EXTN_DSC_LN_ITM RSB Yes discount_total number20_4 0 1 The total discount applied to the item NA NA RSB NA Yes NA completed_discount_amount number20_4 0 1 The discount amount applied to item units that have been picked up or shipped in this order line item. NA NA NA NA Yes NA cancelled_discount_amount number20_4 0 1 The discount amount applied to item units that have been cancelled in this order line item. NA NA NA NA Yes NA returned_discount_amount number20_4 0 1 The discount amount applied to item units that have been returned in this order line item. NA NA RSB NA Yes NA tax_total number20_4 0 1 The tax applied to the item NA NA RSB NA Yes NA completed_tax_amount number20_4 0 1 The tax amount applied to item units that have been picked up or shipped in this order line item. NA NA RSB NA Yes NA cancelled_tax_amount number20_4 0 1 The tax amount applied to item units that have been cancelled in this order line item. NA NA NA NA Yes NA returned_tax_amount number20_4 0 1 The tax amount applied to item units that have been returned in this order line item. NA NA RSB NA Yes NA inclusive_tax_total number20_4 0 1 The VAT tax amount that is included in the item price RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to item units that have been picked up or shipped in this order line item. NA NA NA NA Yes NA cancelled_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to item units that have been cancelled in this order line item. NA NA NA NA No NA returned_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to item units that have been returned in this order line item. NA NA RSB NA Yes NA ovd:PrcOvdLineDesc * 0 1 The manual price override applied to the item. NA NA NA NA NA NA prm:PromoLineDesc * 0 1 The price promtion applied to the item. NA NA NA NA NA NA dis:DiscntLineColDesc * 0 1 A collection of discount line items for the item. NA NA NA NA NA NA tax:TaxLineColDesc * 0 1 A collection of tax line items of the item NA NA NA NA NA NA department_id varchar214 1 1 The order item department id. TR_LTM_SLS_RTN ID_DPT_POS RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. restrictive_age number22 1 1 The minimum age required to purchase the order item. TR_LTM_SLS_RTN IDN_SLS_AG_RST RSB Yes discountable_flag flag 1 1 The boolean flag indicating if the order item is eligible for discount. The possible values are "Y" or "N". TR_LTM_SLS_RTN FL_ITM_DSC RSB Yes damage_discountable_flag flag 1 1 The boolean flag indicating if the order item is eligible for damage discount. The possible values are "Y" or "N". TR_LTM_SLS_RTN FL_ITM_DSC_DMG RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. employee_discountable_flag flag 1 1 The boolean flag indicating if the order item is eligible for employee discount. The possible values are "Y" or "N". TR_LTM_DSC LU_BAS_ASGN RSB Yes item_type item_type 1 1 The item type enum NA NA RSB NA Yes NA manufacturer_upc varchar214 0 1 The manufacturer upc TR_LTM_SLS_RTN ID_ITM_MF_UPC RSB Yes merchandise_hierarchy_group_id varchar214 1 1 The merchandise hierarchy group id of the order item. TR_LTM_SLS_RTN ID_MRHRC_GP RSB Yes product_group product_group 0 1 The product group of the order item TR_LTM_SLS_RTN RSB Yes restocking_fee_flag flag 1 1 A boolean flag indicating if restocking fee should be applied to the order item during return. The possible values are "Y" or "N". TR_LTM_SLS_RTN FL_FE_RSTK RSB Yes return_eligible_flag flag 1 1 A boolean flag indicating if the order item is eligible for return. The possible values are "Y" or "N". TR_LTM_SLS_RTN FL_RTN_PRH RSB Yes serialized_item_flag flag 1 1 A boolean flag indicating if the order item requires a serial number. The possible values are "Y" or "N". TR_LTM_SLS_RTN FL_VLD_SRZ_ITM RSB Yes validate_serial_number_flag flag 0 1 If the order item requires a serial number, this boolean flag indicates if the entered serial number must be validated by the store inventory system. The possible values are "Y" or "N". NA NA RSB NA Yes NA allow_new_serial_number_flag flag 0 1 If the order item requires a serial number, this boolean flag indicates if it is allowed to enter a serial number that is new to the store inventory system. The possible values are "Y" or "N". NA NA NA NA Yes NA size_required_flag flag 1 1 A boolean flag indicating if the order item requires a size code. The possible values are "Y" or "N". TR_LTM_SLS_RTN FL_ITM_SZ_REQ RSB Yes tax_group_id number22 1 1 The order item's tax group id that indicates how tax is calculated for the item. TR_LTM_SLS_RTN ID_GP_TX RSB Yes taxable_flag flag 1 1 A boolean flag that indicates if the order item is taxable. The possible values are "Y" or "N". TR_LTM_SLS_RTN FL_TX RSB Yes weight number12_4 0 1 The weight of the item. NA NA RSB NA Yes NA serial_number varchar240 0 1 The serial number of the order item if it has one TR_LTM_SLS_RTN ID_NMB_SRZ RSB Yes size_code varchar210 0 1 The size code of the order item if it has one. TR_LTM_SLS_RTN ED_SZ RSB Yes gift_registry_id varchar214 0 1 The gift registry id if the order item is purchased from a gift registry. TR_LTM_SLS_RTN ID_REGISTRY RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. gift_receipted_item_flag flag 1 1 A boolean flag indicating if a gift receipt is printed for the order item. The possible values are "Y" and "N". TR_LTM_SLS_RTN FL_RCV_GF RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. shipping_charge_flag flag 1 1 A boolean flag indicating if the item is a shipping charge. The possible values are "Y" and "N". TR_LTM_SLS_RTN FL_SHP_CHG RSB Yes entry_method entry_method 0 1 A entry method enum indicating how the order item is entered. TR_LTM_SLS_RTN LU_MTH_ID_ENR RSB Yes AlterationItem * 0 1 Additional info if the order item is an alteration service item GiftCardItem * 0 1 Additional info if the order item is a gift card item. fulfillment_seq_no number4 1 1 The sequence no of an order's fulfillment detail. It should match a sequence no in CustOrdFulDesc. NA NA RSB NA Yes NA

XML-Schema Name:AlterationItem Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AlterationItem in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description alteration_type alteration_type 1 1 The type of alteration NA NA NA NA Yes NA instruction varchar2250 0 6 User entered instructions for the alteration TR_ORD_DEL_DTL SPL_INSTRC RSB Yes

XML-Schema Name:GiftCardItem Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for GiftCardItem in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description card_number varchar220 1 1 The gift card number DO_CRD_GF ID_NCRPT_ACNT_CRD RSB Yes request_type giftcard_req_type 1 1 The request type: issue or reload DO_CRD_GF TY_RQST_GF_CRD RSB Yes authorization_code varchar220 1 1 The authorization code returned by the authorizer DO_CRD_GF TS_AZN RSB Yes authorization_datetime xs:dateTime 0 1 The date and time the gift card is authorized NA NA RSB NA Yes NA original_balance number20_4 0 1 The original balance of the gift card DO_CRD_GF BLNC_GF_CRD_ORIG RSB Yes current_balance number20_4 1 1 The current balance of the gift card DO_CRD_GF BLNC_GF_CRD RSB Yes settlement_data varchar216 0 1 The authorization settlement data DO_CRD_GF LU_AZN_STLM_DT RSB Yes

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdCustDesc/v1 Version 1.0 Description This object is used to communicate customer details related to a customer order fulfillment request from OMS to RMS and SIM. XSD Structure FulfilOrdCustDesc LocOfFulfilOrdCustDesc

XML-Schema Name:FulfilOrdCustDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCustDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_no varchar214 0 1 Indicates the number that uniquely identifies the customer in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_first_name varchar2120 0 1 Contains the first name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phonetic_first varchar2120 0 1 Contains the phonetic first name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_last_name varchar2120 0 1 Contains the last name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phonetic_last varchar2120 0 1 Contains the phonetic last name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_preferred_name varchar2120 0 1 Contains the preferred name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_company_name varchar2120 0 1 Contains the company name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add1 varchar2240 0 1 First line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add2 varchar2240 0 1 Second line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add3 varchar2240 0 1 Third line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_county varchar2250 0 1 County portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_city varchar2120 0 1 City portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_state varchar23 0 1 State portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_country_id varchar23 0 1 Country portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_post varchar230 0 1 Postal code portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the delivery country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phone varchar220 0 1 Contains the delivery phone number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_first_name varchar2120 0 1 Contains the first name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_first varchar2120 0 1 Contains the phonetic first name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_last_name varchar2120 0 1 Contains the last name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_last varchar2120 0 1 Contains the phonetic last name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_preferred_name varchar2120 0 1 Contains the preferred name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_company_name varchar2120 0 1 Contains the company name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add1 varchar2240 0 1 First line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add2 varchar2240 0 1 Second line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add3 varchar2240 0 1 Third line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_county varchar2250 0 1 County portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_city varchar2120 0 1 City portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_state varchar23 0 1 State portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_country_id varchar23 0 1 Country portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_post varchar230 0 1 Postal code portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the billing country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phone varchar220 0 1 Contains the billing phone number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. LocOfFulfilOrdCustDesc:LocOfFulfilOrdCustDesc * 0 1 References a collection of localization extension. NA NA NA NA NA NA

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

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrdDelDesc/v1 Version 1.0 Description XSD Structure CustOrdDelDesc

XML-Schema Name:CustOrdDelDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrdDelDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description seq_no number4 1 1 The sequence no of an order delivery record. NA NA NA NA Yes NA delivery_loc_type enum_delivery_loc_type 1 1 An enum indicating the location type the items are delivered or cancelled. The possible values are "S" for store, or "W" for warehouse. NA NA NA NA Yes NA delivery_loc_id number10 1 1 The location id where the order items are delivered or cancelled. TR_ORD_DEL_DTL ID_STR_RT RSB Yes delivery_type enum_delivery_type 1 1 An enum indicating the delivery type. The possible values are "C" for customer pickup and "S" for ship direct. TR_LTM_SLS_RTN_ORD FL_SHP_TO_PCKP RSB Yes delivery_date xs:dateTime 1 1 The actual date the items are delivered or cancelled. This will be the GMT time. TR_ORD_DEL_DTL DC_ORD_DEL RSB Yes delivery_time xs:dateTime 0 1 The actual time the items are delivered or cancelled. This will be the GMT time. TR_ORD_DEL_DTL DC_ORD_DEL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. customer_id varchar214 0 1 The customer id of the person who receives or cancels the items. TR_ORD_DEL_DTL ID_CT RSB Yes customer_signature varchar25000 0 unbounded The signature of the person who receives or cancels the items in SVG format Base64 encoded. OR_RCPNT_DTL CH_IM_TRN_AZN_CT RSB Yes carrier_code varchar24 0 1 The carrier code to deliver the order items. TR_ORD_DEL_DTL SHP_CRR_DEL RSB Yes carrier_service_code varchar26 0 1 The carrier service code to deliver the order items. TR_ORD_DEL_DTL SHP_TYP_DEL RSB Yes carrier_tracking_no varchar2120 0 1 The carrier tracking no to deliver the order items. NA NA NA NA Yes NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdCfmCol/v1 Version 1.0 Description This object is used to communicate customer order confirmation and detail back to OMS from RMS and SIM. This object is also used by SIM to confirm that an order can be picked up for store pickup fulfillment. XSD Structure FulfilOrdCfmCol FulfilOrdCfmDesc FulfilOrdCfmDtl

XML-Schema Name:FulfilOrdCfmCol Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmCol in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description collection_size number4 1 1 Number of items in the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdCfmDesc:FulfilOrdCfmDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdCfmDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_no varchar248 1 1 Holds the master customer order number from OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_type confirm_type 1 1 Contains the confirmation type. 'P' - Order Partially Created; 'X' - Order Could not be Created. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_no number12 0 1 Contains the PO or Transfer number in RMS related to the fulfillment order line. Required if fulfillment status is 'P'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdCfmDtl:FulfilOrdCfmDtl * 0 unbounded References a collection of customer order confirmation item details. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdCfmDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_qty number12_4 1 1 Indicates the quantity of the item that can be sourced or fulfilled on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_qty_uom varchar24 1 1 Indicates the unit of measure of the confirmation quantity. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/InvAvToPromCriVo/v1 Version 1.0 Description XSD Structure InvAvToPromCriVo InvAvLocation

XML-Schema Name:InvAvToPromCriVo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvAvToPromCriVo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Contains the item identifier for which to check inventory. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. min_qty number12_4 1 1 Contains the minimum item quantity needed. 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 varchar24 0 1 Contains the unit of measure for quantity. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. InvAvLocation * 1 unbounded Contains the locations at which to check inventory.

XML-Schema Name:InvAvLocation Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvAvLocation in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description location number10 1 1 The location at which to check item inventory. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. loc_type loc_type 1 1 Type of item inventory location. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderRtnColVo/v1 Version 1.0 Description XSD Structure CustOrderRtnColVo

XML-Schema Name:CustOrderRtnColVo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderRtnColVo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description rtn:CustOrderRtnVo * 1 unbounded A collection of customer order return value objects. NA NA NA NA NA NA collection_size number4 1 1 The collection size. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrdFulColDesc/v1 Version 1.0 Description XSD Structure CustOrdFulColDesc

XML-Schema Name:CustOrdFulColDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrdFulColDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ful:CustOrdFulDesc * 1 unbounded A fulfillment detail object. NA NA NA NA NA NA collection_size number4 1 1 The number of CustOrdFulDesc objects. NA NA NA NA Yes NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderRef/v1 Version 1.0 Description XSD Structure CustOrderRef

XML-Schema Name:CustOrderRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description order_id varchar250 1 1 The mandatory order id 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfFulfilOrdCustDesc/v1 Version 1.0 Description References a collection of localization extension. XSD Structure LocOfFulfilOrdCustDesc

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

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ReceiptDesc/v1 Version 1.2 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ReceiptDesc Receipt ReceiptDtl ReceiptCartonDtl ReceiptOverage ReceiptOverageDtl

XML-Schema Name:ReceiptDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description schedule_nbr number8 0 1 Contains the Schedule Identifier Number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. appt_nbr number9 0 1 Unique identifier for receiving a group of items. This is usually an RDM-generated unique numericalidentifier for an Appointment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. Receipt * 1 unbounded Description is not available. ReceiptOverage * 0 unbounded Contains the Receipt Overage Information

XML-Schema Name:Receipt Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Receipt in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description dc_dest_id varchar210 1 1 This element corresponds to different RMS tables, depending on the document_type. 'A' -ALLOC_DETAIL.TO_LOC, 'P' - ORDLOC.LOCATION, 'T' - TSFHEAD.TO_LOC Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. po_nbr varchar212 0 1 Specified the unique identifier of the purchase order, allocation or transfer. 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 0 1 This field holds the master customer order number from OMS. 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 0 1 This field holds the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. document_type varchar21 1 1 Specified whether the receipt is for an allocation 'A', purchase order 'P', or transfer 'T'. Types 'D' and 'V' are also valid document types that are treated the same as transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_doc_no number10 0 1 Contains a reference number for a document associated to the shipment (e.g. Fiscal Document ID for Brazilian based transactions). 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 Used to relate the receipt message to the previous ASN message. this field is required for doc types 'A' and 'T', not required for doc_type 'P'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ReceiptDtl * 0 unbounded Description is not available. ReceiptCartonDtl * 0 unbounded Description is not available. receipt_type varchar22 0 1 This fied is required when receiving a transfer or allocation to determine if the receipt is at the 'BL' (BOL) level or 'SK' (SKU) level. It is not used for a PO receipt. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_loc varchar210 0 1 Contains the source location of the shipment. 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 varchar21 0 1 Contains the from location type. 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:ReceiptDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item_id varchar225 1 1 Specifies the item on the allocation, purchase order, or transfer that has been received. 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 quantity received for the allocation, purchase order, or transfer. The shipment record isalso updated with the quantity received (SHIPSKU.QTY_RECEIVED). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_xactn_type varchar21 1 1 Specifies whether the receipt detail line item is for a 'R'eceipt, 'T'ransshipment, or 'A'djustment. Forpurchase order receiving, Transshipments are not allowed. For stock order (ie. Allocation and Transfer) receiving, Transshipments are handled the same way as 'R'eceipt type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_date xs:dateTime 0 1 Identifies the date on which the transaction was written. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_nbr varchar217 1 1 An externally generated numerical identifier corresponding to the successful reception of the itemat the location. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. dest_id varchar210 0 1 Only used for doc_type of 'P', when the purchase order has an allocation attached to it. This elementspecifies the location to which the allocation is being sent. 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 0 1 Identifies the carton number for shipments originating from the Advance Shipment Notificationprocess as carton shipments. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. distro_nbr varchar212 0 1 Only used for doc_type of 'P', when the purchase order has an allocation attached to it. This elementspecifies the allocation id. 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 0 1 Only used for doc_type of 'P', when the purchase order has an allocation attached to it. When populated, this value should always be 'A' to specify an allocation. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_disposition varchar24 0 1 This value is used to determine if the inventory is available or unavailable, based on the code'sINV_STATUS value on the INV_STATUS_CODES table. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_disposition varchar24 0 1 This value is used to determine inventory availability. It is not used by SIM. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_wip varchar26 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_wip varchar26 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_trouble varchar22 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_trouble varchar22 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. user_id varchar230 0 1 Identifies the point of origin for this inventory control document. An originator may be a program (forautomatically generated documents) or a person. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. dummy_carton_ind varchar21 0 1 Indicates if this carton is a dummy carton. This field is only used for transfer receipts. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tampered_carton_ind varchar21 0 1 Indicates if the carton was tampered. This field is only used for transfer receipts. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_cost number20_4 0 1 Only used for doc_type of 'P'. Specifies the unit_cost for the item on the order. Cost is converted to theorder's currency before insert/update. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. shipped_qty number12_4 0 1 Only used for doc_type of 'P'. Updates the number of items expected to be received, originally set bythe ASN process. 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 Contains the actual weight of the item received for the shipment. 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 Contains the unit of measure of the received weight (e.g. pounds, kilograms). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. gross_cost number20_4 0 1 Contains the Unit cost and Expenses incurred on an item in a particular transaction. 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:ReceiptCartonDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptCartonDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description carton_status_ind varchar21 0 1 Denotes the status of the carton received. It can be Actual (A), Dummy (D), or Overage (O). This field is used only for stock order receiving. 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 0 1 Contains the carton ID for the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. dest_id varchar210 0 1 Identifies the location to which the stock order is received. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_xactn_type varchar21 1 1 Specifies whether the carton receipt is for a 'R'eceipt, 'T'ranshipment, or 'A'djustment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_date xs:dateTime 0 1 This field contains the date on which the carton is received. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_nbr varchar217 0 1 This field holds the externally generated number when the shipment is received at the location. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. user_id varchar230 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_disposition varchar24 0 1 This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. 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 Contains the actual weight of the item received for the carton. 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 Contains the unit of measure of the received weight (e.g. pounds, kilograms). 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:ReceiptOverage Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptOverage in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description po_nbr varchar212 0 1 Contains purchase order number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. document_type varchar21 0 1 Contains the document type information. 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 Contains Advanced Shipment Notice number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ReceiptOverageDtl * 0 unbounded Contains Overage Receipt Detail Information

XML-Schema Name:ReceiptOverageDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptOverageDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item_id varchar225 0 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. qty_received number12_4 0 1 Contains the quantity of the item received at the location as overage, damaged etc. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. reason_code number4 0 1 Contains the rejection reason code or overage reason code. 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:14.0.0

(Point Of Service)

Application Point Of Service 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:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Nothing in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description description varchar2500 0 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcOvdLineDesc/v1 Version 1.0 Description XSD Structure PrcOvdLineDesc

XML-Schema Name:PrcOvdLineDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcOvdLineDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description override_reason_code varchar220 0 1 The reason code indicating why the manual price override is applied to the order item. CO_MDFR_RTL_PRC. RC_MDFR_RT_PRC RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. currency_code varchar23 1 1 The currency ISO code CO_MDFR_RTL_PRC Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_overridden_price number20_4 1 1 The overridden price of an order item unit. This is the new unit price, not extended price. CO_MDFR_RTL_PRC MO_EXTD_DSC RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorizing_employee_id varchar210 0 1 The employee id that authorizes the manual price override. CO_MDFR_RTL_PRC ID_EM_AZN_OVRD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. entry_method enum_entry_method 0 1 A enum indicating how the manual price override is entered. CO_MDFR_RTL_PRC CD_MTH_ENR_OVRD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/PaymentDesc/v1 Version 1.0 Description XSD Structure PaymentDesc CreditDebitTender CheckTender CouponTender GiftCardTender GiftCertTender MailCheckTender PurchaseOrdTender StoreCreditTender TravelCheckTender

XML-Schema Name:PaymentDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PaymentDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description seq_no number4 1 1 The sequence no of an order payment record. TR_LTM_TND AI_LN_ITM RSB Yes payment_type payment_type 1 1 The payment type TR_LTM_TND TY_TND RSB Yes currency_code varchar23 1 1 the currency ISO code TR_LTM_TND ID_CNY_ICD RSB Yes amount number20_4 1 1 The payment amount TR_LTM_TND MO_ITM_LN_TND RSB Yes alternate_currency_code varchar23 0 1 The foreign currency ISO code if payed by a foreign currency tender. NA NA RSB NA Yes NA alternate_amount number20_4 0 1 The payment amount in foreign currency if payed by a foreign currency tender. NA NA RSB NA Yes NA CreditDebitTender * 0 1 This records a credit/debit card payment. CheckTender * 0 1 The records a check payment. CouponTender * 0 1 This records a coupon payment. GiftCardTender * 0 1 This records a gift card payment. GiftCertTender * 0 1 This records a gift certificate payment MailCheckTender * 0 1 This records a refund payment by a check mailed to the customer. PurchaseOrdTender * 0 1 This records a purchase order payment. StoreCreditTender * 0 1 This records a store credit payment. TravelCheckTender * 0 1 This records a travelers check payment.

XML-Schema Name:CreditDebitTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CreditDebitTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description masked_account_number varchar220 1 1 The masked card account number TR_LTM_CRDB_CRD_TN ID_MSK_ACNT_CRD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. card_token varchar2100 0 1 The card token returned by the authorizer TR_LTM_CRDB_CRD_TN LU_ACNT_CRD_TKN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. card_type card_type 0 1 The card type such as Visa, Master etc TR_LTM_CRDB_CRD_TN TY_TND RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. entry_method entry_method 0 1 The method the card is entered. TR_LTM_CRDB_CRD_TN LU_NMB_CRD_SWP_KY RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_code varchar240 1 1 The authorization code returned by the authorizer. TR_LTM_CRDB_CRD_TN LU_MTH_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_datetime xs:dateTime 0 1 The date and time the card is authorized. TR_LTM_CRDB_CRD_TN DC_AZN_CRD, TM_AZN_CRD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_method authorization_method 0 1 The authorization method TR_LTM_CRDB_CRD_TN LU_MTH_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_country varchar23 0 1 The country that issues the personal ID. TR_LTM_CRDB_CRD_TN CNTRY_ID RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_state varchar23 0 1 The state that issues the personal ID. TR_LTM_CRDB_CRD_TN ST_ID RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_expiration_date xs:dateTime 0 1 The expiration date of the personal ID. TR_LTM_CRDB_CRD_TN DC_EP_DB_ID RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. prepaid_balance number20_4 0 1 The prepaid amount on the card TR_LTM_CRDB_CRD_TN MO_BLNC_PPD_RMN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. account_apr varchar28 0 1 The account APR TR_LTM_CRDB_CRD_TN LV_ACC_AFT_PRM_APR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. account_apr_type varchar21 0 1 The account APR type TR_LTM_CRDB_CRD_TN TY_ACC_AFT_PRM_APR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_apr varchar28 0 1 The promotional APR TR_LTM_CRDB_CRD_TN LV_DRNG_PRM_APR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_apr_type varchar21 0 1 The promotional APR type TR_LTM_CRDB_CRD_TN TY_DRNG_PRM_APR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_description varchar260 0 1 The description of the promotion TR_LTM_CRDB_CRD_TN DE_PRM RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_duration varchar240 0 1 The duration of the promotion TR_LTM_CRDB_CRD_TN DE_DRNG_PRM RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. settlement_data varchar216 0 1 The authorization settlement data TR_LTM_CRDB_CRD_TN LU_AZN_STLM_DT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. signature_data varchar25000 0 unbounded The customer signature in encoded SVG format. TR_LTM_CRDB_CRD_TN CH_IM_TND_AZN_CT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. additional_security_info varchar220 0 1 The additional security info required of a debit card TR_LTM_CRDB_CRD_TN Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:CheckTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CheckTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description bank_id varchar220 1 1 The bank id TR_LTM_CHK_TND ID_BK_CHK RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. account_number varchar217 1 1 The account number TR_LTM_CHK_TND ID_NCRPT_ACNT_CHK RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. micr_number varchar280 1 1 The MICR number TR_LTM_CHK_TND NR_NCRPT_MICR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. check_number varchar210 1 1 The check number TR_LTM_CHK_TND AI_CHK RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_code varchar220 1 1 The authorization code returned by the authorizer TR_LTM_CHK_TND LU_MTH_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_method authorization_method 0 1 The authorization method TR_LTM_CHK_TND LU_MTH_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_number varchar220 0 1 The personal id number TR_LTM_CHK_TND ID_NCRPT_PRSL_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_issuer varchar220 0 1 The name of the id issuer TR_LTM_CHK_TND LU_ID_PRSL_ISSR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_issuer_co_code varchar222 0 1 The issuer country code TR_LTM_CHK_TND CD_CO_MICR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_issuer_state_code varchar25 0 1 The issuer state code TR_LTM_CHK_TND CD_ST RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. personal_id_swiped_flag personal_id_swiped_flag 0 1 A boolean flag indicating if the ID is swiped or manually entered. The possible values are "Y" or "N". TR_LTM_CHK_TND SWP_ID RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. customer_phone_number varchar230 0 1 The customer phone number TR_LTM_CHK_TND TA_CT, TL_CT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. entry_method entry_method 0 1 The entry method of the check TR_LTM_CHK_TND SWP_ID RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. echeck_conversion_code echeck_conversion_code 0 1 The conversion code of a ECheck TR_LTM_CHK_TND. CD_CNV_AZN_CHK RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:CouponTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CouponTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description coupon_type coupon_type 0 1 The coupon type TR_ITM_CPN_TND TY_CPN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. entry_method entry_method 0 1 The entry method of the coupon TR_ITM_CPN_TND FL_ENR_CPN_KY RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. coupon_number varchar215 1 1 The coupon number TR_ITM_CPN_TND UC_CPN_SC RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:GiftCardTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for GiftCardTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description card_number varchar220 1 1 The gift card number TR_LTM_GF_CRD_TND ID_NCRPT_ACNT_CRD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_code varchar220 1 1 The authorization code returned by the authorizer TR_LTM_GF_CRD_TND LU_MTH_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_datetime xs:dateTime 0 1 The date and time the gift card is authorized TR_LTM_GF_CRD_TND TS_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. authorization_method authorization_method 0 1 The authorization method TR_LTM_GF_CRD_TND LU_MTH_AZN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. credit_flag credit_flag 1 1 A boolean flag indicating if the payment is a credit to the gift card. The possible values are "Y" or "N". TR_LTM_GF_CRD_TND FL_GF_CRD_CR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. entry_method entry_method 0 1 The entry method of the gift card TR_LTM_GF_CRD_TND LU_NMB_CRD_SWP_KY RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. original_balance number20_4 0 1 The original balance of the gift card TR_LTM_GF_CRD_TND BLNC_GF_CRD_ORIG RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. remaining_balance number20_4 0 1 The remaining balance of the gift card TR_LTM_GF_CRD_TND BLNC_GF_CRD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. settlement_data varchar216 0 1 The authorization settlement data TR_LTM_GF_CRD_TND LU_AZN_STLM_DT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:GiftCertTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for GiftCertTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description certificate_type certificate_type 0 1 The gift certificate type TR_LTM_GF_CF_TND TY_SB_GF_CF RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. issue_location_type issue_location_type 0 1 A enum indicating the issue location type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. issue_location_id number10 0 1 The issuer store id TR_LTM_GF_CF_TND ID_STR_ISSG RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. serial_number varchar240 1 1 The gift certificate serial number TR_LTM_GF_CF_TND ID_NMB_SRZ_GF_CF RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:MailCheckTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MailCheckTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description cnct:ContactDesc * 1 1 The name of the person the check is mailed to. NA NA NA NA NA NA addr:GeoAddrDesc * 1 1 The address the check is mailed to. NA NA NA NA NA NA personal_id_type varchar220 0 1 The personal id type used to verify customer identity NA NA RSB NA Yes NA

XML-Schema Name:PurchaseOrdTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PurchaseOrdTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description agent_name varchar2120 1 1 The agent name the purchase order is sent to TR_LTM_PRCH_ORD_TND NM_ORGN RSB Yes purchase_order_number varchar215 1 1 The purchase order number TR_LTM_PRCH_ORD_TND PRCH_ORD_NMB RSB Yes

XML-Schema Name:StoreCreditTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreCreditTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description certificate_type certificate_type 0 1 The store credit certificate type TR_LTM_CR_STR_TND RSB Yes first_name varchar2120 0 1 The first name of the person the store credit is granted to. TR_LTM_CR_STR_TND FN_PRS_CR_STR RSB Yes last_name varchar2120 0 1 The last name of the person the store credit is granted to. TR_LTM_CR_STR_TND LN_PRS_CR_STR RSB Yes personal_id_type varchar220 0 1 The type of personal id used to verify customer identity. TR_LTM_CR_STR_TND TY_ID_CR_STR RSB Yes state state 1 1 The store credit state TR_LTM_CR_STR_TND SC_CR_STR_TND RSB Yes store_credit_id varchar220 1 1 The store credit id TR_LTM_CR_STR_TND ID_CR_STR RSB Yes

XML-Schema Name:TravelCheckTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TravelCheckTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description check_count number22 1 1 the check count TR_LTM_TRV_CHK_TND QU_CHK RSB Yes

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

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

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

XML-Schema Name:CustOrderDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_id varchar248 1 1 The customer order id. TR_OR_ORD ID_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. external_ref_id varchar2120 0 1 The id from an external source that is linked to this order. This is used for integration purpose. 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. TR_OR_ORD ID_CNY_ICD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. lcl:LocaleDesc * 1 1 The order's original receipt locale. NA NA NA NA NA NA order_desc varchar2250 0 1 The order description in its original receipt locale. TR_OR_ORD DESC_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. order_status order_status 1 1 A enum indicating the order status. The possible values are "NEW", "PARTIAL", "CANCELED", or "COMPLETED". TR_OR_ORD ST_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. initiate_loc_type initiate_loc_type 1 1 A enum indicating the location type where the order is initiated. The possible values are "O" for online or "S" for store. TR_OR_ORD TY_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. initiate_loc_id number10 1 1 The location id where the order is initiated. TR_OR_ORD ID_STR_RT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. initiate_country_code varchar23 1 1 The country code where the order is initiated. TR_RTL CD_CO_ISO RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. grand_total number20_4 0 1 The grand total order amount that includes discount, tax, and shipping charges. TR_OR_ORD TOT_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. sub_total number20_4 0 1 The subtotal order amount that does not include discount, tax, and shipping charges. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. tax_total number20_4 0 1 Total amount of sales tax paid for this order Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. inclusive_tax_total number20_4 0 1 Total amount of VAT tax paid for this order. The VAT tax is already included in the item price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. shipping_charge_total number20_4 0 1 The total amount of shipping charge paid for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_total number20_4 0 1 The total amount of discount for this order. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_amount number20_4 0 1 The total amount picked up or shipped for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_amount number20_4 0 1 The total amount cancelled for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_amount number20_4 0 1 The total amount returned for this order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_discount_amount number20_4 0 1 The discount amount applied to order items that have been picked up or shipped. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_discount_amount number20_4 0 1 The discount amount applied to order items that have been cancelled. RIB or/and RSB or/and RSL Fill column length. No Fill this description. returned_discount_amount number20_4 0 1 The discount amount applied to order items that have been returned. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_tax_amount number20_4 0 1 The tax amount applied to order items that have been picked up or shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_tax_amount number20_4 0 1 The tax amount applied to order items that have been cancelled. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_tax_amount number20_4 0 1 The tax amount applied to order items that have been returned. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been picked up or shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been cancelled. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been returned. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. paid_amount number20_4 0 1 The total paid amount for this order. This amount plus the rounding_adjustment is the actual payment amount that the customer made for the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. rounding_adjustment number20_4 0 1 The rounding adjustment for this order. It can be positive or negative. This amount plus the paid_amount is the actual payment amount that the customer made for the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cst:CustomerDesc * 0 1 The linked customer for this order. NA NA NA NA NA NA gift_receipt_assigned gift_receipt_assigned 1 1 A boolean flag indicating if a gift receipt is assigned to this order. The possible values are "Y" or "N". TR_RTL FL_RCP_GF_TRN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. default_gift_registry_id varchar214 0 1 The default gift registry id of the order if there is one. TR_RTL ID_REGISTRY RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. age_restricted_dob xs:dateTime 0 1 The birthday of the customer if the order has restrictive items. TR_RTL DT_AG_RST_DOB RIB or/and RSB or/and RSL Date No The date of birth of the Customer. The Transaction needs to preserve Date of Birth when Item age restriction is in effect. create_timestamp xs:dateTime 1 1 The order creation timestamp. TR_OR_ORD TS_MDF_ORD RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. update_timestamp xs:dateTime 1 1 The order update timestamp. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. itm:CustOrdItmColDesc * 0 1 A collection of order items. NA NA NA NA NA NA ful:CustOrdFulColDesc * 0 1 A collection of order fulfillment details. A fulfullment detail defines how a group of items will be fulfilled: in store pick up or ship. NA NA NA NA NA NA del:CustOrdDelColDesc * 0 1 A collection of order delivery records. NA NA NA NA NA NA pay:PaymentColDesc * 0 1 A collection of order payments. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustomerRef/v1 Version 1.0 Description XSD Structure CustomerRef

XML-Schema Name:CustomerRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustomerRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_id varchar214 1 1 Contains the unique identifier for the customer NA NA RSB NA Yes NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ShipMethodDesc/v1 Version 1.0 Description XSD Structure ShipMethodDesc Carrier CarrierService

XML-Schema Name:ShipMethodDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipMethodDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description seq_no number4 1 1 The mandatory shipping method sequence number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. Carrier * 1 1 Shipping carrier. CarrierService * 1 1 Shipping carrier service such as next day, overnight etc. currency_code varchar23 1 1 ISC currency code for ship price, such as USD and CAD. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes It is used to calculate shipping charge. shipping_charge number20_4 1 1 Shipping charge amount. TR_LTM_SLS_RTN_ORD MO_ORD_TOT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. est_delivery_date xs:dateTime 1 1 Estimate delivery date. TR_ORD_DEL_DTL DC_ORD_DEL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:Carrier Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Carrier in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description code varchar24 1 1 Specify shipping carrier code. TR_ORD_DEL_DTL SHP_CRR_DEL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. txt:LocaleTxtColDesc * 1 1 The shipping carrier descriptions in one or more locales. NA NA NA NA NA NA

XML-Schema Name:CarrierService Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CarrierService in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description code varchar26 1 1 Specify shipping carrier service code. TR_ORD_DEL_DTL SHP_CRR_DEL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. txt:LocaleTxtColDesc * 1 1 The shipping carrier service descriptions in one or more locales. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/GeoAddrDesc/v1 Version 1.0 Description This is a generic address object XSD Structure GeoAddrDesc

XML-Schema Name:GeoAddrDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for GeoAddrDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description address_alias varchar2120 0 1 Contains the alias for this address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_1 varchar2240 1 1 Contains Address Line 1. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_2 varchar2240 0 1 Contains Address Line 2. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_3 varchar2240 0 1 Contains Address Line 3. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_4 varchar2240 0 1 Contains Address Line 4. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_5 varchar2240 0 1 Contains Address Line 5. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. city varchar2120 0 1 Contains the city where the address is located. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. county varchar2250 0 1 County where this address is located Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. state_code varchar23 0 1 Contains the postal abbreviation for the state, province or territory in which the address is located. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. state_name varchar2120 0 1 Indicates the state, province or territory name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. country_code varchar23 0 1 Contains the postal abbreviation of the country in which the address is located Fill application table name. Fill table column name. RIB or/and RSB or/and RSL 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 or/and RSL Fill column length. Yes Fill this description. postal_code varchar230 0 1 Contains the postal code for the address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL 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 or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderPicVo/v1 Version 1.0 Description XSD Structure CustOrderPicVo

XML-Schema Name:CustOrderPicVo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderPicVo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_id varchar248 1 1 The customer order id 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 0 1 The currency ISO code of the paid amount Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_amount number20_4 0 1 The additional amount picked up for the order in this transaction. This amount is always positive. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_amount number20_4 0 1 The additional amount cancelled for the order in this transaction. This amount is always positive. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_discount_amount number20_4 0 1 The discount amount applied to order items picked up in this transaction. This amount is always positive. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_discount_amount number20_4 0 1 The discount amount applied to order items cancelled in this transaction. This amount is always positive. 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 0 1 The tax amount applied to order items picked up in this transaction. This amount is always positive. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_tax_amount number20_4 0 1 The tax amount applied to order items cancelled in this transaction. This amount is always positive. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items picked up in this transaction. This amount is always positive. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items cancelled in this transaction. This amount is always positive. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. paid_amount number20_4 0 1 The additional amount paid for the order in this transaction. This amount can be negative if it contains refunds for cancelled order items.This amount plus the rounding_adjustment is the actual additional payment amount that the customer made for the order in this transaction. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. rounding_adjustment number20_4 0 1 The rounding adjustment in this transaction. It can be positive or negative. This amount plus the paid_amount is the actual additional payment amount that the customer made for the order in this transaction. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. update_timestamp xs:dateTime 1 1 The order update timestamp Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. itm:CustOrdItmPkColVo * 1 1 A collection of order items picked up or cancelled.. NA NA NA NA NA NA del:CustOrdDelDesc * 1 1 Delivery information of the order items picked up or cancelled.. NA NA NA NA NA NA pay:PaymentColDesc * 0 1 A collection of order payments to add to the order. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdDtl/v1 Version 1.0 Description This object is used to communicate item details related to a customer order fulfillment request from OMS to RMS and SIM. XSD Structure FulfilOrdDtl

XML-Schema Name:FulfilOrdDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. order_qty_suom number12_4 1 1 Indicates the quantity of the item ordered by the customer in item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. standard_uom varchar24 1 1 Indicates item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. substitute_ind varchar21 1 1 Indicates if substitutes are allowed on a customer order. This will only be used by orders passed to SIM. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_retail number20_4 0 1 Indicates the unit sales retail of item on the customer order. This will only be used by Brazil orders in case of Warehouse Fulfillment or vendor sourced POs shipped directly to the customer. It is needed for Sales NF generation. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. retail_curr varchar23 0 1 Indicates currency of unit retail and total retail. This will only be used by Brazil orders in case of Warehouse Fulfillment or vendor sourced POs shipped directly to the customer. It is needed for Sales NF generation. 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 Used to indicate any special instructions for the item, such as services (monograms, engrave, etc). 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdColRef/v1 Version 1.0 Description This object is used to communicate customer order fulfillment cancellation requests from OMS to RMS and SIM. XSD Structure FulfilOrdColRef FulfilOrdRef FulfilOrdDtlRef

XML-Schema Name:FulfilOrdColRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdColRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description collection_size number4 1 1 Number of items in the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdRef:FulfilOrdRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_no varchar248 1 1 Holds the master customer order number from OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_type source_loc_type 0 1 This would be either 'SU' for supplier, 'ST' for store, or 'WH' for warehouse. This would only be populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_id number10 0 1 Indicates the supplier, store or warehouse number associated with sourcing the customer order. Only populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_id number10 1 1 Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdDtlRef:FulfilOrdDtlRef * 1 unbounded Indicates the customer order fulfillment cancellation detail. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdDtlRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDtlRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancel_qty_suom number12_4 1 1 Indicates the quantity that should be cancelled from the order in item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. standard_uom varchar24 1 1 Indicates item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RetStoreLangDesc/v1 Version 1.0 Description XSD Structure RetStoreLangDesc

XML-Schema Name:RetStoreLangDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetStoreLangDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_locale varchar2255 0 1 Contains the language information used at the store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. operator_locale varchar2255 0 1 Operator language. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_locale varchar2255 0 1 Receipt language. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderColRef/v1 Version 1.0 Description XSD Structure CustOrderColRef

XML-Schema Name:CustOrderColRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderColRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ref:CustOrderRef * 0 unbounded A collection of customer order references. NA NA NA NA NA NA collection_size number4 1 1 The collection size. 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:14.0.0

(Point Of Service)

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

XML-Schema Name:PendRtrnCtnRcpt Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PendRtrnCtnRcpt in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description physical_wh number10 1 1 Describes the physical wearhouse id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. rma_nbr varchar220 0 1 Specifies the RMA number of the pending return. 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 0 1 Specifies the customer order number of the pending return. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. receipt_date xs:dateTime 1 1 Timestamp of pending container receipt. 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 Pending return container_id 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/PendRtrnDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure PendRtrnDesc PendRtrnDtlDesc PendRtrnDtlRsnCodeDesc PendRtrnDtlActCodeDesc

XML-Schema Name:PendRtrnDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PendRtrnDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description physical_wh number10 1 1 Physical warehouse dest id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. rma_nbr varchar220 0 1 Specifies the RMA nbr for electronic returns. Null for Non electronic returns. 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 0 1 Specifies the cust_order_nbr non electronic returns. Null for electronic returns. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. special_instructions varchar2250 0 1 Specifies special instructions for returned inventory. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. expected_receipt xs:dateTime 0 1 Specifies the expecetd receipt date Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. PendRtrnDtlDesc * 1 unbounded Placeholder for Pending_return item level details.

XML-Schema Name:PendRtrnDtlDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PendRtrnDtlDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item_id varchar225 1 1 Specifies the returned item_id Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. line_item_nbr number3 1 1 Specifies the line_nbr of the return used to identify unique return details. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. expected_unit_qty number12_4 0 1 Specifies the expected quantity of the returned line_item_nbr Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. PendRtrnDtlRsnCodeDesc * 1 unbounded Placeholder for reason_code details. PendRtrnDtlActCodeDesc * 1 unbounded Placeholder for action_code details

XML-Schema Name:PendRtrnDtlRsnCodeDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PendRtrnDtlRsnCodeDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description reason_code varchar26 0 1 Specifies the reason_code Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. description varchar2250 0 1 Specifies the reason_code description 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:PendRtrnDtlActCodeDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PendRtrnDtlActCodeDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description action_code varchar26 0 1 Specifies the action_code assigned during processing of the return. 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 0 1 Specifies the item quantity processed for return Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. disposition_code varchar26 0 1 Specifies the dispositionassigned during processing of the return. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. sellable varchar21 0 1 Specifies if an item is sellable or not. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. comments varchar21000 0 1 Comments 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:14.0.0

(Point Of Service)

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

XML-Schema Name:ShipOptionCriVo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipOptionCriVo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description addr:GeoAddrDesc * 1 1 Contains the shipping destination address. NA NA NA NA NA NA itm:ShipItemColDesc * 1 1 Contains a collection of shipping items. NA NA NA NA NA NA lcl:LocaleColDesc * 1 1 Specifies the locales for the shipping options results. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderRtnVo/v1 Version 1.0 Description XSD Structure CustOrderRtnVo

XML-Schema Name:CustOrderRtnVo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderRtnVo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_id varchar248 1 1 The customer order id 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 0 1 The currency ISO code of the paid amount Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_amount number20_4 0 1 The additional amount returned or return voided for the order in this transaction. It can be positive or negative. It is positive for return, and negative for return voided. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_discount_amount number20_4 0 1 The discount amount applied to order items returned or return voided in this transaction. It can be positive or negative. It is positive for return, and negative for return voided. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_tax_amount number20_4 0 1 The tax amount applied to order items returned or return voided in this transaction. It can be positive or negative. It is positive for return, and negative for return voided. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items returned or return voided in this transaction. It can be positive or negative. It is positive for return, and negative for return voided. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. update_timestamp xs:dateTime 1 1 The order update timestamp Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. itm:CustOrdItmRtColVo * 1 1 A collection of order items to update incrementally. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrdDelColDesc/v1 Version 1.0 Description XSD Structure CustOrdDelColDesc

XML-Schema Name:CustOrdDelColDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrdDelColDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description del:CustOrdDelDesc * 1 unbounded A delivery record. NA NA NA NA NA NA collection_size number4 1 1 The number of CustOrdDelDesc objects. NA NA NA NA Yes NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/PromoLineDesc/v1 Version 1.0 Description XSD Structure PromoLineDesc

XML-Schema Name:PromoLineDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PromoLineDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API 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. unit_discount_amount number20_4 1 1 The unit discount amount of the order item due to the price promotion Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_name varchar2250 0 1 The promotion name in its original receipt locale. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_component_detail_id number22 0 1 The promotion component detail id in MOM. CO_MDFR_RTL_PRC ID_PRM_CMP_DTL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_component_id number22 0 1 The promotion component id in MOM. CO_MDFR_RTL_PRC ID_PRM_CMP RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_id number22 0 1 The promotion id in MOM. CO_MDFR_RTL_PRC ID_PRM RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ASNInDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ASNInDesc ASNInPO ASNInCtn ASNInItem ASNInItem

XML-Schema Name:ASNInDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description schedule_nbr number8 0 1 Contains the Schedule identifier number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. auto_receive varchar21 0 1 Contains the flag to enable auto receiving at SIM. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_location varchar210 0 1 Contains the location that the shipment will be delivered to. RWMS does not utilize this field. 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 varchar21 0 1 This field contains the location type of the to_location field. Valid values are 'S' = store, 'E' = finisher, and 'W' = warehouse. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_store_type varchar21 0 1 Indicates the store type of the to_location. This will only be populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_stockholding_ind varchar21 0 1 Indicates if the to_location is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. RWMS does not utilize this. field. 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. RWMS does not utilize this field. 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 varchar21 0 1 This field contains the location type of the from_location field. Valid values are 'S' = store and 'W' = warehouse. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_store_type varchar21 0 1 Indicates the store type of the from_location. This will only be populated if from_location is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_stockholding_ind varchar21 0 1 Indicates if the from_location is stockholding or not. Only populated if from_location is 'S'. Valid values are: 'Y' = yes, 'N' = no. RWMS does not utilize this field. 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 1 1 Holds the advance shipping notice 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 1 1 This field is used to determine the ship origin. If asn_type is 'C', ship_origin will be set to '6' (ASN UCC-128) upon insert to the SHIPMENT table. Otherwise, SHIP_ORIGIN is defaulted to '0' (ASN Shipment). 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 1 1 Description is not available. 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 0 1 Holds the transaction sequence number on the input message from the receiving PO or transfer 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 1 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 isused 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 Not used in RWMS. 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 Not used in RWMS. 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 in RWMS. 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 in RWMS. 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 in RWMS. 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 Not used in RWMS. 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 Not used in RWMS. 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 in RWMS. 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 Not used in RWMS. 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 in RWMS. 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 in RWMS. 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. vendor_nbr varchar210 1 1 Contains the supplier who will provide the merchandise specified in the order. This element is used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The order number must be in the table ORDHEAD, in either the ORDER_NO column or VENDOR_ORDER_NO column. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_pay_method varchar22 0 1 Indicates the payment terms for freight charges associated with theorder. Used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The ship_pay_method in the message must match the value of the order's SHIP_PAY_METHOD in RMS (ORDHEAD table.) If the message field is blank, the ORDHEAD value must be NULL. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ASNInPO * 1 unbounded Description is not available. comments varchar22000 0 1 Contains any 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:ASNInPO Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInPO in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description po_nbr varchar212 1 1 Identifies the order number which relates to the goods delivered in the shipment. Validated against theORDHEAD table, and also the SHIPMENT table if the message applies to an existing shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. doc_type varchar21 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. not_after_date xs:dateTime 0 1 Contains the last date that delivery of the order will be accepted. 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 Contains any 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. ASNInCtn * 0 unbounded Description is not available. ASNInItem * 0 unbounded Description is not available.

XML-Schema Name:ASNInCtn Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInCtn in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description final_location varchar210 1 1 This will be the final destination of the carton. For a cross-dock order this will be the allocation location, otherwise it will be the direct to order location. 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 Holds the UCC-128 carton number. 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 Description is not available. 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 Description is not available. 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 Description is not available. 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 Description is not available. 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 Description is not available. 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 Description is not available. 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 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. carrier_shipment_nbr varchar2120 0 1 This field represents the shipment number that manifest systems use to group multi-container shipments for a carrier. Typically a 1 of 4 type message. 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 number12_4 0 1 Description is not available. 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 in RWMS Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ASNInItem * 1 unbounded Description is not available. comments varchar22000 0 1 Contains any comments about the shipment container. 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:ASNInItem Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInItem in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description final_location varchar210 1 1 Required if the order's pre_mark_ind is 'Y'. Validated against the ALLOC_DETAIL table. There needs to be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final_location. 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 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. 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 ASN 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 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. vpn varchar230 0 1 Used to find the item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. 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 in RWMS. 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 in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in themessage. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this 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. consumer_direct varchar21 0 1 This is a Y or N indicator to inform the consuming application if the distro is for a consmer direct order or not. 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 0 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 0 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. distro_doc_type varchar21 0 1 Valid Document Type 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 Description is not available. 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 Contains any comment about the item in 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:ASNInItem Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInItem in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description final_location varchar210 1 1 Required if the order's pre_mark_ind is 'Y'. Validated against the ALLOC_DETAIL table. There needs to be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final_location. 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 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. 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 ASN 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 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. vpn varchar230 0 1 Used to find the item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. 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 in RWMS. 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 in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in themessage. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this 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. consumer_direct varchar21 0 1 This is a Y or N indicator to inform the consuming application if the distro is for a consmer direct order or not. 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 0 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 0 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. distro_doc_type varchar21 0 1 Valid Document Type 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 Description is not available. 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 Contains any comment about the item in the shipment. 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:14.0.0

(Point Of Service)

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

XML-Schema Name:ShipItemColDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipItemColDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description itm:ShipItemDesc * 1 unbounded Shipping item description. NA NA NA NA NA NA collection_size number4 1 1 The number of shipping items. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdColDesc/v1 Version 1.0 Description This object is used to communicate customer order fulfillment details from OMS to RMS and SIM. XSD Structure FulfilOrdColDesc FulfilOrdDesc FulfilOrdCustDesc LocOfFulfilOrdCustDesc FulfilOrdDtl

XML-Schema Name:FulfilOrdColDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdColDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description collection_size number4 1 1 Number of items in the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdDesc:FulfilOrdDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_no varchar248 1 1 Holds the master customer order number from OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_type source_loc_type 0 1 This would be either 'SU' for supplier, 'ST' for store, or 'WH' for warehouse. This would only be populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_id number10 0 1 Indicates the supplier, store or warehouse number associated with sourcing the customer order. Only populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_id number10 1 1 Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. partial_delivery_ind yes_no_ind 1 1 Indicates if the order can be picked and shipped partially ('N') or if it should be shipped only when complete ('Y'). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. delivery_type delivery_type 0 1 Indicates the fulfillment method - ship to customer or store pickup. Expected values are 'S' (ship direct) and 'C' (customer pickup). 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 Indicates the carrier the order is to be shipped with, if specified on the order. 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 Indicates the method that was selected for shipping by the customer placing the order (e.g. Standard Shipping, Overnight, etc.). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. consumer_delivery_date xs:dateTime 1 1 Indicates the desired date the delivery is required by the customer. This will be the GMT time. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. consumer_delivery_time xs:dateTime 0 1 Indicates the desired time the delivery is required by the customer. This will be the GMT time. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. delivery_charges number20_4 0 1 Contains the delivery charges on drop ship. Mostly relevant for Brazil. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. delivery_charges_curr varchar23 0 1 Contains the currency of the delivery charges. 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 Any comments sent by OMS about the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdCustDesc:FulfilOrdCustDesc * 0 1 Referenced object for customer information related to the order. NA NA NA NA NA NA FulfilOrdDtl:FulfilOrdDtl * 1 unbounded References a collection of customer order fulfillment details. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdCustDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCustDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_no varchar214 0 1 Indicates the number that uniquely identifies the customer in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_first_name varchar2120 0 1 Contains the first name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phonetic_first varchar2120 0 1 Contains the phonetic first name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_last_name varchar2120 0 1 Contains the last name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phonetic_last varchar2120 0 1 Contains the phonetic last name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_preferred_name varchar2120 0 1 Contains the preferred name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_company_name varchar2120 0 1 Contains the company name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add1 varchar2240 0 1 First line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add2 varchar2240 0 1 Second line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add3 varchar2240 0 1 Third line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_county varchar2250 0 1 County portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_city varchar2120 0 1 City portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_state varchar23 0 1 State portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_country_id varchar23 0 1 Country portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_post varchar230 0 1 Postal code portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the delivery country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phone varchar220 0 1 Contains the delivery phone number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_first_name varchar2120 0 1 Contains the first name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_first varchar2120 0 1 Contains the phonetic first name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_last_name varchar2120 0 1 Contains the last name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_last varchar2120 0 1 Contains the phonetic last name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_preferred_name varchar2120 0 1 Contains the preferred name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_company_name varchar2120 0 1 Contains the company name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add1 varchar2240 0 1 First line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add2 varchar2240 0 1 Second line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add3 varchar2240 0 1 Third line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_county varchar2250 0 1 County portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_city varchar2120 0 1 City portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_state varchar23 0 1 State portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_country_id varchar23 0 1 Country portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_post varchar230 0 1 Postal code portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the billing country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phone varchar220 0 1 Contains the billing phone number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. LocOfFulfilOrdCustDesc:LocOfFulfilOrdCustDesc * 0 1 References a collection of localization extension. NA NA NA NA NA NA

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

XML-Schema Name:FulfilOrdDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. order_qty_suom number12_4 1 1 Indicates the quantity of the item ordered by the customer in item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. standard_uom varchar24 1 1 Indicates item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. substitute_ind varchar21 1 1 Indicates if substitutes are allowed on a customer order. This will only be used by orders passed to SIM. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_retail number20_4 0 1 Indicates the unit sales retail of item on the customer order. This will only be used by Brazil orders in case of Warehouse Fulfillment or vendor sourced POs shipped directly to the customer. It is needed for Sales NF generation. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. retail_curr varchar23 0 1 Indicates currency of unit retail and total retail. This will only be used by Brazil orders in case of Warehouse Fulfillment or vendor sourced POs shipped directly to the customer. It is needed for Sales NF generation. 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 Used to indicate any special instructions for the item, such as services (monograms, engrave, etc). 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RetResultDesc/v1 Version 1.0 Description XSD Structure RetResultDesc ReturnResult OfflineRequest RetAuthDesc ReturnTransactionID TransIdDesc ItemReturnResult RetItemIdentDesc OverrideInfo OriginalTransactionID TransIdDesc ReturnTender RetTendTypeDesc RetMsgExtDesc RetMsgExtDesc

XML-Schema Name:RetResultDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetResultDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ReturnResult * 1 1 This schema defines the Return Result message. This is sent from the the Point of Return after the completion of the return.

XML-Schema Name:ReturnResult Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReturnResult in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description return_ticket_id varchar230 0 1 Generated Return ticket ID. RM_RTN_TKT AI_RTN_TKT INTEGER 38 Yes Fill this description. offline_date xs:dateTime 0 1 Offline date if the return is an offline request. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. OfflineRequest * 0 1 Offline Request information. ReturnTransactionID * 0 1 Return Transaction ID. currency_iso_code varchar203 1 1 Currency ISO code. RM_RTN_TKT CD_CNY_ISO VARCHAR 3 Yes The country Code associated with the return. ItemReturnResult * 0 unbounded Item Return Result Information. return_voided xs:boolean 0 1 Flag that determines if the return is voided. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. RetMsgExtDesc:RetMsgExtDesc * 0 1 Return message extensions. NA NA NA NA NA NA

XML-Schema Name:OfflineRequest Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OfflineRequest in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetAuthDesc:RetAuthDesc * 1 1 Offline Return Request information. NA NA NA NA NA NA

XML-Schema Name:RetAuthDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetAuthDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ReturnRequest * 1 1 Return Request Information.

XML-Schema Name:ReturnTransactionID Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReturnTransactionID in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description TransIdDesc:TransIdDesc * 1 1 Return transaction id information. NA NA NA NA NA NA

XML-Schema Name:TransIdDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TransIdDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_id varchar205 1 1 Store ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. workstation_id varchar203 1 1 Workstation or Register id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. sequence_number number15 1 1 Transaction Sequence number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. business_date xs:dateTime 1 1 Business Date. 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:ItemReturnResult Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemReturnResult in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetItemIdentDesc:RetItemIdentDesc * 1 1 Item information. NA NA NA NA NA NA quantity_returned number11 1 1 Response approve deny code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. final_result_code final_result_code 0 1 Final result code. RM_LTM_RTN_TKT DE_FNL_RSLT VARCHAR 15 Yes The final result of the transaction. Some results from Returns Management may be conditional so the manager of the store can make the final decision. OverrideInfo * 0 1 Override information. OriginalTransactionID * 0 1 Original Transaction ID information. ReturnTender * 0 1 Return tender information. RetMsgExtDesc:RetMsgExtDesc * 0 1 Return message extensions. NA NA NA NA NA NA

XML-Schema Name:RetItemIdentDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetItemIdentDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item_id varchar214 1 1 Item Id. AS_ITM ID_ITM VARCHAR 14 Yes A unique system identifier for an Item of merchandise or service. item_description varchar2250 0 1 Item Description. AS_ITM DE_ITM VARCHAR 250 Yes The description of the Item. Used for displaying the item description on the screen. Column has been marked for deprecation - moved to I18N table. item_type varchar220 0 1 Item Type. AS_ITM TY_ITM VARCHAR (0) Unknown, (1) Stock Item, (2) Service Item, (3) Store Coupon. Yes A code denoting the type of the Item. Valid values are

XML-Schema Name:OverrideInfo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OverrideInfo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description manager_id varchar214 1 1 Manager Id. RM_LTM_RTN_TKT ID_OPR_OVRD VARCHAR 10 Yes The Employee ID of the Manager who performed the override override_obtained xs:boolean 1 1 Flag to determine if override is obtained. RM_LTM_RTN_TKT FL_OVRD_RSPS CHAR 1 Yes A flag denoting if the response was overridden. tender_override xs:boolean 1 1 Flag to determine if tender is override. RM_LTM_RTN_TKT FL_TND_OVRD CHAR 1 Yes A flag indicating whether or not the original tender was overridden

XML-Schema Name:OriginalTransactionID Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OriginalTransactionID in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description TransIdDesc:TransIdDesc * 1 1 Original transaction id information. NA NA NA NA NA NA

XML-Schema Name:TransIdDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TransIdDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_id varchar205 1 1 Store ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. workstation_id varchar203 1 1 Workstation or Register id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. sequence_number number15 1 1 Transaction Sequence number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. business_date xs:dateTime 1 1 Business Date. 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:ReturnTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReturnTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetTendTypeDesc:RetTendTypeDesc * 1 unbounded Tender type information. NA NA NA NA NA NA

XML-Schema Name:RetTendTypeDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetTendTypeDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description type varchar220 1 1 Tender Type. RM_LTM_RTN_TND TY_TND VARCHAR 20 Yes The type of tender. amount number15 0 1 Tender amount. RM_LTM_RTN_TND MO_TY_TND DECIMAL 13 Yes The monetary value for this tender type. amount_in_base_cur number15 0 1 Tender amount in base currency. Not required to pass this data. Calculated at the RM application using the base currency conversion. RM_LTM_RTN_TND MO_TY_TND_ORGL DECIMAL 13 Yes this field will contain the amount in the original currency prior to the currency change,if return is done in a different currency. card_number varchar220 0 1 Masked card number details. PA_CT ID_MSK_ACNT_CRD VARCHAR 20 Yes Masked card number

XML-Schema Name:RetMsgExtDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetMsgExtDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ExtensionEntry * 0 unbounded Return Message Extensions.

XML-Schema Name:RetMsgExtDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetMsgExtDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ExtensionEntry * 0 unbounded Return Message Extensions.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

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

XML-Schema Name:ShipOptionDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ShipOptionDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description seq_no number4 1 1 The mandatory shipping option sequence number Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. addr:GeoAddrDesc * 0 1 The shipping destination address NA NA NA NA NA NA mth:ShipMethodColDesc * 1 1 Shipping method collection description. NA NA NA NA NA NA ItemAssignments * 1 1 A list of shipping items assigned to this shipping option.

XML-Schema Name:ItemAssignments Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemAssignments in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description seq_no number4 1 unbounded Ship item sequence numbers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. collection_size number4 1 1 The collection size. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/ContactDesc/v1 Version 1.0 Description XSD Structure ContactDesc Phones Emails

XML-Schema Name:ContactDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ContactDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description first_name varchar2120 0 1 Contact first name. ORPOS Usage - For regular customers that are fed into ORPOS from an external customer system, if this field is not populated, ORPOS will prompt for a value. For Customers created by ORPOS, this field needs to be populated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. phonetic_first varchar2120 0 1 Phonetic first name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. last_name varchar2120 0 1 Contact last name. ORPOS Usage - For regular customers that are fed into ORPOS, if this field is not populated, ORPOS will prompt for a value. For Customers created by ORPOS, this field needs to be populated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. phonetic_last varchar2120 0 1 Phonetic last name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. middle_name varchar2120 0 1 Contact middle name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. preferred_name varchar2120 0 1 Contact preferred name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. full_name varchar2250 0 1 Contains the full name for a regular customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. name_prefix varchar2120 0 1 A Title placed before a name. Example Ms, Mr Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. name_suffix varchar2120 0 1 The name suffix, can be academic, honorary, professional or generational. Example: PhD, MBA, PMP, Sr, Jr, JDA Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. company_name varchar2250 0 1 Contains the name of a business/ organization. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. Phones * 0 1 Contains a collection of phone numbers Emails * 0 1 Contains a collection of email addresses.

XML-Schema Name:Phones Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Phones in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description PhoneDesc:PhoneDesc * 1 unbounded Contact Phone. NA NA NA NA NA NA

XML-Schema Name:Emails Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Emails in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description EmailDesc:EmailDesc * 1 unbounded Contact Email. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

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

XML-Schema Name:SOStatusDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for SOStatusDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description dc_dest_id varchar210 1 1 Contains the location number of the stock order source location. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. loc_type varchar21 1 1 Type of location in the dc_dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the dc_dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the dc_dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. distro_nbr varchar212 0 1 Contains the stock order number. This is either the transfer or allocation number in RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. distro_document_type varchar21 1 1 Specifies whether the stock order status pertains to an allocation 'A', or transfer 'T'. Types 'D'C Created Stock Order,'C'ustomer Order, and 'V'irtual Distro are also valid document types but will be ignored by the RMS API. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. SOStatusDtl * 1 unbounded Description is not available. 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 or/and RSL 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 or/and RSL Fill column length. Yes Fill this description. inventory_type varchar26 0 1 This field indicates if a transfer is made from the available or unavailable inventory. 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 0 1 For a stock order associated with a customer order, this field holds the master customer order number from OMS. 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 0 1 For a stock order associated with a customer order, this field holds the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. 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:SOStatusDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for SOStatusDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description dest_id varchar210 1 1 Contains the location number of the stock order receiving location. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. loc_type varchar21 1 1 Type of location in the dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this 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. original_item_id varchar225 0 1 The ID of the item being replaced. Populated only when this record is for a substitute item on a customer order. 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 number3 1 1 Derived as ROWNUM. 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 The difference beween the number of ITEM units shipped versus the receiving count for the given ITEM. This is subtracted from the document-line-item-unit-count to yield an over/under variance between what a supplier said was shipped and what was counted and received at by the store's staff. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. status varchar22 1 1 The status of the stock order. Valid values are: 'DS' - Details Selected, 'DU' - Details Un-Selected, 'NI' - Line Cancellation, 'PP' - Distributed, 'PU' - Un-Distributed, 'RS' - Return To Stock, 'EX' - Expired, 'SR' - Store Reassign, 'SC' - Store Cancellation. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. user_id varchar230 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. updated_date xs:dateTime 0 1 Description is not available. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdCfmDesc/v1 Version 1.0 Description This object is used to communicate customer order confirmation and detail back to OMS from RMS and SIM. This object is also used by SIM to confirm that an order can be picked up for store pickup fulfillment. XSD Structure FulfilOrdCfmDesc FulfilOrdCfmDtl

XML-Schema Name:FulfilOrdCfmDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_no varchar248 1 1 Holds the master customer order number from OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_type confirm_type 1 1 Contains the confirmation type. 'P' - Order Partially Created; 'X' - Order Could not be Created. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_no number12 0 1 Contains the PO or Transfer number in RMS related to the fulfillment order line. Required if fulfillment status is 'P'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdCfmDtl:FulfilOrdCfmDtl * 0 unbounded References a collection of customer order confirmation item details. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdCfmDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_qty number12_4 1 1 Indicates the quantity of the item that can be sourced or fulfilled on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_qty_uom varchar24 1 1 Indicates the unit of measure of the confirmation quantity. 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:14.0.0

(Point Of Service)

Application Point Of Service 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:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvocationSuccess in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS'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:14.0.0

(Point Of Service)

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

XML-Schema Name:PendRtrnRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PendRtrnRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description physical_wh number10 1 1 Physical warehouse dest id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. rma_nbr varchar220 0 1 Specifies the RMA nbr for electronic returns. Null for Non electronic returns. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. line_item_nbr number3 1 1 Specifies the line_nbr of the return used to identify unique return details. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. reason_code varchar26 0 1 Specifies the reason_code 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/TransIdDesc/v1 Version 1.0 Description XSD Structure TransIdDesc

XML-Schema Name:TransIdDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TransIdDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_id varchar205 1 1 Store ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. workstation_id varchar203 1 1 Workstation or Register id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. sequence_number number15 1 1 Transaction Sequence number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. business_date xs:dateTime 1 1 Business Date. 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:14.0.0

(Point Of Service)

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

XML-Schema Name:ASNInRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description to_location varchar210 1 1 This field 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. to_loc_type varchar21 0 1 This field contains the location type of the to_location field. Valid values are 'S' = store, 'E' = finisher, and 'W' = warehouse. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_store_type varchar21 0 1 Indicates the store type of the to_location. This will only be populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. to_stockholding_ind varchar21 0 1 Indicates if the to_location is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. RWMS does not utilize this field. 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 fromwhich 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. from_loc_type varchar21 0 1 This field contains the location type of the from_location field. Valid values are 'S' = store and 'W' = warehouse. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_store_type varchar21 0 1 Indicates the store type of the from_location. This will only be populated if from_location is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. RWMS does not utilize this field. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. from_stockholding_ind varchar21 0 1 Indicates if the from_location is stockholding or not. Only populated if from_location is 'S'. Valid values are: 'Y' = yes, 'N' = no. RWMS does not utilize this field. 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 1 1 Holds the advance shipping notice number associated with a shipment to be deleted. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/DiscntLineDesc/v1 Version 1.0 Description XSD Structure DiscntLineDesc

XML-Schema Name:DiscntLineDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiscntLineDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description line_no number4 1 1 A number that uniquely identifies a discount line within an order line item. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. accounting_method enum_discount_acct_method 1 1 A enum indicating how the discount will be accounted for. CO_MDFR_RTL_PRC DP_LDG_STK_MDFR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. advanced_pricing_rule_flag flag 1 1 A boolean flag indicating if the discount isautomatically applied to the order item as the result of an advanced pricing rule, or manually applied by the operator. The possible values are "Y" or "N". CO_MDFR_RTL_PRC FL_DSC_ADVN_PRC RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. assignment_basis enum_discount_assign_basis 1 1 A enum indicating the basis the discount is assigned to the order item. CO_MDFR_RTL_PRC CD_BAS_PRDV RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. damage_discount_flag flag 1 1 A boolean flag indicating if the discount is applied as the result of item damage. The possible values are "Y" or "N". CO_MDFR_RTL_PRC FL_DSC_DMG 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. discount_amount number20_4 1 1 The discount amount for the order item. CO_MDFR_RTL_PRC_ORD/TR_MDFR_SLS_RTN_PRC_ORD MO_DSC_TOT RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. completed_discount_amount number20_4 1 1 The discount amount applied to item units that have been picked up or shipped. This is to support partial pickup/ship of an order item. CO_MDFR_RTL_PRC_ORD/TR_MDFR_SLS_RTN_PRC_ORD MO_DSC_COMPL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancelled_discount_amount number20_4 1 1 The discount amount applied to item units that have been cancelled. This is to support partial cancellation of an order item. CO_MDFR_RTL_PRC_ORD/TR_MDFR_SLS_RTN_PRC_ORD MO_DSC_CANCL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. returned_discount_amount number20_4 1 1 The discount amount applied to item units that have been returned. This is to support partial return of an order item. CO_MDFR_RTL_PRC_ORD/TR_MDFR_SLS_RTN_PRC_ORD MO_DSC_RTRN RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_discount_amount number20_4 0 1 The unit discount amount for each order item unit. It is different from the discount amount if the order item has multiple quantities. CO_MDFR_RTL_PRC MO_MDFR_RT_PRC RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_employee_id varchar210 0 1 The employee id captured if the discount is an employee based discount CO_MDFR_RTL_PRC ID_DSC_EM RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_method enum_discount_method 1 1 A enum indicating if the discount is percentage based or amount based. Fill application table name. CD_MTH_PRDV RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_rate number5_2 0 1 The discount rate if it is a percentage based discount. CO_MDFR_RTL_PRC PE_MDFR_RT_PRC RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_rule_id varchar222 0 1 The id of the discount rule that is applied to the order item. CO_MDFR_RTL_PRC ID_RU_MDFR RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_scope enum_discount_scope 1 1 A enum indicating if the discount is applied at the entire order level or at the order item level. CO_MDFR_RTL_PRC CD_SCP_PRDV RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. included_in_bestdeal_flag flag 1 1 A boolean flag indicating if the discount is applied because it is the best deal among all the discounts that the order item is eligible of.The possible values are "Y" or "N". CO_MDFR_RTL_PRC FL_PCD_DL_ADVN_APLY RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. discount_reason_code varchar220 0 1 The reason code indicating why this discount is applied to the order item. CO_MDFR_RTL_PRC RC_MDFR_RT_PRC RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. store_coupon_id varchar2255 0 1 A store coupon id that is associated with the discount. TR_LTM_DSC ID_DSC_REF RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_component_detail_id number22 0 1 The promotion component detail id in MOM for this discount. CO_MDFR_RTL_PRC ID_PRM_CMP_DTL RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_component_id number22 0 1 The promotion component id in MOM for this discount. CO_MDFR_RTL_PRC ID_PRM_CMP RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. promotion_id number22 0 1 The promotion id in MOM for this discount CO_MDFR_RTL_PRC ID_PRM RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdDesc/v1 Version 1.0 Description This object is used to communicate customer order fulfillment details from OMS to RMS and SIM. XSD Structure FulfilOrdDesc FulfilOrdCustDesc LocOfFulfilOrdCustDesc FulfilOrdDtl

XML-Schema Name:FulfilOrdDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_no varchar248 1 1 Holds the master customer order number from OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_type source_loc_type 0 1 This would be either 'SU' for supplier, 'ST' for store, or 'WH' for warehouse. This would only be populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_id number10 0 1 Indicates the supplier, store or warehouse number associated with sourcing the customer order. Only populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_id number10 1 1 Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. partial_delivery_ind yes_no_ind 1 1 Indicates if the order can be picked and shipped partially ('N') or if it should be shipped only when complete ('Y'). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. delivery_type delivery_type 0 1 Indicates the fulfillment method - ship to customer or store pickup. Expected values are 'S' (ship direct) and 'C' (customer pickup). 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 Indicates the carrier the order is to be shipped with, if specified on the order. 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 Indicates the method that was selected for shipping by the customer placing the order (e.g. Standard Shipping, Overnight, etc.). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. consumer_delivery_date xs:dateTime 1 1 Indicates the desired date the delivery is required by the customer. This will be the GMT time. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. consumer_delivery_time xs:dateTime 0 1 Indicates the desired time the delivery is required by the customer. This will be the GMT time. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. delivery_charges number20_4 0 1 Contains the delivery charges on drop ship. Mostly relevant for Brazil. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. delivery_charges_curr varchar23 0 1 Contains the currency of the delivery charges. 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 Any comments sent by OMS about the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdCustDesc:FulfilOrdCustDesc * 0 1 Referenced object for customer information related to the order. NA NA NA NA NA NA FulfilOrdDtl:FulfilOrdDtl * 1 unbounded References a collection of customer order fulfillment details. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdCustDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCustDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_no varchar214 0 1 Indicates the number that uniquely identifies the customer in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_first_name varchar2120 0 1 Contains the first name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phonetic_first varchar2120 0 1 Contains the phonetic first name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_last_name varchar2120 0 1 Contains the last name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phonetic_last varchar2120 0 1 Contains the phonetic last name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_preferred_name varchar2120 0 1 Contains the preferred name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_company_name varchar2120 0 1 Contains the company name for the delivery address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add1 varchar2240 0 1 First line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add2 varchar2240 0 1 Second line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_add3 varchar2240 0 1 Third line of the delivery address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_county varchar2250 0 1 County portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_city varchar2120 0 1 City portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_state varchar23 0 1 State portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_country_id varchar23 0 1 Country portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_post varchar230 0 1 Postal code portion of the delivery address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the delivery country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. deliver_phone varchar220 0 1 Contains the delivery phone number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_first_name varchar2120 0 1 Contains the first name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_first varchar2120 0 1 Contains the phonetic first name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_last_name varchar2120 0 1 Contains the last name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_last varchar2120 0 1 Contains the phonetic last name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_preferred_name varchar2120 0 1 Contains the preferred name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_company_name varchar2120 0 1 Contains the company name for the billing address on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add1 varchar2240 0 1 First line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add2 varchar2240 0 1 Second line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_add3 varchar2240 0 1 Third line of the billing address for the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_county varchar2250 0 1 County portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_city varchar2120 0 1 City portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_state varchar23 0 1 State portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_country_id varchar23 0 1 Country portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_post varchar230 0 1 Postal code portion of the billing address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the billing country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phone varchar220 0 1 Contains the billing phone number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. LocOfFulfilOrdCustDesc:LocOfFulfilOrdCustDesc * 0 1 References a collection of localization extension. NA NA NA NA NA NA

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

XML-Schema Name:FulfilOrdDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. order_qty_suom number12_4 1 1 Indicates the quantity of the item ordered by the customer in item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. standard_uom varchar24 1 1 Indicates item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. substitute_ind varchar21 1 1 Indicates if substitutes are allowed on a customer order. This will only be used by orders passed to SIM. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. unit_retail number20_4 0 1 Indicates the unit sales retail of item on the customer order. This will only be used by Brazil orders in case of Warehouse Fulfillment or vendor sourced POs shipped directly to the customer. It is needed for Sales NF generation. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. retail_curr varchar23 0 1 Indicates currency of unit retail and total retail. This will only be used by Brazil orders in case of Warehouse Fulfillment or vendor sourced POs shipped directly to the customer. It is needed for Sales NF generation. 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 Used to indicate any special instructions for the item, such as services (monograms, engrave, etc). 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustomerDesc/v1 Version 1.0 Description XSD Structure CustomerDesc ContactDesc AddrBook AddrBookEntry GeoAddrDesc ContactDesc CustomerGrpIdLst

XML-Schema Name:CustomerDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustomerDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_id varchar214 1 1 Unique identifier for customer. NA NA RSB NA Yes NA customer_type customer_type 1 1 Contains the customer type: regular customer or business. NA NA RSB NA Yes NA ContactDesc:ContactDesc * 1 1 Contains the contact information for the customer. NA NA NA NA NA NA AddrBook * 0 1 Contains multiple customer addresses. gender_type gender_type 0 1 Contains the customer gender. NA NA RSB NA Yes NA birth_date xs:dateTime 0 1 Contains the customer birth date. NA NA RSB NA Yes NA contact_by_mail flag 1 1 Indicates if the customer wants to be contacted by mail. NA NA RSB NA Yes NA contact_by_phone flag 1 1 Indicates if the customer wants to be contacted by phone. NA NA RSB NA Yes NA contact_by_email flag 1 1 Indicates if the customer wants to be contacted by email. NA NA RSB NA Yes NA receipt_preference receipt_preference 0 1 Contains the customer receipt preference. Customer can opt for printed, or email or both printed and email receipts. NA NA RSB NA Yes NA employee_id varchar210 0 1 Contains the id of the employee that created the customer. NA NA RSB NA Yes NA pricing_group_id number22 0 1 Contains the customer specific pricing group id that the customer is linked to. NA NA RSB NA Yes NA CustomerGrpIdLst * 0 1 Contains a collection of preferred customer discount ids. lcl:LocaleDesc * 0 1 Contains the customer preferred language. NA NA NA NA NA NA tax_id varchar21000 0 1 Contains the federal identifier assigned by a national government. NA NA RSB NA Yes NA tax_certificate varchar2230 0 1 Contains the number provided for sales tax exemption issued separately by the state where doing business. NA NA RSB NA Yes NA reason_code varchar220 0 1 Contains the tax exempt reason code. NA NA RSB NA Yes NA job_title varchar2100 0 1 Contains the job title. NA NA RSB NA Yes NA

XML-Schema Name:ContactDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ContactDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description first_name varchar2120 0 1 Contact first name. ORPOS Usage - For regular customers that are fed into ORPOS from an external customer system, if this field is not populated, ORPOS will prompt for a value. For Customers created by ORPOS, this field needs to be populated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. phonetic_first varchar2120 0 1 Phonetic first name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. last_name varchar2120 0 1 Contact last name. ORPOS Usage - For regular customers that are fed into ORPOS, if this field is not populated, ORPOS will prompt for a value. For Customers created by ORPOS, this field needs to be populated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. phonetic_last varchar2120 0 1 Phonetic last name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. middle_name varchar2120 0 1 Contact middle name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. preferred_name varchar2120 0 1 Contact preferred name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. full_name varchar2250 0 1 Contains the full name for a regular customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. name_prefix varchar2120 0 1 A Title placed before a name. Example Ms, Mr Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. name_suffix varchar2120 0 1 The name suffix, can be academic, honorary, professional or generational. Example: PhD, MBA, PMP, Sr, Jr, JDA Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. company_name varchar2250 0 1 Contains the name of a business/ organization. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. Phones * 0 1 Contains a collection of phone numbers Emails * 0 1 Contains a collection of email addresses.

XML-Schema Name:AddrBook Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrBook in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description AddrBookEntry * 1 unbounded Contains a collection of addresses for the customer.

XML-Schema Name:AddrBookEntry Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrBookEntry in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description addr_id number22 0 1 Unique identifier for this address entry. NA NA RSB NA Yes NA primary_addr_ind prim_addr_type 1 1 Indicates whether this address is the primary address (Y) or not (N). NA NA RSB NA Yes NA addr_type addr_type 0 1 The address type. NA NA RSB NA Yes NA GeoAddrDesc:GeoAddrDesc * 1 1 Contains a customer address NA NA NA NA NA NA ContactDesc:ContactDesc * 0 1 Contains the contact information for an address. If no contact information provided at this level, then the contact information provided at the customer header level will be used. NA NA NA NA NA NA

XML-Schema Name:GeoAddrDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for GeoAddrDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description address_alias varchar2120 0 1 Contains the alias for this address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_1 varchar2240 1 1 Contains Address Line 1. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_2 varchar2240 0 1 Contains Address Line 2. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_3 varchar2240 0 1 Contains Address Line 3. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_4 varchar2240 0 1 Contains Address Line 4. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address_5 varchar2240 0 1 Contains Address Line 5. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. city varchar2120 0 1 Contains the city where the address is located. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. county varchar2250 0 1 County where this address is located Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. state_code varchar23 0 1 Contains the postal abbreviation for the state, province or territory in which the address is located. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. state_name varchar2120 0 1 Indicates the state, province or territory name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. country_code varchar23 0 1 Contains the postal abbreviation of the country in which the address is located Fill application table name. Fill table column name. RIB or/and RSB or/and RSL 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 or/and RSL Fill column length. Yes Fill this description. postal_code varchar230 0 1 Contains the postal code for the address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL 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 or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ContactDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ContactDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description first_name varchar2120 0 1 Contact first name. ORPOS Usage - For regular customers that are fed into ORPOS from an external customer system, if this field is not populated, ORPOS will prompt for a value. For Customers created by ORPOS, this field needs to be populated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. phonetic_first varchar2120 0 1 Phonetic first name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. last_name varchar2120 0 1 Contact last name. ORPOS Usage - For regular customers that are fed into ORPOS, if this field is not populated, ORPOS will prompt for a value. For Customers created by ORPOS, this field needs to be populated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. phonetic_last varchar2120 0 1 Phonetic last name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. middle_name varchar2120 0 1 Contact middle name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. preferred_name varchar2120 0 1 Contact preferred name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. full_name varchar2250 0 1 Contains the full name for a regular customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. name_prefix varchar2120 0 1 A Title placed before a name. Example Ms, Mr Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. name_suffix varchar2120 0 1 The name suffix, can be academic, honorary, professional or generational. Example: PhD, MBA, PMP, Sr, Jr, JDA Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. company_name varchar2250 0 1 Contains the name of a business/ organization. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. Phones * 0 1 Contains a collection of phone numbers Emails * 0 1 Contains a collection of email addresses.

XML-Schema Name:CustomerGrpIdLst Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustomerGrpIdLst in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_group_id number22 0 unbounded Contains the id for a preferred customer discount. NA NA RSB NA Yes NA

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RetAuthDesc/v1 Version 1.0 Description XSD Structure RetAuthDesc ReturnRequest ItemReturnInfo ItemTransactionInfo TransactionId TransIdDesc OriginalTender RetTendTypeDesc RetMsgExtDesc RetItemIdentDesc RetMsgExtDesc RetCustomerInfo MoreCustomerInfo PositiveId RetMsgExtDesc

XML-Schema Name:RetAuthDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetAuthDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ReturnRequest * 1 1 Return Request Information.

XML-Schema Name:ReturnRequest Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReturnRequest in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ItemReturnInfo * 1 unbounded Return Item Information. return_store_id varchar205 1 1 Return store ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. return_workstation_id varchar203 1 1 Return workstation ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. return_business_date xs:dateTime 1 1 Return business date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. return_date xs:dateTime 1 1 Return date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. currency_iso_code varchar203 1 1 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. RetStoreLangDesc:RetStoreLangDesc * 0 1 Store languages information. NA NA NA NA NA NA employee_id varchar210 1 1 Employee ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. customer_type varchar225 0 1 Customer type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. RetCustomerInfo * 0 1 Customer information. MoreCustomerInfo * 0 1 More Customer information. PositiveId * 0 1 Customer positive id. transaction_type varchar220 1 1 Transaction type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. return_ticket_id varchar230 0 1 Return Ticket ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. RetMsgExtDesc:RetMsgExtDesc * 0 1 Return message extensions. NA NA NA NA NA NA

XML-Schema Name:ItemReturnInfo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemReturnInfo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ItemTransactionInfo * 1 1 Item Transaction Information. RetItemIdentDesc:RetItemIdentDesc * 1 1 Item information. NA NA NA NA NA NA return_reason varchar2255 1 1 Return Reason. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. quantity number11 1 1 Quantity of item returned. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. amount_paid_per_unit number15 0 1 Amount paid per unit. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. amount_per_unit_in_base_cur number15 0 1 Amount paid per unit in base currency. Not required to pass this data. Calculated at the RM application using the base currency conversion. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. requested_adjusted_price number15 0 1 Requested adjusted price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. requested_price_in_base_cur number15 0 1 Requested adjusted price in base currency. Not required to pass this data. Calculated at the RM application using the base currency conversion. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. serial_number varchar210 0 1 Serial number 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_condition varchar2255 0 1 Item condition. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. manually_entered xs:boolean 1 1 Flag to determine manually entered. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. RetMsgExtDesc:RetMsgExtDesc * 0 1 Return message extensions. NA NA NA NA NA NA

XML-Schema Name:ItemTransactionInfo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTransactionInfo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description receipted xs:boolean 1 1 Flag to determine if the return is receipted. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. TransactionId * 0 1 Original sale transaction information. found xs:boolean 1 1 Flag to determine if the receipt is found. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. valid_at_point_of_return xs:boolean 1 1 Flag that determines if the return is valid at point of return. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. gift_receipt xs:boolean 0 1 Flag that determines if the return is a gift receipt. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. purchase_date xs:dateTime 0 1 Purchase Date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. delivery_date xs:dateTime 0 1 Delivery date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. validation_amount number15 0 1 Validation amount. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. validation_amount_in_base_cur number15 0 1 Validation amount in base currency.Not required to pass this data. Calculated at the RM application using the base currency conversion. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. OriginalTender * 0 1 Original Tender information. sale_quantity number11 0 1 Original sale quantity. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. RetMsgExtDesc:RetMsgExtDesc * 0 1 Return message extensions. NA NA NA NA NA NA

XML-Schema Name:TransactionId Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TransactionId in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description TransIdDesc:TransIdDesc * 1 1 Transaction id information. NA NA NA NA NA NA

XML-Schema Name:TransIdDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TransIdDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description store_id varchar205 1 1 Store ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. workstation_id varchar203 1 1 Workstation or Register id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. sequence_number number15 1 1 Transaction Sequence number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. business_date xs:dateTime 1 1 Business Date. 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:OriginalTender Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OriginalTender in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description RetTendTypeDesc:RetTendTypeDesc * 0 unbounded Tender type information. NA NA NA NA NA NA

XML-Schema Name:RetTendTypeDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetTendTypeDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description type varchar220 1 1 Tender Type. RM_LTM_RTN_TND TY_TND VARCHAR 20 Yes The type of tender. amount number15 0 1 Tender amount. RM_LTM_RTN_TND MO_TY_TND DECIMAL 13 Yes The monetary value for this tender type. amount_in_base_cur number15 0 1 Tender amount in base currency. Not required to pass this data. Calculated at the RM application using the base currency conversion. RM_LTM_RTN_TND MO_TY_TND_ORGL DECIMAL 13 Yes this field will contain the amount in the original currency prior to the currency change,if return is done in a different currency. card_number varchar220 0 1 Masked card number details. PA_CT ID_MSK_ACNT_CRD VARCHAR 20 Yes Masked card number

XML-Schema Name:RetMsgExtDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetMsgExtDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ExtensionEntry * 0 unbounded Return Message Extensions.

XML-Schema Name:RetItemIdentDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetItemIdentDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item_id varchar214 1 1 Item Id. AS_ITM ID_ITM VARCHAR 14 Yes A unique system identifier for an Item of merchandise or service. item_description varchar2250 0 1 Item Description. AS_ITM DE_ITM VARCHAR 250 Yes The description of the Item. Used for displaying the item description on the screen. Column has been marked for deprecation - moved to I18N table. item_type varchar220 0 1 Item Type. AS_ITM TY_ITM VARCHAR (0) Unknown, (1) Stock Item, (2) Service Item, (3) Store Coupon. Yes A code denoting the type of the Item. Valid values are

XML-Schema Name:RetMsgExtDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetMsgExtDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ExtensionEntry * 0 unbounded Return Message Extensions.

XML-Schema Name:RetCustomerInfo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetCustomerInfo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_id varchar214 1 1 Customer id. 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:MoreCustomerInfo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MoreCustomerInfo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description last_name varchar2120 1 1 Last Name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. first_name varchar2120 1 1 First Name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. middle_name varchar2120 0 1 Middle Name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. gender gender_type 0 1 Gender. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. birth_date varchar210 0 1 Birth Date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address1 varchar2240 1 1 Address Line1. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. address2 varchar2240 0 1 Address Line2. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. city varchar2120 1 1 City. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. state varchar230 1 1 State. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. postal_code varchar230 1 1 Postal Code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. country varchar230 1 1 Country. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. telephone_area_code varchar203 0 1 Telephone area code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. telephone_local_number varchar230 0 1 Telephone Local Number. 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:PositiveId Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PositiveId in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description id varchar21000 1 1 Positive id number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. type varchar250 1 1 Positive Id type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. issuer_country varchar202 1 1 Issuer Country. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. issuer_state varchar203 1 1 Issuer State. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. issued xs:dateTime 0 1 Issued date. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. expiration xs:dateTime 0 1 ID Expiration date 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:RetMsgExtDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetMsgExtDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description ExtensionEntry * 0 unbounded Return Message Extensions.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service 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:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReferenceId in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS'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:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Pair in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS'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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdDtlRef/v1 Version 1.0 Description This object is used to communicate item details related to a customer order fulfillment cancellation request from OMS to RMS and SIM. XSD Structure FulfilOrdDtlRef

XML-Schema Name:FulfilOrdDtlRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDtlRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancel_qty_suom number12_4 1 1 Indicates the quantity that should be cancelled from the order in item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. standard_uom varchar24 1 1 Indicates item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderCriVo/v1 Version 1.0 Description XSD Structure CustOrderCriVo OrderCriteria CustomerCri CustomerInfo CreditDebitCri MaskedCardNumber DateRange OrderRequestor OrderItemRequestor

XML-Schema Name:CustOrderCriVo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderCriVo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description search_loc_id number10 1 1 Location where the order search request is initiated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. search_loc_type enum_search_loc_type 1 1 Type of location where the order search request is initiated. The possible value is only "S" for store as of today. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. OrderCriteria * 1 1 This element defines the query criteria for order search OrderRequestor * 1 1 This element defines what needs to be returned in an order search result.

XML-Schema Name:OrderCriteria Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OrderCriteria in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description search_type enum_search_type 1 1 The type of order search to perform Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. customer_order_id varchar248 0 1 Based on the search type, either a customer order id, a customer criteria, or a credit debit card criteria must be specified for order search. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. CustomerCri * 0 1 Based on the search type, either a customer order id, a customer criteria, or a credit debit card criteria must be specified for order search. CreditDebitCri * 0 1 Based on the search type, either a customer order id, a customer criteria, or a credit debit card criteria must be specified for order search.

XML-Schema Name:CustomerCri Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustomerCri in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description CustomerInfo * 0 1 Either customer info or customer id must be set for order search by customer. customer_id varchar214 0 1 Either customer info or customer id must be set for order search by customer. 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:CustomerInfo Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustomerInfo in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description first_name varchar2120 0 1 customer first name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. last_name varchar2120 0 1 customer last name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. company_name varchar2120 0 1 customer company name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. postal_code varchar230 0 1 customer postal code Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. phone_number varchar230 0 1 customer phone number 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:CreditDebitCri Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CreditDebitCri in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description card_token varchar2100 0 1 Either a card token or a masked card number must be set for order search by credit/debit card. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. MaskedCardNumber * 0 1 Either a card token or a masked card number must be set for order search by credit/debit card. item_id varchar225 1 1 An item id in the order Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. DateRange * 0 1 A date range

XML-Schema Name:MaskedCardNumber Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for MaskedCardNumber in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description leading_digits varchar26 1 1 The first 6 digits of the card number Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. trailing_digits varchar24 1 1 The last 4 digits of the card number 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:DateRange Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DateRange in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description start_date xs:dateTime 1 1 the start date Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. end_date xs:dateTime 1 1 the end date 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:OrderRequestor Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OrderRequestor in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description request_order_header_flag flag 1 1 A boolean flag indicating if order header information must be returned. 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. request_order_item_flag enum_request_order_item_flag 1 1 A flag indicating if order items must be returned. The possible values are "NONE", "FIRST" (first item only), or "ALL". Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. request_order_fulfillment_flag flag 1 1 A boolean flag indicating if order fulfillment detail must be returned. 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. request_order_delivery_flag flag 1 1 A boolean flag indicating if order delivery detail must be returned. 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. request_order_payment_flag flag 1 1 A boolean flag indicating if order payment information must be returned. 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. OrderItemRequestor * 0 1 This element defines what needs to be returned for an order item. It is required only if the return_order_item_flag is "FIRST" or "ALL".

XML-Schema Name:OrderItemRequestor Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for OrderItemRequestor in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description request_item_header_flag flag 1 1 A boolean flag indicating if order item header info must be returned. 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. request_item_discount_flag flag 1 1 A boolean flag indicating if discount line items must be returned for an order item. 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. request_item_tax_flag flag 1 1 A boolean flag indicating if tax line items must be returned for an order item. 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.

Retail Integration Mappings Report Release:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdCfmDtl/v1 Version 1.0 Description This object is used to communicate item details of a customer order confirmation message to OMS from RMS and SIM. XSD Structure FulfilOrdCfmDtl

XML-Schema Name:FulfilOrdCfmDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_qty number12_4 1 1 Indicates the quantity of the item that can be sourced or fulfilled on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. confirm_qty_uom varchar24 1 1 Indicates the unit of measure of the confirmation quantity. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdRef/v1 Version 1.0 Description This object is used to communicate a customer order fulfillment cancellation request from OMS to RMS and SIM. XSD Structure FulfilOrdRef FulfilOrdDtlRef

XML-Schema Name:FulfilOrdRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description customer_order_no varchar248 1 1 Holds the master customer order number from OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_type source_loc_type 0 1 This would be either 'SU' for supplier, 'ST' for store, or 'WH' for warehouse. This would only be populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. source_loc_id number10 0 1 Indicates the supplier, store or warehouse number associated with sourcing the customer order. Only populated for vendor, warehouse or multi-site fulfillment orders. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_loc_id number10 1 1 Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. FulfilOrdDtlRef:FulfilOrdDtlRef * 1 unbounded Indicates the customer order fulfillment cancellation detail. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdDtlRef Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdDtlRef in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item varchar225 1 1 Indicates the item ordered by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. cancel_qty_suom number12_4 1 1 Indicates the quantity that should be cancelled from the order in item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. standard_uom varchar24 1 1 Indicates item's standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/RetItemIdentDesc/v1 Version 1.0 Description XSD Structure RetItemIdentDesc

XML-Schema Name:RetItemIdentDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RetItemIdentDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description item_id varchar214 1 1 Item Id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_description varchar2250 0 1 Item Description. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. item_type varchar220 0 1 Item Type. 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:14.0.0

(Point Of Service)

Application Point Of Service Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrdFulDesc/v1 Version 1.0 Description XSD Structure CustOrdFulDesc DeliveryDestDtl BillingDestDtl

XML-Schema Name:CustOrdFulDesc Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrdFulDesc in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description seq_no number4 1 1 The sequence no of an order's fulfillment detail. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. fulfill_order_id varchar248 0 1 The fulfillment order id assigned by OMS. This field is not populated during order creation. TR_LTM_SLS_RTN_ORD ID_ORD_FULFIL Yes fulfill_loc_type fulfill_loc_type 0 1 An enum indicating the fulfillment location type. The possible values are "S" for store, and "W" for warehouse. For a customer pickup, the location type is specified by the customer during order creation; for a customer ship, the location type is determined by OMS. NA NA NA NA Yes NA fulfill_loc_id number10 0 1 The location id where the order items are going to be fulfilled. For a customer pickup, the location id is specified by the customer during order creation; for a customer ship, the location id is determined by OMS. TR_ORD_DEL_DTL ID_STR_PCKP RSB Yes delivery_type delivery_type 1 1 An enum indicating the delivery type. The possible values are "C" for customer pickup and "S" for ship direct. TR_LTM_SLS_RTN_ORD DP_ORD_LN_ITM RSB Yes partial_delivery_ind partial_delivery_ind 0 1 Indicates if the order can be picked and shipped partially ('N') or if it should be picked up or shipped only when complete ('Y'). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_to_fulfill_loc_flag ship_to_fulfill_loc_flag 0 1 A boolean flag indicating if items need to be shipped to the fulfill location for pickup if customer pickup is specified. The possible values are "Y" or "N". TR_LTM_SLS_RTN_ORD FL_SHP_TO_PCKP RSB Yes carrier_code varchar24 0 1 The carrier code if ship direct is specified. TR_ORD_DEL_DTL SHP_CRR_DEL RSB Yes carrier_service_code varchar26 0 1 The carrier service code such as next day, overnight etc if ship direct is secified. TR_ORD_DEL_DTL SHP_TYP_DEL Yes consumer_delivery_date xs:dateTime 0 1 Indicates the desired date the delivery is required by the customer. This will be the GMT time. TR_ORD_DEL_DTL,TR_LTM_SLS_RTN_ORD DC_ORD_PCKP,DC_ORD_PCKP RSB Yes consumer_delivery_time xs:dateTime 0 1 Indicates the desired time the delivery is required by the customer. This will be the GMT time. TR_ORD_DEL_DTL DC_ORD_PCKP RSB Yes comments varchar22000 0 1 Special instructions if any. NA NA NA NA Yes NA DeliveryDestDtl * 1 1 The delivery destination of order items. BillingDestDtl * 0 1 The billing destination of order items.

XML-Schema Name:DeliveryDestDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DeliveryDestDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description cnct:ContactDesc * 1 1 The contact info of the person to pickup the items if customer pickup is specified; or the person to ship the items to if ship direct is specfied. NA NA NA NA NA NA addr:GeoAddrDesc * 0 1 The address to ship the order items to if ship direct is specifed. NA NA NA NA NA NA

XML-Schema Name:BillingDestDtl Version:14.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for BillingDestDtl in POS application. POS's Table Name POS's Column Name Integration API(RIB or/and RSB or/and RSL) POS's Column Length Is Column Required in POS's API? POS's API Description cnct:ContactDesc * 1 1 The contact info of the person to bill the order items. NA NA NA NA NA NA addr:GeoAddrDesc * 1 1 The address of the person to bill the order items. NA NA NA NA NA NA