OtherBill.kdrs-form 87 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <DocRoot xmlns:c="http://www.kingdee.com/Common" xmlns:f="http://www.kingdee.com/Form" xmlns:t="http://www.kingdee.com/Table" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="4.0">
  3. <DocInfo>
  4. <c:Created>Fri Mar 17 11:00:39 CST 2006</c:Created>
  5. <c:Company>kingdee.com</c:Company>
  6. <c:LastModified>Thu Sep 30 10:14:57 CST 2010</c:LastModified>
  7. <c:Author>null</c:Author>
  8. </DocInfo>
  9. <DataSources version="2.0">
  10. <c:DataSource id="ApOtherBill">
  11. <c:Reference />
  12. <c:Params />
  13. </c:DataSource>
  14. </DataSources>
  15. <DataObjects version="1.0">
  16. <DataObject name="ApOtherBill" alias.zh_CN="ApOtherBill" alias="#1">
  17. <CommonQuery name="ApOtherBill" alias.zh_CN="ApOtherBill" alias="#1">
  18. <Outputs>
  19. <Columns>
  20. <Column name="id" alias.zh_TW="單據唯一標誌" alias.zh_CN="单据唯一标志" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  21. <Column name="CU.name" alias.zh_TW="控制單元" alias.zh_CN="控制单元" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  22. <Column name="company.number" alias.zh_TW="公司編碼" alias.zh_CN="公司编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  23. <Column name="company.name" alias.zh_TW="公司" alias.zh_CN="公司" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  24. <Column name="number" alias.zh_TW="單據編號" alias.zh_CN="单据编号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  25. <Column name="billDate" alias.zh_TW="單據日期" alias.zh_CN="单据日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  26. <Column name="billType" alias.zh_TW="單據類型" alias.zh_CN="单据类型" alias.en="" alias="#1" desc.zh_TW="其他應付或債務轉移" desc.zh_CN="其他应付或债务转移" desc.en="" desc="#1" dataType="string" order="0" />
  27. <Column name="sourceBillType" alias.zh_TW="原單類型" alias.zh_CN="原单类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  28. <Column name="billStatus" alias.zh_TW="單據狀態" alias.zh_CN="单据状态" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  29. <Column name="bizType.name" alias.zh_TW="業務類型" alias.zh_CN="业务类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  30. <Column name="paymentType.name" alias.zh_TW="付款方式" alias.zh_CN="付款方式" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  31. <Column name="bizDate" alias.zh_TW="業務日期" alias.zh_CN="业务日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  32. <Column name="asstActType.number" alias.zh_TW="往來類型編碼" alias.zh_CN="往来类型编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  33. <Column name="asstActType.name" alias.zh_TW="往來類型" alias.zh_CN="往来类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  34. <Column name="asstActNumber" alias.zh_TW="往來戶編號" alias.zh_CN="往来户编号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  35. <Column name="asstActName" alias.zh_TW="往來戶名稱" alias.zh_CN="往来户名称" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  36. <Column name="adminOrgUnit.name" alias.zh_TW="部門" alias.zh_CN="部门" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  37. <Column name="purOrg.number" alias.zh_TW="採購組織編碼" alias.zh_CN="采购组织编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  38. <Column name="purOrg.name" alias.zh_TW="採購組織" alias.zh_CN="采购组织" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  39. <Column name="purchaseGroup.number" alias.zh_TW="採購組編碼" alias.zh_CN="采购组编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  40. <Column name="purchaseGroup.name" alias.zh_TW="採購組" alias.zh_CN="采购组" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  41. <Column name="currency.number" alias.zh_TW="幣別編碼" alias.zh_CN="币别编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  42. <Column name="currency.name" alias.zh_TW="幣別" alias.zh_CN="币别" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  43. <Column name="exchangeRate" alias.zh_TW="匯率" alias.zh_CN="汇率" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  44. <Column name="abstractName" alias.zh_TW="摘要" alias.zh_CN="摘要" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  45. <Column name="cashDiscount.number" alias.zh_TW="現金折扣編碼" alias.zh_CN="现金折扣编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  46. <Column name="cashDiscount.name" alias.zh_TW="現金折扣" alias.zh_CN="现金折扣" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  47. <Column name="settleType.number" alias.zh_TW="結算方式編碼" alias.zh_CN="结算方式编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  48. <Column name="settleType.name" alias.zh_TW="結算方式" alias.zh_CN="结算方式" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  49. <Column name="redBlueType" alias.zh_TW="是否紅字發票" alias.zh_CN="是否红字发票" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  50. <Column name="isReversed" alias.zh_TW="是否已被沖銷" alias.zh_CN="是否已被冲销" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  51. <Column name="isReverseBill" alias.zh_TW="是否為沖銷單據" alias.zh_CN="是否为冲销单据" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  52. <Column name="isTransBill" alias.zh_TW="是否轉移生成單據" alias.zh_CN="是否转移生成单据" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  53. <Column name="isInTax" alias.zh_TW="是否含稅" alias.zh_CN="是否含税" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  54. <Column name="isPriceWithoutTax" alias.zh_TW="是否價外稅" alias.zh_CN="是否价外税" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  55. <Column name="isSCMBill" alias.zh_TW="是否物流的單據" alias.zh_CN="是否物流的单据" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  56. <Column name="fiVouchered" alias.zh_TW="是否生成憑證" alias.zh_CN="是否生成凭证" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  57. <Column name="voucherNumber" alias.zh_TW="憑證" alias.zh_CN="凭证" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  58. <Column name="amount" alias.zh_TW="應付金額" alias.zh_CN="应付金额" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  59. <Column name="amountLocal" alias.zh_TW="應付金額本位幣" alias.zh_CN="应付金额本位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  60. <Column name="verifyAmount" alias.zh_TW="已結算金額" alias.zh_CN="已结算金额" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  61. <Column name="verifyAmountLocal" alias.zh_TW="已結算金額本位幣" alias.zh_CN="已结算金额本位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  62. <Column name="unVerifyAmount" alias.zh_TW="未結算金額" alias.zh_CN="未结算金额" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  63. <Column name="unVerifyAmountLocal" alias.zh_TW="未結算金額本位幣" alias.zh_CN="未结算金额本位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  64. <Column name="totalAmount" alias.zh_TW="金額合計" alias.zh_CN="金额合计" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  65. <Column name="totalTax" alias.zh_TW="稅額合計" alias.zh_CN="税额合计" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  66. <Column name="totalTaxAmount" alias.zh_TW="價稅合計" alias.zh_CN="价税合计" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  67. <Column name="creator.name" alias.zh_TW="制單人" alias.zh_CN="制单人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  68. <Column name="createTime" alias.zh_TW="制單日期" alias.zh_CN="制单日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  69. <Column name="auditor.name" alias.zh_TW="審核人" alias.zh_CN="审核人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  70. <Column name="auditDate" alias.zh_TW="審核日期" alias.zh_CN="审核日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  71. <Column name="accountant.name" alias.zh_TW="記賬" alias.zh_CN="记账" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  72. <Column name="lastUpdateUser.name" alias.zh_TW="最後修改人" alias.zh_CN="最后修改人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  73. <Column name="lastUpdateTime" alias.zh_TW="最後修改時間" alias.zh_CN="最后修改时间" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  74. <Column name="description" alias.zh_TW="參考信息" alias.zh_CN="参考信息" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  75. <Column name="showMaterial" alias.zh_TW="是否顯示物料" alias.zh_CN="是否显示物料" alias.en="" alias="#1" desc.zh_TW="根據原單類型確定是顯示物料或者是費用項目" desc.zh_CN="根据原单类型确定是显示物料或者是费用项目" desc.en="" desc="#1" dataType="string" order="0" />
  76. <Column name="entry.id" alias.zh_TW="單據分錄ID_體" alias.zh_CN="单据分录ID_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  77. <Column name="entry.seq" alias.zh_TW="單據分錄序列號_體" alias.zh_CN="单据分录序列号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  78. <Column name="material.number" alias.zh_TW="物料編碼_體" alias.zh_CN="物料编码_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  79. <Column name="material.name" alias.zh_TW="物料名稱_體" alias.zh_CN="物料名称_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  80. <Column name="material.model" alias.zh_TW="規格型號_體" alias.zh_CN="规格型号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  81. <Column name="measureUnit.name" alias.zh_TW="計量單位_體" alias.zh_CN="计量单位_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  82. <Column name="expenseItem.number" alias.zh_TW="費用項目編碼_體" alias.zh_CN="费用项目编码_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  83. <Column name="expenseItem.name" alias.zh_TW="費用項目名稱_體" alias.zh_CN="费用项目名称_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  84. <Column name="coreBillType.name" alias.zh_TW="核心單據類型_體" alias.zh_CN="核心单据类型_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  85. <Column name="entry.coreBillNumber" alias.zh_TW="核心單據編號_體" alias.zh_CN="核心单据编号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  86. <Column name="entry.coreBillEntrySeq" alias.zh_TW="核心單據分錄行號_體" alias.zh_CN="核心单据分录行号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  87. <Column name="entry.quantity" alias.zh_TW="數量_體" alias.zh_CN="数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  88. <Column name="entry.price" alias.zh_TW="單價_體" alias.zh_CN="单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  89. <Column name="entry.realPrice" alias.zh_TW="實際單價_體" alias.zh_CN="实际单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  90. <Column name="entry.taxPrice" alias.zh_TW="含稅單價_體" alias.zh_CN="含税单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  91. <Column name="entry.actualPrice" alias.zh_TW="實際含稅單價_體" alias.zh_CN="实际含税单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  92. <Column name="entry.discountType" alias.zh_TW="折扣方式_體" alias.zh_CN="折扣方式_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  93. <Column name="entry.taxRate" alias.zh_TW="稅率_體" alias.zh_CN="税率_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  94. <Column name="entry.taxAmount" alias.zh_TW="稅額_體" alias.zh_CN="税额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  95. <Column name="entry.taxAmountLocal" alias.zh_TW="稅額本位幣_體" alias.zh_CN="税额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  96. <Column name="entry.discountRate" alias.zh_TW="折扣率_體" alias.zh_CN="折扣率_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  97. <Column name="entry.discountAmount" alias.zh_TW="折扣額_體" alias.zh_CN="折扣额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  98. <Column name="entry.discountAmountLocal" alias.zh_TW="折扣額本位幣_體" alias.zh_CN="折扣额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  99. <Column name="entry.amount" alias.zh_TW="金額_體" alias.zh_CN="金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  100. <Column name="entry.amountLocal" alias.zh_TW="金額本位幣_體" alias.zh_CN="金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  101. <Column name="account.name" alias.zh_TW="科目_體" alias.zh_CN="科目_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  102. <Column name="oppAccount.name" alias.zh_TW="對方科目_體" alias.zh_CN="对方科目_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  103. <Column name="entry.recievePayAmount" alias.zh_TW="應付金額_體" alias.zh_CN="应付金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  104. <Column name="entry.recievePayAmountLocal" alias.zh_TW="應付金額本位幣_體" alias.zh_CN="应付金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  105. <Column name="entry.verifyAmount" alias.zh_TW="已核結算額_體" alias.zh_CN="已核结算额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  106. <Column name="entry.verifyAmountLocal" alias.zh_TW="已核結算額本位幣_體" alias.zh_CN="已核结算额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  107. <Column name="entry.unVerifyAmount" alias.zh_TW="未核結算額_體" alias.zh_CN="未核结算额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  108. <Column name="entry.unVerifyAmountLocal" alias.zh_TW="未核結算金本位幣_體" alias.zh_CN="未核结算金本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  109. <Column name="entry.lockVerifyAmt" alias.zh_TW="鎖定金額_體" alias.zh_CN="锁定金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  110. <Column name="entry.lockVerifyAmtLocal" alias.zh_TW="鎖定金額本位幣_體" alias.zh_CN="锁定金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  111. <Column name="entry.lockUnVerifyAmt" alias.zh_TW="未鎖定金額_體" alias.zh_CN="未锁定金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  112. <Column name="entry.lockUnVerifyAmtLocal" alias.zh_TW="未鎖定金額本位幣_體" alias.zh_CN="未锁定金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  113. <Column name="entry.assistQty" alias.zh_TW="輔助數量_體" alias.zh_CN="辅助数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  114. <Column name="entry.baseQty" alias.zh_TW="基本計量單位數量_體" alias.zh_CN="基本计量单位数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  115. <Column name="entry.hisUnVerifyAmount" alias.zh_TW="歷史未核銷金額_體" alias.zh_CN="历史未核销金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  116. <Column name="entry.hisUnVerifyAmountLocal" alias.zh_TW="歷史未核銷金額本_體位幣" alias.zh_CN="历史未核销金额本_体位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  117. <Column name="entry.wittenOffBaseQty" alias.zh_TW="已核銷基本數量_體" alias.zh_CN="已核销基本数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  118. <Column name="entry.localWrittenOffAmount" alias.zh_TW="已核銷本位幣金額_體" alias.zh_CN="已核销本位币金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  119. <Column name="entry.unwriteOffBaseQty" alias.zh_TW="未核銷基本數量_體" alias.zh_CN="未核销基本数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  120. <Column name="entry.localUnwriteOffAmount" alias.zh_TW="未核銷本位幣金額_體" alias.zh_CN="未核销本位币金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  121. <Column name="entry.invoiceNumber" alias.zh_TW="發票編號_體" alias.zh_CN="发票编号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  122. <Column name="entry.invoicedBaseQty" alias.zh_TW="已開發票基本數量_體" alias.zh_CN="已开发票基本数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  123. <Column name="entry.invoicedAmt" alias.zh_TW="已開發票金額_體" alias.zh_CN="已开发票金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  124. <Column name="entry.isInvoiced" alias.zh_TW="是否已開完票_體" alias.zh_CN="是否已开完票_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  125. <Column name="entry.trackNumber" alias.zh_TW="跟蹤號_體" alias.zh_CN="跟踪号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  126. <Column name="entry.remark" alias.zh_TW="備註_體" alias.zh_CN="备注_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  127. <Column name="person.name" alias.zh_TW="採購員" alias.zh_CN="采购员" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  128. </Columns>
  129. </Outputs>
  130. <Query version="1.0" type="bos.query">
  131. <Columns>
  132. <Column name="id" alias.zh_TW="單據唯一標誌" alias.zh_CN="单据唯一标志" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  133. <Column name="CU.name" alias.zh_TW="控制單元" alias.zh_CN="控制单元" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  134. <Column name="company.number" alias.zh_TW="公司編碼" alias.zh_CN="公司编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  135. <Column name="company.name" alias.zh_TW="公司" alias.zh_CN="公司" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  136. <Column name="number" alias.zh_TW="單據編號" alias.zh_CN="单据编号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  137. <Column name="billDate" alias.zh_TW="單據日期" alias.zh_CN="单据日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  138. <Column name="billType" alias.zh_TW="單據類型" alias.zh_CN="单据类型" alias.en="" alias="#1" desc.zh_TW="其他應付或債務轉移" desc.zh_CN="其他应付或债务转移" desc.en="" desc="#1" dataType="string" />
  139. <Column name="sourceBillType" alias.zh_TW="原單類型" alias.zh_CN="原单类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  140. <Column name="billStatus" alias.zh_TW="單據狀態" alias.zh_CN="单据状态" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  141. <Column name="bizType.name" alias.zh_TW="業務類型" alias.zh_CN="业务类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  142. <Column name="paymentType.name" alias.zh_TW="付款方式" alias.zh_CN="付款方式" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  143. <Column name="bizDate" alias.zh_TW="業務日期" alias.zh_CN="业务日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  144. <Column name="asstActType.number" alias.zh_TW="往來類型編碼" alias.zh_CN="往来类型编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  145. <Column name="asstActType.name" alias.zh_TW="往來類型" alias.zh_CN="往来类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  146. <Column name="asstActNumber" alias.zh_TW="往來戶編號" alias.zh_CN="往来户编号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  147. <Column name="asstActName" alias.zh_TW="往來戶名稱" alias.zh_CN="往来户名称" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  148. <Column name="adminOrgUnit.name" alias.zh_TW="部門" alias.zh_CN="部门" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  149. <Column name="purOrg.number" alias.zh_TW="採購組織編碼" alias.zh_CN="采购组织编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  150. <Column name="purOrg.name" alias.zh_TW="採購組織" alias.zh_CN="采购组织" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  151. <Column name="purchaseGroup.number" alias.zh_TW="採購組編碼" alias.zh_CN="采购组编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  152. <Column name="purchaseGroup.name" alias.zh_TW="採購組" alias.zh_CN="采购组" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  153. <Column name="currency.number" alias.zh_TW="幣別編碼" alias.zh_CN="币别编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  154. <Column name="currency.name" alias.zh_TW="幣別" alias.zh_CN="币别" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  155. <Column name="exchangeRate" alias.zh_TW="匯率" alias.zh_CN="汇率" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  156. <Column name="abstractName" alias.zh_TW="摘要" alias.zh_CN="摘要" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  157. <Column name="cashDiscount.number" alias.zh_TW="現金折扣編碼" alias.zh_CN="现金折扣编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  158. <Column name="cashDiscount.name" alias.zh_TW="現金折扣" alias.zh_CN="现金折扣" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  159. <Column name="settleType.number" alias.zh_TW="結算方式編碼" alias.zh_CN="结算方式编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  160. <Column name="settleType.name" alias.zh_TW="結算方式" alias.zh_CN="结算方式" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  161. <Column name="redBlueType" alias.zh_TW="是否紅字發票" alias.zh_CN="是否红字发票" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  162. <Column name="isReversed" alias.zh_TW="是否已被沖銷" alias.zh_CN="是否已被冲销" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  163. <Column name="isReverseBill" alias.zh_TW="是否為沖銷單據" alias.zh_CN="是否为冲销单据" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  164. <Column name="isTransBill" alias.zh_TW="是否轉移生成單據" alias.zh_CN="是否转移生成单据" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  165. <Column name="isInTax" alias.zh_TW="是否含稅" alias.zh_CN="是否含税" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  166. <Column name="isPriceWithoutTax" alias.zh_TW="是否價外稅" alias.zh_CN="是否价外税" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  167. <Column name="isSCMBill" alias.zh_TW="是否物流的單據" alias.zh_CN="是否物流的单据" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  168. <Column name="fiVouchered" alias.zh_TW="是否生成憑證" alias.zh_CN="是否生成凭证" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  169. <Column name="voucherNumber" alias.zh_TW="憑證" alias.zh_CN="凭证" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  170. <Column name="amount" alias.zh_TW="應付金額" alias.zh_CN="应付金额" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  171. <Column name="amountLocal" alias.zh_TW="應付金額本位幣" alias.zh_CN="应付金额本位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  172. <Column name="verifyAmount" alias.zh_TW="已結算金額" alias.zh_CN="已结算金额" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  173. <Column name="verifyAmountLocal" alias.zh_TW="已結算金額本位幣" alias.zh_CN="已结算金额本位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  174. <Column name="unVerifyAmount" alias.zh_TW="未結算金額" alias.zh_CN="未结算金额" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  175. <Column name="unVerifyAmountLocal" alias.zh_TW="未結算金額本位幣" alias.zh_CN="未结算金额本位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  176. <Column name="totalAmount" alias.zh_TW="金額合計" alias.zh_CN="金额合计" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  177. <Column name="totalTax" alias.zh_TW="稅額合計" alias.zh_CN="税额合计" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  178. <Column name="totalTaxAmount" alias.zh_TW="價稅合計" alias.zh_CN="价税合计" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  179. <Column name="creator.name" alias.zh_TW="制單人" alias.zh_CN="制单人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  180. <Column name="createTime" alias.zh_TW="制單日期" alias.zh_CN="制单日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  181. <Column name="auditor.name" alias.zh_TW="審核人" alias.zh_CN="审核人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  182. <Column name="auditDate" alias.zh_TW="審核日期" alias.zh_CN="审核日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  183. <Column name="accountant.name" alias.zh_TW="記賬" alias.zh_CN="记账" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  184. <Column name="lastUpdateUser.name" alias.zh_TW="最後修改人" alias.zh_CN="最后修改人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  185. <Column name="lastUpdateTime" alias.zh_TW="最後修改時間" alias.zh_CN="最后修改时间" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  186. <Column name="description" alias.zh_TW="參考信息" alias.zh_CN="参考信息" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  187. <Column name="showMaterial" alias.zh_TW="是否顯示物料" alias.zh_CN="是否显示物料" alias.en="" alias="#1" desc.zh_TW="根據原單類型確定是顯示物料或者是費用項目" desc.zh_CN="根据原单类型确定是显示物料或者是费用项目" desc.en="" desc="#1" dataType="string" />
  188. <Column name="entry.id" alias.zh_TW="單據分錄ID_體" alias.zh_CN="单据分录ID_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  189. <Column name="entry.seq" alias.zh_TW="單據分錄序列號_體" alias.zh_CN="单据分录序列号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  190. <Column name="material.number" alias.zh_TW="物料編碼_體" alias.zh_CN="物料编码_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  191. <Column name="material.name" alias.zh_TW="物料名稱_體" alias.zh_CN="物料名称_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  192. <Column name="material.model" alias.zh_TW="規格型號_體" alias.zh_CN="规格型号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  193. <Column name="measureUnit.name" alias.zh_TW="計量單位_體" alias.zh_CN="计量单位_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  194. <Column name="expenseItem.number" alias.zh_TW="費用項目編碼_體" alias.zh_CN="费用项目编码_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  195. <Column name="expenseItem.name" alias.zh_TW="費用項目名稱_體" alias.zh_CN="费用项目名称_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  196. <Column name="coreBillType.name" alias.zh_TW="核心單據類型_體" alias.zh_CN="核心单据类型_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  197. <Column name="entry.coreBillNumber" alias.zh_TW="核心單據編號_體" alias.zh_CN="核心单据编号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  198. <Column name="entry.coreBillEntrySeq" alias.zh_TW="核心單據分錄行號_體" alias.zh_CN="核心单据分录行号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  199. <Column name="entry.quantity" alias.zh_TW="數量_體" alias.zh_CN="数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  200. <Column name="entry.price" alias.zh_TW="單價_體" alias.zh_CN="单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  201. <Column name="entry.realPrice" alias.zh_TW="實際單價_體" alias.zh_CN="实际单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  202. <Column name="entry.taxPrice" alias.zh_TW="含稅單價_體" alias.zh_CN="含税单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  203. <Column name="entry.actualPrice" alias.zh_TW="實際含稅單價_體" alias.zh_CN="实际含税单价_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  204. <Column name="entry.discountType" alias.zh_TW="折扣方式_體" alias.zh_CN="折扣方式_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  205. <Column name="entry.taxRate" alias.zh_TW="稅率_體" alias.zh_CN="税率_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  206. <Column name="entry.taxAmount" alias.zh_TW="稅額_體" alias.zh_CN="税额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  207. <Column name="entry.taxAmountLocal" alias.zh_TW="稅額本位幣_體" alias.zh_CN="税额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  208. <Column name="entry.discountRate" alias.zh_TW="折扣率_體" alias.zh_CN="折扣率_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  209. <Column name="entry.discountAmount" alias.zh_TW="折扣額_體" alias.zh_CN="折扣额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  210. <Column name="entry.discountAmountLocal" alias.zh_TW="折扣額本位幣_體" alias.zh_CN="折扣额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  211. <Column name="entry.amount" alias.zh_TW="金額_體" alias.zh_CN="金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  212. <Column name="entry.amountLocal" alias.zh_TW="金額本位幣_體" alias.zh_CN="金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  213. <Column name="account.name" alias.zh_TW="科目_體" alias.zh_CN="科目_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  214. <Column name="oppAccount.name" alias.zh_TW="對方科目_體" alias.zh_CN="对方科目_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  215. <Column name="entry.recievePayAmount" alias.zh_TW="應付金額_體" alias.zh_CN="应付金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  216. <Column name="entry.recievePayAmountLocal" alias.zh_TW="應付金額本位幣_體" alias.zh_CN="应付金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  217. <Column name="entry.verifyAmount" alias.zh_TW="已核結算額_體" alias.zh_CN="已核结算额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  218. <Column name="entry.verifyAmountLocal" alias.zh_TW="已核結算額本位幣_體" alias.zh_CN="已核结算额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  219. <Column name="entry.unVerifyAmount" alias.zh_TW="未核結算額_體" alias.zh_CN="未核结算额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  220. <Column name="entry.unVerifyAmountLocal" alias.zh_TW="未核結算金本位幣_體" alias.zh_CN="未核结算金本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  221. <Column name="entry.lockVerifyAmt" alias.zh_TW="鎖定金額_體" alias.zh_CN="锁定金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  222. <Column name="entry.lockVerifyAmtLocal" alias.zh_TW="鎖定金額本位幣_體" alias.zh_CN="锁定金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  223. <Column name="entry.lockUnVerifyAmt" alias.zh_TW="未鎖定金額_體" alias.zh_CN="未锁定金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  224. <Column name="entry.lockUnVerifyAmtLocal" alias.zh_TW="未鎖定金額本位幣_體" alias.zh_CN="未锁定金额本位币_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  225. <Column name="entry.assistQty" alias.zh_TW="輔助數量_體" alias.zh_CN="辅助数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  226. <Column name="entry.baseQty" alias.zh_TW="基本計量單位數量_體" alias.zh_CN="基本计量单位数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  227. <Column name="entry.hisUnVerifyAmount" alias.zh_TW="歷史未核銷金額_體" alias.zh_CN="历史未核销金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  228. <Column name="entry.hisUnVerifyAmountLocal" alias.zh_TW="歷史未核銷金額本_體位幣" alias.zh_CN="历史未核销金额本_体位币" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  229. <Column name="entry.wittenOffBaseQty" alias.zh_TW="已核銷基本數量_體" alias.zh_CN="已核销基本数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  230. <Column name="entry.localWrittenOffAmount" alias.zh_TW="已核銷本位幣金額_體" alias.zh_CN="已核销本位币金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  231. <Column name="entry.unwriteOffBaseQty" alias.zh_TW="未核銷基本數量_體" alias.zh_CN="未核销基本数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  232. <Column name="entry.localUnwriteOffAmount" alias.zh_TW="未核銷本位幣金額_體" alias.zh_CN="未核销本位币金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  233. <Column name="entry.invoiceNumber" alias.zh_TW="發票編號_體" alias.zh_CN="发票编号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  234. <Column name="entry.invoicedBaseQty" alias.zh_TW="已開發票基本數量_體" alias.zh_CN="已开发票基本数量_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  235. <Column name="entry.invoicedAmt" alias.zh_TW="已開發票金額_體" alias.zh_CN="已开发票金额_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  236. <Column name="entry.isInvoiced" alias.zh_TW="是否已開完票_體" alias.zh_CN="是否已开完票_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  237. <Column name="entry.trackNumber" alias.zh_TW="跟蹤號_體" alias.zh_CN="跟踪号_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  238. <Column name="entry.remark" alias.zh_TW="備註_體" alias.zh_CN="备注_体" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  239. <Column name="person.name" alias.zh_TW="採購員" alias.zh_CN="采购员" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  240. </Columns>
  241. <Tables />
  242. <Joins />
  243. <Orders />
  244. <Filter />
  245. <Content><![CDATA[OtherBill.bos-query]]></Content>
  246. </Query>
  247. <EXT />
  248. </CommonQuery>
  249. </DataObject>
  250. </DataObjects>
  251. <Styles version="1.0">
  252. <c:Style id="3">
  253. <c:Font fontName="宋体" size="16" color="#000000" bold="true" underline="false" italic="false" strikethrough="false" weight="400.0" />
  254. <c:Borders>
  255. <c:Border position="left" lineStyle="NullLine" />
  256. <c:Border position="top" lineStyle="NullLine" />
  257. <c:Border position="right" lineStyle="NullLine" />
  258. <c:Border position="bottom" lineStyle="NullLine" />
  259. <c:Border position="diagonalleft" lineStyle="NullLine" />
  260. <c:Border position="diagonalright" lineStyle="NullLine" />
  261. </c:Borders>
  262. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  263. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  264. <c:Protection hidden="false" locked="false" />
  265. </c:Style>
  266. <c:Style id="2">
  267. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  268. <c:Borders>
  269. <c:Border position="left" lineStyle="NullLine" />
  270. <c:Border position="top" lineStyle="NullLine" />
  271. <c:Border position="right" lineStyle="NullLine" />
  272. <c:Border position="bottom" lineStyle="NullLine" />
  273. <c:Border position="diagonalleft" lineStyle="NullLine" />
  274. <c:Border position="diagonalright" lineStyle="NullLine" />
  275. </c:Borders>
  276. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  277. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  278. <c:Protection hidden="false" locked="false" />
  279. </c:Style>
  280. <c:Style id="1">
  281. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  282. <c:Borders>
  283. <c:Border position="left" lineStyle="NullLine" />
  284. <c:Border position="top" lineStyle="NullLine" />
  285. <c:Border position="right" lineStyle="NullLine" />
  286. <c:Border position="bottom" lineStyle="NullLine" />
  287. <c:Border position="diagonalleft" lineStyle="NullLine" />
  288. <c:Border position="diagonalright" lineStyle="NullLine" />
  289. </c:Borders>
  290. <c:Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  291. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  292. <c:Protection hidden="false" locked="false" />
  293. </c:Style>
  294. <c:Style id="0">
  295. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  296. </c:Style>
  297. <c:Style id="7">
  298. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  299. <c:Borders>
  300. <c:Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  301. <c:Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  302. <c:Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  303. <c:Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  304. <c:Border position="diagonalleft" lineStyle="NullLine" />
  305. <c:Border position="diagonalright" lineStyle="NullLine" />
  306. </c:Borders>
  307. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  308. <c:Alignment horizontal="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  309. <c:Protection hidden="false" locked="false" />
  310. </c:Style>
  311. <c:Style id="6">
  312. <c:Font color="#000000" />
  313. <c:Borders>
  314. <c:Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  315. <c:Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  316. <c:Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  317. <c:Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  318. </c:Borders>
  319. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  320. </c:Style>
  321. <c:Style id="5">
  322. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  323. <c:Borders>
  324. <c:Border position="left" lineStyle="NullLine" />
  325. <c:Border position="top" lineStyle="NullLine" />
  326. <c:Border position="right" lineStyle="NullLine" />
  327. <c:Border position="bottom" lineStyle="NullLine" />
  328. <c:Border position="diagonalleft" lineStyle="NullLine" />
  329. <c:Border position="diagonalright" lineStyle="NullLine" />
  330. </c:Borders>
  331. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  332. <c:Alignment horizontal="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  333. <c:Protection hidden="false" locked="false" />
  334. </c:Style>
  335. <c:Style id="4">
  336. <c:Font fontName="宋体" size="9" color="#ffffff" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  337. <c:Borders>
  338. <c:Border position="left" lineStyle="NullLine" />
  339. <c:Border position="top" lineStyle="NullLine" />
  340. <c:Border position="right" lineStyle="NullLine" />
  341. <c:Border position="bottom" lineStyle="NullLine" />
  342. <c:Border position="diagonalleft" lineStyle="NullLine" />
  343. <c:Border position="diagonalright" lineStyle="NullLine" />
  344. </c:Borders>
  345. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  346. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  347. <c:Protection hidden="false" locked="false" />
  348. </c:Style>
  349. <c:Style id="8">
  350. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  351. <c:Borders>
  352. <c:Border position="left" lineStyle="NullLine" />
  353. <c:Border position="top" lineStyle="NullLine" />
  354. <c:Border position="right" lineStyle="NullLine" />
  355. <c:Border position="bottom" lineStyle="NullLine" />
  356. <c:Border position="diagonalleft" lineStyle="NullLine" />
  357. <c:Border position="diagonalright" lineStyle="NullLine" />
  358. </c:Borders>
  359. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  360. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  361. <c:Protection hidden="false" locked="false" />
  362. </c:Style>
  363. </Styles>
  364. <Headers />
  365. <Footers />
  366. <Form id="form1" alias="ApOtherBill" version="3.1">
  367. <f:Page id="page1" alias="页1" styleID="0" repeat="-1" dataSourceID="ApOtherBill">
  368. <f:DesignedPage paperSize="iso-a4" objWidth="1720" objHeight="2470" widthLimitless="false" heightLimitless="false" />
  369. <f:Area id="loop1" alias="循环区1" styleID="1" left="[page1.left]" right="[loop1.left]+1720.0" top="[page1.top]+13.0" bottom="[loop1.top]+2457.0" nextAreaID="loop1">
  370. <f:DesignedArea leftLocationType="relative" leftRelativeObjID="page1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop1" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="page1" topRelativeBorder="top" topRelativeOffset="13" bottomLocationType="relative" bottomRelativeObjID="loop1" bottomRelativeBorder="top" bottomRelativeOffset="2457" locked="false" />
  371. <f:Panel id="group1" alias="分组容器1" styleID="2" left="[loop1.left]" right="[group1.left]+1720.0" top="[loop1.top]" bottom="[group1.top]+2457.0" dataSourceID="ApOtherBill">
  372. <f:DesignedPanel leftLocationType="relative" leftRelativeObjID="loop1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="loop1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="top" bottomRelativeOffset="2457" locked="false" />
  373. <f:Cell id="text1" alias="title" styleID="3" left="[group1.left]+486.0" right="[text1.left]+538.0" top="[group1.top]" bottom="[text1.top]+151.0" type="constant">
  374. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="486" rightLocationType="relative" rightRelativeObjID="text1" rightRelativeBorder="left" rightRelativeOffset="538" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="text1" bottomRelativeBorder="top" bottomRelativeOffset="151" locked="false" />
  375. <f:Data type="string">应付单</f:Data>
  376. </f:Cell>
  377. <f:Cell id="field26" alias="fShowMaterial" styleID="4" left="[group1.left]+760.0" right="[field26.left]+161.0" top="[group1.top]+67.0" bottom="[field26.top]+50.0" postMacro="$SET(&quot;showMaterial&quot;, $GETOUTPUTVALUE(&quot;text&quot;));" priority="1" type="field">
  378. <f:DesignedCell text="是否显示物料" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="760" rightLocationType="relative" rightRelativeObjID="field26" rightRelativeBorder="left" rightRelativeOffset="161" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="67" bottomLocationType="relative" bottomRelativeObjID="field26" bottomRelativeBorder="top" bottomRelativeOffset="50" locked="false" />
  379. <f:Data type="string">showMaterial</f:Data>
  380. </f:Cell>
  381. <f:Table id="table1" alias="网格容器1" left="[group1.left]" right="[table1.left]+1720.0" top="[group1.top]+151.0" bottom="[table1.top]+417.0" dataSourceID="ApOtherBill">
  382. <f:DesignedTable layout="auto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table1" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="151" bottomLocationType="relative" bottomRelativeObjID="table1" bottomRelativeBorder="top" bottomRelativeOffset="417" locked="false" />
  383. <f:Rows>
  384. <f:Row />
  385. <f:Row />
  386. <f:Row />
  387. <f:Row />
  388. <f:Row />
  389. <f:Row />
  390. </f:Rows>
  391. <f:Columns>
  392. <f:Column />
  393. <f:Column />
  394. <f:Column />
  395. <f:Column />
  396. <f:Column />
  397. <f:Column />
  398. </f:Columns>
  399. <f:Body>
  400. <f:Cell id="text2" alias="文本2" styleID="5" left="1" right="1" top="1" bottom="1" type="constant">
  401. <f:DesignedCell locked="false" />
  402. <f:Data type="string">公司</f:Data>
  403. </f:Cell>
  404. <f:Cell id="field1" alias="字段1" styleID="5" left="2" right="2" top="1" bottom="1" type="field">
  405. <f:DesignedCell text="公司" locked="false" />
  406. <f:Data type="string">company.name</f:Data>
  407. </f:Cell>
  408. <f:Cell id="text7" alias="文本7" styleID="5" left="3" right="3" top="1" bottom="1" type="constant">
  409. <f:DesignedCell locked="false" />
  410. <f:Data type="string">单据编号</f:Data>
  411. </f:Cell>
  412. <f:Cell id="field2" alias="字段2" styleID="5" left="4" right="4" top="1" bottom="1" type="field">
  413. <f:DesignedCell text="单据编号" locked="false" />
  414. <f:Data type="string">number</f:Data>
  415. </f:Cell>
  416. <f:Cell id="text12" alias="文本12" styleID="5" left="5" right="5" top="1" bottom="1" type="constant">
  417. <f:DesignedCell locked="false" />
  418. <f:Data type="string">单据日期</f:Data>
  419. </f:Cell>
  420. <f:Cell id="field3" alias="字段3" styleID="5" left="6" right="6" top="1" bottom="1" type="field">
  421. <f:DesignedCell text="单据日期" locked="false" />
  422. <f:Data type="string">billDate</f:Data>
  423. </f:Cell>
  424. <f:Cell id="text3" alias="文本3" styleID="5" left="1" right="1" top="2" bottom="2" type="constant">
  425. <f:DesignedCell locked="false" />
  426. <f:Data type="string">单据类型</f:Data>
  427. </f:Cell>
  428. <f:Cell id="field4" alias="字段4" styleID="5" left="2" right="2" top="2" bottom="2" type="field">
  429. <f:DesignedCell text="单据类型" locked="false" />
  430. <f:Data type="string">billType</f:Data>
  431. </f:Cell>
  432. <f:Cell id="text8" alias="文本8" styleID="5" left="3" right="3" top="2" bottom="2" type="constant">
  433. <f:DesignedCell locked="false" />
  434. <f:Data type="string">原单类型</f:Data>
  435. </f:Cell>
  436. <f:Cell id="field5" alias="字段5" styleID="5" left="4" right="4" top="2" bottom="2" postMacro="$SET(&quot;srcType&quot;, $TONUMBER($GETOUTPUTVALUE(&quot;value&quot;)));$SET(&quot;hasMaterial&quot;, $IFF($OR($GET(&quot;srcType&quot;) == 9, $GET(&quot;srcType&quot;) == 10), &quot;true&quot;, &quot;false&quot;));" type="field">
  437. <f:DesignedCell text="原单类型" locked="false" />
  438. <f:Data type="string">sourceBillType</f:Data>
  439. </f:Cell>
  440. <f:Cell id="text13" alias="文本13" styleID="5" left="5" right="5" top="2" bottom="2" type="constant">
  441. <f:DesignedCell locked="false" />
  442. <f:Data type="string">单据状态</f:Data>
  443. </f:Cell>
  444. <f:Cell id="field6" alias="字段6" styleID="5" left="6" right="6" top="2" bottom="2" type="field">
  445. <f:DesignedCell text="单据状态" locked="false" />
  446. <f:Data type="string">billStatus</f:Data>
  447. </f:Cell>
  448. <f:Cell id="text4" alias="文本4" styleID="5" left="1" right="1" top="3" bottom="3" type="constant">
  449. <f:DesignedCell locked="false" />
  450. <f:Data type="string">往来类型</f:Data>
  451. </f:Cell>
  452. <f:Cell id="field7" alias="字段7" styleID="5" left="2" right="2" top="3" bottom="3" type="field">
  453. <f:DesignedCell text="往来类型" locked="false" />
  454. <f:Data type="string">asstActType.name</f:Data>
  455. </f:Cell>
  456. <f:Cell id="text9" alias="文本9" styleID="5" left="3" right="3" top="3" bottom="3" type="constant">
  457. <f:DesignedCell locked="false" />
  458. <f:Data type="string">往来户名称</f:Data>
  459. </f:Cell>
  460. <f:Cell id="field8" alias="字段8" styleID="5" left="4" right="4" top="3" bottom="3" type="field">
  461. <f:DesignedCell text="往来户名称" locked="false" />
  462. <f:Data type="string">asstActName</f:Data>
  463. </f:Cell>
  464. <f:Cell id="text14" alias="文本14" styleID="5" left="5" right="5" top="3" bottom="3" type="constant">
  465. <f:DesignedCell locked="false" />
  466. <f:Data type="string">业务日期</f:Data>
  467. </f:Cell>
  468. <f:Cell id="field9" alias="字段9" styleID="5" left="6" right="6" top="3" bottom="3" type="field">
  469. <f:DesignedCell text="业务日期" locked="false" />
  470. <f:Data type="string">bizDate</f:Data>
  471. </f:Cell>
  472. <f:Cell id="text5" alias="文本5" styleID="5" left="1" right="1" top="4" bottom="4" type="constant">
  473. <f:DesignedCell locked="false" />
  474. <f:Data type="string">币别</f:Data>
  475. </f:Cell>
  476. <f:Cell id="field10" alias="字段10" styleID="5" left="2" right="2" top="4" bottom="4" type="field">
  477. <f:DesignedCell text="币别" locked="false" />
  478. <f:Data type="string">currency.name</f:Data>
  479. </f:Cell>
  480. <f:Cell id="text10" alias="文本10" styleID="5" left="3" right="3" top="4" bottom="4" type="constant">
  481. <f:DesignedCell locked="false" />
  482. <f:Data type="string">汇率</f:Data>
  483. </f:Cell>
  484. <f:Cell id="field11" alias="字段11" styleID="5" left="4" right="4" top="4" bottom="4" type="field" format="0.0000;-0.0000">
  485. <f:DesignedCell text="汇率" locked="false" />
  486. <f:Data type="string">exchangeRate</f:Data>
  487. </f:Cell>
  488. <f:Cell id="text15" alias="文本15" styleID="5" left="5" right="5" top="4" bottom="4" type="constant">
  489. <f:DesignedCell locked="false" />
  490. <f:Data type="string">结算方式</f:Data>
  491. </f:Cell>
  492. <f:Cell id="field12" alias="字段12" styleID="5" left="6" right="6" top="4" bottom="4" type="field">
  493. <f:DesignedCell text="结算方式" locked="false" />
  494. <f:Data type="string">settleType.name</f:Data>
  495. </f:Cell>
  496. <f:Cell id="text6" alias="文本6" styleID="5" left="1" right="1" top="5" bottom="5" type="constant">
  497. <f:DesignedCell locked="false" />
  498. <f:Data type="string">应付金额</f:Data>
  499. </f:Cell>
  500. <f:Cell id="field13" alias="字段13" styleID="5" left="2" right="2" top="5" bottom="5" type="field">
  501. <f:DesignedCell text="应付金额" locked="false" />
  502. <f:Data type="string">amount</f:Data>
  503. </f:Cell>
  504. <f:Cell id="text11" alias="文本11" styleID="5" left="3" right="3" top="5" bottom="5" type="constant">
  505. <f:DesignedCell locked="false" />
  506. <f:Data type="string">已结算金额</f:Data>
  507. </f:Cell>
  508. <f:Cell id="field14" alias="字段14" styleID="5" left="4" right="4" top="5" bottom="5" type="field" format="0.0000;-0.0000">
  509. <f:DesignedCell text="已结算金额" locked="false" />
  510. <f:Data type="string">verifyAmount</f:Data>
  511. </f:Cell>
  512. <f:Cell id="text16" alias="文本16" styleID="5" left="5" right="5" top="5" bottom="5" type="constant">
  513. <f:DesignedCell locked="false" />
  514. <f:Data type="string">未结算金额</f:Data>
  515. </f:Cell>
  516. <f:Cell id="field15" alias="字段15" styleID="5" left="6" right="6" top="5" bottom="5" type="field" format="0.0000;-0.0000">
  517. <f:DesignedCell text="未结算金额" locked="false" />
  518. <f:Data type="string">unVerifyAmount</f:Data>
  519. </f:Cell>
  520. <f:Cell id="text27" alias="文本27" styleID="5" left="1" right="1" top="6" bottom="6" type="constant">
  521. <f:DesignedCell locked="false" />
  522. <f:Data type="string">采购组织</f:Data>
  523. </f:Cell>
  524. <f:Cell id="field25" alias="字段25" styleID="5" left="2" right="2" top="6" bottom="6" type="field">
  525. <f:DesignedCell text="采购组织" locked="false" />
  526. <f:Data type="string">purOrg.name</f:Data>
  527. </f:Cell>
  528. <f:Cell id="text28" alias="文本28" styleID="5" left="3" right="3" top="6" bottom="6" type="constant">
  529. <f:DesignedCell locked="false" />
  530. <f:Data type="string">业务员</f:Data>
  531. </f:Cell>
  532. <f:Cell id="field27" alias="字段27" styleID="5" left="4" right="4" top="6" bottom="6" type="field">
  533. <f:DesignedCell text="采购员" locked="false" />
  534. <f:Data type="string">person.name</f:Data>
  535. </f:Cell>
  536. <f:Cell id="text29" alias="文本29" styleID="5" left="5" right="5" top="6" bottom="6" type="constant">
  537. <f:DesignedCell locked="false" />
  538. <f:Data type="string">部门</f:Data>
  539. </f:Cell>
  540. <f:Cell id="field28" alias="字段28" styleID="5" left="6" right="6" top="6" bottom="6" type="field">
  541. <f:DesignedCell text="部门" locked="false" />
  542. <f:Data type="string">adminOrgUnit.name</f:Data>
  543. </f:Cell>
  544. </f:Body>
  545. </f:Table>
  546. <f:Table id="table2" alias="网格容器2" styleID="1" left="[group1.left]" right="[table2.left]+1720.0" top="[group1.top]+566.0" bottom="[table2.top]+56.0" preMacro="$SETVALUE(&quot;columnwidth.0&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 200, 0)); $SETVALUE(&quot;columnwidth.1&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 200, 0)); $SETVALUE(&quot;columnwidth.2&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 0, 200)); $SETVALUE(&quot;columnwidth.3&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 0, 200));" layout="1">
  547. <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table2" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="566" bottomLocationType="relative" bottomRelativeObjID="table2" bottomRelativeBorder="top" bottomRelativeOffset="56" locked="false" />
  548. <f:Rows>
  549. <f:Row height="*" />
  550. </f:Rows>
  551. <f:Columns>
  552. <f:Column width="215" />
  553. <f:Column width="215" />
  554. <f:Column width="215" />
  555. <f:Column width="215" />
  556. <f:Column width="215" />
  557. <f:Column width="215" />
  558. <f:Column width="215" />
  559. <f:Column width="215" />
  560. </f:Columns>
  561. <f:Body>
  562. <f:Cell id="text17" alias="文本17" styleID="6" left="1" right="1" top="1" bottom="1" type="constant">
  563. <f:DesignedCell locked="false" />
  564. <f:Data type="string">物料编码</f:Data>
  565. </f:Cell>
  566. <f:Cell id="text18" alias="文本18" styleID="6" left="2" right="2" top="1" bottom="1" type="constant">
  567. <f:DesignedCell locked="false" />
  568. <f:Data type="string">物料名称</f:Data>
  569. </f:Cell>
  570. <f:Cell id="text19" alias="文本19" styleID="6" left="3" right="3" top="1" bottom="1" type="constant">
  571. <f:DesignedCell locked="false" />
  572. <f:Data type="string">费用项目编码</f:Data>
  573. </f:Cell>
  574. <f:Cell id="text32" alias="文本32" styleID="6" left="4" right="4" top="1" bottom="1" type="constant">
  575. <f:DesignedCell locked="false" />
  576. <f:Data type="string">费用项目名称</f:Data>
  577. </f:Cell>
  578. <f:Cell id="text20" alias="文本20" styleID="6" left="5" right="5" top="1" bottom="1" type="constant">
  579. <f:DesignedCell locked="false" />
  580. <f:Data type="string">应付金额</f:Data>
  581. </f:Cell>
  582. <f:Cell id="text21" alias="文本21" styleID="6" left="6" right="6" top="1" bottom="1" type="constant">
  583. <f:DesignedCell locked="false" />
  584. <f:Data type="string">已结算金额</f:Data>
  585. </f:Cell>
  586. <f:Cell id="text30" alias="文本30" styleID="6" left="7" right="7" top="1" bottom="1" type="constant">
  587. <f:DesignedCell locked="false" />
  588. <f:Data type="string">未结算金额</f:Data>
  589. </f:Cell>
  590. <f:Cell id="text31" alias="文本31" styleID="6" left="8" right="8" top="1" bottom="1" type="constant">
  591. <f:DesignedCell locked="false" />
  592. <f:Data type="string">备注</f:Data>
  593. </f:Cell>
  594. </f:Body>
  595. </f:Table>
  596. <f:Area id="loop2" alias="循环区2" styleID="1" left="[group1.left]" right="[loop2.left]+1720.0" top="[group1.top]+620.0" bottom="[loop2.top]+800.0" nextAreaID="loop2">
  597. <f:DesignedArea leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop2" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="620" bottomLocationType="relative" bottomRelativeObjID="loop2" bottomRelativeBorder="top" bottomRelativeOffset="800" locked="false" />
  598. <f:Table id="table3" alias="网格容器3" styleID="1" left="[loop2.left]" right="[table3.left]+1720.0" top="[loop2.top]" bottom="[table3.top]+58.0" preMacro="$SETVALUE(&quot;columnwidth.0&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 200, 0)); $SETVALUE(&quot;columnwidth.1&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 200, 0)); $SETVALUE(&quot;columnwidth.2&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 0, 200)); $SETVALUE(&quot;columnwidth.3&quot;, $IFF($GET(&quot;showMaterial&quot;) == &quot;true&quot;, 0, 200));" dataSourceID="ApOtherBill" groupField="id" layout="1">
  599. <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="loop2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table3" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="loop2" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="table3" bottomRelativeBorder="top" bottomRelativeOffset="58" locked="false" />
  600. <f:Rows>
  601. <f:Row height="*" />
  602. </f:Rows>
  603. <f:Columns>
  604. <f:Column width="215" />
  605. <f:Column width="215" />
  606. <f:Column width="215" />
  607. <f:Column width="215" />
  608. <f:Column width="215" />
  609. <f:Column width="215" />
  610. <f:Column width="215" />
  611. <f:Column width="215" />
  612. </f:Columns>
  613. <f:Body>
  614. <f:Cell id="field32" alias="字段32" styleID="6" left="1" right="1" top="1" bottom="1" type="field">
  615. <f:DesignedCell text="物料编码_体" locked="false" />
  616. <f:Data type="string">material.number</f:Data>
  617. </f:Cell>
  618. <f:Cell id="field31" alias="字段31" styleID="6" left="2" right="2" top="1" bottom="1" type="field">
  619. <f:DesignedCell text="物料名称_体" locked="false" />
  620. <f:Data type="string">material.name</f:Data>
  621. </f:Cell>
  622. <f:Cell id="field29" alias="字段29" styleID="6" left="3" right="3" top="1" bottom="1" type="field">
  623. <f:DesignedCell text="费用项目编码_体" locked="false" />
  624. <f:Data type="string">expenseItem.number</f:Data>
  625. </f:Cell>
  626. <f:Cell id="field30" alias="字段30" styleID="6" left="4" right="4" top="1" bottom="1" type="field">
  627. <f:DesignedCell text="费用项目名称_体" locked="false" />
  628. <f:Data type="string">expenseItem.name</f:Data>
  629. </f:Cell>
  630. <f:Cell id="field17" alias="字段17" styleID="7" left="5" right="5" top="1" bottom="1" type="field" format="0.0000;-0.0000">
  631. <f:DesignedCell text="应付金额_体" locked="false" />
  632. <f:Data type="string">entry.recievePayAmount</f:Data>
  633. </f:Cell>
  634. <f:Cell id="field18" alias="字段18" styleID="7" left="6" right="6" top="1" bottom="1" type="field" format="0.0000;-0.0000">
  635. <f:DesignedCell text="已核结算额_体" locked="false" />
  636. <f:Data type="string">entry.verifyAmount</f:Data>
  637. </f:Cell>
  638. <f:Cell id="field19" alias="字段19" styleID="7" left="7" right="7" top="1" bottom="1" type="field" format="0.0000;-0.0000">
  639. <f:DesignedCell text="未核结算额_体" locked="false" />
  640. <f:Data type="string">entry.unVerifyAmount</f:Data>
  641. </f:Cell>
  642. <f:Cell id="field20" alias="字段20" styleID="6" left="8" right="8" top="1" bottom="1" type="field">
  643. <f:DesignedCell text="备注_体" locked="false" />
  644. <f:Data type="string">entry.remark</f:Data>
  645. </f:Cell>
  646. </f:Body>
  647. </f:Table>
  648. </f:Area>
  649. <f:Table id="table4" alias="网格容器4" left="[group1.left]" right="[table4.left]+1720.0" top="[loop2.bottom]" bottom="[table4.top]+129.0" priority="2" dataSourceID="ApOtherBill">
  650. <f:DesignedTable layout="auto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table4" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="loop2" topRelativeBorder="bottom" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="table4" bottomRelativeBorder="top" bottomRelativeOffset="129" locked="false" />
  651. <f:Rows>
  652. <f:Row />
  653. <f:Row />
  654. </f:Rows>
  655. <f:Columns>
  656. <f:Column />
  657. <f:Column />
  658. <f:Column />
  659. <f:Column />
  660. <f:Column />
  661. <f:Column />
  662. </f:Columns>
  663. <f:Body>
  664. <f:Cell id="text22" alias="文本22" styleID="5" left="1" right="1" top="1" bottom="1" type="constant">
  665. <f:DesignedCell locked="false" />
  666. <f:Data type="string">制单人</f:Data>
  667. </f:Cell>
  668. <f:Cell id="field21" alias="字段21" styleID="5" left="2" right="2" top="1" bottom="1" type="field">
  669. <f:DesignedCell text="制单人" locked="false" />
  670. <f:Data type="string">creator.name</f:Data>
  671. </f:Cell>
  672. <f:Cell id="text24" alias="文本1" styleID="8" left="3" right="3" top="1" bottom="1" type="constant">
  673. <f:DesignedCell locked="false" />
  674. <f:Data type="string">修改人</f:Data>
  675. </f:Cell>
  676. <f:Cell id="field16" alias="字段16" styleID="8" left="4" right="4" top="1" bottom="1" type="field" format="G/通用格式">
  677. <f:DesignedCell text="最后修改人" locked="false" />
  678. <f:Data type="string">lastUpdateUser.name</f:Data>
  679. </f:Cell>
  680. <f:Cell id="text26" alias="文本26" styleID="5" left="5" right="5" top="1" bottom="1" type="constant">
  681. <f:DesignedCell locked="false" />
  682. <f:Data type="string">审核人</f:Data>
  683. </f:Cell>
  684. <f:Cell id="field23" alias="字段23" styleID="5" left="6" right="6" top="1" bottom="1" type="field">
  685. <f:DesignedCell text="审核人" locked="false" />
  686. <f:Data type="string">auditor.name</f:Data>
  687. </f:Cell>
  688. <f:Cell id="text23" alias="文本23" styleID="5" left="1" right="1" top="2" bottom="2" type="constant">
  689. <f:DesignedCell locked="false" />
  690. <f:Data type="string">制单日期</f:Data>
  691. </f:Cell>
  692. <f:Cell id="field22" alias="字段22" styleID="5" left="2" right="2" top="2" bottom="2" type="field" format="yyyy-m-d">
  693. <f:DesignedCell text="制单日期" locked="false" />
  694. <f:Data type="string">createTime</f:Data>
  695. </f:Cell>
  696. <f:Cell id="text33" alias="文本24" styleID="8" left="3" right="3" top="2" bottom="2" type="constant">
  697. <f:DesignedCell locked="false" />
  698. <f:Data type="string">修改日期</f:Data>
  699. </f:Cell>
  700. <f:Cell id="field33" alias="字段26" styleID="8" left="4" right="4" top="2" bottom="2" type="field" format="yyyy-m-d">
  701. <f:DesignedCell text="最后修改时间" locked="false" />
  702. <f:Data type="string">lastUpdateTime</f:Data>
  703. </f:Cell>
  704. <f:Cell id="text25" alias="文本25" styleID="5" left="5" right="5" top="2" bottom="2" type="constant">
  705. <f:DesignedCell locked="false" />
  706. <f:Data type="string">审核日期</f:Data>
  707. </f:Cell>
  708. <f:Cell id="field24" alias="字段24" styleID="5" left="6" right="6" top="2" bottom="2" type="field">
  709. <f:DesignedCell text="审核日期" locked="false" />
  710. <f:Data type="string">auditDate</f:Data>
  711. </f:Cell>
  712. </f:Body>
  713. </f:Table>
  714. </f:Panel>
  715. </f:Area>
  716. </f:Page>
  717. </Form>
  718. <PrintInfo>
  719. <c:PageSetup>
  720. <c:PageMargin left="190" right="190" top="250" bottom="250" header="80" footer="80" />
  721. <c:Orientation>PORTRAIT</c:Orientation>
  722. <c:PaperSizeName>iso-a4</c:PaperSizeName>
  723. <c:Header height="80" margin="80" />
  724. <c:Footer height="80" margin="80" />
  725. </c:PageSetup>
  726. <c:PrinterSetup />
  727. </PrintInfo>
  728. </DocRoot>