ODBC Driver for Oracle Sales

Build 24.0.9060

Resources

The resources resource is used to view, create, and update a resource. A resource is a person within the deploying company who can be assigned work to accomplish business objectives, such as sales persons or partner members.

Columns

Name Type References Description
ResourceProfileId [KEY] Long Unique identifier for the Resource Profile.
CreatedBy String Who column: indicates the user who created the row.
CreationDate Datetime Who column: indicates the date and time of the creation of the row.
DeleteFlag Bool Indicates if the user can delete the resource.
EmailAddress String E-mail address
EndDateActive Date Indicates the date at which the resource becomes inactive
FormattedAddress String Primary Formatted address for the resource
FormattedPhoneNumber String Primary Formatted phone number for the resource
JobMeaning String Job for this resource if it is employee
LastUpdateDate Datetime Who column: indicates the date and time of the last update of the row.
LastUpdateLogin String Who column: indicates the session login associated to the user who last updated the row.
LastUpdatedBy String Who column: indicates the user who last updated the row.
Manager String Name of the manager for this resource
ManagerPartyId Long
PartyId Long Identifier for the party. Foreign key to the HZ_PARTIES PARTY_ID.
PartyName String Name of the Party
PartyNumber [KEY] String Unique identification number for this party
PersonFirstName String Peron First Name
PersonLastName String Peron LastName
PersonLastNamePrefix String Resource Peron Last name
PersonMiddleName String Peron Middle Name.
PersonNameSuffix String Peron Name suffix
PersonPreNameAdjunct String Person Preferred Name adjacency
PersonPreviousLastName String perin Previous flag mage
PersonSecondLastName String peron secind last name
PrimaryOrganization String Primary organizations for this resource
RecordSet String
ResourceType String Type of Resource ex employee
StartDateActive Date Indicates the date at which the resource becomes active
UpdateFlag Bool Indicates if the user can update the resource.
Url String Primary URL for the resource
Usage String Read only party usage for resource party

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.
BindSysdate String The identifier for the resource based on the manager reports flag.

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