电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

金蝶云星空-xrl_一页显示一条物料信息模板.xlsx

金蝶云星空-xrl_一页显示一条物料信息模板.xlsx_第1页
1/29
金蝶云星空-xrl_一页显示一条物料信息模板.xlsx_第2页
2/29
金蝶云星空-xrl_一页显示一条物料信息模板.xlsx_第3页
3/29
采购订单${FBillHead.FBi${FBillHead.FSu${FBillHead.FPurchaserId}${FBillHead.FBu${FBillHead.FPurchaseOrgId}${FBillHead.FBi${FBillHead.FPu${FBillHead.FChangeReason}${FBillHead.FDa${FBillHead.FPurchaserGroupId}${FBillHead.FACCTYPE}物料编码物料名称采购单位采购数量${FPOORDERENTRY.FMaterialId}${FPOORDERENTRY.FMaterialName}${FPOORDERENTRY.FUnitId}${FPOORDERENTRY.FQty}交货日期计划单位数量${FENTRYDELIVERYPLAN.FDeliveryDate_Plan}${FENTRYDELIVERYPLAN.FPlanUnitID}${FEntryDeliveryPlan.FPlanQty}${Paging||EachPage_1||FillEmptyRow_false||Divider_RowBreak}单据类型:供应商:采购员:业务类型:采购组织:单据编号:采购部门:变更原因:采购日期:采购组:验收方式:说明单据体.订单条款单据体.明细信息子单据体.交货明细子单据体.税务明细单据体.付款计划子单据体.付款计划子单据体子单据体.关联关系表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.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.FCloserId}${FBillHead.FCloserId.FName}${FBillHead.FCloserId.FUserAccount}${FBillHead.FCloserId.Fsignet}${FBillHead.FCloserId.FFaceImg}关闭日期${FBillHead.FCloseDate}结算方${FBillHead.FSettleId}${FBillHead.FSettleId.FName}${FBillHead.FSettleId.FNumber}确认人${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.FProviderPhone}修改变更操作${FBillHead.FIsModificationOperator}验收方式${FBillHead.FACCTYPE}业务类型${FBillHead.FBusinessType}职务${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}价外税${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}付款条件_名称付款条件_编码汇率类型_名称汇率类型_编码集中结算(6.0废弃)集中结算组织_名称集中结算组织_编码价目表_名称价目表_编码价税合计(本位币)结算币别_名称结算币别_编码结算方式_名称结算方式_编码金额(本位币)税额(本位币)预付单号_名称${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}备注${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}预付单号_编码折扣表_名称折扣表_编码单据体.订单条款条款编码_名称条款编码_编码单据体.明细信息BOM版本BOM版本_名称BOM版本_编码采购单位_名称采购单位_编码定价单位_名称定价单位_编码冻结人${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.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}冻结人_名称冻结人_编码冻结人_签名图片冻结人_人脸采集费用项目_名称费用项目_编码分录价目表_名称分录价目表_编码分散结算组织(6.0废弃)分散结算组织(6.0废弃)_名称分散结算组织(6.0废弃)_编码父项BOM版本父项BOM版本_名称父项BOM版本_编码父项产品_名称父项产品_编码父项产品_图片(数据库)父项产品_图片(文件服务器)父项产品_图片(文件服务器)付款组织_名称付款组织_编码合同单号${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.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}基本单位_名称基本单位_编码集中结算组织(6.0废弃)集中结算组织(6.0废弃)_名称集中结算组织(6.0废弃)_编码计价单位_名称计价单位_编码加工商_名称加工商_编码价税合计(本位币)交货地点_名称交货地点_编码交货库存状态_名称交货库存状态_编码交货上限(基本单位)交货下限${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.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.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.FTerminaterId}${FPOORDERENTRY.FTerminaterId.FName}${FPOORDERENTRY.FTerminaterId.FUserAccount}${FPOORDERENTRY.FTerminaterId.Fsignet}${FPOORDERENTRY.FTerminaterId.FFaceImg}终止日期${FPOORDERENTRY.FTerminateDate}组别${FPOORDERENTRY.FGroup}${FPOORDERENTRY.FMinPrice}销售单位_名称销售单位_编码需求部门_名称需求部门_编码需求人_名称需求人_编码需求人_照片需求组织_名称需求组织_编码折扣率%终止人_名称终止人_编码终止人_签名图片终止人_人脸采集最低报价(6.1废弃)${FPOORDERENTRY.FMaxPrice}最晚交货日期${FPOORDERENTRY.FDeliveryLastDate}最早交货日期${FPOORDERENTRY.FDeliveryEarlyDate}FEntryDeliveryPlan序号${FEntryDeliveryPlan.FSEQ}供应商发货日期${FENTRYDELIVERYPLAN.FSUPPLIERDELIVERYDATE}计划单位${FENTRYDELIVERYPLAN.FPlanUnitID}${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.FPlanQty}数量(基本单位)${FENTRYDELIVERYPLAN.FBasePlanQty}预计到货日期${FENTRYDELIVERYPLAN.FPREARRIVALDATE}运输提前期${FENTRYDELIVERYPLAN.FTRLT}FTaxDetailSubEntity序号${FTaxDetailSubEntity.FSeq}${FTaxDetailSubEntity.FCostPercent}计入成本金额${FTaxDetailSubEntity.FCostAmount}买方代扣代缴${FTaxDetailSubEntity.FBuyerWithholding}卖方代扣代缴${FTaxDetailSubEntity.FSellerWithholding}税额${FTaxDetailSubEntity.FTaxAmount}${FTaxDetailSubEntity.FTaxRate}最高报价(6.1废弃)子单据体.交货明细计划单位_名称计划单位_编码计划基本单位_名称计划基本单位_编码交货地点_名称交货地点_编码子单据体.税务明细计入成本比例%税率%税率名称${FTaxDetailSubEntity.FTaxRateId}${FTaxDetailSubEntity.FTaxRateId.FName}${FTaxDetailSubEntity.FTaxRateId.FNumber}增值税${FTaxDetailSubEntity.FVAT}FIinstallment序号${FIinstallment.FSeq}备注${FIINSTALLMENT.FRemarks}采购订单号${FIINSTALLMENT.FPURCHASEORDERNO}单次预付额度${FIINSTALLMENT.FInsPrepaidAmount}订单明细行内码${FIINSTALLMENT.FOrderEntryId}付款关联金额${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}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}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}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}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}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}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}

1、当您付费下载文档后,您只拥有了使用权限,并不意味着购买了版权,文档只能用于自身使用,不得用于其他商业用途(如 [转卖]进行直接盈利或[编辑后售卖]进行间接盈利)。
2、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。
3、如文档内容存在违规,或者侵犯商业秘密、侵犯著作权等,请点击“违规举报”。

碎片内容

金蝶云星空-xrl_一页显示一条物料信息模板.xlsx

确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信