Update a household

patch

/crmRestApi/resources/11.13.18.05/households/{PartyNumber}

Request

Path Parameters
  • The unique primary identifier for the household party. The profile option HZ_GENERATE_PARTY_NUMBER controls whether the attribute value can be system generated or user-provided during create. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task. Inactive records can't be updated.
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Supported Media Types
Request Body - application/json ()
Root Schema : schema
Type: object
Show Source
  • Additional Identifiers
    Title: Additional Identifiers
    The additional identifiers resource is used to view, create, update, and delete an additional identifiers such as driver's license number or passport number.
  • Additional Names
    Title: Additional Names
    The additional name resource is used to view, create, update, and delete additional names associated with an account. You can use the resource to capture other names associated with an account, such as a maiden name, or a brand name.
  • Addresses
    Title: Addresses
    The addresses resource is used to view, create, update, and delete addresses of a household. An address contains the detailed location information of a household.
  • Title: Additional Address Element 1
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 2
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 3
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 4
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 5
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Address Line 1
    Maximum Length: 240
    First line of address.
  • Title: Address Line 2
    Maximum Length: 240
    Second line of address.
  • Title: Address Line 3
    Maximum Length: 240
    Third line of address.
  • Title: Address Line 4
    Maximum Length: 240
    Fourth line of address.
  • Title: Address Lines Phonetic
    Maximum Length: 560
    Phonetic or Kana representation of the Kanji address lines (used in Japan)
  • Title: Type
    Additional information as type of address like BillTo, ShipTo.
  • Title: Annual Income
    The annual income of the household. If not provided, then the value is NULL.
  • Attachments
    Title: Attachments
    The attachments resource is used to view, create, update, and delete attachments of a household. An attachment includes additional information about a household.
  • Title: Average Age
    The average age of the household.
  • Title: Building
    Maximum Length: 240
    Specific building name or number at a given address.
  • Title: Certification Level
    Maximum Length: 30
    The certification level of a household. A list of valid certification level codes is defined using the lookup HZ_PARTY_CERT_LEVEL. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Certification Reason
    Maximum Length: 30
    The reason for the household current certification level assignment. A list of valid certification reason codes are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Children Below 7 Years of Age
    The number of children in the age range 0-6.
  • Title: Children Aged 13 to 18 Years
    The number of children in the age range 13-18.
  • Title: Children Aged 7 to 12 Years
    The number of children in the age range 7-12.
  • Title: City
    Maximum Length: 60
    The city element of address.
  • Title: Classification Category
    A valid classification category code for the household which will be marked as primary and is defined by an admin.
  • Title: Classification Code
    A valid classification code corresponding to the classification category and which will be marked as primary.
  • Title: Comments
    Maximum Length: 2000
    The description for a group.
  • Default Value: 0
    The unique identifier of the conflict for the household data record. This number is used by mobile or portable applications that consume the web service.
  • Contact Points
    Title: Contact Points
    The contact point resource is used to view, create, update, and delete contact points for an account. Contact points can be geographical addresses, phone numbers, e-mail IDs, URLs, messenger IDs, and so on.
  • Maximum Length: 15
    The corporate currency code associated with the household. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Country
    Maximum Length: 2
    Country code of the address.
  • Title: County
    Maximum Length: 60
    County element of address.
  • Title: Created by Application
    Default Value: HZ_WS
    The application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Maximum Length: 30
    The application module that created the household record.
  • Maximum Length: 30
    The currency conversion rate type associated with the household. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency
    Maximum Length: 15
    The currency code associated with the household. The default value is the value specified in the profile option ZCA_COMMON_CORPORATE_CURRENCY.
  • Aux Classifications
    Title: Aux Classifications
    The aux classifications resource is used to view, create, update, and delete the auxiliary classifications of the customers associated with the households. Auxiliary classification enable you to categorize customers into different groups, such as commercial or private.
  • Title: Number of Dependents
    The number of dependents on the household.
  • Maximum Length: 1
    Default Value: Y
    Indicates whether the row has the latest change in the day. If the value is True, then this row has the latest change in the day.
  • The order of the different changes made during the day. The lowest value represents the earliest change in the day.
  • Title: Email
    Maximum Length: 320
    The e-mail address of the contact point.
  • Title: Email Format
    Maximum Length: 30
    The format for an e-mail preferred by the household, such as HTML or ASCII.
  • Title: Email Verification Date
    The date when email address was last verified.
  • Title: Email Verification Status
    Maximum Length: 30
    The status code of the email address verification. The values based on lookup are valid, invalid, or partially invalid for email.
  • Title: Favorite
    Maximum Length: 10
    Default Value: false
    Indicates if the household is a favorite household. The default value is false.
  • Title: Floor
    Maximum Length: 40
    The specific floor number at a given address or in a particular building when the building number is provided.
  • The unique identifier of the group party.
  • Title: Name
    Maximum Length: 360
    The unique identification number for this party. Data stored in this attribute comes from PARTY_NUMBER in HZ_PARTIES.
  • Title: Size
    The size of the group.
  • Title: Mail Stop
    Maximum Length: 60
    A user-defined code to indicate a mail drop point within their organization
  • Title: Median Age
    The median age.
  • Title: Named Household
    Maximum Length: 1
    Default Value: false
    Indicates whether a sales account is a named sales account. Possible values are True or False. If the value is True, then the sales account is a named sales account. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Notes
    Title: Notes
    The note resource is used to view, create, update, and delete notes associated with a household. A note captures comments, information, or instructions related to a household.
  • The internal version number for the email. It is the number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the group. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the party. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the phone. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the sales account. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • Title: Owner ID
    The unique identifier of sales account owner. To assign an owner to the sales account, you must provide either owner's party identifier, party number, or email address.
  • Title: Registry ID
    Maximum Length: 30
    The alternate unique identifier of the household party record.
  • Title: Area Code
    Maximum Length: 20
    The area code for the telephone number.
  • Title: Phone Country Code
    Maximum Length: 10
    The international country code for a telephone number, such as 33 for France.
  • Title: Extension
    Maximum Length: 20
    The additional number addressed after initial connection to an internal telephone system.
  • Title: Phone
    Maximum Length: 40
    A telephone number formatted in the local format. The number should not include area code, country code, or extension.
  • Title: Phone Verification Date
    The date when phone number was last verified.
  • Title: Phone Verification Status
    Maximum Length: 30
    The status code of the phone number verification. The values based on lookup are valid and invalid for phone.
  • Title: Postal Code
    Maximum Length: 60
    The postal code as defined by the formal countrywide postal system.
  • Title: Postal Code Extension
    Maximum Length: 20
    Four digit extension to the United States Postal ZIP code.
  • Title: Preferred Contact Method
    Maximum Length: 30
    Indicates how a household prefers to be contacted. Validated against lookup type PREFERRED_CONTACT_METHOD. A list of valid codes is defined in the lookup HZ_PREFERENCE. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Preferred Functional Currency
    Maximum Length: 15
    The code indicating the preferred currency for the group.
  • Primary Addresses
    Title: Primary Addresses
    The primary addresses resource is used to view, create, update, and delete the primary addresses of the households. A primary address is the default communication address of a household.
  • The unique identifier of the primary contact. To specify the contact for an household, you can provide either contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • The alternate key identifier of the of the primary contact. To specify the contact for a household, you can either provide contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • The SourceSystem of the primary contact. To specify the contact for a household, you can either provide contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • The SourceSystemReference of the primary contact. To specify the contact for an household, you can either provide contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • Title: Province
    Maximum Length: 60
    The province element of address.
  • Title: Raw Phone Number
    Maximum Length: 60
    The raw phone number.
  • Relationships
    Title: Relationships
    The relationships resource is used to view, create, and update household relationships. A household relationship is the interconnection between parties, such as employee or board member.
  • Title: Sales Account Number
    Maximum Length: 30
    The alternate unique identifier of the record.
  • Title: Status
    Maximum Length: 30
    A valid user-defined status of the sales account.
  • Sales Account Resources
    Title: Sales Account Resources
    Sales account resources is used to view, create, update, and delete a resource party that is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
  • Title: Source System
    The name of external source system, which is defined by an admin as part of system setup. It is part of alternate key (along with SourceSystemReference), and is mandatory if PK or partyNumberBusinessKey is not passed in update.
  • Source System References
    Title: Source System References
    The source system reference resource is used to view, create, update, and delete source systems. A source system is an external system from which you import data.
  • Title: Source System Reference
    The unique identifier for the household party from the external source system specified in the attribute SourceSystem. It is part of alternate key (along with SourceSystemReference), and is mandatory if PK or partyNumberBusinessKey is not passed in update.
  • Title: State
    Maximum Length: 60
    The state element of address.
  • Title: Type
    Maximum Length: 30
    The household party type that defines whether the household is a sales account or a prospect or any other user-defined party type as specified using the lookup type ZCA_ HOUSEHOLD _TYPE. It is defaulted to ZCA_CUSTOMER if no value is provided. Possible values are ZCA_CUSTOMER or ZCA_PROSPECT. A list of valid values is defined in the lookup ZCA_HOUSEHOLD_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Name Suffix
    Maximum Length: 540
    The system-generated or manually overridden suffix, that is concatenated to the householdName attribute to generate the PartyUniqueName. The primary address is defaulted as the suffix.
  • Title: Total Wealth
    The household wealth amount or net worth. If not provided, then the value is NULL.
Nested Schema : Additional Identifiers
Type: array
Title: Additional Identifiers
The additional identifiers resource is used to view, create, update, and delete an additional identifiers such as driver's license number or passport number.
Show Source
Nested Schema : Additional Names
Type: array
Title: Additional Names
The additional name resource is used to view, create, update, and delete additional names associated with an account. You can use the resource to capture other names associated with an account, such as a maiden name, or a brand name.
Show Source
Nested Schema : Addresses
Type: array
Title: Addresses
The addresses resource is used to view, create, update, and delete addresses of a household. An address contains the detailed location information of a household.
Show Source
Nested Schema : Attachments
Type: array
Title: Attachments
The attachments resource is used to view, create, update, and delete attachments of a household. An attachment includes additional information about a household.
Show Source
Nested Schema : Contact Points
Type: array
Title: Contact Points
The contact point resource is used to view, create, update, and delete contact points for an account. Contact points can be geographical addresses, phone numbers, e-mail IDs, URLs, messenger IDs, and so on.
Show Source
Nested Schema : Aux Classifications
Type: array
Title: Aux Classifications
The aux classifications resource is used to view, create, update, and delete the auxiliary classifications of the customers associated with the households. Auxiliary classification enable you to categorize customers into different groups, such as commercial or private.
Show Source
Nested Schema : Notes
Type: array
Title: Notes
The note resource is used to view, create, update, and delete notes associated with a household. A note captures comments, information, or instructions related to a household.
Show Source
Nested Schema : Primary Addresses
Type: array
Title: Primary Addresses
The primary addresses resource is used to view, create, update, and delete the primary addresses of the households. A primary address is the default communication address of a household.
Show Source
Nested Schema : Relationships
Type: array
Title: Relationships
The relationships resource is used to view, create, and update household relationships. A household relationship is the interconnection between parties, such as employee or board member.
Show Source
Nested Schema : Sales Account Resources
Type: array
Title: Sales Account Resources
Sales account resources is used to view, create, update, and delete a resource party that is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
Show Source
Nested Schema : Source System References
Type: array
Title: Source System References
The source system reference resource is used to view, create, update, and delete source systems. A source system is an external system from which you import data.
Show Source
Nested Schema : schema
Type: object
Show Source
  • Title: Issuing Country
    Maximum Length: 2
    The country code of the additional identifier. Review the list of country codes using the Manage Geographies task.
  • Default Value: HZ_WS
    The application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Description
    Maximum Length: 240
    The description of the additional identifier.
  • Title: Expiration Date
    The date when the additional identifier will expire.
  • Title: Issue Date
    The date when the additional identifier was issued.
  • Title: Issuing Authority Name
    Maximum Length: 500
    The name of the issuing authority of the additional identifier.
  • The unique identifier of the issuing authority party.
  • The unique identifier of the party.
  • Title: Identifier Type
    Maximum Length: 30
    The type of the party identifier.
  • Title: Identifier Value
    Maximum Length: 60
    The value of the party identifier.
  • The party number of the additional identifier. Inactive records can't be updated.
  • The name of external source system of the account, contact or household with which the address is associated. Part of alternate key for the account, contact or household record (along with PartyourceSystemReferenceValue). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
  • The identifier for the record from an external source system.
  • The name of external source system, which is defined by an admin as part of system setup. It is part of alternate key (along with SourceSystemReference), and is mandatory if PK or partyNumberBusinessKey is not passed in update.
  • The unique identifier of the relationship from external source system.
  • Title: Issuing State
    Maximum Length: 60
    Used for certain types of identifiers such as Passports or Driving licenses based on geography setup.
  • Maximum Length: 1
    Default Value: A
    The status code of the additional identifier.
