采购订单${FBillHead.FBillTyp${FBillHead.FSupplierId}${FBillHead.FBusines${FBillHead.FPurchaseOrgId}${FBillHead.FBillNo}${FBillHead.FPurchaseDeptId}${FBillHead.FDate}${FBillHead.FPurchaserGroupId}物料编码物料名称采购数量${Group_Begin}${FPOORDERENTRY.FMaterialId}${FPOORDERENTRY.FMaterialName||Group||merge}${Group_End}单据类型:供应商:业务类型:采购组织:单据编号:采购部门:采购日期:采购组:${FPOORDERENTRY.Fqty}说明单据体.订单条款单据体.明细信息子单据体.交货明细子单据体.税务明细单据体.付款计划子单据体.付款计划子单据体子单据体.关联关系表FPOOrderClause:FPOOrderEntry:FEntryDeliveryPlan:FTaxDetailSubEntity:FIinstallment:FOrderActualPaySubEntity:FPOOrderEntry_Link:Excel打印支持按条件过滤单据体数据，类似套打数据表格的“数据源过滤条件”属性，套打数据表格的“数据源过滤条件”也可Excel打印过滤条件支持使用Excel打印关键字进行设置，也支持直接使用SQL语句。例如打印采购订单时，要过滤明细信息单据体中物料编码包含“Excel”的，过滤条件可以定义为${FPOORDERENTRY.FMaterialI特别说明：1、过滤条件必须设置在EntryFilters页签的B列，且必须以“单据体标识:”开头，否则程序将无法正确解析2、请确保过滤条件是符合规则的，否则程序解析时将会报错采购订单PUR_PurchaseOrder常用变量分页之总页数${PageCount}分页之页码${PageNumber}FBillHead版本号${FBillHead.FVersionNo}变更人${FBillHead.FChangerId}${FBillHead.FChangerId.FName}${FBillHead.FChangerId.FUserAccount}${FBillHead.FChangerId.Fsignet}${FBillHead.FChangerId.FFaceImg}变更日期${FBillHead.FChangeDate}变更原因${FBillHead.FChangeReason}变更状态${FBillHead.FChangeStatus}采购部门${FBillHead.FPurchaseDeptId}${FBillHead.FPurchaseDeptId.FName}${FBillHead.FPurchaseDeptId.FNumber}采购日期${FBillHead.FDate}采购员${FBillHead.FPurchaserId}${FBillHead.FPurchaserId.FName}${FBillHead.FPurchaserId.FNumber}采购组${FBillHead.FPurchaserGroupId}${FBillHead.FPurchaserGroupId.FName}${FBillHead.FPurchaserGroupId.FNumber}采购组织${FBillHead.FPurchaseOrgId}${FBillHead.FPurchaseOrgId.FName}${FBillHead.FPurchaseOrgId.FNumber}创建人${FBillHead.FCreatorId}${FBillHead.FCreatorId.FName}${FBillHead.FCreatorId.FUserAccount}采购订单单据头.基本信息变更人_名称变更人_编码变更人_签名图片变更人_人脸采集采购部门_名称采购部门_编码采购员_名称采购员_编码采购组_名称采购组_编码采购组织_名称采购组织_编码创建人_名称创建人_编码${FBillHead.FCreatorId.Fsignet}${FBillHead.FCreatorId.FFaceImg}创建日期${FBillHead.FCreateDate}打印次数${FBillHead.F_AAAA_PrintTimes}单价${FBillHead.F_AAAA_Price}单据编号${FBillHead.FBillNo}单据类型${FBillHead.FBillTypeID}${FBillHead.FBillTypeID.FName}${FBillHead.FBillTypeID.FNumber}对应组织${FBillHead.FCorrespondOrgId}${FBillHead.FCorrespondOrgId.FName}${FBillHead.FCorrespondOrgId.FNumber}供货方${FBillHead.FProviderId}${FBillHead.FProviderId.FName}${FBillHead.FProviderId.FNumber}${FBillHead.FProviderId.F_AAAA_Image}${FBillHead.FProviderId.F_AAAA_ImageFileServer}供货方地址${FBillHead.FProviderAddress}供货方联系人${FBillHead.FProviderContactId}${FBillHead.FProviderContactId.FName}${FBillHead.FProviderContactId.FCONTACTNUMBER}${FBillHead.FProviderContact}供应商${FBillHead.FSupplierId}${FBillHead.FSupplierId.FName}${FBillHead.FSupplierId.FNumber}${FBillHead.FSupplierId.F_AAAA_Image}${FBillHead.FSupplierId.F_AAAA_ImageFileServer}关闭人${FBillHead.FCloserId}${FBillHead.FCloserId.FName}${FBillHead.FCloserId.FUserAccount}${FBillHead.FCloserId.Fsignet}${FBillHead.FCloserId.FFaceImg}关闭日期${FBillHead.FCloseDate}结算方${FBillHead.FSettleId}${FBillHead.FSettleId.FName}创建人_签名图片创建人_人脸采集单据类型_名称单据类型_编码对应组织_名称对应组织_编码供货方_名称供货方_编码供货方_图片(数据库)供货方_图片(文件服务)供货方联系人_名称供货方联系人_编码供货方联系人(旧)供应商_名称供应商_编码供应商_图片(数据库)供应商_图片(文件服务)关闭人_名称关闭人_编码关闭人_签名图片关闭人_人脸采集结算方_名称${FBillHead.FSettleId.FNumber}${FBillHead.FSettleId.F_AAAA_Image}${FBillHead.FSettleId.F_AAAA_ImageFileServer}金额${FBillHead.F_AAAA_Amount}确认人${FBillHead.FConfirmerId}${FBillHead.FConfirmerId.FName}${FBillHead.FConfirmerId.FUserAccount}${FBillHead.FConfirmerId.Fsignet}${FBillHead.FConfirmerId.FFaceImg}确认日期${FBillHead.FConfirmDate}审核人${FBillHead.FApproverId}${FBillHead.FApproverId.FName}${FBillHead.FApproverId.FUserAccount}${FBillHead.FApproverId.Fsignet}${FBillHead.FApproverId.FFaceImg}审核日期${FBillHead.FApproveDate}收款方${FBillHead.FChargeId}${FBillHead.FChargeId.FName}${FBillHead.FChargeId.FNumber}${FBillHead.FChargeId.F_AAAA_Image}${FBillHead.FChargeId.F_AAAA_ImageFileServer}手机${FBillHead.FProviderPhone}数量${FBillHead.F_AAAA_Qty}文本${FBillHead.F_AAAA_Text1}修改变更操作${FBillHead.FIsModificationOperator}验收方式${FBillHead.FACCTYPE}业务类型${FBillHead.FBusinessType}整数${FBillHead.F_AAAA_Integer}职务${FBillHead.FProviderJob}最后修改人${FBillHead.FModifierId}${FBillHead.FModifierId.FName}${FBillHead.FModifierId.FUserAccount}${FBillHead.FModifierId.Fsignet}${FBillHead.FModifierId.FFaceImg}最后修改日期${FBillHead.FModifyDate}结算方_编码结算方_图片(数据库)结算方_图片(文件服务)确认人_名称确认人_编码确认人_签名图片确认人_人脸采集审核人_名称审核人_编码审核人_签名图片审核人_人脸采集收款方_名称收款方_编码收款方_图片(数据库)收款方_图片(文件服务)最后修改人_名称最后修改人_编码最后修改人_签名图片最后修改人_人脸采集作废人${FBillHead.FCancellerId}${FBillHead.FCancellerId.FName}${FBillHead.FCancellerId.FUserAccount}${FBillHead.FCancellerId.Fsignet}${FBillHead.FCancellerId.FFaceImg}作废日期${FBillHead.FCancelDate}FPOOrderFinance保证金${FPOOrderFinance.FDeposit}${FPOOrderFinance.FDepositRatio}本位币${FPOOrderFinance.FLocalCurrId}${FPOOrderFinance.FLocalCurrId.FName}${FPOOrderFinance.FLocalCurrId.FNumber}单次预付额度${FPOOrderFinance.FPAYADVANCEAMOUNT}单次预付额度汇率${FPOOrderFinance.FSupToOderExchangeBusRate}定价时点${FPOOrderFinance.FPriceTimePoint}付款条件${FPOOrderFinance.FPayConditionId}${FPOOrderFinance.FPayConditionId.FName}${FPOOrderFinance.FPayConditionId.FNumber}关联保证金${FPOOrderFinance.FRelateDeposit}关联退款保证金${FPOOrderFinance.FRelateRefundDeposit}含税${FPOOrderFinance.FIsIncludedTax}汇率${FPOOrderFinance.FExchangeRate}汇率类型${FPOOrderFinance.FExchangeTypeId}${FPOOrderFinance.FExchangeTypeId.FName}${FPOOrderFinance.FExchangeTypeId.FNumber}${FPOOrderFinance.FSEPSETTLE}集中结算组织${FPOOrderFinance.FFOCUSSETTLEORGID}${FPOOrderFinance.FFOCUSSETTLEORGID.FName}${FPOOrderFinance.FFOCUSSETTLEORGID.FNumber}价目表${FPOOrderFinance.FPriceListId}${FPOOrderFinance.FPriceListId.FName}${FPOOrderFinance.FPriceListId.FNumber}价税合计${FPOOrderFinance.FBillAllAmount}${FPOOrderFinance.FBillAllAmount_LC}作废人_名称作废人_编码作废人_签名图片作废人_人脸采集子单据头.财务信息保证金比例%本位币_名称本位币_编码付款条件_名称付款条件_编码汇率类型_名称汇率类型_编码集中结算(6.0废弃)集中结算组织_名称集中结算组织_编码价目表_名称价目表_编码价税合计(本位币)价外税${FPOOrderFinance.FISPRICEEXCLUDETAX}结算币别${FPOOrderFinance.FSettleCurrId}${FPOOrderFinance.FSettleCurrId.FName}${FPOOrderFinance.FSettleCurrId.FNumber}结算方式${FPOOrderFinance.FSettleModeId}${FPOOrderFinance.FSettleModeId.FName}${FPOOrderFinance.FSettleModeId.FNumber}金额${FPOOrderFinance.FBillAmount}${FPOOrderFinance.FBillAmount_LC}申请关联保证金${FPOOrderFinance.FAPPLYRELATEDEPOSIT}税额${FPOOrderFinance.FBillTaxAmount}${FPOOrderFinance.FBillTaxAmount_LC}预付单号${FPOOrderFinance.FPayAdvanceBillId}${FPOOrderFinance.FPayAdvanceBillId.FNumber}${FPOOrderFinance.FPayAdvanceBillId.FNumber}预付已核销金额${FPOOrderFinance.FPreMatchAmountFor}折扣表${FPOOrderFinance.FDiscountListId}${FPOOrderFinance.FDiscountListId.FName}${FPOOrderFinance.FDiscountListId.FNumber}FPOOrderClause序号${FPOOrderClause.FSeq}描述${FPOOrderClause.FClauseDesc}条款编码${FPOOrderClause.FClauseId}${FPOOrderClause.FClauseId.FName}${FPOOrderClause.FClauseId.FNumber}条款类型${FPOOrderClause.FClauseType}条款名称${FPOOrderClause.FClauseName}条款内容${FPOOrderClause.FClauseContent}FPOOrderEntry序号${FPOOrderEntry.FSeq}${FPOORDERENTRY.FBomId}${FPOORDERENTRY.FBomId.FName}${FPOORDERENTRY.FBomId.FNumber}结算币别_名称结算币别_编码结算方式_名称结算方式_编码金额(本位币)税额(本位币)预付单号_名称预付单号_编码折扣表_名称折扣表_编码单据体.订单条款条款编码_名称条款编码_编码单据体.明细信息BOM版本BOM版本_名称BOM版本_编码备注${FPOORDERENTRY.FEntryNote}变更标志${FPOOrderEntry.FChangeFlag}采购单位${FPOORDERENTRY.FUnitId}${FPOORDERENTRY.FUnitId.FName}${FPOORDERENTRY.FUnitId.FNumber}采购基本数量${FPOORDERENTRY.FBaseUnitQty}采购数量${FPOORDERENTRY.FQty}产品类型${FPOORDERENTRY.FRowType}单价${FPOORDERENTRY.FPrice}单价折扣${FPOORDERENTRY.FPriceDiscount}当前库存${FPOORDERENTRY.FInventoryQty}定价单位${FPOORDERENTRY.FSetPriceUnitID}${FPOORDERENTRY.FSetPriceUnitID.FName}${FPOORDERENTRY.FSetPriceUnitID.FNumber}冻结人${FPOORDERENTRY.FFreezerId}${FPOORDERENTRY.FFreezerId.FName}${FPOORDERENTRY.FFreezerId.FUserAccount}${FPOORDERENTRY.FFreezerId.Fsignet}${FPOORDERENTRY.FFreezerId.FFaceImg}冻结日期${FPOORDERENTRY.FFreezeDate}费用项目${FPOORDERENTRY.FChargeProjectID}${FPOORDERENTRY.FChargeProjectID.FName}${FPOORDERENTRY.FChargeProjectID.FNumber}分录价目表${FPOORDERENTRY.FPriceListEntry}${FPOORDERENTRY.FPriceListEntry.FName}${FPOORDERENTRY.FPriceListEntry.FNumber}${FPOORDERENTRY.FDispSettleOrgId}${FPOORDERENTRY.FDispSettleOrgId.FName}${FPOORDERENTRY.FDispSettleOrgId.FNumber}辅助属性${FPOORDERENTRY.FAuxPropId}${FPOORDERENTRY.FAuxPropId.FOPCODE}${FPOORDERENTRY.FAuxPropId.FF100002}${FPOORDERENTRY.FAuxPropId.FF100003}${FPOORDERENTRY.FAuxPropId.FF100004}${FPOORDERENTRY.FAuxPropId.FF100005}采购单位_名称采购单位_编码定价单位_名称定价单位_编码冻结人_名称冻结人_编码冻结人_签名图片冻结人_人脸采集费用项目_名称费用项目_编码分录价目表_名称分录价目表_编码分散结算组织(6.0废弃)分散结算组织(6.0废弃)_名称分散结算组织(6.0废弃)_编码辅助属性.快捷码(勿删)辅助属性.等级辅助属性.YS辅助属性.银行辅助属性.国家${FPOORDERENTRY.FPARENTBOMID}${FPOORDERENTRY.FPARENTBOMID.FName}${FPOORDERENTRY.FPARENTBOMID.FNumber}父项产品${FPOORDERENTRY.FPARENTMATID}${FPOORDERENTRY.FPARENTMATID.FName}${FPOORDERENTRY.FPARENTMATID.FNumber}${FPOORDERENTRY.FPARENTMATID.FImage1}${FPOORDERENTRY.FPARENTMATID.FImageFileServer}${FPOORDERENTRY.FPARENTMATID.FImgFile_CMK}付款组织${FPOORDERENTRY.FEntryPayOrgId}${FPOORDERENTRY.FEntryPayOrgId.FName}${FPOORDERENTRY.FEntryPayOrgId.FNumber}供应商批号${FPOORDERENTRY.FSupplierLot}供应商物料编码${FPOORDERENTRY.FSupMatId}供应商物料名称${FPOORDERENTRY.FSupMatName}关联数量${FPOORDERENTRY.FJOINQTY}规格型号${FPOORDERENTRY.FModel}含税单价${FPOORDERENTRY.FTaxPrice}行费用${FPOORDERENTRY.FRowCost}合同单号${FPOORDERENTRY.FContractNo}基本单位${FPOORDERENTRY.FBaseUnitId}${FPOORDERENTRY.FBaseUnitId.FName}${FPOORDERENTRY.FBaseUnitId.FNumber}基本单位关联数量${FPOORDERENTRY.FBaseJoinQty}${FPOORDERENTRY.FCentSettleOrgId}${FPOORDERENTRY.FCentSettleOrgId.FName}${FPOORDERENTRY.FCentSettleOrgId.FNumber}计划跟踪号${FPOORDERENTRY.FMtoNo}计划确认${FPOORDERENTRY.FPlanConfirm}计价单位${FPOORDERENTRY.FPriceUnitId}${FPOORDERENTRY.FPriceUnitId.FName}${FPOORDERENTRY.FPriceUnitId.FNumber}计价基本数量${FPOORDERENTRY.FPriceBaseQty}计价数量${FPOORDERENTRY.FPriceUnitQty}加工商${FPOORDERENTRY.FProcesser}父项BOM版本父项BOM版本_名称父项BOM版本_编码父项产品_名称父项产品_编码父项产品_图片(数据库)父项产品_图片(文件服务器)父项产品_图片(文件服务器)付款组织_名称付款组织_编码基本单位_名称基本单位_编码集中结算组织(6.0废弃)集中结算组织(6.0废弃)_名称集中结算组织(6.0废弃)_编码计价单位_名称计价单位_编码${FPOORDERENTRY.FProcesser.FName}${FPOORDERENTRY.FProcesser.FNumber}${FPOORDERENTRY.FProcesser.F_AAAA_Image}${FPOORDERENTRY.FProcesser.F_AAAA_ImageFileServer}价格上限${FPOORDERENTRY.FUpPrice}价格系数${FPOORDERENTRY.FPriceCoefficient}价格下限${FPOORDERENTRY.FDownPrice}价税合计${FPOORDERENTRY.FAllAmount}${FPOORDERENTRY.FAllAmount_LC}交货地点${FPOORDERENTRY.FLocationId}${FPOORDERENTRY.FLocationId.FName}${FPOORDERENTRY.FLocationId.FNumber}交货地点${FPOORDERENTRY.FLocation}交货地址${FPOORDERENTRY.FLocationAddress}交货库存状态${FPOORDERENTRY.FDeliveryStockStatus}${FPOORDERENTRY.FDeliveryStockStatus.FName}${FPOORDERENTRY.FDeliveryStockStatus.FNumber}交货日期${FPOORDERENTRY.FDeliveryDate}交货上限${FPOORDERENTRY.FDeliveryMaxQty}${FPOORDERENTRY.FBaseDeliveryMaxQty}交货提前天数${FPOORDERENTRY.FDeliveryBeforeDays}交货下限${FPOORDERENTRY.FDeliveryMinQty}${FPOORDERENTRY.FBaseDeliveryMinQty}交货延迟天数${FPOORDERENTRY.FDeliveryDelayDays}结算方式${FPOORDERENTRY.FEntrySettleModeId}${FPOORDERENTRY.FEntrySettleModeId.FName}${FPOORDERENTRY.FEntrySettleModeId.FNumber}结算组织${FPOORDERENTRY.FEntrySettleOrgId}${FPOORDERENTRY.FEntrySettleOrgId.FName}${FPOORDERENTRY.FEntrySettleOrgId.FNumber}金额${FPOORDERENTRY.FEntryAmount}${FPOORDERENTRY.FAmount_LC}净价${FPOORDERENTRY.FTaxNetPrice}控制交货时间${FPOORDERENTRY.FTimeControl}控制交货数量${FPOORDERENTRY.FDeliveryControl}加工商_名称加工商_编码加工商_图片(数据库)加工商_图片(文件服务)价税合计(本位币)交货地点_名称交货地点_编码交货库存状态_名称交货库存状态_编码交货上限(基本单位)交货下限(基本单位)结算方式_名称结算方式_编码结算组织_名称结算组织_编码金额(本位币)库存单位${FPOORDERENTRY.FStockUnitID}${FPOORDERENTRY.FStockUnitID.FName}${FPOORDERENTRY.FStockUnitID.FNumber}库存单位数量${FPOORDERENTRY.FStockQty}库存基本数量${FPOORDERENTRY.FStockBaseQty}${FPOORDERENTRY.FPayAmount}累计入库数量${FPOORDERENTRY.FStockInQty}${FPOORDERENTRY.FBASESTOCKINQTY}累计收料数量${FPOORDERENTRY.FReceiveQty}${FPOORDERENTRY.FBASERECEIVEQTY}累计退料数量${FPOORDERENTRY.FMrbQty}${FPOORDERENTRY.FBASEMRBQTY}${FPOORDERENTRY.FSUMACCRATE}累计验收金额${FPOORDERENTRY.FSUMACCALLAMOUNT}配额生成${FPOORDERENTRY.FIsQuota}批号${FPOORDERENTRY.FLot}${FPOORDERENTRY.FLot.FName}${FPOORDERENTRY.FLot.FNumber}剩余入库数量${FPOORDERENTRY.FRemainStockINQty}剩余收料数量${FPOORDERENTRY.FRemainReceiveQty}是否可库存${FPOORDERENTRY.FIsStock}是否赠品${FPOORDERENTRY.FGiveAway}收料部门${FPOORDERENTRY.FReceiveDeptId}${FPOORDERENTRY.FReceiveDeptId.FName}${FPOORDERENTRY.FReceiveDeptId.FNumber}收料组织${FPOORDERENTRY.FReceiveOrgId}${FPOORDERENTRY.FReceiveOrgId.FName}${FPOORDERENTRY.FReceiveOrgId.FNumber}税额${FPOORDERENTRY.FEntryTaxAmount}${FPOORDERENTRY.FTaxAmount_LC}${FPOORDERENTRY.FEntryTaxRate}税组合${FPOORDERENTRY.FTaxCombination}${FPOORDERENTRY.FTaxCombination.FName}${FPOORDERENTRY.FTaxCombination.FNumber}委外产品类型${FPOORDERENTRY.FProductType}库存单位_名称库存单位_编码累计付款金额(已废弃)累计入库数量(基本)累计收料数量(基本)累计退料数量(基本)累计验收比例%批号_名称批号_编码收料部门_名称收料部门_编码收料组织_名称收料组织_编码税额(本位币)税率%税组合_名称税组合_编码委外组织${FPOORDERENTRY.FSubOrgId}${FPOORDERENTRY.FSubOrgId.FName}${FPOORDERENTRY.FSubOrgId.FNumber}文本${FPOORDERENTRY.F_AAAA_Text}物料版本${FPOOrderEntry.FMaterialVersion}物料编码${FPOORDERENTRY.FMaterialId}${FPOORDERENTRY.FMaterialId.FName}${FPOORDERENTRY.FMaterialId.FNumber}${FPOORDERENTRY.FMaterialId.FImage1}${FPOORDERENTRY.FMaterialId.FImageFileServer}${FPOORDERENTRY.FMaterialId.FImgFile_CMK}物料类别${FPOORDERENTRY.FMaterialType}物料名称${FPOORDERENTRY.FMaterialName}物料说明${FPOORDERENTRY.FMaterialDesc}物料说明${FPOORDERENTRY.FMaterialDesc.CN}物料說明${FPOORDERENTRY.FMaterialDesc.HK}MaterialDescription${FPOORDERENTRY.FMaterialDesc.US}系统定价${FPOORDERENTRY.FSysPrice}先收票数量（基本单位）${FPOORDERENTRY.FBASEFINAPQTY}先收票数量（库存基本）${FPOORDERENTRY.FSTOCKBASEFINAPQTY}消耗汇总基本单位数量${FPOORDERENTRY.FBaseConsumeSumQty}消耗汇总数量${FPOORDERENTRY.FConsumeSumQty}销售单位${FPOORDERENTRY.FSalUnitID}${FPOORDERENTRY.FSalUnitID.FName}${FPOORDERENTRY.FSalUnitID.FNumber}销售订单关联数量（采购）${FPOORDERENTRY.FSalJoinQty}销售订单关联数量（采购基本）${FPOORDERENTRY.FBaseSalJoinQty}销售基本数量${FPOORDERENTRY.FSalBaseQty}销售数量${FPOORDERENTRY.FSalQty}需求部门${FPOORDERENTRY.FRequireDeptId}${FPOORDERENTRY.FRequireDeptId.FName}${FPOORDERENTRY.FRequireDeptId.FNumber}需求单据编号${FPOORDERENTRY.FDEMANDBILLNO}需求单据分录内码${FPOORDERENTRY.FDEMANDBILLENTRYID}需求单据行号${FPOORDERENTRY.FDEMANDBILLENTRYSEQ}委外组织_名称委外组织_编码物料编码_名称物料编码_编码物料编码_图片(数据库)物料编码_图片(文件服务器)物料编码_图片(文件服务器)销售单位_名称销售单位_编码需求部门_名称需求部门_编码需求跟踪号${FPOORDERENTRY.FReqTraceNo}需求来源${FPOORDERENTRY.FDEMANDTYPE}需求人${FPOORDERENTRY.FRequireStaffId}${FPOORDERENTRY.FRequireStaffId.FName}${FPOORDERENTRY.FRequireStaffId.FStaffNumber}${FPOORDERENTRY.FRequireStaffId.FPhoto}需求组织${FPOORDERENTRY.FRequireOrgId}${FPOORDERENTRY.FRequireOrgId.FName}${FPOORDERENTRY.FRequireOrgId.FNumber}应付金额${FPOORDERENTRY.FInvoiceAmount}应付数量${FPOORDERENTRY.FInvoiceQty}允许库存${FPOORDERENTRY.FIsInventory}折扣额${FPOORDERENTRY.FEntryDiscount}${FPOORDERENTRY.FEntryDiscountRate}整单折扣分摊${FPOORDERENTRY.FBillDisApportion}整数${FPOORDERENTRY.F_AAAA_Integer1}终止人${FPOORDERENTRY.FTerminaterId}${FPOORDERENTRY.FTerminaterId.FName}${FPOORDERENTRY.FTerminaterId.FUserAccount}${FPOORDERENTRY.FTerminaterId.Fsignet}${FPOORDERENTRY.FTerminaterId.FFaceImg}终止日期${FPOORDERENTRY.FTerminateDate}组别${FPOORDERENTRY.FGroup}${FPOORDERENTRY.FMinPrice}${FPOORDERENTRY.FMaxPrice}最晚交货日期${FPOORDERENTRY.FDeliveryLastDate}最早交货日期${FPOORDERENTRY.FDeliveryEarlyDate}FEntryDeliveryPlan序号${FEntryDeliveryPlan.FSEQ}供应商发货日期${FENTRYDELIVERYPLAN.FSUPPLIERDELIVERYDATE}计划单位${FENTRYDELIVERYPLAN.FPlanUnitID}${FENTRYDELIVERYPLAN.FPlanUnitID.FName}${FENTRYDELIVERYPLAN.FPlanUnitID.FNumber}计划基本单位${FENTRYDELIVERYPLAN.FPlanBaseUnitID}需求人_名称需求人_编码需求人_照片需求组织_名称需求组织_编码折扣率%终止人_名称终止人_编码终止人_签名图片终止人_人脸采集最低报价(6.1废弃)最高报价(6.1废弃)子单据体.交货明细计划单位_名称计划单位_编码${FENTRYDELIVERYPLAN.FPlanBaseUnitID.FName}${FENTRYDELIVERYPLAN.FPlanBaseUnitID.FNumber}交货地点${FEntryDeliveryPlan.FELocationId}${FEntryDeliveryPlan.FELocationId.FName}${FEntryDeliveryPlan.FELocationId.FNumber}交货地点${FENTRYDELIVERYPLAN.FELocation}交货地址${FEntryDeliveryPlan.FELocationAddress}交货日期${FENTRYDELIVERYPLAN.FDeliveryDate_Plan}确认交货日期${FEntryDeliveryPlan.FConfirmDeliDate}确认交货数量${FEntryDeliveryPlan.FConfirmDeliQty}确认意见${FEntryDeliveryPlan.FConfirmInfo}数量${FEntryDeliveryPlan.FPlanQty}数量（基本单位）${FENTRYDELIVERYPLAN.FBasePlanQty}预计到货日期${FENTRYDELIVERYPLAN.FPREARRIVALDATE}运输提前期${FENTRYDELIVERYPLAN.FTRLT}FTaxDetailSubEntity序号${FTaxDetailSubEntity.FSeq}${FTaxDetailSubEntity.FCostPercent}计入成本金额${FTaxDetailSubEntity.FCostAmount}买方代扣代缴${FTaxDetailSubEntity.FBuyerWithholding}卖方代扣代缴${FTaxDetailSubEntity.FSellerWithholding}税额${FTaxDetailSubEntity.FTaxAmount}${FTaxDetailSubEntity.FTaxRate}税率名称${FTaxDetailSubEntity.FTaxRateId}${FTaxDetailSubEntity.FTaxRateId.FName}${FTaxDetailSubEntity.FTaxRateId.FNumber}增值税${FTaxDetailSubEntity.FVAT}FIinstallment序号${FIinstallment.FSeq}备注${FIINSTALLMENT.FRemarks}采购订单号${FIINSTALLMENT.FPURCHASEORDERNO}单次预付额度${FIINSTALLMENT.FInsPrepaidAmount}订单明细行内码${FIINSTALLMENT.FOrderEntryId}计划基本单位_名称计划基本单位_编码交货地点_名称交货地点_编码子单据体.税务明细计入成本比例%税率%税率名称_名称税率名称_编码单据体.付款计划辅助属性${FIINSTALLMENT.FPayAuxPropId}${FIINSTALLMENT.FPayAuxPropId.FOPCODE}${FIINSTALLMENT.FPayAuxPropId.FF100002}${FIINSTALLMENT.FPayAuxPropId.FF100003}${FIINSTALLMENT.FPayAuxPropId.FF100004}${FIINSTALLMENT.FPayAuxPropId.FF100005}付款关联金额${FIINSTALLMENT.FPayJoinAmount}付款申请关联金额${FIINSTALLMENT.FAPPLYAMOUNT}规格型号${FIINSTALLMENT.FPayModel}含税单价${FIINSTALLMENT.FPayPlanPrice}计价单位${FIINSTALLMENT.FPAYPLANPRICEUNITID}${FIINSTALLMENT.FPAYPLANPRICEUNITID.FName}${FIINSTALLMENT.FPAYPLANPRICEUNITID.FNumber}计价基本单位${FIINSTALLMENT.FBasePriceUnit}${FIINSTALLMENT.FBasePriceUnit.FName}${FIINSTALLMENT.FBasePriceUnit.FNumber}实际预付关联数量${FIINSTALLMENT.FActualPayQty}实际预付金额${FIinstallment.FACTUALAMOUNT}是否预付${FIinstallment.FISPREPAYMENT}数量${FIINSTALLMENT.FPayPlanQty}${FIINSTALLMENT.FBasePayPlanQty}物料编码${FIINSTALLMENT.FPayMaterialId}${FIINSTALLMENT.FPayMaterialId.FName}${FIINSTALLMENT.FPayMaterialId.FNumber}${FIINSTALLMENT.FPayMaterialId.FImage1}${FIINSTALLMENT.FPayMaterialId.FImageFileServer}${FIINSTALLMENT.FPayMaterialId.FImgFile_CMK}物料行号${FIINSTALLMENT.FMATERIALSEQ}物料名称${FIINSTALLMENT.FPayMaterialName}物料说明${FIINSTALLMENT.FPayMaterialDesc}已申请关联数量${FIINSTALLMENT.FAppliedQty}${FIinstallment.FYFRATIO}应付金额${FIinstallment.FYFAMOUNT}应付日期${FIinstallment.FYFDATE}${FIINSTALLMENT.FinsPayAdvanceRate}辅助属性.快捷码(勿删)辅助属性.等级辅助属性.YS辅助属性.银行辅助属性.国家计价单位_名称计价单位_编码计价基本单位_名称计价基本单位_编码数量(基本单位)物料编码_名称物料编码_编码物料编码_图片(数据库)物料编码_图片(文件服务器)物料编码_图片(文件服务器)应付比例(%)预付比例%预付单号${FIINSTALLMENT.FRelBillNo}预付款${FIINSTALLMENT.FInsPayAdvanceAmount}FOrderActualPaySubEntity序号${FOrderActualPaySubEntity.FSeq}采购订单内码${FORDERACTUALPAYSUBENTITY.FPOORDERID}付款单分录内码${FORDERACTUALPAYSUBENTITY.FPAYBILLENTITYID}付款单内码${FORDERACTUALPAYSUBENTITY.FPAYBILLID}付款关联金额${FORDERACTUALPAYSUBENTITY.FPPayJoinAmount}付款申请单号${FORDERACTUALPAYSUBENTITY.FAPPLYBILLNO}付款申请关联金额${FORDERACTUALPAYSUBENTITY.FPAPPLYAMOUNT}结算组织${FORDERACTUALPAYSUBENTITY.FPPSettleOrgId}${FORDERACTUALPAYSUBENTITY.FPPSettleOrgId.FName}${FORDERACTUALPAYSUBENTITY.FPPSettleOrgId.FNumber}实付预付金额${FORDERACTUALPAYSUBENTITY.FAmount}预分配金额${FORDERACTUALPAYSUBENTITY.FPREAMOUNT}预付单号${FORDERACTUALPAYSUBENTITY.FPREPAYBillNo}子单据体.付款计划子单据体结算组织_名称结算组织_编码d.FUserAccount}d.Fsignet}d.FFaceImg}DeptId.FName}DeptId.FNumber}rId.FName}rId.FNumber}rGroupId.FName}rGroupId.FNumber}OrgId.FName}OrgId.FNumber}d.FUserAccount}d.Fsignet}d.FFaceImg}ID.FNumber}ndOrgId.FName}ndOrgId.FNumber}Id.FNumber}Id.F_AAAA_Image}Id.F_AAAA_ImageFileServer}ContactId}ContactId.FName}ContactId.FCONTACTNUMBER}Id.FNumber}Id.F_AAAA_Image}Id.F_AAAA_ImageFileServer}FUserAccount}FFaceImg}F_AAAA_Image}F_AAAA_ImageFileServer}rId.FName}rId.FUserAccount}rId.Fsignet}rId.FFaceImg}Id.FUserAccount}Id.Fsignet}Id.FFaceImg}F_AAAA_Image}F_AAAA_ImageFileServer}cationOperator}Id.FUserAccount}Id.Fsignet}Id.FFaceImg}rId.FName}rId.FUserAccount}rId.Fsignet}rId.FFaceImg}positRatio}calCurrId}calCurrId.FName}calCurrId.FNumber}YADVANCEAMOUNT}pToOderExchangeBusRate}iceTimePoint}yConditionId}yConditionId.FName}yConditionId.FNumber}lateDeposit}lateRefundDeposit}IncludedTax}changeRate}changeTypeId}changeTypeId.FName}changeTypeId.FNumber}CUSSETTLEORGID}CUSSETTLEORGID.FName}CUSSETTLEORGID.FNumber}iceListId}iceListId.FName}iceListId.FNumber}llAllAmount}llAllAmount_LC}PRICEEXCLUDETAX}ttleCurrId}ttleCurrId.FName}ttleCurrId.FNumber}ttleModeId}ttleModeId.FName}ttleModeId.FNumber}llAmount_LC}PLYRELATEDEPOSIT}llTaxAmount}llTaxAmount_LC}yAdvanceBillId}yAdvanceBillId.FNumber}yAdvanceBillId.FNumber}eMatchAmountFor}scountListId}scountListId.FName}scountListId.FNumber}useId.FName}useId.FNumber}useContent}d.FNumber}Id.FNumber}eDiscount}riceUnitID}riceUnitID.FName}riceUnitID.FNumber}zerId.FName}zerId.FUserAccount}zerId.Fsignet}zerId.FFaceImg}geProjectID}geProjectID.FName}geProjectID.FNumber}eListEntry}eListEntry.FName}eListEntry.FNumber}SettleOrgId}SettleOrgId.FName}SettleOrgId.FNumber}ropId.FOPCODE}ropId.FF100002}ropId.FF100003}ropId.FF100004}ropId.FF100005}NTBOMID.FName}NTBOMID.FNumber}NTMATID.FName}NTMATID.FNumber}NTMATID.FImage1}NTMATID.FImageFileServer}NTMATID.FImgFile_CMK}yPayOrgId}yPayOrgId.FName}yPayOrgId.FNumber}UnitId.FName}UnitId.FNumber}SettleOrgId}SettleOrgId.FName}SettleOrgId.FNumber}eUnitId.FName}eUnitId.FNumber}esser.FName}esser.FNumber}esser.F_AAAA_Image}esser.F_AAAA_ImageFileServer}eCoefficient}tionId.FName}tionId.FNumber}tionAddress}veryStockStatus}veryStockStatus.FName}veryStockStatus.FNumber}veryMaxQty}DeliveryMaxQty}veryBeforeDays}veryMinQty}DeliveryMinQty}veryDelayDays}ySettleModeId}ySettleModeId.FName}ySettleModeId.FNumber}ySettleOrgId}ySettleOrgId.FName}ySettleOrgId.FNumber}veryControl}kUnitID.FName}kUnitID.FNumber}STOCKINQTY}RECEIVEQTY}CCALLAMOUNT}inStockINQty}inReceiveQty}iveDeptId}iveDeptId.FName}iveDeptId.FNumber}iveOrgId.FName}iveOrgId.FNumber}yTaxAmount}ombination}ombination.FName}ombination.FNumber}rgId.FName}rgId.FNumber}rialVersion}rialId.FName}rialId.FNumber}rialId.FImage1}rialId.FImageFileServer}rialId.FImgFile_CMK}rialDesc.CN}rialDesc.HK}rialDesc.US}KBASEFINAPQTY}ConsumeSumQty}umeSumQty}nitID.FName}nitID.FNumber}SalJoinQty}ireDeptId}ireDeptId.FName}ireDeptId.FNumber}NDBILLENTRYID}NDBILLENTRYSEQ}ireStaffId}ireStaffId.FName}ireStaffId.FStaffNumber}ireStaffId.FPhoto}ireOrgId.FName}ireOrgId.FNumber}iceAmount}yDiscount}yDiscountRate}DisApportion}A_Integer1}inaterId.FName}inaterId.FUserAccount}inaterId.Fsignet}inaterId.FFaceImg}inateDate}veryLastDate}veryEarlyDate}FSUPPLIERDELIVERYDATE}FPlanUnitID}FPlanUnitID.FName}FPlanUnitID.FNumber}FPlanBaseUnitID}FPlanBaseUnitID.FName}FPlanBaseUnitID.FNumber}FELocationId}FELocationId.FName}FELocationId.FNumber}FELocation}FELocationAddress}FDeliveryDate_Plan}FConfirmDeliDate}FConfirmDeliQty}FConfirmInfo}FBasePlanQty}FPREARRIVALDATE}FCostPercent}FCostAmount}FBuyerWithholding}FSellerWithholding}FTaxAmount}FTaxRate}FTaxRateId}FTaxRateId.FName}FTaxRateId.FNumber}HASEORDERNO}repaidAmount}uxPropId.FOPCODE}uxPropId.FF100002}uxPropId.FF100003}uxPropId.FF100004}uxPropId.FF100005}oinAmount}LANPRICEUNITID}LANPRICEUNITID.FName}LANPRICEUNITID.FNumber}PriceUnit}PriceUnit.FName}PriceUnit.FNumber}PayPlanQty}aterialId}aterialId.FName}aterialId.FNumber}aterialId.FImage1}aterialId.FImageFileServer}aterialId.FImgFile_CMK}aterialName}aterialDesc}ayAdvanceRate}ayAdvanceAmount}ntity.FSeq}NTITY.FPOORDERID}NTITY.FPAYBILLENTITYID}NTITY.FPAYBILLID}NTITY.FPPayJoinAmount}NTITY.FAPPLYBILLNO}NTITY.FPAPPLYAMOUNT}NTITY.FPPSettleOrgId}NTITY.FPPSettleOrgId.FName}NTITY.FPPSettleOrgId.FNumber}NTITY.FAmount}NTITY.FPREAMOUNT}NTITY.FPREPAYBillNo}欢迎使用Excel模板打印！Excel模板打印是一种使用Excel文件作为模板的打印方式，打印的过程是一个将数据填充到模板中对应单元格的过程，并在此因为Excel模板打印使用Excel文件作为模板，所以您可以在制作模板的过程中使用Excel的各种功能，比如设置单元格的宽系统生成的内置Excel模板文件由4个页签组成。以采购订单内置Excel模板文件为例，4个页签按顺序分别是PUR_PurchaseOrder、EntryFilters、DataSource、Instructions1、模板页签，以单据标识命名。打印的数据最终是填充到这个页签。您可以对这个页签的内容进行编辑，从DataSource页签复制关键字到模板页签，以达到您所请注意，模板页签是以单据标识命名的，必须放在最前面，且页签名不允许修改，否则程序将无法正确解析模板文件！2、单据体过滤条件页签，以EntryFilters命名。其作用类似套打设计器中数据表格的数据源过滤条件，详细使用说明请看EntryFilters页签内的说明。3、数据源页签，以DataSource命名。罗列了单据上所有允许引出的字段对应的关键字，类似套打设计器中的数据源。如果发现缺少某个字段的关键字，请到BOS设计器字段对应关键字的格式为${实体标识.字段标识}，以${开头，以}结尾。实体标识、字段标识和开头结尾的标识不可修改，4、使用说明页签，以Instructions命名。用于展示Excel模板打印的使用说明。下面介绍Excel模板打印的部分功能。1、单据体数据打印打印单据体数据，只需要在模板的某一行设置一次单据体字段关键字。程序会自动解析模板，将单据体字段关键字最多的一行当做单据体，类似套打设计器的数据表格控件，循环填充所有单据体分录数如果单据体字段关键字最多的行有多行，则取行号最小的一行作为单据体进行填充，其余单据体字段只会使用第一条分录的数据填2、基础资料属性打印Excel模板文件DataSource页签只列出了单据上存在的字段对应的关键字，基础资料字段只列出了基础资料的编码、名称和图但是Excel模板打印支持在单据不添加基础资料属性字段的前提下，打印基础资料属性。只需要在基础资料关键字的字段标识后比如要打印采购订单明细信息中物料的助记码，只需在物料编码关键字${FPOORDERENTRY.FMaterialId}的基础上追加助记码的标即在模板页签添加${FPOORDERENTRY.FMaterialId.FMnemonicCode}即可打印出物料的助记码。请注意：要打印的基础资料属性，必须在BOS设计器中对应的基础资料字段的引用属性中添加了引用才能打印出来！3、多语言字段打印Excel模板打印支持按区域标识打印多语言字段，只需在字段关键字的字段标识后面以“.”为分隔符，追加区域标识即可。以采购订单的物料名称为例，假如存在日文名称，要在中文环境下打印日文名称，只需要在物料名称的关键字${FPOORDERENTRY即在模板页签添加${FPOORDERENTRY.FMaterialId.FName.1041}即可打印出物料的日文名称。中文(简体)对应的2052可以用CN代替，中文(香港)对应的3076可以用HK代替，English(US)对应的1033可以用US代如果多语言字段不追加区域标识，则会按照当前登录使用的语言进行打印。4、条码打印数据以普通条形码的形式打印，关键字追加||BarCode_编码，如${FPOORDERENTRY.FQty||BarCode_Code128}。支持的编码列表数据以高级条形码的形式打印，关键字追加||AdvBarCode_编码，如${FPOORDERENTRY.FQty||AdvBarCode_DataMatrix}。支持的如果生成的条码太小、显示异常或无法扫描，请手动调整模板对应的单元格的大小以获取正常的打印效果。请注意：①条形码所在的行不能有单元格设置了自动换行，否则该行的行高将无法确定，生成的条形码会显示异常。②不同编码对数据的要求有所不同，若数据不符合对应编码的要求，则无法生成条形码，数据会原样输出。5、单据体分组打印在单据体字段关键字行上一行添加分组标识${Group_Begin}代表分组开始，单据体字段关键字下一行添加${Group_End}代表分在单据体字段关键字追加||Group标识以该字段为依据进行分组，分组依据可设置多个单据体字段。以采购订单明细信息为例，要按物料编码和物料名称分组，则需要在模板中对物料编码关键字和物料名称关键字追加分组标识，请注意：如果模板文件设置了分组打印，“套打设置-Excel模板打印-参数设置-分页打印-单据体每页打印行数”这个参数会失6、单据体统计打印Excel模板打印的单据体统计打印是通过Excel内置的函数来实现的。以采购订单明细信息的采购数量为例，假设采购数量关键字在单元格K19,如果要求和，只需在单元格K21设置求和公式=SUM(K19:K请注意：①单据体统计打印，使用Excel内置函数时，参数应该设置一个范围，至少要包含要统计的字段关键字所在的行及其下一行，这②如果统计不生效，请确认统计字段关键字所在的单元格类型是否为数值、货币等数字类型。7、页眉页脚使用字段关键字打印Excel模板的页眉页脚可以设置字段关键字，设置后，打印时会将对应的数据填充到页眉页脚。请注意：如果设置的字段关键字对应的是单据体字段，则只会填充第一条分录的数据。8、多字段合并打印1个单元格内允许设置多个字段关键字，也允许1个字段关键字在1个单元格内设置多次。9、多字段合并生成条码打印多字段合并生成条码打印的设置与条码打印类似，只需要在单元格的字符串值末尾追加||BarCode_编码或||AdvBarCode_编码以采购订单为例，要将单据编号和物料编码合并生成一个二维码，如CGDD000019-1.01.010，只需在要显示二维码的单元格上设置其他使用说明和注意事项，请参照条码打印。
