select
i.invoiceid EXTID,
i.accountid,
i.invoicedate,
i.duedate,
b.bill_street street,
b.bill_city city,
b.bill_state state,
b.bill_code code,
b.bill_country country,
b.bill_pobox pobox,
i.notes,
i.subject,
i.customerno,
i.invoicestatus,
i.discount_percent,
i.discount_amount ,
i.Adjustment,
i.s_h_amount,
10 as WDOCTYPEID,0 as BEXCLUSIVE FROM vtiger_invoice i join vtiger_accountbillads b on (i.Accountid = b.Accountaddressid)