This is root element of this document which contains name space definitions for the document elements. Description is not available. Alphanumeric value that identifies the item within the pack. 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. 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. Description is not available. Unique alphanumeric value that identifies the item. 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. 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. 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. This field is currently defaulted to 1. It is reserved for future use. If TSFHEAD.FREIGHT_CODE is 'E', expedite_flag is 'Y'. Otherwise, expedite_flag is 'N'. The multiple in which the item needs to be shipped from a warehouse to the location. 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. The ticket type associated with the item. Child Node - see layout below. 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. 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. Description is not available. The number that uniquely identifies the transfer. Defaulted to 'T' for RMS transfers. Physical location that the from_loc belongs to. Type of location in the from_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. 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. 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. 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. Physical location that the to_loc belongs to. Type of location in the to_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. 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. 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. 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. 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. The date the transfer was approved. This is calculated as transfer approval date + days from code_detail where code_type = 'DEFT' and code = 'DATE'. 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. Reserved for future use; currently defaulted to 1. Set to 'Y' if the deliver_type for the transfer's customer is 'S'. Otherwise, set to N. The earliest date that the transfer can be delivered to the store. This will be populated if the transfer type is PO-Linked. The name of the customer. For customer order transfers, this column contains the first line of the delivery address of the customer. For customer order transfers, this column contains the second line of the delivery address of the customer. For customer order transfers, this column contains the city portion of the delivery address. For customer order transfers, this column contains the state portion of the delivery address. For customer order transfers, this column contains the postal code portion of the delivery address. For customer order transfers, this column contains the country portion of the delivery address. Any comments associated with the transfer. Child node - see layout below. Identifies the transfer at the level above the transfer Date the inventory is expected to arrive at the DC. The ID of the user who approved the transfer Date the transfer was approved Transfer entity of the from location. Transfer entity of the to location. 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. Status of the transfer. The last day delivery of the transfer will be accepted Can be used to indicate the transfer reason or category, e.g. 'promotion'. Further info to indicate the reason or category for the transfer. For instance, if context_type was 'promotion', this could be the promotion number. Specifies when the transfer quantity is needed at the location. Delivery slot description. For customer order transfers, this column contains the master customer order number from the Order Management System. 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. Indicates the carrier the order is to be shipped with, if specified on the order. Indicates the method that was selected for shipping by the customer placing the order (e.g. Standard Shipping, Overnight, etc.). Indicates the desired date the delivery is required by the customer. Indicates the desired time the delivery is required by the customer. For customer order transfers, this column contains the first name for the delivery address on the order. For customer order transfers, this column contains the phonetic first name for the delivery address on the order. For customer order transfers, this column contains the last name for the delivery address on the order. For customer order transfers, this column contains the phonetic last name for the delivery address on the order. For customer order transfers, this column contains the preferred name for the delivery address on the order. For customer order transfers, this column contains the company name for the delivery address on the order. For customer order transfers, this column contains the third line of the delivery address of the customer. For customer order transfers, this column contains the county portion of the delivery address. For customer order transfers, this column contains the delivery phone number. For customer order transfers, this column contains the first name for the billing address on the order. For customer order transfers, this column contains the phonetic first name for the billing address on the order. For customer order transfers, this column contains the last name for the billing address on the order. For customer order transfers, this column contains the phonetic last name for the billing address on the order. For customer order transfers, this column contains the preferred name for the billing address on the order. For customer order transfers, this column contains the company name for the billing address on the order. For customer order transfers, this column contains the first line of the billing address of the customer. For customer order transfers, this column contains the second line of the billing address of the customer. For customer order transfers, this column contains the third line of the billing address of the customer. For customer order transfers, this column contains the county portion of the billing address. For customer order transfers, this column contains the city portion of the billing address. For customer order transfers, this column contains the country portion of the billing address. For customer order transfers, this column contains the postal code portion of the billing address. For customer order transfers, this column contains the state portion of the billing address. For customer order transfers, this column contains the billing phone number. 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'. Indicates the order as being consumer direct (Y) or not (N). An order is consumer direct if it is a customer order. This type can hold a number of digits count 12 and fraction digit count of 4. This type can hold a string of max length of 25 characters. This type can hold a string of max length of 10 characters. This type can hold a string of max length of 10 characters. This type can hold a string of max length of 240 characters. This type can hold a number of digits count 4. This type can hold a string of max length of 30 characters. This type can hold a string of max length of 3 characters. This type can hold a string of max length of 120 characters. This type can hold a string of max length of 6 characters. This type can hold a number of digits count 2. This type can hold a string of max length of 4 characters. This type can hold a string of max length of 2000 characters. This type can hold a string of max length of 40 characters. This type can hold a number of digits count 20 and fraction digit count of 4. This type can hold a number of digits count 10. This type can hold a string of max length of 1 characters. This type can hold a string of max length of 9 characters. This type can hold a string of max length of 48 characters. This type can hold a string of max length of 250 characters. This type can hold a string of max length of 20 characters. This type can hold a number of digits count 12.