Power BI Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ShipmentTransactionRequestsshipmentsunpackedLinesnotes

Stores specific notes and instructions for unpacked shipment lines, including packing and shipping recommendations.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request related to unpacked shipment line notes.
ShipmentsDeliveryInterfaceId [KEY] Long Identifier for the interface managing shipment delivery in the transaction request.
UnpackedlinesDeliveryDetailInterfaceId [KEY] Long Unique identifier for the unpacked shipment line delivery details linked to notes.
NoteId [KEY] Long Unique identifier for the note associated with the shipment line.
SourceObjectCode String Abbreviation identifying the metadata object type for the note.
SourceObjectId String Unique identifier of the metadata object associated with the note.
PartyName String Name of the party associated with the shipment note.
NoteTxt String Full text content of the note.
NoteTypeCode String Code representing the category or classification of the note.
VisibilityCode String Code indicating the visibility level of the note (for example, internal, external).
CreatorPartyId Long Unique identifier of the person or entity that created the note.
CreatedBy String User or system process that created the unpacked shipment line note record.
CreationDate Datetime Date and time when the note was created.
LastUpdateDate Datetime Date and time when the note was last updated.
PartyId Long Unique identifier of the party associated with the note.
CorpCurrencyCode String Corporate currency code used for financial transactions related to the shipment.
CurcyConvRateType String Type of currency conversion rate applied to the transaction.
CurrencyCode String Currency code used for financial aspects of the shipment.
ContactRelationshipId Long Unique identifier for the relationship between parties related to the note.
ParentNoteId Long Unique identifier for the parent note if this note is part of a thread.
LastUpdatedBy String User or system process that last updated the unpacked shipment line note record.
LastUpdateLogin String Login information of the user who last modified the note.
EmailAddress String Email address of the party related to the note.
FormattedAddress String Formatted address of the party associated with the shipment note.
FormattedPhoneNumber String Formatted phone number of the party associated with the shipment note.
UpdateFlag Bool Indicates whether the note has been updated (true/false).
DeleteFlag Bool Indicates whether the note is marked for deletion (true/false).
NoteNumber String Alternate unique identifier for the note, system-generated or imported from an external system.
NoteTitle String Title or subject of the note entered by the user.
Carrier String Name of the carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String Reference to the transaction in an external system.
Finder String Searchable reference field for locating shipment notes.
FromActualShipDate Datetime Start date range for the actual shipment departure.
FromInitialShipDate Datetime Start date range for the initially planned shipment departure.
Item String Name of the item associated with the shipment note.
ModeOfTransportCode String Code representing the mode of transport (for example, air, sea, land).
Order String Order number linked to the shipment containing this note.
PackingUnit String Packing unit associated with the unpacked shipment note.
ServiceLevelCode String Shipping service level code associated with the shipment note.
ShipFromOrganizationCode String Code identifying the organization that ships the item.
Shipment String Unique identifier for the shipment containing this note.
ShipmentLine Long Unique identifier for the shipment line associated with this note.
SoldToCustomer String Customer to whom the shipment is sold.
ToActualShipDate Datetime End date range for the actual shipment arrival.
ToInitialShipDate Datetime End date range for the initially planned shipment arrival.
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