Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For TsfDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
tsf_no |
number10 |
1 |
1 |
The number that uniquely identifies the transfer. |
tsfhead |
tsf_no |
null |
null |
Yes |
The number that uniquely identifies the transfer. |
doc_type |
varchar21 |
1 |
1 |
Defaulted to 'T' for RMS transfers. |
* |
* |
null |
null |
Yes |
Defaulted to 'T' for RMS transfers. |
physical_from_loc |
number10 |
1 |
1 |
Physical location that the from_loc belongs to. |
store, wh |
store, physical_wh |
number |
10 |
Yes |
Physical location that the from_loc belongs to. |
from_loc_type |
varchar21 |
1 |
1 |
Type of location in the location field. Valid values are: S = Store W = Warehouse |
item_loc |
loc_type |
null |
null |
Yes |
Type of location in the location field. Valid values are: S = Store W = Warehouse |
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 |
null |
null |
Yes |
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_to_loc |
number10 |
1 |
1 |
Physical location that the to_loc belongs to. |
store, wh |
store, physical_wh |
number |
10 |
Yes |
Physical location that the to_loc belongs to. |
to_loc_type |
varchar21 |
1 |
1 |
Type of location in the location field. Valid values are: S = Store W = Warehouse |
item_loc |
loc_type |
null |
null |
Yes |
Type of location in the location field. Valid values are: S = Store W = Warehouse |
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 |
null |
null |
Yes |
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. |
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 |
null |
null |
Yes |
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. |
pick_not_before_date |
xs:dateTime |
1 |
1 |
The date the transfer was approved. |
tsfhead |
approval_date |
null |
null |
Yes |
The date the transfer was approved. |
pick_not_after_date |
xs:dateTime |
1 |
1 |
This is a calculated date. |
* |
* |
null |
null |
Yes |
This is a calculated date. |
default_order_type |
varchar29 |
1 |
1 |
This is the default 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. |
system_options |
default_order_type |
null |
null |
Yes |
This is the default 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. |
priority |
number4 |
0 |
1 |
Reserved for future use; currently defaulted to 1. |
* |
* |
null |
null |
No |
Reserved for future use; currently defaulted to 1. |
break_by_distro |
varchar21 |
1 |
1 |
Set to 'Y' if the deliver_type for the transfer's customer is 'S'. Otherwise, set to N. |
* |
* |
null |
null |
Yes |
Set to 'Y' if the deliver_type for the transfer's customer 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 will be populated if the transfer type is PO-Linked. |
cust_name |
varchar240 |
0 |
1 |
The name of the customer. |
customer |
cust_name |
null |
null |
No |
The name of the customer. |
deliver_add1 |
varchar2240 |
0 |
1 |
The delivery address for the customer/order relationship. |
ordcust |
deliver_add1 |
null |
null |
No |
The delivery address for the customer/order relationship. |
deliver_add2 |
varchar2240 |
0 |
1 |
Contains an optional second line of the delivery address for the customer/order relationship. |
ordcust |
deliver_add2 |
varchar2 |
240 |
No |
Contains an optional second line of the delivery address for the customer/order relationship. |
deliver_city |
varchar2120 |
0 |
1 |
Contains the city in which the customer order will be delivered. |
ordcust |
deliver_city |
varchar2 |
120 |
No |
Contains the city in which the customer order will be delivered. |
deliver_state |
varchar23 |
0 |
1 |
Contains the state in which the customer order will be delivered. |
ordcust |
deliver_state |
varchar2 |
3 |
No |
Contains the state in which the customer order will be delivered. |
deliver_post |
varchar230 |
0 |
1 |
Contains the postal code in which the customer order will be delivered. |
ordcust |
deliver_post |
varchar2 |
30 |
No |
Contains the postal code in which the customer order will be delivered. |
deliver_country_id |
varchar23 |
0 |
1 |
Contains the country in which the customer order will be delivered. |
ordcust |
deliver_country_id |
varchar2 |
3 |
No |
Contains the country in which the customer order will be delivered. |
message |
varchar22000 |
0 |
1 |
Any comments associated with the transfer. |
tsfhead |
comment_desc |
null |
null |
No |
Any comments associated with the transfer. |
TsfDtl
|
*
|
0
|
unbounded
|
Child node - see layout below.
|
|
|
|
|
|
|
tsf_parent_no |
number10 |
0 |
1 |
Transfer parent number |
tsfhead |
tsf_parent_no |
number |
10 |
No |
Transfer parent number |
exp_dc_date |
xs:dateTime |
0 |
1 |
Date the inventory is expected to arrive at the DC. |
tsfhead |
exp_dc_date |
RIBDate |
* |
No |
Date 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 |
null |
null |
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 the transfer was approved |
from_loc_tsf_entity |
number10 |
0 |
1 |
Transfer entity of the from location |
store, wh |
tsf_entity_id |
null |
null |
No |
Transfer entity of the from location |
to_loc_tsf_entity |
number10 |
0 |
1 |
Transfer entity of the to location |
store, wh |
tsf_entity_id |
null |
null |
No |
Transfer entity of the to location |
inv_type |
varchar26 |
0 |
1 |
Type of inventory |
tsfhead |
inventory_type |
null |
null |
No |
Type of inventory |
tsf_status |
varchar21 |
0 |
1 |
Status of the transfer. |
tsfhead |
status |
null |
null |
No |
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 |
null |
null |
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 |
null |
null |
No |
Can be used to indicate the transfer reason or category, e.g. 'promotion'. |
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 |
null |
null |
No |
Further info to indicate the reason or category for the transfer. For instance, if context_type was 'promotion', this could be the promotion number. |
delivery_slot_id |
varchar215 |
0 |
1 |
Delivery Slot Id. |
NA |
NA |
NA |
NA |
NA |
NA |
delivery_slot_desc |
varchar2240 |
0 |
1 |
Delivery slot description. |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfTsfDesc:ExtOfTsfDesc
|
*
|
0
|
1
|
Provide an extension hook to customize TsfDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|