Nested Schema : households-AdditionalName-item-patch-request
Type: object
Show Source
  • Title: Academic Title
    Maximum Length: 30
    The part of the person's title that denotes the academic qualification, such as Dr. Jane Smith.
  • Default Value: 0
    The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases.
  • Title: Description
    Maximum Length: 240
    The description of the Additional Name record
  • Title: First Name
    Maximum Length: 150
    The first name of a person.
  • Title: Last Name
    Maximum Length: 150
    The last name of a person.
  • Title: Middle Name
    Maximum Length: 60
    The middle name of a person.
  • Title: Additional Name
    Maximum Length: 360
    The name of the record.
  • The source system name.
  • The identifier for the record from the original system.
  • Title: Preferred Indicator
    Maximum Length: 1
    Default Value: false
    Identify the name as preferred name for this party within this name type. Possible values are 'Y' and 'N'. Default is 'N'.
  • The name of the source system for the associated party.
  • The identifier of the source system reference for the associated party.
  • Maximum Length: 1
    Default Value: true
    The record status used to soft delete the record. The accepted values are A for active and I for inactive. The default value is A.
  • Title: Title
    Maximum Length: 60
    A professional or family title, such as Don or The Right Honorable
  • Title: Transliteration Language
    Maximum Length: 4
    TransliterationLanguage helps people pronounce words and names in foreign languages. It is validated against FND_LANGUAGES.LANGUAGE_CODE. Sample values: US,NL,DK etc.
Nested Schema : households-Address-item-patch-request
Type: object
Show Source
  • Title: Additional Address Element 1
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 2
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 3
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 4
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 5
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Address Line 1
    Maximum Length: 240
    The first line for address.
  • Title: Address Line 2
    Maximum Length: 240
    The second line for address.
  • Title: Address Line 3
    Maximum Length: 240
    The third line for address.
  • Title: Address Line 4
    Maximum Length: 240
    The fourth line for address.
  • Title: Address Lines Phonetic
    Maximum Length: 560
    Phonetic or Kana representation of the Kanji address lines (used in Japan).
  • Address Locales
    Title: Address Locales
    The address locales resource is used to view, create, update, and delete the local address. An address locale contains the details about a location or address in the local language.
  • Address Purposes
    Title: Address Purposes
    The address purposes resource is used to view, create, update, and delete the address purpose. The address purpose describes the type of an address, such as a shipping address or a billing address.
  • Title: Type
    The address type as a string.
  • Title: Building
    Maximum Length: 240
    Specific building name or number at a given address.
  • The indicator to process formatted address of the party record.
  • Title: City
    Maximum Length: 60
    The city element of address.
  • Title: CLLI Code
    Maximum Length: 60
    The Common Language Location Identifier (CLLI) code of the address. The code is used within the North American to specify the location of the address.
  • Title: Comments
    Maximum Length: 2000
    The user-provided comments for the address.
  • Default Value: 0
    The unique identifier of the conflict for the address record. This number is used by mobile or portable applications that consume the web service.
  • Title: Corporate Currency
    Maximum Length: 15
    The corporate currency code associated with the address. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Country
    Maximum Length: 2
    The country code of the address. Review the list of country codes using the Manage Geographies task.
  • Title: County
    Maximum Length: 60
    The county element of address.
  • Default Value: HZ_WS
    The application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Created by Application
    Maximum Length: 30
    The module that created the record.
  • Title: Currency Conversion Rate Type
    Maximum Length: 30
    The currency conversion rate type associated with the address. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency Code
    Maximum Length: 15
    The currency code related to the address. A list of valid values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Validated Date
    The date when the address was last validated.
  • Title: Description
    Maximum Length: 2000
    An extensive description of the location.
  • Title: Contact Preferences
    Default Value: false
    Indicates whether the address should not be used for mailing. If the value is Y, then the address should not be used to mail to the contact. The default value is N. If this attribute is not explicitly mentioned in the payload while creating an address, then the value of this attribute is set to null.
  • Title: Don't Validate
    Maximum Length: 1
    Indicates that a particular location is not eligible for address validation regardless of the current Validation Status Code.
  • Title: D-U-N-S Number
    Maximum Length: 30
    The D-U-N-S number of the business location.
  • The date when the address becomes active.
  • Title: End Date
    The date after which this address is rendered inactive.
  • Title: Floor
    Maximum Length: 40
    The specific floor number at a given address or in a particular building when building number is provided.
  • Title: House Type
    Maximum Length: 30
    The type of the building in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Latitude
    The latitude information for the address. This is used for spatial proximity and containment purposes.
  • Title: Location Directions
    Maximum Length: 640
    The directions to the location.
  • Title: Location ID
    The unique identifier for this location.
  • Title: Longitude
    The longitude information for the address. This is used for spatial proximity and containment purposes.
  • Title: Mail Stop
    Maximum Length: 60
    A user-defined code to indicate a mail drop point within their organization.
  • The number used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • The number used to implement optimistic locking for address record. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Title: Party ID
    The unique identifier of the account, contact or household to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the account, contact or household record with which the address is associated.
  • Title: Party Number
    The unique identifier for the party (account, contact, or household), to which the address is associated. One of PartyId, PartyNumber, or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact, or household record with which the address is associated. The profile option HZ_GENERATE_PARTY_NUMBER controls whether the attribute value can be system-generated or user-provided during create. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task. Inactive records can't be updated.
  • Title: Site Name
    Maximum Length: 240
    User-defined name for the address.
  • Title: Party Source System
    The name of external source system of the account, contact or household with which the address is associated. Part of alternate key for the account, contact or household record (along with PartyourceSystemReferenceValue). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
  • Title: Party Source System Reference Value
    The unique identifier from external source system for the account, contact or household with which the address is associated. Part of alternate key (along with PartySourceSystem). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated.
  • Title: Postal Code
    Maximum Length: 60
    The postal code as defined by the formal countrywide postal system.
  • Title: Postal Code Extension
    Maximum Length: 20
    The four-digit extension to the United States Postal ZIP code.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates whether this is the primary address of the associated object. If the value is True, then this is the primary address. The default value is False. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: Province
    Maximum Length: 60
    The province element of address.
  • The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Title: State
    Maximum Length: 60
    The state element of address.
  • Title: Status
    Maximum Length: 1
    Default Value: A
    An internal application-determined flag indicating status of the address. Status codes are defined by the lookup HZ_STATUS.
  • Title: Validated
    Maximum Length: 1
    Default Value: false
    Indicates if the location was validated. If the value is True, then the location is validated. The default value is false. The value is internally set by system during address cleansing.
  • Title: Validation Status
    Maximum Length: 30
    The code indicating the status of the validation. Internally set by system during address cleansing.
Nested Schema : Address Locales
Type: array
Title: Address Locales
The address locales resource is used to view, create, update, and delete the local address. An address locale contains the details about a location or address in the local language.
Show Source
Nested Schema : Address Purposes
Type: array
Title: Address Purposes
The address purposes resource is used to view, create, update, and delete the address purpose. The address purpose describes the type of an address, such as a shipping address or a billing address.
Show Source
Nested Schema : schema
Type: object
Show Source
  • Title: Address Element Attribute 1
    Maximum Length: 150
    The additional address element 1 to support flexible address format in local language.
  • Title: Address Element Attribute 2
    Maximum Length: 150
    The additional address element 2 to support flexible address format in local language.
  • Title: Address Element Attribute 3
    Maximum Length: 150
    The additional address element 3 to support flexible address format in local language.
  • Title: Address Element Attribute 4
    Maximum Length: 150
    The additional address element 4 to support flexible address format in local language.
  • Title: Address Element Attribute 5
    Maximum Length: 150
    The additional address element 5 to support flexible address format in local language.
  • Title: Address Line 1
    Maximum Length: 240
    The first line of the address in the local language.
  • Title: Address Line 2
    Maximum Length: 240
    The second line of the address in the local language.
  • Title: Address Line 3
    Maximum Length: 240
    The third line of the address in the local language.
  • Title: Address Line 4
    Maximum Length: 240
    The fourth line of the address in the local language.
  • Title: Building
    Maximum Length: 240
    The specific building name or number at a given address in local language.
  • Title: City
    Maximum Length: 60
    The specific name of the city in local language.
  • Title: County
    Maximum Length: 60
    The specific name of the county in local language.
  • Title: Floor
    Maximum Length: 240
    The specific floor number at a given address or a particular building when building number is provided in local language.
  • Title: Postal Code
    Maximum Length: 60
    The postal code of the locale. A postal code, known in various countries as a post code, postcode, or ZIP code, is a series of letters or digits appended to a postal address for the purpose of sorting mail in local language.
  • Title: Postal Code Extension
    Maximum Length: 20
    The four digit extension to the United States Postal ZIP code in local language.
  • Title: Province
    Maximum Length: 60
    The name of the province in local language.
  • The name of external source system for the parent address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the parent address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Title: State
    Maximum Length: 60
    The name of the State in the local language.
  • Title: Transliteration Language
    Maximum Length: 4
    Transliteration Language helps people pronounce words and names in foreign languages. It's validated against FND_LANGUAGES.LANGUAGE_CODE. Sample values are US,NL, DK.
