Element | Required/Optional | Value Type | Eagle DB | DB Table | DB Field | Data_Type | Xpath |
---|
objectType |
| ObjectTypeEnum | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/objectType |
objectId |
| ObjectId | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/objectId |
objectDescription |
| FeedTypeEnum | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/objectDescription |
updateTimestamp | Required | dateTime | SECURITYDBO | LINE_OF_CREDIT | UPDATE_DATE | DATE | EagleML/referenceTransaction/lineOfCreditFacility/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type | EagleML/referenceTransaction/lineOfCreditFacility/customElements/ |
sourceName |
| stringĀ |
|
|
|
| EagleML/referenceTransaction/lineOfCreditFacility/sourceName |
updateSource | Required | string | SECURITYDBO | LINE_OF_CREDIT | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/lineOfCreditFacility/updateSource |
effectiveDate | Required | date | SECURITYDBO | LINE_OF_CREDIT | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/lineOfCreditFacility/effectiveDate |
languageId |
| integer | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/languageId |
tagNochangecase |
| string | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/tagNochangecase |
preserveNull |
| string | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/preserveNull |
noLoadValidationFlag |
| YesNoOptionEnum | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/noLoadValidationFlag |
accountingValidationFlag |
| YesNoOptionEnum | not stored in DB |
| EagleML/referenceTransaction/lineOfCreditFacility/accountingValidationFlag |
facilityId | Required | string | SECURITYDBO | LINE_OF_CREDIT | FACILITY_ID | VARCHAR2(255) | EagleML/referenceTransaction/lineOfCreditFacility/facilityId |
facilityType |
| string | SECURITYDBO | LINE_OF_CREDIT | FACILITY_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/lineOfCreditFacility/facilityType |
facilityName |
| string | SECURITYDBO | LINE_OF_CREDIT | FACILITY_NAME | VARCHAR2(255) | EagleML/referenceTransaction/lineOfCreditFacility/facilityName |
durationOfFacilityInDays |
| decimal | SECURITYDBO | LINE_OF_CREDIT | DUR_OF_FACILITY_IN_DAYS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/durationOfFacilityInDays |
allowLoanMaturityInDays |
| decimal | SECURITYDBO | LINE_OF_CREDIT | ALLOW_LOAN_MAT_IN_DAYS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/allowLoanMaturityInDays |
allowMultipleFacilitiesFlag |
| YesNoOptionEnum | SECURITYDBO | LINE_OF_CREDIT | MULTIPLE_FACILITIES | VARCHAR2(1) | EagleML/referenceTransaction/lineOfCreditFacility/allowMultipleFacilitiesFlag |
agentFeeDollars |
| decimal | SECURITYDBO | LINE_OF_CREDIT | AGENT_FEE_DOLLARS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/agentFeeDollars |
agentFeeBasisPoints |
| decimal | SECURITYDBO | LINE_OF_CREDIT | AGENT_FEE_BASIS_POINTS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/agentFeeBasisPoints |
agentFeeTerms |
| string | SECURITYDBO | LINE_OF_CREDIT | AGENT_FEE_TERMS | VARCHAR2(255) | EagleML/referenceTransaction/lineOfCreditFacility/agentFeeTerms |
upfrontFeeBasisPoints |
| decimal | SECURITYDBO | LINE_OF_CREDIT | UPFRONT_FEE_BASIS_POINTS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/upfrontFeeBasisPoints |
upfrontFeeDollars |
| decimal | SECURITYDBO | LINE_OF_CREDIT | UPFRONT_FEE_DOLLARS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/upfrontFeeDollars |
commitmentFeeBasisPoints |
| decimal | SECURITYDBO | LINE_OF_CREDIT | COMMITMENT_FEE_BASIS_PTS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/commitmentFeeBasisPoints |
commitmentFeePayDescription |
| string | SECURITYDBO | LINE_OF_CREDIT | COMMITMENT_FEE_PAY_DESC | VARCHAR2(1000) | EagleML/referenceTransaction/lineOfCreditFacility/commitmentFeePayDescription |
commitmentFeeCalcDays |
| decimal | SECURITYDBO | LINE_OF_CREDIT | COMMITMENT_FEE_CALC_DAYS | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/commitmentFeeCalcDays |
defaultRatePercent |
| decimal | SECURITYDBO | LINE_OF_CREDIT | DEFAULT_RATE_PERCENT | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/defaultRatePercent |
defaultTermsDescription |
| string | SECURITYDBO | LINE_OF_CREDIT | DEFAULT_TERMS_DESCRIPTION | VARCHAR2(1000) | EagleML/referenceTransaction/lineOfCreditFacility/defaultTermsDescription |
amount |
| decimal | SECURITYDBO | LINE_OF_CREDIT | AMOUNT | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/amount |
paymentTiming |
| decimal | SECURITYDBO | LINE_OF_CREDIT | PAYMENT_TIMING | NUMBER(38,12) | EagleML/referenceTransaction/lineOfCreditFacility/paymentTiming |
paymentTimezone |
| string | SECURITYDBO | LINE_OF_CREDIT | PAYMENT_TIMEZONE | VARCHAR2(255) | EagleML/referenceTransaction/lineOfCreditFacility/paymentTimezone |
paymentTimeOfDay |
| string | SECURITYDBO | LINE_OF_CREDIT | PAYMENT_TIME_OF_DAY | VARCHAR2(2) | EagleML/referenceTransaction/lineOfCreditFacility/paymentTimeOfDay |
locEntity | LOC Entity Model - see extra table below | EagleML/referenceTransaction/lineOfCreditFacility/locEntity/ |
locIssuer | LOC Issuer Model - see extra table below | EagleML/referenceTransaction/lineOfCreditFacility/locIssuer/ |
LOC Entity Model |
Entity Common Id Model | ../ |
startDate |
| date | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | START_DATE | DATE | ../startDate |
endDate |
| date | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | END_DATE | DATE | ../endDate |
withdrawalIndicator |
| normalizedString | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | WITHDRAWAL_INDICATOR | VARCHAR2(1) | ../withdrawalIndicator |
locAverageOutstanding |
| decimal | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | LOC_AVG_OUSTANDING | NUMBER(38,12) | ../locAverageOutstanding |
locDaysInUse |
| decimal | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | LOC_DAYS_IN_USE | NUMBER(38,12) | ../locDaysInUse |
LOC Issuer ModelĀ |
Issuer Identifiers Model | ../ |
relationshipType |
| string | SECURITYDBO | LOC_ISSUER_RELATIONSHIP | RELATIONSHIP_TYPE | VARCHAR2(255) | ../relationshipType |
startDate |
| date | SECURITYDBO | LOC_ISSUER_RELATIONSHIP | START_DATE | DATE | ../startDate |
endDate |
| date | SECURITYDBO | LOC_ISSUER_RELATIONSHIP | END_DATE | DATE | ../endDate |
amount |
| decimal | SECURITYDBO | LOC_ISSUER_RELATIONSHIP | AMOUNT | NUMBER(38,12) | ../amount |