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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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. |