DEAL

DEAL

EntityType	Dependent
Logical Entity Name	DEAL
Default Table Name	MESSAGE/DOCUMENT_SETS/DOCUMENT_SET/DOCUMENTS/DOCUMENT/DEAL_SETS/DEAL_SET/DEALS/DEAL
Definition	The root element for all transactions that apply to the use cases of a single deal. A Deal may contain multiple loans or loan applications.
Note

DEAL Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

SequenceNumber XSD:Integer INTEGER YES An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.

MISMOReferenceModelIdentifier MISMOReferenceModelIdentifier VARCHAR(0) YES The MISMO Reference Model Identifier is a unique value that represents the version of the MISMO reference model to which the containing XML instance document complies. For detailed information, please see MISMO Engineering Guide 006 – “Versioning and Release Schedule”, at http://www.mismo.org/specs/specs-downloads/cat_view/249-mismo-engineering-guidelines.html.

MISMOLogicalDataDictionaryIdentifier MISMOLogicalDataDictionaryIdentifier VARCHAR(0) YES The MISMO Logical Data Dictionary Identifier is a unique value that represents the version of the MISMO LDD section of the reference model to which the containing XML instance document complies. For detailed information, please see MISMO Engineering Guide 006 – “Versioning and Release Schedule”, at http://www.mismo.org/specs/specs-downloads/cat_view/249-mismo-engineering-guidelines.html.

DEAL Keys

Key Name Key Type Keys

DEAL Relationships

Parent Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Supertype

DEALS Identifying One To Zero or More NO

Child Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Subtype

ABOUT_VERSIONS Non-Identifying One to Zero or One NO

ASSETS Non-Identifying One to Zero or One NO

COLLATERALS Non-Identifying One to Zero or One NO

EXPENSES Non-Identifying One to Zero or One NO

LIABILITIES Non-Identifying One to Zero or One NO

RELATIONSHIPS Non-Identifying One to Zero or One NO

SERVICES Non-Identifying One to Zero or One NO

LOANS Non-Identifying One to Zero or One NO

PARTIES Non-Identifying One to Zero or One NO

REFERENCE Non-Identifying One to Zero or One NO

DEAL Check Constraints

Check Constraint Name CheckConstraint

DEAL Bound Attachments

Name Current Value

DEAL User-Defined Mappings

Model Name Description

DEAL Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
MISMOReferenceModelIdentifier	MISMOReferenceModelIdentifier	VARCHAR(0)	YES	The MISMO Reference Model Identifier is a unique value that represents the version of the MISMO reference model to which the containing XML instance document complies. For detailed information, please see MISMO Engineering Guide 006 – “Versioning and Release Schedule”, at http://www.mismo.org/specs/specs-downloads/cat_view/249-mismo-engineering-guidelines.html.
MISMOLogicalDataDictionaryIdentifier	MISMOLogicalDataDictionaryIdentifier	VARCHAR(0)	YES	The MISMO Logical Data Dictionary Identifier is a unique value that represents the version of the MISMO LDD section of the reference model to which the containing XML instance document complies. For detailed information, please see MISMO Engineering Guide 006 – “Versioning and Release Schedule”, at http://www.mismo.org/specs/specs-downloads/cat_view/249-mismo-engineering-guidelines.html.

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
DEALS	Identifying	One To Zero or More					NO