Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XTsfDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
tsf_no |
number10 |
1 |
1 |
Number that uniquely identifies the transfer. |
tsfhead |
tsf_no |
null |
null |
Yes |
Number that uniquely identifies the transfer. |
from_loc_type |
varchar21 |
1 |
1 |
The location type of the from location. |
tsfhead |
from_loc_type |
null |
null |
Yes |
The location type of the From location. |
from_loc |
varchar210 |
1 |
1 |
The location number of the from location. |
tsfhead |
from_loc |
null |
null |
Yes |
The location number of the From location. |
to_loc_type |
varchar21 |
1 |
1 |
The location type of the to location. |
tsfhead |
to_loc_type |
null |
null |
Yes |
The location type of the To location. |
to_loc |
varchar210 |
1 |
1 |
The location number of the to location. |
tsfhead |
to_loc |
null |
null |
Yes |
The location number of the To location. |
delivery_date |
xs:dateTime |
0 |
1 |
The earliest date the transfer can be delivered. |
tsfhead |
delivery_date |
null |
null |
No |
The earliest date the transfer can be delivered. |
dept |
number4 |
0 |
1 |
The department number associated with the transfer. |
tsfhead |
dept |
null |
null |
No |
The department number associated with the transfer. |
routing_code |
varchar21 |
0 |
1 |
If the freight status is expedite, this is a code indicating more detailed freight info. |
tsfhead |
routing_code |
null |
null |
No |
If the freight status is expedite, this code indicates more detailed freight information. |
freight_code |
varchar21 |
0 |
1 |
A code indicating the freight status of the transfer (e.g. normal, expedite, etc.). |
tsfhead |
freight_code |
null |
null |
No |
A code indicating the freight status of the transfer (such as normal and expedite). |
tsf_type |
varchar26 |
0 |
1 |
A code indicating the type of transfer (e.g. store requisition, book transfer, etc.). |
tsfhead |
tsf_type |
null |
null |
No |
A code indicating the type of transfer (such as store requisition and book transfer). |
XTsfDtl
|
*
|
0
|
unbounded
|
Child node - see layout below.
|
|
|
|
|
|
|
status |
varchar21 |
0 |
1 |
A code indicating the status of the transfer (e.g. approved, closed, etc.). |
tsfhead |
status |
null |
null |
No |
A code indicating the status of the transfer, such as Approved and Closed. |
user_id |
varchar230 |
0 |
1 |
The userid of the user who created the transfer. |
tsfhead |
create_id |
null |
null |
No |
The userid of the user who created the transfer. |
comment_desc |
varchar22000 |
0 |
1 |
Comments associated with the transfer. |
tsfhead |
comment_desc |
null |
null |
No |
Comments associated with the transfer. |
context_type |
varchar26 |
0 |
1 |
This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. |
tsfhead |
context_type |
null |
varchar2(6) |
No |
This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. |
context_value |
varchar225 |
0 |
1 |
This field holds the value relating to the context type like Promotion number. |
tsfhead |
tsf_type |
null |
null |
No |
This field holds the value relating to the context type like Promotion number. |
ExtOfXTsfDesc:ExtOfXTsfDesc
|
*
|
0
|
1
|
Provide an extension hook to customize XTsfDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfXTsfDesc:LocOfXTsfDesc
|
*
|
0
|
1
|
Provide an extension hook to localize XTsfDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|