质量管理系统数据表

返回总览质量管理系统数据表序号表名1View_OtherInspectionRequestSlip7172View_InventoryInspectionRequest7063View_OperationInspectionSlip7104View_GoodsReturnInspectionSlip7075View_DeliveryInspectionSlip7086View_InventoryInspectionSlip7097View_SubcontractInspectionRequest7038View_GoodsReturnInspectionRequest7049View_DeliveryInspectionRequest70510View_PurchaseInspectionSlip71111View_OtherInspectionSlip71212View_ProductInspectionSlip71313View_SubcontractInspectionSlip71414View_SubcontractOperationInspectionSlip71515ICQCScheme16ICQCSchemeEntry17QMICMOCKRequest18QMICMOCKRequestEntry19POInStock20POInStockEntry21QMSaleCkRequest22QMSaleCkRequestEntry23QMINQCReq24QMINQCReqEntry25ICSaleQcbill26ICSaleQcbillEntry27QMQCBill28QMQCBillEntry29ICQCBill30ICQCBillEntry31QMOtCkRequest32QMOtCkRequestEntry33ICClassGroupInfo34QMClientServiceLog35QMQualityAccident36QMReject37QMRejectEntry38QMSampStd39QMSampStdEntry40QMEvaProj41QMEvaProjEntry42QMQualityStd43QMQualityStdEntry44QMSupplyEva45QMSupplyEvaEntry46QMSampling47QMSamplingEntry48QMWatchLog49QMWatchLogEntry50QMItemSupplyInfo51QMItemSupplyInfoEntry52QMSampleDestroy53QMSampleDestroyEntry54View_ICQCScheme55View_ICClassGroupInfo100170156View_ICClassGroupInfo100170257View_QMReject58View_QMSampStd59View_QMEvaProj60View_QMQualityStd61View_QMSupplyEva62View_QMSampling63View_QMWatchLog64View_QMItemSupplyInfo65View_QMSampleDestroy66View_InspSchm8667View_ProductInspectionRequest70168View_PurchaseInspectionRequest702表描述其他检验申请单视图库存检验申请单视图工序检验单视图退货检验单视图发货检验单视图库存检验单视图委外加工检验申请单视图退货检验申请单视图发货检验申请单视图采购检验单视图其他检验单视图产品检验单视图委外加工检验单视图委外工序检验单视图质检方案质检方案分录产品、委外加工检验申请单产品、委外加工检验申请单分录采购检验申请单采购检验申请单分录发货、退货检验申请单发货、退货检验申请单分录库存检验申请单库存检验申请单分录发货、退货检验单发货、退货检验单分录库存检验单库存检验单分录采购、工序、产品、其它、委外加工、委外工序检验单采购、工序、产品、其它、委外加工、委外工序检验单分录其他检验申请单其他检验申请单分录质量事故记录客户投诉记录分录质量事故记录分录采购检验不良品处理单采购检验不良品处理单分录抽样标准抽样标准分录供应商评估方案供应商评估方案分录质量标准质量标准分录供应商评估表供应商评估表分录取样记录取样记录分录留样观察记录留样观察记录分录物料来源关系物料来源关系分录样品销毁记录样品销毁记录分录质检方案视图客户投诉记录视图质量事故记录视图采购检验不良品处理单视图抽样标准视图供应商评估方案视图质量标准视图供应商评估表视图取样记录视图留样观察记录视图物料来源关系视图样品销毁记录视图质检方案视图产品检验申请单视图采购检验申请单视图返回质量管理系统目录表结构字段名类型描述FAuxNotPassQtyFLOAT不合格数量FAuxPropIDNameSTRING辅助属性FCUUnitQtyNotPassFLOAT常用单位不合格数量FCUUnitQtyPassFLOAT常用单位合格数量FCUUnitSampleBreakQtyFLOAT常用单位样本破坏数量FdateDATETIME日期FAuxPropIDNumberSTRING辅助属性代码FauxqtyFLOAT数量FAuxQtyCheckFLOAT检验数量FAuxQtyPassFLOAT合格数量FEntryIDINTEGER分录内码FAuxRelateQtyFLOAT关联数量FBaseFQtyCheckFLOAT基本单位检验数量FInterIDINTEGER单据内码FBaseNotPassQtyFLOAT基本单位不合格数量FBaseQtyFLOAT基本单位数量FBaseQtyPassFLOAT基本单位合格数量FBaseSampleBreakQtyFLOAT基本单位样本破坏数量FPriceDecimalINTEGER单价精度FQtyDecimalINTEGER数量精度FRelateQtyFLOAT基本单位关联数量FBaseUnitIDSTRING基本单位FCheckerIDINTEGER审核人FCUQtyFLOAT常用单位数量FCUQtyCheckFLOAT常用单位检验数量FDCSPIDNameSTRING仓位FDepartmentNumberSTRING部门代码FDeptIDNameSTRING部门FEmpIDNameSTRING申请人FFullNumberSTRING物料长代码FFManagerIDNameSTRING主管FItemModelSTRING规格型号FAuxSampleBreakQtyFLOAT样本破坏数量FItemIDNumberSTRING物料代码FItemNameSTRING物料名称FNoteSTRING备注FStockIDNameSTRING仓库FReStatusSTRING关联标志FTranTypeINTEGER事务类型FBillNoEntryIDSTRING单据编号、分录内码FCheckSTRING审核标志FUnitIDNameSTRING单位FCheckerIDNameSTRING审核人FCloseSTRING关闭标志FBatchNoSTRING批号FBillerNameSTRING制单FBillNoSTRING单据编号FBillNoItemNumberSTRING单据编号、物料代码FCancellationSTRING作废标志键表键名类型索引表索引名字段触发器表触发器名描述返回质量管理系统目录表结构字段名类型描述FBilldateDATETIME制单日期FCheckdateDATETIME审核日期FAuxNotPassQtyFLOAT不合格数量FAuxSampleBreakQtyFLOAT样本破坏数量FBaseNotPassQtyFLOAT基本单位不合格数量FBaseQtyFLOAT基本单位数量FBaseSampleBreakQtyFLOAT基本单位样本破坏数量FCUUnitSampleBreakQtyFLOAT常用单位样本破坏数量FBillNoItemNumberSTRING单据编号、物料代码FFullNumberSTRING物料长代码FdateDATETIME日期FItemIDNameSTRING物料代码FItemModelSTRING规格型号FItemNameSTRING物料名称FKFDateDATETIME生产/采购日期FAuxPropIDNameSTRING辅助属性FAuxPropIDNumberSTRING辅助属性代码FPeriodDateDATETIME有效期至FAuxQtyPassFLOAT合格数量FQtyCheckFLOAT基本检验数量FAuxRelateQtyFLOAT关联数量FRelateQtyFLOAT基本单位关联数量FSPNameSTRING仓位FDeptIDNameSTRING部门FEmpIDNameSTRING申请人FBaseQtyPassFLOAT基本单位合格数量FDepartmentNumberSTRING部门代码FUnitIDNameSTRING单位FFManagerIDNameSTRING主管FBaseUnitIDSTRING基本单位FBatchNoSTRING批号FBillNoSTRING单据编号FBillNoEntryIDSTRING单据编号、分录内码FCancellationSTRING作废标志FCheckSTRING审核标志FNoteSTRING备注FCheckerIDNameSTRING审核人FCloseSTRING关闭标志FCUQtyCheckFLOAT常用单位检验数量FCUQtyPassFLOAT常用单位合格数量FCUUnitQtyNotPassFLOAT常用单位不合格数量FStockNameSTRING仓库FPriceDecimalINTEGER单价精度FauxqtyFLOAT数量FAuxQtyCheckFLOAT检验数量FQtyDecimalINTEGER数量精度FStockNumberSTRING仓库代码FTranTypeINTEGER事务类型FEntryIDINTEGER单据分录FuserNameSTRING制单FKFPeriodINTEGER保质期FInterIDINTEGER单据内码键表键名类型索引表索引名字段触发器表触发器名描述返回质量管理系统目录表结构字段名类型描述FAuxPropIDNameSTRING辅助属性FBaseUnitIDSTRING基本单位FBatchNoSTRING批号FBillDateDATETIME制单日期FBillNoSTRING检验单号FCancellationSTRING作废标志FCheckMethodNameSTRING检验方式FEmphasesCheckNameSTRING是否重点检查FAnalysisMethodIDSTRING分析方法FAQLIDSTRINGAQLFLowerLimitSTRING规格下限FNoteSTRING检验单备注FICMOInterIDBillNoSTRING生产任务单号FOperNameSTRING工序FOrgBillNoSTRING原检验单号FAuxPropIDNumberSTRING辅助属性代码FItemIDNameSTRING物料代码FQCBasisIDSTRING默认检验依据FItemModelSTRING规格型号FItemNameSTRING物料名称FQCItemNameSTRING检验项目名称FQCItemNoteSTRING项目备注FQCItemNumberSTRING检验项目编码FQCItemResultNameSTRING项目检验结果FQCMethodIDSTRING检验方法FQCOtherID1STRING其它检验依据1FQCOtherID2STRING其它检验依据2FAcQtyINTEGER允收数FPriceDecimalINTEGER单价精度FReQtyINTEGER拒收数FInt