Retail Integration Mappings Report Release:15.0.0

(Integration Gateway Services)

Application Integration Gateway Services 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:15.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 IGS application. IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description customer_order_no varchar248 1 1 Holds the master customer order number from OMS. RMS.ordcust, SIM.ful_ord customer_order_no, cust_order_id varchar2 Holds the master customer order number from OMS. SIM Yes, Yes RMS 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. RMS.ordcust, SIM.ful_ord fulfill_order_no, id varchar2 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. SIM Yes, Yes RMS 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. RMS.ordcust, SIM.N/A source_loc_type,SIM.N/A varchar2 Contains the source type for the customer order. Valid values are 'SU' for supplier, 'ST' for store and 'WH' for warehouse. This would only contain a value for vendor, warehouse, or multi-site fulfilment orders. SIM No, SIM.N/A RMS 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. RMS.ordcust, SIM.N/A source_loc_id, SIM.N/A number Indicates the supplier, store or warehouse number the customer order is sourced from. Only populated for vendor, warehouse or multi-site fulfillment orders. SIM No, SIM.N/A RMS fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). RMS.ordcust, SIM.N/A fulfill_loc_type, SIM.N/A varchar2 Contains the fulfillment location type of the customer order. Valid values are 'S' for physical store and 'V' for virtual store. SIM Yes, SIM.N/A RMS 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. RMS.ordcust, SIM.ful_ord fulfill_loc_id, store_id number 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. SIM Yes, Yes RMS 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'). RMS.ordcust, SIM.ful_ord partial_delivery_ind, allow_partial_delivery varchar2 Indicates if the order can be picked and shipped partially ('N') or if it should be shipped only when complete ('Y'). SIM Yes, Yes RMS 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). RMS.ordcust, SIM.ful_ord delivery_type, delivery_type varchar2 Indicates the fulfillment method - ship to customer or store pickup. Expected values are 'S' (ship direct) and 'C' (customer pickup). SIM No, Yes RMS carrier_code varchar24 0 1 Indicates the carrier the order is to be shipped with, if specified on the order. RMS.ordcust, SIM.shipment_carrier carrier_code, code varchar2 Indicates the carrier the order is to be shipped with, if specified on the order. SIM No, Yes RMS 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.). RMS.ordcust, SIM.shipment_carrier_service carrier_service_code, code varchar2 Indicates the shipping method that was selected by the customer (e.g. Standard Shipping, Overnight, etc.). SIM No, Yes RMS consumer_delivery_date xs:dateTime 1 1 Indicates the desired date the delivery is required by the customer. This will be the GMT time. RMS.ordcust, SIM.ful_ord consumer_delivery_date, delivery_date date Indicates the desired date the delivery is required by the customer. SIM No, No RMS consumer_delivery_time xs:dateTime 0 1 Indicates the desired time the delivery is required by the customer. This will be the GMT time. RMS.ordcust, SIM.ful_ord consumer_delivery_time, delivery_date date Indicates the desired time the delivery is required by the customer. SIM No, Yes RMS delivery_charges number20_4 0 1 Contains the delivery charges on drop ship. Mostly relevant for Brazil. RMS.ordcust, SIM.ful_ord deliver_charge, ship_cost_value number Contains the delivery charges for Drop Ship purchase orders. SIM No, No RMS delivery_charges_curr varchar23 0 1 Contains the currency of the delivery charges. RMS.ordcust, SIM.ful_ord deliver_charge_curr, ship_cost_currency varchar2 Contains the currency of the delivery charges. SIM No, No RMS comments varchar22000 0 1 Any comments sent by OMS about the order. RMS.ordcust, SIM.ful_ord comments, comments varchar2 Any comments about the customer order. SIM No, No RMS 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:15.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 IGS application. IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description customer_no varchar214 0 1 Indicates the number that uniquely identifies the customer in OMS. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_first_name varchar2120 0 1 Contains the first name for the delivery address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_phonetic_first varchar2120 0 1 Contains the phonetic first name for the delivery address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_last_name varchar2120 0 1 Contains the last name for the delivery address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_phonetic_last varchar2120 0 1 Contains the phonetic last name for the delivery address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_preferred_name varchar2120 0 1 Contains the preferred name for the delivery address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_company_name varchar2120 0 1 Contains the company name for the delivery address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_add1 varchar2240 0 1 First line of the delivery address for the customer. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_add2 varchar2240 0 1 Second line of the delivery address for the customer. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_add3 varchar2240 0 1 Third line of the delivery address for the customer. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_county varchar2250 0 1 County portion of the delivery address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_city varchar2120 0 1 City portion of the delivery address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_state varchar23 0 1 State portion of the delivery address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_country_id varchar23 0 1 Country portion of the delivery address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_post varchar230 0 1 Postal code portion of the delivery address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the delivery country-state relationship. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_phone varchar220 0 1 Contains the delivery phone number. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS deliver_email varchar2120 0 1 Contains the delivery email. 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. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_phonetic_first varchar2120 0 1 Contains the phonetic first name for the billing address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_last_name varchar2120 0 1 Contains the last name for the billing address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_phonetic_last varchar2120 0 1 Contains the phonetic last name for the billing address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_preferred_name varchar2120 0 1 Contains the preferred name for the billing address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_company_name varchar2120 0 1 Contains the company name for the billing address on the order. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_add1 varchar2240 0 1 First line of the billing address for the customer. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_add2 varchar2240 0 1 Second line of the billing address for the customer. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_add3 varchar2240 0 1 Third line of the billing address for the customer. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_county varchar2250 0 1 County portion of the billing address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_city varchar2120 0 1 City portion of the billing address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_state varchar23 0 1 State portion of the billing address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_country_id varchar23 0 1 Country portion of the billing address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_post varchar230 0 1 Postal code portion of the billing address. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the billing country-state relationship. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_phone varchar220 0 1 Contains the billing phone number. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS bill_email varchar2120 0 1 Contains the billing email. 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:15.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 IGS application. IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS'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:15.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 IGS application. IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description item varchar225 1 1 Indicates the item ordered by the customer. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS 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. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS order_qty_suom number12_4 1 1 Indicates the quantity of the item ordered by the customer in item's standard unit of measure. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS standard_uom varchar24 1 1 Indicates item's standard unit of measure. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS substitute_ind varchar21 1 1 Indicates if substitutes are allowed on a customer order. This will only be used by orders passed to SIM. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS 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. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS 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. RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS comments varchar22000 0 1 Used to indicate any special instructions for the item, such as services (monograms, engrave, etc). RMS.Fill application table name., SIM.fill application table name. Fill table column name., fill table column name. RIB or/and RSB or/and RSL Fill this description. SIM Yes, Yes RMS