Retail Integration Mappings Report Release:14.1.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

XML-Schema Name:FulfilOrdDesc Version:14.1.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 48 Yes, Yes RMS:Holds the master customer order number from OMS. SIM:External identifier of the customer order being fulfilled.
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 48 Yes, Yes RMS: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:Unique SIM identifier
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 2 No, SIM.N/A RMS: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:not used in SIM
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 10 No, SIM.N/A RMS:Indicates the supplier, store or warehouse number the customer order is sourced from. Only populated for vendor, warehouse or multi-site fulfillment orders. SIM:not used in SIM
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 1 Yes, SIM.N/A RMS:Contains the fulfillment location type of the customer order. Valid values are 'S' for physical store and 'V' for virtual store. SIM:not used in SIM
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 10 Yes, Yes RMS: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:Store identifier at which this order is being fulfilled.
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 1 Yes, Yes RMS:Indicates if the order can be picked and shipped partially ('N') or if it should be shipped only when complete ('Y'). SIM:Indicator whether all items on the order must be there to be delivered.
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 1 No, Yes RMS:Indicates the fulfillment method - ship to customer or store pickup. Expected values are 'S' (ship direct) and 'C' (customer pickup). SIM:Identifier that represents the type of delivery for this order.
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 4 No, Yes RMS:Indicates the carrier the order is to be shipped with, if specified on the order. SIM:Unique code identifier for a carrier
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 6 No, Yes RMS:Indicates the shipping method that was selected by the customer (e.g. Standard Shipping, Overnight, etc.). SIM:Unique identifier that represents the delivery service
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 n/a No, No RMS:Indicates the desired date the delivery is required by the customer. SIM:The date in which the fulfillment order is to be delivered.
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 n/a No, Yes RMS:Indicates the desired time the delivery is required by the customer. SIM:Delivery time is set to Delivery_date column
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 20 No, No RMS:Contains the delivery charges for Drop Ship purchase orders. SIM:The shipment cost for this order.
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 3 No, No RMS:Contains the currency of the delivery charges. SIM:The currency in which the delivery charge is represented.
comments varchar22000 0 1 Any comments sent by OMS about the order. RMS.ordcust, SIM.ful_ord comments, comments varchar2 2000 No, No RMS:Any comments about the customer order. SIM:Comments defined by the external system for this order.
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.1.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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
deliver_email varchar2120 0 1 Contains the delivery email. NA NA NA NA NA NA
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
bill_email varchar2120 0 1 Contains the billing email. NA NA NA NA NA NA
LocOfFulfilOrdCustDesc:LocOfFulfilOrdCustDesc * 0 1 References a collection of localization extension. NA NA NA NA NA NA

XML-Schema Name:LocOfFulfilOrdCustDesc Version:14.1.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:14.1.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 column length. Yes, Yes RMS:Fill this description. SIM: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. 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 column length. Yes, Yes RMS:Fill this description. SIM: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. 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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM: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. 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 column length. Yes, Yes RMS:Fill this description. SIM: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. 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 column length. Yes, Yes RMS:Fill this description. SIM: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. 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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.
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 column length. Yes, Yes RMS:Fill this description. SIM:Fill this description.