Question

Customer Type information in the database

  • 6 October 2023
  • 5 replies
  • 59 views

Badge +3

Hello,

In which database table can i found the data “Customer Type” :

 

Regards,

Pierrick


5 replies

Userlevel 5
Badge +14

Hi @Pierrick 

 

The area is not stored in the database. The area is an Enumeration. You can see where it comes from below.

 

 

 
Badge +3

Thanks for your answer, i explain my need : we are building the data mapping for our BI tool (Report One) and we search were we can get this data by request.

Userlevel 5
Badge +14

@Pierrick You can get like below.

 

 

SELECT DISTINCT identity_type_api.decode(identity_type_db),
identity_type_db
FROM identity_invoice_info

 

Badge +3

Hi @hhy38,

Thanks a lot for your answer, it works !

Userlevel 5
Badge +14

You are welcome. :) 

Reply