XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVnsHdrCriVo 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 shipments created for this store |
RTV_SHIP |
STORE_ID |
NUMBER |
10,0 |
Yes |
The store id the RTV Shipment is created from |
shipment_id |
number15 |
0 |
1 |
Include only vendor shipments with this identifier. This will limit the response to a single vendor shipment. |
RTV_SHIP |
ID |
NUMBER |
15,0 |
No |
The unique identifier for the RTV Shipment |
supplier_id |
number10 |
0 |
1 |
Include only vendor shipments with this identifier. |
RTV_SHIP |
SUPPLIER_ID |
NUMBER |
10,0 |
No |
The supplier to which the RTV Shipment is created |
item_id |
varchar225 |
0 |
1 |
Include only vendor shipments containing this sku number |
RTV_SHIP_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
No |
The ID of the item |
authorization_code |
varchar212 |
0 |
1 |
Include only vendor shipments with this authorization code. |
RTV_SHIP |
AUTHORIZATION_CODE |
VARCHAR2 |
12 |
No |
The vendor authorization number |
status |
rtv_ship_cri_status |
1 |
1 |
Include only vendor shipments with this status. Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, ACTIVE, NO_VALUE. |
RTV_SHIP |
STATUS |
NUMBER |
2,0 |
Yes |
The status of the RTV Shipment. Valid values: 1- New, 2- In progress, 3- Submitted, 4- Shipped, 5- Canceled |
reason_id |
number15 |
0 |
1 |
Include only vendor shipments with at least one line item containing this reason code identifier |
RTV_SHIP_LINE_ITEM |
SHIPMENT_REASON_ID |
NUMBER |
15,0 |
No |
Return reason ID |