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/SODesc/v1 Version 1.3 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure SODesc SODtlDesc SODtlTcktDesc

XML-Schema Name:SODesc 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 SODesc 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 distro_nbr varchar212 1 1 mapped to DO_CTL_INV.ID_ICD as well.Not Yet Available TSF EXTERNAL_ID VARCHAR2(128 BYTE) Yes document_type varchar21 1 1 NA Fill application table name. null null null null Not used in SIM dc_dest_id varchar210 1 1 mapped to DO_CTL_INV.ID_PRTY_TO_ICD as well. Not Yet Available TSF_ALLOCATION SOURCE_ID NUMBER(10,0) No Contains the location number of the stock order receiving location. loc_type varchar21 1 1 Type of location in the dc_dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possible value LOC_TYPE_STORE("S"), store_type varchar21 0 1 Indicates the store type of the dc_dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes values are STORE_TYPE_COMPANY("C"), STORE_TYPE_FRANCHISE("F"), stockholding_ind varchar21 0 1 Indicates if the dc_dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes values are "Y" or "N" order_type varchar29 0 1 NA Fill application table name. null null null null Not used in SIM pick_not_before_date xs:dateTime 0 1 Not Yet Available null null null null No not used in SIM pick_not_after_date xs:dateTime 0 1 Not Yet Available ALLOCATION,RETURN ALLOCATION.DELIVERY_DATE, RETURN.NOT_AFTER_DATE DATE Fill column length. No the date that the allocation is expected to be delivered from the warehouse/not after date for Return priority number4 0 1 NA Fill application table name. null null null null Not used in SIM event_code varchar26 0 1 NA Fill application table name. null null null null Not used in SIM event_description varchar21000 0 1 NA Fill application table name. null null null null Not used in SIM carrier_code varchar24 0 1 NA SHIPMENT_CARRIER CODE VARCHAR2 4 Yes Unique code identifier for a carrier carrier_service_code varchar26 0 1 NA SHIPMENT_CARRIER_SERVICE CODE VARCHAR2 6 Yes Unique identifier that represents the delivery service route varchar210 0 1 NA Fill application table name. null null null null Not used in SIM ship_address_desc varchar230 0 1 NA Fill application table name. null null null null Not used in SIM ship_address1 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM ship_address2 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM ship_address3 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM ship_address4 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM ship_address5 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM ship_city varchar2120 0 1 NA Fill application table name. null null null null Not used in SIM ship_state varchar23 0 1 NA Fill application table name. null null null null Not used in SIM ship_zip varchar230 0 1 NA Fill application table name. null null null null Not used in SIM ship_country_id varchar23 0 1 NA Fill application table name. null null null null Not used in SIM bill_address_desc varchar230 0 1 NA Fill application table name. null null null null Not used in SIM bill_address1 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM bill_address2 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM bill_address3 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM bill_address4 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM bill_address5 varchar2240 0 1 NA Fill application table name. null null null null Not used in SIM bill_city varchar2120 0 1 NA Fill application table name. null null null null Not used in SIM bill_state varchar23 0 1 NA Fill application table name. null null null null Not used in SIM bill_zip varchar230 0 1 NA Fill application table name. null null null null Not used in SIM bill_country_id varchar23 0 1 NA Fill application table name. null null null null Not used in SIM break_by_distro varchar21 0 1 NA Fill application table name. null null null null Not used in SIM rollback_allocation varchar21 0 1 NA Fill application table name. null null null null Not used in SIM cartonization varchar21 0 1 NA Fill application table name. null null null null Not used in SIM consumer_direct varchar21 0 1 NA Fill application table name. null null null null Not used in SIM message varchar22000 0 1 NA RETURN,TRANSFER RETURN.COMMENTS,TRANSFER.TRANSFER_COMMENT VARCHAR2 2000 No comment or short description entered by the creator or processor of the return/transfer chute_type varchar26 0 1 NA Fill application table name. null null null null Not used in SIM po_nbr varchar212 0 1 NA Fill application table name. null null null null Not used in SIM parent_customer_order varchar220 0 1 NA Fill application table name. null null null null Not used in SIM order_line_costs varchar21 0 1 NA Fill application table name. null null null null Not used in SIM container_type varchar26 0 1 NA Fill application table name. null null null null Not used in SIM amount1 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount2 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount3 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount4 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount5 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount6 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM sub_total number12 0 1 NA Fill application table name. null null null null Not used in SIM gift_cost_total number12 0 1 NA Fill application table name. null null null null Not used in SIM promotion_total number12 0 1 NA Fill application table name. null null null null Not used in SIM total number12 0 1 NA Fill application table name. null null null null Not used in SIM tax_total number12 0 1 NA Fill application table name. null null null null Not used in SIM shipping_total number12 0 1 NA Fill application table name. null null null null Not used in SIM order_uda1 varchar210 0 1 NA null null null null null order_uda2 varchar210 0 1 NA Fill application table name. null null null null Not used in SIM order_uda3 varchar210 0 1 NA null null null null null order_uda4 varchar210 0 1 NA Fill application table name. null null null null Not used in SIM order_uda5 varchar210 0 1 NA Fill application table name. null null null null Not used in SIM order_uda6 varchar220 0 1 NA Fill application table name. null null null null Not used in SIM order_uda7 varchar220 0 1 NA Fill application table name. null null null null Not used in SIM order_uda8 varchar220 0 1 NA Fill application table name. null null null null Not used in SIM order_uda9 varchar260 0 1 NA Fill application table name. null null null null Not used in SIM order_uda10 varchar260 0 1 NA Fill application table name. null null null null Not used in SIM dl_comment varchar230 0 1 NA Fill application table name. null null null null Not used in SIM ship_date xs:dateTime 0 1 NA Fill application table name. null null null null Not used in SIM SODtlDesc * 0 unbounded Description is not available. not_after_date xs:dateTime 0 1 NA Fill application table name. null null null null Not used in SIM distro_parent_nbr varchar212 0 1 NA ALLOCATION DISTRIBUTION_PARENT_ID VARCHAR2 25 No A unique identifier of the parent transfer document that is associated to this allocation. exp_dc_date xs:dateTime 0 1 NA Fill application table name. null null null null Not used in SIM approval_id varchar230 0 1 NA Fill application table name. null null null null Not used in SIM approval_date xs:dateTime 0 1 NA Fill application table name. null null null null Not used in SIM from_loc_tsf_entity number10 0 1 NA Fill application table name. null null null null Not used in SIM to_loc_tsf_entity number10 0 1 NA Fill application table name. null null null null Not used in SIM inv_type varchar26 0 1 NA Fill application table name. Fill table column name. null null null used to determine unavailable in SIM which is used to find Return Reason so_status varchar21 0 1 NA Fill application table name. null null null null Not used in SIM delivery_date xs:dateTime 0 1 NA TSF_ALLOCATION DELIVERY_DATE DATE No the date that the allocation is expected to be delivered from the warehouse. context_type varchar26 0 1 This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. CODE_DETAIL, TSF_ALLOCATION, TSF CODE, CONTEXT_TYPE_ID VARCHAR2 PROM - Promotion,REPAIR - Repair Yes This field holds the functional area code to which the allocation relates to. For example promotions. valid values are context_value varchar225 0 1 This field holds the value relating to the context type like Promotion number. TSF_ALLOCATION, TSF CONTEXT_VALUE VARCHAR2 25 No This field holds value relating to the context type, e.g promotion number. delivery_slot_id varchar215 0 1 Delivery Slot Id. TSF_ALLOCATION DELIVERY_SLOT_ID VARCHAR2 15 No delivery slot id delivery_slot_desc varchar2240 0 1 Delivery slot description. DELIVERY_SLOT DESCRIPTION RIB or/and RSB or/and RSL VARCHAR2(240 BYTE) Yes Fill this description. cust_order_nbr varchar248 0 1 Contains the customer order number reference for the transfer as provided by OMS. TSF CUST_ORDER_ID VARCHAR2 128 No Customer order external identifier fulfill_order_nbr varchar248 0 1 Contains the fulfillment order number for the transfer as provided by OMS. One or more fulfillment orders could relate back to a single customer order in OMS. TSF FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier partial_delivery_ind varchar21 0 1 Indicates if the customer order can be picked and shipped partially (Y) or if it should be shipped only when complete (N). This will be mapped to the PICK_COMPLETE indicator in RWMS. A value of Y for PARTIAL_DELIVERY_IND will correspond to the value N for PICK_COMPLETE. TRANSFER ALLOW_PARTIAL_DELIVERY VARCHAR2 1 Yes Indicate if partial delivery is allowed consumer_delivery_date xs:dateTime 0 1 Indicates the desired date the delivery is required by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. consumer_delivery_time xs:dateTime 0 1 Indicates the desired time the delivery is required by the customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. ship_first_name varchar2120 0 1 Contains the first name for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in SIM ship_phonetic_first varchar2120 0 1 Contains the phonetic first name for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not Used By SIM ship_last_name varchar2120 0 1 Contains the last name for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in SIM ship_phonetic_last varchar2120 0 1 Contains the phonetic last name for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not Used By SIM ship_preferred_name varchar2120 0 1 Contains the preferred name for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not Used By SIM ship_company_name varchar2120 0 1 Contains the company name for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in SIM ship_county varchar2250 0 1 Contains the county name for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in SIM ship_phone varchar220 0 1 Contains the phone number for the delivery address on consumer-direct transfers. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not Used by SIM bill_first_name varchar2120 0 1 Contains the first name for the billing address on consumer-direct transfers for inclusion on the packing slip. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_first varchar2120 0 1 Contains the phonetic first name for the billing address on consumer-direct transfers for inclusion on the packing slip. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_last_name varchar2120 0 1 Contains the last name for the billing address on consumer-direct transfers for inclusion on the packing slip. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phonetic_last varchar2120 0 1 Contains the phonetic last name for the billing address on consumer-direct transfers for inclusion on the packing slip. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_preferred_name varchar2120 0 1 Contains the preferred name for the billing address on consumer-direct transfers for inclusion on the packing slip. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_company_name varchar2120 0 1 Contains the company name for the billing address on consumer-direct transfers for inclusion on the packing slip. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_phone varchar220 0 1 Contains the billing address phone number for customer-direct transfers for inclusion on the packing slip. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. bill_county varchar2250 0 1 Contains the county name for the billing address on consumer-direct transfers for inclusion on the packing slip. 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:SODtlDesc 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 SODtlDesc 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 dest_id varchar210 1 1 mapped to TR_LTM_ICD_MR.ID_STR_RT as well, Not Yet Available Yes Not used by SIM loc_type varchar21 1 1 Type of location in the dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes value LOC_TYPE_STORE("S"), store_type varchar21 0 1 Indicates the store type of the dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes values are STORE_TYPE_COMPANY("C"), STORE_TYPE_FRANCHISE("F"), stockholding_ind varchar21 0 1 Indicates if the dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes values are "Y" or "N" item_id varchar225 1 1 mapped to TR_LTM_ICD_MR.ID_ITM as well. Not Yet Available ALLOCATION,RTV_LINE_ITEM,TSF_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier. requested_unit_qty number12_4 1 1 mapped to TR_LTM_ICD_MR.QU_ITM as well.Not Yet Available ALLOCATION,TSF_LINE_ITEM,RTV_LINE_ITEM QUANTITY NUMBER 20,4 No Quantity. retail_price number20_4 0 1 NA Fill application table name. null null null null Not used in SIM selling_uom varchar24 0 1 NA Fill application table name. null null null null Not used in SIM ticket_type varchar24 0 1 NA Fill application table name. null null null null Not used in SIM priority number4 0 1 NA Fill application table name. null null null null Not used in SIM store_ord_mult varchar21 0 1 NA Fill application table name. null null null null Not used in SIM expedite_flag varchar21 0 1 NA Fill application table name. null null null null Not used in SIM order_line_nbr number3 0 1 NA Fill application table name. null null null null Not used in SIM amount1 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount2 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount3 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount4 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount5 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM amount6 number16_2 0 1 NA Fill application table name. null null null null Not used in SIM tax_percent number12_4 0 1 NA Fill application table name. null null null null Not used in SIM item_status varchar21 0 1 NA Fill application table name. null null null null Not used in SIM component_ticketing_distro_nbr varchar212 0 1 NA Fill application table name. null null null null Not used in SIM in_store_date xs:dateTime 0 1 NA Fill application table name. null null null null Not used in SIM total number12_4 0 1 NA Fill application table name. null null null null not used in SIM gift_cost number12_4 0 1 NA Fill application table name. null null null null Not used in SIM shipping number12_4 0 1 NA Fill application table name. null null null null Not used in SIM promotion number10 0 1 NA Fill application table name. null null null null Not used in SIM sub_total number12_4 0 1 NA Fill application table name. null null null null Not used in SIM tax number12_4 0 1 NA Fill application table name. null null null null Not used in SIM order_detail_uda1 varchar210 0 1 NA Fill application table name. null null null null Not used in SIM order_detail_uda2 varchar210 0 1 NA Fill application table name. null null null null Not used in SIM order_detail_uda3 varchar210 0 1 NA Fill application table name. null null null null Not used in SIM order_detail_uda4 varchar220 0 1 NA Fill application table name. null null null null Not used in SIM order_detail_uda5 varchar220 0 1 NA Fill application table name. null null null null Not used in SIM transaction_uom varchar24 0 1 Holds the original transaction unit of measure to be passed on to the store system. It is only used for customer direct orders coming from the order management system. All quantities on the payload are expressed in items standard unit of measure. No SODtlTcktDesc * 0 unbounded Description is not available.

XML-Schema Name:SODtlTcktDesc 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 SODtlTcktDesc 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 distro_nbr varchar212 1 1 NA Fill application table name. null null null No Not used in SIM document_type varchar21 0 1 NA Fill application table name. null null null null Not used in SIM item_id varchar225 0 1 NA Fill application table name. null null null No Not used in SIM dest_id varchar210 0 1 NA Fill application table name. null null null No Not used in SIM component_item_id varchar225 1 1 NA Fill application table name. null null null null Not used in SIM retail_price number20_4 0 1 NA Fill application table name. null null null null Not used in SIM selling_uom varchar24 0 1 NA Fill application table name. null null null null Not used in SIM