Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

ElementOptional/ RequiredValueTypeStarTagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpath
objectType
ObjectTypeEnum-
not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/objectType
objectId
ObjectId-
not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/objectId
objectDescription
FeedTypeEnum-
not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/objectDescription
updateTimestamp
dateTime-
not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/updateTimestamp
customElementsNot recommendedCustomElementsCustomElements - complex type (see extra table below)EagleML/warehouseTransaction/warehouseGLBalances/customElements/
sourceName
string1102in_short_descSPACE_MASTERDBOINTERFACESSHORT_DESCEagleML/warehouseTransaction/warehouseGLBalances/sourceName
updateSource
string944in_update_sourceLEDGERDBOGL_DETAIL_POSTINGUPDATE_SOURCECHAR(255)EagleML/warehouseTransaction/warehouseGLBalances/updateSource
batchCollectErrorsFlag
YesNoOptionEnum

not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/batchCollectErrorsFlag
singleRowCommitFlag
YesNoOptionEnum

not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/singleRowCommitFlag
reportType
normalizedString

not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/reportType
Entity Common Id ModelEagleML/warehouseTransaction/warehouseGLBalances/
Entity Properties Model (extract only)EagleML/warehouseTransaction/warehouseGLBalances/
accountingBasis
string21in_gldp_acct_basisLEDGERDBOGL_DETAIL_POSTINGGLDP_ACCTG_BASISVARCHAR2(6)EagleML/warehouseTransaction/warehouseGLBalances/accountingBasis
Asset Identifiers ModelEagleML/warehouseTransaction/warehouseGLBalances/
Extended Asset Properties Model (extract only)EagleML/warehouseTransaction/warehouseGLBalances/
maturityDate
string

not stored in DB
EagleML/warehouseTransaction/warehouseGLBalances/maturityDate
effectiveDate
date1109in_gldp_effective_dateLEDGERDBOGL_DETAIL_POSTINGGLDP_EFFECTIVE_DATECHAR(255)EagleML/warehouseTransaction/warehouseGLBalances/effectiveDate
baseCurrency
CurrencyCode86in_gldp_base_currencyLEDGERDBOGL_DETAIL_POSTINGGLDP_BASE_CURRENCY
EagleML/warehouseTransaction/warehouseGLBalances/baseCurrency
localCurrency
CurrencyCode8340in_gldp_currency_codeLEDGERDBOGL_DETAIL_POSTINGGLDP_CURRENCY_CODE
EagleML/warehouseTransaction/warehouseGLBalances/localCurrency
longShortIndicator
string15in_gldp_long_short_indLEDGERDBOGL_DETAIL_POSTINGGLDP_LONG_SHORT_INDVARCHAR2(1)EagleML/warehouseTransaction/warehouseGLBalances/longShortIndicator
updateSwitch
normalizedString
in_switch



EagleML/warehouseTransaction/warehouseGLBalances/updateSwitch
shareClass
string34in_gldp_share_classLEDGERDBOGL_DETAIL_POSTINGGLDP_SHARE_CLASSVARCHAR2(50)EagleML/warehouseTransaction/warehouseGLBalances/shareClass
ledgerAccount
string1288in_gldp_ledger_acctLEDGERDBOGL_DETAIL_POSTINGGLDP_LEDGER_ACCTCHAR(55)EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccount
ledgerAccountDescription
string1289in_gldp_ledger_acct_descLEDGERDBOGL_DETAIL_POSTINGGLDP_LEDGER_ACCT_DESCVARCHAR2(100)EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccountDescription
balance
decimal903in_gldp_balanceLEDGERDBOGL_DETAIL_POSTINGGLDP_BALANCENUMBER(38,6)EagleML/warehouseTransaction/warehouseGLBalances/balance
assetLiabCode
string12057in_gldp_asset_liab_codeLEDGERDBOGL_DETAIL_POSTINGGLDP_ASSET_LIAB_CODEVARCHAR2(12)EagleML/warehouseTransaction/warehouseGLBalances/assetLiabCode
assetLiabDescription
string12058in_gldp_asset_liab_descLEDGERDBOGL_DETAIL_POSTINGGLDP_ASSET_LIAB_DESCVARCHAR2(10)EagleML/warehouseTransaction/warehouseGLBalances/assetLiabDescription
stmtCat
string1291in_gldp_stmt_catLEDGERDBOGL_DETAIL_POSTINGGLDP_STMT_CATVARCHAR2(100)EagleML/warehouseTransaction/warehouseGLBalances/stmtCat
fromFundClass
string

