ODBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

ShipmentLineTransactionRequestsshipmentLinesnotes

Stores and organizes notes related to shipment lines, including packing and shipping instructions for enhanced operational clarity.

Columns

Name Type SupportedFinders Description
ShipmentLineTransactionRequestsTransactionId [KEY] Long The unique identifier for the shipment line transaction request related to the note.
ShipmentlinesDeliveryDetailInterfaceId [KEY] Long The unique identifier for the delivery detail interface associated with the shipment line note.
NoteId [KEY] Long The unique identifier of the note associated with the shipment line.
SourceObjectCode String Abbreviation that identifies the object defined by the metadata for the note.
SourceObjectId String Unique value identifying the object defined by the metadata for the note.
PartyName String The name of the party associated with the note.
NoteTxt String Text content of the actual note.
NoteTypeCode String Abbreviation identifying the category/type of the note.
VisibilityCode String Abbreviation identifying the visibility level of the note (for example, private, public).
CreatorPartyId Long The unique identifier for the person or entity who created the note.
CreatedBy String The user or system that created the note.
CreationDate Datetime The date and time when the note was created.
LastUpdateDate Datetime The date and time when the note was last updated.
PartyId Long The unique identifier of the party associated with the note.
CorpCurrencyCode String Abbreviation identifying the corporate currency used for the note.
CurcyConvRateType String The type of currency conversion rate used for the note.
CurrencyCode String Abbreviation for the currency used in the note.
ContactRelationshipId Long Unique identifier for the contact relationship associated with the note.
ParentNoteId Long The unique identifier of the parent note, if the note is a reply or part of a thread.
LastUpdatedBy String The user or system that last updated the note.
LastUpdateLogin String Login ID of the user who last updated the note.
EmailAddress String The email address associated with the note.
FormattedAddress String The formatted address associated with the note.
FormattedPhoneNumber String The formatted phone number associated with the note.
UpdateFlag Bool Flag indicating whether the note has been updated.
DeleteFlag Bool Flag indicating whether the note has been deleted.
NoteNumber String An alternate unique identifier for the note, typically system-generated or from an external system.
NoteTitle String The title or subject of the note entered by the user.
BaseItem String FindByLineAttributes The base item associated with the note.
BaseItemId Long FindByLineAttributes The unique identifier of the base item linked to the note.
Carrier String FindByLineAttributes The carrier responsible for the shipment line associated with the note.
CarrierId Long FindByLineAttributes The unique identifier for the carrier of the shipment.
CarrierNumber String FindByLineAttributes The carrier number for the shipment related to the note.
EndAssemblyItem String FindByLineAttributes The end assembly item associated with the shipment line and the note.
Finder String A reference field used to search for the note in the system.
FromRequestedDate Datetime FindByLineAttributes The start date of the requested date range for the shipment line associated with the note.
FromScheduledShipDate Datetime FindByLineAttributes The start date of the scheduled ship date range for the shipment line associated with the note.
InitialDestinationId Long FindByLineAttributes The unique identifier for the initial destination of the shipment line.
Item String FindByLineAttributes The item associated with the shipment line noted in the record.
ItemId Long FindByLineAttributes The unique identifier of the item related to the shipment line.
ModeOfTransportCode String FindByLineAttributes The code identifying the mode of transport for the shipment line.
OrderTypeCode String FindByLineAttributes The order type code related to the shipment line note.
OrganizationCode String FindByLineAttributes The abbreviation of the organization associated with the shipment line.
OrganizationId Long FindByLineAttributes The unique identifier for the organization handling the shipment line.
OrganizationName String FindByLineAttributes The name of the organization managing the shipment line.
ServiceLevelCode String FindByLineAttributes The service level code for the shipment line, indicating the priority of shipping.
ToRequestedDate Datetime FindByLineAttributes The end date of the requested date range for the shipment line related to the note.
ToScheduledShipDate Datetime FindByLineAttributes The end date of the scheduled ship date range for the shipment line related to the note.
TransactionId Long PrimaryKey The unique identifier of the transaction associated with the shipment line note.
TransportationShipment String FindByLineAttributes The transportation shipment reference associated with the shipment line note.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770