Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/FodModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:FodModVo 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 FodModVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
int_fulfill_order_delivery_id number12 1 1 Internal fulfillment order delivery identifier FUL_ORD_DLV ID number 12,0 Yes Unique SIM identifier
notes varchar22000 0 10 Notes to add to the delivery. NOTES TEXT VARCHAR2 2000 Yes The note's message.
FodBolMod * 0 1 Information about bill of lading for the order delivery.
FodItmMod * 0 1000 Collection of delivery line items representing modified information

XML-Schema Name:FodBolMod 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 FodBolMod in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
bill_of_lading_motive_id varchar2120 0 1 Bill of lading motive identifier Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
requested_pickup_date xs:dateTime 0 1 Bill of lading requested pickup date Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carrier_role fod_carrier_role 1 1 Bill of lading carrier role. Valid values are SENDER, RECEIVER, THIRD_PARTY. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carrier_code varchar225 0 1 Bill of lading carrier code Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carrier_service_code varchar225 0 1 Bill of lading carrier service role Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carrier_name varchar2240 0 1 Bill of lading carrier name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carrier_address varchar22000 0 1 Bill of lading carrier address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carton_type_id number12 0 1 Unique identifier of the shipment carton type that the order is shipped in. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
package_weight number12_4 0 1 The weight of the package measured by package_weight_uom. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
package_weight_uom varchar24 0 1 The unit of measure of the package weight. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
alternate_ship_to_address varchar22000 0 1 Bill of lading alternate destination address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
tracking_number varchar2128 0 1 Bill of lading tracking number 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:FodItmMod 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 FodItmMod in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
fulfill_order_delivery_line_id number12 1 1 Delivery line item identifier FUL_ORD_DLV_LINE_ITEM ID number 12,0 Yes Unique SIM identifier.
quantity number20_4 1 1 Quantity in units. Value is in standard unit of measure. If UINs are included, the quantity of UINs will override this value. FUL_ORD_DLV_LINE_ITEM QUANTITY number 12,4 Yes The quantity of this line item on the delivery.
added_uin_col varchar2128 0 100 Unique Identifier Numbers to add to the line item Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Serial numbers
removed_uin_col varchar2128 0 1000 Unique Identifier Numbers to remove from the line item Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Removed serial numbers
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes associated to the line item, either added or updated external attributes. NA NA NA NA NA NA
removed_ext_att_col varchar2128 0 1000 Contains barcodes associated to the extended attribute scan to be deleted. All occurrences will be deleted. 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:StrInvExtAttDesc 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 StrInvExtAttDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.