LEDGERDBOGL_DETAIL_POSTINGGLDP_FROM_FUND_CLASSVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/fromFundClass
contraClass
string
in_cls_evt_idLEDGERDBOGL_DETAIL_POSTINGGLDP_CONTRA_CLASSVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/contraClass
lotNumber
string8333
LEDGERDBOGL_DETAIL_POSTINGGLDP_LOT_NUMBERVARCHAR2(8)EagleML/warehouseTransaction/warehouseGLBalances/lotNumber
gldpTransactionId
string8334
LEDGERDBOGL_DETAIL_POSTINGGLDP_TRANSACTION_IDVARCHAR2(15)EagleML/warehouseTransaction/warehouseGLBalances/gldpTransactionId
groupId
integer8335
LEDGERDBOGL_DETAIL_POSTINGGLDP_GROUP_IDNUMBER(15)EagleML/warehouseTransaction/warehouseGLBalances/groupId
groupSequence
integer8336
LEDGERDBOGL_DETAIL_POSTINGGLDP_GROUP_SEQUENCENUMBER(4)EagleML/warehouseTransaction/warehouseGLBalances/groupSequence
accountingDateId
integer8337
LEDGERDBOGL_DETAIL_POSTINGGLDP_ACCOUNTING_DATE_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/accountingDateId
accountingDate
date36in_gldp_accounting_dateLEDGERDBOGL_DETAIL_POSTINGGLDP_ACCOUNTING_DATEDATEEagleML/warehouseTransaction/warehouseGLBalances/accountingDate
accountStartDate
date

LEDGERDBOGL_DETAIL_POSTINGGLDP_ACCOUNT_START_DATEDATEEagleML/warehouseTransaction/warehouseGLBalances/accountStartDate
amountBase
decimal8338
LEDGERDBOGL_DETAIL_POSTINGGLDP_AMOUNT_BASENUMBER(15,2)EagleML/warehouseTransaction/warehouseGLBalances/amountBase
amountLocal
decimal8339
LEDGERDBOGL_DETAIL_POSTINGGLDP_AMOUNT_LOCALNUMBER(15,2)EagleML/warehouseTransaction/warehouseGLBalances/amountLocal
datePostedId
integer8341
LEDGERDBOGL_DETAIL_POSTINGGLDP_DATE_POSTED_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/datePostedId
datePosted
date8342
LEDGERDBOGL_DETAIL_POSTINGGLDP_DATE_POSTEDDATEEagleML/warehouseTransaction/warehouseGLBalances/datePosted
debitOrCredit
string8343
LEDGERDBOGL_DETAIL_POSTINGGLDP_DEBIT_OR_CREDITVARCHAR2(1)EagleML/warehouseTransaction/warehouseGLBalances/debitOrCredit
postedToGl
string8344
LEDGERDBOGL_DETAIL_POSTINGGLDP_POSTED_TO_GLVARCHAR2(1)EagleML/warehouseTransaction/warehouseGLBalances/postedToGl
postingSource
string8345
LEDGERDBOGL_DETAIL_POSTINGGLDP_POSTING_SOURCEVARCHAR2(15)EagleML/warehouseTransaction/warehouseGLBalances/postingSource
recurringTrans
string8346
LEDGERDBOGL_DETAIL_POSTINGGLDP_RECURRING_TRANSVARCHAR2(1)EagleML/warehouseTransaction/warehouseGLBalances/recurringTrans
timePosted
string8347
LEDGERDBOGL_DETAIL_POSTINGGLDP_TIME_POSTEDVARCHAR2(8)EagleML/warehouseTransaction/warehouseGLBalances/timePosted
gldpType
string

LEDGERDBOGL_DETAIL_POSTINGGLDP_TYPEVARCHAR2(100)EagleML/warehouseTransaction/warehouseGLBalances/gldpType
userFlag
string8348
LEDGERDBOGL_DETAIL_POSTINGGLDP_USER_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehouseGLBalances/userFlag
userId
string8349
LEDGERDBOGL_DETAIL_POSTINGGLDP_USER_IDVARCHAR2(8)EagleML/warehouseTransaction/warehouseGLBalances/userId
userText
string

LEDGERDBOGL_DETAIL_POSTINGGLDP_USER_TEXTVARCHAR2(20)EagleML/warehouseTransaction/warehouseGLBalances/userText
tradeId
integer8353
LEDGERDBOGL_DETAIL_POSTINGGLDP_TRADE_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/tradeId
cashInt
integer8354
LEDGERDBOGL_DETAIL_POSTINGGLDP_CASH_INTNUMBEREagleML/warehouseTransaction/warehouseGLBalances/cashInt
glgrId
integer8350
LEDGERDBOGL_DETAIL_POSTINGGLDP_GLGR_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/glgrId
glacId
integer8351
LEDGERDBOGL_DETAIL_POSTINGGLDP_GLAC_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/glacId
glprId
integer8352
LEDGERDBOGL_DETAIL_POSTINGGLDP_GLPR_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/glprId
glagId
integer8355
LEDGERDBOGL_DETAIL_POSTINGGLDP_GLAG_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/glagId
glabId
integer8356
LEDGERDBOGL_DETAIL_POSTINGGLDP_GLAB_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/glabId
glcfId
integer8357
LEDGERDBOGL_DETAIL_POSTINGGLDP_GLCF_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/glcfId
transactionDateId
integer8358
LEDGERDBOGL_DETAIL_POSTINGGLDP_TRANSACTION_DATE_IDNUMBEREagleML/warehouseTransaction/warehouseGLBalances/transactionDateId
transactionDate
date8359
LEDGERDBOGL_DETAIL_POSTINGGLDP_TRANSACTION_DATEDATEEagleML/warehouseTransaction/warehouseGLBalances/transactionDate
allocationId
integer8360
LEDGERDBOGL_DETAIL_POSTINGGLDP_ALLOCATION_IDNUMBER(38)EagleML/warehouseTransaction/warehouseGLBalances/allocationId
rollupGroup
string8361
LEDGERDBOGL_DETAIL_POSTINGGLDP_ROLLUP_GROUPVARCHAR2(50)EagleML/warehouseTransaction/warehouseGLBalances/rollupGroup
rollupIndicator
string8362
LEDGERDBOGL_DETAIL_POSTINGGLDP_ROLLUP_INDVARCHAR2(1)EagleML/warehouseTransaction/warehouseGLBalances/rollupIndicator
userAmount
decimal8363
LEDGERDBOGL_DETAIL_POSTINGGLDP_USER_AMOUNTNUMBER(15,2)EagleML/warehouseTransaction/warehouseTransaction/warehouseGLBalances/userAmount
moneyManager
string

