Informations for query report


I’m trying to write a query report but I can’t find the names for several columns… I’m a beginner in SQL, so I’m still trying to figure out how it works, and I’ve managed to create a report using the other ones to get the names of the columns but I’d like to add two other colums for which no report is created… Is there a list or a way to get those names ?

By name, I mean this kind of line : po_item.item_code as “Item Code:Link/Item:120”

Thanks, and sorry if it seems like a stupid question for you…


Try to find that doctype in doctype list or customize form., there you will find list of all fields name.

For Example,
Find purchase order doctype in doctype list or customize form, there you will find all fields of purchase order.

Thanks, that’s what I was looking for !