XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVrnHdrDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
return_id |
number12 |
1 |
1 |
Unique identifier of the vendor return. |
RTV |
ID |
NUMBER |
15,0 |
No |
unique identifier of a vendor return |
store_id |
number10 |
1 |
1 |
Store identifier |
RTV |
STORE_ID |
NUMBER |
10,0 |
Yes |
store identifier |
external_id |
varchar2128 |
0 |
1 |
External system identifier |
RTV |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external identifier |
supplier_id |
varchar2128 |
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 |
authorization_number |
varchar212 |
0 |
1 |
Authorization code |
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 |
|
No |
The return is not allowed after this date |
number_of_line_items |
number10 |
1 |
1 |
Number of line items on the vendor return. |
|
|
|
|
No |
Number of line items on the RTV document. |
|