CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ShipmentLinesnotes

Oversees notes tied to shipment lines for additional information tracking.

Columns

Name Type Description
ShipmentLinesShipmentLine [KEY] Long The unique identifier for the shipment line associated with the note in the ShipmentLinesnotes table. This connects the note to a specific shipment line, allowing for detailed record-keeping of shipment-related notes.
NoteId [KEY] Long The unique identifier for the note within the ShipmentLinesnotes table. This ID allows for the distinct tracking of individual notes linked to shipment lines.
SourceObjectCode String A code representing the type of source object that the note pertains to. This could refer to shipment, inventory, or any other relevant object in the system.
SourceObjectId String A unique identifier for the source object associated with the note. This ID links the note to the specific object it references, facilitating easy retrieval of related notes for that object.
PartyName String The name of the party associated with the note. This could be the customer, vendor, or another stakeholder involved in the shipment or transaction.
NoteTxt String The text content of the note. This is the main field for entering the details or description of the note, such as comments or instructions regarding the shipment.
NoteTypeCode String A code that defines the type of note. This could be used to categorize the note for specific business purposes, such as general notes, shipping instructions, or customer feedback.
VisibilityCode String A code that determines the visibility of the note to different users. Options typically include INTERNAL (viewable only by internal users), EXTERNAL (viewable by external parties), and PRIVATE (restricted to the note creator).
CreatorPartyId Long The unique identifier of the party who created the note. This helps trace the origin of the note to a specific party or user within the system.
CreatedBy String The name or username of the individual who created the note. This field provides accountability by tracking the creator of the note.
CreationDate Datetime The date and time when the note was created. This timestamp is used for record-keeping and determining the chronology of notes related to a shipment.
LastUpdateDate Datetime The date and time when the note was last updated. This field helps track the most recent changes made to the note.
PartyId Long The unique identifier of the party related to the note. This can help associate the note with specific parties such as customers, suppliers, or internal users.
CorpCurrencyCode String The currency code used by the corporation for the note. This field is useful for financial notes where currency conversion or reporting is required.
CurcyConvRateType String The type of currency conversion rate used when processing the note. This can be helpful in cases where the note involves international transactions and currency exchange.
CurrencyCode String The specific currency code used for any amounts or transactions referenced in the note.
ContactRelationshipId Long The ID associated with the contact relationship for the note. This links the note to a specific contact, such as a person involved in the shipment or transaction.
ParentNoteId Long The ID of the parent note, if this note is a response or follow-up to another note. This allows for hierarchical note structures within the system.
LastUpdatedBy String The name or username of the individual who last updated the note. This field tracks the person responsible for any changes made to the note.
LastUpdateLogin String The login credentials or username of the person who last updated the note. This helps maintain an audit trail of note modifications.
EmailAddress String The email address associated with the note. This could be used for sending notifications or alerts related to the note.
FormattedAddress String The formatted address associated with the note, typically used for shipping or contact purposes. This field provides a standardized representation of the address.
FormattedPhoneNumber String The formatted phone number associated with the note, typically for contact purposes. This field ensures that phone numbers are displayed in a consistent format.
UpdateFlag Bool A flag indicating whether the note is marked for update. This flag helps identify notes that are in the process of being modified.
DeleteFlag Bool A flag indicating whether the note is marked for deletion. This helps manage the lifecycle of notes, ensuring that obsolete or irrelevant notes are removed from the system.
NoteNumber String A unique number assigned to the note. This can be used for referencing the note in reporting or communication.
NoteTitle String The title or summary of the note. This provides a brief description of the note's purpose or content.
Finder String A search identifier used to quickly locate the note within the system. This field is useful for filtering and retrieving specific notes related to shipment lines.
ShipmentLine Long The unique identifier for the shipment line associated with the note in the ShipmentLinesnotes table. This ensures that notes are linked to the correct shipment line for accurate record-keeping.

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