Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:XOrderDesc.xsd
Tag Name Table Name Column Name API Req Description
order_no ordhead order_no Yes The unique identifier for the order.
supplier ordhead supplier 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 ordhead currency_code No 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.
terms ordhead terms No 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.
not_before_date ordhead not_before_date No The first date that delivery will be accepted. This can be modified in worksheet or approved status.
not_after_date ordhead not_after_date No The last date that delivery will be accepted. This can be modified in worksheet or approved status.
otb_eow_date ordhead otb_eow_date No The end of week date of the OTB bucket used. This can be modified in worksheet or approved status.
dept ordhead dept No 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.
status ordhead status No 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.
exchange_rate ordhead exchange_rate 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 ordhead include_on_ord_ind No Indicates if the order should be included in on-order calculations. This can be modified in worksheet or approved status.
written_date ordhead written_date 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 * * * *
orig_ind ordhead orig_ind Yes Indicates where the order originated. Valid values include: 2 - Manual, 6 - AIP generated order, 7 , 8.
edi_po_ind ordhead edi_po_ind No 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.
pre_mark_ind ordhead pre_marked_ind No 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.
user_id ordhead orig_approval_id No Indicates where the order was approved. It will be the user ID of the person approving the order.
comment_desc ordhead comment_desc No Any comments pertaining to the order.

Application Name: Retail Merchandising System
XML-Schema or Node Name:XOrderDtl
Tag Name Table Name Column Name API Req Description
item ordsku item 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 ordloc location 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 ordloc unit_cost 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 on the message, it will default from the item supplier cost for this location.
ref_item ordsku ref_item No 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.
origin_country_id ordsku origin_country_id No The identifier of the country from which the item is being sourced. This field cannot be modified.
supp_pack_size ordsku supp_pack_size No The supplier pack size for the item on the order. This may be updated in worksheet or approved status.
qty_ordered ordloc qty_ordered Yes 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.
location_type ordloc location_type Yes The location type of the location. Valid values are 'S' store and 'W' warehouse. This field cannot be modified.
cancel_ind n/a n/a No Indicates if the detail record's quantity should be cancelled. Valid values are 'Y'es and 'N'o.
reinstate_ind n/a n/a No 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.