hongtaiyang/runtime/server/properties/script_ztfl/6.0/sql/ncm/ncm_clean.sql

--产品间费用分配标准设置
Delete from T_NCM_AllocStdSetByPrd where FCompanyID in ($ORGID) and FCalculatePeriodID in ($FPERIOD_ID);


--在产品成本分配标准设置
Delete from T_NCM_AllocStdSetByWIP where FCompanyID in ($ORGID) and FCalculatePeriodID in ($FPERIOD_ID);


--成本中心间分配标准设置
Delete from T_NCM_AllocStdSetByCCO where FCompanyID in ($ORGID) and FCalculatePeriodID in ($FPERIOD_ID);


--实际工时数据
Delete from T_NCM_ActualHourEntry where FParentID in 
(select Fid from T_NCM_ActualHour where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID));

Delete from T_NCM_ActualHour where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID);


--约当系数数据录入
Delete from T_NCM_EquivalentCoef where FCompanyID in ($ORGID) and FCalculatePeriodID in ($FPERIOD_ID);


--自定义分配标准数据录入
Delete from T_NCM_UserDefinedData where FCompanyID in ($ORGID) and FCalculatePeriodID in ($FPERIOD_ID);


--投入产量录入
Delete from T_NCM_InputQtyBillEntry where FParentID in 
(select Fid from T_NCM_InputQtyBill where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID));

Delete from T_NCM_InputQtyBill where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID);


--在产品产量盘点
Delete from T_NCM_WIPCountingBill where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID);


--其它费用归集
Delete from T_NCM_OtherFeeBillEntry where FParentID in 
(select Fid from T_NCM_OtherFeeBill where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID));

Delete from T_NCM_OtherFeeBill where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID);


--成本中心费用归集
Delete from T_NCM_CCOFeeBillEntry where FParentID in 
(select Fid from T_NCM_CCOFeeBill where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID));

Delete from T_NCM_CCOFeeBill where FCompanyOrg in ($ORGID) and FCalculatePeriod in ($FPERIOD_ID);


--成本计算报告数据
Delete from T_NCM_CalcLog where FCompanyId in ($ORGID) and FPeriodId in ($FPERIOD_ID);