CF is not displayed in SQL view

Hi @Ed22 ,

Please tray to add “_CFV” after your view.

For example: Customer_order_cfv.

CFV means custom field view.

Hope it helps

Ozgun Bal

I created Custom Field CF_AAA_CISLO, but I had this error: 

@Ed22 if you added the Custom Attribute in the Sales Price List entity, then you should run the below query. Are you getting the CF?

select * from IFSAPP.SALES_PRICE_LIST_CFV

it says table or view does not exist

@Ed22 is this the 1st CF created in the SalesPricelIst entity? Did you Publish the entity configuration?

Can you provide a screenshot of the SalesPriceList entity configuration please?

I added this CF in entity SalesPriceListPart, should I add to the SalesPriceList? 

@Ed22 OK, got it now. You need to query the IFSAPP.SALES_PRICE_LIST_PART_CFV view then.

I have still error which is in picture 1: ORA00904 CF$_AAA_CISLO: invalid identifier

Thank you, I solved this. Problem wasnt in this CF problem was in another CF, I removed wrong CF and it works.