SSIS Components for Oracle Fusion Cloud SCM

Build 23.0.8839

PackingUnitsnotes

PackingUnitsnotes

Columns

Name Type Description
PackingUnitsPackingUnitId [KEY] Long PackingUnitsPackingUnitId of PackingUnitsnotes
NoteId [KEY] Long The unique identifier of the note. This is the primary key of the notes table.
SourceObjectCode String This is the source object code for the source object as defined in OBJECTS Metadata.
SourceObjectId String The unique identifier of the parent source object associated to the note.
PartyName String The name of the party.
NoteTxt String The column which stores the actual note text.
NoteTypeCode String The note type code for categorization of note.
VisibilityCode String The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private.
CreatorPartyId Long The unique identifier of the party.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
LastUpdateDate Datetime The date when the record was last updated.
PartyId Long The unique identifier of the party.
CorpCurrencyCode String The corporate currency code for extensibility.
CurcyConvRateType String The currency conversion rate type for extensibility.
CurrencyCode String The currency code for extensibility.
ContactRelationshipId Long The relationship ID populated when the note is associated with a contact.
ParentNoteId Long The unique identifier of the note. This is the primary key of the notes table.
LastUpdatedBy String The unique identifier of the note. This is the primary key of the notes table.
LastUpdateLogin String The login of the user who last updated the record.
EmailAddress String The email address of the user who created the note.
FormattedAddress String The address of the user who created the note.
FormattedPhoneNumber String The phone number of the user who created the note.
UpdateFlag Bool Indicates whether the user can update the note.
DeleteFlag Bool Indicates whether the user has access to delete the note.
NoteNumber String The alternate unique identifier of the note. A user key that's system generated or from an external system.
NoteTitle String The title of the note entered by the user.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PackingUnitId Long PackingUnitId
Finder String finder
PPackingUnit String pPackingUnit

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839