Retail Integration Mappings Report Release:15.0.0

(Retail Merchandising System)

Application Retail Merchandising System Target Name Space http://www.oracle.com/retail/integration/base/bo/TsfDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure TsfDesc TsfDtl TsfDtlTckt

XML-Schema Name:TsfDesc 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 TsfDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description tsf_no number12 1 1 The number that uniquely identifies the transfer. tsfhead tsf_no number 12 Yes The number to uniquely identify the transfer. doc_type varchar21 1 1 Defaulted to 'T' for RMS transfers. n/a n/a n/a n/a Yes Defaults to T for RMS transfers. physical_from_loc number10 1 1 Physical location that the from_loc belongs to. store, wh, partner store, physical_wh, partner_id number 10 Yes Physical location that the from_loc belongs to. from_loc_type varchar21 1 1 Type of location in the from_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. tsfhead from_loc_type varchar2 1 Yes Type of location in the location field. Valid values are S = Store, W = Warehouse, E = External Finisher from_store_type varchar21 0 1 Indicates the store type of the from_loc store. Only populated if from_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 No Indicates the store type of the from_loc store. Only populated if from_loc_type is 'S'. Valid values are 'C' = company store, 'F' = franchise store. from_stockholding_ind varchar21 0 1 Indicates if the from_loc store is stockholding or not. Only populated if from_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. store stockholding_ind varchar2 1 No Indicates if the from_loc store is stockholding or not. Only populated if from_loc_type is 'S'. Valid values are 'Y' = yes, 'N' = no. from_loc varchar210 1 1 The location number of the transfer from location. This field will contain either a store or warehouse number based on the from_loc_type field. tsfhead from_loc varchar2 10 Yes The number of the Transfer From location. This field contains either a store or warehouse number, based on the from_loc_type field. physical_to_loc number10 1 1 Physical location that the to_loc belongs to. store, wh, partner store, physical_wh, partner_id number 10 Yes Physical location of the to_loc. to_loc_type varchar21 1 1 Type of location in the to_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. tsfhead to_loc_type varchar2 1 Yes Type of location noted in the location field. Valid values are S (store), W (warehouse), and E(external finisher). to_store_type varchar21 0 1 Indicates the store type of the to_loc store. Only populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 No Indicates the store type of the to_loc store. Only populated if to_loc_type is 'S'. Valid values are 'C' = company store, 'F' = franchise store. to_stockholding_ind varchar21 0 1 Indicates if the to_loc store is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. store stockholding_ind varchar2 1 No Indicates if the to_loc store is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are 'Y' = yes, 'N' = no. to_loc varchar210 1 1 The location number of the transfer to location. This field will contain either a store or warehouse number based on the to_loc_type field. tsfhead to_loc varchar2 10 Yes The location number of the Transfer To location. This field contains either a store, warehouse, or external finisher based on the to_loc_type field. tsf_type varchar26 1 1 A code for the type of the transfer, such as SR - Store Requisition CO - Customer Order RV - RTV CF - Confirmation NS - Non-Salable AD - Administrative MR - Manual Requisitions PL - PO-Linked Transfer. tsfhead tsf_type varchar2 6 Yes A code for the type of the transfer, such as SR (Store Requisition), CO (Customer Order), RV (RTV), CF (Confirmation), NS (Non-saleable), AD (Administrative), MR (Manual Requisitions), PL (PO-Linked Transfer). pick_not_before_date xs:dateTime 1 1 The date the transfer was approved. tsfhead approval_date date Fill column length. Yes The date the transfer was approved. pick_not_after_date xs:dateTime 1 1 This is calculated as transfer approval date + days from code_detail where code_type = 'DEFT' and code = 'DATE'. n/a n/a n/a n/a Yes This is calculated as transfer approval date + days from code_detail where code_type = 'DEFT' and code = 'DATE'. order_type varchar29 1 1 This is the order type associated with transfers. RWMS uses this value to determine how to distribute stock orders. Valid values (e.g. Automatic, Manual, etc.) are on the order_types table. n/a n/a n/a n/a Yes This is the order type associated with transfers. RWMS uses this value to determine how to distribute stock orders. Valid values (e.g. Automatic, Manual, etc.) are on the order_types table. If transfer type is 'CO', set this to 'MANUAL'. Otherwise, set this to the default_order_type from system_options. priority number4 0 1 Reserved for future use; currently defaulted to 1. n/a n/a n/a n/a No Not used by RMS. break_by_distro varchar21 1 1 Set to 'Y' if the deliver_type for the transfer's customer is 'S'. Otherwise, set to N. n/a n/a n/a n/a Yes Set to Y if the delivery type for the customer order is S. Otherwise, set to N. delivery_date xs:dateTime 0 1 The earliest date that the transfer can be delivered to the store. This will be populated if the transfer type is PO-Linked. tsfhead delivery_date RIBDate Fill column length. No The earliest date that the transfer can be delivered to the store. This is populated if the transfer type is PO-Linked. cust_name varchar240 0 1 The name of the customer. n/a n/a n/a n/a No Not used by RMS. deliver_add1 varchar2240 0 1 For customer order transfers, this column contains the first line of the delivery address of the customer. ordcust deliver_add1 varchar2 240 No For customer order transfers, this column contains the first line of the delivery address of the customer. deliver_add2 varchar2240 0 1 For customer order transfers, this column contains the second line of the delivery address of the customer. ordcust deliver_add2 varchar2 240 No For customer order transfers, this column contains the second line of the delivery address of the customer. deliver_city varchar2120 0 1 For customer order transfers, this column contains the city portion of the delivery address. ordcust deliver_city varchar2 120 No For customer order transfers, this column contains the city portion of the delivery address. deliver_state varchar23 0 1 For customer order transfers, this column contains the state portion of the delivery address. ordcust deliver_state varchar2 3 No For customer order transfers, this column contains the state portion of the delivery address. deliver_post varchar230 0 1 For customer order transfers, this column contains the postal code portion of the delivery address. ordcust deliver_post varchar2 30 No For customer order transfers, this column contains the postal code portion of the delivery address. deliver_country_id varchar23 0 1 For customer order transfers, this column contains the country portion of the delivery address. ordcust deliver_country_id varchar2 3 No For customer order transfers, this column contains the country portion of the delivery address. message varchar22000 0 1 Any comments associated with the transfer. tsfhead comment_desc varchar2 2000 No Any comments associated with the transfer. TsfDtl * 0 unbounded Child node - see layout below. tsf_parent_no number12 0 1 Identifies the transfer at the level above the transfer tsfhead tsf_parent_no number 12 No Identifies the transfer at the level above the transfer exp_dc_date xs:dateTime 0 1 Date the inventory is expected to arrive at the DC. tsfhead exp_dc_date RIBDate Fill column length. No Date on which the inventory is expected to arrive at the DC. approval_id varchar230 0 1 The ID of the user who approved the transfer tsfhead approval_id varchar2 30 No The ID of the user who approved the transfer. approval_date xs:dateTime 0 1 Date the transfer was approved tsfhead approval_date RIBDate Fill column length. No Date on which the transfer was approved from_loc_tsf_entity number10 0 1 Transfer entity of the from location. store, wh, partner tsf_entity_id number 10 No Transfer entity of the from location. to_loc_tsf_entity number10 0 1 Transfer entity of the to location. store, wh, partner tsf_entity_id number 10 No Transfer entity of the to location. inv_type varchar26 0 1 A specific transfer can only contain available or unavailable merchandise, never a combination of both. This column will indicate whether the transfer is for Available inventory or Unavailable inventory. tsfhead inventory_type varchar2 6 Yes A specific transfer can only contain available or unavailable merchandise, never a combination of both. This column will indicate whether the transfer is for Available inventory or Unavailable inventory. tsf_status varchar21 0 1 Status of the transfer. tsfhead status varchar2 1 Yes Status of the transfer. not_after_date xs:dateTime 0 1 The last day delivery of the transfer will be accepted tsfhead not_after_date date Fill column length. No The last day delivery of the transfer will be accepted. context_type varchar26 0 1 Can be used to indicate the transfer reason or category, e.g. 'promotion'. tsfhead context_type varchar2 6 No Holds the functional area code to which the transfer relates to for example - PROM(Promotions). context_value varchar225 0 1 Further info to indicate the reason or category for the transfer. For instance, if context_type was 'promotion', this could be the promotion number. tsfhead context_value varchar2 25 No Holds the value relating to the context type. For example, if context type is Promotion, this field could be used to for the promotion number. delivery_slot_id varchar215 0 1 Specifies when the transfer quantity is needed at the location. tsfhead delivery_slot_id varchar2 15 No Specifies when the transfer quantity is needed at the location. delivery_slot_desc varchar2240 0 1 Delivery slot description. delivery_slot delivery_slot_desc varchar2 240 No Delivery slot description cust_order_nbr varchar248 0 1 For customer order transfers, this column contains the master customer order number from the Order Management System. ordcust customer_order_no varchar2 48 No For customer order transfers, this column contains the master customer order number from the Order Management System. 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. ordcust fulfill_order_no varchar2 48 No If the transfer is associated to a customer order, this column contains the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. carrier_code varchar24 0 1 Indicates the carrier the order is to be shipped with, if specified on the order. ordcust carrier_code varchar2 4 No If the transfer is associated to a customer order, this column contains the carrier the order is to be shipped with. carrier_service_code varchar26 0 1 Indicates the method that was selected for shipping by the customer placing the order (e.g. Standard Shipping, Overnight, etc.). ordcust carrier_service_code varchar2 6 No If the transfer is associated to a customer order, this column contains the shipping method that was selected by the customer. Valid values are defined as codes for code type 'CSVC' -- 'F'(Free 2 Day Shipping), 'D'(Discounted 4 Day Shipping), 'O'(Overnight Shipping), 'P'(Premium Next Business Day Delivery), 'S'(Standard Shipping). consumer_delivery_date xs:dateTime 0 1 Indicates the desired date the delivery is required by the customer. ordcust consumer_delivery_date date Fill column length. No If the transfer is associated to a customer order, this column contains the desired date the delivery is required by the customer. consumer_delivery_time xs:dateTime 0 1 Indicates the desired time the delivery is required by the customer. ordcust consumer_delivery_time date Fill column length. No If the transfer is associated to a customer order, this column contains the desired time the delivery is required by the customer. deliver_first_name varchar2120 0 1 For customer order transfers, this column contains the first name for the delivery address on the order. ordcust deliver_first_name varchar2 120 No For customer order transfers, this column contains the first name for the delivery address on the order. deliver_phonetic_first varchar2120 0 1 For customer order transfers, this column contains the phonetic first name for the delivery address on the order. ordcust deliver_phonetic_first varchar2 120 No For customer order transfers, this column contains the phonetic first name for the delivery address on the order. deliver_last_name varchar2120 0 1 For customer order transfers, this column contains the last name for the delivery address on the order. ordcust deliver_last_name varchar2 120 No For customer order transfers, this column contains the last name for the delivery address on the order. deliver_phonetic_last varchar2120 0 1 For customer order transfers, this column contains the phonetic last name for the delivery address on the order. ordcust deliver_phonetic_last varchar2 120 No For customer order transfers, this column contains the phonetic last name for the delivery address on the order. deliver_preferred_name varchar2120 0 1 For customer order transfers, this column contains the preferred name for the delivery address on the order. ordcust deliver_preferred_name varchar2 120 No For customer order transfers, this column contains the preferred name for the delivery address on the order. deliver_company_name varchar2120 0 1 For customer order transfers, this column contains the company name for the delivery address on the order. ordcust deliver_company_name varchar2 120 No For customer order transfers, this column contains the company name for the delivery address on the order. deliver_add3 varchar2240 0 1 For customer order transfers, this column contains the third line of the delivery address of the customer. ordcust deliver_add3 varchar2 240 No For customer order transfers, this column contains the third line of the delivery address of the customer. deliver_county varchar2250 0 1 For customer order transfers, this column contains the county portion of the delivery address. ordcust deliver_county varchar2 250 No For customer order transfers, this column contains the county portion of the delivery address. deliver_phone varchar220 0 1 For customer order transfers, this column contains the delivery phone number. ordcust deliver_phone varchar2 20 No For customer order transfers, this column contains the delivery phone number. bill_first_name varchar2120 0 1 For customer order transfers, this column contains the first name for the billing address on the order. ordcust bill_first_name varchar2 120 No For customer order transfers, this column contains the first name for the billing address on the order. bill_phonetic_first varchar2120 0 1 For customer order transfers, this column contains the phonetic first name for the billing address on the order. ordcust bill_phonetic_first varchar2 120 No For customer order transfers, this column contains the phonetic first name for the billing address on the order. bill_last_name varchar2120 0 1 For customer order transfers, this column contains the last name for the billing address on the order. ordcust bill_last_name varchar2 120 No For customer order transfers, this column contains the last name for the billing address on the order. bill_phonetic_last varchar2120 0 1 For customer order transfers, this column contains the phonetic last name for the billing address on the order. ordcust bill_phonetic_last varchar2 120 No For customer order transfers, this column contains the phonetic last name for the billing address on the order. bill_preferred_name varchar2120 0 1 For customer order transfers, this column contains the preferred name for the billing address on the order. ordcust bill_preferred_name varchar2 120 No For customer order transfers, this column contains the preferred name for the billing address on the order. bill_company_name varchar2120 0 1 For customer order transfers, this column contains the company name for the billing address on the order. ordcust bill_company_name varchar2 120 No For customer order transfers, this column contains the company name for the billing address on the order. bill_add1 varchar2240 0 1 For customer order transfers, this column contains the first line of the billing address of the customer. ordcust bill_add1 varchar2 240 No For customer order transfers, this column contains the first line of the billing address of the customer. bill_add2 varchar2240 0 1 For customer order transfers, this column contains the second line of the billing address of the customer. ordcust bill_add2 varchar2 240 No For customer order transfers, this column contains the second line of the billing address of the customer. bill_add3 varchar2240 0 1 For customer order transfers, this column contains the third line of the billing address of the customer. ordcust bill_add3 varchar2 240 No For customer order transfers, this column contains the third line of the billing address of the customer. bill_county varchar2250 0 1 For customer order transfers, this column contains the county portion of the billing address. ordcust bill_county varchar2 250 No For customer order transfers, this column contains the county portion of the billing address. bill_city varchar2120 0 1 For customer order transfers, this column contains the city portion of the billing address. ordcust bill_city varchar2 120 No For customer order transfers, this column contains the city portion of the billing address. bill_country varchar23 0 1 For customer order transfers, this column contains the country portion of the billing address. ordcust bill_country_id varchar2 3 No For customer order transfers, this column contains the country portion of the billing address. bill_post varchar230 0 1 For customer order transfers, this column contains the postal code portion of the billing address. ordcust bill_post varchar2 30 No For customer order transfers, this column contains the postal code portion of the billing address. bill_state varchar23 0 1 For customer order transfers, this column contains the state portion of the billing address. ordcust bill_state varchar2 3 No For customer order transfers, this column contains the state portion of the billing address. bill_phone varchar220 0 1 For customer order transfers, this column contains the billing phone number. ordcust bill_phone varchar2 20 No For customer order transfers, this column contains the billing phone number. partial_delivery_ind varchar21 0 1 For customer order transfers, this column indicates if the order can be picked and shipped partially or if it should be shipped only when complete. Valid values are 'Y' or 'N'. ordcust partial_delivery_ind varchar2 1 No For customer order transfers, this column indicates if the order can be picked and shipped partially or if it should be shipped only when complete. Valid values are 'Y' or 'N'. consumer_direct varchar21 1 1 Indicates the order as being consumer direct (Y) or not (N). An order is consumer direct if it is a customer order. n/a n/a n/a n/a Yes Indicates the order as being consumer direct (Y) or not (N). An order is consumer direct if it is a customer order.

