采购订单${FBillHead.FBillTy${FBillHead.FSupplierId}${FBillHead.FBusine${FBillHead.FPurchaseOrgId}${FBillHead.FBillNo物料名称：${FPOORDERENTRY.FMaterialName||NotEntry}序号委外产品类型物料编码物料名称${FPOOrderEntry.FSeq}${FPOORDERENTRY.FProductType}${FPOORDERENTRY.FMaterialId}${FPOORDERENTRY.FMaterialName}单据类型:供应商:业务类型:采购组织:单据编号:说明单据体.订单条款单据体.明细信息子单据体.交货明细子单据体.税务明细单据体.付款计划子单据体.付款计划子单据体子单据体.关联关系表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.FBillNo}单据类型${FBillHead.FBillTypeID}${FBillHead.FBillTypeID.FName}${FBillHead.FBillTypeID.FNumber}单据状态${FBillHead.FDocumentStatus}对应组织${FBillHead.FCorrespondOrgId}${FBillHead.FCorrespondOrgId.FName}${FBillHead.FCorrespondOrgId.FNumber}供货方${FBillHead.FProviderId}${FBillHead.FProviderId.FName}${FBillHead.FProviderId.FNumber}供货方地址${FBillHead.FProviderAddress}供货方联系人${FBillHead.FProviderContactId}${FBillHead.FProviderContactId.FName}${FBillHead.FProviderContactId.FCONTACTNUMBER}${FBillHead.FProviderContact}供应商${FBillHead.FSupplierId}${FBillHead.FSupplierId.FName}${FBillHead.FSupplierId.FNumber}${FBillHead.FNetOrderBillId}${FBillHead.FNetOrderBillNo}关闭人${FBillHead.FCloserId}${FBillHead.FCloserId.FName}${FBillHead.FCloserId.FUserAccount}${FBillHead.FCloserId.Fsignet}${FBillHead.FCloserId.FFaceImg}关闭日期${FBillHead.FCloseDate}关闭状态${FBillHead.FCloseStatus}结算方${FBillHead.FSettleId}${FBillHead.FSettleId.FName}${FBillHead.FSettleId.FNumber}确认人${FBillHead.FConfirmerId}${FBillHead.FConfirmerId.FName}${FBillHead.FConfirmerId.FUserAccount}${FBillHead.FConfirmerId.Fsignet}${FBillHead.FConfirmerId.FFaceImg}确认日期${FBillHead.FConfirmDate}单据类型_名称单据类型_编码对应组织_名称对应组织_编码供货方_名称供货方_编码供货方联系人_名称供货方联系人_编码供货方联系人(旧)供应商_名称供应商_编码供应商协同平台订单ID(6.1废弃)供应商协同平台订单编号(6.1废弃)关闭人_名称关闭人_编码关闭人_签名图片关闭人_人脸采集结算方_名称结算方_编码确认人_名称确认人_编码确认人_签名图片确认人_人脸采集确认状态${FBillHead.FConfirmStatus}审核人${FBillHead.FApproverId}${FBillHead.FApproverId.FName}${FBillHead.FApproverId.FUserAccount}${FBillHead.FApproverId.Fsignet}${FBillHead.FApproverId.FFaceImg}审核日期${FBillHead.FApproveDate}释放采购申请${FBillHead.FRelReqStatus}收款方${FBillHead.FChargeId}${FBillHead.FChargeId.FName}${FBillHead.FChargeId.FNumber}手工关闭${FBillHead.FMANUALCLOSE}手机${FBillHead.FProviderPhone}修改变更操作${FBillHead.FIsModificationOperator}验收方式${FBillHead.FACCTYPE}业务类型${FBillHead.FBusinessType}源单编号${FBillHead.FSourceBillNo}职务${FBillHead.FProviderJob}指定供应商${FBillHead.FAssignSupplierId}${FBillHead.FAssignSupplierId.FName}${FBillHead.FAssignSupplierId.FNumber}最后修改人${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}作废状态${FBillHead.FCancelStatus}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}价外税${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}保证金比例%本位币_名称本位币_编码付款条件_名称付款条件_编码汇率类型_名称汇率类型_编码集中结算(6.0废弃)集中结算组织_名称集中结算组织_编码价目表_名称价目表_编码价税合计(本位币)结算币别_名称结算币别_编码结算方式_名称结算方式_编码金额(本位币)${FPOOrderFinance.FBillTaxAmount_LC}预付单号${FPOOrderFinance.FPayAdvanceBillId}${FPOOrderFinance.FPayAdvanceBillId.FNumber}${FPOOrderFinance.FPayAdvanceBillId.FNumber}预付已核销金额${FPOOrderFinance.FPreMatchAmountFor}折扣表${FPOOrderFinance.FDiscountListId}${FPOOrderFinance.FDiscountListId.FName}${FPOOrderFinance.FDiscountListId.FNumber}整单费用${FPOOrderFinance.FBillCost}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}备注${FPOORDERENTRY.FEntryNote}变更标志${FPOOrderEntry.FChangeFlag}采购单位${FPOORDERENTRY.FUnitId}${FPOORDERENTRY.FUnitId.FName}${FPOORDERENTRY.FUnitId.FNumber}采购基本分子${FPOORDERENTRY.FPurBaseNum}采购基本数量${FPOORDERENTRY.FBaseUnitQty}采购数量${FPOORDERENTRY.FQty}产品行主键${FPOORDERENTRY.FRowId}产品类型${FPOORDERENTRY.FRowType}单价${FPOORDERENTRY.FPrice}单价折扣${FPOORDERENTRY.FPriceDiscount}当前库存${FPOORDERENTRY.FInventoryQty}税额(本位币)预付单号_名称预付单号_编码折扣表_名称折扣表_编码单据体.订单条款条款编码_名称条款编码_编码单据体.明细信息BOM版本BOM版本_名称BOM版本_编码采购单位_名称采购单位_编码定价单位${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.FParentRowId}${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}定价单位_名称定价单位_编码冻结人_名称冻结人_编码冻结人_签名图片冻结人_人脸采集费用项目_名称费用项目_编码分录价目表_名称分录价目表_编码分散结算组织(6.0废弃)分散结算组织(6.0废弃)_名称分散结算组织(6.0废弃)_编码辅助属性.快捷码(勿删)辅助属性.等级父项BOM版本父项BOM版本_名称父项BOM版本_编码父项产品_名称父项产品_编码父项产品_图片(数据库)父项产品_图片(文件服务器)父项产品_图片(文件服务器)付款组织_名称付款组织_编码${FPOORDERENTRY.FNetOrderEntryId}关联数量${FPOORDERENTRY.FJOINQTY}关联应付金额${FPOORDERENTRY.FAPJoinAmount}${FPOORDERENTRY.FBaseAPJoinQty}${FPOORDERENTRY.FStockBaseAPJoinQty}规格型号${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}${FPOORDERENTRY.FProcesser.FName}${FPOORDERENTRY.FProcesser.FNumber}价格上限${FPOORDERENTRY.FUpPrice}价格系数${FPOORDERENTRY.FPriceCoefficient}价格下限${FPOORDERENTRY.FDownPrice}${FPOORDERENTRY.FPRILSTENTRYID}价税合计${FPOORDERENTRY.FAllAmount}${FPOORDERENTRY.FAllAmount_LC}交货地点${FPOORDERENTRY.FLocationId}${FPOORDERENTRY.FLocationId.FName}${FPOORDERENTRY.FLocationId.FNumber}交货地点${FPOORDERENTRY.FLocation}交货地址${FPOORDERENTRY.FLocationAddress}供应商协同平台订单分录ID(6.1废弃)关联应付数量(计价基本)关联应付数量（库存基本)基本单位_名称基本单位_编码集中结算组织(6.0废弃)集中结算组织(6.0废弃)_名称集中结算组织(6.0废弃)_编码计价单位_名称计价单位_编码加工商_名称加工商_编码价目表分录id价税合计(本位币)交货地点_名称交货地点_编码交货库存状态${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.FSTOCKJOINBASEQTY}库存基本分母${FPOORDERENTRY.FStockBaseDen}库存基本数量${FPOORDERENTRY.FStockBaseQty}库存可退数量${FPOORDERENTRY.FSTOCKRETQTY}${FPOORDERENTRY.FBASESTOCKRETQTY}${FPOORDERENTRY.FPayAmount}累计检验退料并扣款数量（基本）${FPOORDERENTRY.FBASECHECKCUTPAYQTY}累计入库数量${FPOORDERENTRY.FStockInQty}${FPOORDERENTRY.FBASESTOCKINQTY}${FPOORDERENTRY.FSTOCKBASESTOCKINQTY}累计收料数量${FPOORDERENTRY.FReceiveQty}${FPOORDERENTRY.FBASERECEIVEQTY}交货库存状态_名称交货库存状态_编码交货上限(基本单位)交货下限(基本单位)结算方式_名称结算方式_编码结算组织_名称结算组织_编码金额(本位币)库存单位_名称库存单位_编码库存关联数量(基本单位)库存可退数量(基本单位)累计付款金额(已废弃)累计入库数量(基本)累计入库数量(库存基本)累计收料数量(基本)累计退料数量${FPOORDERENTRY.FMrbQty}${FPOORDERENTRY.FBASEMRBQTY}${FPOORDERENTRY.FSUMACCRATE}累计验收金额${FPOORDERENTRY.FSUMACCALLAMOUNT}${FPOORDERENTRY.FCOPYENTRYID}零售条形码${FPOORDERENTRY.FBarcode}配额生成${FPOORDERENTRY.FIsQuota}批号${FPOORDERENTRY.FLot}${FPOORDERENTRY.FLot.FName}${FPOORDERENTRY.FLot.FNumber}剩余入库数量${FPOORDERENTRY.FRemainStockINQty}剩余收料数量${FPOORDERENTRY.FRemainReceiveQty}是否可库存${FPOORDERENTRY.FIsStock}是否赠品${FPOORDERENTRY.FGiveAway}收货门店${FPOORDERENTRY.FBranchId}${FPOORDERENTRY.FBranchId.FName}${FPOORDERENTRY.FBranchId.FNumber}${FPOORDERENTRY.FBranchId.FImageFile}${FPOORDERENTRY.FBranchId.FImageFileServer}收料部门${FPOORDERENTRY.FReceiveDeptId}${FPOORDERENTRY.FReceiveDeptId.FName}${FPOORDERENTRY.FReceiveDeptId.FNumber}收料可退数量${FPOORDERENTRY.FCHECKRETQTY}${FPOORDERENTRY.FBASECHECKRETQTY}收料组织${FPOORDERENTRY.FReceiveOrgId}${FPOORDERENTRY.FReceiveOrgId.FName}${FPOORDERENTRY.FReceiveOrgId.FNumber}税额${FPOORDERENTRY.FEntryTaxAmount}${FPOORDERENTRY.FTaxAmount_LC}${FPOORDERENTRY.FEntryTaxRate}税组合${FPOORDERENTRY.FTaxCombination}${FPOORDERENTRY.FTaxCombination.FName}${FPOORDERENTRY.FTaxCombination.FNumber}尾差处理标识${FPOORDERENTRY.FTailDiffFlag}委外产品类型${FPOORDERENTRY.FProductType}委外组织${FPOORDERENTRY.FSubOrgId}${FPOORDERENTRY.FSubOrgId.FName}累计退料数量(基本)累计验收比例%联副产品分录id批号_名称批号_编码收货门店_名称收货门店_编码收货门店_图片(文件服务器)收货门店_门店图片收料部门_名称收料部门_编码收料可退数量(基本单位)收料组织_名称收料组织_编码税额(本位币)税率%税组合_名称税组合_编码委外组织_名称${FPOORDERENTRY.FSubOrgId.FNumber}我方承担样本破坏基本数量${FPOORDERENTRY.FSAMPLEDAMAGEBASEQTY}物料版本${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.FStockBaseSalJoinQty}销售基本数量${FPOORDERENTRY.FSalBaseQty}销售数量${FPOORDERENTRY.FSalQty}携带的主业务单位${FPOORDERENTRY.FSRCBIZUNITID}${FPOORDERENTRY.FSRCBIZUNITID.FName}${FPOORDERENTRY.FSRCBIZUNITID.FNumber}需求部门${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.FMRPFreezeStatus}业务关闭${FPOORDERENTRY.FMRPCloseStatus}业务流程${FPOORDERENTRY.FBFLowId}业务终止${FPOORDERENTRY.FMRPTerminateStatus}应付金额${FPOORDERENTRY.FInvoiceAmount}应付数量${FPOORDERENTRY.FInvoiceQty}源单编号${FPOORDERENTRY.FSrcBillNo}源单类型${FPOORDERENTRY.FSrcBillTypeId}允许库存${FPOORDERENTRY.FIsInventory}折扣额${FPOORDERENTRY.FEntryDiscount}${FPOORDERENTRY.FEntryDiscountRate}整单折扣分摊${FPOORDERENTRY.FBillDisApportion}终止人${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}需求人_名称需求人_编码需求人_照片需求组织_名称需求组织_编码折扣率%终止人_名称终止人_编码终止人_签名图片终止人_人脸采集最低报价(6.1废弃)最高报价(6.1废弃)子单据体.交货明细${FENTRYDELIVERYPLAN.FPlanUnitID.FName}${FENTRYDELIVERYPLAN.FPlanUnitID.FNumber}计划基本单位${FENTRYDELIVERYPLAN.FPlanBaseUnitID}${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.FDeliRemainQty}剩余数量（基本单位）${FENTRYDELIVERYPLAN.FBaseDeliRemainQty}数量${FEntryDeliveryPlan.FPlanQty}数量（基本单位）${FENTRYDELIVERYPLAN.FBasePlanQty}已交货数量${FEntryDeliveryPlan.FDeliCommitQty}已交货数量（基本单位）${FENTRYDELIVERYPLAN.FBaseDeliCommitQty}预计到货日期${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.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}预付单号${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}ContactId}ContactId.FName}ContactId.FCONTACTNUMBER}Id.FNumber}FUserAccount}FFaceImg}rId.FName}rId.FUserAccount}rId.Fsignet}rId.FFaceImg}Id.FUserAccount}Id.Fsignet}Id.FFaceImg}cationOperator}pplierId.FName}pplierId.FNumber}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}NTBOMID.FName}NTBOMID.FNumber}NTMATID.FName}NTMATID.FNumber}NTMATID.FImage1}NTMATID.FImageFileServer}NTMATID.FImgFile_CMK}yPayOrgId}yPayOrgId.FName}yPayOrgId.FNumber}rderEntryId}APJoinQty}kBaseAPJoinQty}UnitId.FName}UnitId.FNumber}SettleOrgId}SettleOrgId.FName}SettleOrgId.FNumber}eUnitId.FName}eUnitId.FNumber}esser.FName}esser.FNumber}eCoefficient}STENTRYID}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}KJOINBASEQTY}STOCKRETQTY}CHECKCUTPAYQTY}STOCKINQTY}KBASESTOCKINQTY}RECEIVEQTY}CCALLAMOUNT}inStockINQty}inReceiveQty}chId.FName}chId.FNumber}chId.FImageFile}chId.FImageFileServer}iveDeptId}iveDeptId.FName}iveDeptId.FNumber}CHECKRETQTY}iveOrgId.FName}iveOrgId.FNumber}yTaxAmount}ombination}ombination.FName}ombination.FNumber}rgId.FName}rgId.FNumber}LEDAMAGEBASEQTY}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}kBaseSalJoinQty}IZUNITID.FName}IZUNITID.FNumber}ireDeptId}ireDeptId.FName}ireDeptId.FNumber}NDBILLENTRYID}NDBILLENTRYSEQ}ireStaffId}ireStaffId.FName}ireStaffId.FStaffNumber}ireStaffId.FPhoto}ireOrgId.FName}ireOrgId.FNumber}reezeStatus}loseStatus}erminateStatus}iceAmount}illTypeId}yDiscount}yDiscountRate}DisApportion}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}FDeliRemainQty}FBaseDeliRemainQty}FBasePlanQty}FDeliCommitQty}FBaseDeliCommitQty}FPREARRIVALDATE}FCostPercent}FCostAmount}FBuyerWithholding}FSellerWithholding}FTaxAmount}FTaxRate}FTaxRateId}FTaxRateId.FName}FTaxRateId.FNumber}HASEORDERNO}repaidAmount}uxPropId.FOPCODE}uxPropId.FF100002}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模板打印，从入门到精通原文链接：https://vip.kingdee.com/article/162160327596484864欢迎使用Excel模板打印！总体说明：Excel模板打印是一种使用Excel文件作为模板的打印方式，利用Excel软件的排版样式、单元格属性及内置新建的Excel模板文件默认由4个页签组成：以采购订单为例，文件的4个页签按顺序分别是PUR_PurchaseOrder、EntryFil1、模板页签用户只需对模板页签（即第一个页签）进行编辑打印模板，字段关键字请参考DataSource页签。注意事项：不允许修改和调整此页签名及放置位置，否则程序将无法正确解析模板文件！2、EntryFilters——单据体过滤条件页签支持表体按过滤条件设置进行打印，详情请参考EntryFilters页签说明。3、DataSource——数据源页签罗列了单据上所有字段对应的关键字，其格式为${实体标识.字段标识}。如果发现缺少某个字段的关键字，请打开【BOS设计器】-勾选字段的【功能控制】-【允许引出】，再重新建一份模板，即可4、Instructions——使用说明页签用于展示Excel模板打印的使用说明。下面是Excel模板样式设计说明（以采购订单为例）：1、基础资料属性的打印应用场景：需打印订单物料的助记码、规格型号模板设置方法：在基础资料物料编号关键字的字段标识后面以“.”为分隔符，追加属性关键字即可举例：${FPOORDERENTRY.FMaterialId.FMnemonicCode}——打印物料助记码${FPOORDERENTRY.FMaterialId.FImageFileServer}——打印物料图片2、显示字段多语言的打印应用场景：在简体环境下，采购订单上的供应商打印显示为英文供应商名称模板设置方法：在字段关键字后加上语言标识即可语言说明：${关键字.CN}——中文${关键字.US}——英文${关键字.HK}——繁体举例：${FBillHead.FSupplierId.US}—简体环境下显示英文供应商名称3、条码打印应用场景：需要将采购订单的物料编码以条码样式打印出来，以便快速扫描入单模板设置方法：打印普通条形码格式：${关键字||BarCode_条码编码}，支持的编码类型参考套打的普通条形码打印高级条形码格式：${关键字||AdvBarCode_条码编码}，支持的编码类型参考套打的高级条形码举例：${FPOORDERENTRY.FMaterialId||BarCode_Code128}——将物料代码打印为Code128条码样式${FPOORDERENTRY.FMaterialId||AdvBarCode_DataMatrix}——将物料代码打印为DataMatrix条码样式4、多字段合并生成条码打印应用场景：将物料代码和采购数量在同一个单元格合并到一起生成条码打印模板设置方法：只需将多个关键字合并到一个单元格加上||BarCode_编码或||AdvBarCode_编码即可举例：${FPOORDERENTRY.FMaterialId}${FPOORDERENTRY.FQty}||BarCode_Code128——将物料编码和采购数量合并一起生成5、单据体分组打印应用场景：对采购订单物料代码分组后打印，相同的为一组显示出来模板设置方法：在单据体字段关键字行上一行添加分组标识${Group_Begin}代表分组开始，单据体字段关键字下一行添加${Group_End}代举例：物料代码物料名称${Group_Begin}${FPOORDERENTRY.FMaterialId.FNumber||Group}${FPOORDERENTRY.FMaterialId.FName||Group}${Group_End}——表示对物料编码和物料名称分组打印6、分组打印合并分组字段应用场景：单据体有多个物料，按物料名称分组后，相同的物料名称只显示一个模板设置方法：按单据体分组打印设置后，在对应的分组字段关键字后面加上||Merge，即可将分组后的多行数据合并举例：${FPOORDERENTRY.FMaterialId.FName||Group||Merge}7、单据体统计打印应用场景：对采购订单物料数量求和汇总打印模板设置方法：利用Excel内置函数来实现假设数量字段所在列是K19，则在K21单元格设置求和公式=SUM(K19:K20)即可，同理求平均值用=AVERAGE(K19:K20)等举例：如上8、页眉页脚使用字段关键字打印应用场景：设置采购订单打印时，显示当前第几页，共几页模板设置方法：利用Excel自带的页眉页脚功能点菜单-插入-页眉/页脚，分别设置页眉、页脚9、多字段合并打印应用场景：需要将物料名称和助记码放在同一个单元格中打印显示模板设置方法：只需将物料名称和助记码关键字放到同一个单元格中即可举例：${FPOORDERENTRY.FModel}${FPOORDERENTRY.FMaterialId.FMnemonicCode}——将物料名称和助记码放到同一个单元格说明：也允许1个字段关键字在1个单元格内设置多次。10、父子单据体嵌套打印应用场景：比如采购订单的明细信息和交货安排放到同一个表格中打印，一条明细信息分录数据对应多条交货安排分录数据模板设置方法：将两个单据体要打印的关键字放在同一行即可举例：物料名称交货日期A11${FPOORDERENTRY.FMaterialName}B11${FENTRYDELIVERYPLAN.FDeliveryDate_Plan}11、父子单据体嵌套打印，取消合并单元格应用场景：父子单据体嵌套打印，如果父单据体的分录数据超过1行，默认会将父单据体的分录数据合并成一行，希望原样打模板设置方法：在父单据体关键字后面添加||NotMerge举例：${FPOORDERENTRY.FMaterialName||NotMerge}12、行列转换，单据体分录数据按列打印应用场景：每一行单据体分录数据，打印成一列模板设置方法：在单据体关键字后面添加||Transpose举例：物料编码${FPOORDERENTRY.FMaterialId||Transpose}物料名称${FPOORDERENTRY.FMaterialName||Transpose}单价${FPOORDERENTRY.FPrice||Transpose}金额${FPOORDERENTRY.FEntryAmount||Transpose}13、设置分页打印，即每个单据体打印固定行数分页打印参数：${Paging||以下参数1||以下参数2||...}1、单据体每页打印行数：EachPage_行数2、不足行数是否填充空白行FillEmptyRow_True/FalseTrue:填充空白行False:不填充空白行默认为填充3、每页之间间隔Divider_EmptyRow_行数：每页之间设置N行空白行Divider_RowBreak：每页之间分页打印启用分页打印示例：1、${Paging}解析：设置分页打印，没有设置参数，默认每页打印5行，默认最后一页行数不足自动填充空白行，默认每页之间不设置间隔2、${Paging||EachPage_3||FillEmptyRow_True||Divider_RowBreak}解析：设置分页打印，每页打印3行，最后一页不满3行则填充空白行至3行，每页之间设置分页符3、${Paging||EachPage_3||FillEmptyRow_False||Divider_EmptyRow_3}解析：设置分页打印，每页打印3行，最后一页不满3行不填充空白行，每页之间设置3行空白行说明：请将分页打印标识放到设计模板的最后一行，切勿在分页打印标识所在的行设置其他数据。
