Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For RTVReqDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
rtv_order_no |
number10 |
1 |
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. |
supplier |
varchar210 |
1 |
1 |
Description is not available. |
RETURN |
SOURCE_ID |
VARCHAR2 |
128 |
No |
Unique identifier of the supplier |
status_ind |
number2 |
1 |
1 |
Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. |
RETURN |
STATUS |
NUMBER |
2,0 |
null |
Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. |
loc |
number10 |
1 |
1 |
Contains either the store or warehouse number for the items being returned. |
RETURN |
STORE_ID |
NUMBER |
10,0 |
Yes |
Contains either the store or warehouse number for the items being returned. |
loc_type |
varchar21 |
1 |
1 |
Indicates the location type. Contains an 'S' if the location is a store or 'W' if the location is a warehouse. |
|
|
|
|
null |
Not used in SIM |
physical_loc |
number10 |
1 |
1 |
Contains the store number or the physical warehouse where the items are being returned. |
|
|
|
|
null |
Not used in SIM. |
total_order_amt |
number20_4 |
0 |
1 |
Contains the total amount of the return. This field is stored in the supplier's currency. |
|
|
|
|
null |
Not used in SIM. |
ship_to_addr_line1 |
varchar2240 |
1 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
ship_to_addr_line2 |
varchar2240 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
ship_to_addr_line3 |
varchar2240 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
ship_to_city |
varchar2120 |
1 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
state |
varchar23 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
ship_to_country_code |
varchar23 |
1 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
ship_to_postal_code |
varchar230 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
ret_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. |
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. |
ret_courier |
varchar2250 |
0 |
1 |
Contains the courier name if the supplier requires that returns be sent by a designated carrier. |
|
|
|
|
null |
Not used in SIM. |
freight_charge |
number20_4 |
0 |
1 |
Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency. |
|
|
|
|
null |
Not used in SIM. |
creation_date |
xs:dateTime |
1 |
1 |
Description is not available. |
RETURN |
CREATE_DATE |
Date |
|
No |
This indicates the stores specific create date of the RTV request |
completed_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM. |
handling_pct |
number12_4 |
0 |
1 |
Contains the handling (restocking) percent if a percent is specified at a vendor level. |
|
|
|
|
null |
Not used in SIM. |
handling_cost |
number20_4 |
1 |
1 |
Contains the handling (restocking) cost for the vendor return if a handling (restocking) percent is specified at a supplier level. The cost is calculated by taking the total order amount multiplied by the handling (restocking) percent. This field is stored in the supplier's currency. |
|
|
|
|
null |
Not used in SIM. |
ext_ref_no |
varchar214 |
0 |
1 |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
|
|
|
|
null |
Not used in SIM. |
comment_desc |
varchar22000 |
0 |
1 |
Description is not available. |
RETURN |
COMMENTS |
VARCHAR2 |
2000 |
No |
Comments |
RTVReqDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
not_after_date |
xs:dateTime |
0 |
1 |
Description is not available. |
RETURN |
NOT_AFTER_DATE |
Date |
|
No |
This indicates the store specific date after which return is not allowed. |
ExtOfRTVReqDesc:ExtOfRTVReqDesc
|
*
|
0
|
1
|
Provide an extension hook to customize RTVReqDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfRTVReqDesc:LocOfRTVReqDesc
|
*
|
0
|
1
|
Provide an extension hook to localize RTVReqDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|