Retail Integration Mappings Report Release:15.0.0 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/ManifestTrackDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ManifestTrackDesc Version:15.0.0 Return to Top
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