1. SOAP Web Services for SCM
  2. Shipment Advice Shipment Line SDO

Shipment Advice Shipment Line SDO

An object to store the detailed shipment line information for a shipment.

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

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 Line Descriptive Flexfield SDO

Contains

Shipment Advice Serial Number SDO

Contains

Shipment Advice Prorated Shipping Cost SDO

Contains

Shipment Line Descriptive Flexfield SDO

Contains

Shipment Advice Shipping Cost SDO

Contained by

Shipment Advice Shipment SDO

Handled by

Manifest Shipment

Attributes

The following table describes attributes in the service data object.

Name Type Description

ArrivalSetName

string

Arrival Set Name of the Order Line

AssessableValue

decimal

Deemed price at which a product is valued, by a tax authority, for tax calculation purposes. The same product can have more than one assessable value, as given by different tax authorities.

BackorderedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Backordered quantity

BillToAddressLine1

string

Address line1 of bill-to location

BillToAddressLine2

string

Address line2 of bill-to location

BillToAddressLine3

string

Address line3 of bill-to location

BillToAddressLine4

string

Address line4 of bill-to location

BillToCity

string

City of bill-to location

BillToContactFirstName

string

First name of bill-to contact

BillToContactId

long

Unique identifier for bill-to contact

BillToContactLastName

string

Last name of bill-to contact

BillToContactName

string

Name of bill-to contact

BillToContactPhoneNumber

string

Contact number of bill-to party

BillToCountry

string

Country of bill-to location

BillToCounty

string

County of bill-to location

BillToFax

string

Fax of bill-to party

BillToLocationId

long

Unique identifier for bill-to location

BillToPartyId

long

Unique identifier for Bill to party

BillToPartyName

string

Name of bill-to party

BillToPartyNumber

string

Identifier for bill-to party

BillToPartySiteId

long

Party site id of Bill to party

BillToPostalCode

string

Postal code of bill-to location

BillToRegion

string

Region of bill-to location

BillToState

string

State of bill-to location

BillToURL

string

URL of bill-to pary

BusinessUnitId

long

Unique identifer of Business Unit

BusinessUnitName

string

Name of the Business Unit

CancelledQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Quantity being canceled

CarrierId

long

Unique identifier for a carrier.

CarrierName

string

Carrier name.

CarrierNumber

string

Identifier for a carrier.

CategoryId

long

Identifier for party created for a carrier.

ConvertedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Shipped or backordered quantity converted into ordered quantity unit

CurrencyCode

string

Unique identifier for Currency

CustomerItemDescription

string

Description of customer item

CustomerItemId

long

Unique identifier for customer item

CustomerItemName

string

Name of customer item

CustomerPONumber

string

Customer purchase order identifier.

DateRequested

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

Date on which the line is requested.

DateScheduled

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

Date on which the line is scheduled.

DefaultTaxationCountry

string

Country where the transaction is deemed to have taken place for taxation purposes.

DeliveryAssignmentId

long

Primary Key for assignment

DeliveryDetailId

long
Unique identifier for the shipment line.

  • Primary Key

DeliveryId

long

Unique identifier for a shipment.

DocumentSubType

string

Classification used by a tax authority to categorize a document associated with a transaction for a tax.

ExemptCertificateNumber

string

Number associated with the tax certificate issued by the taxing authority.

ExemptReasonCode

string

Code associated with the reason a tax exemption was granted and taken.

FOBCode

string

Freight on board code

FOBName

string

freight on board name

FinalDischargeLocationId

long

Final destination location for the purchases made by the customer. The location of the final customer or where the goods would be used is not necessarily the same as the initial ship-to location.

FirstPartyRegistrationName

string

Identifier for first party registration id

FirstPtyRegId

long

Unique sequence of letters and/or numbers assigned to a first party, by a tax authority, when it is registered and by which the first party registration will be identified.

FreightTermsCode

string

Freight terms code

FreightTermsName

string

Freight terms name

GrossWeight

decimal

Gross weight.

InitialDestination

string

Destination location of the initial leg of the transportation planned to deliver the shipment to the final destination.

InitialDestinationId

long

Destination location of the initial leg of the transportation planned to deliver the shipment to the final destination.

IntendedUseClassifId

decimal

Unique identifier for a ship-from location.

IntendedUseName

string

Tax classification Name based on the purpose for which a product is used.

InventoryItemId

long

Unique identifier for an item.

ItemDescription

string

Item description.

ItemName

string

Identifier for an item.

LegalEntity

string

Name of Legal entity

LegalEntityId

long

Unique identifier for Legal Entity

LoadSequenceNumber

long

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

LocatorId

long

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

LotNumber

string

Lot number of item.

ModeOfTransport

string

Mode of transport.

ModeOfTransportName

string

Mode of transport name.

NetWeight

decimal

Net weight.

OrderTypeCode

string

Source line type code.

OrderTypeName

string

Name of the Order Type

OrganizationCode

string

Identifier for Organization

OrganizationId

long

Unique Identifer for Organziation

OrganizationName

string

Name of Organization

OriginalSourceShipmentId

