Accounts

The account represents a staff member in Oracle B2C Service.

Table-Specific Information

SELECT

The 本製品 will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the 本製品.

SELECT * FROM Accounts WHERE id = 12
SELECT * FROM Accounts WHERE id > 15
SELECT * FROM Accounts WHERE lookUpName LIKE '%test'
SELECT * FROM Accounts WHERE id IN (12, 23, 123)
SELECT * FROM Accounts WHERE lookUpName IS NOT NULL

INSERT

Insert can be executed by specifying the login, namefirst, namelast, profileId, staffGroupId and newpassword columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Accounts (login, namefirst, namelast, profileId, staffGroupId, newpassword) VALUES ('testadministrator', 'abc', 'xyz', '14', '102243', 'testpw')

UPDATE

Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Accounts SET namelast = 'abcd' WHERE id = 1

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Accounts WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
CountryId	Long	False	Id of country. The default country identifier.
CountrylookUpName	String	False	LookUpName of country. The default country identifier.
CreatedTime	Datetime	True	The date and time when the account was created. This attribute is read-only.
DisplayName	String	False	The display name of the account.
DisplayOrder	Int	False	The order in which this staff account is displayed relative to other members of the same group.
EmailNotificationId	Long	False	Id of emailNotification. The format the staff member prefers for email notifications.
EmailNotificationlookUpName	String	False	LookUpName of emailNotification. The format the staff member prefers for email notifications.
Id [KEY]	Long	True	The unique identifier of the account.
Login	String	False	The user name used for authentication.
LookupName	String	True	The name used to look up the account.
ManagerId	Long	False	Id of manager. The manager of the staff member.
ManagerlookUpName	String	False	LookUpName of manager. The manager of the staff member.
NewPassword	String	False	The new password for authentication. It is stored with a one-way encryption in the system. This attribute is write-only.
NotificationPending	Bool	True	Indicates whether any notifications are pending. This attribute does not have a default value and is read-only.
PasswordExpirationTime	Datetime	True	The date and time when the password is set to expire. This attribute is read-only.
ProfileId	Long	False	Id of profile. The profile to which the staff account is assigned.
ProfilelookUpName	String	False	LookUpName of profile. The profile to which the staff account is assigned.
Signature	String	False	The email signature of the account.
StaffGroupId	Long	False	Id of staffGroup. The group to which the staff member is assigned.
StaffGrouplookUpName	String	False	LookUpName of staffGroup. The group to which the staff member is assigned.
UpdatedTime	Datetime	True	The date and time when the account was last updated. This attribute is read-only.
AttributesaccountLocked	Bool	False	Indicates whether the account is temporarily locked. For example, you may lock a staff member's account who has taken a leave of absence. An account automatically gets locked if the staff member has exceeded the number of invalid login attempts or if the password has expired. The default value is false.
AttributescanModifyEmailSignature	Bool	False	Indicates whether the staff member can modify the email signature. The default value is false.
AttributesforcePasswordChange	Bool	False	Indicates whether the staff member must change the password at the next login. The value remains true until the staff member changes the password. The default value is false.
AttributesinfrequentUser	Bool	False	Indicates whether the staff member is considered as an infrequent user seat, as opposed to a full seat. The default value is false.
AttributespasswordNeverExpires	Bool	False	Indicates whether the staff member's account password never expires. This setting overrides system-wide password expiration configurations. The default value is false.
AttributespermanentlyDisabled	Bool	False	Indicates whether the staff member's account is permanently disabled. For example, an account is permanently disabled when a staff member leaves your organization. A disabled account appears in the tree of the Staff Accounts management console if Show Disabled setting is enabled, but you cannot deselect the Permanently Disable check box if you edit the account. You can reuse the login name of a permanently disabled account for a different account. The default value is false.
AttributesstaffAssignmentDisabled	Bool	False	Indicates whether the staff member's account cannot be assigned to incidents, answers, opportunities, and tasks. The default value is false.
AttributesviewsReportsDisabled	Bool	False	Indicates whether the staff member's account cannot be included in the list for filters in reports. The default value is false.
AttributesvirtualAccount	Bool	True	Indicates whether the staff member's account is virtual. The default value is false. This attribute is read-only.
Namefirst	String	False	The first name of the person.
Namelast	String	False	The surname or last name of the person.
NameFuriganafirst	String	False	The first name of the person.
NameFuriganalast	String	False	The surname or last name of the person.
SalesSettingsdefaultCurrencyId	Long	False	Id of defaultCurrency. The default currency ID.
SalesSettingsdefaultCurrencylookUpName	String	False	LookUpName of defaultCurrency. The default currency ID.
SalesSettingsterritoryId	Long	False	Id of territory. The sales territory ID.
SalesSettingsterritorylookUpName	String	False	LookUpName of territory. The sales territory ID.
ServiceSettingsscreenPopPort	Int	False	The port number assigned for screen-pop alerts for the staff account. It is used in Citrix and Terminal Services environments where there are multiple agents logged in to different sessions on the same machine.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
emails	String	The list of email addresses.
phones	String	The list of phone numbers.

SSIS Components for Oracle Service Cloud