怎样查用友nc中预算表在数据库中表名

1、bd_forerate预算汇率表

2、fa_ntb_id预算用表

3、prm_returnbudget_b返利预算设置子表

4、gl_ntb_id总账预算执行表

5、arap_id_ntb预算注册表

6、prm_returnbudget返利预算设置

你根据自己的需要查找下。祝你好运

select SUM(CASE WHEN ap_detail.iflag = 5 THEN 0 ELSE Ap_Detail.iDAmount END) - SUM(CASE WHEN ap_detail.iflag = 5 THEN 0 ELSE Ap_Detail.iCAmount END) from ap_detail where cDwCode='C01043' and (iFlag = 0 OR iFlag = 5) AND cFlag = 'AR'这就是找一客户的期初

---