ArmsLengthIndicator |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | ArmsLengthIndicator |
Logical Rolename | |
ColumnName | ArmsLengthIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | 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. |
Note |
ArmsLengthIndicator Logical Attribute Properties |
Logical Attribute Name | ArmsLengthIndicator |
Datatype | BIT |
Nullable | NO |
ArmsLengthIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ArmsLengthIndicator Bound Attachments |
Name | Current Value |
ArmsLengthIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ArmsLengthIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ArmsLengthIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ArmsLengthIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ArmsLengthIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PersonalPropertyIncludedIndicator |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | PersonalPropertyIncludedIndicator |
Logical Rolename | |
ColumnName | PersonalPropertyIncludedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates if there is personal property included in the contract for sale. |
Note |
PersonalPropertyIncludedIndicator Logical Attribute Properties |
Logical Attribute Name | PersonalPropertyIncludedIndicator |
Datatype | BIT |
Nullable | NO |
PersonalPropertyIncludedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PersonalPropertyIncludedIndicator Bound Attachments |
Name | Current Value |
PersonalPropertyIncludedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PersonalPropertyIncludedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PersonalPropertyIncludedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PersonalPropertyIncludedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PersonalPropertyIncludedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ProposedFinancingDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | ProposedFinancingDescription |
Logical Rolename | |
ColumnName | ProposedFinancingDescription |
RoleName | |
Domain | MISMOString |
Definition | 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. |
Note |
ProposedFinancingDescription Logical Attribute Properties |
Logical Attribute Name | ProposedFinancingDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ProposedFinancingDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ProposedFinancingDescription Bound Attachments |
Name | Current Value |
ProposedFinancingDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ProposedFinancingDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ProposedFinancingDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ProposedFinancingDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ProposedFinancingDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesConcessionDescription |
Logical Rolename | |
ColumnName | SalesConcessionDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe sales concessions granted by an interested party. |
Note |
SalesConcessionDescription Logical Attribute Properties |
Logical Attribute Name | SalesConcessionDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
SalesConcessionDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesConcessionDescription Bound Attachments |
Name | Current Value |
SalesConcessionDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesConcessionDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionIndicator |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesConcessionIndicator |
Logical Rolename | |
ColumnName | SalesConcessionIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true indicates the presence of a concession in the sales contract. |
Note |
SalesConcessionIndicator Logical Attribute Properties |
Logical Attribute Name | SalesConcessionIndicator |
Datatype | BIT |
Nullable | NO |
SalesConcessionIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesConcessionIndicator Bound Attachments |
Name | Current Value |
SalesConcessionIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesConcessionIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConcessionIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConditionsOfSaleDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesConditionsOfSaleDescription |
Logical Rolename | |
ColumnName | SalesConditionsOfSaleDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field describing the conditions of the sale |
Note |
SalesConditionsOfSaleDescription Logical Attribute Properties |
Logical Attribute Name | SalesConditionsOfSaleDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
SalesConditionsOfSaleDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesConditionsOfSaleDescription Bound Attachments |
Name | Current Value |
SalesConditionsOfSaleDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesConditionsOfSaleDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConditionsOfSaleDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConditionsOfSaleDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesConditionsOfSaleDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAmount |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractAmount |
Logical Rolename | |
ColumnName | SalesContractAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of money the contract is for. |
Note |
SalesContractAmount Logical Attribute Properties |
Logical Attribute Name | SalesContractAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesContractAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractAmount Bound Attachments |
Name | Current Value |
SalesContractAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAnalysisDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractAnalysisDescription |
Logical Rolename | |
ColumnName | SalesContractAnalysisDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used for the analysis of the terms and conditions of the property sales contract. |
Note |
SalesContractAnalysisDescription Logical Attribute Properties |
Logical Attribute Name | SalesContractAnalysisDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
SalesContractAnalysisDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractAnalysisDescription Bound Attachments |
Name | Current Value |
SalesContractAnalysisDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractAnalysisDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAnalysisDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAnalysisDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractAnalysisDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractDate |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractDate |
Logical Rolename | |
ColumnName | SalesContractDate |
RoleName | |
Domain | MISMODate |
Definition | The effective date of the sales contract (e.g. the date of sale) |
Note |
SalesContractDate Logical Attribute Properties |
Logical Attribute Name | SalesContractDate |
Datatype | DATE |
Nullable | NO |
SalesContractDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractDate Bound Attachments |
Name | Current Value |
SalesContractDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceRevewCommentDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractInvoiceRevewCommentDescription |
Logical Rolename | |
ColumnName | SalesContractInvoiceRevewCommentDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field reporting any comments about the sales contract or the reason it was not reviewed. |
Note |
SalesContractInvoiceRevewCommentDescription Logical Attribute Properties |
Logical Attribute Name | SalesContractInvoiceRevewCommentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
SalesContractInvoiceRevewCommentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractInvoiceRevewCommentDescription Bound Attachments |
Name | Current Value |
SalesContractInvoiceRevewCommentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractInvoiceRevewCommentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceRevewCommentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceRevewCommentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceRevewCommentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceReviewedIndicator |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractInvoiceReviewedIndicator |
Logical Rolename | |
ColumnName | SalesContractInvoiceReviewedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the appraiser did review the sales contract. |
Note |
SalesContractInvoiceReviewedIndicator Logical Attribute Properties |
Logical Attribute Name | SalesContractInvoiceReviewedIndicator |
Datatype | BIT |
Nullable | NO |
SalesContractInvoiceReviewedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractInvoiceReviewedIndicator Bound Attachments |
Name | Current Value |
SalesContractInvoiceReviewedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractInvoiceReviewedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceReviewedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceReviewedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractInvoiceReviewedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractRetailerName |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractRetailerName |
Logical Rolename | |
ColumnName | SalesContractRetailerName |
RoleName | |
Domain | MISMOString |
Definition | The name of the vendor of the contract. |
Note |
SalesContractRetailerName Logical Attribute Properties |
Logical Attribute Name | SalesContractRetailerName |
Datatype | VARCHAR(0) |
Nullable | NO |
SalesContractRetailerName Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractRetailerName Bound Attachments |
Name | Current Value |
SalesContractRetailerName User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractRetailerName Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractRetailerName Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractRetailerName Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractRetailerName Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewCommentDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractReviewCommentDescription |
Logical Rolename | |
ColumnName | SalesContractReviewCommentDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field describing the sales contract |
Note |
SalesContractReviewCommentDescription Logical Attribute Properties |
Logical Attribute Name | SalesContractReviewCommentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
SalesContractReviewCommentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractReviewCommentDescription Bound Attachments |
Name | Current Value |
SalesContractReviewCommentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractReviewCommentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewCommentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewCommentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewCommentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractReviewDescription |
Logical Rolename | |
ColumnName | SalesContractReviewDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field describing the result of the review and analysis of the contract for sale or why analysis was not performed. |
Note |
SalesContractReviewDescription Logical Attribute Properties |
Logical Attribute Name | SalesContractReviewDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
SalesContractReviewDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractReviewDescription Bound Attachments |
Name | Current Value |
SalesContractReviewDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractReviewDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewedIndicator |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractReviewedIndicator |
Logical Rolename | |
ColumnName | SalesContractReviewedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicated that the appraiser reviewed and analyzed the contract for sale for the subject purchase transaction. |
Note |
SalesContractReviewedIndicator Logical Attribute Properties |
Logical Attribute Name | SalesContractReviewedIndicator |
Datatype | BIT |
Nullable | NO |
SalesContractReviewedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractReviewedIndicator Bound Attachments |
Name | Current Value |
SalesContractReviewedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractReviewedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractReviewedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractTermsConsistentWithMarketIndicator |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SalesContractTermsConsistentWithMarketIndicator |
Logical Rolename | |
ColumnName | SalesContractTermsConsistentWithMarketIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the terms and conditions of the sales contract are consistent with the local market |
Note |
SalesContractTermsConsistentWithMarketIndicator Logical Attribute Properties |
Logical Attribute Name | SalesContractTermsConsistentWithMarketIndicator |
Datatype | BIT |
Nullable | NO |
SalesContractTermsConsistentWithMarketIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesContractTermsConsistentWithMarketIndicator Bound Attachments |
Name | Current Value |
SalesContractTermsConsistentWithMarketIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesContractTermsConsistentWithMarketIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractTermsConsistentWithMarketIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractTermsConsistentWithMarketIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesContractTermsConsistentWithMarketIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SaleType |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SaleType |
Logical Rolename | |
ColumnName | SaleType |
RoleName | |
Domain | SaleEnum |
Definition | Quantifies the type of sales transaction for the property as indicated from the analysis of the sales contract. |
Note |
SaleType Logical Attribute Properties |
Logical Attribute Name | SaleType |
Datatype | VARCHAR(0) |
Nullable | YES |
SaleType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SaleType Reference Value (Bound to Domain) |
Name | ValidationRule437 |
Description | |
Type | By List |
Value | Value Description |
CourtOrderedNonForeclosureSale | A sale in which a judge has ordered the sale of the property as a dispute resolution. Usually two people own it, one wants to sell, the other does not. The one wanting to sell always wins if the other refuses to buy them out. This could be a divorce or it could be an inherited property with multiple siblings. |
EstateSale | The most common reason for an estate sale is the death of the property owner, and the consequent need to quickly liquidate the belongings of the deceased. An estate sale may also occur because the property owner will be moving into a situation where he will be unable to keep his property—for example, a move to an assisted living facility, a retirement community, a rest home, or other living quarters. |
Other | Other |
RelocationSale | A property being sold as a part of an relocation program paid by an employer to assist an employee in liquidating a home. |
REOPostForeclosureSale | The sale of a property from inventory that has been foreclosed and taken possession of by the lien holder. |
ShortSale | A sale of property in which the lien holder accepts less than the debt or obligation against the property. |
TrusteeJudicialForeclosureSale | A judicial foreclosure process using a trustee. A Trustee Sale is a public auction that is open to all bidders and the property is usually awarded to the highest bidder who meets all the criteria set by the Trustee. A trustee is an entity or company chosen to administer the assets of the beneficiary and facilitate the foreclosure process. Once underway, a judicial foreclosure can only be stopped by payment in full. |
TrusteeNonJudicialForeclosureSale | A non-judicial foreclosure process. In a trustee sale, the lender files a Notice of Default and a notice is posted on the property indicating a trustee sale will be held at least 90 days later, generally but not always at the county courthouse steps. Unlike a foreclosure where the homeowners lone recourse is to redeem the full amount of the loan, an owner can stop a trustee sale simply by getting current on his or her mortgage payments plus any interest and fees that have been added along the way. A homeowner can do this at any time up to the posted time of the trustee sale and the entire process comes to a halt. |
SaleType Bound Attachments |
Name | Current Value |
SaleType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SaleType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SaleType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SaleType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SaleType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SaleTypeOtherDescription |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SaleTypeOtherDescription |
Logical Rolename | |
ColumnName | SaleTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additioal information when Other is selected for the ListingStatusType. |
Note |
SaleTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | SaleTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
SaleTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SaleTypeOtherDescription Bound Attachments |
Name | Current Value |
SaleTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SaleTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SaleTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SaleTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SaleTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SellerIsOwnerIndicator |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | SellerIsOwnerIndicator |
Logical Rolename | |
ColumnName | SellerIsOwnerIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the property seller is the owner of public record for the subject property. |
Note |
SellerIsOwnerIndicator Logical Attribute Properties |
Logical Attribute Name | SellerIsOwnerIndicator |
Datatype | BIT |
Nullable | NO |
SellerIsOwnerIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SellerIsOwnerIndicator Bound Attachments |
Name | Current Value |
SellerIsOwnerIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SellerIsOwnerIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SellerIsOwnerIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SellerIsOwnerIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SellerIsOwnerIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalSalesConcessionAmount |
Base Entity | SALES_CONTRACT_DETAIL |
Attribute Name | TotalSalesConcessionAmount |
Logical Rolename | |
ColumnName | TotalSalesConcessionAmount |
RoleName | |
Domain | MISMOAmount |
Definition | 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 |
Note |
TotalSalesConcessionAmount Logical Attribute Properties |
Logical Attribute Name | TotalSalesConcessionAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
TotalSalesConcessionAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TotalSalesConcessionAmount Bound Attachments |
Name | Current Value |
TotalSalesConcessionAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TotalSalesConcessionAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalSalesConcessionAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalSalesConcessionAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalSalesConcessionAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |