Skip to main content

Hello,

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

 

Regards,

Pierrick

Hi @Pierrick 

 

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

 

 

 

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.

@Pierrick You can get like below.

 

 

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

 

Hi @hhy38,

Thanks a lot for your answer, it works !

You are welcome. :) 

Reply


Terms & ConditionsCookie settings