SSIS Components for Oracle Sales

Build 24.0.9060

EmployeeResourceAttachments

The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture

Columns

Name Type References Description
AttachedDocumentId [KEY] Long This is the hash key of the attributes which make up the composite key--- AttachedDocumentId and DocumentId1 ---for the Attachments resource and used to uniquely identify an instance of Attachments. The client should not generate the hash key value. Instead, the client should query on the Attachments collection resource with a filter on the primary key values in order to navigate to a specific instance of Attachments.
PartyNumber [KEY] String The unique identifier for the resource party.
ContentRepositoryFileShared Boolean Indicates if the attachment is shared.
CreatedBy String The user who uploaded the picture attachment.
CreationDate Datetime The date when the picture attachment was uploaded.
DatatypeCode String The data type for the picture attachment.
Description String The description of the picture attachment.
DmFolderPath String The folder path where the picture attachment exists.
ErrorStatusCode String The error code, if any, for the attachment.
ErrorStatusMessage String The error message, if any, for the attachment.
ExpirationDate Datetime The expiration date of the contents in the attachment.
FileContents String The contents of the attachment.
FileName String The name of the attachment file.
FileUrl String The URL of the attachment file.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.
Title String The title of the attachment.
UploadedFileContentType String The content type of the attachment.
UploadedFileLength Long The length of the attachment file.
UploadedFileName String The name of the attachment file.
UploadedText String The text uploaded in the attachment.
Uri String The URI of the attachment.
Url String The URL of the attachment.
UserName String The login associated with the attachment.

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
Finder String Input specifying the Finder type.
EmailAddress String The e-mail address of the resource.
BindSysdate String The identifier for the resource based on the manager reports flag.
PartyId String The unique identifier for the resource party.
ResourceProfileId String The unique primary key identifier for the resource profile.

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