Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XOrderDesc.xsd
Tag Name Table Name Column Name API Req Description
order_no * * Yes The unique identifier for the order.
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 * * 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 * * 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 * * No The first date that delivery will be accepted. This can be modified in worksheet or approved status.
not_after_date * * No The last date that delivery will be accepted. This can be modified in worksheet or approved status.
otb_eow_date * * No The end of week date of the OTB bucket used. This can be modified in worksheet or approved status.
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 * * 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 * * 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 * * No Indicates if the order should be included in on-order calculations. This can be modified in worksheet or approved status.
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 * * Yes Indicates where the order originated. Valid values include: 2 - Manual, 6 - AIP generated order, 7 , 8.
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 * * 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 * * No Indicates where the order was approved. It will be the user ID of the person approving the order.
comment_desc * * No Any comments pertaining to the order.

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XOrderDtl
Tag Name Table Name Column Name API Req Description
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 * * 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 * * 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 * * 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 * * No The identifier of the country from which the item is being sourced. This field cannot be modified.
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 * * 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 * * Yes The location type of the location. Valid values are 'S' store and 'W' warehouse. This field cannot be modified.
cancel_ind * * No Indicates if the detail record's quantity should be cancelled. Valid values are 'Y'es and 'N'o.
reinstate_ind * * 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.


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XOrderRef.xsd
Tag Name Table Name Column Name API Req Description
order_no * * Yes The unique identifier for the order.
XOrderDtlRef * * * *

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XOrderDtlRef
Tag Name Table Name Column Name API Req Description
item * * No An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P').
location * * Yes An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected.
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.


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XTsfDesc.xsd
Tag Name Table Name Column Name API Req Description
tsf_no * * Yes Number that uniquely identifies the transfer.
from_loc_type * * Yes The location type of the from location.
from_loc * * Yes The location number of the from location.
to_loc_type * * Yes The location type of the to location.
to_loc * * Yes The location number of the to location.
delivery_date * * No The earliest date the transfer can be delivered.
dept * * No The department number associated with the transfer.
routing_code * * No If the freight status is expedite, this is a code indicating more detailed freight info.
freight_code * * No A code indicating the freight status of the transfer (e.g. normal, expedite, etc.).
tsf_type * * No A code indicating the type of transfer (e.g. store requisition, book transfer, etc.).
XTsfDtl * * * Child node - see layout below.
status * * No A code indicating the status of the transfer (e.g. approved, closed, etc.).
user_id * * No The userid of the user who created the transfer.
comment_desc * * No Comments associated with the transfer.

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XTsfDtl
Tag Name Table Name Column Name API Req Description
item * * Yes The unique identifier of the item being transferred.
tsf_qty * * Yes The total quantity of the item reserved for this transfer at the from location.
supp_pack_size * * No The supplier pack size for this item/transfer.
inv_status * * No A code indicating the inventory status for this transfer detail; valid values are found on the inv_status_types table.
unit_cost * * No Not mapped to a database field. Sometimes used to calculate retail price.


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XTsfRef.xsd
Tag Name Table Name Column Name API Req Description
tsf_no * * Yes The transfer number where info is being deleted.
XTsfDtlRef * * No Child node - see below.

Application Name: Advanced Inventory Planning
Version 13.0.1
XML-Schema or Node Name:XTsfDtlRef
Tag Name Table Name Column Name API Req Description
item * * Yes The item for which transfer info is being deleted.