/*供應(yīng)商結(jié)余款操作*/
if exists (select * from sysobjects where id = object_id('van_balance_client') ) drop table van_balance_client;  
CREATE TABLE van_balance_client
(
operat_id             varchar(30)  not null, /*操作單號(hào)*/
clientid              varchar(30)   null,    /*供應(yīng)商id*/
bal_front             numeric(12,2)  null,   /*該供應(yīng)商上期結(jié)余款金額*/
bal_opera             numeric(12,2) null,    /*操作結(jié)余款*/
bal_use               varchar(100)  null,    /*結(jié)余款操作方式（增加，減少）*/
register_date         datetime null,         /*結(jié)余款操作時(shí)間*/
operator              char(30) null,         /*操作人員*/
PRIMARY KEY (operat_id)
);