Looking to create a BAQ that will list out all Reason Types and Codes listed under Type - Any ideas what table the Reason Type is listed in?
Erp.Reason.
The ReasontType value will have to be found in the Field Help (technical) or in the Data Dictionary for the table. Or you can compare what you see on screen with what you see in the BAQ results to figure it out.
I pulled table ERP>Reason - selected Reason Type, Reason Code, Reason Description
Display (FYI) Reason Type is one digit A, D, L, M, Q,S,W - Figured out all but the L and W. By looking at reason code maint.
L & W are Quote Task Win/Loss reasons
If it is solved for you, mark it as Solved so others will see this when searching.