XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XTsfDesc 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 |
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. |