This is a description of the Portfolio Management module
This is the multi-page printable view of this section. Click here to print.
Portfolio Management module
The Portfolio Management module in Vertex
- 1: Sourcing Cluster
- 2: Book
- 3: PM Domain
1 - Sourcing Cluster
Sourcing clusters are automic units that execute a sourcing strategy. They respond to deals/orders and sourcing cluster volume inputs, calculate their own open position based on this data and has scripts to organise their volume and create orders or deals to interact with the rest of the portfolio.
Sourcing Cluster
Entity diagram
Calculations
Sourcing Cluster Actor
The sourcing cluster is implemented as an actor, this means that the actor is implemented as a black box that only has an inbox and an outbox with the outside world. The state that it creates is internal to the actor and shall not be directly viewed or mutated by anything else than an actor. This is why it is important to know the inputs and outputs of the sourcing cluster actor.
Inputs
Inputs from the actor should be introduced into the actor system. This can be done by other actors. There is special actor that can introduce messages from outside the actor system into the actor system. This actor is subscribes to a Kafka topic and publishes the messages to the specific actor that is the receipiant of the message.
Put Sourcing Cluster Volume Input
All volume inputs that are added to the sourcing cluster are also send to the sourcing cluster actor. The volume inputs message will contain the full time series data of the input as well as the metadata of that input.
Deal versions
All deals/deal versions that have a reference to a sourcing cluster are also send to the sourcing cluster. The message contains all the details of the deal version including possible volume or price time series data.
Order versions
All orders/order versions that have a reference to a sourcing cluster are also send to the sourcing cluster. The message contains all the details of the order version including possible volume or price time series data.
Linked order
Sends a message to the sourcing cluster actor whenever a order or deal is linked to an existing order and the sourcing cluster is involved in the parent order.
Initial sourcing cluster config
The message sends the initial configuration from the sourcing cluster to the sourcing cluster actor. This contains the intial configuration like the product type, book id, sourcing cluster key values, agreements on the sourcing cluster, scripts and sourcing product component en element configuration.
Set Process Forecast Responsibility Disabled
Sends a message to the sourcing cluster actor to enable or disable the processing of inputs to its target.
Set Process Open Position Management Disabled
Sends a message to the sourcing cluster actor to enable or disable the processing of open volume in the cluster. If disabled all input will still be processed to calculate a new open position but the cluster will not longer automatically act on this open position.
Sourcing cluster parent set
Send to a sourcing cluster actor to announce that it now has a parent sourcing cluster (actor).
Sourcing cluster child added
Send to a sourcing cluster actor to announce that another sourcing cluster (actor) just became its child.
Sourcing cluster Pricing Agreement Completed
Send to a sourcing cluster actor if a pricing agreement, that is linked to a sourcing cluster, is completed.
Sourcing cluster Sourcing Agreement Completed
Send to a sourcing cluster actor if a sourcing agreement, that is linked to a sourcing cluster, is completed.
Sourcing product component configuration update
Supply Agreement Strategies
Send to a sourcing cluster actor to send it the strategies that have been configured on supply agreements that are linked to sourcing agreements that are linked to the sourcing cluster.
Request rule context
Request the rule context of a sourcing cluster actor. Normally the rule context is created internally in the sourcing cluster actor from its internal state. This is only used for diagnostics of scripts that use the rule context of the sourcing cluster actor.
Diagnostics report request
Request a diagnostics report from a sourcing cluster actor. This is only used for diagnostics and is not used in the normal process.
Sourcing cluster deleted
Send to a sourcing cluster actor to inform it that the sourcing cluster has been deleted
Outputs
Command output
Send commands from the sourcing cluster actor to the CQRS system. It is wrapped in a message so we can use all message mechanics of the actor and to preserve existing transaction boundaries (commands should be send at the end of the message batch).
Position update
Send both the absolute as the relative position of all positions that have changed during the process of a batch of messages
Escalation
Sends a simple text message from the sourcing cluster actor when the sourcing cluster actor want to get the attention of a user.
Diagnostics report
A messages that contains a copy of or a summary of the internal state of the actor. This is only used for diagnostics to check the internal state of an actor.
Rule context output
Contains the rules context that can be used by the user to run scripts with a rule context that contains data from the internal state of the sourcing cluster actor.
2 - Book
A book can have actions to run. Everytime a book action is run a book action run is created. A book action run can have multiple attempts.
State diagram
This state diagram shows the flow for a book action run including attempts.
stateDiagram-v2
RUN: Book run
state RUN {
state "Create initial book run" as IBR
state "Create book run attempt" as CBRA
state "Book run completed" as BRC
state "Book run failed" as BRFAILED
BASG: Book attempt state graph
state BASG {
state "Waiting for approval" as WFA
state "In progress" as IP
state "Cancelled" as CNL
state "Completed" as CMPL
state "Error" as ERR
state "Manual approval required" as MA
MF: Message flow
state MF {
state "Sending request" as SR
state "Processing response" as PR
[*] --> SR
SR --> PR
SR --> [*]: Request compose failed
SR --> [*]: Cancelled by user or by related entity
PR --> [*]
}
state approval <<choice>>
[*] --> MA
MA --> approval
approval --> WFA: Start initial attempt with manual approval
approval --> IP: Start initial attempt without manual approval
WFA --> IP: Manually approved by user
WFA --> CNL: Cancelled by user or by related entity
IP --> CMPL
IP --> ERR
IP --> CNL
IP --> MF: Start sending
MF --> ERR: Response processing failed
MF --> CNL: Cancelled by user or by related entity
MF --> CMPL: Response processed
CMPL --> [*]
ERR --> [*]
CNL --> [*]
}
[*] --> IBR
IBR --> CBRA
CBRA --> BASG
BRFAILED --> CBRA: Retry book run
BASG --> BRC: Completed
BASG --> BRFAILED: Error
BASG --> BRFAILED: Cancelled
BRC --> [*]
BRFAILED --> [*]
}
[*] --> RUN
RUN --> [*]
3 - 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"
}