Excel Add-In for Oracle Sales

Build 24.0.9062

AccountAddressPurposes

The address purpose resource is used to view, create, or modify the address purpose. The address purpose describes the use of an address, such as shipping address or billing address.

Columns

Name Type ReadOnly References Description
AddressPurposeId [KEY] Long False

This is the primary key of the address purpose table.

PartyNumber [KEY] String False

Accounts.PartyNumber

AddressNumber [KEY] String False

AccountAddresses.AddressNumber

DeleteFlag Boolean False

Indicates whether the address purpose is to be deleted. If the value is Y, then the address purpose has to be deleted. The default value is N.

Purpose String False

The purpose of the address. A list of valid values is defined in the lookup PARTY_SITE_USE_CODE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.

AccountLastUpdateDate Datetime False

The date and time when the opportunity was last updated.

SourceSystem String False

The name of external source system for the address purpose denoted by a code, which is defined by an administrator as part of system setup.

SourceSystemReferenceValue String False

The unique identifier for the address purpose from the external source.

Pseudo-Columns

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

Name Type Description
Finder String

Input specifying the Finder type.

FocusPartyId String

The unique identifier of the child account to be returned at the top by the Direct Accounts finder.

ParentPartyId String

The unique identifier of the account used to search the direct child accounts.

PartyId String

The unique identifier of the account.

BindUserPartyId String

The unique identifier of the party. Used in MyAccounts finder.

OrganizationProfileId String

The unique identifier of the organization.

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