Shipment Advice Shipment SDO

An object to store the details of an eligible shipment such as shipment name or carrier in the shipment advice

QName: {http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/shipmentAdvice/shipmentAdviceAsnServiceV2/}SAShipment

Logical Business Objects

  • SCM : Shipping : Shipment

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Shipment Advice Shipment Line SDO

Contains

Shipment Advice Attachment SDO

Contains

Shipment Advice Packing Unit SDO

Contains

Shipment Descriptive Flexfield SDO

Contains

Shipment Advice Shipping Cost SDO

Handled by

Manifest Shipment

Attributes

The following table describes attributes in the service data object.

Name Type Description

ActualShipDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date the shipment was actually sent.

ActualShipDateTime

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the shipment was actually sent.

BillOfLadingNumber

string

Identifier for bill of lading.

CarrierId

long

Unique identifier for a carrier.

CarrierName

string

Carrier name.

CarrierNumber

string

Identifier for a carrier.

DeliveryId

long

Unique identifier for a shipment.
  • Primary Key

DeliveryName

string

Identifier for a shipment.

Description

string

Description of a shipment.

DistribtedOrganization

string

Indicates distributed organization.

DockCode

string

Customer dock code.

EarliestDropoffDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Not currently used.

EarliestPickupDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Not currently used.

FOBAddressLine1

string

Address line1 of FOB Location

FOBAddressLine2

string

Addresss Line2 of FOB Location

FOBAddressLine3

string

Address Line3 for FOB Location

FOBAddressLine4

string

Address Line4 for FOB Location

FOBCity

string

City for FOB Location

FOBCode

string

FOB code.

FOBCountry

string

Country for FOB Location

FOBCounty

string

County for FOB Location

FOBLocationId

long

Unique identifier for FOB locaiton.

FOBName

string

FOB name.

FOBPostalCode

string

Postalcode for FOB Location

FOBRegion

string

Region for FOB Location

FOBState

string

State for FOB Location

FreightTermsCode

string

Unique code for a freight term.

FreightTermsName

string

Freight terms name.

GrossWeight

decimal

Gross weight.

InitialPickupDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date on which the shipment is planned to be shipped.

InitialPickupLocationId

long

Unique identifier for a ship-from location.

LatestDropoffDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Not currently used.

LatestPickupDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Not currently used.

LoadingOrderType

string

Loading order type code.

LoadingOrderTypeName

string

Loading order type name.

LoadingSequence

decimal

Sequence in which the lines will be loaded onto the equipment.

ModeOfTransport

string

Mode of transport.

ModeOfTransportName

string

Mode of transport name.

NetWeight

decimal

Net weight.

NumberOfLPN

decimal

Number of packing units.

OrganizationCode

string

Identifier for a ship-from organization.

OrganizationId

long

Unique identifier for a ship-from organization.

OrganizationName

string

Name of a ship from organization.

OutsourcerPartyId

long

Unique identifier for logistics service provider customer. Foreign key to PARTY_ID in HZ_PARTIES table. Represents the outsourcer who sent this message to logistics service provider system.

OutsourcerPartyName

string

Name for a logistics service provider customer.

OutsourcerPartyNumber

string

Identifier for a logistics service provider customer.

PackingSlipNumber

string

Identifier for packing slip.

PortOfDischarge

string

Not currently used.

PortOfLoading

string

Not currently used.

RcvShipmentHeaderId

long

Unique identifier for supplier ASN within receiving.

RcvShipmentNumber

string

Identifier for supplier ASN.

RoutingInstructions

string

Routing instructions.

SAAttachment

Shipment Advice Attachment SDO

An object to store the details of the shipment attachments.

SAInnerPackingUnit

Shipment Advice Packing Unit SDO

Identifier for a packing unit.

SAOuterPackingUnit

Shipment Advice Packing Unit SDO

Identifier for a packing unit.

SAShipmentDFFVA

Shipment Descriptive Flexfield SDO

Additional information of shipment

SAShipmentItem

Shipment Advice Shipment Line SDO

Shipment Line

SAShippingCost

Shipment Advice Shipping Cost SDO

Identifier for a shipping cost.

ServiceLevel

string

Service level.

ServiceLevelName

string

Service level name.

ShipFromAddressLine1

string

Address line1 for the origin addres of the shipment.

ShipFromAddressLine2

string

Address line2 for the origin addres of the shipment.

ShipFromAddressLine3

string

Address line3 for the origin addres of the shipment.

ShipFromAddressLine4

string

Address line4 for the origin addres of the shipment.

ShipFromCity

string

City for the origin addres of the shipment.A

ShipFromCountry

string

Country for the origin address of the shipment.

ShipFromCounty

string

County for the origin address of the shipment.

ShipFromPostalCode

string

Postal code for the origin address of the shipment.

ShipFromRegion

string

Region for the origin address of the shipment.

ShipFromState

string

State for the origin address of the shipment.

ShipMethodCode

string

Shipping method code.

ShipToAddressLine1

string

Address line1 for the destination addres of the shipment.

ShipToAddressLine2

string

Address line 2 for the destination addres of the shipment.

ShipToAddressLine3

string

Address line3 for the destination addres of the shipment.

ShipToAddressLine4

string

Address line4 for the destination addres of the shipment.

ShipToCity

string

City for the destination addres of the shipment.

ShipToCountry

string

Country for the destination address of the shipment.

ShipToCounty

string

County for the destination addres of the shipment.

ShipToPartyId

long

Unique identifier for ship-to party.

ShipToPartyName

string

Name for ship-to party.

ShipToPartyNumber

string

Identifier for ship-to party site.

ShipToPostalCode

string

Postal code for the destination address of the shipment.

ShipToRegion

string

Region for the destination address of the shipment.

ShipToState

string

State for the destination address of the shipment.

ShippingMarks

string

Shipping marks.

ShippingMethodName

string

Shipping method.

SoldToPartyId

long

Unique identifier for sold-to party.

SoldToPartyName

string

Name for sold-to party.

SoldToPartyNumber

string

Identifier for sold-to party.

SourceSystemId

long

Unique identifier for a source system.
  • Primary Key

SourceSystemName

string

Source system name.

TareWeight

string

Tare weight.

TradeComplianceScreened

string

Indicates if shipment line was screened for trade compliance

TransportationReason

string

Describes Reason of Transport for Shipment.

TransportationShipment

string

Transportation Shipment of shipment

TransportationShipmentComplete

string

Indicator to check if the transportation shipment is completed or not.

UltimateDropoffDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Not currently used.

UltimateDropoffLocationId

long

Not currently used.

VehicleNumber

string

Identifier for a vehicle.

Volume

decimal

Volume of an item.

VolumeUOMCode

string

Unit of measure code for volume.

VolumeUOMName

string

Unit of measure for volume.

Waybill

string

Waybill for the shipment.

WeightUOMCode

string

Unit of measure code for weight.

WeightUOMName

string

Unit of measure for weight.