long

Unique identifier for a Original shipment as received from source system

OriginalSourceShipmentNumber

string

Identifier for a Original shipment as received from source system

POBillToBUId

long

Business Unit of Purchare Order

POHeaderId

long

Header id of Purchase order

POSoldToLEId

long

Unique identifier for Purchase Order sold-to legal entity

POVendorId

long

Party id of PO Vendor

POVendorPartyId

long

Unique identifier of Puchase Order's Vendor party

ParenInventoryItemDescription

string

Description of Parent inventory item

ParentInventoryItemId

long

Unique id of parent inventory item

ParentInventoryItemName

string

Name of Parent inventory item

ParentLPNId

long

Unique identifier for a parent packing unit.

ParentLPNName

string

Identifier for a parent packing unit.

PendingQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Represents the remaining quantity on the shipment lies from the original shipment line. Not currently used.

PendingQuantityFlag

boolean

Indicates there are additional shipments to be made on the original shipment line. Not currently used.

PjcProjectId

long

DFF column to save project ID for standardized project cost collection.

PjcTaskId

long

DFF column to save task ID for standardized project cost collection.

PreferredGrade

string

Preferred grade.

PreferredGradeName

string

Preferred grade.

ProductCategory

string

Type of product fiscal classification used to classify products. Related term(s): product fiscal classification.

ProductType

string

Nature or the product involved in a taxable transaction. For example, goods or services

ProjectCostingProject

string

DFF column to save project number for standardized project cost collection.

ProjectCostingProjectName

string

DFF column to save project name for standardized project cost collection.

ProjectCostingTask

string

DFF column to save task number for standardized project cost collection.

ProjectCostingTaskName

string

DFF column to save task name for standardized project cost collection.

RcvShipmentLineId

long

Unique identifier of supplier ASN shipment line.

ReleasedStatus

string

Pick Release Status

ReleasedStatusName

string

Pick Released Status Name

RequestedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Quantity of an item requested on a sales order line.

RequestedQuantityUOM

string

Unit of measure code for requested quantity.

RequestedQuantityUOMName

string

Unit of measure name for requested quantity.

Revision

string

Revision for an item.

SASerialNumber

Shipment Advice Serial Number SDO

Identifier for a serial number.

SAShipmentItemDFFVA

Shipment Line Descriptive Flexfield SDO

Additional Information of the shipment line.

SAShipmentProratedFreightCost

Shipment Advice Prorated Shipping Cost SDO

Prorated Shipping cost of Shipment Line

SAShippingCost

Shipment Advice Shipping Cost SDO

Identifier for a shipping cost.

SalesOrderLineNumber

string

Order line number from the sales order system.

SalesOrderNumber

string

Identifier for a sales order.

SalesOrderShipmentNumber

string

Order line shipment number from the sales order system.

SealCode

string

Seal Code

SecondaryBackorderedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Secondary backordered quantity

SecondaryCancelledQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Secondary Cancelled quantity

SecondaryConvertedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Secondary Converted quantity

SecondaryRequestedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Secondary requested quantity as ordered by customer.

SecondaryRequestedQuantityUOM

string

UOM code of secondary requested quantity

SecondaryRequestedQuantityUOMName

string

UOM name of secondary requested quantity

SecondaryShippedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Secondary Shipped quantity in requested quantity unit of measure.

SecondarySrcRequestedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Secondary Requested quantity as ordered by customer.

SecondarySrcRequestedQuantityUOM

string

UOM code of secondary requested quantity

SecondarySrcRequestedQuantityUOMName

string

UOM name of secondary requested quantity

SecondaryStagedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Secondary staged quantity

SerialNumber

string

Serial Number

ServiceLevel

string

Service level.

ServiceLevelName

string

Service level name.

ShipFromAddressLine1

string

Address Line 1 of ship-from location

ShipFromAddressLine2

string

Address Line 2 of ship-from location

ShipFromAddressLine3

string

Address Line 3 of ship-from location

ShipFromAddressLine4

string

Address Line 4 of ship-from location

ShipFromCity

string

City for Ship-from location

ShipFromCountry

string

Country of ship-from location

ShipFromCounty

string

County of ship-from location

ShipFromLocationId

long

Unique Id for Location

ShipFromPostalCode

string

Postal code of ship-from location

ShipFromRegion

string

Region of Ship-from Location

ShipFromState

string

State of ship-from location

ShipMethodCode

string

Ship method Code

ShipMethodName

string

Ship Method Name

ShipToAddressLine1

string

Address Line1 of ship-to location

ShipToAddressLine2

string

Address Line2 of ship-to location

ShipToAddressLine3

string

Address Line3 of ship-to location

ShipToAddressLine4

string

Address Line4 of ship-to location

ShipToCity

string

City of ship-to location

ShipToContactFirstName

string

First name of ship-to contact

ShipToContactId

long

Unique identifier for ship-to contact.

ShipToContactLastName

string

Last name of ship-to contact

ShipToContactName

string

Contact name of ship-to party

ShipToContactPartyName

string

Person to be contacted at ship-to customer.

