XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVnsHdrDesc 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 |
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 |
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_SHIP |
NOT_AFTER_DATE |
DATE |
|
No |
The not after date for the RTV Shipment |
status |
rtv_ship_status |
1 |
1 |
Current status Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, UNKNOWN. |
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 |
number_of_line_items |
number10 |
1 |
1 |
Number of line items on the vendor shipment. |
|
|
|
|
No |
Number of line items on the shipment. |
|