XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RTVDesc in IGS application. |
IGS's Table Name |
IGS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
IGS's Column Length |
Is Column Required in IGS's API? |
IGS's API Description |
dc_dest_id |
varchar210 |
1 |
1 |
Contains the location number that the items are returned from. If the dc_dest_id is a store, the STORE column gets populated with the dc_dest_id value, and the WH column is defaulted to -1. If the dc_dest_id is a warehouse, the WH column gets populated. |
RMS.rtv_head |
store, wh |
varchar2 |
10 |
Yes |
Contains the number of the location number from which the items are returned. If the dc_dest_id is a store, the STORE column is populated with the dc_dest_id value, and the WH column defaults to
-1. If the dc_dest_id is a warehouse, the WH column is populated. |
rtv_id |
varchar214 |
1 |
1 |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
RMS.rtv_head |
ext_ref_no |
varchar2 |
14 |
Yes |
Audit trail reference to an external system when an external transaction initiates master record creation in RMS. |
rtn_auth_nbr |
varchar212 |
0 |
1 |
Contains the number that the supplier provides when the decision is made that an order may be returned. This value is not always required and is determined by vendor level data. |
RMS.rtv_head |
ret_auth_num |
varchar2 |
12 |
No |
Contains the number that the supplier provides when the decision is made that an order may be returned. This value is not always required and is determined by vendor level data. |
vendor_nbr |
varchar210 |
1 |
1 |
Contains the supplier ID to which the merchandise is being returned. |
RMS.rtv_head |
supplier |
varchar2 |
10 |
Yes |
Contains the supplier ID to which the merchandise is being returned. |
ship_address1 |
varchar2240 |
0 |
1 |
Contains the first line of the supplier's address for returns. |
RMS.rtv_head |
ship_to_add_1 |
varchar2 |
240 |
No |
Contains the first line of the supplier's address for returns. |
ship_address2 |
varchar2240 |
0 |
1 |
Contains the second line of the supplier's address for returns. |
RMS.rtv_head |
ship_to_add_2 |
varchar2 |
240 |
No |
Contains the second line of the supplier's address for returns. |
ship_address3 |
varchar2240 |
0 |
1 |
Contains the third line of the supplier's address for returns. |
RMS.rtv_head |
ship_to_add_3 |
varchar2 |
240 |
No |
Contains the third line of the supplier's address for returns. |
state |
varchar23 |
0 |
1 |
Contains the state of the supplier's address for returns. |
RMS.rtv_head |
state |
varchar2 |
3 |
No |
Contains the state of the supplier's address for returns. |
city |
varchar2120 |
0 |
1 |
Contains the city name of the supplier's address for returns. |
RMS.rtv_head |
ship_to_city |
varchar2 |
120 |
No |
Contains the city name of the supplier's address for returns. |
shipto_zip |
varchar230 |
0 |
1 |
Contains the zip code of the supplier's address for returns. |
RMS.rtv_head |
ship_to_pcode |
varchar2 |
30 |
No |
Contains the zip code of the supplier's address for returns. |
country |
varchar23 |
0 |
1 |
Contains the country ID of the supplier's address for returns. |
RMS.rtv_head |
ship_to_country_id |
varchar2 |
3 |
No |
Contains the country ID of the supplier's address for returns. |
creation_ts |
xs:dateTime |
0 |
1 |
CREATED_DATE contains the date the vendor return was created, COMPLETED_DATE contains the date the vendor return was completed. |
RMS.rtv_head |
created_date, completed_date |
date |
Fill column length. |
No |
CREATED_DATE contains the date the vendor return was created, COMPLETED_DATE contains the date the vendor return was completed. |
comments |
varchar22000 |
0 |
1 |
Contains any comments associated with the return. |
RMS.rtv_head |
comment_desc |
varchar2 |
2000 |
No |
Contains comments associated with the return. |
rtv_order_no |
number10 |
0 |
1 |
Contains the number that uniquely identifies the return to vendor within the system. |
RMS.rtv_head |
rtv_order_no |
number |
10 |
No |
Contains the number to uniquely identify the return to vendor within the system. |
RTVDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
status_ind |
varchar21 |
0 |
1 |
This value is used to determine the current status of the return. If this is 'A', RMS will set the status to 12 (In Progress). If this is 'S' or null, it will be set to 15 (Shipped). |
RMS.n/a |
n/a |
n/a |
n/a |
No |
This value is used to determine the current status of the return. If this is 'A', RMS will set the status to 12 (In Progress). If this is 'S' or null, it will be set to 15 (Shipped). |