Power BI Connector for Oracle Sales

Build 24.0.9060

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

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.

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.9060