费用报销模块表说明

一、基础数据
T_BC_ExpenseType 费用类型    
T_BC_OperationType 业务类别  
T_BC_CollectionAccount 收款信息
T_BC_AccountLimit 员工额度表
T_BC_BudgetControl 额度控制
T_BC_ProxyReimburse 代理报销
T_BC_REIMBURSELEVELSETTING 额度设置
T_BC_ReimburseLevel 报销级别
T_BC_STAFFREIMBURSELEVELSET  差旅标准级别

T_BC_EvectionStandard 差旅标准

二、主要业务表

--费用申请单
SELECT distinct bat.* FROM T_BC_OtherExpenseBill  bat
inner join T_BC_OtherExpenseBillEntry   baten  on bat.fid=baten.fbillid
inner join T_ORG_Company org on  bat.FCompanyID=org.fid
where  org.fnumber='申请人公司编码'
--and bat.fnumber='单据编码'

--出差申请单
SELECT distinct bat.* FROM T_BC_EvectionReqBill  bat
inner join T_BC_EvectionReqBillEntry   baten  on bat.fid=baten.fbillid
inner join T_ORG_Company org on  bat.FCompanyID=org.fid
where org.fnumber='申请人公司编码'
--and bat.fnumber='单据编码'

--费用报销单
SELECT distinct bat.* FROM T_BC_BizAccountBill  bat
inner join T_BC_BizAccountBillEntry baten  on bat.fid=baten.fbillid
inner join T_ORG_Company org on  bat.FCompanyID=org.fid
where org.fnumber='申请人公司编码'
--and bat.fnumber='单据编码'

--对公报销单
SELECT distinct bat.* FROM T_BC_BizAccountOutBill   bat
inner join T_BC_BizAccountOutBillEntry     baten  on bat.fid=baten.fbillid
inner join T_ORG_Company org on  bat.FCompanyID=org.fid
where org.fnumber='申请人公司编码'
--and bat.fnumber='单据编码'

--差旅报销单
SELECT distinct bat.* FROM T_BC_TravelAccountBill  bat
inner join T_BC_TravelAccountBillEntry   baten  on bat.fid=baten.fbillid
inner join T_ORG_Company org on  bat.FCompanyID=org.fid
where org.fnumber='申请人公司