GMP管理系统数据表(xls)(1)

返回总览GMP管理系统数据表序号表名表描述1ICClassGroupInfo偏差处理报告2GMPBatchPacket批包装指令分录3GMPStockOutTempHumi库房外温湿度记录4GMPStockOutTempHumiEntry库房外温湿度记录分录5GMPBatchPackLog包装记录6GMPBatchPackLogEntry包装记录分录7GMPCleanFieldLog清场记录8GMPCleanFieldLogEntry清场记录分录9GMPItemBalance包装材料物料平衡10GMPItemBalanceEntry包装材料物料平衡分录11GMPCleanRecord清洁记录12GMPMMWarpReport偏差处理报告分录13View_ICClassGroupInfo1001012批包装指令视图14View_ICClassGroupInfo1001017偏差处理报告视图15GMPCleanScheme清洁方案16GMPCleanSchemeEntry清洁方案分录17GMPStockMaintain库存养护记录18GMPStockMaintainEntry库存养护记录分录19GMPStockInTempHumi库房内温湿记录20GMPStockInTempHumiEntry库房内温湿记录分录21GMPCleanRecordEntry清洁记录分录22GMPRidScheme清场方案23GMPRidSchemeEntry清场方案分录24GMPOutScheme成品放行审核方案25GMPOutSchemeentry成品放行审核方案分录26GMPAuditBill成品放行审核单27GMPAuditBillEntry成品放行审核单分录28GMPNoteDestoryLog标签销毁记录29GMPNoteDestoryLogEntry标签销毁记录分录30GMPBoxUnitNoteinfo合箱管理记录31GMPBoxUnitNote合箱管理记录分录32QMCollectRate物料平衡收率表33QMCollectRateEntry物料平衡收率表分录34GMPItemScrap报损审批单35GMPItemScrapEntry报损审批单分录36GMPItemDestroy报损销毁记录37GMPItemDestroyEntry报损销毁记录分录38GMPOperationProj操作记录方案39GMPOperationProjEntry操作记录方案分录40GMPProcOper工序操作记录41GMPProcOperEntry1工序操作记录分录42View_GMPCleanScheme清洁方案视图43View_GMPStockMaintain库存养护记录视图44View_GMPStockInTempHumi库房内温湿记录视图45View_GMPStockOutTempHumi库房外温湿度记录视图46View_GMPBatchPackLog包装记录视图47View_GMPCleanFieldLog清场记录视图48View_GMPItemBalance包装材料物料平衡视图49View_GMPCleanRecord清洁记录视图50View_GMPRidScheme清场方案视图51View_GMPOutScheme成品放行审核方案视图52View_GMPAuditBill成品放行审核单视图53View_GMPNoteDestoryLog标签销毁记录视图54View_GMPBoxUnitNoteinfo合箱管理记录视图55View_QMCollectRate物料平衡收率表视图56View_GMPItemScrap报损审批单视图57View_GMPItemDestroy报损销毁记录视图58View_GMPOperationProj操作记录方案视图59View_GMPProcOper工序操作记录视图60GMPOrgCard客户证照维护61GMPSupCard供应商证照维护返回GMP管理系统目录表结构字段名类型描述FDetailINTEGER是否明细FClassTypeIDINTEGER类别FDiscontinuedINTEGERFFullNumberSTRINGFIDINTEGER内码FLevelsINTEGERFLogicINTEGER菜单控制FNameSTRING名称FNumberSTRING代码FParentIDINTEGER父级内码键表键名类型PK_ICClassGroupInfo主键索引表索引名字段PK_ICClassGroupInfoFID触发器表触发器名描述返回GMP管理系统目录表结构字段名类型描述FBomNameSTRINGBOM编号FBatchNoSTRING批号FBillComeFromSTRING单据来源FBillNoSTRING单据编号FQtyFLOAT计划包装数量FBillStatusSTRING单据状态FContainerCountFLOAT散装容器数FDiscardAmountFLOAT报废数FMoBillNoSTRING生产任务单FPacketAmountFLOAT实际包装数量FRouteIDINTEGER工艺路线FBillerIDINTEGER制单人FReleaseIDINTEGER下达人FPlanCommitDateDATETIME计划开工日期FBomNumberINTEGERFCommitDateDATETIME单据下达日期FWorkShopINTEGER生产车间FCostObjIDINTEGER成本对象FDiscontinuedINTEGERFFullNumberSTRINGFIDINTEGER内码FincomeRateINTEGERFItemBalRateINTEGERFitemIDINTEGER物料代码FLevelsINTEGERFLogicINTEGER菜单控制FMemoSTRING备注FMoBillNoIDINTEGERFMoBillNoIDFPlanFinishDateDATETIME计划完工日期FUnAmountFLOAT未包装数量FCreateDTDATETIME制单日期FNameSTRING名称FNumberSTRING代码键表键名类型PK__GMPBatchPacket__6D8F833D主键索引表索引名字段PK__GMPBatchPacket__6D8F833DFID触发器表触发器名描述返回GMP管理系统目录表结构字段名类型描述FClassTypeIDINTEGER事务类型FIDINTEGER内码键表键名类型PK__GMPStockOutTempH__04DCFCE9主键索引表索引名字段PK__GMPStockOutTempH__04DCFCE9FID触发器表触发器名描述返回GMP管理系统目录表结构字段名类型描述FDateDATETIME制单日期FMaxTempFLOAT日最高温度(℃)FPMHumiFLOAT下午自然湿度(%)FRecordDateDATETIME记录日期FAMHumiFLOAT上午自然湿度(%)FAMTempFLOAT上午自然温度(℃)FBillerIDINTEGER制单人FEntryIDINTEGER分录内码FIDINTEGER内码FMinTempFLOAT日最低温度(℃)FPMTempFLOAT下午自然温度(℃)FRecorderIDINTEGER记录人FStockIDINTEGER仓库代码FBillNoSTRING记录编号FIndexINTEGER行号键表键名类型PK__GMPStockOutTempH__08AD8DCD主键索引表索引名字段PK__GMPStockOutTempH__08AD8DCDFEntryIDIX_GMPStockOutTempHumiEntryFID触发器表触发器名描述返回GMP管理系统目录表结构字段名类型描述FBillDTDATETIME制单日期FCheckDateDATETIME审核日期FFProductRateFLOAT成品率%FItemBalanceFLOAT物料平衡%FPackEndDtDATETIME包装结束日期FPackStartDTDATETIME包装开始日期FStockInQtyFLOAT入库数FBatchBillNoSTRING批包装指令单FBatchBillNoIDINTEGER批包装指令IDFBatchInterIDINTEGERFBatchNoSTRING批号FBillerIDINTEGER制单FBillNoSTRING编号FBulkQtyFLOAT散装容器数FCheckerIDINTEGER审核FClassTypeIDINTEGER事务类型FDiscardAmountFLOAT报废数FGetItemNoSTRING领料单号FIDINTEGER内码FItemIDINTEGER产品代码FPackageQtyFLOAT包装数量FPreCleanLogSTRING前次清场记录单号FSimpleQtyFLOAT取样数FThisCleanlogSTRING本次清场记录单号FTotalQtyFLOAT计划包装数量FUnPackageQtyFLOAT未包装数量键表键名类型PK__GMPBatchPackLog__08437979主键索引表索引名字段PK__GMPBatchPackLog__08437979FID触发器表触发器名描述返回GMP管理系统目录表结构字段名类型描述FCheckIDINTEGER核对人FErrorQtyFLOAT损毁数FMemoSTRING备注FOperateIDINTEGER操作人FPackBatchNoSTRING批号FPackItemIDINTEGER包材代码FRemainQtyFLOAT剩余数FTakeQtyFLOAT领用数FTakerIDINTEGER领用人FUseQtyFLOAT使用数FDistributeIDINTEGER发放人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FOperOrderSTRING操作指令FPackItemModelSTRING规格型号FPackItemNameSTRING包材名称FPackItemUnitSTRING基本单位键表键名类型PK__GMPBatchPackLogE__1E32BA98主键索引表索引名字段PK__GMPBatchPackLogE__1E32BA98FEntryIDIX_GMPBatchPackLogEntryFID触发器表触发器名描述返回GMP管理系统目录表结构字段名类型描述FCleanDTDATETIME清场日期FBatchNoSTRING接续批号FBillerIDINTEGER制单FRouteIDINTEGER工艺路线FBillNoSTRING单据编号FCheckDateDATETIME审核日期FCheckerIDINTEGER审核FClassTypeIDSTRING事务类型FQtyFLOAT数量FCleanMonitorIDINTEGER清场班长FCleanTypeIDINTEGER清场类型FConclusionINTEGER结论FCreateDTDATETIME制单日期FIDINTEGER内码FMemoSTRING备注FModelSTRINGFNextItemIDINTEGER接续产品代码FNextItemNameSTRINGFPreBatchNoSTRING前场批号FPreItemIDINTEGERFPreItemNumberSTRING产品名称FPreModelSTRINGFPreQtyFLOAT数量FProcedureIDINTEGER工序FProjectIDINTEGERFProjectIDFProjectNameSTRING清场方案FQACheckerIDINTEGERQA检查人FQACheckResultSTRINGQA检查结果键表键名类型PK__GMPCleanFieldLog__5A7CAEC9主键索引表索引名字段PK__GMPCleanFieldLog