ShipToContactPhoneNumber

string

Contact number of ship-to party

ShipToCountry

string

Country of ship-to location

ShipToCounty

string

County of ship-to location

ShipToFax

string

Fax of ship-to -party

ShipToLocationId

long

Unique identifier for ship-to location

ShipToLocationType

string

Type of ship-to location(internal or external)

ShipToPartyId

long

Unique identifer for ship-to party

ShipToPartyName

string

Name of ship-to party

ShipToPartyNumber

string

Identifier for ship-to party

ShipToPartySiteId

long

Party site id of ship to party

ShipToPostalCode

string

Postal code of ship-to location

ShipToRegion

string

Region of ship-to location

ShipToState

string

State of ship-to location

ShipToURL

string

URL of ship-to -party

ShipmentAdviceStatus

string

Indicates if the shipment advice has been sent to source system for a shipped line. Null or 'N' = Shipment advice not set. 'Y' = Shipment advice sent.

ShipmentItemInvStripingDFFVA

Shipment Line Descriptive Flexfield SDO

Additional information of InvStriping Attributes.

ShipmentPriorityCode

string

Shipment priority code.

ShipmentPriorityName

string

Shipment priority name.

ShippedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Shipped quantity in requested quantity unit of measure.

SoldToContactFirstName

string

First name of sold-to contact

SoldToContactId

long

Unique identifier for sold-to contact.

SoldToContactLastName

string

Last name of sold-to contact

SoldToContactName

string

Unique identifier for sold-to contact.

SoldToContactPhoneNumber

string

Contact number of sold-to contact

SoldToFax

string

Fax of sold-to party

SoldToPartyId

long

Unique identifier for sold-to party

SoldToPartyName

string

Name of sold-to party

SoldToPartyNumber

string

Identifier for sold-to party

SoldToURL

string

URL of sold-to party

SourceDocumentTypeId

long

Unique Identifier for Source Document Type

SourceDocumentTypeIdDisplay

string

Name of Source Document

SourceHeaderId

long

Unique identifier for a source order.

SourceHeaderNumber

string

Identifier for a source order.

SourceLineId

long

Unique identifier for a source order line.

SourceLineNumber

string

Identifier for a source order line.

SourceShipmentId

long

Shipment id from source system

SourceShipmentNumber

string

Shipment number from source system

SourceSystemId

long

Unique identifier for a source system.

SourceSystemName

string

Name of the Soure system from which Order has been placed

SplitFromDeliveryDetailId

long

Unique identifier of shipment line from which it is split from.

SrcRequestedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Requested quantity as ordered by customer.

SrcRequestedQuantityUOM

string

Ordered quantity unit of measure from the source system

SrcRequestedQuantityUOMName

string

Secondary ordered quantity unit of measure from the source system.

StagedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Staged quantity

Subinventory

string

Subinventory from which the requested item should be picked if the material is available.

TaxClassificationCode

string

Code for the tax classification, a grouping of taxes for reporting and processing purposes.

TaxInvoiceDate

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

Date of the tax invoice used to meet specific tax reporting requirements of different countries.

TaxInvoiceNumber

string

Number of the tax invoice used to meet specific tax reporting requirements of different countries.

ThirdPartyRegistrationName

string

Identifier for Third Party Registration Number

ThirdPtyRegId

long

Unique sequence of letters and/or numbers assigned to a third party or third party site, by a tax authority, when it is registered and by which the party or party site registration will be identified.

TrackingNumber

string

Tracking number.

TradeComplianceDate

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

Date when the trade compliance status is updated.

TradeComplianceReason

string

Reason for the trade compliance screening status.

TradeComplianceScreeningMethod

string

Method determining when the line to be screened for trade compliance.

TradeComplianceScreeningMethodName

string

Method name determining when the line to be screened for trade compliance.

TradeComplianceStatusCode

string

Status of the trade compliance screening of the shipment line.

TradeComplianceStatusName

string

Status name of the trade compliance screening of the shipment line.

TransportationPlanningDate

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

Date when the transportation planning of the shipment line is received.

TransportationPlanningStatusCode

string

Status code of the transportation planning of the shipment line.

TransportationPlanningStatusName

string

Status name of the transportation planning of the shipment line.

TransportationShipmentLine

string

Shipment line planned by the transportation management system.

TransportationShipmentNumber

string

A shipment planned by the transportation management system.

TrxBusinessCategory

string

Business classification used by Oracle Fusion Tax to identify and categorize an external transaction into a Fusion Tax transaction.

UnitPrice

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Unit price for the shipment line

UnitVolume

decimal

Unit Volume of the item on this delivery detail

UnitWeight

decimal

Unit Weight of the item on this delivery detail

UserDefinedFiscClass

string

Classification for any tax requirement that you cannot define using the existing fiscal classification types.

Volume

decimal

Volume of an item.

VolumeUOMCode

string

Unit of measure code for volume.

VolumeUOMName

string

Unit of measure for volume.

WeightUOMCode

string

Unit of measure code for weight.

WeightUOMName

string

Unit of measure for weight.