| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVrnHdrCriVo 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 |
| store_id |
number10 |
1 |
1 |
Include only vendor returns associated to this store. |
RTV |
STORE_ID |
NUMBER |
10,0 |
Yes |
store identifier |
| item_id |
varchar225 |
0 |
1 |
Include only vendor returns containing this SKU number. |
RTV_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
No |
item identifier |
| return_id |
number12 |
0 |
1 |
Include only vendor returns with this identifier. This will limit the response to a single return. |
RTV |
ID |
NUMBER |
15,0 |
No |
unique identifier of the vendor return |
| external_id |
varchar2128 |
0 |
1 |
Include only vendor returns with this external identifier. |
RTV |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external identifier |
| authorization_number |
varchar212 |
0 |
1 |
Include only vendor returns with this 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. |
| reason_id |
number12 |
0 |
1 |
Include only vendor returns with at least one line item containing this reason code identifier, |
RTV_LINE_ITEM |
SHIPMENT_REASON_ID |
NUMBER |
15,0 |
No |
The shipment reason id |
| status |
rtv_cri_status |
1 |
1 |
Include only vendor returns with this status. Valid values are REQUESTED, REQUEST_IN_PROGRESS, RTV_IN_PROGRESS, APPROVED, IN_SHIPPING, COMPLETED, REJECTED, CANCELED_REQUEST, CANCELED_RTV, ACTIVE, NO_VALUE. |
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 |
| supplier_id |
varchar2128 |
0 |
1 |
Include only vendor returns with this supplier identifier. |
RTV |
SUPPLIER_ID |
NUMBER |
10,0 |
No |
supplier identifier |
|
