XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVnsCtnDesc 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 |
shipment_id |
number15 |
1 |
1 |
Shipment unique identifier |
RTV_SHIP_CARTON |
RTV_SHIP_ID |
NUMBER |
15,0 |
Yes |
The unique ID of the RTV shipment the carton is associated to |
container_id |
number15 |
1 |
1 |
Container unique identifier. |
RTV_SHIP_CARTON |
ID |
NUMBER |
15,0 |
Yes |
The unique identifier for the RTV shipment carton/container |
store_id |
number10 |
1 |
1 |
Store unique identifier |
RTV_SHIP_CARTON |
STORE_ID |
NUMBER |
10,0 |
Yes |
The store id from which the RTV Shipment is created |
container_label |
varchar2128 |
0 |
1 |
The identifier used to print a barcode or label for the container. |
RTV_SHIP_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external identifier |
status |
rtv_ship_carton_status |
1 |
1 |
Current status of the container Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. |
RTV_SHIP_CARTON |
STATUS |
NUMBER |
2,0 |
Yes |
The status of the RTV Shipment carton. Valid values: 1- New, 2- In progress, 3- Completed, 4- Canceled |
package_weight |
number12_4 |
0 |
1 |
The weight of the package measured by package_weight_uom. |
RTV_SHIP_CARTON |
WEIGHT |
NUMBER |
12,4 |
No |
The weight of the container |
package_weight_uom |
varchar24 |
0 |
1 |
The unit of measure of the package weight. |
RTV_SHIP_CARTON |
WEIGHT_UOM |
VARCHAR2 |
4 |
No |
The UOM of the container |
tracking_number |
varchar2128 |
0 |
1 |
Container Tracking number |
RTV_SHIP_CARTON |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
The Tracking number for the container |
package_type |
varchar2128 |
0 |
1 |
Package type of the container. |
RTV_SHIP_CARTON |
SHIPMENT_CARTON_DIM_ID |
NUMBER |
10,0 |
No |
The shipment container dimention id |
restriction_level |
mdse_restrict_level |
1 |
1 |
Restriction level of the container. Valid values are DEPT, CLASS, SUBCLASS, NONE, UNKNOWN. |
RTV_SHIP_CARTON |
RESTRICTION_LEVEL |
NUMBER |
4,0 |
Yes |
The hierarchy restriction level for items in a container |
create_user_name |
varchar2128 |
1 |
1 |
User who created this shipment container. |
RTV_SHIP_CARTON |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user who created the RTV Shipment carton |
create_date |
xs:dateTime |
1 |
1 |
Date on which the shipment container was created in GMT timezone. |
RTV_SHIP_CARTON |
CREATE_DATE |
DATE |
Fill column length. |
Yes |
The create date of the RTV Shipment carton |
update_user_name |
varchar2128 |
0 |
1 |
User who last updated this shipment container. |
RTV_SHIP_CARTON |
UPDATE_USER |
VARCHAR2 |
128 |
No |
The user who last updated the RTV Shipment carton |
update_date |
xs:dateTime |
0 |
1 |
Date on which the shipment container was last updated in GMT timezone. |
RTV_SHIP_CARTON |
UPDATE_DATE |
DATE |
Fill column length. |
No |
The date when the RTV Shipment carton was updated |
approved_user_name |
varchar2128 |
0 |
1 |
User who approved this shipment container. |
RTV_SHIP_CARTON |
APPROVAL_USER |
VARCHAR2 |
128 |
No |
The user who confirmed the RTV Shipment |
approved_date |
xs:dateTime |
0 |
1 |
Date on which the shipment container was approved in GMT timezone. |
RTV_SHIP_CARTON |
APPROVAL_DATE |
DATE |
Fill column length. |
No |
The date when the RTV Shipment was confirmed |
StrVnsCtnItm
|
*
|
0
|
5000
|
Collection of items within the container.
|
|
|
|
|
|
|