XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocPOTsfDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
loc |
number10 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
location,to_loc |
number |
10 |
No |
For a transfer, this will hold the location number of the transfer to location. For an order,This field contains the location all items on the order will be delivered to if populated. |
loc_type |
varchar21 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
loc_type,to_loc_type |
varchar2 |
1 |
No |
For a transfer,this field contains the location type of the to location of the transfer. Valid values are |
order_id |
number12 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
order_no,tsf_no |
number |
12 |
No |
Contains the number that uniquely identifies an order/transfer within the system. |
source_type |
varchar21 |
1 |
1 |
Not Yet Available |
Fill application table name. |
Fill table column name. |
varchar2 |
1 |
Yes |
This would be 'S'(supplier) for an order and 'W' (Warehouse)for a transfer |
source_id |
number10 |
1 |
1 |
Not Yet Available |
ordhead,tsfhead |
supplier,from_loc |
number |
10 |
Yes |
For an order, this field Contains the vendor number who will provide the merchandise specified in the order.For a transfer,this field contains the location number of the transfer from location. This field will contain a store, internal finisher, external finisher or warehouse number based upon the FROM_LOC_TYPE field. An internal finisher is a warehouse and an external finisher is a partner. |
user_id |
varchar230 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
orig_approval_id,create_id |
varchar2 |
30 |
No |
For an order,this field Indicates where the order was approved. It will be the user ID of the person approving the order for all orders manually approved on-line and will contain Replen for orders automatically approved in the replenishment process. For a transfer,This field contains the user ID of the user that created the transfer. |
comments |
varchar22000 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
comments_desc |
varchar2 |
2000 |
No |
This field contains any miscellaneous comments associated to the Transfer/Order |
order_status |
varchar26 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
status |
6 |
varchar2 |
No |
Contains status of order/transfer |
not_before_date |
xs:dateTime |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
not_before_date,delivery_date |
date |
Fill column length. |
No |
For an order,this field contains the first date that delivery of the order will be accepted.For a transfer,this field indicates the earliest date that the transfer can be delivered to the store. |
not_after_date |
xs:dateTime |
0 |
1 |
Not Yet Available |
ordhead |
not_after_date |
date |
Fill column length. |
No |
For an order,this field contains the last date that delivery of the order will be accepted. |
create_date |
xs:dateTime |
0 |
1 |
NA |
ordhead,tsfhead |
create_date |
date |
Fill column length. |
No |
This field contains the date the transfer was created. |
LocPOTsfDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
orig_ind |
number1 |
0 |
1 |
Not Yet Available |
ordhead |
orig_ind |
number |
1 |
Yes |
For an order, this indicates where the order originated. |
origin_country_id |
varchar23 |
0 |
1 |
Not Yet Available |
ORDSKU |
ORIGIN_COUNTRY_ID |
varchar2 |
3 |
No |
For an order, this is the identifier of the country into which the items on the order are being imported. |
|