Retail Integration Mappings Report Release:14.1.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:14.1.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. NA NA NA NA NA NA
FodItmMod * 0 1000 Collection of delivery line items representing modified information

XML-Schema Name:FodBolMod Version:14.1.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 NA NA NA NA NA NA
requested_pickup_date xs:dateTime 0 1 Bill of lading requested pickup date NA NA NA NA NA NA
carrier_role fod_carrier_role 1 1 Bill of lading carrier role. Valid values are SENDER, RECEIVER, THIRD_PARTY. NA NA NA NA NA NA
carrier_code varchar225 0 1 Bill of lading carrier code NA NA NA NA NA NA
carrier_service_code varchar225 0 1 Bill of lading carrier service role NA NA NA NA NA NA
carrier_name varchar2240 0 1 Bill of lading carrier name NA NA NA NA NA NA
carrier_address varchar22000 0 1 Bill of lading carrier address NA NA NA NA NA NA
carton_type_id number12 0 1 Unique identifier of the shipment carton type that the order is shipped in. NA NA NA NA NA NA
package_weight number12_4 0 1 The weight of the package measured by package_weight_uom. NA NA NA NA NA NA
package_weight_uom varchar24 0 1 The unit of measure of the package weight. NA NA NA NA NA NA
alternate_ship_to_address varchar22000 0 1 Bill of lading alternate destination address NA NA NA NA NA NA
tracking_number varchar2128 0 1 Bill of lading tracking number NA NA NA NA NA NA

XML-Schema Name:FodItmMod Version:14.1.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 Yes Serial numbers
removed_uin_col varchar2128 0 1000 Unique Identifier Numbers to remove from the line item 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. NA NA NA NA NA NA

XML-Schema Name:StrInvExtAttDesc Version:14.1.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. NA NA NA NA NA NA
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. NA NA NA NA NA NA
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode. NA NA NA NA NA NA