- FROM ".TB_PREF."debtor_trans, ".TB_PREF."sys_types
- WHERE ".TB_PREF."debtor_trans.tran_date <= '$date' AND ".TB_PREF."debtor_trans.debtor_no = '$debtorno'
- AND ".TB_PREF."debtor_trans.type = ".TB_PREF."sys_types.type_id
- AND ".TB_PREF."debtor_trans.type <> 13
+ FROM ".TB_PREF."debtor_trans
+ WHERE ".TB_PREF."debtor_trans.tran_date <= '$date' AND ".TB_PREF."debtor_trans.debtor_no = ".db_escape($debtorno)."
+ AND ".TB_PREF."debtor_trans.type <> ".ST_CUSTDELIVERY."