XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocPOTsfHdrDesc 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 |
order_id |
number12 |
1 |
1 |
Description is not available. |
ordhead,tsfhead |
orser_no,tsf_no |
number |
12 |
Yes |
Contains the number that uniquely identifies an order/transfer within the system. |
source_type |
varchar21 |
1 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
varchar2 |
1 |
Yes |
For on order, this would be 'S'(supplier) and for a transfer, this would be 'W'(warehouse) |
source_id |
number10 |
1 |
1 |
Description is not available. |
ordhead,wh |
supplier,physical_wh |
number |
10 |
Yes |
For an order, this holds the supplier and for a transfer , this holds the physical warehouse id |
create_date |
xs:dateTime |
0 |
1 |
Description is not available. |
ordhead,tsfhead |
written_date,create_date |
date |
Fill column length. |
No |
This field contains the date the transfer was created or Contains the date the order was created within the system. |
order_status |
varchar26 |
1 |
1 |
Description is not available. |
ordhead,tsfhead |
status |
varchar2 |
6 |
Yes |
Contains the status of order/transfer |
not_before_date |
xs:dateTime |
1 |
1 |
Description is not available. |
ordhead,tsfhead |
not_before_date,delivery_date |
date |
Fill column length. |
Yes |
For an order,it Contains the first date that delivery of the order will be accepted.For a transfer, it Indicates the earliest date that the transfer can be delivered to the store. |
not_after_date |
xs:dateTime |
1 |
1 |
Description is not available. |
ordhead,tsfhead |
not_after_date,delivery_date |
date |
Fill column length. |
Yes |
For an order,it Contains the last date that delivery of the order will be accepted.For a transfer, it Indicates the earliest date that the transfer can be delivered to the store. |
user_id |
varchar230 |
0 |
1 |
Description is not 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. |
quantity |
number12_4 |
0 |
1 |
Description is not available. |
ordloc,tsfdetail |
qty_ordered,tsf_qty |
number |
(12,4) |
No |
For an order, it contains the total ordered quantity for that order.For a transfer, it contains the total quantity on that transfer |