This is a description of the Pricing module
This is the multi-page printable view of this section. Click here to print.
Pricing module
The Pricing module in Vertex
1 - Pricing Domain
This page presents the ERD for each AggregateRoot, grouping related entities into domain boundaries. Each AggregateRoot enforces business rules, processes commands synchronously, and defines consistency borders within a single transactional scope. An indicative json schema is created to how the export of a aggregate root will approximitly look like
Common Product Element
Aggregate Root: CommonProductElement
Represents common product elements with versions, rules, and custom enums for pricing calculations.
erDiagram
"Pricing.CommonProductElementVersionCustomEnums" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
uniqueidentifier CustomEnumId
bit IsNullable
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CommonProductElementVersionKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"Pricing.CommonProductElementVersionRules" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
int RuleType
int Unit
int FeeType
bit Editable
bit Required
int PricingStage
bit ExternallyAvailable
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Rule
}
"Pricing.CommonProductElementVersion_Script" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
uniqueidentifier ScriptId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CommonProductElementVersions" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementId FK
datetimeoffset StartDate
int VersionNumber
nvarchar Comment
bit ResultsCanBeCopiedFromSourcePricing
int DeliveryPeriodDivisionType
bit DealsAreLeading
uniqueidentifier SourcingProductElementId
int Precision
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset PeriodDivisionDate
uniqueidentifier PriceForwardCurveGroupId
int PricingResultType
}
"Pricing.CommonProductElements" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
nvarchar InternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CommonProductElementVersionCustomEnums" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersionKeyValues" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersionRules" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersion_Script" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.ProductElements" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersions" }o--|| "Pricing.CommonProductElements" : "CommonProductElementId"
erDiagram
"Pricing.CommonProductElementVersionCustomEnums" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
uniqueidentifier CustomEnumId
bit IsNullable
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CommonProductElementVersionKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"Pricing.CommonProductElementVersionRules" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
int RuleType
int Unit
int FeeType
bit Editable
bit Required
int PricingStage
bit ExternallyAvailable
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Rule
}
"Pricing.CommonProductElementVersion_Script" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementVersionId FK
uniqueidentifier ScriptId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CommonProductElementVersions" {
uniqueidentifier Id PK
uniqueidentifier CommonProductElementId FK
datetimeoffset StartDate
int VersionNumber
nvarchar Comment
bit ResultsCanBeCopiedFromSourcePricing
int DeliveryPeriodDivisionType
bit DealsAreLeading
uniqueidentifier SourcingProductElementId
int Precision
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset PeriodDivisionDate
uniqueidentifier PriceForwardCurveGroupId
int PricingResultType
}
"Pricing.CommonProductElements" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
nvarchar InternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CommonProductElementVersionCustomEnums" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersionKeyValues" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersionRules" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersion_Script" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.ProductElements" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.CommonProductElementVersions" }o--|| "Pricing.CommonProductElements" : "CommonProductElementId"{
"definitions": {
"Pricing.CommonProductElementVersionCustomEnums": {
"properties": {
"CustomEnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CommonProductElementVersionId": {
"type": "string",
"description": "FK to Pricing.CommonProductElementVersions"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsNullable": {
"type": "boolean",
"description": "bit"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.CommonProductElementVersionRules": {
"properties": {
"PricingStage": {
"type": "integer",
"description": "int"
},
"Required": {
"type": "boolean",
"description": "bit"
},
"FeeType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"RuleType": {
"type": "integer",
"description": "int"
},
"CommonProductElementVersionId": {
"type": "string",
"description": "FK to Pricing.CommonProductElementVersions"
},
"ExternallyAvailable": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Rule": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Editable": {
"type": "boolean",
"description": "bit"
}
},
"type": "object"
},
"Pricing.CommonProductElements": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.CommonProductElementVersion_Script": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CommonProductElementVersionId": {
"type": "string",
"description": "FK to Pricing.CommonProductElementVersions"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ScriptId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.CommonProductElementVersions": {
"properties": {
"Precision": {
"type": "integer",
"description": "int"
},
"PriceForwardCurveGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DealsAreLeading": {
"type": "boolean",
"description": "bit"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"DeliveryPeriodDivisionType": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingResultType": {
"type": "integer",
"description": "int"
},
"SourcingProductElementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ResultsCanBeCopiedFromSourcePricing": {
"type": "boolean",
"description": "bit"
},
"VersionNumber": {
"type": "integer",
"description": "int"
},
"CommonProductElementId": {
"type": "string",
"description": "FK to Pricing.CommonProductElements"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PeriodDivisionDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.CommonProductElementVersionKeyValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CommonProductElementVersionId": {
"type": "string",
"description": "FK to Pricing.CommonProductElementVersions"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Pricing.CommonProductElement",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Pricing
Aggregate Root: Pricing
Represents the main pricing entity with all associated details, results, agreements, and delivery periods for comprehensive pricing management.
erDiagram
"Pricing.FixationQuoteDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationQuoteId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"Pricing.FixationQuotes" {
uniqueidentifier Id PK
uniqueidentifier PricingAgreementId FK
nvarchar InternalReference
nvarchar ExternalReference
bit Indicative
datetimeoffset ReceivedTimestamp
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier FixationRequestId
decimal Capacity
int CapacityUnit
int LoadType
decimal Percentage
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
int PriceReferenceMoment
decimal TargetPercentage
int TradeDirection
decimal Volume
int VolumeUnit
}
"Pricing.FixationSubQuoteDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationSubQuoteId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"Pricing.FixationSubQuotes" {
uniqueidentifier Id PK
uniqueidentifier FixationQuoteId FK
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal TargetPercentage
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
int TradeDirection
int LoadType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ManualPricingValueMetadatas" {
uniqueidentifier Id PK
uniqueidentifier ManualPricingValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int Key
nvarchar Value
int Format
bit FromFeeRule
bit IsPricingOption
uniqueidentifier CustomEnumId FK
}
"Pricing.ManualPricingValues" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier SourcingAgreementId FK
decimal Fee
int Precision
int Unit
bit IsSubResult
int SourceType
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier SourcePricingResultId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementDetailMetadatas" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingAgreementDetailId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementMeteringPointDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingAgreementMeteringPointId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementMeteringPoints" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementOptions" {
uniqueidentifier Id PK
decimal Percentage
uniqueidentifier CustomEnumComponentId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementPricingResultTotals" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
decimal Fee
int Unit
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsIncomplete
int Precision
}
"Pricing.PricingAgreementStrategies" {
uniqueidentifier Id PK
uniqueidentifier PricingAgreementId FK
int SourcingType
uniqueidentifier ProductElementId FK
decimal Percentage
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
decimal StopLossThreshold
int StopLossThresholdUnit
int FallbackStrategySourcingType
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset ProcurementEnd
datetimeoffset ProcurementStart
}
"Pricing.PricingAgreements" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
datetimeoffset Scored
nvarchar InternalReference
nvarchar ExternalReference
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier BrandId
bit Concealed
uniqueidentifier PropositionTemplateVersionId FK
}
"Pricing.PricingCosts" {
uniqueidentifier Id PK
uniqueidentifier PricingDeliveryPeriodCostTrackerId FK
decimal Fee
int Unit
uniqueidentifier ProductElementId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier SalesProductVersionId FK
uniqueidentifier DirectionCustomEnumComponentValueId
bit Concealed
}
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" {
uniqueidentifier Id PK
uniqueidentifier PricingDeliveryPeriodCostTrackerId FK
nvarchar Reason
uniqueidentifier ProductElementId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingDeliveryPeriodCostTrackers" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier PricingAgreementId FK
int Status
int PricingStage
datetimeoffset NextRecheckDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourcingAgreementId FK
}
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" {
uniqueidentifier Id PK
uniqueidentifier PricingDeliveryPeriodResultTrackerId FK
nvarchar Reason
uniqueidentifier ProductElementId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ScriptVersionId
datetimeoffset RevisitDate
bit Concealed
}
"Pricing.PricingDeliveryPeriodResultTrackers" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier PricingDeliveryPeriodId FK
int Status
int PricingStage
datetimeoffset NextRecheckDate
uniqueidentifier LastPricingRunId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourcingAgreementId FK
}
"Pricing.PricingDeliveryPeriods" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
nvarchar Description
int DeliveryPeriodDivisionType
datetimeoffset Start
datetimeoffset End
bit IsPartial
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset PeriodDivisionDate
}
"Pricing.PricingDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit UserOverwritable
int PricingStage
}
"Pricing.PricingGenerationTriggers" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentId FK
uniqueidentifier PricingRequestId FK
int TriggerType
nvarchar TriggerConfiguration
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingProvidedValueMetadatas" {
uniqueidentifier Id PK
uniqueidentifier PricingProvidedValueId FK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingProvidedValues" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingValueProviderTypeImplementationId
int Key
nvarchar Value
int Format
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingResultMetadatas" {
uniqueidentifier Id PK
uniqueidentifier PricingResultId FK
int Key
nvarchar Value
int Format
bit FromFeeRule
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit IsPricingOption
bit Concealed
}
"Pricing.PricingResultTotals" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
decimal Fee
int Unit
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsIncomplete
int Precision
}
"Pricing.PricingResults" {
uniqueidentifier Id PK
decimal Fee
int Unit
bit IsEditable
bit IsRequired
int PricingStage
int SourceType
uniqueidentifier PricingRunId FK
uniqueidentifier ParentProductElementRuleId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier SalesProductVersionId FK
uniqueidentifier SourcePricingResultId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
bit IsSubResult
bit Concealed
uniqueidentifier MigratedFromPricingResultId FK
bit IsIncomplete
decimal CompletionPercentage
int Precision
uniqueidentifier PriceForwardCurveId
int PricingResultType
}
"Pricing.PricingRuns" {
uniqueidentifier Id PK
datetimeoffset Timestamp
datetimeoffset ValidFrom
datetimeoffset ValidUntil
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar SourcePricingInternalReference
bit Concealed
uniqueidentifier SourcingAgreementId FK
int PricingRunType
}
"Pricing.PricingStatus" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
int StatusType
nvarchar Reason
datetimeoffset Timestamp
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingValueProviderKeyValues" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
uniqueidentifier PricingValueProviderStateId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingValueProviderStates" {
uniqueidentifier Id PK
uniqueidentifier PricingValueProviderTypeImplementationId
int State
nvarchar StatusMessage
bit AllowPricingActivation
datetimeoffset ContinuationDateTimeOffset
uniqueidentifier PricingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int StatusType
}
"Pricing.PricingVolumeGroupDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingVolumeGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingVolumeGroups" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar DataSlotReference
nvarchar Revision
int SnapShotTimestamp
nvarchar TimeSeriesCode
}
"Pricing.Pricing_BrandRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier BrandId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.Pricing_ProductComponentRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ProductComponentModelPricingRequestId
bit Concealed
}
"Pricing.Pricings" {
uniqueidentifier Id PK
datetimeoffset IssueOn
nvarchar InternalReference
nvarchar ExternalReference
nvarchar ReuseIdentifier
bit AllowMultipleAgreements
uniqueidentifier PricingRequestId FK
uniqueidentifier PropositionTemplateVersionId FK
uniqueidentifier ProductComponentVersionId FK
uniqueidentifier CorrespondenceId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar SourcePricingInternalReference
uniqueidentifier SalesBatchId
uniqueidentifier SalesBatchItemId
uniqueidentifier ModelPricingRequestId
datetimeoffset ContractStartDate
datetimeoffset ContractEndDate
datetimeoffset PublicationDate
bit SourceInAdvance
datetimeoffset ScoringValidUntil
uniqueidentifier OptionPhaseDetailSetId
bit Concealed
datetimeoffset ValidFromOverride
datetimeoffset ValidUntilOverride
}
"Pricing.SourcingAgreementDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier SourcingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreementPricingResultTotals" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier SourcingAgreementId FK
decimal Fee
int Unit
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsIncomplete
int Precision
}
"Pricing.SourcingAgreementVolumeGroupDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier SourcingAgreementVolumeGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreementVolumeGroups" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier SourcingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreement_ProductComponent" {
uniqueidentifier Id PK
uniqueidentifier SourcingAgreementId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreements" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
datetimeoffset DateSourced
nvarchar InternalReference
nvarchar ExternalReference
nvarchar Comment
datetimeoffset PositionClosingDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier PropositionTemplateVersionId FK
}
"Pricing.FixationQuoteDetails" }o--|| "Pricing.FixationQuotes" : "FixationQuoteId"
"Pricing.FixationQuotes" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.FixationSubQuotes" }o--|| "Pricing.FixationQuotes" : "FixationQuoteId"
"Pricing.FixationSubQuoteDetails" }o--|| "Pricing.FixationSubQuotes" : "FixationSubQuoteId"
"Pricing.FixationSubQuotePeriods" }o--|| "Pricing.FixationSubQuotes" : "FixationSubQuoteId"
"Pricing.ManualPricingValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "Pricing.ManualPricingValues" : "ManualPricingValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.ManualPricingValues" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.ManualPricingValues" }o--|| "Pricing.PricingResults" : "SourcePricingResultId"
"Pricing.ManualPricingValues" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.ManualPricingValues" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ManualPricingValues" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.ManualPricingValues" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "Pricing.PricingAgreementDetails" : "PricingAgreementDetailId"
"Pricing.PricingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "Pricing.PricingAgreementMeteringPoints" : "PricingAgreementMeteringPointId"
"Pricing.PricingAgreementMeteringPoints" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementOptions" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingAgreementStrategies" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingRuns" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreements" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingCosts" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "Pricing.PricingDeliveryPeriodCostTrackers" : "PricingDeliveryPeriodCostTrackerId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingCosts" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.PricingDeliveryPeriodCostTrackers" : "PricingDeliveryPeriodCostTrackerId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.PricingDeliveryPeriodResultTrackers" : "PricingDeliveryPeriodResultTrackerId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.PricingRuns" : "LastPricingRunId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingDeliveryPeriods" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingResults" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingResultTotals" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "Pricing.PricingProvidedValues" : "PricingProvidedValueId"
"Pricing.PricingProvidedValues" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingResultMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "Pricing.PricingResults" : "PricingResultId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.PricingResults" : "MigratedFromPricingResultId"
"Pricing.PricingResults" }o--|| "Pricing.PricingResults" : "SourcePricingResultId"
"Pricing.PricingResults" }o--|| "Pricing.PricingRuns" : "PricingRunId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ParentProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingRuns" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingRuns" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingStatus" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingValueProviderKeyValues" }o--|| "Pricing.PricingValueProviderStates" : "PricingValueProviderStateId"
"Pricing.PricingValueProviderStates" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "Pricing.PricingVolumeGroups" : "PricingVolumeGroupId"
"Pricing.PricingVolumeGroups" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.Pricing_BrandRelation" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.Pricing_ProductComponentRelation" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.Pricing_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.Pricings" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.Pricings" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.Pricings" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.SourcingAgreements" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.SourcingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "Pricing.SourcingAgreementVolumeGroups" : "SourcingAgreementVolumeGroupId"
"Pricing.SourcingAgreementVolumeGroups" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreement_ProductComponent" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.SourcingAgreement_ProductComponent" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
erDiagram
"Pricing.FixationQuoteDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationQuoteId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"Pricing.FixationQuotes" {
uniqueidentifier Id PK
uniqueidentifier PricingAgreementId FK
nvarchar InternalReference
nvarchar ExternalReference
bit Indicative
datetimeoffset ReceivedTimestamp
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier FixationRequestId
decimal Capacity
int CapacityUnit
int LoadType
decimal Percentage
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
int PriceReferenceMoment
decimal TargetPercentage
int TradeDirection
decimal Volume
int VolumeUnit
}
"Pricing.FixationSubQuoteDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationSubQuoteId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"Pricing.FixationSubQuotes" {
uniqueidentifier Id PK
uniqueidentifier FixationQuoteId FK
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal TargetPercentage
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
int TradeDirection
int LoadType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ManualPricingValueMetadatas" {
uniqueidentifier Id PK
uniqueidentifier ManualPricingValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int Key
nvarchar Value
int Format
bit FromFeeRule
bit IsPricingOption
uniqueidentifier CustomEnumId FK
}
"Pricing.ManualPricingValues" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier SourcingAgreementId FK
decimal Fee
int Precision
int Unit
bit IsSubResult
int SourceType
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier SourcePricingResultId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementDetailMetadatas" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingAgreementDetailId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementMeteringPointDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingAgreementMeteringPointId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementMeteringPoints" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementOptions" {
uniqueidentifier Id PK
decimal Percentage
uniqueidentifier CustomEnumComponentId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingAgreementPricingResultTotals" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
decimal Fee
int Unit
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsIncomplete
int Precision
}
"Pricing.PricingAgreementStrategies" {
uniqueidentifier Id PK
uniqueidentifier PricingAgreementId FK
int SourcingType
uniqueidentifier ProductElementId FK
decimal Percentage
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
decimal StopLossThreshold
int StopLossThresholdUnit
int FallbackStrategySourcingType
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset ProcurementEnd
datetimeoffset ProcurementStart
}
"Pricing.PricingAgreements" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
datetimeoffset Scored
nvarchar InternalReference
nvarchar ExternalReference
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier BrandId
bit Concealed
uniqueidentifier PropositionTemplateVersionId FK
}
"Pricing.PricingCosts" {
uniqueidentifier Id PK
uniqueidentifier PricingDeliveryPeriodCostTrackerId FK
decimal Fee
int Unit
uniqueidentifier ProductElementId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier SalesProductVersionId FK
uniqueidentifier DirectionCustomEnumComponentValueId
bit Concealed
}
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" {
uniqueidentifier Id PK
uniqueidentifier PricingDeliveryPeriodCostTrackerId FK
nvarchar Reason
uniqueidentifier ProductElementId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingDeliveryPeriodCostTrackers" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier PricingAgreementId FK
int Status
int PricingStage
datetimeoffset NextRecheckDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourcingAgreementId FK
}
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" {
uniqueidentifier Id PK
uniqueidentifier PricingDeliveryPeriodResultTrackerId FK
nvarchar Reason
uniqueidentifier ProductElementId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ScriptVersionId
datetimeoffset RevisitDate
bit Concealed
}
"Pricing.PricingDeliveryPeriodResultTrackers" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier PricingDeliveryPeriodId FK
int Status
int PricingStage
datetimeoffset NextRecheckDate
uniqueidentifier LastPricingRunId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourcingAgreementId FK
}
"Pricing.PricingDeliveryPeriods" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
nvarchar Description
int DeliveryPeriodDivisionType
datetimeoffset Start
datetimeoffset End
bit IsPartial
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset PeriodDivisionDate
}
"Pricing.PricingDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit UserOverwritable
int PricingStage
}
"Pricing.PricingGenerationTriggers" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentId FK
uniqueidentifier PricingRequestId FK
int TriggerType
nvarchar TriggerConfiguration
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingProvidedValueMetadatas" {
uniqueidentifier Id PK
uniqueidentifier PricingProvidedValueId FK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingProvidedValues" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier PricingValueProviderTypeImplementationId
int Key
nvarchar Value
int Format
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingResultMetadatas" {
uniqueidentifier Id PK
uniqueidentifier PricingResultId FK
int Key
nvarchar Value
int Format
bit FromFeeRule
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit IsPricingOption
bit Concealed
}
"Pricing.PricingResultTotals" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
decimal Fee
int Unit
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsIncomplete
int Precision
}
"Pricing.PricingResults" {
uniqueidentifier Id PK
decimal Fee
int Unit
bit IsEditable
bit IsRequired
int PricingStage
int SourceType
uniqueidentifier PricingRunId FK
uniqueidentifier ParentProductElementRuleId FK
uniqueidentifier ProductElementRuleId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier SalesProductVersionId FK
uniqueidentifier SourcePricingResultId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
bit IsSubResult
bit Concealed
uniqueidentifier MigratedFromPricingResultId FK
bit IsIncomplete
decimal CompletionPercentage
int Precision
uniqueidentifier PriceForwardCurveId
int PricingResultType
}
"Pricing.PricingRuns" {
uniqueidentifier Id PK
datetimeoffset Timestamp
datetimeoffset ValidFrom
datetimeoffset ValidUntil
uniqueidentifier PricingId FK
uniqueidentifier PricingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar SourcePricingInternalReference
bit Concealed
uniqueidentifier SourcingAgreementId FK
int PricingRunType
}
"Pricing.PricingStatus" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
int StatusType
nvarchar Reason
datetimeoffset Timestamp
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingValueProviderKeyValues" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
uniqueidentifier PricingValueProviderStateId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingValueProviderStates" {
uniqueidentifier Id PK
uniqueidentifier PricingValueProviderTypeImplementationId
int State
nvarchar StatusMessage
bit AllowPricingActivation
datetimeoffset ContinuationDateTimeOffset
uniqueidentifier PricingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int StatusType
}
"Pricing.PricingVolumeGroupDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingVolumeGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingVolumeGroups" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar DataSlotReference
nvarchar Revision
int SnapShotTimestamp
nvarchar TimeSeriesCode
}
"Pricing.Pricing_BrandRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier BrandId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.Pricing_ProductComponentRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ProductComponentModelPricingRequestId
bit Concealed
}
"Pricing.Pricings" {
uniqueidentifier Id PK
datetimeoffset IssueOn
nvarchar InternalReference
nvarchar ExternalReference
nvarchar ReuseIdentifier
bit AllowMultipleAgreements
uniqueidentifier PricingRequestId FK
uniqueidentifier PropositionTemplateVersionId FK
uniqueidentifier ProductComponentVersionId FK
uniqueidentifier CorrespondenceId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar SourcePricingInternalReference
uniqueidentifier SalesBatchId
uniqueidentifier SalesBatchItemId
uniqueidentifier ModelPricingRequestId
datetimeoffset ContractStartDate
datetimeoffset ContractEndDate
datetimeoffset PublicationDate
bit SourceInAdvance
datetimeoffset ScoringValidUntil
uniqueidentifier OptionPhaseDetailSetId
bit Concealed
datetimeoffset ValidFromOverride
datetimeoffset ValidUntilOverride
}
"Pricing.SourcingAgreementDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier SourcingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreementPricingResultTotals" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
uniqueidentifier SourcingAgreementId FK
decimal Fee
int Unit
uniqueidentifier PricingDeliveryPeriodId FK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier TariffCustomEnumComponentValueId FK
uniqueidentifier DirectionCustomEnumComponentValueId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsIncomplete
int Precision
}
"Pricing.SourcingAgreementVolumeGroupDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier SourcingAgreementVolumeGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreementVolumeGroups" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier SourcingAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreement_ProductComponent" {
uniqueidentifier Id PK
uniqueidentifier SourcingAgreementId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SourcingAgreements" {
uniqueidentifier Id PK
uniqueidentifier PricingId FK
datetimeoffset DateSourced
nvarchar InternalReference
nvarchar ExternalReference
nvarchar Comment
datetimeoffset PositionClosingDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier PropositionTemplateVersionId FK
}
"Pricing.FixationQuoteDetails" }o--|| "Pricing.FixationQuotes" : "FixationQuoteId"
"Pricing.FixationQuotes" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.FixationSubQuotes" }o--|| "Pricing.FixationQuotes" : "FixationQuoteId"
"Pricing.FixationSubQuoteDetails" }o--|| "Pricing.FixationSubQuotes" : "FixationSubQuoteId"
"Pricing.FixationSubQuotePeriods" }o--|| "Pricing.FixationSubQuotes" : "FixationSubQuoteId"
"Pricing.ManualPricingValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "Pricing.ManualPricingValues" : "ManualPricingValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.ManualPricingValues" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.ManualPricingValues" }o--|| "Pricing.PricingResults" : "SourcePricingResultId"
"Pricing.ManualPricingValues" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.ManualPricingValues" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ManualPricingValues" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.ManualPricingValues" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "Pricing.PricingAgreementDetails" : "PricingAgreementDetailId"
"Pricing.PricingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "Pricing.PricingAgreementMeteringPoints" : "PricingAgreementMeteringPointId"
"Pricing.PricingAgreementMeteringPoints" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementOptions" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingAgreementStrategies" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreementStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingRuns" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingAgreements" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.PricingAgreements" : "PricingAgreementId"
"Pricing.PricingCosts" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "Pricing.PricingDeliveryPeriodCostTrackers" : "PricingDeliveryPeriodCostTrackerId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingCosts" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.PricingDeliveryPeriodCostTrackers" : "PricingDeliveryPeriodCostTrackerId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingDeliveryPeriodCostTrackers" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.PricingDeliveryPeriodResultTrackers" : "PricingDeliveryPeriodResultTrackerId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.PricingRuns" : "LastPricingRunId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingDeliveryPeriodResultTrackers" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingDeliveryPeriods" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingResults" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingResultTotals" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.PricingDeliveryPeriods" : "PricingDeliveryPeriodId"
"Pricing.PricingDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "Pricing.PricingProvidedValues" : "PricingProvidedValueId"
"Pricing.PricingProvidedValues" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingResultMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "Pricing.PricingResults" : "PricingResultId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.PricingResults" : "MigratedFromPricingResultId"
"Pricing.PricingResults" }o--|| "Pricing.PricingResults" : "SourcePricingResultId"
"Pricing.PricingResults" }o--|| "Pricing.PricingRuns" : "PricingRunId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ParentProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingRuns" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingRuns" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.PricingStatus" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingValueProviderKeyValues" }o--|| "Pricing.PricingValueProviderStates" : "PricingValueProviderStateId"
"Pricing.PricingValueProviderStates" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.PricingVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "Pricing.PricingVolumeGroups" : "PricingVolumeGroupId"
"Pricing.PricingVolumeGroups" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.Pricing_BrandRelation" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.Pricing_ProductComponentRelation" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.Pricing_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.Pricings" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.Pricings" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.Pricings" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.SourcingAgreements" }o--|| "Pricing.Pricings" : "PricingId"
"Pricing.SourcingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "Pricing.SourcingAgreementVolumeGroups" : "SourcingAgreementVolumeGroupId"
"Pricing.SourcingAgreementVolumeGroups" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreement_ProductComponent" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.SourcingAgreement_ProductComponent" }o--|| "Pricing.SourcingAgreements" : "SourcingAgreementId"
"Pricing.SourcingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"{
"definitions": {
"Pricing.SourcingAgreement_ProductComponent": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductComponentId": {
"type": "string",
"description": "FK to Pricing.ProductComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingValueProviderKeyValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingValueProviderStateId": {
"type": "string",
"description": "FK to Pricing.PricingValueProviderStates"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.Pricing_BrandRelation": {
"properties": {
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"BrandId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingAgreementStrategies": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"FallbackStrategySourcingType": {
"type": "integer",
"description": "int"
},
"ProcurementEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProcurementPeriodInMonths": {
"type": "integer",
"description": "int"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Percentage": {
"type": "string",
"description": "decimal"
},
"ProcurementStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"ProcurementOffsetPeriodInMonths": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"StopLossThresholdUnit": {
"type": "integer",
"description": "int"
},
"ProcurementDeliveryPeriodInMonths": {
"type": "integer",
"description": "int"
},
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StopLossThreshold": {
"type": "string",
"description": "decimal"
}
},
"type": "object"
},
"Pricing.PricingDetails": {
"properties": {
"PricingStage": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"UserOverwritable": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.PricingDeliveryPeriods": {
"properties": {
"End": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"DeliveryPeriodDivisionType": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Start": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PeriodDivisionDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"IsPartial": {
"type": "boolean",
"description": "bit"
}
},
"type": "object"
},
"Pricing.PricingAgreementMeteringPointDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementMeteringPointId": {
"type": "string",
"description": "FK to Pricing.PricingAgreementMeteringPoints"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.PricingVolumeGroupDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PricingVolumeGroupId": {
"type": "string",
"description": "FK to Pricing.PricingVolumeGroups"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.PricingResults": {
"properties": {
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MigratedFromPricingResultId": {
"type": "string",
"description": "FK to Pricing.PricingResults"
},
"IsSubResult": {
"type": "boolean",
"description": "bit"
},
"Precision": {
"type": "integer",
"description": "int"
},
"SourceType": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceForwardCurveId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DirectionCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"PricingRunId": {
"type": "string",
"description": "FK to Pricing.PricingRuns"
},
"IsIncomplete": {
"type": "boolean",
"description": "bit"
},
"PricingDeliveryPeriodId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriods"
},
"CompletionPercentage": {
"type": "string",
"description": "decimal"
},
"Fee": {
"type": "string",
"description": "decimal"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsEditable": {
"type": "boolean",
"description": "bit"
},
"IsRequired": {
"type": "boolean",
"description": "bit"
},
"TariffCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"PricingStage": {
"type": "integer",
"description": "int"
},
"SourcePricingResultId": {
"type": "string",
"description": "FK to Pricing.PricingResults"
},
"ProductElementRuleId": {
"type": "string",
"description": "FK to Pricing.ProductElementRules"
},
"PricingResultType": {
"type": "integer",
"description": "int"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"ParentProductElementRuleId": {
"type": "string",
"description": "FK to Pricing.ProductElementRules"
}
},
"type": "object"
},
"Pricing.ManualPricingValues": {
"properties": {
"Precision": {
"type": "integer",
"description": "int"
},
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourceType": {
"type": "integer",
"description": "int"
},
"ProductElementRuleId": {
"type": "string",
"description": "FK to Pricing.ProductElementRules"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"PricingDeliveryPeriodId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriods"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"Fee": {
"type": "string",
"description": "decimal"
},
"IsSubResult": {
"type": "boolean",
"description": "bit"
},
"SourcePricingResultId": {
"type": "string",
"description": "FK to Pricing.PricingResults"
},
"DirectionCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"TariffCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
}
},
"type": "object"
},
"Pricing.PricingDeliveryPeriodResultTrackers": {
"properties": {
"PricingStage": {
"type": "integer",
"description": "int"
},
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingDeliveryPeriodId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriods"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"LastPricingRunId": {
"type": "string",
"description": "FK to Pricing.PricingRuns"
},
"Status": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"NextRecheckDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
}
},
"type": "object"
},
"Pricing.FixationSubQuoteDetails": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FixationSubQuoteId": {
"type": "string",
"description": "FK to Pricing.FixationSubQuotes"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.SourcingAgreementVolumeGroupDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SourcingAgreementVolumeGroupId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreementVolumeGroups"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.PricingAgreementPricingResultTotals": {
"properties": {
"Precision": {
"type": "integer",
"description": "int"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Fee": {
"type": "string",
"description": "decimal"
},
"PricingDeliveryPeriodId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriods"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"IsIncomplete": {
"type": "boolean",
"description": "bit"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DirectionCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"TariffCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
}
},
"type": "object"
},
"Pricing.PricingAgreementDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.Pricings": {
"properties": {
"OptionPhaseDetailSetId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
},
"ModelPricingRequestId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractStartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SalesBatchId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentVersionId": {
"type": "string",
"description": "FK to Pricing.ProductComponentVersions"
},
"SourceInAdvance": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SalesBatchItemId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IssueOn": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ValidFromOverride": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ReuseIdentifier": {
"type": "string",
"description": "nvarchar"
},
"PropositionTemplateVersionId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplateVersions"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"ValidUntilOverride": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"AllowMultipleAgreements": {
"type": "boolean",
"description": "bit"
},
"ContractEndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ScoringValidUntil": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PublicationDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CorrespondenceId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"SourcePricingInternalReference": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"Pricing.PricingDeliveryPeriodCostTrackers": {
"properties": {
"PricingStage": {
"type": "integer",
"description": "int"
},
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingDeliveryPeriodId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriods"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Status": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"NextRecheckDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
}
},
"type": "object"
},
"Pricing.PricingAgreementMeteringPoints": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingRuns": {
"properties": {
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcePricingInternalReference": {
"type": "string",
"description": "nvarchar"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PricingRunType": {
"type": "integer",
"description": "int"
},
"ValidUntil": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"ValidFrom": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Timestamp": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingStatus": {
"properties": {
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StatusType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Reason": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Timestamp": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingValueProviderStates": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContinuationDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StatusMessage": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingValueProviderTypeImplementationId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"StatusType": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"State": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"AllowPricingActivation": {
"type": "boolean",
"description": "bit"
}
},
"type": "object"
},
"Pricing.PricingResultMetadatas": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"IsPricingOption": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FromFeeRule": {
"type": "boolean",
"description": "bit"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingResultId": {
"type": "string",
"description": "FK to Pricing.PricingResults"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.PricingProvidedValueMetadatas": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PricingProvidedValueId": {
"type": "string",
"description": "FK to Pricing.PricingProvidedValues"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.FixationSubQuotes": {
"properties": {
"TradeDirection": {
"type": "integer",
"description": "int"
},
"PriceForwardCurveGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DeliveryPeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"VolumeUnit": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Percentage": {
"type": "string",
"description": "decimal"
},
"FixationQuoteId": {
"type": "string",
"description": "FK to Pricing.FixationQuotes"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TargetPercentage": {
"type": "string",
"description": "decimal"
},
"Capacity": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Volume": {
"type": "string",
"description": "decimal"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"CapacityUnit": {
"type": "integer",
"description": "int"
},
"PriceIndexReferenceDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.SourcingAgreementDetails": {
"properties": {
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.ManualPricingValueMetadatas": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"IsPricingOption": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FromFeeRule": {
"type": "boolean",
"description": "bit"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ManualPricingValueId": {
"type": "string",
"description": "FK to Pricing.ManualPricingValues"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.SourcingAgreements": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DateSourced": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PositionClosingDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PropositionTemplateVersionId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplateVersions"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
}
},
"type": "object"
},
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons": {
"properties": {
"ScriptVersionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductElementRuleId": {
"type": "string",
"description": "FK to Pricing.ProductElementRules"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Reason": {
"type": "string",
"description": "nvarchar"
},
"RevisitDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingDeliveryPeriodResultTrackerId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriodResultTrackers"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.FixationQuoteDetails": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FixationQuoteId": {
"type": "string",
"description": "FK to Pricing.FixationQuotes"
}
},
"type": "object"
},
"Pricing.Pricing_ProductComponentRelation": {
"properties": {
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductComponentModelPricingRequestId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentId": {
"type": "string",
"description": "FK to Pricing.ProductComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingAgreementOptions": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CustomEnumComponentId": {
"type": "string",
"description": "FK to PM.CustomEnumComponents"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Percentage": {
"type": "string",
"description": "decimal"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.SourcingAgreementPricingResultTotals": {
"properties": {
"Precision": {
"type": "integer",
"description": "int"
},
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Fee": {
"type": "string",
"description": "decimal"
},
"PricingDeliveryPeriodId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriods"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IsIncomplete": {
"type": "boolean",
"description": "bit"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"DirectionCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"TariffCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
}
},
"type": "object"
},
"Pricing.FixationQuotes": {
"properties": {
"TradeDirection": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"VolumeUnit": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Percentage": {
"type": "string",
"description": "decimal"
},
"PriceIndexReferenceDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"PriceReferenceMoment": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"type": "string",
"description": "FK to Pricing.PricingAgreements"
},
"TargetPercentage": {
"type": "string",
"description": "decimal"
},
"Capacity": {
"type": "string",
"description": "decimal"
},
"ReceivedTimestamp": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"Indicative": {
"type": "boolean",
"description": "bit"
},
"Volume": {
"type": "string",
"description": "decimal"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FixationRequestId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CapacityUnit": {
"type": "integer",
"description": "int"
},
"PriceForwardCurveGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons": {
"properties": {
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingDeliveryPeriodCostTrackerId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriodCostTrackers"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductElementRuleId": {
"type": "string",
"description": "FK to Pricing.ProductElementRules"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Reason": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingAgreementDetailMetadatas": {
"properties": {
"PricingAgreementDetailId": {
"type": "string",
"description": "FK to Pricing.PricingAgreementDetails"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.SourcingAgreementVolumeGroups": {
"properties": {
"SourcingAgreementId": {
"type": "string",
"description": "FK to Pricing.SourcingAgreements"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingCosts": {
"properties": {
"PricingDeliveryPeriodCostTrackerId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriodCostTrackers"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductElementRuleId": {
"type": "string",
"description": "FK to Pricing.ProductElementRules"
},
"Fee": {
"type": "string",
"description": "decimal"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DirectionCustomEnumComponentValueId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"TariffCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
}
},
"type": "object"
},
"Pricing.PricingResultTotals": {
"properties": {
"Precision": {
"type": "integer",
"description": "int"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Fee": {
"type": "string",
"description": "decimal"
},
"PricingDeliveryPeriodId": {
"type": "string",
"description": "FK to Pricing.PricingDeliveryPeriods"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IsIncomplete": {
"type": "boolean",
"description": "bit"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DirectionCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"TariffCustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
}
},
"type": "object"
},
"Pricing.PricingVolumeGroups": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"SnapShotTimestamp": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Revision": {
"type": "string",
"description": "nvarchar"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingGenerationTriggers": {
"properties": {
"TriggerConfiguration": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"TriggerType": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductComponentId": {
"type": "string",
"description": "FK to Pricing.ProductComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
}
},
"type": "object"
},
"Pricing.PricingAgreements": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PropositionTemplateVersionId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplateVersions"
},
"Scored": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"BrandId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
}
},
"type": "object"
},
"Pricing.PricingProvidedValues": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"PricingValueProviderTypeImplementationId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingId": {
"type": "string",
"description": "FK to Pricing.Pricings"
}
},
"type": "object"
}
},
"title": "Pricing.Pricing",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Pricing Request
Aggregate Root: PricingRequest
Represents pricing requests with their details, metering points, and associated brands and product components.
erDiagram
"Pricing.ContractVolumeDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier ContractVolumeId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ContractVolumes" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingRequestId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequestDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingRequestId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit UserOverwritableInPricing
int PricingStage
}
"Pricing.PricingRequestMeteringPointDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingRequestMeteringPointId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequestMeteringPoints" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingRequestId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequestStrategies" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
int SourcingType
uniqueidentifier ProductElementId FK
decimal Percentage
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
decimal StopLossThreshold
int StopLossThresholdUnit
int FallbackStrategySourcingType
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset ProcurementEnd
datetimeoffset ProcurementStart
}
"Pricing.PricingRequest_BrandRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
uniqueidentifier BrandId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequest_ProductComponentRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ProductComponentModelPricingRequestId
bit Concealed
}
"Pricing.PricingRequest_TSSelector" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapShotTimeStamp
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequests" {
uniqueidentifier Id PK
datetimeoffset IssueOn
nvarchar InternalReference
nvarchar ExternalReference
nvarchar Comment
nvarchar SourceApplication
uniqueidentifier PropositionTemplateId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar SourcePricingInternalReference
uniqueidentifier SalesBatchId
uniqueidentifier SalesBatchItemId
uniqueidentifier ModelPricingRequestId
datetimeoffset ContractStartDate
datetimeoffset ContractEndDate
bit SourceInAdvance
uniqueidentifier OptionPhaseDetailSetId
bit Concealed
}
"Pricing.ContractVolumeDetails" }o--|| "Pricing.ContractVolumes" : "ContractVolumeId"
"Pricing.ContractVolumeDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumes" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "Pricing.PricingRequestMeteringPoints" : "PricingRequestMeteringPointId"
"Pricing.PricingRequestMeteringPoints" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestStrategies" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingRequest_BrandRelation" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequest_ProductComponentRelation" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequest_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequest_TSSelector" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequests" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequests" }o--|| "Pricing.PropositionTemplates" : "PropositionTemplateId"
"Pricing.Pricings" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
erDiagram
"Pricing.ContractVolumeDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier ContractVolumeId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ContractVolumes" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingRequestId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequestDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingRequestId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit UserOverwritableInPricing
int PricingStage
}
"Pricing.PricingRequestMeteringPointDetails" {
uniqueidentifier Id PK
int Key
nvarchar Value
int Format
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier CustomEnumId FK
uniqueidentifier PricingRequestMeteringPointId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequestMeteringPoints" {
uniqueidentifier Id PK
nvarchar Name
nvarchar EAN
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier PricingRequestId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequestStrategies" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
int SourcingType
uniqueidentifier ProductElementId FK
decimal Percentage
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
decimal StopLossThreshold
int StopLossThresholdUnit
int FallbackStrategySourcingType
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset ProcurementEnd
datetimeoffset ProcurementStart
}
"Pricing.PricingRequest_BrandRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
uniqueidentifier BrandId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequest_ProductComponentRelation" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ProductComponentModelPricingRequestId
bit Concealed
}
"Pricing.PricingRequest_TSSelector" {
uniqueidentifier Id PK
uniqueidentifier PricingRequestId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapShotTimeStamp
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PricingRequests" {
uniqueidentifier Id PK
datetimeoffset IssueOn
nvarchar InternalReference
nvarchar ExternalReference
nvarchar Comment
nvarchar SourceApplication
uniqueidentifier PropositionTemplateId FK
uniqueidentifier ProductComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar SourcePricingInternalReference
uniqueidentifier SalesBatchId
uniqueidentifier SalesBatchItemId
uniqueidentifier ModelPricingRequestId
datetimeoffset ContractStartDate
datetimeoffset ContractEndDate
bit SourceInAdvance
uniqueidentifier OptionPhaseDetailSetId
bit Concealed
}
"Pricing.ContractVolumeDetails" }o--|| "Pricing.ContractVolumes" : "ContractVolumeId"
"Pricing.ContractVolumeDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumes" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "Pricing.PricingRequestMeteringPoints" : "PricingRequestMeteringPointId"
"Pricing.PricingRequestMeteringPoints" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestStrategies" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequestStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingRequest_BrandRelation" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequest_ProductComponentRelation" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequest_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequest_TSSelector" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.PricingRequests" : "PricingRequestId"
"Pricing.PricingRequests" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequests" }o--|| "Pricing.PropositionTemplates" : "PropositionTemplateId"
"Pricing.Pricings" }o--|| "Pricing.PricingRequests" : "PricingRequestId"{
"definitions": {
"Pricing.PricingRequestMeteringPoints": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingRequest_ProductComponentRelation": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductComponentModelPricingRequestId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentId": {
"type": "string",
"description": "FK to Pricing.ProductComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
}
},
"type": "object"
},
"Pricing.PricingRequest_TSSelector": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SnapShotTimeStamp": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Revision": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"Pricing.PricingRequestStrategies": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"FallbackStrategySourcingType": {
"type": "integer",
"description": "int"
},
"ProcurementEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProcurementDeliveryPeriodInMonths": {
"type": "integer",
"description": "int"
},
"ProcurementPeriodInMonths": {
"type": "integer",
"description": "int"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Percentage": {
"type": "string",
"description": "decimal"
},
"ProcurementStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProcurementOffsetPeriodInMonths": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"StopLossThresholdUnit": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
},
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StopLossThreshold": {
"type": "string",
"description": "decimal"
}
},
"type": "object"
},
"Pricing.PricingRequests": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentId": {
"type": "string",
"description": "FK to Pricing.ProductComponents"
},
"SalesBatchItemId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractStartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SalesBatchId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"OptionPhaseDetailSetId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"SourcePricingInternalReference": {
"type": "string",
"description": "nvarchar"
},
"ModelPricingRequestId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IssueOn": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"SourceInAdvance": {
"type": "boolean",
"description": "bit"
},
"PropositionTemplateId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplates"
},
"SourceApplication": {
"type": "string",
"description": "nvarchar"
},
"ContractEndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingRequestDetails": {
"properties": {
"PricingStage": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"UserOverwritableInPricing": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.PricingRequestMeteringPointDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PricingRequestMeteringPointId": {
"type": "string",
"description": "FK to Pricing.PricingRequestMeteringPoints"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.ContractVolumes": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PricingRequest_BrandRelation": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"BrandId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingRequestId": {
"type": "string",
"description": "FK to Pricing.PricingRequests"
}
},
"type": "object"
},
"Pricing.ContractVolumeDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Format": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ContractVolumeId": {
"type": "string",
"description": "FK to Pricing.ContractVolumes"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
}
},
"title": "Pricing.PricingRequest",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Product Component
Aggregate Root: ProductComponent
Represents product components with their versions, rules, key values, and associated product elements for pricing calculations.
erDiagram
"Pricing.ProductComponentKeyValues" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentVersionId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductComponentPricingValueProviders" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentVersionId FK
uniqueidentifier PricingValueProviderTypeImplementationId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductComponentRules" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentVersionId FK
int RuleType
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductComponentVersions" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentId FK
datetimeoffset StartDate
int VersionNumber
nvarchar Comment
bit InterruptCalculationOnMissingPricing
bit GenerateMissingPricing
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier VolumeGroupGenerationScriptId
nvarchar MaxDeliveryPeriodDeviationOnReUse
bit Concealed
uniqueidentifier SupplyAgreementGenerationScriptId
uniqueidentifier ProductCustomEnumComponentId FK
uniqueidentifier SourcingProductComponentId
}
"Pricing.ProductComponents" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar InternalReference
}
"Pricing.ProductElementCustomEnums" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
uniqueidentifier CustomEnumId
bit IsNullable
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductElementKeyValues" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsInheritedFromCPE
}
"Pricing.ProductElementRules" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
int RuleType
int Unit
int FeeType
bit Editable
bit Required
int PricingStage
bit ExternallyAvailable
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int ProductComponentPricingPricingStage
}
"Pricing.ProductElement_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentId FK
nvarchar ProductElementName
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductElement_Script" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
uniqueidentifier ScriptId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductElements" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier ProductComponentVersionId FK
int DisplayOrderIndex
int CalculationOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit ResultsCanBeCopiedFromSourcePricing
int DeliveryPeriodDivisionType
bit DealsAreLeading
bit Concealed
uniqueidentifier SourcingProductElementId
int SubResultDeliveryPeriodDivisionType
int Precision
uniqueidentifier CommonProductElementVersionId FK
bit SourcingProductElementIdIsInheritedFromCPE
datetimeoffset PeriodDivisionDate
uniqueidentifier PriceForwardCurveGroupId
bit PriceForwardCurveGroupIdIsInheritedFromCPE
int PricingResultType
}
"Pricing.ProductComponentKeyValues" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.ProductComponentPricingValueProviders" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.ProductComponentRules" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.Pricings" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.ProductComponentVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.ProductElements" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.SalesProductVersion_ProductComponentVersion" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequest_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequests" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.ProductElement_CategoryLabel" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.SourcingAgreement_ProductComponent" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.Pricing_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.ProductElementCustomEnums" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.ProductElementKeyValues" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ParentProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ManualPricingValues" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ProductElementRules" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ProductElement_Script" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.ProductElements" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.PricingRequestStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingAgreementStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"
erDiagram
"Pricing.ProductComponentKeyValues" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentVersionId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductComponentPricingValueProviders" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentVersionId FK
uniqueidentifier PricingValueProviderTypeImplementationId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductComponentRules" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentVersionId FK
int RuleType
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductComponentVersions" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentId FK
datetimeoffset StartDate
int VersionNumber
nvarchar Comment
bit InterruptCalculationOnMissingPricing
bit GenerateMissingPricing
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier VolumeGroupGenerationScriptId
nvarchar MaxDeliveryPeriodDeviationOnReUse
bit Concealed
uniqueidentifier SupplyAgreementGenerationScriptId
uniqueidentifier ProductCustomEnumComponentId FK
uniqueidentifier SourcingProductComponentId
}
"Pricing.ProductComponents" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar InternalReference
}
"Pricing.ProductElementCustomEnums" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
uniqueidentifier CustomEnumId
bit IsNullable
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductElementKeyValues" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit IsInheritedFromCPE
}
"Pricing.ProductElementRules" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
int RuleType
int Unit
int FeeType
bit Editable
bit Required
int PricingStage
bit ExternallyAvailable
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int ProductComponentPricingPricingStage
}
"Pricing.ProductElement_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier ProductComponentId FK
nvarchar ProductElementName
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductElement_Script" {
uniqueidentifier Id PK
uniqueidentifier ProductElementId FK
uniqueidentifier ScriptId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.ProductElements" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier ProductComponentVersionId FK
int DisplayOrderIndex
int CalculationOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit ResultsCanBeCopiedFromSourcePricing
int DeliveryPeriodDivisionType
bit DealsAreLeading
bit Concealed
uniqueidentifier SourcingProductElementId
int SubResultDeliveryPeriodDivisionType
int Precision
uniqueidentifier CommonProductElementVersionId FK
bit SourcingProductElementIdIsInheritedFromCPE
datetimeoffset PeriodDivisionDate
uniqueidentifier PriceForwardCurveGroupId
bit PriceForwardCurveGroupIdIsInheritedFromCPE
int PricingResultType
}
"Pricing.ProductComponentKeyValues" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.ProductComponentPricingValueProviders" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.ProductComponentRules" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.Pricings" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.ProductComponentVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.ProductElements" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.SalesProductVersion_ProductComponentVersion" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.PricingGenerationTriggers" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequest_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.PricingRequests" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.ProductElement_CategoryLabel" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.SourcingAgreement_ProductComponent" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.Pricing_ProductComponentRelation" }o--|| "Pricing.ProductComponents" : "ProductComponentId"
"Pricing.ProductElementCustomEnums" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.ProductElementKeyValues" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ParentProductElementRuleId"
"Pricing.PricingResults" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ManualPricingValues" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ProductElementRules" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElementRules" : "ProductElementRuleId"
"Pricing.ProductElement_Script" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodResultTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.ProductElements" }o--|| "Pricing.CommonProductElementVersions" : "CommonProductElementVersionId"
"Pricing.PricingRequestStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingAgreementStrategies" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingCosts" }o--|| "Pricing.ProductElements" : "ProductElementId"
"Pricing.PricingDeliveryPeriodCostTrackerStatusReasons" }o--|| "Pricing.ProductElements" : "ProductElementId"{
"definitions": {
"Pricing.ProductElement_CategoryLabel": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductElementName": {
"type": "string",
"description": "nvarchar"
},
"CategoryLabelId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CategoryId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentId": {
"type": "string",
"description": "FK to Pricing.ProductComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductComponentVersions": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentId": {
"type": "string",
"description": "FK to Pricing.ProductComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"VolumeGroupGenerationScriptId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SupplyAgreementGenerationScriptId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"SourcingProductComponentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MaxDeliveryPeriodDeviationOnReUse": {
"type": "string",
"description": "nvarchar"
},
"GenerateMissingPricing": {
"type": "boolean",
"description": "bit"
},
"InterruptCalculationOnMissingPricing": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"VersionNumber": {
"type": "integer",
"description": "int"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductCustomEnumComponentId": {
"type": "string",
"description": "FK to PM.CustomEnumComponents"
}
},
"type": "object"
},
"Pricing.ProductComponentKeyValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentVersionId": {
"type": "string",
"description": "FK to Pricing.ProductComponentVersions"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductComponentPricingValueProviders": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingValueProviderTypeImplementationId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentVersionId": {
"type": "string",
"description": "FK to Pricing.ProductComponentVersions"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductElementKeyValues": {
"properties": {
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IsInheritedFromCPE": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductComponentRules": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"RuleType": {
"type": "integer",
"description": "int"
},
"ProductComponentVersionId": {
"type": "string",
"description": "FK to Pricing.ProductComponentVersions"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Rule": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductElementCustomEnums": {
"properties": {
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CustomEnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsNullable": {
"type": "boolean",
"description": "bit"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductElement_Script": {
"properties": {
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ScriptId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductElements": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"SubResultDeliveryPeriodDivisionType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CalculationOrderIndex": {
"type": "integer",
"description": "int"
},
"CommonProductElementVersionId": {
"type": "string",
"description": "FK to Pricing.CommonProductElementVersions"
},
"DeliveryPeriodDivisionType": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentVersionId": {
"type": "string",
"description": "FK to Pricing.ProductComponentVersions"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"DisplayOrderIndex": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ResultsCanBeCopiedFromSourcePricing": {
"type": "boolean",
"description": "bit"
},
"PricingResultType": {
"type": "integer",
"description": "int"
},
"Precision": {
"type": "integer",
"description": "int"
},
"SourcingProductElementIdIsInheritedFromCPE": {
"type": "boolean",
"description": "bit"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DealsAreLeading": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PeriodDivisionDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SourcingProductElementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceForwardCurveGroupIdIsInheritedFromCPE": {
"type": "boolean",
"description": "bit"
},
"PriceForwardCurveGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductElementRules": {
"properties": {
"PricingStage": {
"type": "integer",
"description": "int"
},
"Required": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductElementId": {
"type": "string",
"description": "FK to Pricing.ProductElements"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Rule": {
"type": "string",
"description": "nvarchar"
},
"RuleType": {
"type": "integer",
"description": "int"
},
"ProductComponentPricingPricingStage": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExternallyAvailable": {
"type": "boolean",
"description": "bit"
},
"FeeType": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Editable": {
"type": "boolean",
"description": "bit"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.ProductComponents": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Pricing.ProductComponent",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Proposition Template
Aggregate Root: PropositionTemplate
Represents proposition templates with their versions, rules, key values, and associated sales product versions.
erDiagram
"Pricing.PropositionTemplateKeyValues" {
uniqueidentifier Id PK
uniqueidentifier PropositionTemplateVersionId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PropositionTemplateRules" {
uniqueidentifier Id PK
int RuleType
uniqueidentifier PropositionTemplateVersionId FK
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PropositionTemplateVersion_SalesProductVersion" {
uniqueidentifier Id PK
uniqueidentifier PropositionTemplateVersionId FK
uniqueidentifier SalesProductVersionId FK
int CalculationOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ParentSalesProductVersionId FK
bit Concealed
}
"Pricing.PropositionTemplateVersions" {
uniqueidentifier Id PK
uniqueidentifier PropositionTemplateId FK
datetimeoffset StartDate
int VersionNumber
bit IsRevoked
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier VolumeGroupGenerationScriptId
bit Concealed
uniqueidentifier SupplyAgreementGenerationScriptId
}
"Pricing.PropositionTemplates" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar InternalReference
}
"Pricing.PropositionTemplateKeyValues" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateRules" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "ParentSalesProductVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.Pricings" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateVersions" }o--|| "Pricing.PropositionTemplates" : "PropositionTemplateId"
"Pricing.SourcingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PricingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PricingRequests" }o--|| "Pricing.PropositionTemplates" : "PropositionTemplateId"
erDiagram
"Pricing.PropositionTemplateKeyValues" {
uniqueidentifier Id PK
uniqueidentifier PropositionTemplateVersionId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PropositionTemplateRules" {
uniqueidentifier Id PK
int RuleType
uniqueidentifier PropositionTemplateVersionId FK
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.PropositionTemplateVersion_SalesProductVersion" {
uniqueidentifier Id PK
uniqueidentifier PropositionTemplateVersionId FK
uniqueidentifier SalesProductVersionId FK
int CalculationOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier ParentSalesProductVersionId FK
bit Concealed
}
"Pricing.PropositionTemplateVersions" {
uniqueidentifier Id PK
uniqueidentifier PropositionTemplateId FK
datetimeoffset StartDate
int VersionNumber
bit IsRevoked
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier VolumeGroupGenerationScriptId
bit Concealed
uniqueidentifier SupplyAgreementGenerationScriptId
}
"Pricing.PropositionTemplates" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar InternalReference
}
"Pricing.PropositionTemplateKeyValues" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateRules" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "ParentSalesProductVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.Pricings" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PropositionTemplateVersions" }o--|| "Pricing.PropositionTemplates" : "PropositionTemplateId"
"Pricing.SourcingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PricingAgreements" }o--|| "Pricing.PropositionTemplateVersions" : "PropositionTemplateVersionId"
"Pricing.PricingRequests" }o--|| "Pricing.PropositionTemplates" : "PropositionTemplateId"{
"definitions": {
"Pricing.PropositionTemplateVersions": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"VolumeGroupGenerationScriptId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsRevoked": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SupplyAgreementGenerationScriptId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PropositionTemplateId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplates"
},
"VersionNumber": {
"type": "integer",
"description": "int"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Pricing.PropositionTemplates": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PropositionTemplateKeyValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"PropositionTemplateVersionId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplateVersions"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PropositionTemplateRules": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Rule": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"RuleType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PropositionTemplateVersionId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplateVersions"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.PropositionTemplateVersion_SalesProductVersion": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"PropositionTemplateVersionId": {
"type": "string",
"description": "FK to Pricing.PropositionTemplateVersions"
},
"ParentSalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CalculationOrderIndex": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Pricing.PropositionTemplate",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Sales Product
Aggregate Root: SalesProduct
Represents sales products with their versions, rules, key values, and associated product component versions.
erDiagram
"Pricing.SalesProductKeyValues" {
uniqueidentifier Id PK
uniqueidentifier SalesProductVersionId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProductRules" {
uniqueidentifier Id PK
uniqueidentifier SalesProductVersionId FK
int RuleType
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProductVersion_ProductComponentVersion" {
uniqueidentifier Id PK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier ProductComponentVersionId FK
int DisplayOrderIndex
int CalculationOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProductVersions" {
uniqueidentifier Id PK
uniqueidentifier SalesProductId FK
datetimeoffset StartDate
int VersionNumber
nvarchar Comment
uniqueidentifier ProductCustomEnumComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProducts" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
int DisplayOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar InternalReference
bit Concealed
}
"Pricing.SalesProductKeyValues" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SalesProductRules" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SalesProductVersion_ProductComponentVersion" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.SalesProductVersion_ProductComponentVersion" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingResults" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.ManualPricingValues" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "ParentSalesProductVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SalesProductVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "Pricing.SalesProducts" : "SalesProductId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingCosts" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
erDiagram
"Pricing.SalesProductKeyValues" {
uniqueidentifier Id PK
uniqueidentifier SalesProductVersionId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProductRules" {
uniqueidentifier Id PK
uniqueidentifier SalesProductVersionId FK
int RuleType
nvarchar Rule
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProductVersion_ProductComponentVersion" {
uniqueidentifier Id PK
uniqueidentifier SalesProductVersionId FK
uniqueidentifier ProductComponentVersionId FK
int DisplayOrderIndex
int CalculationOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProductVersions" {
uniqueidentifier Id PK
uniqueidentifier SalesProductId FK
datetimeoffset StartDate
int VersionNumber
nvarchar Comment
uniqueidentifier ProductCustomEnumComponentId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.SalesProducts" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
int DisplayOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar InternalReference
bit Concealed
}
"Pricing.SalesProductKeyValues" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SalesProductRules" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SalesProductVersion_ProductComponentVersion" }o--|| "Pricing.ProductComponentVersions" : "ProductComponentVersionId"
"Pricing.SalesProductVersion_ProductComponentVersion" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingResults" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.ManualPricingValues" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "ParentSalesProductVersionId"
"Pricing.PropositionTemplateVersion_SalesProductVersion" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.SalesProductVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "Pricing.SalesProducts" : "SalesProductId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"
"Pricing.PricingCosts" }o--|| "Pricing.SalesProductVersions" : "SalesProductVersionId"{
"definitions": {
"Pricing.SalesProductVersions": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"SalesProductId": {
"type": "string",
"description": "FK to Pricing.SalesProducts"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"VersionNumber": {
"type": "integer",
"description": "int"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductCustomEnumComponentId": {
"type": "string",
"description": "FK to PM.CustomEnumComponents"
}
},
"type": "object"
},
"Pricing.SalesProducts": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"DisplayOrderIndex": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.SalesProductKeyValues": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"Pricing.SalesProductVersion_ProductComponentVersion": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"DisplayOrderIndex": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductComponentVersionId": {
"type": "string",
"description": "FK to Pricing.ProductComponentVersions"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CalculationOrderIndex": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.SalesProductRules": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SalesProductVersionId": {
"type": "string",
"description": "FK to Pricing.SalesProductVersions"
},
"RuleType": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Rule": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Pricing.SalesProduct",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Pricing Engine Queue Item
Aggregate Root: PricingEngineQueueItem
Represents queue items for pricing engine processing and execution.
erDiagram
"Pricing.PricingEngineQueueItems" {
uniqueidentifier Id PK
datetimeoffset Queued
int Priority
varbinary QueueItemData
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
erDiagram
"Pricing.PricingEngineQueueItems" {
uniqueidentifier Id PK
datetimeoffset Queued
int Priority
varbinary QueueItemData
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}{
"definitions": {
"Pricing.PricingEngineQueueItems": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Priority": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"QueueItemData": {
"type": "string",
"description": "varbinary"
},
"Queued": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Pricing.PricingEngineQueueItem",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Custom Enum
Aggregate Root: CustomEnum
Represents custom enumerations with components, values, and key values for flexible data classification.
erDiagram
"Pricing.CustomEnumComponentValueKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentValueId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CustomEnumComponentValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentId FK
nvarchar Value
nvarchar ScriptValue
datetimeoffset StartDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CustomEnumComponents" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumId FK
nvarchar Name
nvarchar ExternalReference
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CustomEnums" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"PM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ProductComponentVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementOptions" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
erDiagram
"Pricing.CustomEnumComponentValueKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentValueId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CustomEnumComponentValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentId FK
nvarchar Value
nvarchar ScriptValue
datetimeoffset StartDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CustomEnumComponents" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumId FK
nvarchar Name
nvarchar ExternalReference
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Pricing.CustomEnums" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResults" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ManualPricingValues" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.SourcingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"PM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "DirectionCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingAgreementPricingResultTotals" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "CRM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "Pricing.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "ApplicationCore.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.PricingCosts" }o--|| "PM.CustomEnumComponentValues" : "TariffCustomEnumComponentValueId"
"Pricing.ProductComponentVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.ProductComponentVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"Pricing.SalesProductVersions" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementOptions" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingAgreementOptions" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.PricingDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingProvidedValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingRequestMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingResultMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ManualPricingValueMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.ContractVolumeDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.SourcingAgreementVolumeGroupDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetailMetadatas" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.PricingAgreementMeteringPointDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"{
"definitions": {
"Pricing.CustomEnumComponentValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CustomEnumComponentId": {
"type": "string",
"description": "FK to PM.CustomEnumComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ScriptValue": {
"type": "string",
"description": "nvarchar"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.CustomEnumComponents": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"Pricing.CustomEnumComponentValueKeyValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"CustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Pricing.CustomEnums": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Pricing.CustomEnum",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}