Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

PackingUnitsnestedPackingUnitsnotes

Stores and retrieves notes, comments, and instructions related to nested packing units for operational clarity.

Columns

Name Type Description
PackingUnitsPackingUnitId [KEY] Long Unique identifier for the packing unit within the PackingUnitsnestedPackingUnitsnotes table.
NestedpackingunitsPackingUnitId [KEY] Long Unique identifier for the nested packing unit associated with the current packing unit in the PackingUnitsnestedPackingUnitsnotes table.
NoteId [KEY] Long Unique identifier for the note entry in the PackingUnitsnestedPackingUnitsnotes table.
SourceObjectCode String Abbreviation identifying the type of object linked to the note, as defined in the OBJECTS metadata. For packing units, this is typically 'SHIPPING_LPN'.
SourceObjectId String A unique value that identifies the specific packing unit related to the note.
PartyName String The name of the party associated with the note in the PackingUnitsnestedPackingUnitsnotes table.
NoteTxt String The actual content or text of the note, detailing information related to the packing unit.
NoteTypeCode String Abbreviation representing the classification or category of the note type, such as 'INFO' or 'WARNING'.
VisibilityCode String Abbreviation representing the visibility level of the note, indicating who can view it (for example, 'PRIVATE', 'PUBLIC').
CreatorPartyId Long A unique identifier for the party that created the note within the PackingUnitsnestedPackingUnitsnotes table.
CreatedBy String Name or identifier of the person or system that created the note.
CreationDate Datetime Timestamp representing when the note was created in the system.
LastUpdateDate Datetime Timestamp representing when the note was last updated.
PartyId Long Unique identifier for the party associated with the note in the PackingUnitsnestedPackingUnitsnotes table.
CorpCurrencyCode String Currency abbreviation representing the corporate currency. This field is not used in packing units but may be reserved for future functionality.
CurcyConvRateType String Type of currency conversion rate used for the note, if applicable. Currently not used in the packingUnits resource.
CurrencyCode String Abbreviation representing the currency associated with the note. This field is not currently utilized in the packingUnits resource.
ContactRelationshipId Long Unique identifier for the contact relationship linked to the note. This field is currently not in use for packing units.
ParentNoteId Long Unique identifier for the parent note, if this note is a response or part of a series.
LastUpdatedBy String Name or identifier of the person or system who last updated the note.
LastUpdateLogin String Login or identifier of the user who last updated the note.
EmailAddress String Email address associated with the note, if provided.
FormattedAddress String Formatted address linked to the note, typically the physical address of the associated party.
FormattedPhoneNumber String Phone number associated with the note, formatted for display purposes.
UpdateFlag Bool Flag indicating whether the note is being updated (true) or not (false).
DeleteFlag Bool Flag indicating whether the note is marked for deletion (true) or not (false).
NoteNumber String Alternate identifier for the note, which could be system-generated or from an external source, used for reference.
NoteTitle String The title or subject of the note, as provided by the user when the note is created.
Finder String A search keyword or identifier used for retrieving the note within the system.
PackingUnitId Long Unique identifier for the packing unit linked to the note in the PackingUnitsnestedPackingUnitsnotes table.
PPackingUnit String An alternate or related packing unit identifier, used for specific packing unit relationships within the notes.

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