SSIS Components for Oracle Sales

Build 24.0.9060

ContactAddressPurposes

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 contact address purposes table.

PartyNumber [KEY] String False

Contacts.PartyNumber

AddressNumber [KEY] String False

ContactAddresses.AddressNumber

DeleteFlag Boolean False

Indicates if the address purpose for an address was deleted. If the value is True, then the address purpose is deleted. The default value is False.

Purpose String False

The use or purpose of the address.

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

BindUserPartyId String

The unique identifier of the contact.

PersonProfileId String

The unique identifier of the contact.

PartyId String

The unique identifier of the contact.

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