XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RTVDesc 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 |
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 |
store identifier |
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 |
VARCHAR2 |
128 |
No |
external identifier. ex this is external id from 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. |
RETURN |
AUTHORIZATION_NUMBER |
VARCHAR2 |
12 |
No |
the vendor authorization number for when a number is required when a return being returned to a vendor. |
vendor_nbr |
varchar210 |
1 |
1 |
Contains the supplier ID to which the merchandise is being returned. |
RETURN |
SOURCE_ID |
VARCHAR2 |
128 |
No |
supplier or warehouse reference identifier |
ship_address1 |
varchar2240 |
0 |
1 |
Contains the first line of the supplier's address for returns. |
ADDRESS |
ADDRESS_LINE_1 |
VARCHAR2 |
240 |
Yes |
First Address |
ship_address2 |
varchar2240 |
0 |
1 |
Contains the second line of the supplier's address for returns. |
ADDRESS |
ADDRESS_LINE_2 |
VARCHAR2 |
240 |
No |
Second Adress. |
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 |
STATE |
VARCHAR2 |
3 |
No |
supplier state for address type |
city |
varchar2120 |
0 |
1 |
Contains the city name of the supplier's address for returns. |
ADDRESS |
CITY |
VARCHAR2 |
120 |
Yes |
supplier city id for address type |
shipto_zip |
varchar230 |
0 |
1 |
Contains the zip code of the supplier's address for returns. |
ADDRESS |
POSTAL_CODE |
VARCHAR2 |
30 |
No |
supplier post info depending on address type |
country |
varchar23 |
0 |
1 |
Contains the country ID of the supplier's address for returns. |
ADDRESS |
COUNTRY_ID |
VARCHAR2 |
3 |
Yes |
supplier country id depending on address type |
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 |
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. |
RETURN |
COMMENTS |
VARCHAR2 |
2000 |
No |
comment or short description entered by the creator or processor of 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 |
Fill column length. |
No |
external identifier.
ex. this is external id from rms. |
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). |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
values are SHIPPED_STATUS "S" or APPROVED_STATUS "A" |