XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVnsDesc 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 |
shipment_id |
number15 |
1 |
1 |
Unique identifier |
RTV_SHIP |
ID |
NUMBER |
15,0 |
Yes |
The unique identifier for the RTV Shipment |
store_id |
number10 |
1 |
1 |
Store identifier of store that is returning the stock |
RTV_SHIP |
STORE_ID |
NUMBER |
10,0 |
Yes |
The store id the RTV Shipment is created from |
supplier_id |
number10 |
1 |
1 |
Supplier identifier. |
RTV_SHIP |
SUPPLIER_ID |
NUMBER |
10,0 |
Yes |
The supplier to which the RTV Shipment is created |
status |
rtv_ship_status |
1 |
1 |
Current status Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, UNKNOWN. |
RTV_SHIP |
STATUS |
NUMBER |
2 |
Yes |
The status of the RTV Shipment. Valid values: 1- New, 2- In progress, 3- Submitted, 4- Shipped, 5- Canceled |
authorization_code |
varchar212 |
0 |
1 |
Authorization code |
RTV_SHIP |
AUTHORIZATION_CODE |
VARCHAR2 |
12 |
No |
The vendor authorization number |
not_after_date |
xs:dateTime |
0 |
1 |
Date after which the vendor shipment in no longer valid |
RTV |
NOT_AFTER_DATE |
DATE |
|
No |
The return is not allowed after this date |
context_id |
number18 |
0 |
1 |
Context type identifier. |
RTV_SHIP |
CONTEXT_ID |
NUMBER |
18 |
No |
The context identifier |
context_value |
varchar225 |
0 |
1 |
Context type value. |
RTV_SHIP |
CONTEXT_VALUE |
VARCHAR2 |
25 |
No |
This field holds value related to the context type. |
doc_internal_id |
number12 |
0 |
1 |
Vendor return document unique identifier |
RTV_SHIP |
RTV_ID |
NUMBER |
15,0 |
No |
unique identifier of a vendor return |
doc_external_id |
varchar2128 |
0 |
1 |
External system identifier of the vendor return document |
RTV_SHIP |
RTV_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external identifier |
create_date |
xs:dateTime |
1 |
1 |
Date the vendor shipment was created in GMT timezone |
RTV_SHIP |
CREATE_DATE |
DATE |
|
Yes |
The create date of the RTV Shipment |
create_user |
varchar2128 |
1 |
1 |
Create user of the vendor shipment |
RTV_SHIP |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user who created the RTV Shipment |
update_date |
xs:dateTime |
1 |
1 |
Update the vendor shipment was dispatched in GMT timezone |
RTV_SHIP |
UPDATE_DATE |
DATE |
|
Yes |
The date when the RTV Shipment was updated |
update_user |
varchar2128 |
1 |
1 |
Update user of the vendor shipment |
RTV_SHIP |
UPDATE_USER |
VARCHAR2 |
128 |
Yes |
The user who last updated the RTV Shipment |
submit_date |
xs:dateTime |
0 |
1 |
Date the vendor shipment was submitted in GMT timezone |
RTV_SHIP |
SUBMIT_DATE |
DATE |
|
No |
The date when the RTV Shipment was submitted |
submit_user |
varchar2128 |
0 |
1 |
Submit user of the vendor shipment |
RTV_SHIP |
SUBMIT_USER |
VARCHAR2 |
128 |
No |
The user who submitted the RTV Shipment |
dispatch_date |
xs:dateTime |
0 |
1 |
Date the vendor shipment was dispatched in GMT timezone |
RTV_SHIP |
DISPATCH_DATE |
DATE |
|
No |
The date when the RTV Shipment was dispatched |
dispatch_user |
varchar2128 |
0 |
1 |
Dispatch user of the vendor shipment |
RTV_SHIP |
DISPATCH_USER |
VARCHAR2 |
128 |
No |
The user who dispatched the RTV Shipment |
StrVnsBol
|
*
|
0
|
1
|
Bill of lading associated to the vendor shipment.
|
|
|
|
|
|
|
StrVnsNote
|
*
|
0
|
1000
|
Notes associated to the vendor shipment.
|
|
|
|
|
|
|