Nested Schema : households-Address-AddressPurpose-item-patch-request
Type: object
Show Source
  • Title: Comments
    Maximum Length: 2000
    The user comments for the address purpose.
  • Maximum Length: 30
    Default Value: HZ_WS
    The application module that created this address purpose record. The default value for CreatedByModule is HZ_WS for all Web service based creation. A list of accepted values is defined in the lookup type HZ_CREATED_BY_MODULES. You can review and update the value for this attribute using the Setup and Maintenance task work area, Manage Trading Community Common Lookups task.
  • Indicates whether the address purpose is to be deleted. If the value is True, then the address purpose will be deleted. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: To Date
    The date on which the address purpose is no longer valid.
  • Title: Primary
    Maximum Length: 1
    Default Value: N
    Indicates if this is the primary use for the site. Y stands for the primary site and N stands for all other sites.
  • The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • 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. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address purpose.
  • The unique identifier for the address purpose from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Title: Status
    Maximum Length: 1
    Default Value: A
    Indicates whether the address purpose is still valid for the associated address record. The value A indicates active and I indicates inactive.
Nested Schema : schema
Type: object
Show Source
Nested Schema : schema
Type: object
Show Source
  • Title: Conflict ID
    Default Value: 0
    The unique identifier of the conflict for the contact point record. This number is used by mobile or portable applications that consume the web service.
  • Title: Created by Application
    Default Value: HZ_WS
    The application module that created this contact point record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: OK to Contact
    Indicates whether to use a particular contact method. Defaulted to false.
  • Title: Do Not Contact
    Indicates whether the record can be contacted.
  • Title: Do Not Contact Reason
    The reason code for the contact preference.
  • Title: Email
    Maximum Length: 255
    The email address of the contact point record of type email.
  • Title: Email Purpose
    Maximum Length: 30
    The purpose of using the EMAIL contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE. The values can be ASSISTANT, PERSONAL, HOME_BUSINESS, BUSINESS, and so on.
  • Title: Object Version Number
    The number used to implement optimistic locking for contact point record. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Title: Party ID
    The unique identifier of the associated party record for contact point.
  • Title: Registry ID
    The public unique identifier of the associated party record.
  • Title: Party Source System
    The name of external source system of the account, contact or household with which the contact point is associated. Part of alternate key for the account, contact or household record along with PartyourceSystemReferenceValue. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
  • Title: Party Source System Reference Value
    The unique identifier from external source system for the account, contact or household with which the address is associated. Part of alternate key along with PartySourceSystem. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated.
  • Title: Area Code
    Maximum Length: 255
    The area code for the phone number.
  • Title: Phone Country Code
    Maximum Length: 255
    The country code of the phone number.
  • Title: Extension
    Maximum Length: 255
    The extension number of the phone line number like office desk extension.
  • Title: Phone
    Maximum Length: 255
    The phone number of the contact point.
  • Title: Phone Purpose
    Maximum Length: 30
    Defines the purpose of using the PHONE contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
  • Title: Type
    The type of phone contact point. The accepted values are defined in the lookup type ORA_HZ_PHONE_TYPE. The values can be WORK, HOME, FAX, and so on.
  • Title: Preference Requested By
    Indicates if the permission or restriction was created internally or requested by the party. The list of accepted values are defined in the REQUESTED_BY lookup.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates whether this is the primary contact point of the associated object. If the value is True, then this is the primary contact point. The default value is False. If this attribute isn't explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: Phone
    Maximum Length: 255
    The raw phone number on the contact point record of type phone.
  • Title: User ID
    The unique identifier of the social network.
  • Title: Social Network
    The name of the social network.
  • Title: Social Network Purpose
    Maximum Length: 30
    Defines the purpose of using the IM contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
  • Title: Source System
    The name of external source system, which is defined by an administrator as part of system setup. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
  • Title: Source System Reference Value
    The unique identifier for the contacts party from the external source system specified in the attribute SourceSystem. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
  • Title: Status
    Maximum Length: 30
    Default Value: A
    Indicates the status of the contact point. The status codes are defined in the lookup HZ_STATUS. The default value is A.
  • Title: URL
    The URL of the contact point.
  • Title: Verification Date
    The date of verification of the phone or email contact point.
  • Title: Verification Status
    Maximum Length: 30
    The status of the verification for phone or email contact points. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID, ORA_INVALID and ORA_PARTIALLY_VALID. The value ORA_PARTIALLY_VALID is applicable only for email. Default value is blank which indicates that values aren't verified.
  • Title: Web Purpose
    Maximum Length: 30
    Defines the purpose of using the WEB contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE_WEB.Sample values: HOMEPAGE,SALESURL,MARKETINGURL,SUPPORTURL,RSS_FEED etc.
Nested Schema : schema
Type: object
Show Source
  • Title: End Date
    The date from which the classification code is no longer valid.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates if the customer classification is the primary classification. The default value is false.
  • Title: Source System
    The name of external source system where the customer classification is imported from. The values are configured in Setup and Maintenance work area, Manage Trading Community Source Systems task.
  • Title: Source System Reference Value
    The unique identifier for the customer classification in the external source.
  • Title: Status
    Maximum Length: 1
    Default Value: A
    Indicates if the code assignment is active or inactive. The code assignment is active if the value is A, and inactive if the value is I.
Nested Schema : schema
Type: object
Show Source
  • Title: Contact Relationship ID
    The unique identifier of the relationship that is populated when the note is associated with a contact.
  • Title: Corporate Currency Code
    Maximum Length: 15
    The corporate currency code associated with the note. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Creator Party ID
    The unique identifier of the person who created the note.
  • Title: Currency Conversion Rate Type
    Maximum Length: 30
    The currency conversion rate type associated with the note. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency
    Maximum Length: 15
    The currency code attribute associated with the note. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Title
    Maximum Length: 500
    The title of the note entered by the user.
  • Title: Note
    The column which will store the actual note text.
  • Title: Type
    Maximum Length: 30
    The code used to classify a note, as asset or adjustment.
  • Title: Related Object
    Maximum Length: 64
    The unique identifier of the source object as defined in OBJECTS Metadata, such as activities, opportunities, etc.
  • Title: Private
    Maximum Length: 30
    Default Value: INTERNAL
    Specifies the visibility level of the note.
Nested Schema : households-PrimaryAddress-item-patch-request
Type: object
Show Source
  • Title: Addressee
    Maximum Length: 360
    The addressee of the household.
  • Title: Additional Address Element 1
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 2
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 3
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 4
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 5
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Address Line 1
    Maximum Length: 240
    The first line for address.
  • Title: Address Line 2
    Maximum Length: 240
    The second line for address.
  • Title: Address Line 3
    Maximum Length: 240
    The third line for address.
  • Title: Address Line 4
    Maximum Length: 240
    The fourth line for address.
  • Title: Address Lines Phonetic
    Maximum Length: 560
    Phonetic or Kana representation of the Kanji address lines (used in Japan).
  • Title: Site Number
    Maximum Length: 30
    The alternate key identifier of the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix is defined as in profile option ZCA_PUID_PREFIX, concatenated with an internally generated unique sequence number.
  • Title: Building
    Maximum Length: 240
    The specific building name or number at a given address.
  • Title: City
    Maximum Length: 60
    The city element of the primary address.
  • Title: Comments
    Maximum Length: 2000
    The user-provided comments for the primary address.
  • Default Value: 0
    The unique identifier of the conflict for the primary address record. This number is used by mobile or portable applications that consume the web service.
  • Maximum Length: 15
    The corporate currency code. A list of valid values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Country
    Maximum Length: 2
    The country code of the primary address. Review the list of country codes using the Manage Geographies task.
  • Title: County
    Maximum Length: 60
    The county element of the primary address.
  • Maximum Length: 30
    The currency conversion rate type associated with the address. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency
    Maximum Length: 15
    The currency code associated with the primary address. The default value is the value specified in the profile option ZCA_COMMON_CORPORATE_CURRENCY.
  • Title: Validated Date
    The date when the address was last validated.
  • Title: Delete Primary Address
    Indicates whether the primary address is to be deleted. If the value is True, then the primary address will be deleted. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: Description
    Maximum Length: 2000
    An extensive description of the location.
  • Title: Don't Validate
    Maximum Length: 1
    Indicator to specify that a particular location isn't eligible for address validation irrespective of the current validation.
  • Title: To Date
    The last date for a primary address record in active status.
  • Title: Floor
    Maximum Length: 40
    The specific floor number at a given address or in a particular building when building number is provided.
  • Title: House Type
    Maximum Length: 30
    The type of the building mentioned in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Latitude
    The latitude information for the address. This is used for spatial proximity and containment purposes.
  • Title: Comments
    Maximum Length: 2000
    The additional information for the record in free text format.
  • Title: Location Directions
    Maximum Length: 640
    The directions to the location.
  • The unique identifier for the location record for this address.
  • The integration key for the location record.
  • Title: Location ID
    The system identifier for the location record of the primary address.
  • The name of source system for the location record.
  • The unique identifier of the relationship from external source system.
  • Maximum Length: 1
    Default Value: true
    The location record of primary address.
  • Title: Longitude
    The longitude information for the address. This is used for spatial proximity and containment purposes.
  • Title: Mail Stop
    Maximum Length: 60
    The user-defined code that indicates a mail drop point within the organization.
  • The internal version number for the location for the primary address. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the party site for primary address. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates whether this is the primary address of the associated object. If the value is Y, then the address is a primary address.
  • Title: Site Name
    Maximum Length: 240
    The name of the party site for the primary address.
  • Title: One-Time Address
    Maximum Length: 30
    The type of the party site. You can't use this attribute as a finder, because this is a transient field. The response will return an error if you use this attribute as a finder.
  • Title: Postal Code
    Maximum Length: 60
    The postal code element of the address.
  • Title: Postal Code Extension
    Maximum Length: 20
    The four-digit extension to the United States Postal ZIP code.
  • Title: Province
    Maximum Length: 60
    The province element of the address.
  • Title: Short Description
    Maximum Length: 240
    The short description of the primary address.
  • The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Title: State
    Maximum Length: 60
    The state element of the address.
  • Maximum Length: 1
    Default Value: A
    Indicates the status of the primary address. Status codes are defined by the lookup HZ_STATUS.
  • Title: Time Zone
    Maximum Length: 64
    The code of the time zone associated with the primary address.
  • Title: Validated
    Maximum Length: 1
    Default Value: false
    Indicates whether the location was validated. Y for validated, N for invalidated. The value is internally set by system during address cleansing. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to NULL.
  • Title: Validation Status
    Maximum Length: 30
    The code indicating the status of the validation. Internally set by system during address cleansing.
