Full expand

Full collapse

Address

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

A supplier address represents the location information of a supplier. You can have multiple addresses for a supplier, each with different address purposes. For example, a supplier address with purposes for ordering and remit-to, or a supplier address with purpose a for bidding or RFQ.

Label, Plural Label

Address, Addresses

Qualified Label, Qualified Plural Label

Supplier Address, Supplier Addresses

Module

oraProcurementCoreSuppliers

Keys

• $primary: id

Base Business Object

• Module: oraCxSalesCommonParty

• Business Object: Address

Expand all

Collapse all

Fields

* Field can't be null

• additionalAttribute1 (string)

  The additional address element 1 to support flexible address format.

  Label

  Additional Address Element 1

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• additionalAttribute2 (string)

  The additional address element 2 to support flexible address format.

  Label

  Additional Address Element 2

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• additionalAttribute3 (string)

  The additional address element 3 to support flexible address format.

  Label

  Additional Address Element 3

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• additionalAttribute4 (string)

  The additional address element 4 to support flexible address format.

  Label

  Additional Address Element 4

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• additionalAttribute5 (string)

  The additional address element 5 to support flexible address format.

  Label

  Additional Address Element 5

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• address1 (string)

  The first line of the address.

  Label

  Address Line 1

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• address2 (string)

  The second line of the address.

  Label

  Address Line 2

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• address3 (string)

  The third line of the address.

  Label

  Address Line 3

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• address4 (string)

  The fourth line of the address.

  Label

  Address Line 4

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• addressLinesPhonetic (string)

  The phonetic or Kana representation of the Kanji address lines used in Japan.

  Label

  Address Lines Phonetic

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• addressStatus (string)*

  Status of the supplier address.

  Label

  Status

  Properties

  • not nullable
• building (string)

  The building name or number at a given address.

  Label

  Building

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• city (string)

  The name of the city.

  Label

  City

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• county (string)

  The name of the county.

  Label

  County

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • inherited
  • not nullable
  • overridable
• description (string)

  The description of the location.

  Label

  Description

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• doContactFlag (boolean)

  Indicates if the customer prefers to be contacted over this contact method.

  Label

  Do Contact Flag

  Properties

  • inherited
• doNotContactFlag (boolean)

  Indicates if the customer prefers not to be contacted over this contact method.

  Label

  Do Not Contact Flag

  Properties

  • inherited
• email (object)*

  An email address represents an email box to which messages are delivered for a person or business. For example, an email address for a supplier contact, or an email address for a supplier address location.

  Label

  Email

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Email

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	ownerTableId

• endDate (date)

  Date when the supplier address is no longer active.

  Label

  Inactive Date

  Properties

  • inherited
  • creatable
  • searchable
  • overridable
  • updatable
• fax (object)*

  A fax represents a phone number that can be used to contact a fax machine to reach a particular person or business. For example, a fax number for a supplier contact, or a fax number for a supplier address location.

  Label

  Fax

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Phone

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	ownerTableId

• floorNumber (string)

  The floor number at a given address or in a particular building when the building number is provided.

  Label

  Floor

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• formattedAddress (string)*

  Formatted display of the supplier address.

  Label

  Address

  Properties

  • inherited
  • not nullable
• id (int64)*

  The unique identifier for an address.

  Label

  Site ID

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• identifyingAddressFlag (boolean)*

  Indicates whether the identifying address for the party in the context of a specific relationship. Y for the identifying site, N for sites that aren't the identifying site.

  Label

  Primary

  Properties

  • inherited
  • creatable
  • searchable
  • not nullable
  • overridable
  • updatable
• latitude (big-decimal)

  Used to store latitude information for the location for spatial proximity and containment purposes.

  Label

  Latitude

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• longitude (big-decimal)

  Used to store longitude information for the location for spatial proximity and containment purposes.

  Label

  Longitude

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• mailstop (string)

  A user-defined code to indicate a mail drop point within their organization.

  Label

  Mail Stop

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• name (string)

  Name of the supplier address.

  Label

  Address Name

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• personalFlag (boolean)

  Indicates if this is a personal address of the contact.

  Label

  Personal Flag

  Properties

  • inherited
  • searchable
  • overridable
• phone (object)*

  A phone represents a number that you can call to reach a particular person or business. For example, a phone number for a supplier contact or a phone number for a supplier address location.

  Label

  Phone

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Phone

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	ownerTableId

• postalCode (string)

  The postal code as defined by the countrywide postal system.

  Label

  Postal Code

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• postalPlus4Code (string)

  The four digit extension to the postal code.

  Label

  Postal Code Extension

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• province (string)

  The name of the province.

  Label

  Province

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• state (string)

  The name of the state.

  Label

  State

  Properties

  • inherited
  • creatable
  • overridable
  • updatable
• taxProfile (object)*

  A tax profile represents the body of information that relates to a party's transaction tax activities. A tax profile can include main and default information, tax registration, tax exemptions, party fiscal classifications, tax reporting codes, configuration options, and service subscriptions. Third-party tax profiles are for parties with the usage of customer, supplier, and their addresses or sites. For example, a tax profile for supplier Seven Corporation or a tax profile for address San Francisco Office in Seven Corporation.

  Label

  Supplier Site Tax Profiles

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: AddressTaxProfile

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	partyId

• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Created On

  Properties

  • inherited
  • searchable
  • not nullable
  • overridable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • inherited
  • searchable
  • not nullable
  • overridable
• type (enumeration: PartySiteType)

  This address type of the address based on the lookup. This can be null or One-Time.

  Label

  One-Time Address

  Type

  • Module: oraCxSalesCommonParty

  • Enumeration Type: PartySiteType

  Properties

  • inherited
  • creatable
  • overridable
  • updatable

  Valid Values

  • ONE_TIME
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • inherited
  • not nullable
  • overridable

Expand all

Collapse all

Reference Objects

• country (object)

  The country code of the address.

  Label

  Country

  Cardinality	Target Object
  One to One	Module: oraCommonAppsInfraObjects Business Object: Territory

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  countryCode	territoryCode

  Properties

  • inherited
• timezone (object)

  The time zone code for the address.

  Label

  Time Zone

  Cardinality	Target Object
  One to One	Module: oraCommonAppsInfraObjects Business Object: Timezone

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  timezoneCode	timezoneCode

  Properties

  • inherited

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • addressStatus (string)

    Status of the supplier address.

    Label

    Status

    Properties

    • not nullable
  • endDate (date)

    Date when the supplier address is no longer active.

    Label

    Inactive Date

    Properties

    • inherited
    • creatable
    • searchable
    • overridable
    • updatable
  • formattedAddress (string)

    Formatted display of the supplier address.

    Label

    Address

    Properties

    • inherited
    • not nullable
  • id (int64)

    The unique identifier for an address.

    Label

    Site ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • name (string)

    Name of the supplier address.

    Label

    Address Name

    Properties

    • inherited
    • creatable
    • overridable
    • updatable

Other Properties

Property	Value
Application Package Name	ora_procurement_core_suppliers
Extensible	No

Back to Top