2、分析过程

•   需要后台查询卡片的月结表或余额表记录是否存在。
  

•   检查卡片月结表是否有数据

  select * from t_fa_facurcard where fcompanyid =(select fid from t_org_company where fnumber ='组织编码') and fperiodid in(select fid from t_bd_period where fnumber <=当前期间的上一个期间编码) and fbizstatus<>'0399' and fbizstatus<>'0499' and fbizstatus<>'0599' and fid not in(select ffacurcardid from t_fa_famoncard where fcompanyid =(select fid from t_org_company where fnumber ='组织编码') and ffaperiodid in(select fid from t_bd_period where fnumber =当前期间的上一个期间编码))
  

• 检查卡片余额表是否有数据

   select * from t_fa_facurcard where fid not in(select ffacurcardid from t_fa_faaccountbalance where           fcompanyORGunitid=(select fid from t_org