Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
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

XML-Schema Name:FulfilOrdColDesc 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 FulfilOrdColDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
collection_size number4 1 1 Number of items in the collection. n/a n/a n/a n/a Yes n/a
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: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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
customer_order_no varchar248 1 1 Holds the master customer order number from OMS. ordcust customer_order_no varchar2 48 Yes Holds the master customer order number from OMS.
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. ordcust fulfill_order_no varchar2 48 Yes Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS.
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. ordcust source_loc_type varchar2 2 No 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.
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. ordcust source_loc_id number 10 No Indicates the supplier, store or warehouse number the customer order is sourced from. Only populated for vendor, warehouse or multi-site fulfillment orders.
fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). ordcust fulfill_loc_type varchar2 1 Yes Contains the fulfillment location type of the customer order. Valid values are 'S' for physical store and 'V' for virtual store.
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. ordcust fulfill_loc_id number 10 Yes 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.
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'). ordcust partial_delivery_ind varchar2 1 Yes Indicates if the order can be picked and shipped partially ('N') or if it should be shipped only when complete ('Y').
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). ordcust delivery_type varchar2 1 No Indicates the fulfillment method - ship to customer or store pickup. Expected values are 'S' (ship direct) and 'C' (customer pickup).
carrier_code varchar24 0 1 Indicates the carrier the order is to be shipped with, if specified on the order. ordcust carrier_code varchar2 4 No Indicates the carrier the order is to be shipped with, if specified on the order.
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.). ordcust carrier_service_code varchar2 6 No Indicates the shipping method that was selected by the customer (e.g. Standard Shipping, Overnight, etc.).
consumer_delivery_date xs:dateTime 1 1 Indicates the desired date the delivery is required by the customer. This will be the GMT time. ordcust consumer_delivery_date date n/a No Indicates the desired date the delivery is required by the customer.
consumer_delivery_time xs:dateTime 0 1 Indicates the desired time the delivery is required by the customer. This will be the GMT time. ordcust consumer_delivery_time date n/a No Indicates the desired time the delivery is required by the customer.
delivery_charges number20_4 0 1 Contains the delivery charges on drop ship. Mostly relevant for Brazil. ordcust deliver_charge number 20 No Contains the delivery charges for Drop Ship purchase orders.
delivery_charges_curr varchar23 0 1 Contains the currency of the delivery charges. ordcust deliver_charge_curr varchar2 3 No Contains the currency of the delivery charges.
comments varchar22000 0 1 Any comments sent by OMS about the order. ordcust comments varchar2 2000 No Any comments about the customer 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: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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
customer_no varchar214 0 1 Indicates the number that uniquely identifies the customer in OMS. ordcust customer_no varchar2 14 No Indicates the number that uniquely identifies the customer in OMS.
deliver_first_name varchar2120 0 1 Contains the first name for the delivery address on the order. ordcust deliver_first_name varchar2 120 No Contains the first name for the delivery address on the order.
deliver_phonetic_first varchar2120 0 1 Contains the phonetic first name for the delivery address on the order. ordcust deliver_phonetic_first varchar2 120 No Contains the phonetic first name for the delivery address on the order.
deliver_last_name varchar2120 0 1 Contains the last name for the delivery address on the order. ordcust deliver_last_name varchar2 120 No Contains the last name for the delivery address on the order.
deliver_phonetic_last varchar2120 0 1 Contains the phonetic last name for the delivery address on the order. ordcust deliver_phonetic_last varchar2 120 No Contains the phonetic last name for the delivery address on the order.
deliver_preferred_name varchar2120 0 1 Contains the preferred name for the delivery address on the order. ordcust deliver_preferred_name varchar2 120 No Contains the preferred name for the delivery address on the order.
deliver_company_name varchar2120 0 1 Contains the company name for the delivery address on the order. ordcust deliver_company_name varchar2 120 No Contains the company name for the delivery address on the order.
deliver_add1 varchar2240 0 1 First line of the delivery address for the customer. ordcust deliver_add1 varchar2 240 No First line of the delivery address for the customer.
deliver_add2 varchar2240 0 1 Second line of the delivery address for the customer. ordcust deliver_add2 varchar2 240 No Second line of the delivery address for the customer.
deliver_add3 varchar2240 0 1 Third line of the delivery address for the customer. ordcust deliver_add3 varchar2 240 No Third line of the delivery address for the customer.
deliver_county varchar2250 0 1 County portion of the delivery address. ordcust deliver_county varchar2 250 No County portion of the delivery address.
deliver_city varchar2120 0 1 City portion of the delivery address. ordcust deliver_city varchar2 120 No City portion of the delivery address.
deliver_state varchar23 0 1 State portion of the delivery address. ordcust deliver_state varchar2 3 No State portion of the delivery address.
deliver_country_id varchar23 0 1 Country portion of the delivery address. ordcust deliver_country_id varchar2 3 No Country portion of the delivery address.
deliver_post varchar230 0 1 Postal code portion of the delivery address. ordcust deliver_post varchar2 30 No Postal code portion of the delivery address.
deliver_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the delivery country-state relationship. ordcust deliver_jurisdiction varchar2 10 No Identifies the jurisdiction code for the delivery country-state relationship.
deliver_phone varchar220 0 1 Contains the delivery phone number. ordcust deliver_phone varchar2 20 No Contains the delivery phone number.
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. ordcust bill_first_name varchar2 120 No Contains the first name for the billing address on the order.
bill_phonetic_first varchar2120 0 1 Contains the phonetic first name for the billing address on the order. ordcust bill_phonetic_first varchar2 120 No Contains the phonetic first name for the billing address on the order.
bill_last_name varchar2120 0 1 Contains the last name for the billing address on the order. ordcust bill_last_name varchar2 120 No Contains the last name for the billing address on the order.
bill_phonetic_last varchar2120 0 1 Contains the phonetic last name for the billing address on the order. ordcust bill_phonetic_last varchar2 120 No Contains the phonetic last name for the billing address on the order.
bill_preferred_name varchar2120 0 1 Contains the preferred name for the billing address on the order. ordcust bill_preferred_name varchar2 120 No Contains the preferred name for the billing address on the order.
bill_company_name varchar2120 0 1 Contains the company name for the billing address on the order. ordcust bill_company_name varchar2 120 No Contains the company name for the billing address on the order.
bill_add1 varchar2240 0 1 First line of the billing address for the customer. ordcust bill_add1 varchar2 240 No First line of the billing address for the customer.
bill_add2 varchar2240 0 1 Second line of the billing address for the customer. ordcust bill_add2 varchar2 240 No Second line of the billing address for the customer.
bill_add3 varchar2240 0 1 Third line of the billing address for the customer. ordcust bill_add3 varchar2 240 No Third line of the billing address for the customer.
bill_county varchar2250 0 1 County portion of the billing address. ordcust bill_county varchar2 250 No County portion of the billing address.
bill_city varchar2120 0 1 City portion of the billing address. ordcust bill_city varchar2 120 No City portion of the billing address.
bill_state varchar23 0 1 State portion of the billing address. ordcust bill_state varchar2 3 No State portion of the billing address.
bill_country_id varchar23 0 1 Country portion of the billing address. ordcust bill_country_id varchar2 3 No Country portion of the billing address.
bill_post varchar230 0 1 Postal code portion of the billing address. ordcust bill_post varchar2 30 No Postal code portion of the billing address.
bill_jurisdiction varchar210 0 1 Identifies the jurisdiction code for the billing country-state relationship. ordcust bill_jurisdiction varchar2 10 No Identifies the jurisdiction code for the billing country-state relationship.
bill_phone varchar220 0 1 Contains the billing phone number. ordcust bill_phone varchar2 20 No Contains the billing phone number.
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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS'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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
item varchar225 1 1 Indicates the item ordered by the customer. ordcust_detail item varchar2 25 Yes Indicates the item ordered by the customer.
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. ordcust_detail ref_item varchar2 25 No 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 transfer requests for a specific reference item are not supported.
order_qty_suom number12_4 1 1 Indicates the quantity of the item ordered by the customer in item's standard unit of measure. ordcust_detail qty_ordered_suom number 12 Yes Holds the quantity ordered for the customer order/fulfillment no/item number. This quantity is in item's standard unit of measure.
standard_uom varchar24 1 1 Indicates item's standard unit of measure. ordcust_detail standard_uom varchar2 4 Yes Indicates the item's standard unit of measure.
transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. ordcust_detail transaction_uom varchar2 4 Yes Indicates the original transaction unit of measure the order is placed in.
substitute_ind varchar21 1 1 Indicates if substitutes are allowed on a customer order. This will only be used by orders passed to SIM. ordcust_detail substitute_allowed_ind varchar2 1 Yes Indicates if substitutes are allowed for an item on a customer order at the time of store fulfillment. This is applicable for store fulfillment only in SIM. Valid values are Y or N.
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. ordcust_detail unit_retail number 20 No Indicates the unit sales retail of the item on the customer order and is maintained in standard UOM.
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. ordcust_detail retail_currency_code varchar2 3 No Indicates currency of unit retail.
comments varchar22000 0 1 Used to indicate any special instructions for the item, such as services (monograms, engrave, etc). ordcust_detail comments varchar2 2000 No Used to indicate any special instructions for the item, such as services (monograms, engrave, etc)