Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For RTVDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
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. |
RETURN |
STORE_ID |
NUMBER |
10,0 |
Yes |
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. |
rtv_id |
varchar214 |
1 |
1 |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
RETURN |
EXTERNAL_ID |
NUMBER |
12,0 |
No |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
rtn_auth_nbr |
varchar212 |
1 |
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. |
RETURN |
AUTHORIZATION_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. |
PA_SPR |
ID_SPR |
VARCHAR2 |
128 |
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. |
ADDRESS_DETAIL |
ADD_1 |
VARCHAR2 |
240 |
Yes |
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. |
ADDRESS_DETAIL |
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. |
ADDRESS_DETAIL |
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. |
ADDRESS_DETAIL |
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. |
ADDRESS_DETAIL |
CITY |
VARCHAR2 |
120 |
Yes |
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. |
ADDRESS_DETAIL |
POST |
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. |
ADDRESS_DETAIL |
COUNTRY_ID |
VARCHAR2 |
3 |
Yes |
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. |
RETURN |
CREATE_DATE |
Date |
|
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. |
RETURN |
COMMENTS |
VARCHAR2 |
2000 |
No |
Contains any comments associated with the return. |
rtv_order_no |
number10 |
0 |
1 |
Contains the number that uniquely identifies the return to vendor within the system. |
RETURN |
EXTERNAL_ID |
NUMBER |
12,0 |
No |
Contains the number that uniquely identifies the return to vendor within the system. |
RTVDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
status_ind |
varchar21 |
0 |
1 |
Description is not available. |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfRTVDesc:ExtOfRTVDesc
|
*
|
0
|
1
|
Provide an extension hook to customize RTVDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfRTVDesc:LocOfRTVDesc
|
*
|
0
|
1
|
Provide an extension hook to localize RTVDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|