XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RTVReqDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
rtv_order_no |
number12 |
1 |
1 |
Contains the number that uniquely identifies the return to vendor within the system. |
RTV |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
external identifier. ex. this is external id from rms. |
supplier |
varchar210 |
1 |
1 |
Description is not available. |
RTV |
SUPPLIER_ID |
VARCHAR2 |
128 |
No |
supplier or warehouse reference identifier |
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 |
No |
the current status of a return.
1 - Pending,
2 - Requested,
3 - Dispatched,
4 - Received,
5 - Active,
6 - Canceled |
loc |
number10 |
1 |
1 |
Contains either the store or warehouse number for the items being returned. |
RTV |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM |
physical_loc |
number10 |
1 |
1 |
Contains the store number or the physical warehouse where the items are being returned. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
ship_to_addr_line1 |
varchar2240 |
1 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
ship_to_addr_line2 |
varchar2240 |
0 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
ship_to_addr_line3 |
varchar2240 |
0 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
ship_to_city |
varchar2120 |
1 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
state |
varchar23 |
0 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
ship_to_country_code |
varchar23 |
1 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
ship_to_postal_code |
varchar230 |
0 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
RTV |
AUTHORIZATION_NUMBER |
VARCHAR2 |
12 |
No |
the vendor authorization number for when a number is required when a return being returned to a vendor. |
ret_courier |
varchar2250 |
0 |
1 |
Contains the courier name if the supplier requires that returns be sent by a designated carrier. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
creation_date |
xs:dateTime |
1 |
1 |
Description is not available. |
RTV |
CREATE_DATE |
Date |
Fill column length. |
No |
create date of a original return |
completed_date |
xs:dateTime |
0 |
1 |
Description is not available. |
RTV |
CLOSED_DATE |
RIB or/and RSB |
DATE |
null |
Fill this description. |
handling_pct |
number12_4 |
0 |
1 |
Contains the handling (restocking) percent if a percent is specified at a vendor level. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
null |
Not used in SIM. |
comment_desc |
varchar22000 |
0 |
1 |
Description is not available. |
NOTES |
TEXT |
VARCHAR2 |
2000 |
No |
comment or short description entered by the creator or processor of the return |
RTVReqDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
not_after_date |
xs:dateTime |
0 |
1 |
Description is not available. |
RTV |
NOT_AFTER_DATE |
DATE |
Fill column length. |
No |
This indicates the store specific date after which return is not allowed. |