CDS Views for Specification (PLM-WUI-RCP-SPE)

CDS View NameDescriptionSQL View Name
A_ALLERGENAllergenAALLERGEN
A_ALLERGENDESCRIPTIONAllergen DescriptionAALLERGENDESC
A_NUTRIENTNutrientANUTRIENT
A_NUTRIENTBASEUNITOFMEASURENutrient Base Unit Of MeasureANUTRBASEUOM
A_NUTRIENTDERIVEDNUTRIENTDerived NutrientANUTRDRVDNTR
A_NUTRIENTDESCRIPTIONNutrient DescriptionANUTRIENTDESC
A_NUTRIENTREFERENCEQUANTITYNutrient Reference QuantityANUTRREFQTY
A_PRODSPECCMPSTNREFERENCEVALUEComposition Reference ValueAPRSPCMPSTREFV
A_PRODSPECCMPSTNTYPESPECTYPEAvailable Spec Types by Composition TypeAPRSPTYBYCMPTYP
A_PRODSPECCOMPCOMPONENTTYPEComponent Type for Prod Spec ComponentsAPRODSPCMPCMPTY
A_PRODSPECCOMPCOMPONENTTYPETProd Spec Comp Component Type TextAPRODSPCMPCMPTYT
A_PRODSPECCOMPCOMPTYPEBYCMPSTNComponent Type for Components by CmpstnAPRSPCMPTYBYC
A_PRODSPECCOMPEXCEPTIONCODEException Code for Prod Spec ComponentAPRODSPCMPEXC
A_PRODSPECCOMPEXCEPTIONCODETProd Spec Comp Exception Code TextAPRODSPCMPEXCT
A_PRODSPECCOMPONENTComponents for Product Specification CompositionsAPRODSPECOMP
A_PRODSPECCOMPONENTBASEUOMBase UoM for Specification TypeAPRODSPECOMPUOM
A_PRODSPECCOMPONENTDESCRIPTIONDescription of a Product Spec ComponentAPRODSPECOMPDESC
A_PRODSPECCOMPOSITIONTYPEComposition Prod Spec Composition TypeAPRODSPECOMPTYP
A_PRODSPECCOMPOSITIONTYPEALLCommon view of all Prod Spec Cmpstn TypeAPRODSPCOMPTYPA
A_PRODSPECCOMPOSITIONTYPETEXTComposition Prod Spec Composition Type - TextAPRODSPECOMPTYPT
A_PRODSPECLISTINGCMPSTNTYPEListing Prod Spec Composition TypeAPRODSPECOMPLI
A_PRODSPECLISTINGCMPSTNTYPETXTListing Prod Spec Composition Type - TextAPRODSPECOMPLIT
A_PRODSPECPRPTYCHARCASSIGNMENTProd Spec Property Charc AssignmentAPRODSPCPROPCHAS
A_PRODSPECPRPTYDEFINITIONProd Spec Property DefinitionAPRODSPCPROPDEF
A_PRODSPECPRPTYDEFINITIONTEXTProd Spec Property Definition TextAPRODSPCPROPDEFT
A_PRODSPECQLTATVCMPSTNTYPEQualitative Prod Spec Composition TypeAPRODSPECOMPQL
A_PRODSPECQLTATVCMPSTNTYPETEXTQualitative Prod Spec Composition Type - TextAPRODSPECOMPQLT
A_PRODSPECQTYTVCMPSTNREFQTYRef Quantity for Quantitative CmpstnAPRODSPECREFQTY
A_PRODSPECQTYTVCMPSTNTYPEQuantitative Prod Spec Composition TypeAPRODSPECOMPQT
A_PRODSPECQTYTVCMPSTNTYPETEXTQuantitative Prod Spec Composition Type - TextAPRODSPECOMPQTT
A_PRSPCOMPEXCPTNCODEBYCMPSTNException Code for Components by CmpstnAPRSEXCCMPSTN
A_PURESUBSTANCEPure SubstanceAPURESUB
A_PURESUBSTANCEDESCRIPTIONPure Substance DescriptionAPURESUBDESC
A_RAWSUBSTANCESpecification Header Data for Raw SubstancesARAWSUBSTANCE
A_REALSUBSTANCESpecification Header Data for Real SubstancesAREALSUBSTANCE
A_SPECASSIGNEDMATLFORKEYDATESpecification Material AssignmentsASPECMATASSIGN
A_SPECAUTHORIZATIONGROUPTEXTSpecification Authorization GroupsASPECAUTHGROUPT
A_SPECCHARBYVALUEASSGMTINSTSpecification PropertiesASPECCHARBYVAI
A_SPECIDENTIFIERSpecification DescriptionsASPECIDENT
A_SPECIFICATIONPHRASESpecification PhraseASPCPHRASE
A_SPECIFICATIONPHRASEITEMSpecification Phrase ItemASPCPHRITEM
A_SPECIFICATIONPHRASESETSpecification Phrase SetASPCPHRSET
A_SPECIFICATIONPHRASESETTEXTSpecification Phrase Set TextASPCPHRSETTXT
A_SPECPHRASESETPHRASEASSGMTSpec Phrase Set Phrase AssignmentASPCPHRSETASM
A_SPECSTATUSATTRIBUTESSpecification Status AttributesASPECSTATUSATTR
A_SPECSTATUSNEXTSTATUSSpecification Possible Next StatusesASPECSTATUSNXTST
A_SPECSTATUSSCHEMASpecification Status SchemesASPECSTATUSSCHM
A_SPECVALASSGMTINSTANCEWTHCOMPSpecification CompositionsASPECVAINSTWCOMP
C_ALLERGENManage AllergensCALLERGEN
C_ALLERGENGROUPManage Allergen GroupsCALLERGENGROUP
C_DIETManage DietsCDIET
C_DIETGROUPManage Diet GroupsCDIETGROUP
C_GENETICALLYMODIFIEDORGANISMManage GMOsCGENMODORGANISM
C_GMOGROUPManage GMO GroupsCGMOGROUP
C_NUTRIENTManage NutrientsCNUTRIENT
C_NUTRIENTGROUPManage Nutrient GroupsCNUTRIENTGROUP
C_PRODUCTPACKAGEManage ProductPackagesCPRODUCTPACKAGE
C_PURESUBSTANCEManage Pure SubstancesCPURESUBSTANCE
C_RAWSUBSTANCEManage Raw SubstancesCRAWSUBSTANCE
C_RDAPROFILEManage RDA ProfilesCRDAPROFILE
C_REALSUBSTANCEManage Real SubstancesCREALSUBSTANCE
C_RELIGIOUSCERTManage Religious CertificatesCRELIGIOUSCERT
C_RELIGIOUSCERTGRPManage Religious Certificate GroupsCRELIGCERTGRP
C_SPECIFICATIONCURRENTOBJPGManage SpecificationsCSPCCURROPG
C_STREAMSUBSTANCEManage Stream SubstancesCSTREAMSUBSTANCE
ESH_N_ALLERGENAnchor view -ALLERGENESH_L_ALLERGEN
ESH_N_ALLERG_GRPAnchor view -ALLERG_GRPESH_L_ALLERG_GRP
ESH_N_DIETAnchor view -DIETESH_L_DIET
ESH_N_DIETGROUPAnchor view -DIETGROUPESH_L_DIETGROUP
ESH_N_GMOAnchor view -GMOESH_L_GMO
ESH_N_GMOGROUPAnchor view -GMOGROUPESH_L_GMOGROUP
ESH_N_NUTRIENTAnchor view -NUTRIENTESH_L_NUTRIENT
ESH_N_NUTR_GRPAnchor view -NUTR_GRPESH_L_NUTR_GRP
ESH_N_PRODPACKAnchor view -PRODPACKESH_L_PRODPACK
ESH_N_PURESUBAnchor view -PURESUBESH_L_PURESUB
ESH_N_RAWSUBAnchor view -RAWSUBESH_L_RAWSUB
ESH_N_REALSUBAnchor view -REALSUBESH_L_REALSUB
ESH_N_RELCERTGRPAnchor view -RELCERTGRPESH_L_RELCERTGRP
ESH_N_RELIGIOUSCERTAnchor view -RELIGIOUSCERTESH_L_RELIGCERT
ESH_N_SPECIFICATIONAnchor view -SPECIFICATIONESH_L_SPEC
ESH_N_SPECMATASSGAnchor view -SPECMATASSGESH_L_SPCMATASSG
ESH_N_SPEC_INTAnchor view -SPEC_INTESH_L_SPEC_INT
ESH_N_STREAMSUBAnchor view -STREAMSUBESH_L_STREAMSUB
ESH_S_ALLERGENSearch view -ALLERGENESH_U_ALLERGEN
ESH_S_ALLERG_GRPSearch view -ALLERG_GRPESH_U_ALLERG_GRP
ESH_S_DIETSearch view -DIETESH_U_DIET
ESH_S_DIETGROUPSearch view -DIETGROUPESH_U_DIETGROUP
ESH_S_GMOSearch view -GMOESH_U_GMO
ESH_S_GMOGROUPSearch view -GMOGROUPESH_U_GMOGROUP
ESH_S_NUTRIENTSearch view -NUTRIENTESH_U_NUTRIENT
ESH_S_NUTR_GRPSearch view -NUTR_GRPESH_U_NUTR_GRP
ESH_S_PRODPACKSearch view -PRODPACKESH_U_PRODPACK
ESH_S_PURESUBSearch view -PURESUBESH_U_PURESUB
ESH_S_RAWSUBSearch view -RAWSUBESH_U_RAWSUB
ESH_S_REALSUBSearch view -REALSUBESH_U_REALSUB
ESH_S_RELCERTGRPSearch view -RELCERTGRPESH_U_RELCERTGRP
ESH_S_RELIGIOUSCERTSearch view -RELIGIOUSCERTESH_U_RELIGCERT
ESH_S_SPECIFICATIONSearch view -SPECIFICATIONESH_U_SPEC
ESH_S_SPECMATASSGSearch view -SPECMATASSGESH_U_SPCMATASSG
ESH_S_SPEC_INTSearch view -SPEC_INTESH_U_SPEC_INT
ESH_S_STREAMSUBSearch view -STREAMSUBESH_U_STREAMSUB
I_ALLERGENAllergenIALLERGEN
I_ALLERGENCHANGEDBYVHValue help for the Changed By attribute of AllergenIALLRGNCHGDVH
I_ALLERGENCREATEDBYVHValue help for the Created By attribute of AllergenIALLRGNCRTDVH
I_ALLERGENGROUPAllergen GroupIALLERGENGROUP
I_ALLERGENGROUPCHANGEDBYVHValue help for the Changed By attribute of Allergen GroupIALLRGNGRPCHGDVH
I_ALLERGENGROUPCREATEDBYVHValue help for the Created By attribute of Allergen GroupIALLRGNGRPCRTDVH
I_ALLERGENSTATEMENTAllergen StatementIALLERGENSTMNT
I_ALLERGENSTATEMENTTEXTAllergen Statement TextIALLERGENSTMNTT
I_DIETDietIDIET
I_DIETCHANGEDBYVHValue help for the Changed By attribute of DietIDIETCHGDVH
I_DIETCREATEDBYVHValue help for the Created By attribute of DietIDIETCRTDVH
I_DIETGROUPDiet GroupIDIETGROUP
I_DIETGROUPCHANGEDBYVHValue help for the Changed By attribute of Diet GroupIDTGRPCHGDVH
I_DIETGROUPCREATEDBYVHValue help for the Created By attribute of Diet GroupIDTGRPCRTDVH
I_GENETICALLYMODIFIEDORGANISMGMOIGENMODORGANISM
I_GMOCHANGEDBYVHValue help for the Changed By attribute of GMOIGMOCHGDVH
I_GMOCREATEDBYVHValue help for the Created By attribute of GMOIGMOCRTDVH
I_GMOGROUPGMO GroupIGMOGROUP
I_GMOGROUPCHANGEDBYVHValue help for the Changed By attribute of GMO GroupIGMOGRPCHGDVH
I_GMOGROUPCREATEDBYVHValue help for the Created By attribute of GMO GroupIGMOGRPCRTDVH
I_NUTRIENTNutrientINUTRIENT
I_NUTRIENTBASEUNITOFMEASURENutrient Base Unit of MeasureINUTRBASEUOM
I_NUTRIENTCHANGEDBYVHValue help for the Changed By attribute of NutrientINTRNTCHGDVH
I_NUTRIENTCREATEDBYVHValue help for the Created By attribute of NutrientINTRNTCRTDVH
I_NUTRIENTDERIVEDNUTRIENTNutrient Derived NutrientINUTRDRVDNTR
I_NUTRIENTGROUPNutrient GroupINUTRIENTGROUP
I_NUTRIENTGROUPCHANGEDBYVHValue help for the Changed By attribute of Nutrient GroupINTRGRPCHGDVH
I_NUTRIENTGROUPCREATEDBYVHValue help for the Created By attribute of Nutrient GroupINTRGRPCRTDVH
I_NUTRIENTREFERENCEQUANTITYNutrient Reference QuantityINUTRIENTREFQTY
I_NUTRIENTSTATEMENTNutrient StatementINUTRIENTSTMNT
I_NUTRIENTSTATEMENTTEXTNutrient Statement TextINUTRIENTSTMNTT
I_PACKAGECHANGEDBYVHValue help for the Changed By attribute of Product PackageIPCKGNCHGDVH
I_PACKAGECREATEDBYVHValue help for the Created By attribute of Product PackageIPCKGCRTDVH
I_PRODSPECALLERGENCMPSTNProd. Spec. Allergen Comp.IPRODSPECCMPA
I_PRODSPECALLERGENCMPSTNHDRTPProd. Spec. Allergen Comp. Hdr. TPIPRODSPCCMPAHTP
I_PRODSPECALLERGENCMPSTNHEADERProd. Spec. Allergen Comp. HdrIPRODSPECCMPAHDR
I_PRODSPECALLERGENCMPSTNTPProd. Spec. Allergen Comp. TPIPRODSPECCMPATP
I_PRODSPECALLGNCMPSTNNONHISTProd. Spec. Allergen Comp. Non Hist.IPRODSPCOMPANH
I_PRODSPECALLGNCMPSTNNONHISTTPProd. Spec. Allergen Comp. Non Hist. TPIPRSPCOMPANHTP
I_PRODSPECCMPSTNProduct Specification CompositonIPRODSPECCMP
I_PRODSPECCMPSTNHDRNONHISTProd Spec Comp Hdr Non HistIPRODSPCOMPHNH
I_PRODSPECCMPSTNHDRNONHISTTPProd Spec Comp Hdr Non Hist TPIPRSPCOMPHNHTP
I_PRODSPECCMPSTNHEADERProd. Spec. Compostion Hdr.IPRODSPECCMPHDR
I_PRODSPECCMPSTNHEADERTPProd. Spec. Composition Hdr. TPIPRODSPECCMPHTP
I_PRODSPECCMPSTNNONHISTProduct Specification Comp Non HistIPRODSPCOMPNH
I_PRODSPECCMPSTNNONHISTTPProduct Specification Comp Non Hist TPIPRSPCOMPNHTP
I_PRODSPECCMPSTNTPProduct Specification Composition TPIPRODSPECCMPTP
I_PRODSPECCMPSTNTYPESPECTYPEAvailable Spec Types for Cmpstn TypesIPRSPTYBYCMPTYP
I_PRODSPECCOMPCOMPTYPEBYCMPSTNComponent Type for Components by CmpstnIPRSPCMPTYBYC
I_PRODSPECCOMPONENTProduct Spec Composition ComponentsIPRODSPECOMP
I_PRODSPECCOMPONENTBASEUOMProd Specification Component Base UoMIPRSPCOMPUOM
I_PRODSPECCOMPONENTDESCRIPTIONDescription of a Product Spec ComponentIPRODSPECOMPDESC
I_PRODSPECCOMPOSITIONTYPEALLCommon view of all Prod Spec Cmpstn TypeIPRODSPECOMPTYPA
I_PRODSPECDESCNONHISTORICProduct Specification Desc. Non Hist.IPRODSPECDESCNH
I_PRODSPECDESCNONHISTORICTPProduct Specification Desc. Non Hist. TPIPRODSPECDESCNHT
I_PRODSPECDESCRIPTIONProduct Specification DescriptionIPRODSPECDESC
I_PRODSPECDESCRIPTIONTPProduct Specification Description TPIPRODSPECDESCTP
I_PRODSPECLISTINGCMPSTNHEADERProd Spec Listing Composition HeaderIPRODSPCLCMPHDR
I_PRODSPECLISTINGCMPSTNNONHISTProd Spec Listing Comp Non HistIPRODSPCLCMPNH
I_PRODSPECLISTINGCOMPOSITIONProd Spec Listing CompositionIPRODSPCLCMP
I_PRODSPECLISTINGCOMPOSITIONTPProd Spec Listing Composition TPIPRODSPECLCMPTP
I_PRODSPECLSTGCMPSTNHDRNONHISTProd Spec Listing Comp Hdr Non HistIPRODSPCLCMPHNH
I_PRODSPECLSTGCMPSTNHEADERTPProd Spec Listing Composition Header TPIPRODSPECLCMPHTP
I_PRODSPECLSTGCMPSTNNONHISTTPProd Spec Listing Comp Non Hist TPIPRSPLCMPNHTP
I_PRODSPECNONHISTORICProduct Specification Non HistoricIPRODSPECNONHIS
I_PRODSPECNONHISTORICTPProduct Specification Non Historic (TP)IPRODSPECNHISTP
I_PRODSPECNTRNTCMPSTNNONHISTProd. Spec. Ntrnt. Comp. Header Non HistIPRODNTCOMPSNH
I_PRODSPECNTRNTCMPSTNNONHISTTPProd. Spec. Nutrient Comp. Hdr. Non HistIPRSPCNTNHTP
I_PRODSPECNUTRIENTCMPSTNProduct Specification Nutrient Comp.IPRODSPECCMPN
I_PRODSPECNUTRIENTCMPSTNHDRProduct Specification Nut. Comp. Hdr.IPRSPNTRCMPSTHD
I_PRODSPECNUTRIENTCMPSTNHDRTPProd. Spec. Nutrient Comp. Hdr. TPIPRODSPCCMPNHT
I_PRODSPECNUTRIENTCMPSTNTPProduct Specification Nutrient Comp. TPIPRODSPECCMPNTP
I_PRODSPECPROPERTYHEADERProduct Specification Property HeaderIPRODSPECPRPHDR
I_PRODSPECPROPERTYHEADERTPProduct Specification Property Header TPIPRODSPCPRPHDRTP
I_PRODSPECPRPTYCHARACTERVALUEProduct Specification Property Character Type Value (TP)IPDSPCPRPCHARVAL
I_PRODSPECPRPTYCHARCVALUEProduct Specification Property Value by CharacteristicIPDSPCPRPCHVALUE
I_PRODSPECPRPTYCHARCVALUETPProduct Specification Property Value by Characteristic TPIPDSPCPRPCHVALTP
I_PRODSPECPRPTYCHARVALUETPProduct Specification Property Character Type Value (TP)IPDSPCPRPCHARVTP
I_PRODSPECPRPTYHEADERNONHISTProduct Specification Non Historic Property HeaderIPRODSPPRPHNH
I_PRODSPECPRPTYHEADERNONHISTTPProduct Spec. Property Header Non Hist TPIPRSPPRPTYHNHTP
I_PRODSPECPRPTYNUMERICVALUEProduct Specification Property Numeric Type ValueIPDSPCPRPNUMVAL
I_PRODSPECPRPTYNUMERICVALUETPProduct Spec. Property Numeric Value TPIPDSPCPRPNUMVATP
I_PRODSPECQLTATVCMPSTNHEADERProd Spec Qualitative Comp HdrIPRODSPCQLCMPHDR
I_PRODSPECQLTATVCMPSTNHEADERTPProd Spec Qltatv Comp Hdr Non Hist TPIPRDSPCQLCMPSHTP
I_PRODSPECQLTATVCMPSTNNONHISTProd Spec Qltatv Comp Non HistIPRODSPCQLCMPNH
I_PRODSPECQTYTVCMPSTNHEADERProd Spec Quantitative Comp HdrIPRODSPECQCMPH
I_PRODSPECQTYTVCMPSTNHEADERTPProd Spec Quantitative Comp Hdr TPIPRODSPCQCMPSHTP
I_PRODSPECQTYTVCMPSTNNONHISTProd Spec Qtytv Comp Non HistIPRODSPCQCMPNH
I_PRODSPECQTYTVCMPSTNNONHISTTPProd Spec Qtytv Comp Non Hist TPIPRODSPCQCMPNHTP
I_PRODSPECQUALITATIVECMPSTNProd Spec Qualitative CompositionIPRODSPECQLCMP
I_PRODSPECQUALITATIVECMPSTNTPProd Spec Qualitative Composition TPIPRODSPECQLCMPTP
I_PRODSPECQUANTITATIVECMPSTNProd Spec Quantitative CompositionIPRODSPECQCMP
I_PRODSPECQUANTITATIVECMPSTNTPProd Spec Quantitative Composition TPIPRODSPECQCMPTP
I_PRODSPECSTDCMPSTNProduct Specification Std. CompositionIPRODSPCOMPS
I_PRODSPECSTDCMPSTNHDRNONHISTProduct Specification Std. Comp. Hdr. Non Hist.IPRODSPCOMPSHNH
I_PRODSPECSTDCMPSTNHEADERProduct Specification Std. Comp. Hdr.IPRODSPCOMPSH
I_PRODSPECSTDCMPSTNHEADERTPProduct Specification Std. Comp. Hdr. (TP)IPRODSPCOMPSHTP
I_PRODSPECSTDCMPSTNNONHISTProd. Spec. Std. Composition Header Non HistIPRODSPCOMPSNH
I_PRODSPECSTDCMPSTNNONHISTTPProd. Spec. Std. Comosition Header Non Hist TPIPRSPCOMPSNHTP
I_PRODSPECSTDCMPSTNTPProduct Specification Std. Comp. (TP)IPRODSPCCOMPSTP
I_PRODSPECTYPEProduct Specification TypeIPRODSPECTYP
I_PRODUCTPACKAGEProduct PackageIPRODUCTPACKAGE
I_PRODUCTSPECIFICATIONProduct SpecificationIPRODSPEC
I_PRODUCTSPECIFICATIONTPProduct Specification TPIPRODSPECTP
I_PRSPALLGNCMPSTNHDRNONHISTProd. Spec. Allgn. Comp. Hdr. Non Hist.IPRODSPCOMPAHNH
I_PRSPALLGNCMPSTNHDRNONHISTTPProd. Spec. Allgn. Comp. Hdr. NonHist.TPIPRSPCOMPAHNHTP
I_PRSPCOMPEXCPTNCODEBYCMPSTNException Code for Components by CmpstnIPRSEXCCMPSTN
I_PRSPLSTGCMPSTNHDRNONHISTTPProd Spec Listing Comp Hdr Non Hist TPIPRSPLCOMPHNHTP
I_PRSPNTRNTCMPSTNHDRNONHISTProduct Spec Nut Comp Hdr Non HistIPRODSPCOMPNHNH
I_PRSPNTRNTCMPSTNHDRNONHISTTPProduct Spec Nutr Comp Hdr Non Hist TPIPRSPCNTCSHNHTP
I_PRSPPRPTYCHARCVALUENONHISTProduct Spec. Property Value by Char. Non HistoricIPDSPCPRPCHVALNH
I_PRSPPRPTYCHARCVALUENONHISTTPProduct Spec. Property Value by Char. Non Historic TPIPDSPCPRPCHVNHTP
I_PRSPQLTATVCMPSTNHDRNONHISTProd Spec Qltatv Comp Hdr Non HistIPRODSPCQLCMPHNH
I_PRSPQLTATVCMPSTNHDRNONHISTTPProd Spec Qltatv Comp Hdr Non Hist TPIPRDSPCQLCMPHNHT
I_PRSPQLTATVCMPSTNNONHISTTPProd Spec Qltatv Comp Non Hist TPIPRDSPCQLCMPNHTP
I_PRSPQTYTVCMPSTNHDRNONHISTProd Spec Qtytv Comp Hdr Non HistIPRODSPCQCMPHNH
I_PRSPQTYTVCMPSTNHDRNONHISTTPProd Spec Qtytv Comp Hdr Non Hist TPIPRODSPCQCMPHNHT
I_PRSPSTDCMPSTNHDRNONHISTTPProduct Specification Std. Comp. Hdr. Non Hist. (TP)IPRSPCOMPSHNHTP
I_PURESUBSTANCEPure SubstanceIPURESUBSTANCE
I_PURESUBSTANCECHANGEDBYVHValue help for the Changed By attribute of Pure SubstanceIPURSBSCHGDVH
I_PURESUBSTANCECOMPONENTTYPEPure Subst. Component Type Code ListIPURESUBSTCOMPT
I_PURESUBSTANCECREATEDBYVHValue help for the Created By attribute of Pure SubstanceIPURSBSCRTDVH
I_PURESUBSTCOMPONENTTYPETEXTPure Subst. Component Type TextIPURESUBSTCOMPTT
I_RAWSUBSTANCERaw SubstanceIRAWSUBSTANCE
I_RAWSUBSTANCECHANGEDBYVHValue help for the Changed By attribute of Raw SubstanceIRAWSBSCHGDVH
I_RAWSUBSTANCECREATEDBYVHValue help for the Created By attribute of Raw SubstanceIRAWSBSCRTDVH
I_RDAPROFILERDA ProfileIRDAPROFILE
I_RDAPROFILECHANGEDBYVHValue help for the Changed By attribute of RDA ProfileIRDAPRFCHGDVH
I_RDAPROFILECREATEDBYVHValue help for the Created By attribute of RDA ProfileIRDAPRFCRTDVH
I_REALSUBSTANCEReal SubstanceIREALSUBSTANCE
I_REALSUBSTANCECHANGEDBYVHValue help for the Changed By attribute of Real SubstanceIRLSBSCHGDVH
I_REALSUBSTANCECREATEDBYVHValue help for the Created By attribute of Real SubstanceIRLSBSCRTDVH
I_RELIGIOUSCERTReligious CertificateIRELIGIOUSCERT
I_RELIGIOUSCERTCHANGEDBYVHValue help for the Changed By attribute of Religious CertICRTFCTCHGDVH
I_RELIGIOUSCERTCREATEDBYVHValue help for the Created By attribute of Religious CertICRTFCTCRTDVH
I_RELIGIOUSCERTGRPReligious Certificate GroupIRELIGCERTGRP
I_RELIGIOUSCERTGRPCHANGEDBYVHVH for the Changed By attribute of Religious Cert GroupICRTGRPCHGDVH
I_RELIGIOUSCERTGRPCREATEDBYVHVH for the Created By attribute of Religious Cert GroupICRTGRPCRTDVH
I_SPECASSIGNEDHEADERSTATUSSpecification Assigned Header StatusISPECASGHDRST
I_SPECASSIGNEDMATERIALSpecification Material AssignmentISPECMATASSGMT
I_SPECASSIGNEDMATLFORKEYDATESpecification Material Assignment for Key DateISPECMATASSGMTKD
I_SPECASSIGNEDSTATUSSpecification Assigned StatusISPECASGST
I_SPECAUTHORIZATIONGROUPSpecification Authorization GroupISPECAUTHGROUP
I_SPECAUTHORIZATIONGROUPSTDVHSpecification Authorization GroupISPECAUTHGRP_SVH
I_SPECAUTHORIZATIONGROUPTEXTSpecification Authorization Group TextISPECAUTHGROUPT
I_SPECAUTHZNGRPCATEGORYASSGMTSpec. Authzn. Group Category Assgmt.ISPCAUTHCATASG
I_SPECCATEGORYSpecification CategoryISPECCATEGORY
I_SPECCATEGORYTEXTSpecification Category TextISPECCATEGORYT
I_SPECCHANGENUMBERVALUEHELPValue Help for Change Numbers in SpecificationISPECECNVH
I_SPECCHARBYVALUEASSGMTINSTSpecification Characteristic by VAIISPECCHARBYVAI
I_SPECCOMPEXCEPTIONCODESpecification Component Exception CodeISPECCOMPEXCPTNC
I_SPECCOMPEXCEPTIONCODETEXTSpec. Component Exception Code TextISPECCOMPEXCPTNT
I_SPECCOMPONENTTYPESpecification Component TypeISPECCOMPTYPE
I_SPECCOMPONENTTYPETEXTSpecification Component Type TextISPECCOMPTYPET
I_SPECCSTMCMPSTNDEFINITIONSpec. Composition (Custom) DefinitionISPCCUSTCOMP
I_SPECCSTMPROPERTYCHARCASSGMTSpec. (Custom) Property Charc. Assgmt.ISPCCUSTCHRASGMT
I_SPECCSTMPROPERTYDEFINITIONSpec. (Custom) Property DefinitionISPCCUSTPRPTY
I_SPECDEFIDFRFORSPECCATDefault description of a specificationISPECDEFSPECCAT
I_SPECDISTINCTIDFRBYPOSITIONSpecification Identifier by PositionIDISTINIDFRBYPOS
I_SPECHDRSTSSCHEMATRANSITIONSpecification Header Status Schema TransitionISPECSTATUSTRANS
I_SPECHDRSTSSPECTYPESCHEMASpecification Header Status Schema for Specification TypesISPECSTSSPTYPSCH
I_SPECHDRSTSSUBOBJSCHEMASpecification Header Status Subobject Type SchemaISPECSTATUSSUBOB
I_SPECHEADERSTATUSSpecification Header StatusISPECSTATUS
I_SPECHEADERSTATUSATTRIBUTESSpecification Header Status AttributesISPECSTATUSATTRI
I_SPECHEADERSTATUSSCHEMASpecification Header Status SchemaISPECSTATUSSCHEM
I_SPECHEADERSTATUSSCHEMATEXTSpecification Header Status Schema TextISPECSTATUSSCHMT
I_SPECHEADERSTATUSTEXTSpecification Header Status TextISPECHEADERSTATT
I_SPECHEADERSTSDFNDATTRIBSpecification Header Status Defined AttributeISPECSTATUSDFATT
I_SPECHEADERSTSDFNDATTRIBTEXTSpecification Header Status Defined Attribute TextISPECSTATUSDFATX
I_SPECIDENTIFIERSpecification IdentifierISPECIDENT
I_SPECIDENTIFIERBYPOSITIONSpecification Identifier by PositionISPECIDENTBYPOS
I_SPECIDENTIFIERFORKEYDATESpecification on a Key DateISPECIDFR_KD
I_SPECIDENTIFIERLONGTEXTSpecification Identifier Long TextISPECIDENTLTX
I_SPECIDENTIFIERUSAGESpecification Identifier UsageISPECIDFGUSAGE
I_SPECIDFRBSCBYAPPFORKEYDATESpecification Basic Identifier by Appl. for Key DateIFRCPIDFRSCR
I_SPECIDFRBSCFORKEYDATESpecification Basic Identifier by Appl for Key DateISPCIDFRBSC
I_SPECIDNLISTINGSpecification Identification ListingISPECIDNLIST
I_SPECIDNLISTINGDEFINITIONSpecification Identification Listing DefinitionISPECIDFRLSTDEF
I_SPECIDNLISTINGFORVIEWSpecification Identification Listing for ViewsISPCIDFRLSTVW
I_SPECIDNLISTINGTEXTSpecification Identification Listing TextISPECIDFRLSTT
I_SPECIFICATIONSpecificationISPECIFICATION
I_SPECIFICATIONCHANGEDBYVHValue help for the Changed By attribute of SpecificationISPCCHGDVH
I_SPECIFICATIONCREATEDBYVHValue help for the Created By attribute of SpecificationISPCCRTDVH
I_SPECIFICATIONFORKEYDATESpecification on a Key DateISPECFORKDATE
I_SPECIFICATIONLASTCHANGESpecification Last ChangeISPCLASTCHANGED
I_SPECIFICATIONNONHISTORICSpecification Non HistoricISPCNONHIST
I_SPECIFICATIONPHRASESpecification PhraseISPCPHRASE
I_SPECIFICATIONPHRASEGROUPSpecification Phrase GroupISPCPHRGRP
I_SPECIFICATIONPHRASEGROUPTEXTSpecification Phrase Group TextISPCPHRGRPTXT
I_SPECIFICATIONPHRASEITEMSpecification Phrase ItemISPCPHRITEM
I_SPECIFICATIONPHRASELIBRARYSpecification Phrase LibraryISPCPHRLIBRARY
I_SPECIFICATIONPHRASELIBRTEXTSpecification Phrase Library TextISPCPHRLIBRTXT
I_SPECIFICATIONPHRASENONHISTSpecification Phrase Header Non HistoricISPCPHRNH
I_SPECIFICATIONPHRASESETSpecification Phrase SetISPCPHRSET
I_SPECIFICATIONPHRASESETTEXTSpecification Phrase Set TextISPCPHRSETTXT
I_SPECIFICATIONPHRSSETNONHISTSpecification Phrase Set Non HistoricISPCPHRSETNH
I_SPECIFICATIONSTDATTRIBCODESpecification Standard Attribute DefinitionISPCSTDAD
I_SPECIFICATIONTYPEVALIDITYValid Specification TypesISPECTYPVAL
I_SPECIFICATIONVHValue Help for SpecificationISPECVH
I_SPECINHERITANCERELATIONSHIPSpecification Inheritance RelationshipISPECINHREL
I_SPECINHERITANCETEMPLATESpecification Inheritance TemplateISPECINHTPL
I_SPECINHERITANCETEMPLATEHDRSpecification Inheritance Template HeaderISPECINHHDR
I_SPECINHERITANCETEMPLATEUSAGESpecification Inheritance Template UsageISPECINHUSAGE
I_SPECLISTEDSUBSTANCELINKSpecification Listed Substance LinkISPCLID
I_SPECLISTEDSUBSTANCELINKMINSpecification Listed Substance LinkISPCLIDMIN
I_SPECOBJPARAMCOMPTYPEASSGMTSpec. Obj. Param. Comp. Type Assgmt.ISPECOBJPCTA
I_SPECOBJPARAMETERASSIGNMENTSpec Object Parameter AssignmentISPECOBJPAR
I_SPECOBJPARAMEXCPTNCODEASSGMTSpec. Obj. Param. Excptn. Code Assgmt.ISPECOBJPECA
I_SPECPHRASESETPHRASEASSGMTSpecification Phrase Set Phrase AssignmentISPCPHRSETASM
I_SPECPRIMIDFRFORSPECCATSpecification primary identifier for a spec. categoryISPCIDFRPRIM
I_SPECPRIMIDFRFORSPECCATMINSpecification primary identifier for a categoryISPECIDFRPRIM
I_SPECRATINGSpecification RatingISPECRATING
I_SPECRATINGTEXTSpecification Rating TextISPECRATINGTEXT
I_SPECREFERENCESpecification and Reference Specification RelationsISPECVAREF
I_SPECSECDRYIDFRFORSPECCATSpecification secondary identifier for a spec. categoryISPCIDFRSEC
I_SPECSTDATTRIBCODEFORSPECTYPESpecification Standard Attribute Code for Specification TypeISPCSTDADSPCT
I_SPECSTDCOMPOSITIONDEFINITIONSpec. Composition (Standard) DefinitionISPCSTDCOMP
I_SPECSUBSTANCENATURESpecification Substance NatureISPECSUBNATR
I_SPECSUBSTANCENATURETEXTSpecification Substance Nature TextISPECSUBNATRT
I_SPECTYPESpecification TypeISPECTYPE
I_SPECTYPEASSIGNEDCATEGORYAssigned Specification Categories to Specification TypeISPCTYPCATASSGMT
I_SPECTYPEBASEUNITOFMEASUREBase UoM for Specification TypeISPCTYPBUOM
I_SPECTYPESTDVHSpecification TypeISPECTYPE_SVH
I_SPECTYPETEXTSpecification Type TextISPECTYPET
I_SPECVALASSGMTSpecification Value AssignmentISPECVA
I_SPECVALASSGMTHEADERSpecification Value Assignment HeaderISPECVAHDR
I_SPECVALASSGMTINSTANCESpecification Value Assignment Instance with UsagesISPECVAINST
I_SPECVALASSGMTINSTANCEWTHCOMPSpecification Value Assignment Instance with CompositionISPECVAINSTWCOMP
I_SPECVALASSGMTITEMSpecification Value Assignment ItemISPECVAITEM
I_SPECVALASSGMTITEMFORKEYDATESpecification Value Assignment Item for Key DateISPECVAITMKDATE
I_SPECVALASSGMTREFERENCEVALUESpec Reference Values for CompositionISPECVAREFV
I_SPECVALASSGMTREFVALUETEXTSpec Reference Values for Cmpstn TextISPECVAREFVT
I_SPECVALASSGMTTYPESpecification Value Assignment TypeISPECVATYPE
I_SPECVALASSGMTTYPECHARCTOPHRSSpec Value Assignment Type Charc Phrase Set AssignmentISPECVATCHARPRHS
I_SPECVALASSGMTTYPETEXTSpecification Value Assignment Type TextISPECVATYPET
I_SPECVALASSGMTTYPETOSPECTYPESpec Value Assignment Type Specification Type AssignmentISPECVATSPECTYPA
I_SPECVALASSGMTTYPEWTHSPECTYPEValue Assignment Type Specification Type AssignmentISPECVATSPECTYP
I_SPECVALASSGMTUSAGESpecification Value Assignment UsageISPECVAUSAGE
I_SPECVALASSGMTWITHHEADERSpecification Value Assignment Instance with HeaderISPECVAWHDR
I_SPECVALIDITYAREASpecification Validity AreaISPECVALAREA
I_SPECVALIDITYAREATEXTSpecification Validity Area TextISPECVALAREATEXT
I_STREAMSUBSTANCEStream SubstanceISTREAMSUBSTANCE
I_STREAMSUBSTANCECHANGEDBYVHValue help for the Changed By attribute of Stream SubstanceISTRSBSCHGDVH
I_STREAMSUBSTANCECREATEDBYVHValue help for the Created By attribute of Stream SubstanceISTRSBSCRTDVH
N_SPECASSIGNEDHEADERSTATUSSpecification Assigned Header StatusNSPECASGHDRST
P_PRODSPECCMPSTNOBJPARAMPRIOComposition Object Param Fallback LogicPPRSPCOBJPPRIO
P_PURESUBSTANCECOMPONENTTYPEPure Subst. Component TypePPURESUBSTCOMPT
P_SPECAPICUSTOMDEFINEDATTRIBSpec. API Custom Defined AttributesPSPCAPICUSDA
P_SPECASSIGNEDHEADERSTATUSLTSTLatest Specification Header Status AssignedPSPECASGHDRLAT
P_SPECASSIGNEDMATLFORKEYDATESpecification Material Assignment for Key DatePSPECMATASSGMTKD
P_SPECCHARACTERISTICVALUESpecification Characteristic ValuePSPCCHARVALUE
P_SPECIDFRBSCBYAPPSCORE1Private view for basic idfr reading by app (score calc 1)PSPCIDFRBSCAPP1
P_SPECIDFRBSCBYAPPSCORE2Private view for basic idfr reading by app (score calc 2)PSPCIDFRBSCAPP2
P_SPECIDFRBSCBYAPPSCOREMAXPrivate view for basic idfr reading by app (max score)PSPCIDFRBSCAPPM
P_SPECPRIMIDFRFORSPECCATMINHelper view for I_SpecPrimIdfrForSpecCatPSPCIDFRPRIM
P_SPECSECDRYIDFRFORSPECCATMINHelper view for P_SpecSecdryIdfrForSpecCatMinPSPCIDFRSEC
P_SPECSINGLEIDENTIFIERSpecification on a Key DatePSPECSINGLEID
P_SPECUSAGEPrivate view for Specification UsagePSPECUSAGE
P_SPECVALASSGMTINSTANCENORMALPrivate view for Normal VAsPSPECVANRM
P_SPECVALASSGMTWITHHEADERPrivate view for Specification VA with VA headerPSPECVAHDR
R_PRODSPECCMPSTNHDRWITHUSAGEProduct Spec. Comp. Header with UsageRPSCMPHWUSG
R_PRODSPECPRPTYHDRWITHUSAGEProduct Specification Property Header with UsageRPSPRPHWUSG
R_SPECCOMPOSITIONDATEINDEPSpec Value Assignment Instance with Comp Date IndependentRSPCCMPDATEINDEP