JDBC Driver for Oracle SCM

Build 22.0.8462

ProductProposals

The Product Proposals resource manages the product proposals. A product proposal represents a business plan for a proposed new concept, a new product, a sustaining product, or a product to be phased out. The product proposal contains financial information such as cost and revenue of the product. It also contains milestone and resource data that represents the execution details.

Columns

Name Type Description
ProductProposalId [KEY] String ProductProposalId of ProductProposals
Name String Name of the product proposal.
ProposalNumber String ProposalNumber of ProductProposals
Description String Description of the product proposal.
AllowAccesstoEveryone String Value that indicates whether to allow access to everyone with the right privileges.
ConceptCurrencyCode String Abbreviation that identifies the currency of the proposal.
ConceptMasterId String Value that uniquely identifies the associated concept master.
ConceptMasterName String ConceptMasterName of ProductProposals
ConceptMasterVersion String ConceptMasterVersion of ProductProposals
CreatedBy String CreatedBy of ProductProposals
CreationDate Datetime CreationDate of ProductProposals
CurrencyConversionRate String Rate of conversion applied to convert the currency to US dollars.
InstanceId String Value that uniquely identifies the instance.
IsCloned String IsCloned of ProductProposals
IsLatest String IsLatest of ProductProposals
LastConceptVersion String LastConceptVersion of ProductProposals
LastProjCostRefreshTime Datetime Time taken to refresh the most recent project cost. This attribute is used only when being connected to Agile PLM.
LastProjResourceRefreshTime Datetime Time taken to refresh the most recent project resource. This attribute is used only when being connected to Agile PLM.
LastUpdateDate Datetime LastUpdateDate of ProductProposals
LastUpdatedBy String LastUpdatedBy of ProductProposals
LatestConceptId String LatestConceptId of ProductProposals
LatestConceptName String LatestConceptName of ProductProposals
LatestConceptVersion String LatestConceptVersion of ProductProposals
LifecyclePhase String LifecyclePhase of ProductProposals
ProposalStatus String ProposalStatus of ProductProposals
ProposalType String Type of the proposal.
PublishedFromPortfolio String PublishedFromPortfolio of ProductProposals
ReportId String ReportId of ProductProposals
ReportTemplate String ReportTemplate of ProductProposals
SrcProductProposalId String SrcProductProposalId of ProductProposals
SrcProductProposalName String SrcProductProposalName of ProductProposals
SrcProductProposalVersion Long SrcProductProposalVersion of ProductProposals
Version Int Version of ProductProposals
WorkflowObjectType String WorkflowObjectType of ProductProposals
ProjectedResources String Projected resources for the proposal.
ActualDevFixedCost String Sum of actual fixed costs for development.
MarketSharePercent String Percent of the market share estimated for the proposal.
HighLevelDesign Date High level design milestone of the proposal.
ActualCost String Sum of actual costs of the proposal.
CompetitiveAdvantage String Value that indicates the competitive advantage of the proposal.
ProjProdMaterialCost String Sum of projected costs for the product materials.
ActualProdFixedCost String Sum of actual fixed costs for the product.
ReturnOnInvestment String Value that indicates the ratio of the benefit gain minus cost of the product divided by the cost to develop the product.
ProjectedMargin String Projected margin of the proposal.
Summary String Summary of the proposal.
Impact String Impact of the proposal.
PaybackPeriod String Period of time required to repay the sum of the original investment on the product.
RiskSubjective String Overall risk for product on subjective basis. Valid values are High, Medium, and Low.
DevelopmentStart Date Date when the development begins.
TargetCost String Sum of target costs.
RndKnowHow String Know-how for research and development.
AllocatedBudget String Budget allocated for the proposal.
ProjDevFixedCost String Sum of projected fixed costs for development.
BusinessObjectives String Value that indicates the business objectives of the proposal.
ActualProductionCost String Sum of actual costs for production.
ProposalVersionNotes String ProposalVersionNotes of ProductProposals
ActualDevLaborCost String Sum of actual labor costs for development.
ActualProdLaborCost String Sum of actual labor costs for production.
ProjDevLaborCost String Sum of projected labor costs for development.
ProductCategorization String Category under which the product is classified.
InternalRateOfReturn String Rate of discount that makes the net present value of all cash flows for a product equal to zero.
ProposalProjectedCost String Projected cost of the proposal.
MarketAttractiveness String Value that indicates the market attractiveness of the proposal.
ProductStrategicFit String Product strategic fit of the proposal.
DiscountRate Double Rate of discount of the proposal.
DevelopmentEnd Date Date when the development of the proposal ends.
YearTwoRevenue String Sum of revenues for first two years after the product launch.
ProbOfCommercialSuccess String Value that indicates the probability of the product to be sold commercially.
BusinessUnitStrength String Strength of business unit of the proposal.
ProjDevCost String Sum of projected costs for development.
RiskNumeric String Risk of the proposal.
ActualDevelopmentCost String Sum of actual costs for development.
YearFiveRevenue String Sum of revenues for first five years after the product launch.
CostValueIndex String Cost value index of the proposal.
BaselineDate Date Date when the proposal metrics were calculated.
ActualDevVariableCost String Sum of variable costs for the actual development.
ExpectedCommercialValue String Expected commercial value.
ProposalProjectedRevenue String Sum of projected revenues of the proposal.
ActualProdMaterialCost String Sum of actual costs for the production material.
ActualRevenue String Sum of actual revenues.
Alignment String Alignment score of the proposal.
ActualResources String Sum of actual resources.
Launch Date Date when the proposal is planned to be launched.
EOL Date Estimated end of life of the proposal.
AverageSellingPrice String Average selling price of the proposal.
ProjProdFixedCost String Sum of projected fixed costs for production.
ProjProdCost String Sum of projected costs for production.
ProbOfTechnicalSuccess String Value that indicates the probability of technical success.
CPI String Consumer price index metric of the proposal.
ProjProdLaborCost String Sum of projected labor costs for production.
MarketStrategy String Market strategy intended with this proposal.
ProjProdVariableCost String Sum of projected variable costs for production.
SupplyChainFit String Supply chain fit of the proposal.
ActualMargin String Actual margin of the proposal.
PrimaryJustification String Primary justification for the proposal.
FundingAmount String Funding amount for the proposal.
ActualDevMaterialCost String Sum of actual costs for the development material.
ProjDevMaterialCost String Sum of projected costs for the development material.
ActualLaunch Date Date when the product is actually launched.
FundingRequestFor String Phase of the proposal for which the funding is requested.
ActualProdVariableCost String Sum of variable costs for the actual production.
NetPresentValue String Difference between present value of cash inflows and the present value of cash outflows. Future cash flows are discounted by the discount rate in order to convert them to present cash flows.
ProductLine String Product line of the proposal.
RequirementsDefinition Date Milestone for the requirements definition.
ProjDevVariableCost String Sum of projected variable costs for development.
BusinessUnit String Business unit of proposal.
ResourceValueIndex String Value that indicates the net present value divided by projected resources for product.
MarketGrowthPercent String Percent of market growth.
BreakEvenTime String Time when break even should be reached.
YearThreeRevenue String Sum of revenues for the first three years after product launch.
SecondaryJustification String Secondary justification for the product proposal.
Rpi String Retail price index of the proposal.
ConceptType String Type of the associated concept.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462