PM 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
Book
Aggregate Root: Book
Represents trading books that contain deals, orders, and other trading activities with associated actions and market products.
erDiagram
"PM.BookActionDetails" {
uniqueidentifier Id PK
uniqueidentifier BookActionId FK
nvarchar Key
int FormatType
uniqueidentifier CustomEnumId FK
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int DetailType
}
"PM.BookActions" {
uniqueidentifier Id PK
uniqueidentifier BookId FK
int BookActionTriggerFlag
uniqueidentifier BookProcessor
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit TriggerWhenBookIsSource
bit TriggerWhenBookIsTarget
int OrderIndex
int BookProcessorContextFlag
int Interval
int IntervalType
nvarchar Name
bit ManualApprovalRequired
bit IsDisabled
}
"PM.BookKeyValues" {
uniqueidentifier Id PK
uniqueidentifier BookId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.BookMarketProductNamePerLoadTypes" {
uniqueidentifier Id PK
uniqueidentifier BookId FK
nvarchar MarketProductName
int LoadType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.Books" {
uniqueidentifier Id PK
uniqueidentifier PortfolioId FK
nvarchar Name
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int BookType
uniqueidentifier ProductCustomEnumComponentId FK
bit Concealed
datetimeoffset ActivePeriodStart
int ActivePeriodStartType
datetimeoffset ActivePeriodEnd
}
"PM.BookActionDetails" }o--|| "PM.BookActions" : "BookActionId"
"PM.BookActionDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.BookActions" }o--|| "PM.Books" : "BookId"
"PM.BookActionRuns" }o--|| "PM.BookActions" : "BookActionId"
"PM.BookKeyValues" }o--|| "PM.Books" : "BookId"
"PM.BookMarketProductNamePerLoadTypes" }o--|| "PM.Books" : "BookId"
"PM.Books" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "PM.Portfolios" : "PortfolioId"
"PM.DealVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.DealVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "FallbackStrategyBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.SourcingClusters" }o--|| "PM.Books" : "BookId"
"PM.TradeSummaries" }o--|| "PM.Books" : "SourceBookId"
"PM.TradeSummaries" }o--|| "PM.Books" : "TargetBookId"
erDiagram
"PM.BookActionDetails" {
uniqueidentifier Id PK
uniqueidentifier BookActionId FK
nvarchar Key
int FormatType
uniqueidentifier CustomEnumId FK
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int DetailType
}
"PM.BookActions" {
uniqueidentifier Id PK
uniqueidentifier BookId FK
int BookActionTriggerFlag
uniqueidentifier BookProcessor
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit TriggerWhenBookIsSource
bit TriggerWhenBookIsTarget
int OrderIndex
int BookProcessorContextFlag
int Interval
int IntervalType
nvarchar Name
bit ManualApprovalRequired
bit IsDisabled
}
"PM.BookKeyValues" {
uniqueidentifier Id PK
uniqueidentifier BookId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.BookMarketProductNamePerLoadTypes" {
uniqueidentifier Id PK
uniqueidentifier BookId FK
nvarchar MarketProductName
int LoadType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.Books" {
uniqueidentifier Id PK
uniqueidentifier PortfolioId FK
nvarchar Name
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int BookType
uniqueidentifier ProductCustomEnumComponentId FK
bit Concealed
datetimeoffset ActivePeriodStart
int ActivePeriodStartType
datetimeoffset ActivePeriodEnd
}
"PM.BookActionDetails" }o--|| "PM.BookActions" : "BookActionId"
"PM.BookActionDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.BookActions" }o--|| "PM.Books" : "BookId"
"PM.BookActionRuns" }o--|| "PM.BookActions" : "BookActionId"
"PM.BookKeyValues" }o--|| "PM.Books" : "BookId"
"PM.BookMarketProductNamePerLoadTypes" }o--|| "PM.Books" : "BookId"
"PM.Books" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "PM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "PM.Portfolios" : "PortfolioId"
"PM.DealVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.DealVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "FallbackStrategyBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.SourcingClusters" }o--|| "PM.Books" : "BookId"
"PM.TradeSummaries" }o--|| "PM.Books" : "SourceBookId"
"PM.TradeSummaries" }o--|| "PM.Books" : "TargetBookId"{
"definitions": {
"PM.BookMarketProductNamePerLoadTypes": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"BookId": {
"type": "string",
"description": "FK to PM.Books"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"MarketProductName": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"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"
},
"PM.Books": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"BookType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ActivePeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ActivePeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"PortfolioId": {
"type": "string",
"description": "FK to PM.Portfolios"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ActivePeriodStartType": {
"type": "integer",
"description": "int"
},
"ProductCustomEnumComponentId": {
"type": "string",
"description": "FK to PM.CustomEnumComponents"
}
},
"type": "object"
},
"PM.BookActions": {
"properties": {
"BookProcessor": {
"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"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IntervalType": {
"type": "integer",
"description": "int"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ManualApprovalRequired": {
"type": "boolean",
"description": "bit"
},
"OrderIndex": {
"type": "integer",
"description": "int"
},
"BookActionTriggerFlag": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Interval": {
"type": "integer",
"description": "int"
},
"IsDisabled": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"BookId": {
"type": "string",
"description": "FK to PM.Books"
},
"BookProcessorContextFlag": {
"type": "integer",
"description": "int"
},
"TriggerWhenBookIsTarget": {
"type": "boolean",
"description": "bit"
},
"TriggerWhenBookIsSource": {
"type": "boolean",
"description": "bit"
}
},
"type": "object"
},
"PM.BookActionDetails": {
"properties": {
"BookActionId": {
"type": "string",
"description": "FK to PM.BookActions"
},
"DetailType": {
"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"
},
"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"
},
"FormatType": {
"type": "integer",
"description": "int"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"PM.BookKeyValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"BookId": {
"type": "string",
"description": "FK to PM.Books"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"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"
}
},
"title": "PM.Book",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Book Action Run
Aggregate Root: BookActionRun
Represents execution runs of book actions with detailed tracking and results.
erDiagram
"PM.BookActionRunAttempts" {
uniqueidentifier Id PK
uniqueidentifier BookActionRunId FK
uniqueidentifier RequestDocumentId
uniqueidentifier ResponseDocumentId
nvarchar ErrorMessage
int BookActionRunAttemptStage
uniqueidentifier TriggererAuthToken
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.BookActionRuns" {
uniqueidentifier Id PK
uniqueidentifier BookActionId FK
int BookActionTriggerType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier DealVersionId
uniqueidentifier OrderVersionId
}
"PM.BookActionRunAttempts" }o--|| "PM.BookActionRuns" : "BookActionRunId"
"PM.BookActionRuns" }o--|| "PM.BookActions" : "BookActionId"
erDiagram
"PM.BookActionRunAttempts" {
uniqueidentifier Id PK
uniqueidentifier BookActionRunId FK
uniqueidentifier RequestDocumentId
uniqueidentifier ResponseDocumentId
nvarchar ErrorMessage
int BookActionRunAttemptStage
uniqueidentifier TriggererAuthToken
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.BookActionRuns" {
uniqueidentifier Id PK
uniqueidentifier BookActionId FK
int BookActionTriggerType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier DealVersionId
uniqueidentifier OrderVersionId
}
"PM.BookActionRunAttempts" }o--|| "PM.BookActionRuns" : "BookActionRunId"
"PM.BookActionRuns" }o--|| "PM.BookActions" : "BookActionId"{
"definitions": {
"PM.BookActionRunAttempts": {
"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"
},
"TriggererAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"BookActionRunAttemptStage": {
"type": "integer",
"description": "int"
},
"ResponseDocumentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"RequestDocumentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ErrorMessage": {
"type": "string",
"description": "nvarchar"
},
"BookActionRunId": {
"type": "string",
"description": "FK to PM.BookActionRuns"
}
},
"type": "object"
},
"PM.BookActionRuns": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"OrderVersionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DealVersionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"BookActionId": {
"type": "string",
"description": "FK to PM.BookActions"
},
"BookActionTriggerType": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "PM.BookActionRun",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Commodity Type
Aggregate Root: CommodityType
Defines different types of commodities with their associated key values and configurations.
erDiagram
"PM.CommodityTypes" {
uniqueidentifier Id PK
nvarchar Name
nvarchar ShortName
nvarchar ColorCode
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.OrderVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.FixationRequests" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.TradeSummaries" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
erDiagram
"PM.CommodityTypes" {
uniqueidentifier Id PK
nvarchar Name
nvarchar ShortName
nvarchar ColorCode
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.OrderVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.FixationRequests" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.TradeSummaries" }o--|| "PM.CommodityTypes" : "CommodityTypeId"{
"definitions": {
"PM.CommodityTypes": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"ShortName": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"ColorCode": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "PM.CommodityType",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Deal
Aggregate Root: Deal
Represents trading deals with their details, metering points, and associated sourcing agreements.
erDiagram
"PM.DealConfirmationPeriods" {
uniqueidentifier Id PK
uniqueidentifier DealConfirmationId FK
uniqueidentifier DealVersionPeriodId FK
nvarchar ExternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int Status
}
"PM.DealConfirmationStatus" {
uniqueidentifier Id PK
uniqueidentifier DealConfirmationId FK
int Status
datetimeoffset Timestamp
uniqueidentifier DocumentId
nvarchar ErrorMessage
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealConfirmations" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
nvarchar ExternalReference
nvarchar CorrelationId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit ConfirmationPerPeriod
}
"PM.DealVersionDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier DealVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersionMarkToMarketReports" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
decimal MarkToMarket
datetimeoffset DeterminedOn
nvarchar PriceForwardCurveTimeSeriesCode
nvarchar PriceForwardCurveDataSlotReference
nvarchar PriceForwardCurveRevision
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersionPeriodSurcharges" {
uniqueidentifier Id PK
uniqueidentifier DealVersionPeriodId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersionPeriods" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
decimal ContractedCapacity
decimal Price
int PeriodHours
decimal TotalNotionalContractQuantity
decimal ContractedAmount
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
decimal IndicativePrice
}
"PM.DealVersion_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersions" {
uniqueidentifier Id PK
uniqueidentifier DealId FK
int VersionNumber
uniqueidentifier TransactionId
datetimeoffset TransactionDateTimeOffset
int SettlementMethod
bit VoiceBrokered
datetimeoffset TerminationDate
uniqueidentifier CommodityTypeId FK
decimal ContractedCapacity
int ContractedCapacityUnit
decimal ContractedPrice
int PriceUnit
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit IsLatestVersion
nvarchar ShapeTimeSeriesCode
nvarchar ShapeTimeSeriesDataSlotReference
nvarchar ShapeTimeSeriesRevision
uniqueidentifier SourceBookId FK
int SourceTradeDirection
int SourceOrigin
uniqueidentifier TargetBookId FK
int TargetTradeDirection
int TradeContractType
int LoadType
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
datetimeoffset LastTradingMoment
int PeriodHours
decimal TotalNotionalContractQuantity
int TotalNotionalContractQuantityUnit
decimal ContractedAmount
uniqueidentifier SourceMarketPartyId
uniqueidentifier TargetMarketPartyId
bit ConfirmedByOrder
decimal Surcharge
int SurchargeUnit
bit Concealed
nvarchar PriceTimeSeriesCode
nvarchar PriceTimeSeriesDataSlotReference
nvarchar PriceTimeSeriesRevision
uniqueidentifier SourcingProductElementId FK
uniqueidentifier SourceSourcingClusterId FK
uniqueidentifier TargetSourcingClusterId FK
int PeriodDivisionType
uniqueidentifier CreatorSourcingClusterId
uniqueidentifier ChainId
uniqueidentifier CreatorUserId
uniqueidentifier CreatorBookActionId
uniqueidentifier CreatorOrderId
int PriceTimeSeriesSnapshotTimestamp
int ShapeTimeSeriesSnapshotTimestamp
nvarchar IndicativePriceTimeSeriesCode
nvarchar IndicativePriceTimeSeriesDataSlotReference
nvarchar IndicativePriceTimeSeriesRevision
int IndicativePriceTimeSeriesSnapshotTimestamp
int IndicativePriceUnit
datetimeoffset PriceIndexReferenceDateTimeOffset
uniqueidentifier PriceForwardCurveGroupId
nvarchar DeliveryLocationDescription
bit ProcessedInPositions
}
"PM.Deals" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier LatestVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier LinkedOrderId FK
bit Concealed
nvarchar LinkedTradeReference
uniqueidentifier FixationRequestId FK
uniqueidentifier FixationSubRequestId FK
datetimeoffset ExternalUpdateTimestamp
nvarchar CounterReason
uniqueidentifier CounteredByCounterDealId
uniqueidentifier CounteredOriginalDealId
bit CounteringCompleted
}
"PM.DealConfirmationPeriods" }o--|| "PM.DealConfirmations" : "DealConfirmationId"
"PM.DealConfirmationPeriods" }o--|| "PM.DealVersionPeriods" : "DealVersionPeriodId"
"PM.DealConfirmationStatus" }o--|| "PM.DealConfirmations" : "DealConfirmationId"
"PM.DealConfirmations" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersionDetails" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersionMarkToMarketReports" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersionPeriodSurcharges" }o--|| "PM.DealVersionPeriods" : "DealVersionPeriodId"
"PM.DealVersionPeriods" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersion_CategoryLabel" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.Deals" }o--|| "PM.DealVersions" : "LatestVersionId"
"PM.DealVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.DealVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.DealVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.DealVersions" }o--|| "PM.Deals" : "DealId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.DealVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.LinkedChildDealTrackers" }o--|| "PM.DealVersions" : "FulfilledChildDealVersionId"
"PM.Deals" }o--|| "PM.Orders" : "LinkedOrderId"
"PM.Deals" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Deals" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
erDiagram
"PM.DealConfirmationPeriods" {
uniqueidentifier Id PK
uniqueidentifier DealConfirmationId FK
uniqueidentifier DealVersionPeriodId FK
nvarchar ExternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int Status
}
"PM.DealConfirmationStatus" {
uniqueidentifier Id PK
uniqueidentifier DealConfirmationId FK
int Status
datetimeoffset Timestamp
uniqueidentifier DocumentId
nvarchar ErrorMessage
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealConfirmations" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
nvarchar ExternalReference
nvarchar CorrelationId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
bit ConfirmationPerPeriod
}
"PM.DealVersionDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier DealVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersionMarkToMarketReports" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
decimal MarkToMarket
datetimeoffset DeterminedOn
nvarchar PriceForwardCurveTimeSeriesCode
nvarchar PriceForwardCurveDataSlotReference
nvarchar PriceForwardCurveRevision
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersionPeriodSurcharges" {
uniqueidentifier Id PK
uniqueidentifier DealVersionPeriodId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersionPeriods" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
decimal ContractedCapacity
decimal Price
int PeriodHours
decimal TotalNotionalContractQuantity
decimal ContractedAmount
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
decimal IndicativePrice
}
"PM.DealVersion_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier DealVersionId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.DealVersions" {
uniqueidentifier Id PK
uniqueidentifier DealId FK
int VersionNumber
uniqueidentifier TransactionId
datetimeoffset TransactionDateTimeOffset
int SettlementMethod
bit VoiceBrokered
datetimeoffset TerminationDate
uniqueidentifier CommodityTypeId FK
decimal ContractedCapacity
int ContractedCapacityUnit
decimal ContractedPrice
int PriceUnit
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit IsLatestVersion
nvarchar ShapeTimeSeriesCode
nvarchar ShapeTimeSeriesDataSlotReference
nvarchar ShapeTimeSeriesRevision
uniqueidentifier SourceBookId FK
int SourceTradeDirection
int SourceOrigin
uniqueidentifier TargetBookId FK
int TargetTradeDirection
int TradeContractType
int LoadType
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
datetimeoffset LastTradingMoment
int PeriodHours
decimal TotalNotionalContractQuantity
int TotalNotionalContractQuantityUnit
decimal ContractedAmount
uniqueidentifier SourceMarketPartyId
uniqueidentifier TargetMarketPartyId
bit ConfirmedByOrder
decimal Surcharge
int SurchargeUnit
bit Concealed
nvarchar PriceTimeSeriesCode
nvarchar PriceTimeSeriesDataSlotReference
nvarchar PriceTimeSeriesRevision
uniqueidentifier SourcingProductElementId FK
uniqueidentifier SourceSourcingClusterId FK
uniqueidentifier TargetSourcingClusterId FK
int PeriodDivisionType
uniqueidentifier CreatorSourcingClusterId
uniqueidentifier ChainId
uniqueidentifier CreatorUserId
uniqueidentifier CreatorBookActionId
uniqueidentifier CreatorOrderId
int PriceTimeSeriesSnapshotTimestamp
int ShapeTimeSeriesSnapshotTimestamp
nvarchar IndicativePriceTimeSeriesCode
nvarchar IndicativePriceTimeSeriesDataSlotReference
nvarchar IndicativePriceTimeSeriesRevision
int IndicativePriceTimeSeriesSnapshotTimestamp
int IndicativePriceUnit
datetimeoffset PriceIndexReferenceDateTimeOffset
uniqueidentifier PriceForwardCurveGroupId
nvarchar DeliveryLocationDescription
bit ProcessedInPositions
}
"PM.Deals" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier LatestVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier LinkedOrderId FK
bit Concealed
nvarchar LinkedTradeReference
uniqueidentifier FixationRequestId FK
uniqueidentifier FixationSubRequestId FK
datetimeoffset ExternalUpdateTimestamp
nvarchar CounterReason
uniqueidentifier CounteredByCounterDealId
uniqueidentifier CounteredOriginalDealId
bit CounteringCompleted
}
"PM.DealConfirmationPeriods" }o--|| "PM.DealConfirmations" : "DealConfirmationId"
"PM.DealConfirmationPeriods" }o--|| "PM.DealVersionPeriods" : "DealVersionPeriodId"
"PM.DealConfirmationStatus" }o--|| "PM.DealConfirmations" : "DealConfirmationId"
"PM.DealConfirmations" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersionDetails" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersionMarkToMarketReports" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersionPeriodSurcharges" }o--|| "PM.DealVersionPeriods" : "DealVersionPeriodId"
"PM.DealVersionPeriods" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.DealVersion_CategoryLabel" }o--|| "PM.DealVersions" : "DealVersionId"
"PM.Deals" }o--|| "PM.DealVersions" : "LatestVersionId"
"PM.DealVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.DealVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.DealVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.DealVersions" }o--|| "PM.Deals" : "DealId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.DealVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.LinkedChildDealTrackers" }o--|| "PM.DealVersions" : "FulfilledChildDealVersionId"
"PM.Deals" }o--|| "PM.Orders" : "LinkedOrderId"
"PM.Deals" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Deals" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"{
"definitions": {
"PM.DealVersionPeriods": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DealVersionId": {
"type": "string",
"description": "FK to PM.DealVersions"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DeliveryPeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IndicativePrice": {
"type": "string",
"description": "decimal"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractedAmount": {
"type": "string",
"description": "decimal"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TotalNotionalContractQuantity": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractedCapacity": {
"type": "string",
"description": "decimal"
},
"PeriodHours": {
"type": "integer",
"description": "int"
},
"Price": {
"type": "string",
"description": "decimal"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"PM.DealConfirmationStatus": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DocumentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ErrorMessage": {
"type": "string",
"description": "nvarchar"
},
"Status": {
"type": "integer",
"description": "int"
},
"DealConfirmationId": {
"type": "string",
"description": "FK to PM.DealConfirmations"
},
"Timestamp": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"PM.DealVersion_CategoryLabel": {
"properties": {
"DealVersionId": {
"type": "string",
"description": "FK to PM.DealVersions"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CategoryLabelId": {
"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"
},
"CategoryId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.DealConfirmationPeriods": {
"properties": {
"DealVersionPeriodId": {
"type": "string",
"description": "FK to PM.DealVersionPeriods"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"DealConfirmationId": {
"type": "string",
"description": "FK to PM.DealConfirmations"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Status": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.DealVersionMarkToMarketReports": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceForwardCurveDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"PriceForwardCurveTimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"MarkToMarket": {
"type": "string",
"description": "decimal"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceForwardCurveRevision": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DealVersionId": {
"type": "string",
"description": "FK to PM.DealVersions"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DeterminedOn": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.Deals": {
"properties": {
"CounterReason": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"CounteringCompleted": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FixationSubRequestId": {
"type": "string",
"description": "FK to PM.FixationSubRequests"
},
"LatestVersionId": {
"type": "string",
"description": "FK to PM.DealVersions"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ExternalUpdateTimestamp": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"LinkedTradeReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"LinkedOrderId": {
"type": "string",
"description": "FK to PM.Orders"
},
"CounteredOriginalDealId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CounteredByCounterDealId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FixationRequestId": {
"type": "string",
"description": "FK to PM.FixationRequests"
}
},
"type": "object"
},
"PM.DealVersionPeriodSurcharges": {
"properties": {
"DealVersionPeriodId": {
"type": "string",
"description": "FK to PM.DealVersionPeriods"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SurchargeUnit": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Surcharge": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.DealVersions": {
"properties": {
"IndicativePriceTimeSeriesDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"VersionNumber": {
"type": "integer",
"description": "int"
},
"SourceTradeDirection": {
"type": "integer",
"description": "int"
},
"SourceBookId": {
"type": "string",
"description": "FK to PM.Books"
},
"CreatorSourcingClusterId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TerminationDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DealId": {
"type": "string",
"description": "FK to PM.Deals"
},
"ShapeTimeSeriesDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"IndicativePriceUnit": {
"type": "integer",
"description": "int"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IndicativePriceTimeSeriesRevision": {
"type": "string",
"description": "nvarchar"
},
"ChainId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractedCapacityUnit": {
"type": "integer",
"description": "int"
},
"PriceTimeSeriesRevision": {
"type": "string",
"description": "nvarchar"
},
"TransactionDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"ContractedPrice": {
"type": "string",
"description": "decimal"
},
"TargetTradeDirection": {
"type": "integer",
"description": "int"
},
"SourcingProductElementId": {
"type": "string",
"description": "FK to PM.SourcingProductElements"
},
"LastTradingMoment": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TotalNotionalContractQuantityUnit": {
"type": "integer",
"description": "int"
},
"TargetMarketPartyId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TradeContractType": {
"type": "integer",
"description": "int"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"SourceOrigin": {
"type": "integer",
"description": "int"
},
"PriceIndexReferenceDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ShapeTimeSeriesSnapshotTimestamp": {
"type": "integer",
"description": "int"
},
"CreatorOrderId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceTimeSeriesDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TransactionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourceMarketPartyId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SettlementMethod": {
"type": "integer",
"description": "int"
},
"PeriodHours": {
"type": "integer",
"description": "int"
},
"ConfirmedByOrder": {
"type": "boolean",
"description": "bit"
},
"CreatorBookActionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IndicativePriceTimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"ShapeTimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CreatorUserId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceTimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"Surcharge": {
"type": "string",
"description": "decimal"
},
"SurchargeUnit": {
"type": "integer",
"description": "int"
},
"TargetSourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IsLatestVersion": {
"type": "boolean",
"description": "bit"
},
"TotalNotionalContractQuantity": {
"type": "string",
"description": "decimal"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"VoiceBrokered": {
"type": "boolean",
"description": "bit"
},
"PeriodDivisionType": {
"type": "integer",
"description": "int"
},
"PriceUnit": {
"type": "integer",
"description": "int"
},
"DeliveryLocationDescription": {
"type": "string",
"description": "nvarchar"
},
"ProcessedInPositions": {
"type": "boolean",
"description": "bit"
},
"DeliveryPeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ContractedAmount": {
"type": "string",
"description": "decimal"
},
"ShapeTimeSeriesRevision": {
"type": "string",
"description": "nvarchar"
},
"ContractedCapacity": {
"type": "string",
"description": "decimal"
},
"TargetBookId": {
"type": "string",
"description": "FK to PM.Books"
},
"CommodityTypeId": {
"type": "string",
"description": "FK to PM.CommodityTypes"
},
"PriceForwardCurveGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourceSourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IndicativePriceTimeSeriesSnapshotTimestamp": {
"type": "integer",
"description": "int"
},
"PriceTimeSeriesSnapshotTimestamp": {
"type": "integer",
"description": "int"
}
},
"type": "object"
},
"PM.DealVersionDetails": {
"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"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"DealVersionId": {
"type": "string",
"description": "FK to PM.DealVersions"
},
"FormatType": {
"type": "integer",
"description": "int"
},
"CustomEnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.DealConfirmations": {
"properties": {
"DealVersionId": {
"type": "string",
"description": "FK to PM.DealVersions"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CorrelationId": {
"type": "string",
"description": "nvarchar"
},
"ConfirmationPerPeriod": {
"type": "boolean",
"description": "bit"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"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"
}
},
"title": "PM.Deal",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Fixation Request
Aggregate Root: FixationRequest
Represents requests for price fixation with associated details and metering points.
erDiagram
"PM.FixationRequestDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationRequestId FK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationRequest_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier FixationRequestId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationRequests" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
datetimeoffset ReceivedTimestamp
datetimeoffset ExternalTimestamp
uniqueidentifier DocumentId
int Status
nvarchar StatusReason
uniqueidentifier SourcingClusterId FK
uniqueidentifier PricingAgreementId
uniqueidentifier SourcingAgreementId
uniqueidentifier SupplyAgreementId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
uniqueidentifier CommodityTypeId FK
int LoadType
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal Price
int PriceUnit
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
int PriceReferenceMoment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier FixationQuoteId
decimal TargetPercentage
int TradeDirection
}
"PM.FixationSubRequestDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestId FK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationSubRequestPeriodSurcharges" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestPeriodId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationSubRequestPeriods" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal Price
int PriceUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
decimal TargetPercentage
}
"PM.FixationSubRequestSurcharges" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationSubRequests" {
uniqueidentifier Id PK
uniqueidentifier FixationRequestId FK
nvarchar InternalReference
nvarchar ExternalReference
int LoadType
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal Price
int PriceUnit
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
int PriceReferenceMoment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset DeliveryPeriodEnd
datetimeoffset DeliveryPeriodStart
decimal TargetPercentage
int TradeDirection
}
"PM.FixationRequestDetails" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.FixationRequest_CategoryLabel" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.FixationRequests" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.FixationRequests" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.FixationRequests" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.FixationSubRequests" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Deals" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Orders" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.TradeSummaries" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.FixationSubRequestDetails" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.FixationSubRequestPeriodSurcharges" }o--|| "PM.FixationSubRequestPeriods" : "FixationSubRequestPeriodId"
"PM.FixationSubRequestPeriods" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.FixationSubRequestSurcharges" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.Deals" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.Orders" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.TradeSummaries" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
erDiagram
"PM.FixationRequestDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationRequestId FK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationRequest_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier FixationRequestId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationRequests" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
datetimeoffset ReceivedTimestamp
datetimeoffset ExternalTimestamp
uniqueidentifier DocumentId
int Status
nvarchar StatusReason
uniqueidentifier SourcingClusterId FK
uniqueidentifier PricingAgreementId
uniqueidentifier SourcingAgreementId
uniqueidentifier SupplyAgreementId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
uniqueidentifier CommodityTypeId FK
int LoadType
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal Price
int PriceUnit
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
int PriceReferenceMoment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier FixationQuoteId
decimal TargetPercentage
int TradeDirection
}
"PM.FixationSubRequestDetails" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestId FK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationSubRequestPeriodSurcharges" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestPeriodId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationSubRequestPeriods" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal Price
int PriceUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
decimal TargetPercentage
}
"PM.FixationSubRequestSurcharges" {
uniqueidentifier Id PK
uniqueidentifier FixationSubRequestId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.FixationSubRequests" {
uniqueidentifier Id PK
uniqueidentifier FixationRequestId FK
nvarchar InternalReference
nvarchar ExternalReference
int LoadType
decimal Volume
int VolumeUnit
decimal Capacity
int CapacityUnit
decimal Percentage
decimal Price
int PriceUnit
uniqueidentifier PriceForwardCurveGroupId
datetimeoffset PriceIndexReferenceDateTimeOffset
int PriceReferenceMoment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset DeliveryPeriodEnd
datetimeoffset DeliveryPeriodStart
decimal TargetPercentage
int TradeDirection
}
"PM.FixationRequestDetails" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.FixationRequest_CategoryLabel" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.FixationRequests" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.FixationRequests" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.FixationRequests" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.FixationSubRequests" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Deals" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Orders" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.TradeSummaries" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.FixationSubRequestDetails" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.FixationSubRequestPeriodSurcharges" }o--|| "PM.FixationSubRequestPeriods" : "FixationSubRequestPeriodId"
"PM.FixationSubRequestPeriods" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.FixationSubRequestSurcharges" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.Deals" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.Orders" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.TradeSummaries" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"{
"definitions": {
"PM.FixationSubRequestPeriods": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"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"
},
"FixationSubRequestId": {
"type": "string",
"description": "FK to PM.FixationSubRequests"
},
"PriceUnit": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TargetPercentage": {
"type": "string",
"description": "decimal"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Capacity": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Price": {
"type": "string",
"description": "decimal"
},
"Volume": {
"type": "string",
"description": "decimal"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CapacityUnit": {
"type": "integer",
"description": "int"
}
},
"type": "object"
},
"PM.FixationRequests": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingAgreementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"StatusReason": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DocumentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"VolumeUnit": {
"type": "integer",
"description": "int"
},
"PriceUnit": {
"type": "integer",
"description": "int"
},
"PriceForwardCurveGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Capacity": {
"type": "string",
"description": "decimal"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"DeliveryPeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SupplyAgreementId": {
"type": "string",
"description": "FK to PM.SupplyAgreements"
},
"SourcingAgreementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CapacityUnit": {
"type": "integer",
"description": "int"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"ReceivedTimestamp": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Volume": {
"type": "string",
"description": "decimal"
},
"Status": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"PriceReferenceMoment": {
"type": "integer",
"description": "int"
},
"Percentage": {
"type": "string",
"description": "decimal"
},
"TargetPercentage": {
"type": "string",
"description": "decimal"
},
"TradeDirection": {
"type": "integer",
"description": "int"
},
"PriceIndexReferenceDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CommodityTypeId": {
"type": "string",
"description": "FK to PM.CommodityTypes"
},
"FixationQuoteId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"ExternalTimestamp": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Price": {
"type": "string",
"description": "decimal"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"PM.FixationSubRequests": {
"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"
},
"TargetPercentage": {
"type": "string",
"description": "decimal"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"DeliveryPeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PriceUnit": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Capacity": {
"type": "string",
"description": "decimal"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"PriceIndexReferenceDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"Price": {
"type": "string",
"description": "decimal"
},
"PriceReferenceMoment": {
"type": "integer",
"description": "int"
},
"Volume": {
"type": "string",
"description": "decimal"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FixationRequestId": {
"type": "string",
"description": "FK to PM.FixationRequests"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CapacityUnit": {
"type": "integer",
"description": "int"
},
"PriceForwardCurveGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.FixationRequestDetails": {
"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"
},
"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"
},
"FormatType": {
"type": "integer",
"description": "int"
},
"FixationRequestId": {
"type": "string",
"description": "FK to PM.FixationRequests"
},
"CustomEnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.FixationSubRequestPeriodSurcharges": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FixationSubRequestPeriodId": {
"type": "string",
"description": "FK to PM.FixationSubRequestPeriods"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SurchargeUnit": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"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"
},
"Surcharge": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.FixationRequest_CategoryLabel": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CategoryLabelId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FixationRequestId": {
"type": "string",
"description": "FK to PM.FixationRequests"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CategoryId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.FixationSubRequestSurcharges": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FixationSubRequestId": {
"type": "string",
"description": "FK to PM.FixationSubRequests"
},
"SurchargeUnit": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"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"
},
"Surcharge": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.FixationSubRequestDetails": {
"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"
},
"FixationSubRequestId": {
"type": "string",
"description": "FK to PM.FixationSubRequests"
},
"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"
},
"FormatType": {
"type": "integer",
"description": "int"
},
"CustomEnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "PM.FixationRequest",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Order
Aggregate Root: Order
Represents trading orders with their details, key values, and associated metering points.
erDiagram
"PM.OrderEngineQueueItemItems" {
uniqueidentifier Id PK
datetimeoffset Queued
int Priority
uniqueidentifier OrderId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset ReferenceDateTime
}
"PM.OrderVersionDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier OrderVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersionMarkToMarketReports" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionId FK
decimal MarkToMarket
datetimeoffset DeterminedOn
nvarchar PriceForwardCurveTimeSeriesCode
nvarchar PriceForwardCurveDataSlotReference
nvarchar PriceForwardCurveRevision
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersionPeriodSurcharges" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionPeriodId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersionPeriods" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
decimal ContractedCapacity
decimal Price
int PeriodHours
decimal TotalNotionalContractQuantity
decimal ContractedAmount
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
decimal IndicativePrice
}
"PM.OrderVersion_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersions" {
uniqueidentifier Id PK
uniqueidentifier OrderId FK
bit IsLatestVersion
int VersionNumber
uniqueidentifier TransactionId
datetimeoffset TransactionDateTimeOffset
bit VoiceBrokered
datetimeoffset TerminationDate
decimal ContractedCapacity
int ContractedCapacityUnit
decimal ContractedPrice
int PriceUnit
nvarchar Comment
nvarchar ShapeTimeSeriesCode
nvarchar ShapeTimeSeriesDataSlotReference
nvarchar ShapeTimeSeriesRevision
uniqueidentifier SourceBookId FK
int SourceTradeDirection
int SourceOrigin
uniqueidentifier TargetBookId FK
int TargetTradeDirection
int TradeContractType
int LoadType
int SettlementMethod
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
datetimeoffset LastTradingMoment
uniqueidentifier CommodityTypeId FK
int PeriodHours
decimal TotalNotionalContractQuantity
int TotalNotionalContractQuantityUnit
decimal ContractedAmount
int OrderType
int OrderCondition
int ProcurementStrategy
decimal PriceLimit
int PriceLimitUnit
int OrderValidity
datetimeoffset OrderValidityDateTimeOffset
decimal MinimalExecutionVolume
int MinimalExecutionVolumeUnit
decimal UndisclosedVolume
int UndisclosedVolumeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier SourceMarketPartyId
uniqueidentifier TargetMarketPartyId
bit IsPlaceholder
decimal Surcharge
int SurchargeUnit
bit Concealed
bit ConfirmedByParentOrder
int StrategyExecutionType
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
decimal StopLossThreshold
int StopLossThresholdUnit
int FallbackStrategyExecutionType
uniqueidentifier FallbackStrategyBookId FK
datetimeoffset ExecutionDate
uniqueidentifier SourcingProductElementId FK
uniqueidentifier SourceSourcingClusterId FK
uniqueidentifier TargetSourcingClusterId FK
int StopLossTriggerOnLoadType
int ChildOrderGranularity
int ChildOrderVolumeType
nvarchar PriceTimeSeriesCode
nvarchar PriceTimeSeriesDataSlotReference
nvarchar PriceTimeSeriesRevision
int PeriodDivisionType
uniqueidentifier CreatorSourcingClusterId
uniqueidentifier ChainId
uniqueidentifier CreatorUserId
uniqueidentifier CreatorBookActionId
uniqueidentifier CreatorOrderId
datetimeoffset ProcurementEnd
datetimeoffset ProcurementStart
int PriceTimeSeriesSnapshotTimestamp
int ShapeTimeSeriesSnapshotTimestamp
datetimeoffset IntendedProcurementEnd
datetimeoffset IntendedProcurementStart
nvarchar DeliveryLocationDescription
bit ProcessedInPositions
}
"PM.Orders" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier LinkedOrderId FK
uniqueidentifier LatestVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int Status
nvarchar StatusReason
datetimeoffset NextEvaluationDateTimeOffset
nvarchar LinkedTradeReference
uniqueidentifier FixationRequestId FK
uniqueidentifier FixationSubRequestId FK
}
"PM.OrderVersionDetails" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.OrderVersionMarkToMarketReports" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.OrderVersionPeriodSurcharges" }o--|| "PM.OrderVersionPeriods" : "OrderVersionPeriodId"
"PM.OrderVersionPeriods" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.OrderVersion_CategoryLabel" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.Orders" }o--|| "PM.OrderVersions" : "LatestVersionId"
"PM.OrderVersions" }o--|| "PM.Books" : "FallbackStrategyBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.OrderVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.OrderVersions" }o--|| "PM.Orders" : "OrderId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.LinkedChildOrderTrackers" }o--|| "PM.OrderVersions" : "FulfilledChildOrderVersionId"
"PM.Deals" }o--|| "PM.Orders" : "LinkedOrderId"
"PM.Orders" }o--|| "PM.Orders" : "LinkedOrderId"
"PM.LinkedChildDealTrackers" }o--|| "PM.Orders" : "OrderId"
"PM.LinkedChildOrderTrackers" }o--|| "PM.Orders" : "OrderId"
"PM.Orders" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Orders" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
erDiagram
"PM.OrderEngineQueueItemItems" {
uniqueidentifier Id PK
datetimeoffset Queued
int Priority
uniqueidentifier OrderId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset ReferenceDateTime
}
"PM.OrderVersionDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier OrderVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersionMarkToMarketReports" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionId FK
decimal MarkToMarket
datetimeoffset DeterminedOn
nvarchar PriceForwardCurveTimeSeriesCode
nvarchar PriceForwardCurveDataSlotReference
nvarchar PriceForwardCurveRevision
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersionPeriodSurcharges" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionPeriodId FK
nvarchar Name
decimal Surcharge
int SurchargeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersionPeriods" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionId FK
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
decimal ContractedCapacity
decimal Price
int PeriodHours
decimal TotalNotionalContractQuantity
decimal ContractedAmount
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
decimal IndicativePrice
}
"PM.OrderVersion_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier OrderVersionId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.OrderVersions" {
uniqueidentifier Id PK
uniqueidentifier OrderId FK
bit IsLatestVersion
int VersionNumber
uniqueidentifier TransactionId
datetimeoffset TransactionDateTimeOffset
bit VoiceBrokered
datetimeoffset TerminationDate
decimal ContractedCapacity
int ContractedCapacityUnit
decimal ContractedPrice
int PriceUnit
nvarchar Comment
nvarchar ShapeTimeSeriesCode
nvarchar ShapeTimeSeriesDataSlotReference
nvarchar ShapeTimeSeriesRevision
uniqueidentifier SourceBookId FK
int SourceTradeDirection
int SourceOrigin
uniqueidentifier TargetBookId FK
int TargetTradeDirection
int TradeContractType
int LoadType
int SettlementMethod
datetimeoffset DeliveryPeriodStart
datetimeoffset DeliveryPeriodEnd
datetimeoffset LastTradingMoment
uniqueidentifier CommodityTypeId FK
int PeriodHours
decimal TotalNotionalContractQuantity
int TotalNotionalContractQuantityUnit
decimal ContractedAmount
int OrderType
int OrderCondition
int ProcurementStrategy
decimal PriceLimit
int PriceLimitUnit
int OrderValidity
datetimeoffset OrderValidityDateTimeOffset
decimal MinimalExecutionVolume
int MinimalExecutionVolumeUnit
decimal UndisclosedVolume
int UndisclosedVolumeUnit
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier SourceMarketPartyId
uniqueidentifier TargetMarketPartyId
bit IsPlaceholder
decimal Surcharge
int SurchargeUnit
bit Concealed
bit ConfirmedByParentOrder
int StrategyExecutionType
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
decimal StopLossThreshold
int StopLossThresholdUnit
int FallbackStrategyExecutionType
uniqueidentifier FallbackStrategyBookId FK
datetimeoffset ExecutionDate
uniqueidentifier SourcingProductElementId FK
uniqueidentifier SourceSourcingClusterId FK
uniqueidentifier TargetSourcingClusterId FK
int StopLossTriggerOnLoadType
int ChildOrderGranularity
int ChildOrderVolumeType
nvarchar PriceTimeSeriesCode
nvarchar PriceTimeSeriesDataSlotReference
nvarchar PriceTimeSeriesRevision
int PeriodDivisionType
uniqueidentifier CreatorSourcingClusterId
uniqueidentifier ChainId
uniqueidentifier CreatorUserId
uniqueidentifier CreatorBookActionId
uniqueidentifier CreatorOrderId
datetimeoffset ProcurementEnd
datetimeoffset ProcurementStart
int PriceTimeSeriesSnapshotTimestamp
int ShapeTimeSeriesSnapshotTimestamp
datetimeoffset IntendedProcurementEnd
datetimeoffset IntendedProcurementStart
nvarchar DeliveryLocationDescription
bit ProcessedInPositions
}
"PM.Orders" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier LinkedOrderId FK
uniqueidentifier LatestVersionId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int Status
nvarchar StatusReason
datetimeoffset NextEvaluationDateTimeOffset
nvarchar LinkedTradeReference
uniqueidentifier FixationRequestId FK
uniqueidentifier FixationSubRequestId FK
}
"PM.OrderVersionDetails" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.OrderVersionMarkToMarketReports" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.OrderVersionPeriodSurcharges" }o--|| "PM.OrderVersionPeriods" : "OrderVersionPeriodId"
"PM.OrderVersionPeriods" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.OrderVersion_CategoryLabel" }o--|| "PM.OrderVersions" : "OrderVersionId"
"PM.Orders" }o--|| "PM.OrderVersions" : "LatestVersionId"
"PM.OrderVersions" }o--|| "PM.Books" : "FallbackStrategyBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "SourceBookId"
"PM.OrderVersions" }o--|| "PM.Books" : "TargetBookId"
"PM.OrderVersions" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.OrderVersions" }o--|| "PM.Orders" : "OrderId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.LinkedChildOrderTrackers" }o--|| "PM.OrderVersions" : "FulfilledChildOrderVersionId"
"PM.Deals" }o--|| "PM.Orders" : "LinkedOrderId"
"PM.Orders" }o--|| "PM.Orders" : "LinkedOrderId"
"PM.LinkedChildDealTrackers" }o--|| "PM.Orders" : "OrderId"
"PM.LinkedChildOrderTrackers" }o--|| "PM.Orders" : "OrderId"
"PM.Orders" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.Orders" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"{
"definitions": {
"PM.Orders": {
"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"
},
"StatusReason": {
"type": "string",
"description": "nvarchar"
},
"LatestVersionId": {
"type": "string",
"description": "FK to PM.OrderVersions"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FixationSubRequestId": {
"type": "string",
"description": "FK to PM.FixationSubRequests"
},
"LinkedTradeReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"LinkedOrderId": {
"type": "string",
"description": "FK to PM.Orders"
},
"Status": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FixationRequestId": {
"type": "string",
"description": "FK to PM.FixationRequests"
},
"NextEvaluationDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"PM.OrderEngineQueueItemItems": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ReferenceDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"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"
},
"Queued": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Priority": {
"type": "integer",
"description": "int"
},
"OrderId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.OrderVersion_CategoryLabel": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CategoryLabelId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"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"
},
"OrderVersionId": {
"type": "string",
"description": "FK to PM.OrderVersions"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.OrderVersionDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"OrderVersionId": {
"type": "string",
"description": "FK to PM.OrderVersions"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"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"
},
"FormatType": {
"type": "integer",
"description": "int"
},
"CustomEnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.OrderVersionPeriodSurcharges": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SurchargeUnit": {
"type": "integer",
"description": "int"
},
"OrderVersionPeriodId": {
"type": "string",
"description": "FK to PM.OrderVersionPeriods"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Surcharge": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.OrderVersions": {
"properties": {
"MinimalExecutionVolumeUnit": {
"type": "integer",
"description": "int"
},
"SourceOrigin": {
"type": "integer",
"description": "int"
},
"ProcurementStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ShapeTimeSeriesDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"VersionNumber": {
"type": "integer",
"description": "int"
},
"SourceTradeDirection": {
"type": "integer",
"description": "int"
},
"SourceBookId": {
"type": "string",
"description": "FK to PM.Books"
},
"PriceUnit": {
"type": "integer",
"description": "int"
},
"StopLossTriggerOnLoadType": {
"type": "integer",
"description": "int"
},
"ProcurementEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"OrderType": {
"type": "integer",
"description": "int"
},
"ChildOrderGranularity": {
"type": "integer",
"description": "int"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ChainId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractedCapacityUnit": {
"type": "integer",
"description": "int"
},
"StopLossThreshold": {
"type": "string",
"description": "decimal"
},
"TransactionDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PriceLimitUnit": {
"type": "integer",
"description": "int"
},
"ContractedPrice": {
"type": "string",
"description": "decimal"
},
"TargetTradeDirection": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"LastTradingMoment": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TotalNotionalContractQuantityUnit": {
"type": "integer",
"description": "int"
},
"PriceTimeSeriesDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"TargetMarketPartyId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExecutionDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TradeContractType": {
"type": "integer",
"description": "int"
},
"StrategyExecutionType": {
"type": "integer",
"description": "int"
},
"OrderValidity": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IsPlaceholder": {
"type": "boolean",
"description": "bit"
},
"ShapeTimeSeriesSnapshotTimestamp": {
"type": "integer",
"description": "int"
},
"CreatorOrderId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceTimeSeriesRevision": {
"type": "string",
"description": "nvarchar"
},
"ProcurementDeliveryPeriodInMonths": {
"type": "integer",
"description": "int"
},
"OrderId": {
"type": "string",
"description": "FK to PM.Orders"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IntendedProcurementStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProcurementStrategy": {
"type": "integer",
"description": "int"
},
"FallbackStrategyExecutionType": {
"type": "integer",
"description": "int"
},
"ProcurementOffsetPeriodInMonths": {
"type": "integer",
"description": "int"
},
"SourceMarketPartyId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SettlementMethod": {
"type": "integer",
"description": "int"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"CreatorSourcingClusterId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PeriodHours": {
"type": "integer",
"description": "int"
},
"StopLossThresholdUnit": {
"type": "integer",
"description": "int"
},
"ConfirmedByParentOrder": {
"type": "boolean",
"description": "bit"
},
"CreatorBookActionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingProductElementId": {
"type": "string",
"description": "FK to PM.SourcingProductElements"
},
"TerminationDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ShapeTimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FallbackStrategyBookId": {
"type": "string",
"description": "FK to PM.Books"
},
"CreatorUserId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceTimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"Surcharge": {
"type": "string",
"description": "decimal"
},
"SurchargeUnit": {
"type": "integer",
"description": "int"
},
"TargetSourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"ProcurementPeriodInMonths": {
"type": "integer",
"description": "int"
},
"IsLatestVersion": {
"type": "boolean",
"description": "bit"
},
"TotalNotionalContractQuantity": {
"type": "string",
"description": "decimal"
},
"ChildOrderVolumeType": {
"type": "integer",
"description": "int"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"VoiceBrokered": {
"type": "boolean",
"description": "bit"
},
"UndisclosedVolume": {
"type": "string",
"description": "decimal"
},
"OrderValidityDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"MinimalExecutionVolume": {
"type": "string",
"description": "decimal"
},
"DeliveryLocationDescription": {
"type": "string",
"description": "nvarchar"
},
"ProcessedInPositions": {
"type": "boolean",
"description": "bit"
},
"PriceLimit": {
"type": "string",
"description": "decimal"
},
"IntendedProcurementEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DeliveryPeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ContractedAmount": {
"type": "string",
"description": "decimal"
},
"ShapeTimeSeriesRevision": {
"type": "string",
"description": "nvarchar"
},
"UndisclosedVolumeUnit": {
"type": "integer",
"description": "int"
},
"ContractedCapacity": {
"type": "string",
"description": "decimal"
},
"OrderCondition": {
"type": "integer",
"description": "int"
},
"TargetBookId": {
"type": "string",
"description": "FK to PM.Books"
},
"CommodityTypeId": {
"type": "string",
"description": "FK to PM.CommodityTypes"
},
"SourceSourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"PeriodDivisionType": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PriceTimeSeriesSnapshotTimestamp": {
"type": "integer",
"description": "int"
},
"TransactionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.OrderVersionMarkToMarketReports": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceForwardCurveDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"PriceForwardCurveTimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"OrderVersionId": {
"type": "string",
"description": "FK to PM.OrderVersions"
},
"MarkToMarket": {
"type": "string",
"description": "decimal"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceForwardCurveRevision": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DeterminedOn": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.OrderVersionPeriods": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"DeliveryPeriodEnd": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DeliveryPeriodStart": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"OrderVersionId": {
"type": "string",
"description": "FK to PM.OrderVersions"
},
"IndicativePrice": {
"type": "string",
"description": "decimal"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractedAmount": {
"type": "string",
"description": "decimal"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TotalNotionalContractQuantity": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractedCapacity": {
"type": "string",
"description": "decimal"
},
"PeriodHours": {
"type": "integer",
"description": "int"
},
"Price": {
"type": "string",
"description": "decimal"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "PM.Order",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Portfolio
Aggregate Root: Portfolio
Represents trading portfolios with their details, key values, and associated metering points.
erDiagram
"PM.PortfolioGroupingKeyValues" {
uniqueidentifier Id PK
uniqueidentifier PortfolioGroupingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"PM.PortfolioGroupings" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier ParentPortfolioGroupingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.PortfolioKeyValues" {
uniqueidentifier Id PK
uniqueidentifier PortfolioId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"PM.Portfolios" {
uniqueidentifier Id PK
nvarchar Name
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier DefaultMarketPartyId
bit Concealed
uniqueidentifier PortfolioGroupingId FK
int PortfolioType
}
"PM.PortfolioGroupingKeyValues" }o--|| "PM.PortfolioGroupings" : "PortfolioGroupingId"
"PM.PortfolioGroupings" }o--|| "PM.PortfolioGroupings" : "ParentPortfolioGroupingId"
"PM.Portfolios" }o--|| "PM.PortfolioGroupings" : "PortfolioGroupingId"
"PM.PortfolioKeyValues" }o--|| "PM.Portfolios" : "PortfolioId"
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "TargetPortfolioId"
"PM.Books" }o--|| "PM.Portfolios" : "PortfolioId"
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "SourcePortfolioId"
erDiagram
"PM.PortfolioGroupingKeyValues" {
uniqueidentifier Id PK
uniqueidentifier PortfolioGroupingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"PM.PortfolioGroupings" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier ParentPortfolioGroupingId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.PortfolioKeyValues" {
uniqueidentifier Id PK
uniqueidentifier PortfolioId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Key
nvarchar Value
}
"PM.Portfolios" {
uniqueidentifier Id PK
nvarchar Name
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier DefaultMarketPartyId
bit Concealed
uniqueidentifier PortfolioGroupingId FK
int PortfolioType
}
"PM.PortfolioGroupingKeyValues" }o--|| "PM.PortfolioGroupings" : "PortfolioGroupingId"
"PM.PortfolioGroupings" }o--|| "PM.PortfolioGroupings" : "ParentPortfolioGroupingId"
"PM.Portfolios" }o--|| "PM.PortfolioGroupings" : "PortfolioGroupingId"
"PM.PortfolioKeyValues" }o--|| "PM.Portfolios" : "PortfolioId"
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "TargetPortfolioId"
"PM.Books" }o--|| "PM.Portfolios" : "PortfolioId"
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "SourcePortfolioId"{
"definitions": {
"PM.PortfolioGroupingKeyValues": {
"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"
},
"PortfolioGroupingId": {
"type": "string",
"description": "FK to PM.PortfolioGroupings"
},
"Value": {
"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"
},
"PM.Portfolios": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PortfolioGroupingId": {
"type": "string",
"description": "FK to PM.PortfolioGroupings"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DefaultMarketPartyId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PortfolioType": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"PM.PortfolioGroupings": {
"properties": {
"ParentPortfolioGroupingId": {
"type": "string",
"description": "FK to PM.PortfolioGroupings"
},
"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"
},
"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"
},
"PM.PortfolioKeyValues": {
"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"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PortfolioId": {
"type": "string",
"description": "FK to PM.Portfolios"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "PM.Portfolio",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Sourcing Cluster
Aggregate Root: SourcingCluster
Represents clusters for sourcing activities with their details, key values, and associated metering points.
erDiagram
"PM.SourcingClusterDetails" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterEngineQueueItems" {
uniqueidentifier Id PK
datetimeoffset Queued
int Priority
varbinary QueueItemData
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterInputTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier SourcingProductElementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterMetadataTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterParentChildRelations" {
uniqueidentifier Id PK
uniqueidentifier ParentSourcingClusterId FK
uniqueidentifier ChildSourcingClusterId FK
uniqueidentifier SourcingClusterTreeValidatorId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterTreeValidators" {
uniqueidentifier Id PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Name
}
"PM.SourcingCluster_CompletedPricingAgreement" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier PricingAgreementId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingCluster_CompletedSourcingAgreement" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier SourcingAgreementId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingCluster_ScriptRelation" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier ScriptId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier ScriptVersionId
}
"PM.SourcingCluster_SourcingClusterInHold" {
uniqueidentifier SourcingClusterId PK
uniqueidentifier ChildSourcingClusterId PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
}
"PM.SourcingCluster_SupplyAgreement" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier SupplyAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusters" {
uniqueidentifier Id PK
nvarchar InternalReference
bit OpenPositionManagementDisabled
uniqueidentifier PricingAgreementId
uniqueidentifier SourcingAgreementId
uniqueidentifier BookId FK
uniqueidentifier ParentSourcingClusterId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourcingProductComponentId FK
bit ForecastResponsibilityDisabled
uniqueidentifier SourcingClusterTreeValidatorId FK
uniqueidentifier PositionPartitioningCategoryId
bigint SourcingProductComponentLatestUpdateTimeStamp
}
"PM.SourcingClusterDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusterInputTimeSeries" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusterInputTimeSeries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingClusterMetadataTimeSeries" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusterParentChildRelations" }o--|| "PM.SourcingClusters" : "ChildSourcingClusterId"
"PM.SourcingClusterParentChildRelations" }o--|| "PM.SourcingClusters" : "ParentSourcingClusterId"
"PM.SourcingClusterParentChildRelations" }o--|| "PM.SourcingClusterTreeValidators" : "SourcingClusterTreeValidatorId"
"PM.SourcingClusters" }o--|| "PM.SourcingClusterTreeValidators" : "SourcingClusterTreeValidatorId"
"PM.SourcingCluster_CompletedPricingAgreement" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_CompletedSourcingAgreement" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_ScriptRelation" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_SourcingClusterInHold" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_SupplyAgreement" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_SupplyAgreement" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.SourcingClusters" }o--|| "PM.SourcingClusters" : "ParentSourcingClusterId"
"PM.SourcingClusters" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.FixationRequests" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusters" }o--|| "PM.Books" : "BookId"
erDiagram
"PM.SourcingClusterDetails" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterEngineQueueItems" {
uniqueidentifier Id PK
datetimeoffset Queued
int Priority
varbinary QueueItemData
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterInputTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier SourcingProductElementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterMetadataTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterParentChildRelations" {
uniqueidentifier Id PK
uniqueidentifier ParentSourcingClusterId FK
uniqueidentifier ChildSourcingClusterId FK
uniqueidentifier SourcingClusterTreeValidatorId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusterTreeValidators" {
uniqueidentifier Id PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Name
}
"PM.SourcingCluster_CompletedPricingAgreement" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier PricingAgreementId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingCluster_CompletedSourcingAgreement" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier SourcingAgreementId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingCluster_ScriptRelation" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier ScriptId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier ScriptVersionId
}
"PM.SourcingCluster_SourcingClusterInHold" {
uniqueidentifier SourcingClusterId PK
uniqueidentifier ChildSourcingClusterId PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
}
"PM.SourcingCluster_SupplyAgreement" {
uniqueidentifier Id PK
uniqueidentifier SourcingClusterId FK
uniqueidentifier SupplyAgreementId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingClusters" {
uniqueidentifier Id PK
nvarchar InternalReference
bit OpenPositionManagementDisabled
uniqueidentifier PricingAgreementId
uniqueidentifier SourcingAgreementId
uniqueidentifier BookId FK
uniqueidentifier ParentSourcingClusterId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourcingProductComponentId FK
bit ForecastResponsibilityDisabled
uniqueidentifier SourcingClusterTreeValidatorId FK
uniqueidentifier PositionPartitioningCategoryId
bigint SourcingProductComponentLatestUpdateTimeStamp
}
"PM.SourcingClusterDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusterInputTimeSeries" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusterInputTimeSeries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingClusterMetadataTimeSeries" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusterParentChildRelations" }o--|| "PM.SourcingClusters" : "ChildSourcingClusterId"
"PM.SourcingClusterParentChildRelations" }o--|| "PM.SourcingClusters" : "ParentSourcingClusterId"
"PM.SourcingClusterParentChildRelations" }o--|| "PM.SourcingClusterTreeValidators" : "SourcingClusterTreeValidatorId"
"PM.SourcingClusters" }o--|| "PM.SourcingClusterTreeValidators" : "SourcingClusterTreeValidatorId"
"PM.SourcingCluster_CompletedPricingAgreement" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_CompletedSourcingAgreement" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_ScriptRelation" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_SourcingClusterInHold" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_SupplyAgreement" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingCluster_SupplyAgreement" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.DealVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "SourceSourcingClusterId"
"PM.OrderVersions" }o--|| "PM.SourcingClusters" : "TargetSourcingClusterId"
"PM.SourcingClusters" }o--|| "PM.SourcingClusters" : "ParentSourcingClusterId"
"PM.SourcingClusters" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.FixationRequests" }o--|| "PM.SourcingClusters" : "SourcingClusterId"
"PM.SourcingClusters" }o--|| "PM.Books" : "BookId"{
"definitions": {
"PM.SourcingClusterParentChildRelations": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"ParentSourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SourcingClusterTreeValidatorId": {
"type": "string",
"description": "FK to PM.SourcingClusterTreeValidators"
},
"ChildSourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingCluster_CompletedPricingAgreement": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"PricingAgreementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingClusterDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
},
"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"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingCluster_SourcingClusterInHold": {
"properties": {
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"ChildSourcingClusterId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingClusterTreeValidators": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"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"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingClusters": {
"properties": {
"SourcingAgreementId": {
"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"
},
"SourcingClusterTreeValidatorId": {
"type": "string",
"description": "FK to PM.SourcingClusterTreeValidators"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PositionPartitioningCategoryId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingProductComponentId": {
"type": "string",
"description": "FK to PM.SourcingProductComponents"
},
"OpenPositionManagementDisabled": {
"type": "boolean",
"description": "bit"
},
"SourcingProductComponentLatestUpdateTimeStamp": {
"type": "string",
"description": "bigint"
},
"ParentSourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ForecastResponsibilityDisabled": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"BookId": {
"type": "string",
"description": "FK to PM.Books"
}
},
"type": "object"
},
"PM.SourcingClusterInputTimeSeries": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SnapshotTimestamp": {
"type": "integer",
"description": "int"
},
"SourcingProductElementId": {
"type": "string",
"description": "FK to PM.SourcingProductElements"
},
"Revision": {
"type": "string",
"description": "nvarchar"
},
"DataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SubType": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingClusterEngineQueueItems": {
"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"
},
"PM.SourcingClusterMetadataTimeSeries": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SnapshotTimestamp": {
"type": "integer",
"description": "int"
},
"Revision": {
"type": "string",
"description": "nvarchar"
},
"DataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SubType": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingCluster_CompletedSourcingAgreement": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingAgreementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingCluster_ScriptRelation": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ScriptVersionId": {
"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"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingCluster_SupplyAgreement": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SupplyAgreementId": {
"type": "string",
"description": "FK to PM.SupplyAgreements"
},
"SourcingClusterId": {
"type": "string",
"description": "FK to PM.SourcingClusters"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "PM.SourcingCluster",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Sourcing Product Component
Aggregate Root: SourcingProductComponent
Represents product components used in sourcing activities with their details and key values.
erDiagram
"PM.ProductComponent_SourcingProductComponent" {
uniqueidentifier Id
uniqueidentifier ProductComponentId PK
uniqueidentifier SourcingProductComponentId PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.ProductElement_SourcingProductElement" {
uniqueidentifier Id
uniqueidentifier ProductElementId PK
uniqueidentifier SourcingProductElementId PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingProductComponentRuleConfigDetailSet" {
uniqueidentifier Id PK
uniqueidentifier SourcingProductComponentRuleConfigId FK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingProductComponentRuleConfigDetails" {
}
"PM.SourcingProductComponentRuleConfigs" {
uniqueidentifier Id PK
uniqueidentifier SourcingProductComponentId FK
nvarchar Name
int RuleType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingProductComponents" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int CommodityType
bigint LatestUpdateTimeStamp
int SourcingClusterTargetAssignmentType
}
"PM.SourcingProductElements" {
uniqueidentifier Id PK
uniqueidentifier SourcingProductComponentId FK
nvarchar Name
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.ProductComponent_SourcingProductComponent" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.ProductElement_SourcingProductElement" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "PM.SourcingProductComponentRuleConfigs" : "SourcingProductComponentRuleConfigId"
"PM.SourcingProductComponentRuleConfigs" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.SourcingClusters" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.SourcingProductElements" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.TradeSummaries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.DealVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.OrderVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingProductElementRuleConfigs" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingClusterInputTimeSeries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
erDiagram
"PM.ProductComponent_SourcingProductComponent" {
uniqueidentifier Id
uniqueidentifier ProductComponentId PK
uniqueidentifier SourcingProductComponentId PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.ProductElement_SourcingProductElement" {
uniqueidentifier Id
uniqueidentifier ProductElementId PK
uniqueidentifier SourcingProductElementId PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingProductComponentRuleConfigDetailSet" {
uniqueidentifier Id PK
uniqueidentifier SourcingProductComponentRuleConfigId FK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingProductComponentRuleConfigDetails" {
}
"PM.SourcingProductComponentRuleConfigs" {
uniqueidentifier Id PK
uniqueidentifier SourcingProductComponentId FK
nvarchar Name
int RuleType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SourcingProductComponents" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
int CommodityType
bigint LatestUpdateTimeStamp
int SourcingClusterTargetAssignmentType
}
"PM.SourcingProductElements" {
uniqueidentifier Id PK
uniqueidentifier SourcingProductComponentId FK
nvarchar Name
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.ProductComponent_SourcingProductComponent" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.ProductElement_SourcingProductElement" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "PM.SourcingProductComponentRuleConfigs" : "SourcingProductComponentRuleConfigId"
"PM.SourcingProductComponentRuleConfigs" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.SourcingClusters" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.SourcingProductElements" }o--|| "PM.SourcingProductComponents" : "SourcingProductComponentId"
"PM.TradeSummaries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.DealVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.OrderVersions" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingProductElementRuleConfigs" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.SourcingClusterInputTimeSeries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"{
"definitions": {
"PM.SourcingProductComponentRuleConfigDetails": {
"properties": {
},
"type": "object"
},
"PM.ProductElement_SourcingProductElement": {
"properties": {
"SourcingProductElementId": {
"type": "string",
"description": "FK to PM.SourcingProductElements"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductElementId": {
"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"
},
"PM.SourcingProductComponentRuleConfigs": {
"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"
},
"SourcingProductComponentId": {
"type": "string",
"description": "FK to PM.SourcingProductComponents"
},
"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"
},
"PM.SourcingProductComponents": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CommodityType": {
"type": "integer",
"description": "int"
},
"SourcingClusterTargetAssignmentType": {
"type": "integer",
"description": "int"
},
"LatestUpdateTimeStamp": {
"type": "string",
"description": "bigint"
},
"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"
},
"PM.ProductComponent_SourcingProductComponent": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingProductComponentId": {
"type": "string",
"description": "FK to PM.SourcingProductComponents"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ProductComponentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.SourcingProductElements": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SourcingProductComponentId": {
"type": "string",
"description": "FK to PM.SourcingProductComponents"
},
"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"
},
"PM.SourcingProductComponentRuleConfigDetailSet": {
"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"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"SourcingProductComponentRuleConfigId": {
"type": "string",
"description": "FK to PM.SourcingProductComponentRuleConfigs"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FormatType": {
"type": "integer",
"description": "int"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
}
},
"title": "PM.SourcingProductComponent",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Supply Agreement
Aggregate Root: SupplyAgreement
Represents supply agreements with their details, key values, and associated metering points.
erDiagram
"PM.SupplyAgreementDetails" {
uniqueidentifier Id PK
uniqueidentifier SupplyAgreementId FK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreementInputTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SupplyAgreementId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreementMetadataTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SupplyAgreementId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreements" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier PricingAgreementId
uniqueidentifier SourcingAgreementId
datetimeoffset ExpectedStartDateTimeOffset
datetimeoffset ExpectedEndDateTimeOffset
datetimeoffset StartDateTimeOffset
datetimeoffset EndDateTimeOffset
int SupplyAgreementType
datetimeoffset PositionClosingDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.SupplyAgreementInputTimeSeries" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.SupplyAgreementMetadataTimeSeries" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.SourcingCluster_SupplyAgreement" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.FixationRequests" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
erDiagram
"PM.SupplyAgreementDetails" {
uniqueidentifier Id PK
uniqueidentifier SupplyAgreementId FK
nvarchar Key
nvarchar Value
int Format
uniqueidentifier CustomEnumId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreementInputTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SupplyAgreementId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreementMetadataTimeSeries" {
uniqueidentifier Id PK
uniqueidentifier SupplyAgreementId FK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
nvarchar SubType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreements" {
uniqueidentifier Id PK
nvarchar InternalReference
nvarchar ExternalReference
uniqueidentifier PricingAgreementId
uniqueidentifier SourcingAgreementId
datetimeoffset ExpectedStartDateTimeOffset
datetimeoffset ExpectedEndDateTimeOffset
datetimeoffset StartDateTimeOffset
datetimeoffset EndDateTimeOffset
int SupplyAgreementType
datetimeoffset PositionClosingDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.SupplyAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.SupplyAgreementInputTimeSeries" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.SupplyAgreementMetadataTimeSeries" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.SourcingCluster_SupplyAgreement" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"
"PM.FixationRequests" }o--|| "PM.SupplyAgreements" : "SupplyAgreementId"{
"definitions": {
"PM.SupplyAgreementMetadataTimeSeries": {
"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"
},
"Revision": {
"type": "string",
"description": "nvarchar"
},
"DataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"SupplyAgreementId": {
"type": "string",
"description": "FK to PM.SupplyAgreements"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SubType": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"PM.SupplyAgreements": {
"properties": {
"SourcingAgreementId": {
"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"
},
"PositionClosingDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExpectedEndDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SupplyAgreementType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingAgreementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"StartDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ExpectedStartDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"EndDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"PM.SupplyAgreementInputTimeSeries": {
"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"
},
"Revision": {
"type": "string",
"description": "nvarchar"
},
"DataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"SupplyAgreementId": {
"type": "string",
"description": "FK to PM.SupplyAgreements"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SubType": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"PM.SupplyAgreementDetails": {
"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": "string",
"description": "nvarchar"
},
"SupplyAgreementId": {
"type": "string",
"description": "FK to PM.SupplyAgreements"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
}
},
"title": "PM.SupplyAgreement",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Trade Summary
Aggregate Root: TradeSummary
Represents summaries of trading activities with their details and key values for reporting purposes.
erDiagram
"PM.TradeSummaries" {
uniqueidentifier Id PK
bit IsDeal
uniqueidentifier AggregateRootId
uniqueidentifier LatestVersionId
uniqueidentifier AgreementId
int StrategyExecutionType
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
int LatestVersionNumber
nvarchar AggregateRootInternalReference
nvarchar AggregateRootExternalReference
datetimeoffset DeliveryPeriodStartDate
datetimeoffset DeliveryPeriodEndDate
uniqueidentifier SourcingProductElementId FK
int TradeContractType
uniqueidentifier CommodityTypeId FK
int LoadType
int SettlementMethod
uniqueidentifier SourcePortfolioId FK
uniqueidentifier SourceBookId FK
int SourceTradeDirection
uniqueidentifier TargetPortfolioId FK
uniqueidentifier TargetBookId FK
int TargetTradeDirection
decimal ContractedCapacity
int ContractedCapacityUnit
int OrderType
int OrderCondition
decimal MinimalExecutionVolume
int MinimalExecutionVolumeUnit
decimal UndisclosedVolume
int UndisclosedVolumeUnit
decimal Price
uniqueidentifier ChainId
int PriceUnit
bit VoiceBrokered
datetimeoffset TerminationDate
datetimeoffset EntityCreateDateTime
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourceSourcingClusterId
uniqueidentifier TargetSourcingClusterId
int DealConfirmationStatus
int OrderStatus
int SourceBookActionRunLatestStatus
int TargetBookActionRunLatestStatus
decimal TotalNotionalContractQuantity
int TotalNotionalContractQuantityUnit
uniqueidentifier FixationRequestId FK
uniqueidentifier FixationSubRequestId FK
nvarchar CounterReason
uniqueidentifier CounteredByCounterDealId
uniqueidentifier CounteredOriginalDealId
bit CounteringCompleted
nvarchar DeliveryLocationDescription
datetimeoffset TransactionDateTimeOffset
}
"PM.TradeSummary_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier TradeSummaryId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "TargetPortfolioId"
"PM.TradeSummaries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.TradeSummary_CategoryLabel" }o--|| "PM.TradeSummaries" : "TradeSummaryId"
"PM.TradeSummaries" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.TradeSummaries" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.TradeSummaries" }o--|| "PM.Books" : "SourceBookId"
"PM.TradeSummaries" }o--|| "PM.Books" : "TargetBookId"
"PM.TradeSummaries" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "SourcePortfolioId"
erDiagram
"PM.TradeSummaries" {
uniqueidentifier Id PK
bit IsDeal
uniqueidentifier AggregateRootId
uniqueidentifier LatestVersionId
uniqueidentifier AgreementId
int StrategyExecutionType
int ProcurementPeriodInMonths
int ProcurementOffsetPeriodInMonths
int ProcurementDeliveryPeriodInMonths
int LatestVersionNumber
nvarchar AggregateRootInternalReference
nvarchar AggregateRootExternalReference
datetimeoffset DeliveryPeriodStartDate
datetimeoffset DeliveryPeriodEndDate
uniqueidentifier SourcingProductElementId FK
int TradeContractType
uniqueidentifier CommodityTypeId FK
int LoadType
int SettlementMethod
uniqueidentifier SourcePortfolioId FK
uniqueidentifier SourceBookId FK
int SourceTradeDirection
uniqueidentifier TargetPortfolioId FK
uniqueidentifier TargetBookId FK
int TargetTradeDirection
decimal ContractedCapacity
int ContractedCapacityUnit
int OrderType
int OrderCondition
decimal MinimalExecutionVolume
int MinimalExecutionVolumeUnit
decimal UndisclosedVolume
int UndisclosedVolumeUnit
decimal Price
uniqueidentifier ChainId
int PriceUnit
bit VoiceBrokered
datetimeoffset TerminationDate
datetimeoffset EntityCreateDateTime
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier SourceSourcingClusterId
uniqueidentifier TargetSourcingClusterId
int DealConfirmationStatus
int OrderStatus
int SourceBookActionRunLatestStatus
int TargetBookActionRunLatestStatus
decimal TotalNotionalContractQuantity
int TotalNotionalContractQuantityUnit
uniqueidentifier FixationRequestId FK
uniqueidentifier FixationSubRequestId FK
nvarchar CounterReason
uniqueidentifier CounteredByCounterDealId
uniqueidentifier CounteredOriginalDealId
bit CounteringCompleted
nvarchar DeliveryLocationDescription
datetimeoffset TransactionDateTimeOffset
}
"PM.TradeSummary_CategoryLabel" {
uniqueidentifier Id PK
uniqueidentifier TradeSummaryId FK
uniqueidentifier CategoryId
uniqueidentifier CategoryLabelId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "TargetPortfolioId"
"PM.TradeSummaries" }o--|| "PM.SourcingProductElements" : "SourcingProductElementId"
"PM.TradeSummary_CategoryLabel" }o--|| "PM.TradeSummaries" : "TradeSummaryId"
"PM.TradeSummaries" }o--|| "PM.FixationRequests" : "FixationRequestId"
"PM.TradeSummaries" }o--|| "PM.FixationSubRequests" : "FixationSubRequestId"
"PM.TradeSummaries" }o--|| "PM.Books" : "SourceBookId"
"PM.TradeSummaries" }o--|| "PM.Books" : "TargetBookId"
"PM.TradeSummaries" }o--|| "PM.CommodityTypes" : "CommodityTypeId"
"PM.TradeSummaries" }o--|| "PM.Portfolios" : "SourcePortfolioId"{
"definitions": {
"PM.TradeSummary_CategoryLabel": {
"properties": {
"TradeSummaryId": {
"type": "string",
"description": "FK to PM.TradeSummaries"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CategoryLabelId": {
"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"
},
"CategoryId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PM.TradeSummaries": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CounteredOriginalDealId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"AggregateRootInternalReference": {
"type": "string",
"description": "nvarchar"
},
"ContractedCapacityUnit": {
"type": "integer",
"description": "int"
},
"AggregateRootExternalReference": {
"type": "string",
"description": "nvarchar"
},
"ProcurementDeliveryPeriodInMonths": {
"type": "integer",
"description": "int"
},
"DeliveryPeriodStartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ContractedCapacity": {
"type": "string",
"description": "decimal"
},
"SourceTradeDirection": {
"type": "integer",
"description": "int"
},
"CounteringCompleted": {
"type": "boolean",
"description": "bit"
},
"FixationRequestId": {
"type": "string",
"description": "FK to PM.FixationRequests"
},
"OrderCondition": {
"type": "integer",
"description": "int"
},
"TerminationDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SourceBookId": {
"type": "string",
"description": "FK to PM.Books"
},
"AggregateRootId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"AgreementId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProcurementPeriodInMonths": {
"type": "integer",
"description": "int"
},
"TargetPortfolioId": {
"type": "string",
"description": "FK to PM.Portfolios"
},
"TargetSourcingClusterId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ChainId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CounteredByCounterDealId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"LoadType": {
"type": "integer",
"description": "int"
},
"LatestVersionId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"VoiceBrokered": {
"type": "boolean",
"description": "bit"
},
"TotalNotionalContractQuantityUnit": {
"type": "integer",
"description": "int"
},
"SourceBookActionRunLatestStatus": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DeliveryLocationDescription": {
"type": "string",
"description": "nvarchar"
},
"LatestVersionNumber": {
"type": "integer",
"description": "int"
},
"ProcurementOffsetPeriodInMonths": {
"type": "integer",
"description": "int"
},
"TransactionDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CounterReason": {
"type": "string",
"description": "nvarchar"
},
"SourceSourcingClusterId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsDeal": {
"type": "boolean",
"description": "bit"
},
"SourcePortfolioId": {
"type": "string",
"description": "FK to PM.Portfolios"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TargetTradeDirection": {
"type": "integer",
"description": "int"
},
"PriceUnit": {
"type": "integer",
"description": "int"
},
"DealConfirmationStatus": {
"type": "integer",
"description": "int"
},
"UndisclosedVolumeUnit": {
"type": "integer",
"description": "int"
},
"FixationSubRequestId": {
"type": "string",
"description": "FK to PM.FixationSubRequests"
},
"TradeContractType": {
"type": "integer",
"description": "int"
},
"SourcingProductElementId": {
"type": "string",
"description": "FK to PM.SourcingProductElements"
},
"EntityCreateDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SettlementMethod": {
"type": "integer",
"description": "int"
},
"MinimalExecutionVolume": {
"type": "string",
"description": "decimal"
},
"MinimalExecutionVolumeUnit": {
"type": "integer",
"description": "int"
},
"StrategyExecutionType": {
"type": "integer",
"description": "int"
},
"CommodityTypeId": {
"type": "string",
"description": "FK to PM.CommodityTypes"
},
"TargetBookId": {
"type": "string",
"description": "FK to PM.Books"
},
"OrderStatus": {
"type": "integer",
"description": "int"
},
"TotalNotionalContractQuantity": {
"type": "string",
"description": "decimal"
},
"Price": {
"type": "string",
"description": "decimal"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"UndisclosedVolume": {
"type": "string",
"description": "decimal"
},
"TargetBookActionRunLatestStatus": {
"type": "integer",
"description": "int"
},
"OrderType": {
"type": "integer",
"description": "int"
},
"DeliveryPeriodEndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
}
},
"title": "PM.TradeSummary",
"$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
"PM.CustomEnumComponentValueKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentValueId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.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
}
"PM.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
}
"PM.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"
"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"
"PM.Books" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }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"
"PM.SourcingClusterDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
erDiagram
"PM.CustomEnumComponentValueKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentValueId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PM.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
}
"PM.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
}
"PM.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"
"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"
"PM.Books" }o--|| "CRM.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "Pricing.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }o--|| "ApplicationCore.CustomEnumComponents" : "ProductCustomEnumComponentId"
"PM.Books" }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"
"PM.SourcingClusterDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingClusterDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingProductComponentRuleConfigDetailSet" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SourcingProductElementRuleConfigDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.SupplyAgreementDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.BookActionDetails" }o--|| "PM.CustomEnums" : "CustomEnumId"{
"definitions": {
"PM.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"
},
"PM.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"
},
"PM.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"
},
"PM.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": "PM.CustomEnum",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}