select * from ASM_NumberBill
select * from ASM_NumberBillDetail

select * from INM_OutBill
select * from INM_OutBillDetail

select * from ASM_CounterBill

select * from PPM_JobBill
select * from PPM_JobBillDetail
select * from PPM_JobBillDetailNumericAssert
select * from PPM_JobBillDetailUsedMaterial
select * from PPM_JobBillDetailUserExec

select * from RSM_GatheringBill

select * from SRM_SettlePaymentBill
select * from SRM_SettlePaymentBillDetail

select * from RSM_SettleGatheringBill
select * from RSM_SettleGatheringBillDetail

select * from RSM_PettyGatheringBill

select * from FAM_CredenceBill
select * from FAM_CredenceBillDetail

select * from INM_InBill
select * from INM_InBillDetail

select * from FAM_IncomingBill

select * from RSM_RefundmentBill

select * from ASM_MaintenanceBill

select * from PPM_LogisticsBill

select * from SRM_ChargeUpPaymentBill

select * from INM_UsedBill
select * from INM_UsedBillDetail

select * from RSM_PreGatheringBill

select * from FAM_OutgoingBill

select * from FAM_TransferBill

--抄表单
delete ASM_NumberBillDetail where ParentBillCode in(
select Code from ASM_NumberBill where BusiDate<'2016-01-01')

delete ASM_NumberBill where BusiDate<'2016-01-01'

--出库单
delete INM_OutBillDetail where ParentBillCode in(
select Code from INM_OutBill where BusiDate<'2016-01-01')

delete INM_OutBill where BusiDate<'2016-01-01'

--工作单
delete PPM_JobBillDetailUserExec where JobBillCode in(
select Code from PPM_JobBill where BusiDate<'2016-01-01'
)

delete PPM_JobBillDetailUsedMaterial where  JobBillCode in(
select Code from PPM_JobBill where BusiDate<'2016-01-01'
)

delete PPM_JobBillDetailNumericAssert where  JobBillCode in(
select Code from PPM_JobBill where BusiDate<'2016-01-01'
)

delete PPM_JobBillDetail where  ParentBillCode in(
select Code from PPM_JobBill where BusiDate<'2016-01-01'
)

delete PPM_JobBill where BusiDate<'2016-01-01'

--结算单
delete RSM_GatheringBill where BusiDate<'2016-01-01'

--结付单
delete SRM_SettlePaymentBillDetail where ParentBillCode in
(
select Code from SRM_SettlePaymentBill where BusiDate<'2016-01-01'
)

delete SRM_SettlePaymentBill where BusiDate<'2016-01-01'

--销账单
delete RSM_SettleGatheringBillDetail where ParentBillCode in(
select Code from RSM_SettleGatheringBill where BusiDate<'2016-01-01'
)

delete RSM_SettleGatheringBill where BusiDate<'2016-01-01'

--零售单
delete RSM_PettyGatheringBill where BusiDate<'2016-01-01'

--凭证单
delete FAM_CredenceBillDetail where ParentBillCode in(
select Code from FAM_CredenceBill where BusiDate<'2016-01-01'
)

delete FAM_CredenceBill where BusiDate<'2016-01-01'

--入库单
delete INM_InBillDetail where ParentBillCode in(
select Code from INM_InBill where BusiDate<'2016-01-01'
)

delete INM_InBill where BusiDate<'2016-01-01'

--收入单
delete FAM_IncomingBill where BusiDate<'2016-01-01'

--退款单
delete RSM_RefundmentBill where BusiDate<'2016-01-01'

--维护单
delete ASM_MaintenanceBill where BusiDate<'2016-01-01'

--物流单
delete PPM_LogisticsBill where BusiDate<'2016-01-01'

--应付单
delete SRM_ChargeUpPaymentBill where BusiDate<'2016-01-01'

--用料单
delete INM_UsedBillDetail where ParentBillCode in(
select Code from INM_UsedBill where BusiDate<'2016-01-01'
)

delete INM_UsedBill where BusiDate<'2016-01-01'

--预存单
delete RSM_PreGatheringBill where BusiDate<'2016-01-01'

--支出单
delete FAM_OutgoingBill where BusiDate<'2016-01-01'

--转账单
delete FAM_TransferBill  where BusiDate<'2016-01-01'