审核日期日期编号事务类型单据号######AdministrCHG000003Administrator4117059003TEST######AdministrCHG000004Administrator4117060003TEST制单人_FName审核人_FName制单机构_FNumber制单机构_FName验收_FNumber验收_FName源单类型打印次数003TEST001成本调拨4330003TEST001成本调拨4330保管_FNumber保管_FName部门_FNumber部门_FName业务员_FNumber业务员_FName调拨类型_FID调拨类型_FName调拨类型_FTypeID序列号内码订单号订单行号行号001CHG0000034100.0001001CHG0000044100.0001002CHG0000044100.0002订单内码_FBillno单据号_FBillno单据号_FTrantype物料代码_FNumber物料代码_FName物料代码_FModel辅助属性_FNumberA原材料A原材料B原材料基本缺省调批号基本调入仓缺省调拨数调入仓库存数量单位成本*00PCSPCS0010*00PCSPCS0010*00PCSPCS0020辅助属性_FName辅助属性_FClassName单位_FNumber单位_FName基本单位数成本调拨单价调拨金额备注计划单价计划价金额有效期至100000001.01100000001.01200000001.01生产/采购日期保质期(天)调出仓库_FNumber换算率辅助数量源单单号源单类型原料仓01.03不良仓000原料仓01.03不良仓000原料仓01.03不良仓000调出仓库_FName调出仓位_FName调出仓位_FGroupName调入仓库_FNumber调入仓库_FName调入仓位_FName调入仓位_FGroupName源单内码源单分录任务单内码投料单分录计划跟踪号0000MTS606Y是0000MTS606Y是0000MTS606Y是生产/委外订单号计划模式_FID计划模式_FName计划模式_FTypeID检验是否良品_FID检验是否良品_FNameMTS计划模式MTS计划模式MTS计划模式锁库标志客户订单行客户订单号244002440024400检验是否良品_FTypeID是否VMI_FID是否VMI_FName是否VMI_FTypeID供应商_FNumber供应商_FName保质期单据号_FBillno单据号_FTrantype仓库_FNumber仓库_FName仓位_FName仓位_FGroupName调出仓库_FNumber调出仓库_FName调出仓位_FName调出仓位_FGroupName批号生产采购日是否有效辅助属性_FNumber辅助属性_FName辅助属性_FClassName供应商_FNumber供应商_FName物料_FNumber物料_FName物料_FModel序列号状态最后单据类别序列号ID序列号规则ID最后SNListIDFTypeFKeyFFieldNamFCaptionFValueTypFNeedSaveFColIndexFSrcTableFSrcFieldFExpFieldFImpFieldClassInfoClassTypeK3BillClassInfoClassTypeID41ClassInfoLanguageIDCHSPageInfoPage1Page1FieldInfoFCheckDatFCheckDat审核日期datetime-16FieldInfoFdateFDate日期datetime-8FieldInfoFBillerIDFBillerID制单人nvarchar(255)-7T_userFUserIDFNameFNameFieldInfoFBillNoFBillno编号nvarchar(255)-6FieldInfoFCheckerIFCheckerI审核人nvarchar(255)-5T_userFUserIDFNameFNameFieldInfoFBrIDFBrID制单机构nvarchar(255)-4t_SonCompFItemIDFNumber+FFNumber+FNameFieldInfoFTranTypeFTranType事务类型nvarchar(255)-2FieldInfoFInterIDFInterID单据号nvarchar(255)-1FieldInfoFFManagerFFManager验收nvarchar(255)4t_EmpFItemIDFNumber+FFNumber+FNameFieldInfoFSManagerFSManager保管nvarchar(255)5t_EmpFItemIDFNumber+FFNumber+FNameFieldInfoFSelTranTFSelTranT源单类型nvarchar(255)6FieldInfoFDeptIDFDeptID部门nvarchar(255)8t_DepartmFItemIDFNumber+FFNumber+FNameFieldInfoFEmpIDFEmpID业务员nvarchar(255)9t_EmpFItemIDFNumber+FFNumber+FNameFieldInfoFRefTypeFRefType调拨类型nvarchar(255)10t_SubMessFInterIDFID+FNameFID+FTypeIDFieldInfoFPrintCouFPrintCou打印次数decimal(28,10)11PageInfoPage2Page2FieldInfoFSNListIDFSNListID序列号内码decimal(28,10)-9FieldInfoFOrderBilFOrderBil订单号nvarchar(255)-5FieldInfoFOrderEntFOrderEnt订单行号nvarchar(255)-4FieldInfoFOrderIntFOrderInt订单内码nvarchar(255)-3POOrderFInterIDFBillnoFBillnoFieldInfoFEntryIDFEntryID行号nvarchar(255)-2FieldInfoFInterIDFInterID单据号nvarchar(255)-1ICStockBiFInterIDFBillno+FFBillno+FTrantypeFieldInfoFItemIDFItemID物料代码nvarchar(255)1t_ICItemFItemIDFNumber+FFNumber+FName+FModFieldInfoFAuxPropIFAuxPropI辅助属性nvarchar(255)2(SELECTtFItemIDFNumber+FFNumber+FName+FClaFieldInfoFDefaultBFDefaultB基本缺省调decimal(28,10)3FieldInfoFBatchNoFBatchNo批号nvarchar(255)4FieldInfoFRealStocFRealStoc基本调入仓decimal(28,10)5FieldInfoFUnitIDFUnitID单位nvarchar(255)6(selecttFItemIDFNumber+FFNumber+FNameFieldInfoFDefaultQFDefaultQ缺省调拨数decimal(28,10)7FieldInfoFRealStocFRealStoc调入仓库存decimal(28,10)8FieldInfoFauxqtyFauxqty数量decimal(28,10)9FieldInfoFauxpriceFauxprice单位成本decimal(28,10)10FieldInfoFQtyFQty基本单位数decimal(28,10)11FieldInfoFamountFamount成本decimal(28,10)12FieldInfoFAuxPriceFAuxPrice调拨单价decimal(28,10)13FieldInfoFAmtRefFAmtRef调拨金额decimal(28,10)14FieldInfoFnoteFnote备注nvarchar(255)15FieldInfoFAuxPlanPFAuxPlanP计划单价decimal(28,10)16FieldInfoFPlanAmouFPlanAmou计划价金额decimal(28,10)17FieldInfoFKFDateFKFDatedatetime18FieldInfoFKFPeriodFKFPerioddecimal(28,10)19FieldInfoFPeriodDaFPeriodDa有效期至datetime20FieldInfoFSCStockIFSCStockI调出仓库nvarchar(255)21t_StockFItemIDFNumber+FFNumber+FNameFieldInfoFSCSPIDFSCSPID调出仓位nvarchar(255)22(selecttFSPIDFName+FGrFName+FGroupNameFieldInfoFDCStockIFDCStockI调入仓库nvarchar(255)23t_StockFItemIDFNumber+FFNumber+FNameFieldInfoFDCSPIDFDCSPID调入仓位nvarchar(255)24(selecttFSPIDFName+FGrFName+FGroupNameFieldInfoFSecCoeffFSecCoeff换算率decimal(28,10)26FieldInfoFSecQtyFSecQty辅助数量decimal(28,10)27FieldInfoFSourceBiFSourceBi源单单号nvarchar(255)28生产/采购日期保质期(天)FieldInfoFSourceTrFSourceTr源单类型decimal(28,10)29FieldInfoFSourceInFSourceIn源单内码decimal(28,10)30FieldInfoFSourceEnFSourceEn源单分录decimal(28,10)31FieldInfoFICMOBillFICMOBillnvarchar(255)32FieldInfoFICMOInteFICMOInte任务单内码decimal(28,10)33FieldInfoFPPBomEntFPPBomEnt投料单分录decimal(28,10)34FieldInfoFPlanModeFPlanMode计划模式nvarchar(255)38t_SubMessFInterIDFID+FNameFID+FTypeIDFieldInfoFMTONoFMTONo计划跟踪号nvarchar(255)39FieldInfoFChkPassIFChkPassI检验是否良nvarchar(255)40t_SubMessFInterIDFID+FNameFID+FTypeIDFieldInfoFIsVMIFIsVMInvarchar(255)41t_SubMessFInterIDFID+FNameFID+FTypeIDFieldInfoFEntrySupFEntrySup供应商nvarchar(255)42t_SupplieFItemIDFNumber+FFNumber+FNameFieldInfoFLockFlagFLockFlag锁库标志decimal(28,10)43FieldInfoFClientEnFClientEn客户订单行nvarchar(255)44FieldInfoFClientOrFClientOr客户订单号nvarchar(255)45PageInfoPage3Page3FieldInfoFInterIDFInterID单据号nvarchar(255)-1ICStockBiFInterIDFBillno+FFBillno+FTrantypeFieldInfoFKFPeriodFKFPeriod保质期nvarchar(255)1FieldInfoFStockIDFStockID仓库nvarchar(255)2t_StockFItemIDFNumber+FFNumber+FNameFieldInfoFStockPlaFStockPla仓位nvarchar(255)3(selecttFSPIDFName+FGrFName+FGroupNameFieldInfoFOutStockFOutStock调出仓库nvarchar(255)4t_StockFItemIDFNumber+FFNumber+FNameFieldInfoFOutStockFOutStock调出仓位nvarchar(255)5(selecttFSPIDFName+FGrFName+FGroupNameFieldInfoFAuxPropIFAuxPropI辅助属性nvarchar(255)6(SELECTtFItemIDFNumber+FFNumber+FName+FClaFieldInfoFSupplyIDFSupplyID供应商nvarchar(255)7t_SupplieFItemIDFNumber+FFNumber+FNameFieldInfoFBatchNOFBatchNO批号nvarchar(255)8FieldInfoFKFDateFKFDate生产采购日nvarchar(255)9FieldInfoFValidFValid是否有效nvarchar(255)10FieldInfoFItemIDFItemID物料nvarchar(255)11t_ICItemFItemIDFNumber+FFNumber+FName+FModFieldInfoFSerialNuFSerialNu序列号nvarchar(255)12FieldInfoFSerialIDFSerialIDnvarchar(255)13FieldInfoFSerialClFSerialClnvarchar(255)14FieldInfoFstatusFstatus状态nvarchar(255)15FieldInfoFSNListIDFSNListIDnvarchar(255)16FieldInfoFtranTypeFtranType最后单据类nvarchar(255)17生产/委外订单号是否VMI序列号ID序列号规则ID最后SNListIDFDefaultVFSearchFItemPageFTrueTypeFPrecisioFSearchNaFIsShownLFViewMaskFPage000001000001000001000001000001FNumber+FName000001000001000001FNumber+FName000001FNumber+FName000001000001FNumber+FName000001FNumber+FName000001FID+FTypeID000001000001000002000002000002000002000002FBillno+FTrantype000002FNumber+FName+FMod000002FNumber+FName+FCla000002000002000002000002FNumber+FName000002000002000002000002000002000002000002000002000002000002000002000002000002000002000002FNumber+FName000002FName+FGroupName000002FNumber+FName000002FName+FGroupName000002000002000002000002000002000002000002000002000002000002FID+FTypeID000002000002FID+FTypeID000002FID+FTypeID000002FNumber+FName000002000002000002000002FBillno+FTrantype000003000003FNumber+FName000003FName+FGroupName000003FNumber+FName000003FName+FGroupName000003FNumber+FName+FCla000003FNumber+FName000003000003000003000003FNumber+FName+FMod000003000003000003000003000003000003000003