Nested Schema : schema
Type: object
Show Source
  • Title: Comments
    Maximum Length: 2000
    The comments provided by the user.
  • Default Value: 0
    The unique identifier of the conflict for the relationship record. This number is used by mobile or portable applications that consume the web service.
  • Title: Dependent Indicator
    Maximum Length: 1
    Default Value: N
    Indicates whether one party is dependent on another. Default value is N.
  • Title: To Date
    The date when the relationship ends.
  • Title: Head of Household Indicator
    Maximum Length: 1
    Default Value: N
    Indicates whether a person is the head of the household that he belongs to. It's applicable only in the MEMBERSHIP relationship, and will be used to indicate which members are the head of household. There may be multiple heads of households, depending on the deploying company's implementation.
  • Title: Influence Level
    The sales contact's influence in a buying relationship. Sample values are Inner Circle, Political structure, None.
  • Maximum Length: 100
    The definition of the job name.
  • Maximum Length: 900
    The definition of the job package.
  • The unique identifier of the object in this relationship.
  • Title: Object Registry ID
    Maximum Length: 30
    The alternate key identifier of the object party of the relationship.
  • Title: Object Source System
    The name of external source system for the object party in the relationship, which are defined by an admin as part of system setup.
  • Title: Object Source System Reference
    The unique identifier for the object party in the relationship from external source system.
  • The number used to implement optimistic locking for relationship record. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Title: Ownership Percentage
    The percentage of the child entity owned by the parent entity.
  • Maximum Length: 10
    Default Value: false
    Indicates whether this contact person is primary contact for the customer. Accepted values are Y and N. Default value is N.
  • Maximum Length: 10
    Default Value: false
    Indicates whether this customer is primary customer for the contact. Accepted values are Y and N. Default value is N.
  • The name of the external source system for the relationship, which are defined by an admin as part of the system setup.
  • The unique identifier of the relationship from external source system.
  • The unique identifier of the request on relationship record.
  • The unique identifier of the subject in this relationship.
  • Title: Subject Registry ID
    Maximum Length: 30
    The alternate key identifier of the subject party of the relationship.
  • Title: Subject Source System
    The name of external source system for the subject party in the relationship, which are defined by an admin as part of system setup.
  • Title: Subject Source System Reference
    The unique identifier of the subject party in the relationship from external source system.