XML-Schema Name:TsfDtl 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 TsfDtl in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description item varchar225 1 1 Unique alphanumeric value that identifies the item. tsfdetail item varchar2 25 Yes Unique alphanumeric value to identify the item. tsf_qty number12_4 1 1 The total quantity of the item reserved at the from location for this transfer. This field is set back to zero each time the stock is either merged into a 'Combined Transfer' or shipped. tsfdetail tsf_qty number 12 Yes The total quantity of the item reserved at the From location for this transfer.This field is set back to zero each time the stock is either merged into a Combined Transfer or shipped. price number20_4 0 1 Contains the unit retail price in the selling unit of measure for the item/location combination. This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input. item_loc selling_unit_retail number 20 No Contains the unit retail price in the selling unit of measure for the item/location combination. selling_uom varchar24 0 1 Contains the selling unit of measure of the item. This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input. item_loc selling_uom varchar2 4 No Contains the selling unit of measure of the item. priority number4 0 1 This field is currently defaulted to 1. It is reserved for future use. n/a n/a n/a n/a No Not used by RMS. expedite_flag varchar21 0 1 If TSFHEAD.FREIGHT_CODE is 'E', expedite_flag is 'Y'. Otherwise, expedite_flag is 'N'. n/a n/a n/a n/a Yes If TSFHEAD.FREIGHT_CODE is E, expedite_flag is Y. Otherwise, expedite_flag is N. store_ord_mult varchar21 0 1 The multiple in which the item needs to be shipped from a warehouse to the location. item_loc store_ord_mult varchar2 1 No The multiple in which the item must be shipped from a warehouse to the location. tsf_po_link_no number12 0 1 A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (i.e. warehouse) on the transfer to fulfill the transfer quantity to the to location (i.e store) on the transfer. tsfdetail tsf_po_link_no number 12 No A reference number to link the item on the transfer to any purchase orders that have been created to allow the From location (warehouse) on the transfer to fulfill the transfer quantity to the To location (store) on the transfer. ticket_type_id varchar24 0 1 The ticket type associated with the item. item_ticket ticket_type_id varchar2 4 No The ticket type associated with the item. TsfDtlTckt * 0 unbounded Child Node - see layout below. inv_status number2 0 1 Contains the inventory status, if one exists, for the transfer detail record. The inventory status field corresponds to the inventory status type found on the INV_STATUS_TYPES table. tsfdetail inv_status number 2 No Contains the inventory status, if one exists, for the transfer detail record. The inventory status field corresponds to the inventory status type found on the INV_STATUS_TYPES table. 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 item's standard unit of measure. ordcust_detail transaction_uom varchar2 4 No For customer order transfers, this column contains the original unit of measure in which the customer had placed the order in OMS.

XML-Schema Name:TsfDtlTckt 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 TsfDtlTckt in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description comp_item varchar225 1 1 Alphanumeric value that identifies the item within the pack. packitem_breakout item varchar2 25 Yes Alphanumeric value to identify the item within the pack. comp_price number20_4 0 1 Contains the unit retail price in the selling unit of measure for the comp item/location combination. This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input. item_loc selling_unit_retail number 20 No Contains the unit retail price in the selling unit of measure for the comp item/location combination. comp_selling_uom varchar24 0 1 Contains the selling unit of measure for the comp item. This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input. item_loc selling_uom varchar2 4 No Contains the selling unit of measure for the comp item.