Retail Integration Mappings Report Release:16.0.21 (Advanced Inventory Planning)
Application Advanced Inventory Planning
Target Name Space http://www.oracle.com/retail/integration/base/bo/InvocationSuccess/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:InvocationSuccess Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvocationSuccess in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
success_message varchar2500 0 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:16.0.21
Retail Integration Mappings Report Release:16.0.21 (Advanced Inventory Planning)
Application Advanced Inventory Planning
Target Name Space http://www.oracle.com/retail/integration/base/bo/Nothing/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:Nothing Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Nothing in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
description varchar2500 0 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:16.0.21
Retail Integration Mappings Report Release:16.0.21 (Advanced Inventory Planning)
Application Advanced Inventory Planning
Target Name Space http://www.oracle.com/retail/integration/base/bo/ReferenceId/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ReferenceId Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReferenceId in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
id varchar2255 0 1 N/A N/A N/A N/A N/A N/A
Pair * 0 unbounded

XML-Schema Name:Pair Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Pair in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
name varchar2255 1 1 N/A N/A N/A N/A N/A N/A
value varchar2255 1 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:16.0.21
Retail Integration Mappings Report Release:16.0.21 (Advanced Inventory Planning)
Application Advanced Inventory Planning
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:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrderDesc in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
order_no varchar212 1 1 The unique identifier for the order. * * null null 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. * * null null 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. * * null null 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 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. * * null null 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 xs:dateTime 0 1 The first date that delivery will be accepted. This can be modified in worksheet or approved status. * * null null 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. * * null null No The last date that 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. * * null null 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. * * null null 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 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. * * null null 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 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.. * * null null 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. * * null null No Indicates if 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. * * null null 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. * * null 2 - Manual, 6 - AIP generated order, 7 , 8. Yes Indicates where the order originated. Valid values include
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. * * null Y = Submit via EDI, N = Do not use EDI. No Indicates whether or not the order will be transmitted to the supplier via an Electronic Data Exchange transaction. Valid values are
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. * * null null 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 varchar230 0 1 Indicates where the order was approved. It will be the user ID of the person approving the order. * * 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. * * null null No Any 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 Fill column length. Yes Fill this description.

XML-Schema Name:XOrderDtl Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrderDtl in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP'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. * * 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. * * 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. * * 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 on 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. * * null null 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 varchar23 0 1 The identifier of the country from which the item is being sourced. This field cannot be modified. * * null null 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. * * null null 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. * * null null 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 varchar21 0 1 The location type of the location. Valid values are 'S' store and 'W' warehouse. This field cannot be modified. * * null null 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. * * null null No Indicates if the detail record's quantity should be cancelled. Valid values are 'Y'es and 'N'o.
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. * * null null 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.
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 Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21
Retail Integration Mappings Report Release:16.0.21 (Advanced Inventory Planning)
Application Advanced Inventory Planning
Target Name Space http://www.oracle.com/retail/integration/base/bo/XOrderRef/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:XOrderRef Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrderRef in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
order_no varchar212 1 1 The unique identifier for the order. * * null null Yes The unique identifier for the order.
XOrderDtlRef * 0 unbounded Description is not available.
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 Fill column length. Yes Fill this description.

XML-Schema Name:XOrderDtlRef Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrderDtlRef in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP'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'). * * null null No An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P').
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. * * null null Yes An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected.
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. * * null null 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.

Retail Integration Mappings Report Release:16.0.21
Retail Integration Mappings Report Release:16.0.21 (Advanced Inventory Planning)
Application Advanced Inventory Planning
Target Name Space http://www.oracle.com/retail/integration/base/bo/XTsfDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:XTsfDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XTsfDesc in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
tsf_no number12 1 1 Number that uniquely identifies the transfer. * * null null Yes Number that uniquely identifies the transfer.
from_loc_type varchar21 1 1 The location type of the from location. * * null null Yes The location type of the From location.
from_loc varchar210 1 1 The location number of the from location. * * null null Yes The location number of the From location.
to_loc_type varchar21 1 1 The location type of the to location. * * null null Yes The location type of the To location.
to_loc varchar210 1 1 The location number of the to location. * * null null Yes The location number of the To location.
delivery_date xs:dateTime 0 1 The earliest date the transfer can be delivered. * * null null No The earliest date on which the transfer can be delivered.
dept number4 0 1 The department number associated with the transfer. * * null null No The department number associated with the transfer.
routing_code varchar21 0 1 If the freight status is expedite, this is a code indicating more detailed freight info. * * null null No If the freight status is expedite, this code indicates more detailed freight information.
freight_code varchar21 0 1 A code indicating the freight status of the transfer (e.g. normal, expedite, etc.). * * null null No A code indicating the freight status of the transfer (such as normal and expedite.).
tsf_type varchar26 0 1 A code indicating the type of transfer (e.g. store requisition, book transfer, etc.). * * null null No A code indicating the type of transfer (for example, store requisition and book transfer).
XTsfDtl * 0 unbounded Child node - see layout below.
status varchar21 0 1 A code indicating the status of the transfer (e.g. approved, closed, etc.). * * null null No A code indicating the status of the transfer (such as Approved and Closed).
user_id varchar230 0 1 The userid of the user who created the transfer. * * null null No The userid of the user who created the transfer.
comment_desc varchar22000 0 1 Comments associated with the transfer. * * null null No Comments associated with the transfer.
context_type varchar26 0 1 This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
context_value varchar225 0 1 This field holds the value relating to the context type like Promotion number. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:XTsfDtl Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XTsfDtl in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
item varchar225 1 1 The unique identifier of the item being transferred. * * null null Yes The unique identifier of the item being transferred.
tsf_qty number12_4 1 1 The total quantity of the item reserved for this transfer at the from location. * * null null Yes The total quantity of the item reserved for this transfer at the from location.
supp_pack_size number12_4 0 1 The supplier pack size for this item/transfer. * * null null No The supplier pack size for this item/transfer.
inv_status number2 0 1 A code indicating the inventory status for this transfer detail; valid values are found on the inv_status_types table. * * null null No A code indicating the inventory status for this transfer detail. Valid values are in the inv_status_types table.
unit_cost number20_4 0 1 Not mapped to a database field. Sometimes used to calculate retail price. * * null null No Not mapped to a database field. Sometimes used to calculate retail price.
adjustment_type varchar26 0 1 Not mapped to a database field. Sometimes used to calculate retail price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
adjustment_value number20_4 0 1 Not mapped to a database field. Sometimes used to calculate retail price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21
Retail Integration Mappings Report Release:16.0.21 (Advanced Inventory Planning)
Application Advanced Inventory Planning
Target Name Space http://www.oracle.com/retail/integration/base/bo/XTsfRef/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:XTsfRef Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XTsfRef in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
tsf_no number12 1 1 The transfer number where info is being deleted. * * null null Yes The transfer number where information is being deleted.
XTsfDtlRef * 0 unbounded Child node - see below.

XML-Schema Name:XTsfDtlRef Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XTsfDtlRef in AIP application.
AIP's Table Name AIP's Column Name Integration API(RIB or/and RSB or/and RSL) AIP's Column Length Is Column Required in AIP's API? AIP's API Description
item varchar225 1 1 The item for which transfer info is being deleted. * * null null Yes The item for which transfer information is being deleted.