I have decided to not use contract billing in SDP MSP at this time. Instead, I run a report on the first of the month for the previous month's work log. I have added an additional Pick List Account field to set billing type for an account, and would like to modify the report query to filter the report and only show accounts with a specific account type. I've found the fields in actablecolumns (ATTRIBUTE_301) but not sure how to add the additional WHERE to filter on this field in the following query:

SELECT ad.ORG_NAME "Account",wo.WORKORDERID "Request ID",ct.CREATEDTIME "Time Spent Created Time",rctd.FIRST_NAME "Time Spent Technician",aau.FIRST_NAME "Requester",std.STATUSNAME "Request Status",wo.COMPLETEDTIME "Completed Time",ct.TIMESPENT "Time Spent",ct.TOTAL_CHARGE "Time Spent Total_Charge" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID INNER JOIN AccountSiteMapping asm ON wo.siteid=asm.siteid INNER JOIN AccountDefinition ad ON asm.accountid=ad.org_id WHERE  (((ct.CREATEDTIME >= 1396310400000) AND ((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL))) AND ((ct.CREATEDTIME <= 1398902399000) AND (((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL)) AND (ct.CREATEDTIME != -1))))  AND wo.ISPARENT='1'  ORDER BY 1 NULLS FIRST