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/FodCreModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:FodCreModVo 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 FodCreModVo 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_id number12 1 1 Fulfillment order identifier. Service attempts to create delivery for the fulfillment order based on identifier. FUL_ORD ID number 12,0 Yes Unique SIM identifier.
notes varchar22000 0 1 Notes to add to the fulfillment order delivery. NOTES TEST varchar2 2000 Yes The note's message.
FodCreBolMod * 0 1 Information about bill of lading for the order delivery.
FodCreItmMod * 0 1000 Collection of fulfillment order delivery line items containing modified information.

XML-Schema Name:FodCreBolMod 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 FodCreBolMod 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:FodCreItmMod 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 FodCreItmMod 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_line_id number12 1 1 Indicates the fulfillment order line item corresponding to the created delivery line item FUL_ORD_DLV_LINE_ITEM FUL_ORD_LINE_ITEM_ID number 12,0 Yes Unique identifier of the fulfillment order line item this delivery line item is fulfilling.
quantity number20_4 1 1 Quantity of the delivery. 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
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.