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/XOrderDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

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

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