QM 模块数据库表

QMQMAT-QMHUQMQMTBQMTTQPACQPAMQPMKQPMTQPMZ/TQ01DQMTQ01EQMTQ21TQ25QMQPCDQPCTQPGRQPGTTQ07TQ07AQMTQ07TTQ07TQ15

TQ15TTQ15TQ17TQ17TTQ17QDEB:/QDEBT/:QDPA-QDPKQDPKTQDPPQDQLTQ17ATQ11TQ29T006QDBMQDBMTQDDRQDDRTQDEPQDEPT:QDFBQDFBT

QDFMQDFMTQDPSQDPSTQDSAQDSATQDSVQDSVTTQ39BQMGraphics&SPCQASHQASTQPSHQPSHTQPSPSPCQPSPTSPCQPSTQPSTTQMSPQMPLKO-MAPLPLPO-/PLMK

PLMWMAPL-()TQ03QSS:/(Rel.4.6)TQ29A-TQ72TQ72TTQ75QMTQ75FQMTQ75KTQ75FTQ75TQmQINFQMTQ02QMTQ02AQMTQ02BQMTQ02TQMTQ02UQMTQ04ATQ04SQMTQ05QMTQ05TQM:TQ08QMTQ08TQM:QMTQ09QM:QM

TQ09TQM:QMTQ32AQMQVDMQMSDQMTQ32BQALSQALTT156Q:TQ30TQ30TTQ32TQ32CTQ32CTQ33TQ34QAPPTQ79/TQ79TQAESQAKLQAMRQAMVQASE

QASRQASVTQ12TQ12TTQ70TQ70CTQ70ETQ70FTQ70STQ73TQ73TTQ74TQ74TTQ76TQ76TTQ77TQ77TTQ78TQ78TTQ84TQ84TTQ86

TQ86ATQ86TQAMBQMQAVETQ06TQ06TTQ06TQ07MQMSampleMgmtQPRNQPRSQPRVKQPRVKQPRVPQPRVPTQ40TQ40TTQ41TQ41TTQ42TQ42TQMISS068S069S097QM

S098QMS099QMS100S102S103S104S161InspectionResults:GeneralS162QuantitativeInspectionResultsS163QuantitativeInspectionResult:VendorS164QuantitativeInspectionResult:VendorS165InspectionResults(General):CustomersS166QuantitativeInspectionResults:CustomerTQ55TQ56TQ56TTQ57QCPRQMI000KONDI:QCVKQCVMQCVMT:

QCVV:TQ61TQ61T:TQ62TQ62T:TQ63()TQ63T:TQ64TQ64T:TQ65:,/TQ67QMELQMFE-QMSM-QMMA-T352CTQ81TQ81VTQ81V_TTQ81_TTQ82TQ83

TQ85TQ85RTQ85_TTQ8COMARAT001W/LFA1()KNA1AUFKSAFKMCH1MCHAEKKOEKPOEKETVBUKVBUPCSKSEQUI1、Inspectionlot/inforecord（检验批决定一个检验计划，节点相当于检验批（检验计划）的一道工序；任务类型+组+组计数器=一个检验计划）QALSInspectionlotrecord检验批记录QAMBLinkinspectionlot-materialdocument检验批---物料凭证QAVEInspectionusagedecision使用决策（包括质量给分）QAMR检验处理中的特性结果QASE采样单元的结果表TQ17缺陷分类TQ17T缺陷分类描述表QPCT代码文本（可以取出缺陷文本、使用决策描述等各种描述）QDPSInspectionstagesQMATInspectiontype-materialparameters检验类型--物料参数（物料主数据中）QPMT检验特性描述表QDPKT采样方案描述（短文本）QDSVT采样过程描述QASR采样结果表QALS检验批结果表PLMK检验计划特性（行项目表）QASE（对定量特性结果记录）□□□□□□□□QAKL（对定性结果记录）数值分类结果表QAMR检验处理中的特性结果（过程中）QAMV□□□□□□□□□□□□□□QALS□□□□□,□□□□□□□QINFInspectioninforecord（vendor-material）物料和供应商的QM信息记录QDQLQualitylevel质量级别QDPSInspectionstages对动态修改规则的检验阶段2、QualitynotificationTQ80Notificationtypes通知类型QMELQualitynotification质量通知抬头表QMFEQualitynotification-items质量通知---项目表QMURQualitynotification-causes质量通知---原因QMSMQualitynotification-tasks质量通知任务QMMAQualitynotification-activities质量通知作业QMIHQualitymessage-maintenancedataexcerpt质量信息---维护数据摘录3、CertificateprofileQCVMTCertificateprofilecharacteristiclevel:texts证书特性参数文本QCVMCertificateprofilecharacteristiclevel证书参数文件特性层QCVKCertificateprofileheader证书参数文件表头4.检验计划PLMK检验计划特性PLAS任务清单，工序/作业选择（用于选择检验计划的某道工序）PLPO任务清单，工序/作业（项目表）PLKO任务清单（抬头表）QPCTCodetextsQMATInspectiontype-materialparametersQPMKInspectioncharacteristicmasterQPCDInspectioncatalogcodesQPGTCodegrouptextsQPACInspectioncatalogcodesforselectedsetsQDPSInspectionstagesforadynamicmodificationruleQPMTMasterInspectionCharacteristicsTextsTQ15InspectioncatalogtypeindexQPGRInspectioncatalogcodegroupsQPAMInspectioncatalogselectedsetsQPMZAssignmenttable-insp.methods/masterinsp.characteristicTQ17DefectclassesQMTTInspectionMethodTextsQDSVSamplingprocedureTQ07Follow-UpActionforUsageDecisionofInspectionLotQMTBInspectionmethodmasterrecordTQ15TLanguage-dependenttextsfortableTQ15QDBMValuationmodeV_QPCD_KATGeneratedTableforViewV_QPCD_KATQMHUQMLinkBetweenInspectionLotandHandlingUnitItemQASHQualitycontrolchartQASTControlcharttrackTQ25QM:screensequenceformasterandinspectioncharacteristicsTQ01DAuthorizationgroupsforQMmasterdataTQ39BQM:Activatesreferencefordyn.modificationlevelQDDRDynamicmodificationrule(header)QDDRTDynamicmodificationrule:textsQDSVTSamplingProcedure:TextsQDBMTValuationMode:TextsQDEPAllowedinspectionseveritiesQDEPTAllowedInspectionSeverities:TextsQDPSTInspectionStages:TextsV_QPGR_KATGeneratedTableforViewV_QPGR_KATTQ07TLanguage-dependenttextsforTableTQ07TQ21AssignmentofscreenstoscreengroupsTQ01ETextauthorizationgroupsforQMmasterdataQDFBFunctionmodulesfortheindividualprocedurecategoriesQDFBTFunctionModulesforProcedure:TextsQDFMFunctionmodulesforvaluationmodeQDFMTFunctionModulesforValuationMode:TextsQDSASamplingtypeQDSATSamplingType:TextsTQ07AQM:FunctionModulesforFollow-UpActionTQ17TLanguage-dependenttextsfortableTQ17QPSHControlcharttypesQPSHTTextsforcontrolcharttypesQPSPSPCcriterionQPSPTTextsforSPCcriteriaQPSTControl