Forum Stats

  • 3,826,991 Users
  • 2,260,733 Discussions
  • 7,897,146 Comments

Discussions

Extension attributes in Customer object data set

BrijTrivedi
BrijTrivedi Member Posts: 3

Hi,

We have few custom fields created in customer. for example: customer type.

None of these fields are visible in hz_parties data set. Could you please let us know if there is any other table where the custom fields of customer object are stored in or where to find these custom fields' extension attribute?

Thanks,

Brij

Tagged:
Helio Bianchi

Answers

  • Lucas Gomes-Oracle
    Lucas Gomes-Oracle Member Posts: 23 Employee
    edited Jun 16, 2015 2:08PM

    Hello Brij,

    Are you planning to use these fields in a Report? Have you created a Custom Subject Area?

    Regards,

    Lucas

  • BrijTrivedi
    BrijTrivedi Member Posts: 3
    edited Jun 23, 2015 10:21AM

    Hello Lucas,

    I have not created a subject area as I was working with data model and using SQL Query. I got an update from Support engineer that i can use HZ_ORGANIZATION_PROFILES OP to find custom field. That worked.

    Could you let me know from where can I find the table names for my reports which I need to create using Data model. I need to prepare reports using almost all objects like customer, contact, product, opportunity, revenue and related child objects.

    Thanks,

    Brij

This discussion has been closed.