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. |
DO_CTL_INV |
ID_ICD |
NUMBER |
128 |
Yes |
Not Yet Available |
supplier |
varchar210 |
1 |
1 |
Description is not available. |
DO_CTL_INV |
ID_PRTY_TO_ICD |
VARCHAR2 |
128 |
No |
Not Yet Available |
status_ind |
number2 |
1 |
1 |
Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. |
|
null |
null |
null |
null |
null |
loc |
number10 |
1 |
1 |
Contains either the store or warehouse number for the items being returned. |
DO_CTL_INV |
ID_STR_RT |
NUMBER |
128 |
No |
Not Yet Available |
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 |
null |
null |
null |
null |
physical_loc |
number10 |
1 |
1 |
Contains the store number or the physical warehouse where the items are being returned. |
|
null |
null |
null |
null |
null |
total_order_amt |
number20_4 |
0 |
1 |
Contains the total amount of the return. This field is stored in the supplier's currency. |
|
null |
number |
20 |
null |
null |
ship_to_addr_line1 |
varchar2240 |
1 |
1 |
Description is not available. |
|
null |
varchar2 |
240 |
null |
null |
ship_to_addr_line2 |
varchar2240 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
240 |
null |
null |
ship_to_addr_line3 |
varchar2240 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
240 |
null |
null |
ship_to_city |
varchar2120 |
1 |
1 |
Description is not available. |
|
null |
varchar2 |
120 |
null |
null |
state |
varchar23 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
3 |
null |
null |
ship_to_country_code |
varchar23 |
1 |
1 |
Description is not available. |
|
null |
varchar2 |
3 |
null |
null |
ship_to_postal_code |
varchar230 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
30 |
null |
null |
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. |
DO_CTL_INV |
AUTHORIZATION_NUM |
VARCHAR2 |
128 |
No |
Not Yet Available |
ret_courier |
varchar2250 |
0 |
1 |
Contains the courier name if the supplier requires that returns be sent by a designated carrier. |
|
null |
varchar2 |
250 |
null |
null |
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 |
number |
20 |
null |
null |
creation_date |
xs:dateTime |
1 |
1 |
Description is not available. |
DO_CTL_INV |
TS_CRT_ICD |
RIBDate |
* |
No |
Not Yet Available |
completed_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
null |
RIBDate |
* |
null |
null |
handling_pct |
number12_4 |
0 |
1 |
Contains the handling (restocking) percent if a percent is specified at a vendor level. |
|
null |
null |
null |
null |
null |
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 |
null |
null |
null |
null |
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 |
varchar2 |
14 |
null |
null |
comment_desc |
varchar22000 |
0 |
1 |
Description is not available. |
DO_CTL_INV |
COMMENT_DESC |
VARCHAR2 |
300 |
No |
Not Yet Available |
RTVReqDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
not_after_date |
xs:dateTime |
0 |
1 |
Description is not available. |
DO_CTL_INV |
NOT_AFTER_DATE |
RIBDate |
* |
No |
Not Yet Available |
ExtOfRTVReqDesc:ExtOfRTVReqDesc
|
*
|
0
|
1
|
Provide an extension hook to customize RTVReqDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|