tsf_no |
tsfhead |
tsf_no |
Yes |
The number that
uniquely identifies the transfer. |
doc_type |
* |
* |
Yes |
Defaulted to 'T'
for RMS transfers. |
physical_from_loc |
store, wh |
store, physical_wh |
Yes |
Physical
location that the from_loc belongs to. |
from_loc_type |
item_loc |
loc_type |
Yes |
Type of location
in the location field. Valid values are: S = Store W =
Warehouse |
from_loc |
tsfhead |
from_loc |
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 |
store, wh |
store, physical_wh |
Yes |
Physical
location that the to_loc belongs to. |
to_loc_type |
item_loc |
loc_type |
Yes |
Type of location
in the location field. Valid values are: S = Store W =
Warehouse |
to_loc |
tsfhead |
to_loc |
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 |
tsfhead |
tsf_type |
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 |
tsfhead |
approval_date |
Yes |
The date the
transfer was approved. |
pick_not_after_date |
* |
* |
Yes |
This is a
calculated date. |
default_order_type |
system_options |
default_order_type |
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 |
* |
* |
No |
Reserved for
future use; currently defaulted to 1. |
break_by_distro |
* |
* |
Yes |
Set to 'Y' if
the deliver_type for the transfer's customer is 'S'. Otherwise, set to
N. |
delivery_date |
tsfhead |
delivery_date |
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 |
customer |
cust_name |
No |
The name of the
customer. |
deliver_add1 |
ordcust |
deliver_add1 |
No |
The delivery
address for the customer/order relationship. |
deliver_add2 |
ordcust |
deliver_add2 |
No |
Contains an
optional second line of the delivery address for the customer/order
relationship. |
deliver_city |
ordcust |
deliver_city |
No |
Contains the
city in which the customer order will be delivered. |
deliver_state |
ordcust |
deliver_state |
No |
Contains the
state in which the customer order will be delivered. |
deliver_post |
ordcust |
deliver_post |
No |
Contains the
postal code in which the customer order will be delivered. |
deliver_country_id |
ordcust |
deliver_country_id |
No |
Contains the
country in which the customer order will be delivered. |
message |
tsfhead |
comment_desc |
No |
Any comments
associated with the transfer. |
TsfDtl |
* |
* |
* |
Child node - see
layout below. |
tsf_parent_no |
tsfhead |
tsf_parent_no |
No |
Transfer parent
number |
exp_dc_date |
tsfhead |
exp_dc_date |
No |
Date the
inventory is expected to arrive at the DC. |
approval_id |
tsfhead |
approval_id |
No |
The ID of the
user who approved the transfer |
approval_date |
tsfhead |
approval_date |
No |
Date the
transfer was approved |
from_loc_tsf_entity |
store, wh |
tsf_entity_id |
No |
Transfer entity
of the from location |
to_loc_tsf_entity |
store, wh |
tsf_entity_id |
No |
Transfer entity
of the to location |
inv_type |
tsfhead |
inventory_type |
No |
Type of
inventory |
tsf_status |
tsfhead |
status |
No |
Status of the
transfer. |
not_after_date |
tsfhead |
not_after_date |
No |
The last day
delivery of the transfer will be accepted |
context_type |
tsfhead |
context_type |
No |
Can be used to
indicate the transfer reason or category, e.g. 'promotion'. |
context_value |
tsfhead |
context_value |
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. |