Power BI Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ShipmentTransactionRequestsshipmentsnotes

Tracks notes related to shipments in transaction requests, including routing and shipping marks for operational clarity.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request associated with shipment notes.
ShipmentsDeliveryInterfaceId [KEY] Long Identifier for the interface handling shipment delivery within the transaction request.
NoteId [KEY] Long Unique identifier for the note associated with the shipment transaction.
SourceObjectCode String Code representing the object type that the metadata defines for the note.
SourceObjectId String Unique identifier for the object that the metadata defines for the note.
PartyName String Name of the party associated with the shipment note.
NoteTxt String Content of the shipment note.
NoteTypeCode String Code that categorizes the type of note (for example, internal, customer-facing).
VisibilityCode String Code that defines the visibility level of the note (for example, public, private).
CreatorPartyId Long Unique identifier of the person who created the note.
CreatedBy String User or system identifier that created the shipment note.
CreationDate Datetime Timestamp when the shipment note was created.
LastUpdateDate Datetime Timestamp when the shipment note was last updated.
PartyId Long Unique identifier for the party associated with the note.
CorpCurrencyCode String Code representing the corporate currency used in transactions.
CurcyConvRateType String Type of currency conversion rate applied.
CurrencyCode String Code representing the currency used in the shipment transaction.
ContactRelationshipId Long Unique identifier for the relationship between the note and its associated party.
ParentNoteId Long Identifier linking the note to a parent note in case of nested notes.
LastUpdatedBy String User or system identifier that last updated the shipment note.
LastUpdateLogin String Identifier for the login session that last updated the note.
EmailAddress String Email address associated with the shipment note.
FormattedAddress String Formatted address of the party linked to the shipment note.
FormattedPhoneNumber String Formatted phone number of the party associated with the shipment note.
UpdateFlag Bool Indicates whether the note was updated (true/false).
DeleteFlag Bool Indicates whether the note is marked for deletion (true/false).
NoteNumber String System-generated or externally provided unique identifier for the note.
NoteTitle String Title of the shipment note, entered by the user.
Carrier String Name of the carrier handling the shipment.
ExternalSystemTransactionReference String Reference ID linking the shipment transaction to an external system.
Finder String Reference field used to search for specific shipment records.
FromActualShipDate Datetime Start date range for the actual shipment date in the transaction request.
FromInitialShipDate Datetime Start date range for the initially planned shipment date.
Item String Identifier or name of the item associated with the shipment transaction.
ModeOfTransportCode String Code representing the mode of transport used for shipping (for example, air, sea, land).
Order String Order number associated with the shipment.
PackingUnit String Packing unit or container used for the shipment.
ServiceLevelCode String Code representing the level of service for the shipment (for example, express, standard).
ShipFromOrganizationCode String Code identifying the organization location from which the shipment originates.
Shipment String Unique identifier or name of the shipment.
ShipmentLine Long Line number corresponding to a specific item in the shipment.
SoldToCustomer String Name of the customer to whom the shipment is sold.
ToActualShipDate Datetime End date range for the actual shipment date in the transaction request.
ToInitialShipDate Datetime End date range for the initially planned shipment date.
TransactionId Long Unique transaction ID linking this shipment note record to the transaction request.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454