Element |
Optional/ Required |
Value Type |
Star Tag |
SP Parameter |
SP TYPE |
Eagle DB |
DB Table |
DB Field |
DB Field Type |
Xpath |
---|---|---|---|---|---|---|---|---|---|---|
legalId |
Optional |
string |
5089 |
in_lei |
S |
SECURITYDBO |
LEI_DETAILS/ ISSUER_ORGANIZATION |
LEI |
VARCHAR2(20) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/legalId |
legalName |
Optional |
string |
5090 |
in_legal_name |
S |
SECURITYDBO |
LEI_DETAILS |
LEGAL_NAME |
VARCHAR2(255) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/legalName |
entityStatus |
Optional |
string |
5091 |
in_entity_status |
S |
SECURITYDBO |
LEI_DETAILS |
ENTITY_STATUS |
VARCHAR2(30) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/entityStatus |
legalForm |
Optional |
string |
5092 |
in_legal_form |
S |
SECURITYDBO |
LEI_DETAILS |
LEGAL_FORM |
VARCHAR2(30) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/legalForm |
idAssignedDate |
Optional |
date |
5093 |
in_id_assigned_date |
S |
SECURITYDBO |
LEI_DETAILS |
ID_ASSIGNED_DATE |
DATE |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/idAssignedDate |
idLastUpdateDate |
Optional |
date |
5094 |
in_id_last_update_date |
S |
SECURITYDBO |
LEI_DETAILS |
ID_LAST_UPDATE_DATE |
DATE |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/idLastUpdateDate |
idDisabledDate |
Optional |
date |
5095 |
in_id_disabled_date |
S |
SECURITYDBO |
LEI_DETAILS |
ID_DISABLED_DATE |
DATE |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/idDisabledDate |
idRecordState |
Optional |
string |
5096 |
in_id_record_state |
S |
SECURITYDBO |
LEI_DETAILS |
ID_RECORD_STATE |
VARCHAR2(30) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/idRecordState |
idCertificationState |
Optional |
string |
5097 |
in_id_certification_state |
S |
SECURITYDBO |
LEI_DETAILS |
ID_CERTIFICATION_STATE |
VARCHAR2(30) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/idCertificationState |
street |
Optional |
string |
5098 |
in_street |
S |
SECURITYDBO |
LEI_DETAILS |
STREET |
VARCHAR2(255) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/street |
city |
Optional |
string |
5099 |
in_city |
S |
SECURITYDBO |
LEI_DETAILS |
CITY |
VARCHAR2(255) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/city |
state |
Optional |
string |
5100 |
in_state |
S |
SECURITYDBO |
LEI_DETAILS |
STATE |
VARCHAR2(255) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/state |
zip |
Optional |
string |
5180 |
in_zip |
S |
SECURITYDBO |
LEI_DETAILS |
ZIP |
VARCHAR2(255) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/zip |
countryCode |
Optional |
string |
5181 |
in_country_code |
S |
SECURITYDBO |
LEI_DETAILS |
COUNTRY_CODE |
VARCHAR2(30) |
EagleML/referenceTransaction/issuerOrganization/legalEntityId/countryCode |