Nested Schema : households-SalesTeamMember-item-patch-request
Type: object
Show Source
  • Title: Access
    Maximum Length: 30
    The code indicating the level of access granted to the resource as well as managers of the organizations. The possible values are defined in the ZCA_ACCESS_LEVEL lookup. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Assignment Type
    Maximum Length: 30
    Default Value: MANUAL
    The code indicating how the resource is assigned to the sales account team. The possible values are contained in the ZCA_ASSIGNMENT_TYPE lookup.
  • Title: Corporate Currency Code
    Maximum Length: 15
    The corporate currency code associated with the sales team member. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Currency Conversion Rate Type
    Maximum Length: 30
    The currency conversion rate type associated with the address. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency Code
    Maximum Length: 15
    The currency code associated with the sales team member of the household object. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Archived Date
    The date when the resource is dissociated from the sales account.
  • Title: Locked
    Maximum Length: 1
    Default Value: false
    Indicates if the automatic territory assignment can be set. If the value is True, then the automatic territory assignment cannot remove the sales account team resource. When a sales account team member is added manually, this flag is defaulted to `Y'.
  • Title: Function
    Maximum Length: 30
    The code indicating the role of a sales team member in the resource team such as Integrator, Executive Sponsor, and Technical Account Manager. A list of accepted values is defined in the lookup FND_LOOKUPS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • The number used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Title: Owner
    Default Value: false
    Indicates whether the resource is the owner.
  • The unique identifier of the associated party record for sales team member record.
  • The public identifier of the associated party record.
  • The name of external source system of the associated party record.
  • The unique identifier from external source system of the associated party record.
  • Title: Resource Email
    The email address of the resource.
  • Title: Resource Party Number
    The alternate key identifier of the resource that this team member belongs to.
  • Title: Start Date
    The date on which the resource is associated with a sales account.
  • Title: Sales Account Resource ID
    The unique identifier of the member of the sales accounts resource team.
  • Title: User Last Update Date
    The date and time when the record was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database.
Nested Schema : schema
Type: object
Show Source
  • Default Value: 0
    The unique identifier of the conflict. This number is used by mobile or portable applications that consume the web service.
  • Default Value: HZ_WS
    The application module that created the record. It is defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • The date after which the record is inactive.
  • The number used to implement locking. This number is incremented every time that the row is updated. The number is comparedat the start and end of a transaction to determine whether another session has updated the row.
  • The unique identifier of the associated account.
  • Title: Party Number
    The alternate unique identifier of the associated account. Inactive records can't be updated.
  • Title: Party Source System
    The source system name for the account.
  • Title: Party Source System Reference Value
    The identifier for the record from an external source system.
  • Maximum Length: 255
    The source system reference value required to identify the associated account.
  • Maximum Length: 1
    Default Value: A
    Indicates of the mapping to the source system is active. If the value is A, then the mapping is active. If the value is I, then the mapping is inactive.
Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : households-item-response
Type: object
Show Source
  • Additional Identifiers
    Title: Additional Identifiers
    The additional identifiers resource is used to view, create, update, and delete an additional identifiers such as driver's license number or passport number.
  • Additional Names
    Title: Additional Names
    The additional name resource is used to view, create, update, and delete additional names associated with an account. You can use the resource to capture other names associated with an account, such as a maiden name, or a brand name.
  • Addresses
    Title: Addresses
    The addresses resource is used to view, create, update, and delete addresses of a household. An address contains the detailed location information of a household.
  • Title: Additional Address Element 1
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 2
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 3
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 4
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Additional Address Element 5
    Maximum Length: 150
    Additional address element to support flexible address format
  • Title: Address Line 1
    Maximum Length: 240
    First line of address.
  • Title: Address Line 2
    Maximum Length: 240
    Second line of address.
  • Title: Address Line 3
    Maximum Length: 240
    Third line of address.
  • Title: Address Line 4
    Maximum Length: 240
    Fourth line of address.
  • Title: Address Lines Phonetic
    Maximum Length: 560
    Phonetic or Kana representation of the Kanji address lines (used in Japan)
  • Title: Site Number
    Maximum Length: 30
    Alternate unique identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix defined as in profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.
  • Title: Type
    Additional information as type of address like BillTo, ShipTo.
  • Title: Annual Income
    The annual income of the household. If not provided, then the value is NULL.
  • Title: Assignment Exception Indicator
    Read Only: true
    Maximum Length: 1
    Default Value: false
    Indicates whether the sales account has the required dimensions to allow assignment manager to assign territories to the sales account. The default value is false.
  • Attachments
    Title: Attachments
    The attachments resource is used to view, create, update, and delete attachments of a household. An attachment includes additional information about a household.
  • Title: Average Age
    The average age of the household.
  • Title: Building
    Maximum Length: 240
    Specific building name or number at a given address.
  • Title: Certification Level
    Maximum Length: 30
    The certification level of a household. A list of valid certification level codes is defined using the lookup HZ_PARTY_CERT_LEVEL. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Certification Reason
    Maximum Length: 30
    The reason for the household current certification level assignment. A list of valid certification reason codes are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Children Below 7 Years of Age
    The number of children in the age range 0-6.
  • Title: Children Aged 13 to 18 Years
    The number of children in the age range 13-18.
  • Title: Children Aged 7 to 12 Years
    The number of children in the age range 7-12.
  • Title: City
    Maximum Length: 60
    The city element of address.
  • Title: Classification Category
    A valid classification category code for the household which will be marked as primary and is defined by an admin.
  • Title: Classification Code
    A valid classification code corresponding to the classification category and which will be marked as primary.
  • Title: Comments
    Maximum Length: 2000
    The description for a group.
  • Default Value: 0
    The unique identifier of the conflict for the household data record. This number is used by mobile or portable applications that consume the web service.
  • Contact Points
    Title: Contact Points
    The contact point resource is used to view, create, update, and delete contact points for an account. Contact points can be geographical addresses, phone numbers, e-mail IDs, URLs, messenger IDs, and so on.
  • Maximum Length: 15
    The corporate currency code associated with the household. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Country
    Maximum Length: 2
    Country code of the address.
  • Title: County
    Maximum Length: 60
    County element of address.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the record.
  • Title: Created by Application
    Default Value: HZ_WS
    The application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Maximum Length: 30
    The application module that created the household record.
  • Title: Creation Date
    Read Only: true
    The date and time when the record was created.
  • Maximum Length: 30
    The currency conversion rate type associated with the household. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency
    Maximum Length: 15
    The currency code associated with the household. The default value is the value specified in the profile option ZCA_COMMON_CORPORATE_CURRENCY.
  • Aux Classifications
    Title: Aux Classifications
    The aux classifications resource is used to view, create, update, and delete the auxiliary classifications of the customers associated with the households. Auxiliary classification enable you to categorize customers into different groups, such as commercial or private.
  • Read Only: true
    Indicates if the household can be deleted. The default value is false.
  • Title: Number of Dependents
    The number of dependents on the household.
  • Maximum Length: 1
    Default Value: Y
    Indicates whether the row has the latest change in the day. If the value is True, then this row has the latest change in the day.
  • The order of the different changes made during the day. The lowest value represents the earliest change in the day.
  • Title: Email
    Maximum Length: 320
    The e-mail address of the contact point.
  • Read Only: true
    The unique identifier of the email contact point.
  • Title: Type
    Read Only: true
    Maximum Length: 30
    Default Value: EMAIL
    The type of the email contact point.
  • Title: Email Format
    Maximum Length: 30
    The format for an e-mail preferred by the household, such as HTML or ASCII.
  • Title: Email Verification Date
    The date when email address was last verified.
  • Title: Email Verification Status
    Maximum Length: 30
    The status code of the email address verification. The values based on lookup are valid, invalid, or partially invalid for email.
  • Title: Existing Sales Account
    Read Only: true
    Maximum Length: 1
    Default Value: false
    Indicates whether there is an existing selling or billing relationship with the sales account. The default value is false.
  • Title: Existing Indicator Last Update Date
    Read Only: true
    The date when the existing customer flag was last modified.
  • Title: Favorite
    Maximum Length: 10
    Default Value: false
    Indicates if the household is a favorite household. The default value is false.
  • Title: Floor
    Maximum Length: 40
    The specific floor number at a given address or in a particular building when the building number is provided.
  • Title: Address
    Read Only: true
    The formatted version of the primary address.
  • Title: Phone Number
    Read Only: true
    The formatted phone number information.
  • The unique identifier of the group party.
  • Title: Type
    Read Only: true
    Maximum Length: 30
    Default Value: HOUSEHOLD
    The type of the group.
  • Title: Name
    Maximum Length: 360
    The unique identification number for this party. Data stored in this attribute comes from PARTY_NUMBER in HZ_PARTIES.
  • The unique identifier of the household profile.
  • Title: Size
    The size of the group.
  • Title: Last Assigned Date
    Read Only: true
    The date when the sales account territory assignment was last run by the assignment manager.
  • Read Only: true
    The timestamp when the sales account territory assignment was last run by the assignment manager.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login details of the user who last updated the record.
  • Links
  • Title: Mail Stop
    Maximum Length: 60
    A user-defined code to indicate a mail drop point within their organization
  • Title: Median Age
    The median age.
  • Title: Named Household
    Maximum Length: 1
    Default Value: false
    Indicates whether a sales account is a named sales account. Possible values are True or False. If the value is True, then the sales account is a named sales account. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Notes
    Title: Notes
    The note resource is used to view, create, update, and delete notes associated with a household. A note captures comments, information, or instructions related to a household.
  • The internal version number for the email. It is the number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the group. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • Read Only: true
    The internal version number for the owner. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the party. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the phone. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the sales account. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • Read Only: true
    Maximum Length: 320
    The email address of sales account owner. To assign an owner to the sales account, you can either provide owner's party ID, party number, or email address.
  • Read Only: true
    Maximum Length: 360
    The name of the sales account owner.
  • Title: Owner ID
    The unique identifier of sales account owner. To assign an owner to the sales account, you must provide either owner's party identifier, party number, or email address.
  • Read Only: true
    The unique identifier of the owner party.
  • Read Only: true
    Maximum Length: 30
    The party number of a valid employee resource who owns and manages the sales account. To assign an owner to the sales account, you can either provide owner's party ID, party number, or email address.
  • Title: Party ID
    Read Only: true
    The unique identifier of the party.
  • Title: Registry ID
    Maximum Length: 30
    The unique primary identifier for the household party. The profile option HZ_GENERATE_PARTY_NUMBER controls whether the attribute value can be system generated or user-provided during create. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task. Inactive records can't be updated.
  • Title: Registry ID
    Maximum Length: 30
    The alternate unique identifier of the household party record.
  • Read Only: true
    Maximum Length: 1
    Default Value: A
    The status of the household.
  • Title: Party Type
    Read Only: true
    Maximum Length: 30
    Default Value: GROUP
    The type of the party.
  • Title: Name
    Read Only: true
    Maximum Length: 900
    This is the derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, this is concatenation of person_name and suffix.
  • Title: Area Code
    Maximum Length: 20
    The area code for the telephone number.
  • Read Only: true
    The unique identifier of the phone contact point.
  • Title: Type
    Read Only: true
    Maximum Length: 30
    Default Value: PHONE
    The type of the phone contact point.
  • Title: Phone Country Code
    Maximum Length: 10
    The international country code for a telephone number, such as 33 for France.
  • Title: Extension
    Maximum Length: 20
    The additional number addressed after initial connection to an internal telephone system.
  • Title: Phone
    Maximum Length: 40
    A telephone number formatted in the local format. The number should not include area code, country code, or extension.
  • Title: Phone Verification Date
    The date when phone number was last verified.
  • Title: Phone Verification Status
    Maximum Length: 30
    The status code of the phone number verification. The values based on lookup are valid and invalid for phone.
  • Title: Postal Code
    Maximum Length: 60
    The postal code as defined by the formal countrywide postal system.
  • Title: Postal Code Extension
    Maximum Length: 20
    Four digit extension to the United States Postal ZIP code.
  • Title: Preferred Contact Method
    Maximum Length: 30
    Indicates how a household prefers to be contacted. Validated against lookup type PREFERRED_CONTACT_METHOD. A list of valid codes is defined in the lookup HZ_PREFERENCE. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Preferred Functional Currency
    Maximum Length: 15
    The code indicating the preferred currency for the group.
  • Primary Addresses
    Title: Primary Addresses
    The primary addresses resource is used to view, create, update, and delete the primary addresses of the households. A primary address is the default communication address of a household.
  • Read Only: true
    The unique identifier of the primary address.
  • Title: Contact Email
    Read Only: true
    The e-mail address of the primary contact.
  • Read Only: true
    Maximum Length: 255
    The name of the primary contact.
  • The unique identifier of the primary contact. To specify the contact for an household, you can provide either contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • The alternate key identifier of the of the primary contact. To specify the contact for a household, you can either provide contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • Title: Contact Phone
    Read Only: true
    The phone number of the primary contact.
  • The SourceSystem of the primary contact. To specify the contact for a household, you can either provide contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • The SourceSystemReference of the primary contact. To specify the contact for an household, you can either provide contact's party ID, PartyNumber, or (SourceSystem, SourceSystemReference) .
  • Title: Province
    Maximum Length: 60
    The province element of address.
  • Title: Raw Phone Number
    Maximum Length: 60
    The raw phone number.
  • Title: Record Set
    Read Only: true
    Maximum Length: 30
    Displays the search results under the selected record set.
  • Relationships
    Title: Relationships
    The relationships resource is used to view, create, and update household relationships. A household relationship is the interconnection between parties, such as employee or board member.
  • The unique identifier of the sales profile on the household record.
  • Title: Sales Account Number
    Maximum Length: 30
    The alternate unique identifier of the record.
  • Title: Status
    Maximum Length: 30
    A valid user-defined status of the sales account.
  • Sales Account Resources
    Title: Sales Account Resources
    Sales account resources is used to view, create, update, and delete a resource party that is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
  • Title: Sell to Address
    Read Only: true
    The unique identifier of the sell to party site on the household record.
  • Read Only: true
    Maximum Length: 255
    Default Value: SALES_PARTY
    The type of the source object.
  • Title: Source System
    The name of external source system, which is defined by an admin as part of system setup. It is part of alternate key (along with SourceSystemReference), and is mandatory if PK or partyNumberBusinessKey is not passed in update.
  • Source System References
    Title: Source System References
    The source system reference resource is used to view, create, update, and delete source systems. A source system is an external system from which you import data.
  • Title: Source System Reference
    The unique identifier for the household party from the external source system specified in the attribute SourceSystem. It is part of alternate key (along with SourceSystemReference), and is mandatory if PK or partyNumberBusinessKey is not passed in update.
  • Read Only: true
    Maximum Length: 30
    Default Value: HZ_PARTIES
    The name of the table that holds the record data and is referenced to manage source system reference.
  • Title: State
    Maximum Length: 60
    The state element of address.
  • Read Only: true
    Maximum Length: 255
    The unique identifier of the string on the household record..
  • Title: Type
    Maximum Length: 30
    The household party type that defines whether the household is a sales account or a prospect or any other user-defined party type as specified using the lookup type ZCA_ HOUSEHOLD _TYPE. It is defaulted to ZCA_CUSTOMER if no value is provided. Possible values are ZCA_CUSTOMER or ZCA_PROSPECT. A list of valid values is defined in the lookup ZCA_HOUSEHOLD_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Name Suffix
    Maximum Length: 540
    The system-generated or manually overridden suffix, that is concatenated to the householdName attribute to generate the PartyUniqueName. The primary address is defaulted as the suffix.
  • Read Only: true
    Indicates if the record can be updated. The default value is false.
  • Title: Total Wealth
    The household wealth amount or net worth. If not provided, then the value is NULL.
Nested Schema : Additional Identifiers
Type: array
Title: Additional Identifiers
The additional identifiers resource is used to view, create, update, and delete an additional identifiers such as driver's license number or passport number.
Show Source
Nested Schema : Additional Names
Type: array
Title: Additional Names
The additional name resource is used to view, create, update, and delete additional names associated with an account. You can use the resource to capture other names associated with an account, such as a maiden name, or a brand name.
Show Source
Nested Schema : Addresses
Type: array
Title: Addresses
The addresses resource is used to view, create, update, and delete addresses of a household. An address contains the detailed location information of a household.
Show Source
Nested Schema : Attachments
Type: array
Title: Attachments
The attachments resource is used to view, create, update, and delete attachments of a household. An attachment includes additional information about a household.
Show Source
Nested Schema : Contact Points
Type: array
Title: Contact Points
The contact point resource is used to view, create, update, and delete contact points for an account. Contact points can be geographical addresses, phone numbers, e-mail IDs, URLs, messenger IDs, and so on.
Show Source
Nested Schema : Aux Classifications
Type: array
Title: Aux Classifications
The aux classifications resource is used to view, create, update, and delete the auxiliary classifications of the customers associated with the households. Auxiliary classification enable you to categorize customers into different groups, such as commercial or private.
Show Source
Nested Schema : Notes
Type: array
Title: Notes
The note resource is used to view, create, update, and delete notes associated with a household. A note captures comments, information, or instructions related to a household.
Show Source
Nested Schema : Primary Addresses
Type: array
Title: Primary Addresses
The primary addresses resource is used to view, create, update, and delete the primary addresses of the households. A primary address is the default communication address of a household.
Show Source
Nested Schema : Relationships
Type: array
Title: Relationships
The relationships resource is used to view, create, and update household relationships. A household relationship is the interconnection between parties, such as employee or board member.
Show Source
Nested Schema : Sales Account Resources
Type: array
Title: Sales Account Resources
Sales account resources is used to view, create, update, and delete a resource party that is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
Show Source
Nested Schema : Source System References
Type: array
Title: Source System References
The source system reference resource is used to view, create, update, and delete source systems. A source system is an external system from which you import data.
Show Source
Nested Schema : households-AdditionalIdentifier-item-response
Type: object
Show Source
  • Title: Issuing Country
    Maximum Length: 2
    The country code of the additional identifier. Review the list of country codes using the Manage Geographies task.
  • Read Only: true
    Maximum Length: 64
    The user who created the additional identifier.
  • Default Value: HZ_WS
    The application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Read Only: true
    The date when the additional identifier was created.
  • Title: Description
    Maximum Length: 240
    The description of the additional identifier.
  • Title: Expiration Date
    The date when the additional identifier will expire.
  • Title: Issue Date
    The date when the additional identifier was issued.
  • Title: Issuing Authority Name
    Maximum Length: 500
    The name of the issuing authority of the additional identifier.
  • The unique identifier of the issuing authority party.
  • Read Only: true
    The date when the additional identifier was last updated.
  • Read Only: true
    Maximum Length: 64
    The user who last updated the additional identifier.
  • Read Only: true
    Maximum Length: 32
    The login of the user who last updated the additional identifier.
  • Links
  • Read Only: true
    The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The unique identifier of the party.
  • Read Only: true
    The unique identifier of the party.
  • Title: Identifier Type
    Maximum Length: 30
    The type of the party identifier.
  • Title: Identifier Value
    Maximum Length: 60
    The value of the party identifier.
  • The party number of the additional identifier. Inactive records can't be updated.
  • The name of external source system of the account, contact or household with which the address is associated. Part of alternate key for the account, contact or household record (along with PartyourceSystemReferenceValue). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
  • The identifier for the record from an external source system.
  • The name of external source system, which is defined by an admin as part of system setup. It is part of alternate key (along with SourceSystemReference), and is mandatory if PK or partyNumberBusinessKey is not passed in update.
  • The unique identifier of the relationship from external source system.
  • Title: Issuing State
    Maximum Length: 60
    Used for certain types of identifiers such as Passports or Driving licenses based on geography setup.
  • Maximum Length: 1
    Default Value: A
    The status code of the additional identifier.
Nested Schema : households-AdditionalName-item-response
Type: object
Show Source
Nested Schema : households-Address-item-response
Type: object
Show Source
  • Title: Additional Address Element 1
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 2
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 3
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 4
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Additional Address Element 5
    Maximum Length: 150
    The additional address element to support flexible address format.
  • Title: Address Line 1
    Maximum Length: 240
    The first line for address.
  • Title: Address Line 2
    Maximum Length: 240
    The second line for address.
  • Title: Address Line 3
    Maximum Length: 240
    The third line for address.
  • Title: Address Line 4
    Maximum Length: 240
    The fourth line for address.
  • Read Only: true
    Address internal unique identifier that is internally generated during create. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update.
  • Title: Address Lines Phonetic
    Maximum Length: 560
    Phonetic or Kana representation of the Kanji address lines (used in Japan).
  • Address Locales
    Title: Address Locales
    The address locales resource is used to view, create, update, and delete the local address. An address locale contains the details about a location or address in the local language.
  • Title: Site Number
    Maximum Length: 30
    The alternate unique identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix defined as in profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.
  • Address Purposes
    Title: Address Purposes
    The address purposes resource is used to view, create, update, and delete the address purpose. The address purpose describes the type of an address, such as a shipping address or a billing address.
  • Title: Type
    The address type as a string.
  • Title: Building
    Maximum Length: 240
    Specific building name or number at a given address.
  • The indicator to process formatted address of the party record.
  • Title: City
    Maximum Length: 60
    The city element of address.
  • Title: CLLI Code
    Maximum Length: 60
    The Common Language Location Identifier (CLLI) code of the address. The code is used within the North American to specify the location of the address.
  • Title: Comments
    Maximum Length: 2000
    The user-provided comments for the address.
  • Default Value: 0
    The unique identifier of the conflict for the address record. This number is used by mobile or portable applications that consume the web service.
  • Title: Corporate Currency
    Maximum Length: 15
    The corporate currency code associated with the address. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Country
    Maximum Length: 2
    The country code of the address. Review the list of country codes using the Manage Geographies task.
  • Title: County
    Maximum Length: 60
    The county element of address.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the record.
  • Default Value: HZ_WS
    The application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Created by Application
    Maximum Length: 30
    The module that created the record.
  • Title: Creation Date
    Read Only: true
    The date and time when the record was created.
  • Title: Currency Conversion Rate Type
    Maximum Length: 30
    The currency conversion rate type associated with the address. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency Code
    Maximum Length: 15
    The currency code related to the address. A list of valid values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Validated Date
    The date when the address was last validated.
  • Title: Description
    Maximum Length: 2000
    An extensive description of the location.
  • Title: Contact Preferences
    Default Value: false
    Indicates whether the address should not be used for mailing. If the value is Y, then the address should not be used to mail to the contact. The default value is N. If this attribute is not explicitly mentioned in the payload while creating an address, then the value of this attribute is set to null.
  • Title: Don't Validate
    Maximum Length: 1
    Indicates that a particular location is not eligible for address validation regardless of the current Validation Status Code.
  • Title: D-U-N-S Number
    Maximum Length: 30
    The D-U-N-S number of the business location.
  • The date when the address becomes active.
  • Title: End Date
    The date after which this address is rendered inactive.
  • Title: Floor
    Maximum Length: 40
    The specific floor number at a given address or in a particular building when building number is provided.
  • Title: Address
    Read Only: true
    The formatted address information.
  • Title: Formatted Address 1
    Read Only: true
    The formatted version of the address.
  • Title: Address
    Read Only: true
    The formatted multiple line address information.
  • Title: Address
    Read Only: true
    The formatted multiline version of the address.
  • Title: House Type
    Maximum Length: 30
    The type of the building in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login details of the user who last updated the record.
  • Title: Latitude
    The latitude information for the address. This is used for spatial proximity and containment purposes.
  • Links
  • Title: Location Directions
    Maximum Length: 640
    The directions to the location.
  • Title: Location ID
    The unique identifier for this location.
  • Title: Longitude
    The longitude information for the address. This is used for spatial proximity and containment purposes.
  • Title: Mail Stop
    Maximum Length: 60
    A user-defined code to indicate a mail drop point within their organization.
  • The number used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • The number used to implement optimistic locking for address record. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Title: Party ID
    The unique identifier of the account, contact or household to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the account, contact or household record with which the address is associated.
  • Title: Party Number
    The unique identifier for the party (account, contact, or household), to which the address is associated. One of PartyId, PartyNumber, or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact, or household record with which the address is associated. The profile option HZ_GENERATE_PARTY_NUMBER controls whether the attribute value can be system-generated or user-provided during create. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task. Inactive records can't be updated.
  • Title: Site Name
    Maximum Length: 240
    User-defined name for the address.
  • Title: Party Source System
    The name of external source system of the account, contact or household with which the address is associated. Part of alternate key for the account, contact or household record (along with PartyourceSystemReferenceValue). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
  • Title: Party Source System Reference Value
    The unique identifier from external source system for the account, contact or household with which the address is associated. Part of alternate key (along with PartySourceSystem). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated.
  • Title: Postal Code
    Maximum Length: 60
    The postal code as defined by the formal countrywide postal system.
  • Title: Postal Code Extension
    Maximum Length: 20
    The four-digit extension to the United States Postal ZIP code.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates whether this is the primary address of the associated object. If the value is True, then this is the primary address. The default value is False. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: Province
    Maximum Length: 60
    The province element of address.
  • The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Read Only: true
    Maximum Length: 255
    The name of the table that holds the address record data and is referenced to manage source system reference.
  • Read Only: true
    Maximum Length: 255
    Default Value: HZ_PARTIES
    The name of the table that holds the party record data and is referenced to manage source system reference.
  • Title: Start Date
    The date from which this address is active. This value is defaulted to the current system date if not provided during create.
  • Title: State
    Maximum Length: 60
    The state element of address.
  • Title: Status
    Maximum Length: 1
    Default Value: A
    An internal application-determined flag indicating status of the address. Status codes are defined by the lookup HZ_STATUS.
  • Title: Validated
    Maximum Length: 1
    Default Value: false
    Indicates if the location was validated. If the value is True, then the location is validated. The default value is false. The value is internally set by system during address cleansing.
  • Read Only: true
    The date on which the validation starts. This attribute is internally set by the system during address cleansing.
  • Title: Validation Status
    Maximum Length: 30
    The code indicating the status of the validation. Internally set by system during address cleansing.
Nested Schema : Address Locales
Type: array
Title: Address Locales
The address locales resource is used to view, create, update, and delete the local address. An address locale contains the details about a location or address in the local language.
Show Source
Nested Schema : Address Purposes
Type: array
Title: Address Purposes
The address purposes resource is used to view, create, update, and delete the address purpose. The address purpose describes the type of an address, such as a shipping address or a billing address.
Show Source
Nested Schema : households-Address-AddressLocale-item-response
Type: object
Show Source
  • Title: Address Element Attribute 1
    Maximum Length: 150
    The additional address element 1 to support flexible address format in local language.
  • Title: Address Element Attribute 2
    Maximum Length: 150
    The additional address element 2 to support flexible address format in local language.
  • Title: Address Element Attribute 3
    Maximum Length: 150
    The additional address element 3 to support flexible address format in local language.
  • Title: Address Element Attribute 4
    Maximum Length: 150
    The additional address element 4 to support flexible address format in local language.
  • Title: Address Element Attribute 5
    Maximum Length: 150
    The additional address element 5 to support flexible address format in local language.
  • Title: Address Line 1
    Maximum Length: 240
    The first line of the address in the local language.
  • Title: Address Line 2
    Maximum Length: 240
    The second line of the address in the local language.
  • Title: Address Line 3
    Maximum Length: 240
    The third line of the address in the local language.
  • Title: Address Line 4
    Maximum Length: 240
    The fourth line of the address in the local language.
  • Title: Site Number
    Read Only: true
    Maximum Length: 30
    The unique address identifier that's internally generated during create. One of the following keys is used to identify the address purpose record during update: AddressId, AddressNumber, or SourceSystem and SourceSystemReferenceValue.
  • Title: Building
    Maximum Length: 240
    The specific building name or number at a given address in local language.
  • Title: City
    Maximum Length: 60
    The specific name of the city in local language.
  • Title: Country
    Read Only: true
    Maximum Length: 2
    The specific name of the country in local language.
  • Title: County
    Maximum Length: 60
    The specific name of the county in local language.
  • Read Only: true
    Maximum Length: 64
    The user who created the address locale record.
  • Read Only: true
    The date and time when the address locale record was created.
  • Title: Floor
    Maximum Length: 240
    The specific floor number at a given address or a particular building when building number is provided in local language.
  • Read Only: true
    The formatted read only version of the locale address.
  • Read Only: true
    The date and time when the address locale was last updated.
  • Read Only: true
    Maximum Length: 64
    The user who last updated the address locale record.
  • Read Only: true
    Maximum Length: 32
    The login of the user who last updated the address locale record.
  • Links
  • The unique identifier of the location record.
  • Read Only: true
    The unique identifier of the location locale record.
  • Title: Postal Code
    Maximum Length: 60
    The postal code of the locale. A postal code, known in various countries as a post code, postcode, or ZIP code, is a series of letters or digits appended to a postal address for the purpose of sorting mail in local language.
  • Title: Postal Code Extension
    Maximum Length: 20
    The four digit extension to the United States Postal ZIP code in local language.
  • Title: Province
    Maximum Length: 60
    The name of the province in local language.
  • The name of external source system for the parent address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the parent address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Title: State
    Maximum Length: 60
    The name of the State in the local language.
  • Title: Transliteration Language
    Maximum Length: 4
    Transliteration Language helps people pronounce words and names in foreign languages. It's validated against FND_LANGUAGES.LANGUAGE_CODE. Sample values are US,NL, DK.
Nested Schema : households-Address-AddressPurpose-item-response
Type: object
Show Source
  • The unique address identifier that is internally generated during create. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address purpose record during update.
  • Title: Site Number
    Read Only: true
    Maximum Length: 30
    The unique address identifier that is internally generated during create. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address purpose record during update.
  • Read Only: true
    The unique identifier of the address purpose.
  • Title: Comments
    Maximum Length: 2000
    The user comments for the address purpose.
  • Read Only: true
    Maximum Length: 64
    The user who created the address purpose record.
  • Maximum Length: 30
    Default Value: HZ_WS
    The application module that created this address purpose record. The default value for CreatedByModule is HZ_WS for all Web service based creation. A list of accepted values is defined in the lookup type HZ_CREATED_BY_MODULES. You can review and update the value for this attribute using the Setup and Maintenance task work area, Manage Trading Community Common Lookups task.
  • Read Only: true
    The date and time when the address purpose record was created.
  • Indicates whether the address purpose is to be deleted. If the value is True, then the address purpose will be deleted. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: To Date
    The date on which the address purpose is no longer valid.
  • Read Only: true
    The date and time when the address purpose was last updated.
  • Read Only: true
    Maximum Length: 64
    The user who last updated the address purpose record.
  • Read Only: true
    Maximum Length: 32
    The login of the user who last updated the address purpose record.
  • Links
  • Title: Primary
    Maximum Length: 1
    Default Value: N
    Indicates if this is the primary use for the site. Y stands for the primary site and N stands for all other sites.
  • Title: Purpose
    Maximum Length: 30
    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.
  • The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • 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. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address purpose.
  • The unique identifier for the address purpose from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Title: From Date
    The date from which the address purpose is valid.
  • Title: Status
    Maximum Length: 1
    Default Value: A
    Indicates whether the address purpose is still valid for the associated address record. The value A indicates active and I indicates inactive.
Nested Schema : households-Attachment-item-response
Type: object
Show Source
Nested Schema : households-ContactPoint-item-response
Type: object
Show Source
  • Title: Conflict ID
    Default Value: 0
    The unique identifier of the conflict for the contact point record. This number is used by mobile or portable applications that consume the web service.
  • Title: Contact Point ID
    Read Only: true
    The unique identifier of the contact point.
  • Title: Type
    Maximum Length: 30
    The type of Contact Point record. The accepted values are defined in the lookup type COMMUNICATION_TYPE. Sample values include PHONE, EMAIL, and WEB.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the contact point record.
  • Title: Created by Application
    Default Value: HZ_WS
    The application module that created this contact point record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Creation Date
    Read Only: true
    The date when the record was created.
  • Title: OK to Contact
    Indicates whether to use a particular contact method. Defaulted to false.
  • Title: Do Not Contact
    Indicates whether the record can be contacted.
  • Title: Do Not Contact Reason
    The reason code for the contact preference.
  • Title: Email
    Maximum Length: 255
    The email address of the contact point record of type email.
  • Title: Email Purpose
    Maximum Length: 30
    The purpose of using the EMAIL contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE. The values can be ASSISTANT, PERSONAL, HOME_BUSINESS, BUSINESS, and so on.
  • Title: Phone Number
    Read Only: true
    Maximum Length: 255
    The formatted phone number of the contact point.
  • Title: Last Update Date
    Read Only: true
    The date when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the contact point record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login of the user who last updated the record.
  • Links
  • Title: Object Version Number
    The number used to implement optimistic locking for contact point record. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Title: Party ID
    The unique identifier of the associated party record for contact point.
  • Title: Registry ID
    The public unique identifier of the associated party record.
  • Title: Party Source System
    The name of external source system of the account, contact or household with which the contact point is associated. Part of alternate key for the account, contact or household record along with PartyourceSystemReferenceValue. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
  • Title: Party Source System Reference Value
    The unique identifier from external source system for the account, contact or household with which the address is associated. Part of alternate key along with PartySourceSystem. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated.
  • Title: Area Code
    Maximum Length: 255
    The area code for the phone number.
  • Title: Phone Country Code
    Maximum Length: 255
    The country code of the phone number.
  • Title: Extension
    Maximum Length: 255
    The extension number of the phone line number like office desk extension.
  • Title: Phone
    Maximum Length: 255
    The phone number of the contact point.
  • Title: Phone Purpose
    Maximum Length: 30
    Defines the purpose of using the PHONE contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
  • Title: Type
    The type of phone contact point. The accepted values are defined in the lookup type ORA_HZ_PHONE_TYPE. The values can be WORK, HOME, FAX, and so on.
  • Title: Preference Requested By
    Indicates if the permission or restriction was created internally or requested by the party. The list of accepted values are defined in the REQUESTED_BY lookup.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates whether this is the primary contact point of the associated object. If the value is True, then this is the primary contact point. The default value is False. If this attribute isn't explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: Phone
    Maximum Length: 255
    The raw phone number on the contact point record of type phone.
  • Title: User ID
    The unique identifier of the social network.
  • Title: Social Network
    The name of the social network.
  • Title: Social Network Purpose
    Maximum Length: 30
    Defines the purpose of using the IM contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
  • Title: Source System
    The name of external source system, which is defined by an administrator as part of system setup. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
  • Title: Source System Reference Value
    The unique identifier for the contacts party from the external source system specified in the attribute SourceSystem. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
  • Title: Status
    Maximum Length: 30
    Default Value: A
    Indicates the status of the contact point. The status codes are defined in the lookup HZ_STATUS. The default value is A.
  • Title: URL
    The URL of the contact point.
  • Title: Verification Date
    The date of verification of the phone or email contact point.
  • Title: Verification Status
    Maximum Length: 30
    The status of the verification for phone or email contact points. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID, ORA_INVALID and ORA_PARTIALLY_VALID. The value ORA_PARTIALLY_VALID is applicable only for email. Default value is blank which indicates that values aren't verified.
  • Title: Web Purpose
    Maximum Length: 30
    Defines the purpose of using the WEB contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE_WEB.Sample values: HOMEPAGE,SALESURL,MARKETINGURL,SUPPORTURL,RSS_FEED etc.
Nested Schema : households-CustomerClassification-item-response
Type: object
Show Source
  • Title: Classification Category
    Maximum Length: 30
    The name of the classification category.
  • Title: Classification Code
    Maximum Length: 30
    The code indicating the classification category. For example, High Technology, Customer, or Telecom.
  • Title: Classification Code Meaning
    Read Only: true
    Maximum Length: 80
    A valid classification code meaning corresponding to the classification code.
  • Title: Code Assignment ID
    Read Only: true
    The unique identifier for the customer classification assignment.
  • Read Only: true
    Default Value: 0
    The unique identifier of the conflict for the classification record. This number is used by mobile or portable applications that consume the web service.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the record.
  • Title: Created by Module
    Maximum Length: 30
    The application module that created the customer classification record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Creation Date
    Read Only: true
    The date when the record was created.
  • Title: End Date
    The date from which the classification code is no longer valid.
  • Title: Auxiliary Classification Status
    Read Only: true
    Indicates whether the classification category is an user-defined group classification category. The default value is false.
  • Title: Industry Type Status
    Read Only: true
    Indicates whether the classification category is an industry group classification category. The default value is false.
  • Title: Organization Type Status
    Read Only: true
    Indicates whether the classification category is an organization type classification category. The default value is false.
  • Title: Last Updated Date
    Read Only: true
    The date when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login of the user who last updated the record.
  • Links
  • Title: Party ID
    The unique Identifier of the account, contact or household with which the classification is associated.
  • Title: Party Number
    Maximum Length: 30
    The unique alternate identifier of the account, contact, or household with which the classification is associated. Inactive records can't be updated.
  • Title: Party Source System
    The name of the external source system of the account, contact, or household with which the classification is associated.
  • Title: Party Source System Reference Value
    Identifier from external source system for the account, contact or household with which the classification is associated.
  • Title: Party Type
    Read Only: true
    Maximum Length: 30
    Indicates the type of the party, such as account, contact, or household.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates if the customer classification is the primary classification. The default value is false.
  • Title: Source System
    The name of external source system where the customer classification is imported from. The values are configured in Setup and Maintenance work area, Manage Trading Community Source Systems task.
  • Title: Source System Reference Value
    The unique identifier for the customer classification in the external source.
  • Title: Start Date
    The date on which the customer classification was created.
  • Title: Status
    Maximum Length: 1
    Default Value: A
    Indicates if the code assignment is active or inactive. The code assignment is active if the value is A, and inactive if the value is I.
Nested Schema : households-Note-item-response
Type: object
Show Source
  • Title: Contact Relationship ID
    The unique identifier of the relationship that is populated when the note is associated with a contact.
  • Title: Corporate Currency Code
    Maximum Length: 15
    The corporate currency code associated with the note. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the record.
  • Title: Creation Date
    Read Only: true
    The date and time when the record was created.
  • Title: Creator Party ID
    The unique identifier of the person who created the note.
  • Title: Currency Conversion Rate Type
    Maximum Length: 30
    The currency conversion rate type associated with the note. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency
    Maximum Length: 15
    The currency code attribute associated with the note. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Delete Indicator
    Read Only: true
    Indicates whether the note is to be deleted. If the value is Y, then the note has to be deleted. The default value is N.
  • Title: Primary Email
    Read Only: true
    Maximum Length: 320
    The email address of the user who created the note.
  • Title: Primary Address
    Read Only: true
    The address of the user who created the note.
  • Title: Primary Phone
    Read Only: true
    The phone number of the user who created the note.
  • Title: Last Update Date
    Read Only: true
    The date and time when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login of the user who last updated the record.
  • Links
  • Title: Note ID
    Read Only: true
    The unique identifier of the note. This is the primary key of the notes table.
  • Maximum Length: 30
    The alternate unique identifier of the note. A user key that's system generated or from an external system.
  • Title: Title
    Maximum Length: 500
    The title of the note entered by the user.
  • Title: Note
    The column which will store the actual note text.
  • Title: Type
    Maximum Length: 30
    The code used to classify a note, as asset or adjustment.
  • Title: Parent Note ID
    The unique identifier of the parent note.
  • Title: Party ID
    Read Only: true
    The unique identifier for the party.
  • Title: Author
    Read Only: true
    Maximum Length: 360
    The name of the author of the note.
  • Title: Related Object Type
    Maximum Length: 30
    The code indicating the type of the source object as defined in OBJECTS Metadata, such as Activities, Opportunities, etc.
  • Title: Related Object
    Maximum Length: 64
    The unique identifier of the source object as defined in OBJECTS Metadata, such as activities, opportunities, etc.
  • Title: Update Indicator
    Read Only: true
    Indicates whether the note can be updated. If the value is Y, then the note can be updated. The default value is N.
  • Title: Private
    Maximum Length: 30
    Default Value: INTERNAL
    Specifies the visibility level of the note.
Nested Schema : households-PrimaryAddress-item-response
Type: object
Show Source
  • Title: Addressee
    Maximum Length: 360
    The addressee of the household.
  • Title: Additional Address Element 1
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 2
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 3
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 4
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Title: Additional Address Element 5
    Maximum Length: 150
    Additional address element to support flexible address format.
  • Read Only: true
    The unique identifier of the address that is internally generated during create. One of addressId, addressnumber or SourceSystem and sourcesystemreferencevalue keys is used to identify the address record during update.
  • Title: Address Line 1
    Maximum Length: 240
    The first line for address.
  • Title: Address Line 2
    Maximum Length: 240
    The second line for address.
  • Title: Address Line 3
    Maximum Length: 240
    The third line for address.
  • Title: Address Line 4
    Maximum Length: 240
    The fourth line for address.
  • Title: Address Lines Phonetic
    Maximum Length: 560
    Phonetic or Kana representation of the Kanji address lines (used in Japan).
  • Title: Site Number
    Maximum Length: 30
    The alternate key identifier of the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix is defined as in profile option ZCA_PUID_PREFIX, concatenated with an internally generated unique sequence number.
  • Title: Building
    Maximum Length: 240
    The specific building name or number at a given address.
  • Title: City
    Maximum Length: 60
    The city element of the primary address.
  • Title: Comments
    Maximum Length: 2000
    The user-provided comments for the primary address.
  • Default Value: 0
    The unique identifier of the conflict for the primary address record. This number is used by mobile or portable applications that consume the web service.
  • Maximum Length: 15
    The corporate currency code. A list of valid values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Country
    Maximum Length: 2
    The country code of the primary address. Review the list of country codes using the Manage Geographies task.
  • Title: County
    Maximum Length: 60
    The county element of the primary address.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the record.
  • Title: Creation Date
    Read Only: true
    The date and time when the record was created.
  • Maximum Length: 30
    The currency conversion rate type associated with the address. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency
    Maximum Length: 15
    The currency code associated with the primary address. The default value is the value specified in the profile option ZCA_COMMON_CORPORATE_CURRENCY.
  • Title: Validated Date
    The date when the address was last validated.
  • Title: Delete Primary Address
    Indicates whether the primary address is to be deleted. If the value is True, then the primary address will be deleted. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to null.
  • Title: Description
    Maximum Length: 2000
    An extensive description of the location.
  • Title: Don't Validate
    Maximum Length: 1
    Indicator to specify that a particular location isn't eligible for address validation irrespective of the current validation.
  • Title: To Date
    The last date for a primary address record in active status.
  • Title: Floor
    Maximum Length: 40
    The specific floor number at a given address or in a particular building when building number is provided.
  • Title: Address
    Read Only: true
    The formatted address information.
  • Title: Address
    Read Only: true
    The formatted multiple line address information.
  • Title: House Type
    Maximum Length: 30
    The type of the building mentioned in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login details of the user who last updated the record.
  • Title: Latitude
    The latitude information for the address. This is used for spatial proximity and containment purposes.
  • Links
  • Title: Comments
    Maximum Length: 2000
    The additional information for the record in free text format.
  • Title: Location Directions
    Maximum Length: 640
    The directions to the location.
  • The unique identifier for the location record for this address.
  • The integration key for the location record.
  • Title: Location ID
    The system identifier for the location record of the primary address.
  • The name of source system for the location record.
  • The unique identifier of the relationship from external source system.
  • Maximum Length: 1
    Default Value: true
    The location record of primary address.
  • Title: Longitude
    The longitude information for the address. This is used for spatial proximity and containment purposes.
  • Title: Mail Stop
    Maximum Length: 60
    The user-defined code that indicates a mail drop point within the organization.
  • The internal version number for the location for the primary address. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • The internal version number for the party site for primary address. The number is used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
  • Title: Primary
    Maximum Length: 1
    Default Value: false
    Indicates whether this is the primary address of the associated object. If the value is Y, then the address is a primary address.
  • The unique identifier of the account, contact or household to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the account, contact or household record with which the address is associated.
  • Title: Site Name
    Maximum Length: 240
    The name of the party site for the primary address.
  • Title: One-Time Address
    Maximum Length: 30
    The type of the party site. You can't use this attribute as a finder, because this is a transient field. The response will return an error if you use this attribute as a finder.
  • Title: Postal Code
    Maximum Length: 60
    The postal code element of the address.
  • Title: Postal Code Extension
    Maximum Length: 20
    The four-digit extension to the United States Postal ZIP code.
  • Title: Province
    Maximum Length: 60
    The province element of the address.
  • Title: Short Description
    Maximum Length: 240
    The short description of the primary address.
  • The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • The unique identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
  • Title: From Date
    The date on which the resource is associated with a sales account.
  • Title: State
    Maximum Length: 60
    The state element of the address.
  • Maximum Length: 1
    Default Value: A
    Indicates the status of the primary address. Status codes are defined by the lookup HZ_STATUS.
  • Title: Time Zone
    Maximum Length: 64
    The code of the time zone associated with the primary address.
  • Title: Validated
    Maximum Length: 1
    Default Value: false
    Indicates whether the location was validated. Y for validated, N for invalidated. The value is internally set by system during address cleansing. The default value is NULL. If this attribute is not explicitly mentioned in the payload, then the value of this attribute is set to NULL.
  • Title: Validation Status
    Maximum Length: 30
    The code indicating the status of the validation. Internally set by system during address cleansing.
Nested Schema : households-Relationship-item-response
Type: object
Show Source
  • Title: Backward Role
    Read Only: true
    The backward relationship code used to describe relationships. For example, SUPPLIER_OF.
  • Title: Comments
    Maximum Length: 2000
    The comments provided by the user.
  • Default Value: 0
    The unique identifier of the conflict for the relationship record. This number is used by mobile or portable applications that consume the web service.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the record.
  • Title: Created by Application
    Maximum Length: 30
    Default Value: HZ_WS
    The application module that created the relationship record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
  • Title: Creation Date
    Read Only: true
    The date and time when the record was created.
  • Title: Dependent Indicator
    Maximum Length: 1
    Default Value: N
    Indicates whether one party is dependent on another. Default value is N.
  • Read Only: true
    Maximum Length: 30
    The code of the relationship direction. The list of accepted values are defined in the lookup DIRECTION_CODE. Valid values are P-Parent, C-Child, N-Not Directional.
  • Title: To Date
    The date when the relationship ends.
  • Title: Head of Household Indicator
    Maximum Length: 1
    Default Value: N
    Indicates whether a person is the head of the household that he belongs to. It's applicable only in the MEMBERSHIP relationship, and will be used to indicate which members are the head of household. There may be multiple heads of households, depending on the deploying company's implementation.
  • Title: Influence Level
    The sales contact's influence in a buying relationship. Sample values are Inner Circle, Political structure, None.
  • Maximum Length: 100
    The definition of the job name.
  • Maximum Length: 900
    The definition of the job package.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login details of the user who last updated the record.
  • Links
  • The unique identifier of the object in this relationship.
  • Title: Object Party Name
    Read Only: true
    Maximum Length: 360
    The name of the object party.
  • Title: Object Registry ID
    Maximum Length: 30
    The alternate key identifier of the object party of the relationship.
  • Title: Object Source System
    The name of external source system for the object party in the relationship, which are defined by an admin as part of system setup.
  • Title: Object Source System Reference
    The unique identifier for the object party in the relationship from external source system.
  • Maximum Length: 30
    The source table name of the object party in this relationship.
  • Maximum Length: 30
    The object type of the relationship like ORGANIZATION, PERSON.
  • Maximum Length: 30
    The usage code of object party in the relationship.
  • The number used to implement optimistic locking for relationship record. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Read Only: true
    The alternate number used to implement optimistic locking for relationship record.
  • Read Only: true
    The alternate number to implement optimistic locking for relationship record.
  • Read Only: true
    The alternate unique identifier of the associated party record.
  • Read Only: true
    The alternate identifier of the associated party record.
  • Title: Ownership Percentage
    The percentage of the child entity owned by the parent entity.
  • Maximum Length: 10
    Default Value: false
    Indicates whether this contact person is primary contact for the customer. Accepted values are Y and N. Default value is N.
  • Maximum Length: 10
    Default Value: false
    Indicates whether this customer is primary customer for the contact. Accepted values are Y and N. Default value is N.
  • Title: Relationship Code
    Maximum Length: 30
    The code indicating whether this is a forward or a backward relationship code.
  • Read Only: true
    The unique identifier of the relationship.
  • The unique identifier of the relationship record.
  • The name of the external source system for the relationship, which are defined by an admin as part of the system setup.
  • The unique identifier of the relationship from external source system.
  • Title: Relationship Type
    Maximum Length: 30
    The name of the type of the relationship. For example, CUSTOMER_SUPPLIER.
  • The unique identifier of the request on relationship record.
  • Title: Role
    The role between the subject and object party.
  • Read Only: true
    Maximum Length: 255
    Default Value: HZ_PARTIES
    The name of the table that holds the record data and is referenced to manage source system reference.
  • Title: From Date
    The date when the relationship begins.
  • Read Only: true
    Maximum Length: 1
    Default Value: A
    The status of the relationship, A for active, I for inactive.
  • The unique identifier of the subject in this relationship.
  • Title: Subject Party Name
    Read Only: true
    Maximum Length: 360
    The name of the subject party.
  • Title: Subject Registry ID
    Maximum Length: 30
    The alternate key identifier of the subject party of the relationship.
  • Title: Subject Source System
    The name of external source system for the subject party in the relationship, which are defined by an admin as part of system setup.
  • Title: Subject Source System Reference
    The unique identifier of the subject party in the relationship from external source system.
  • Maximum Length: 30
    The source table name of the subject party in this relationship.
  • Maximum Length: 30
    The subject type of the relationship like ORGANIZATION, PERSON.
  • Maximum Length: 30
    The usage code of subject party in the relationship.
Nested Schema : households-SalesTeamMember-item-response
Type: object
Show Source
  • Title: Access
    Maximum Length: 30
    The code indicating the level of access granted to the resource as well as managers of the organizations. The possible values are defined in the ZCA_ACCESS_LEVEL lookup. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
  • Title: Assignment Type
    Maximum Length: 30
    Default Value: MANUAL
    The code indicating how the resource is assigned to the sales account team. The possible values are contained in the ZCA_ASSIGNMENT_TYPE lookup.
  • Title: Corporate Currency Code
    Maximum Length: 15
    The corporate currency code associated with the sales team member. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the record.
  • Title: Creation Date
    Read Only: true
    The date and time when the record was created.
  • Title: Currency Conversion Rate Type
    Maximum Length: 30
    The currency conversion rate type associated with the address. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
  • Title: Currency Code
    Maximum Length: 15
    The currency code associated with the sales team member of the household object. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • Title: Archived Date
    The date when the resource is dissociated from the sales account.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the record was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the record.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The login details of the user who last updated the record.
  • Links
  • Title: Locked
    Maximum Length: 1
    Default Value: false
    Indicates if the automatic territory assignment can be set. If the value is True, then the automatic territory assignment cannot remove the sales account team resource. When a sales account team member is added manually, this flag is defaulted to `Y'.
  • Title: Function
    Maximum Length: 30
    The code indicating the role of a sales team member in the resource team such as Integrator, Executive Sponsor, and Technical Account Manager. A list of accepted values is defined in the lookup FND_LOOKUPS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
  • The number used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • Title: Owner
    Default Value: false
    Indicates whether the resource is the owner.
  • The unique identifier of the associated party record for sales team member record.
  • The public identifier of the associated party record.
  • The name of external source system of the associated party record.
  • The unique identifier from external source system of the associated party record.
  • Title: Resource Email
    The email address of the resource.
  • Title: Resource ID
    The unique identifier of the household resource.
  • Title: Resource Name
    Read Only: true
    The name of the sales team member.
  • Read Only: true
    The name of the organization that the sales team member belongs to.
  • Title: Resource Party Number
    The alternate key identifier of the resource that this team member belongs to.
  • Title: Phone
    Read Only: true
    The primary phone number of the sales team member.
  • Title: Role
    Read Only: true
    The names of the roles assigned to the sales team member.
  • Title: Sales Account ID
    The unique identifier for the sales account.
  • Title: Start Date
    The date on which the resource is associated with a sales account.
  • Title: Sales Account Resource ID
    The unique identifier of the member of the sales accounts resource team.
  • Title: User Last Update Date
    The date and time when the record was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database.
