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

XML-Schema Name:FodHdrColDesc 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 FodHdrColDesc 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
FodHdrDesc:FodHdrDesc * 0 unbounded Collection of fulfillment order delivery headers NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. 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:FodHdrDesc 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 FodHdrDesc 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
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.
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.
dispatch_date xs:dateTime 0 1 Date the fulfillment order delivery FUL_ORD_DLV DISPATCH_DATE Date Fill column length. No The date this delivery was dispatched.