XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocPOTsfHdrCriVo 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 |
0 |
1 |
Not Yet Available |
ordhead,stfhead |
order_no,tsf_no |
number |
12 |
No |
Order_no/Tsf_no fro which information is to be retrieved |
item |
varchar225 |
0 |
1 |
Not Yet Available |
ordloc,tsfdetail |
item |
varchar2 |
25 |
No |
The item for which store order information(orders and transfers) need to be retrieved |
loc |
number10 |
1 |
1 |
Not Yet Available |
ordloc,tsfhead |
loc,to_loc |
number |
10 |
Yes |
The location for which store order information needs to be retrieved |
loc_type |
varchar21 |
1 |
1 |
Not Yet Available |
Fill application table name. |
Fill table column name. |
varchar2 |
1 |
Yes |
Location Type for the location |
source_type |
varchar21 |
0 |
1 |
Not Yet Available |
Fill application table name. |
Fill table column name. |
varchar2 |
1 |
No |
Fill this description. |
source_id |
number10 |
0 |
1 |
Not Yet Available |
ordhead,wh |
supplier,physical_wh |
number |
10 |
No |
For an order, this holds the supplier and for a transfer , this holds the physical warehouse id |
order_status |
varchar26 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
status |
varchar2 |
6 |
No |
Contains the status of order/transfer |
not_before_date |
xs:dateTime |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
not_after_date,delivery_date |
date |
Fill column length. |
No |
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 |
0 |
1 |
Not Yet Available |
ordhead,tsfhead |
not_after_date,delivery_date |
date |
Fill column length. |
No |
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. |
|