--物料视图  
select * from VW_BD_MATERIAL_LB

--人员 
select * from VW_BD_PERSON_LB

--组织视图 
select * from VW_BAS_ORG_LB

--跟踪号
select * from t_mm_tracknumber a where a.fcontrolunitid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';

--仓库
select * from t_db_warehouse a where a.fstorageorgid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';

--工序
select * from t_mm_operation a where a.fstorageorgunitid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';

--工艺路线
select * from t_mm_standardrooting a where a.fstorageorgunitid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';

--BOM
select * from t_mm_bom a where a.fstorageorgunitid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';

--生产订单
select * from t_mm_manufactureorder a where a.fstorageorgunitid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';

--生产订单工艺
select * from t_mm_mftordertechnics a where a.fstorageorgunitid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';

--生产订单备料
select * from t_mm_mftorderstock a where a.fstorageorgunitid='JIxGQ7G0TQeP/jCu+62lo8znrtQ=';


//DFS向EAS中间表插入数据
--汇报主表
--汇报出勤班组主表
--汇报出勤班组明细表