SALES_CONTRACT_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
ArmsLengthIndicator	MISMOIndicator	BIT	NO	Indicates that this is an Arms Length Transaction. An Arms length transaction is between a willing buyer and a willing seller with no undue influence on either party and there is no relationship between the parties except that of the specific transaction.
PersonalPropertyIncludedIndicator	MISMOIndicator	BIT	NO	Indicates if there is personal property included in the contract for sale.
ProposedFinancingDescription	MISMOString	VARCHAR(0)	NO	A free form text field describing the terms of the loan or financing proposed in the sales transaction as determined in the analysis of the Sales Contract or transaction details by the appraiser.
SalesConcessionDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe sales concessions granted by an interested party.
SalesConcessionIndicator	MISMOIndicator	BIT	NO	When true indicates the presence of a concession in the sales contract.
SalesConditionsOfSaleDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the conditions of the sale
SalesContractAmount	MISMOAmount	DECIMAL(0, 2)	NO	The amount of money the contract is for.
SalesContractAnalysisDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used for the analysis of the terms and conditions of the property sales contract.
SalesContractDate	MISMODate	DATE	NO	The effective date of the sales contract (e.g. the date of sale)
SalesContractInvoiceRevewCommentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field reporting any comments about the sales contract or the reason it was not reviewed.
SalesContractInvoiceReviewedIndicator	MISMOIndicator	BIT	NO	Indicates that the appraiser did review the sales contract.
SalesContractRetailerName	MISMOString	VARCHAR(0)	NO	The name of the vendor of the contract.
SalesContractReviewCommentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the sales contract
SalesContractReviewDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the result of the review and analysis of the contract for sale or why analysis was not performed.
SalesContractReviewedIndicator	MISMOIndicator	BIT	NO	Indicated that the appraiser reviewed and analyzed the contract for sale for the subject purchase transaction.
SalesContractTermsConsistentWithMarketIndicator	MISMOIndicator	BIT	NO	Indicates that the terms and conditions of the sales contract are consistent with the local market
SaleType	SaleEnum	VARCHAR(0)	YES	Quantifies the type of sales transaction for the property as indicated from the analysis of the sales contract.
SaleTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additioal information when Other is selected for the ListingStatusType.
SellerIsOwnerIndicator	MISMOIndicator	BIT	NO	Indicates that the property seller is the owner of public record for the subject property.
TotalSalesConcessionAmount	MISMOAmount	DECIMAL(0, 2)	NO	The sum total dollar amount of the value of all sales concessions granted by an interested party including such items as furniture, carpeting, decorator allowances, automobiles, vacations, securities, giveaways or other sales incentives

SALES_CONTRACT_DETAIL Keys

Key Name

Key Type

Keys

SALES_CONTRACT_DETAIL Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
SALES_CONTRACT	Identifying	One to Zero or One					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

SALES_CONTRACT_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

SALES_CONTRACT_DETAIL Bound Attachments

Name	Current Value

SALES_CONTRACT_DETAIL User-Defined Mappings

Model

Name

Description

SALES_CONTRACT_DETAIL Data Movement Rules

Name

Type

Rule Text/Value