XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ManifestTrackDesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
transaction_type |
manifest_tran_type |
0 |
1 |
Type of transaction that was manifested. Valid values are FULFILLMENT_ORDER_DELIVERY, RETURN, TRANSFER. |
NA |
NA |
RIB or/and RSB or/and RSL |
Fill column length. |
No |
Fill this description. |
transaction_id |
number12 |
0 |
1 |
Identifier of transaction that was manifested. |
NA |
NA |
RIB or/and RSB or/and RSL |
Fill column length. |
No |
Fill this description. |
shipment_id |
varchar2120 |
0 |
1 |
This field represents the shipment number that manifest systems use to group multi-container shipments for a carrier. Typically a 1 of 4 type message. |
container |
carrier_shipment_nbr |
varchar2 |
120 |
Yes |
This field represents the shipment number that manifest systems use to group multi-container shipments for a carrier. Typically a 1 of 4 type message |
container_id |
varchar220 |
0 |
1 |
Identifier of the container. |
container |
container_id |
varchar2 |
20 |
Yes |
Unique identifier for a container. A container is a generic thing that can hold merchandise or other containers. This could be carton, pallet, tote, trolley, laundry basket, etc.
A Manifest record is created based on the container id, bol_nbr and dest_id. |
carrier_code |
varchar24 |
1 |
1 |
Carrier selected. |
container |
carrier_code |
varchar2 |
4 |
Yes |
A code which uniquely identifies a carrier. |
carrier_service_code |
varchar26 |
1 |
1 |
Service to be used by the carrier. |
container |
service_code |
varchar2 |
Code for the service. |
Yes |
MMS |
carrier_tracking_number |
varchar2120 |
1 |
1 |
This is a unique tracking number that is used to track containers through carriers system. |
container |
carrier_tracking_nbr |
varchar2 |
120 |
Yes |
This is a unique tracking number that is used to track containers through carriers system |