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

XML-Schema Name:FodDesc 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 FodDesc 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 of the fulfillment order being delivered.
ext_fulfill_order_delivery_id varchar225 0 1 External fulfillment order delivery identifier FUL_ORD_DLV EXTERNAL_ID VARCHAR2 25 No The external transaction id for this delivery.
fulfill_order_id number12 1 1 Fulfillment order identifier FUL_ORD_DLV FUL_ORD_ID NUMBER 12,0 Yes Unique SIM identifier of the fulfillment order being delivered.
store_id number10 1 1 Fulfillment order identifier FUL_ORD_DLV STORE_ID number 10,0 Yes The store identifier.
status fod_status 1 1 Current status Valid values are IN_PROGRESS, SUBMITTED, COMPLETED, CANCELED, UNKNOWN. FUL_ORD_DLV STATUS NUMBER 4,0 Yes Indicates the status of the delivery. Valid values are 1 - In Progress, 2 - Submitted, 3 - Completed, 4 - Canceled, 5- Active
create_date xs:dateTime 1 1 Date the delivery was created FUL_ORD_DLV CREATE_DATE Date Fill column length. Yes The date this delivery was created.
create_user_name varchar2128 1 1 User that created this delivery FUL_ORD_DLV CREATE_USER VARCHAR2 128 Yes The user that created this delivery.
dispatch_date xs:dateTime 0 1 Date the delivery was dispatched FUL_ORD_DLV DISPATCH_DATE Date Fill column length. No The date this delivery was dispatched.
dispatch_user_name varchar2128 0 1 User that dispatched this delivery FUL_ORD_DLV DISPATCH_USER VARCHAR2 128 No The user that dispatched this delivery.
FodBol * 1 1 Bill of lading information associated to the delivery.
FodItm * 0 unbounded Collection of fulfillment order delivery line items

XML-Schema Name:FodBol 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 FodBol 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 SHIPMENT_BOL MOTIVE VARCHAR2 120 Yes this field contains the motive
requested_pickup_date xs:dateTime 0 1 Bill of lading requested pickup date SHIPMENT_BOL REQUESTED_PICKUP_DATE Date Fill column length. No the field contains the requested pickup date
carrier_role fod_carrier_role 1 1 Bill of lading carrier role Valid values are SENDER, RECEIVER, THIRD_PARTY. SHIPMENT_BOL CARRIER_ROLE VARCHAR2 12 Yes this field contains the type of carrier for the shipment
carrier_code varchar225 0 1 Bill of lading carrier code SHIPMENT_CARRIER CODE VARCHAR2 4 Yes Unique code identifier for a carrier
carrier_service_code varchar225 0 1 Bill of lading carrier service role SHIPMENT_CARRIER_SERVICE CODE VARCHAR2 6 Yes Unique identifier that represents the delivery service
carrier_name varchar2240 0 1 Bill of lading carrier name SHIPMENT_BOL THIRD_PARTY_NAME VARCHAR2 240 No this field contains the name of the third party
carrier_address varchar22000 0 1 Bill of lading carrier address SHIPMENT_BOL THIRD_PARTY_ADDRESS VARCHAR2 2000 No this field contains the address of the third party
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.
ship_to_address_type fod_address_type 1 1 Bill of lading destination address type Valid values are BUSINESS, POSTAL, RETURNS, ORDER, INVOICE, REMITTANCE, NO_VALUE. SHIPMENT_BOL SHIP_TO_ADDRESS_TYPE VARCHAR2 2 No The address type for the ship to address. valid values 01 - Business Address, 02 - Postal Address, 03 - Return Address, 04 - Order Address, 05 - Invoice Address, 06 - Remittance Address, 07 - Billing Address, 08 - Delivery Address
alternate_ship_to_address varchar22000 0 1 Bill of lading alternate destination address SHIPMENT_BOL ALT_DESTINATION_ADDRESS VARCHAR2 2000 No this field contains the alternate destination address
tracking_number varchar2128 0 1 Bill of lading tracking number SHIPMENT_BOL TRACKING_NUMBER VARCHAR2 128 No Holds the tracking number for the transaction.

XML-Schema Name:FodItm 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 FodItm 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 Line item identifier of the fulfillment order delivery FUL_ORD_DLV_LINE_ITEM ID number 12,0 Yes Unique SIM identifier.
fulfill_order_line_id number12 1 1 Line item identifier of the fulfillment order 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 in standard unit of measure FUL_ORD_DLV_LINE_ITEM QUANTITY number 12,4 Yes The quantity of this line item on the delivery.
case_size number10_2 1 1 Case size of the item FUL_ORD_DLV_LINE_ITEM CASE_SIZE NUMBER 10,2 No The case size of this line item.
uin_col varchar2128 0 unbounded Collection of all the unique identifier numbers Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Serial Numbers list
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes for the line item. NA NA NA NA NA NA

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.