Skip to main content
Solved

Customer Type information in the database

  • October 6, 2023
  • 5 replies
  • 88 views

Forum|alt.badge.img+6

Hello,

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

 

Regards,

Pierrick

Best answer by hhy38

@Pierrick You can get like below.

 

 

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

 

5 replies

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • October 6, 2023

Hi @Pierrick 

 

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

 

 

 

Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • October 6, 2023

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.


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • Answer
  • October 7, 2023

@Pierrick You can get like below.

 

 

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

 


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • October 18, 2023

Hi @hhy38,

Thanks a lot for your answer, it works !


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • October 18, 2023

You are welcome. :)