Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Warning

REAL_ESTATE table is available only in environments v13.0 and higher.

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

reAddressLine1

string

11655

in_re_address_line1

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

ADDRESS_LINE1

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reAddressLine1

reAddressLine2

string

11656

in_re_address_line2

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

ADDRESS_LINE2

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reAddressLine2

reCity

string

11657

in_re_city

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

CITY

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reCity

impairedFlag

string

11658

in_re_impaired

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

IMPAIRED

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/realEstateModel/impairedFlag

netLeasableArea

string

11659

in_re_net_leasable_area

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

NET_LEASABLE_AREA

NUMBER

EagleML/referenceTransaction/genericSMF/realEstateModel/netLeasableArea

propertyType

string

11660

in_re_property_type

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

PROPERTY_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/propertyType

reState

string

11670

in_re_state

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

STATE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reState

statisticalDivision

string

11671

in_re_statistical_div

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

STATISTICAL_DIV

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/statisticalDivision

numberOfUnits

decimal

11672

in_re_unit_of_measure

N

realestate_model.inc

SECURITYDBO

REAL_ESTATE

UNITS

NIMBER(38,12)

EagleML/referenceTransaction/genericSMF/realEstateModel/numberOfUnits

unitOfMeasure

string

11673

in_re_units

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

UNIT_OF_MEASURE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/unitOfMeasure

propertySubType

string

17570

in_re_property_sub_type

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

PROPERTY_SUB_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/propertySubType

metro

string

17571

in_re_metro

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

METRO

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/metro

msa

string

17572

in_re_msa

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

MSA

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/msa

projectType

string

17573

in_re_project_type

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

PROJECT_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/projectType

yearBuilt

string

17574

in_re_year_built

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

YEAR_BUILT

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/yearBuilt

riskProfile

string

17575

in_re_risk_profile

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

RISK_PROFILE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/riskProfile

lifecycle

string

17576

in_re_lifecycle

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

LIFECYCLE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/lifecycle

renovated

string

17577

in_re_renovated

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

RENOVATED

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/renovated