学习目标

完成本单元后，您将能够：

了解费用常见元数据与query,客户端扩展常见问题。

业务场景

在费用实际业务中，往往标准产品无法满足现场个性化需求，通过了解常用的费用扩展类和query，能更好帮助我们去了解费用底层逻辑，动态扩展满足现场需求的单据

1.常见元数据和query

申请类单据

单据

元数据

费用申请单

bosType:E76173AD
billTypeCode:70

实体：com.kingdee.eas.cp.bc.app.OtherExpenseBill (T_BC_OtherExpenseBill)
分录: com.kingdee.eas.cp.bc.app.OtherExpenseBillEntry

(T_BC_OtherExpenseBillEntry)

GUI编辑页: com.kingdee.eas.cp.bc.client.OtherExpenseEditUI

1.gui费用报销下
GUI列表页: com.kingdee.eas.cp.bc.client.OtherExpenseReqListUI
GUI列表页query: com.kingdee.eas.cp.bc.app.OtherExpBillQuery
GUI带分录query: com.kingdee.eas.cp.bc.app.OtherExpBillWithEntryQuery

2.gui费用核算下(eas8.2、8.5才有核算)
GUI核算下列表页:com.kingdee.eas.cp.bc.client.OtherExpenseReqShareListUI
GUI核算下列表页query: com.kingdee.eas.cp.bc.app.OtherExpBillSharingQuery
GUI核算下带分录query:

com.kingdee.eas.cp.bc.app.OtherExpBillWithEntrySharingQuery

3.套打query
ReportQuery: com.kingdee.eas.cp.bc.app.OtherExpBillForPrintQuery
R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.OtherExpenseBillForR1PrintQuery
R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.OtherExpenseBillEntryForPrintQuery

出差申请单

bosType:DE853384
billTypeCode:10

实体：com.kingdee.eas.cp.bc.app.EvectionReqBill (T_BC_EvectionReqBill)

分录: EvectionReqBillEntry (T_BC_EvectionReqBillEntry)

GUI编辑页: com.kingdee.eas.cp.bc.client.EvectionReqBillEditUI

1.gui费用报销下
GUI列表页: com.kingdee.eas.cp.bc.client.EvectionReqBillListUI
GUI列表页query: com.kingdee.eas.cp.bc.app.EvectionReqQuery
GUI带分录query: com.kingdee.eas.cp.bc.app.EvectionReqWithEntryQuery

2.gui费用核算下(eas8.2、8.5才有核算)
GUI核算下列表页:

com.kingdee.eas.cp.bc.client.EvectionReqBillShareListUI
GUI核算下列表页query: com.kingdee.eas.cp.bc.app.EvectionReqSharingQuery
GUI核算下带分录query:

com.kingdee.eas.cp.bc.app.EvectionReqWithEntrySharingQuery

3.套打query

ReportQuery: com.kingdee.eas.cp.bc.app.EvectionReqForPrintQuery

R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.EvectionReqBillForR1PrintQuery

R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.EvectionReqBillEntryForPrintQuery

借款类单据

单据

元数据

借款单

bosType:8110AAB2

billTypeCode:30

实体：com.kingdee.eas.cp.bc.app.DailyLoanBill (T_BC_DailyLoanBill)

分录: DailyLoanBillEntry (T_BC_DailyLoanBillEntry)
冲申请分录:DailyLoanBillReqCheckEntry (T_BC_DailyLBRCE)

GUI编辑页: com.kingdee.eas.cp.bc.client.DailyLoanBillEditUI

1.gui费用报销下
GUI列表页: com.kingdee.eas.cp.bc.client.LoanReqListUI
GUI列表query: com.kingdee.eas.cp.bc.app.DailyLoanBillQuery
GUI带分录query: com.kingdee.eas.cp.bc.app.DailyLoanWithEntryBillQuery

2.gui费用核算下(eas8.2、8.5才有核算)
GUI核算下列表页: com.kingdee.eas.cp.bc.client.LoanReqShareListUI
GUI核算下列表query: com.kingdee.eas.cp.bc.app.DailyLoanBillSharingQuery
GU核算下带分录query:

com.kingdee.eas.cp.bc.app.DailyLoanWithEntryBillSharingQuery
查看付款明细UI:

com.kingdee.eas.cp.bc.client.DailyLoanBillPayEntryListUI

3.套打query

ReportQuery: com.kingdee.eas.cp.bc.app.DialyLoadBillQueryForPrintQuery

R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.DailyLoanBillForR1PrintQuery

R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.DailyLoanBillEntryForPrintQuery

R1ReportCollectionEntryQuery:

com.kingdee.eas.cp.bc.app.DailyLoanBillAccountEntryForPrintQuery

出差借款单

bosType:7AE53B38 billTypeCode:20

实体：com.kingdee.eas.cp.bc.app.EvectionLoanBill (T_BC_EvectionLoanBill)

分录: EvectionLoanBillEntry (T_BC_EvectionLoanBillEntry)

冲申请分录: EvectionLoanBillReqCheckEntry (T_BC_EvectionLBRCE)

GUI编辑页: com.kingdee.eas.cp.bc.client.EvectionLoanBillEditUI

1.gui费用报销下

GUI列表页: com.kingdee.eas.cp.bc.client.EvectionLoanBillListUI

GUI列表query: com.kingdee.eas.cp.bc.app.EvectionLoanBillQuery

GUI带分录query:

com.kingdee.eas.cp.bc.app.EvectionLoanWithEntryBillQuery

2.gui费用核算下(eas8.2、8.5才有核算)

GUI核算下列表页:

com.kingdee.eas.cp.bc.client.EvectionLoanBillShareListUI

GUI核算下列表query:

com.kingdee.eas.cp.bc.app.EvectionLoanBillSharingQuery

GUI核算下带分录query:

com.kingdee.eas.cp.bc.app.EvectionLoanWithEntryBillSharingQuery

查看付款明细UI:

com.kingdee.eas.cp.bc.client.EvectionLoanBillPayEntryListUI

3.套打query

ReportQuery:

com.kingdee.eas.cp.bc.app.EvectionLoanForPrintQuery

R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.EvectionLoanBillForR1PrintQuery

R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.EvectionLoanBillEntryForPrintQuery

报销类单据

单据

元数据

费用报销单

bosType:4A44F49F

billTypeCode:90

实体：com.kingdee.eas.cp.bc.app.BizAccountBill (T_BC_BizAccountBill)

分录: BizAccountBillEntry （T_BC_BizAccountBillEntry）

冲申请分录: BizAccountBillReqCheckEntry (T_BC_BizABRCE)

冲借款分录: BizAccountBillLoanCheckEntry (T_BC_BizABLCE)

多收款人分录: BizAccountBillAccountEntry (T_BC_BizAccountBCE)

发票分录: TicketEntry (T_BC_TicketEntry)

GUI编辑页: com.kingdee.eas.cp.bc.client.BizAccountEditUI

1.gui费用报销下
GUI列表页: com.kingdee.eas.cp.bc.client.BizExpenseAccountListUI
GUI列表query: com.kingdee.eas.cp.bc.app.BizAccountQuery
GUI带分录query: com.kingdee.eas.cp.bc.app.BizAccountWithEntryQuery

2.gui费用核算下(eas8.2、8.5才有核算)
GUI核算下列表页:

com.kingdee.eas.cp.bc.client.BizExpenseAccountShareListUI
GUI核算下列表query: com.kingdee.eas.cp.bc.app.BizAccountSharingQuery
GUI核算下带分录query:

com.kingdee.eas.cp.bc.app.BizAccountWithEntrySharingQuery
查看付款明细UI:

com.kingdee.eas.cp.bc.client.BizAccountBillPayEntryListUI

3.套打query
ReportQuery: com.kingdee.eas.cp.bc.app.BizAccountForPrintQuery
R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.BizAccountBillForR1PrintQuery
R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.BizAccountBillEntryForPrintQuery
R1ReportCollectionEntryQuery:

com.kingdee.eas.cp.bc.app.BizAccountBillAccountEntryForPrintQuery

差旅费报销单

bosType:C57003BC billTypeCode:110

实体：com.kingdee.eas.cp.bc.app.TravelAccountBill(T_BC_TravelAccountBill)

分录: TravelAccountBillEntry（T_BC_TravelAccountBillEntry）

冲申请分录: TravelAccountBillReqCheckEntry (T_BC_TravelABRCE)

冲借款分录: TravelAccountBillLoanCheckEntry (T_BC_TravelABLCE)

多收款人分录: TravelAccountBillAccountEntry (T_BC_TravelAccountBCE)

发票分录: TraTicketEntry (T_BC_TraTicketEntry)

GUI编辑页: com.kingdee.eas.cp.bc.client.TravelAccountEditUI

1.gui费用报销下
GUI列表页: com.kingdee.eas.cp.bc.client.TravelExpenseAccountListUI
GUI列表query: com.kingdee.eas.cp.bc.app.TravelAccountQuery
GUI带分录query: com.kingdee.eas.cp.bc.app.TravelAccountWithEntryQuery

2.gui费用核算下(eas8.2、8.5才有核算)
GUI核算下列表页:

com.kingdee.eas.cp.bc.client.TravelExpenseAccountShareListUI
GUI核算下列表query: com.kingdee.eas.cp.bc.app.TravelAccountSharingQuery
GUI核算下带分录query:

com.kingdee.eas.cp.bc.app.TravelAccountWithEntrySharingQuery
查看付款明细UI:

com.kingdee.eas.cp.bc.client.TravelAccountBillPayEntryListUI

3.套打query
ReportQuery: com.kingdee.eas.cp.bc.app.TravelAccountForPrintQuery
R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.TravelAccountBillForR1PrintQuery
R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.TravelAccountBillEntryForPrintQuery
R1ReportEntrySumQuery:

com.kingdee.eas.cp.bc.app.TravelAccountBillEntrySumForPrintQuery
R1ReportCollectionEntryQuery:

com.kingdee.eas.cp.bc.app.TravelAccountBillAccountEntryForPrintQuery

物品采购报销单

bosType:30BD2798

billTypeCode:100

实体：com.kingdee.eas.cp.bc.app.DailyPurchaseAccountBill

(T_BC_DailyPurchaseAccountBill)

分录: DailyPurchaseAccountBillEntry（T_BC_DailyPurchaseAccontEntry）

冲申请分录: DailyPurchaseAccountBillReqCheckEntry (T_BC_DailyPABRCE)

冲借款分录: DailyPurchaseAccountBillLoanCheckEntry (T_BC_DailyPABLCE)

多收款人分录: DailyPurchaseAccountBillAccountEntry

(T_BC_DailyPurchaseBAE)

发票分录: PurTicketEntry (T_BC_PurTicketEntry)

GUI编辑页: com.kingdee.eas.cp.bc.client.DailyAccountEditUI

1.gui费用报销下
GUI列表页: com.kingdee.eas.cp.bc.client.DailyExpenseAccountListUI
GUI列表query: com.kingdee.eas.cp.bc.app.DailyPurAccountQuery
GUI带分录query:

com.kingdee.eas.cp.bc.app.DailyPurAccountWithEntryQuery

2.gui费用核算下(eas8.2、8.5才有核算)
GUI核算下列表页:

com.kingdee.eas.cp.bc.client.DailyExpenseAccountListShareUI
GUI核算下列表query:

com.kingdee.eas.cp.bc.app.DailyPurAccountSharingQuery
GUI核算下带分录query:

com.kingdee.eas.cp.bc.app.DailyPurAccountWithEntrySharingQuery
查看付款明细UI:

com.kingdee.eas.cp.bc.client.DailyPurchaseAccountBillPayEntryListUI

3.套打query
ReportQuery:

com.kingdee.eas.cp.bc.app.DailyPurAccountForPrintQuery
R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.DailyPurchaseAccountBillForR1PrintQuery
R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.DailyPurchaseAccountBillEntryForPrintQuery

对公费用报销单

bosType:92F938DD
billTypeCode:40

实体：com.kingdee.eas.cp.bc.app.BizAccountOutBill(T_BC_BizAccountOutBill)

实体表: com.kingdee.eas.cp.bc.app.T_BC_BizAccountOutBill

分录: BizAccountOutBillEntry（T_BC_ BizAccountOutBillEntry）

冲申请分录: BizAccountOutBillReqCheckEntry (T_BC_BizAOBRCE)

冲借款分录: BizAccountOutBillLoanCheckEntry (T_BC_BizAOBLCE)

多收款人分录: BizAccountOutBillAccountEntry (T_BC_BizAOBAE)

发票分录: BizOutTicketEntry (T_BC_BizOutTicketEntry)

1.套打query
ReportQuery:

com.kingdee.eas.cp.bc.app.BizAccountOutForPrintQuery
R1ReportBillQuery:

com.kingdee.eas.cp.bc.app.BizAccountOutBillForR1PrintQuery
R1ReportEntryQuery:

com.kingdee.eas.cp.bc.app.BizAccountOutBillEntryForPrintQuery

还款类单据

单据

元数据

还款单

bosType:0B104F5C
billTypeCode:108

实体：com.kingdee.eas.cp.bc.app.RePaymentBill

GUI编辑页: com.kingdee.eas.cp.bc.client.RePaymentBillEditUI

1.gui费用报销下

GUI列表页:com.kingdee.eas.cp.bc.client.RePaymentBillListUI
GUI列表页query: com.kingdee.eas.cp.bc.app.RePaymentBillQuery
2.gui费用核算下(eas8.2、8.5才有核算)

GUI列表页:com.kingdee.eas.cp.bc.client.RePaymentBillSharingListUI
GUI列表页: com.kingdee.eas.cp.bc.app.RePaymentBillSharingQuery

其他

单据

元数据

收款帐号维护

bosType:A62F9111

实体：com.kingdee.eas.cp.bc.app.CollectionAccount

实体表: com.kingdee.eas.cp.bc.app.T_BC_CollectionAccount
GUI编辑页:com.kingdee.eas.cp.bc.client.CollectionAccountListUI

GUI列表页:com.kingdee.eas.cp.bc.client.CollectionAccountEditUI

报表

费用申请明细报表:com.kingdee.eas.cp.bc.client.ReqListRptMainUI

借款费用明细报表:com.kingdee.eas.cp.bc.client.LoanListRptMainUI

费用报销明细报表:com.kingdee.eas.cp.bc.client.BizListRptMainUI

申请单统计报表:com.kingdee.eas.cp.bc.client.ExpenseReqRpt

借款单统计报表:com.kingdee.eas.cp.bc.client.LoanRpt

报销单统计报表:com.kingdee.eas.cp.bc.client.ExpenseActRpt

备用金余额查:com.kingdee.eas.cp.bc.client.AssistantAccountListUI

2. gui费用单据扩展

2.1. 费用单据列表页扩展增加分录字段

gui扩展时注意：

(1) gui费用报销和费用核算下列表页为不同页面，具体如下表。

(2) gui费用报销和费用核算下列表页，除了还款单外，页面所加载的query，都受CP021(是否在客户端序时簿显示分录明细信息)参数控制。页面加载时，根据该参数动态绑定。CP021为否，就为页面上绑定的query，该query只有单头字段(特别注意：只有单头字段的query不能加任何分录字段，也不能关联上分录表，只能有单头字段)；CP021为是，query为带分录query。所以要根据扩展需求，扩展不同的query。具体可见以上第1节费用报销主要元数据。

以下以扩展费用管理—费用报销—费用报销单序时簿页面，增加分录字段为例说明：

该报销单序时薄页面绑定query为：

单头query: com.kingdee.eas.cp.bc.app.BizAccountQuery (为页面默认绑定query，该query只能有单头字段，不能关联分录表，不能有任何分录字段)
带分录query: com.kingdee.eas.cp.bc.app.BizAccountWithEntryQuery (cp021为是，页面加载时动态绑定该query)

1.如果只是扩展增加单头字段，只需要这两个query上增加需要扩展的单头字段即可。

2.如果需要增加分录字段，需要做一些特殊处理。以下以增加字段entries.exchangeRate(分录汇率)、entries.convertmode(分录汇率折算方式)、entries.name(分录名称)说明：

（1）在BizAccountQuery中增加分录及分录字段，分录命名需要用entries

（2）在BizAccountWithEntryQuery中增加分录字段，注意该query本身有分录字段，所以只需要增加没有的分录字段即可。

（3）在报销单序时簿页面增加分录字段，并和query相应字段绑定

绑定字段后

（4）重要：将BizAccountQuery中加的所有分录、及分录字段都去掉，该query不允许有分录字段。去掉不会影响之前页面添加的绑定字段。这步必须做，不然会影响cp021为否，页面只显示单头字段时的单据显示及单头金额合计的计算。

扩展后的页面效果

费用报销常见元数据和query

恭喜您！