收支凭证新增.sql 691 B

1234567
  1. insert into sa_cashbill (siteid, sa_cashbillid, createuserid, createby, createdate, billno, changeuserid, changeby,
  2. changedate,
  3. sys_enterpriseid, sa_accountclassid, type, remarks, amount, status, source, sourcenote,
  4. subclass, class, ownertable, ownerid,period,discountamount,billdate,isupload)
  5. values ($siteid$, $sa_cashbillid$, $userid$, $username$, CURRENT_TIME, $billno$, $userid$, $username$, CURRENT_TIME,
  6. $sys_enterpriseid$, $sa_accountclassid$, $type$, $remarks$,
  7. $amount$, '新建', $source$, $sourcenote$, $subclass$, $class$, $ownertable$, $ownerid$,$period$,$discountamount$,$billdate$,0);