D:\apache-tomcat7
-----------------------------------------------
/*
初始版本为 2020-12-15 清除业务单据
*/


-- 删除仓库信息
select * from CK_CGMT
select * from CK_CGDT
select * from CK_RKMT
select * from CK_RKDT
select * from CK_ThMT
select * from CK_ThDT
select * from CK_ChuKMT
select * from CK_ChuKDT
select * from CK_XTMT
select * from CK_XTDT

select * from CK_YKMT
select * from CK_YKDT
select * from CK_PDMT
select * from CK_PDDT
select * from CK_SYMT
select * from CK_SYDT

select * from CK_JZMT
select * from CK_JZDT
select * from CK_jhcbMt
select * from CK_jhcbDt
select * from CK_cbkc
select * from Store

/*
-- 删除仓库信息

truncate table CK_CGMT
truncate table CK_CGDT
truncate table CK_RKMT
truncate table CK_RKDT
truncate table CK_ThMT
truncate table CK_ThDT
truncate table CK_ChuKMT
truncate table CK_ChuKDT
truncate table CK_XTMT
truncate table CK_XTDT

truncate table CK_YKMT
truncate table CK_YKDT
truncate table CK_PDMT
truncate table CK_PDDT
truncate table CK_SYMT
truncate table CK_SYDT

truncate table CK_JZMT
truncate table CK_JZDT
truncate table CK_jhcbMt
truncate table CK_jhcbDt
truncate table CK_cbkc
truncate table Store

*/

-- 删除专柜信息
select * from ZG_RKMT
select * from ZG_RKDT
select * from ZG_THMT
select * from ZG_THDT
select * from ZG_BHMT
select * from ZG_BHDT

select * from ZG_DBMT
select * from ZG_DBDT
select * from ZG_PDMT
select * from ZG_PDDT
select * from ZG_SYMT
select * from ZG_SYDT

select * from ZG_XSMT
select * from ZG_XSDT
select * from ZG_xsDT2
select * from ZG_xsmbMt
select * from ZG_xsmbDt

select * from ZG_CKchaMT
select * from ZG_CKchaDT
select * from ZG_JZMT
select * from ZG_JZDT
select * from Counter

select * from ZG_KSdate
select * from ZG_kdtzdMt
select * from ZG_kdtzdDt
select * from ZG_kdtzdDt2

select * from ZG_tjdMt
select * from ZG_tjdDt
select * from ZG_tjdDt2
select * from ZG_tjdFzMt
select * from ZG_tjdFzDt
select * from ZG_tjdFzDt2

/*
-- 删除专柜信息

truncate table ZG_RKMT
truncate table ZG_RKDT
truncate table ZG_THMT
truncate table ZG_THDT
truncate table ZG_BHMT
truncate table ZG_BHDT

truncate table ZG_DBMT
truncate table ZG_DBDT
truncate table ZG_PDMT
truncate table ZG_PDDT
truncate table ZG_SYMT
truncate table ZG_SYDT

truncate table ZG_XSMT
truncate table ZG_XSDT
truncate table ZG_xsDT2
truncate table ZG_xsmbMt
truncate table ZG_xsmbDt

truncate table ZG_CKchaMT
truncate table ZG_CKchaDT
truncate table ZG_JZMT
truncate table ZG_JZDT
truncate table Counter

truncate table ZG_KSdate
truncate table ZG_kdtzdMt
truncate table ZG_kdtzdDt
truncate table ZG_kdtzdDt2

truncate table ZG_tjdMt
truncate table ZG_tjdDt
truncate table ZG_tjdDt2
truncate table ZG_tjdFzMt
truncate table ZG_tjdFzDt
truncate table ZG_tjdFzDt2

*/

-- 初期成本
select * from Bsc_JZMT
select * from bsc_jzdt
select * from Cb_qcMt
select * from cb_qcdt
select * from cb_xzc
select * from Cb_JZMT
select * from Cb_JZdt

/*
-- 初期成本
truncate table Bsc_JZMT
truncate table bsc_jzdt
truncate table Cb_qcMt
truncate table cb_qcdt
truncate table cb_xzc
truncate table Cb_JZMT
truncate table Cb_JZdt

*/


-- 财务信息
select * from Cust_IMoney
select * from Cust_Fydt
select * from Sup_IMoney
select * from Sup_Fydt
select * from CS_IMoney
select * from Cw_rxskMt
select * from Cw_rxskDt
select * from Cw_ScjsdMt
select * from Cw_ScjsdDt
select * from Cw_jmsjsdMt
select * from Cw_jmsjsdDt
/*
truncate table Cust_IMoney
truncate table Cust_Fydt
truncate table Sup_IMoney
truncate table Sup_Fydt
truncate table CS_IMoney
truncate table Cw_rxskMt
truncate table Cw_rxskDt
truncate table Cw_ScjsdMt
truncate table Cw_ScjsdDt
truncate table Cw_jmsjsdMt
truncate table Cw_jmsjsdDt

*/


-- pos销售信息
select * from Pos_zfMx
select * from Pos_Cdjf
select * from Pos_CdJfSet
select * from Pos_Card
select * from Pos_CusLb
select * from Pos_CustDoc
/*
truncate table Pos_zfMx
truncate table Pos_Cdjf
*/