| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVrnDesc 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 |
| return_id |
number15 |
1 |
1 |
Vendor return unique identifie.r |
RTV |
ID |
NUMBER |
15,0 |
Yes |
unique identifier of a vendor return |
| external_id |
varchar2128 |
0 |
1 |
External system identifier. |
RTV |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external identifier |
| store_id |
number10 |
1 |
1 |
Store identifier of store that is returning the stock. |
RTV |
STORE_ID |
NUMBER |
10,0 |
Yes |
store identifier |
| supplier_id |
number10 |
1 |
1 |
Supplier identifier. |
RTV |
SUPPLIER_ID |
NUMBER |
10,0 |
Yes |
supplier identifier |
| status |
rtv_status |
1 |
1 |
Current status Valid values are REQUESTED, REQUEST_IN_PROGRESS, RTV_IN_PROGRESS, APPROVED, IN_SHIPPING, COMPLETED, REJECTED, CANCELED_REQUEST, CANCELED_RTV, UNKNOWN. |
RTV |
STATUS |
NUMBER |
2,0 |
Yes |
status of the return. 1 - Requested, 2-In Progress, 3-Canceled Request, 4-Rejected,5-Approved,6-In Shipping,7-Completed,8-Canceled |
| context |
rtv_context |
1 |
1 |
Current status Valid values are INVALID_DELIVERY, SEASONAL, DAMAGED, NONE, UNKNOWN. |
RTV |
RTV_TYPE_ID |
NUMBER |
15,0 |
Yes |
unique identifier of a vendor return type |
| authorization_number |
varchar212 |
0 |
1 |
Authorization number. |
RTV |
AUTHORIZATION_NUMBER |
VARCHAR2 |
12 |
No |
The vendor authorization number for when a number is required when a return being returned to a vendor |
| not_after_date |
xs:dateTime |
0 |
1 |
Date after which the return in no longer valid. |
RTV |
NOT_AFTER_DATE |
DATE |
Fill column length. |
No |
The return is not allowed after this date |
| create_user_name |
varchar2128 |
0 |
1 |
User who created this vendor return. |
RTV |
CREATE_USER |
VARCHAR2 |
128 |
No |
the user who created the return |
| create_date |
xs:dateTime |
0 |
1 |
Date on which the vendor return was created in GMT timezone. |
RTV |
CREATE_DATE |
DATE |
Fill column length. |
No |
the date that the return was created |
| update_user_name |
varchar2128 |
0 |
1 |
User who last updated this vendor return. |
RTV |
UPDATE_USER |
VARCHAR2 |
128 |
No |
The user who created the record |
| update_date |
xs:dateTime |
0 |
1 |
Date on which the vendor return was last updated in GMT timezone. |
RTV |
UPDATE_DATE |
DATE |
Fill column length. |
No |
The update date |
| approved_user_name |
varchar2128 |
0 |
1 |
User who approved this vendor return. |
RTV |
APPROVED_USER |
VARCHAR2 |
128 |
No |
The user who approved the return |
| approved_date |
xs:dateTime |
0 |
1 |
Date on which the vendor return was approved in GMT timezone. |
RTV |
APPROVED_DATE |
DATE |
Fill column length. |
No |
The date the return was approved |
| closed_user_name |
varchar2128 |
0 |
1 |
User who closed this vendor return. |
RTV |
CLOSED_USER |
VARCHAR2 |
128 |
No |
the user who closed the return |
| closed_user_date |
xs:dateTime |
0 |
1 |
Date on which the vendor return was closed in GMT timezone. |
RTV |
CLOSED_DATE |
DATE |
Fill column length. |
No |
the date the return was closed |
|
GeoAddrDesc:GeoAddrDesc
|
*
|
0
|
1
|
Address fields.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
StrVrnItm
|
*
|
0
|
unbounded
|
Collection of vendor return line items.
|
|
|
|
|
|
|