LEDGERDBOGL_DETAIL_POSTINGGLDP_MONEY_MANAGERVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/moneyManager
custodian
string

LEDGERDBOGL_DETAIL_POSTINGGLDP_CUSTODIANVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/custodian
sectorId
string

LEDGERDBOGL_DETAIL_POSTINGGLDP_SECTOR_IDCHAR(8)EagleML/warehouseTransaction/warehouseGLBalances/sectorId
coaName
string

LEDGERDBOGL_DETAIL_POSTINGCOA_NAMEVARCHAR2(30)EagleML/warehouseTransaction/warehouseGLBalances/coaName
custCoaAccountNumber
string

LEDGERDBOGL_DETAIL_POSTINGCUST_COA_ACCOUNT_NUMBERCHAR(55)EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountNumber
custCoaAccountDescription
string

LEDGERDBOGL_DETAIL_POSTINGCUST_COA_ACCOUNT_DESCVARCHAR2(100)EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountDescription
adjustIndicator
string

LEDGERDBOGL_DETAIL_POSTINGADJUST_INDCHAR(1)EagleML/warehouseTransaction/warehouseGLBalances/adjustIndicator
adjustId
integer

LEDGERDBOGL_DETAIL_POSTINGADJUST_IDNUMBER(38)EagleML/warehouseTransaction/warehouseGLBalances/adjustId
masterId
integer

LEDGERDBOGL_DETAIL_POSTINGMASTER_IDNUMBER(38)EagleML/warehouseTransaction/warehouseGLBalances/masterId
userAdjust
decimal

LEDGERDBOGL_DETAIL_POSTINGUSER_ADJUSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseGLBalances/userAdjust
taxLineCode
string8364
LEDGERDBOGL_DETAIL_POSTINGGLDP_TAX_LINE_CODEVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/taxLineCode
procSecType
string

LEDGERDBOGL_DETAIL_POSTINGGLDP_PROC_SEC_TYPEVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/procSecType
aggrTaxCode
string

LEDGERDBOGL_DETAIL_POSTINGAGGR_TAX_CODEVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/aggrTaxCode
beginningBalanceBase
integer

LEDGERDBOGL_DETAIL_POSTINGGLDP_BEGINNING_BALANCE_BASENUMBER(38,9) default is 0EagleML/warehouseTransaction/warehouseGLBalances/beginningBalanceBase
endingBalanceBase
integer

LEDGERDBOGL_DETAIL_POSTINGGLDP_ENDING_BALANCE_BASENUMBER(38,9) default is 0EagleML/warehouseTransaction/warehouseGLBalances/endingBalanceBase
endingBalanceBaseTemp
integer

LEDGERDBOGL_DETAIL_POSTINGGLDP_ENDING_BALANCE_BASE_TEMPNUMBER(28,9)EagleML/warehouseTransaction/warehouseGLBalances/endingBalanceBaseTemp
closeoutLedgerAccountOffset
string946in_closeout_ldgr_acct_offsetLEDGERDBOGL_DETAIL_POSTINGCLOSEOUT_LEDGER_ACCT_OFFSETVARCHAR2(55)EagleML/warehouseTransaction/warehouseGLBalances/closeoutLedgerAccountOffset
closeoutLedgerAccountTarget
string931in_closeout_ldgr_acct_targetLEDGERDBOGL_DETAIL_POSTINGCLOSEOUT_LEDGER_ACCT_TARGETVARCHAR2(55)EagleML/warehouseTransaction/warehouseGLBalances/closeoutLedgerAccountTarget
custLedgerSource
string16420




EagleML/warehouseTransaction/warehouseGLBalances/custLedgerSource
drCrIndicator
string





EagleML/warehouseTransaction/warehouseGLBalances/drCrIndicator
absGldpBalance
decimal





EagleML/warehouseTransaction/warehouseGLBalances/absGldpBalance
  • No labels