Nested Schema : households-SourceSystemReference-item-response
Type: object
Show Source
Back to Top

Examples

cURL Command

The following example shows how to update a household by submitting a patch request on the REST resource using cURL.

curl -u <username:password> \ -X PATCH -d @example_request_payload.json https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/households/CDRM_9049

Example of Request Body

The following example shows the contents of the request body in JSON format.

{
    "HouseholdName": "Pinnacle Inc",
    "CreatedByModule": "HZ_WS",
    "Type": "ZCA_CUSTOMER",
    "YearIncorporated": "2000",
    "PhoneCountryCode": "1",
    "PhoneAreaCode": "408",
    "PhoneNumber": "9991111",
    "PhoneExtension": "56",
    "EmailAddress": "Tenng.lean@oracle.com",
    "URL": "www.oracle-upd.com"
}

Example of Response Body

The following example shows the contents of the response body in JSON format.

{
    "HouseholdName": "Pinnacle Inc",
    "UniqueNameSuffix": "(Redwood Shores, US)",
    "PartyUniqueName": "Pinnacle Flowers (Redwood Shores, US)",
    "Type": "ZCA_CUSTOMER",
    "OwnerEmailAddress": "Tenng.lean@oracle.com ",
    "CreatedByModule": "HZ_WS",
    ...
}
Back to Top