Warehouse GL Balances Data Map Table

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

customElements

Not recommended

CustomElements

CustomElements - complex type (see extra table below)

EagleML/warehouseTransaction/warehouseGLBalances/customElements/

sourceName

string

1102

in_short_desc

S

PACE_MASTERDBO

INTERFACES

SHORT_DESC

EagleML/warehouseTransaction/warehouseGLBalances/sourceName

updateSource

string

944

in_update_source

LEDGERDBO

GL_DETAIL_POSTING

UPDATE_SOURCE

CHAR(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 Model

EagleML/warehouseTransaction/warehouseGLBalances/

Entity Properties Model (extract only)

EagleML/warehouseTransaction/warehouseGLBalances/

accountingBasis

string

21

in_gldp_acct_basis

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ACCTG_BASIS

VARCHAR2(6)

EagleML/warehouseTransaction/warehouseGLBalances/accountingBasis

Asset Identifiers Model

EagleML/warehouseTransaction/warehouseGLBalances/

Extended Asset Properties Model (extract only)

EagleML/warehouseTransaction/warehouseGLBalances/

maturityDate

string

not stored in DB

EagleML/warehouseTransaction/warehouseGLBalances/maturityDate

effectiveDate

date

1109

in_gldp_effective_date

LEDGERDBO

GL_DETAIL_POSTING

GLDP_EFFECTIVE_DATE

CHAR(255)

EagleML/warehouseTransaction/warehouseGLBalances/effectiveDate

baseCurrency

CurrencyCode

86

in_gldp_base_currency

LEDGERDBO

GL_DETAIL_POSTING

GLDP_BASE_CURRENCY

EagleML/warehouseTransaction/warehouseGLBalances/baseCurrency

localCurrency

CurrencyCode

8340

in_gldp_currency_code

LEDGERDBO

GL_DETAIL_POSTING

GLDP_CURRENCY_CODE

EagleML/warehouseTransaction/warehouseGLBalances/localCurrency

longShortIndicator

string

15

in_gldp_long_short_ind

LEDGERDBO

GL_DETAIL_POSTING

GLDP_LONG_SHORT_IND

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseGLBalances/longShortIndicator

updateSwitch

normalizedString

in_switch

EagleML/warehouseTransaction/warehouseGLBalances/updateSwitch

shareClass

string

34

in_gldp_share_class

LEDGERDBO

GL_DETAIL_POSTING

GLDP_SHARE_CLASS

VARCHAR2(50)

EagleML/warehouseTransaction/warehouseGLBalances/shareClass

ledgerAccount

string

1288

in_gldp_ledger_acct

LEDGERDBO

GL_DETAIL_POSTING

GLDP_LEDGER_ACCT

CHAR(55)

EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccount

ledgerAccountDescription

string

1289

in_gldp_ledger_acct_desc

LEDGERDBO

GL_DETAIL_POSTING

GLDP_LEDGER_ACCT_DESC

VARCHAR2(100)

EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccountDescription

balance

decimal

903

in_gldp_balance

LEDGERDBO

GL_DETAIL_POSTING

GLDP_BALANCE

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseGLBalances/balance

assetLiabCode

string

12057

in_gldp_asset_liab_code

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ASSET_LIAB_CODE

VARCHAR2(12)

EagleML/warehouseTransaction/warehouseGLBalances/assetLiabCode

assetLiabDescription

string

12058

in_gldp_asset_liab_desc

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ASSET_LIAB_DESC

VARCHAR2(10)

EagleML/warehouseTransaction/warehouseGLBalances/assetLiabDescription

stmtCat

string

1291

in_gldp_stmt_cat

LEDGERDBO

GL_DETAIL_POSTING

GLDP_STMT_CAT

VARCHAR2(100)

EagleML/warehouseTransaction/warehouseGLBalances/stmtCat

fromFundClass

string

LEDGERDBO

GL_DETAIL_POSTING

GLDP_FROM_FUND_CLASS

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/fromFundClass

contraClass

string

in_cls_evt_id

LEDGERDBO

GL_DETAIL_POSTING

GLDP_CONTRA_CLASS

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/contraClass

lotNumber

string

8333

LEDGERDBO

GL_DETAIL_POSTING

GLDP_LOT_NUMBER

VARCHAR2(8)

EagleML/warehouseTransaction/warehouseGLBalances/lotNumber

gldpTransactionId

string

8334

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TRANSACTION_ID

VARCHAR2(15)

EagleML/warehouseTransaction/warehouseGLBalances/gldpTransactionId

groupId

integer

8335

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GROUP_ID

NUMBER(15)

EagleML/warehouseTransaction/warehouseGLBalances/groupId

groupSequence

integer

8336

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GROUP_SEQUENCE

NUMBER(4)

EagleML/warehouseTransaction/warehouseGLBalances/groupSequence

accountingDateId

integer

8337

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ACCOUNTING_DATE_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/accountingDateId

accountingDate

date

36

in_gldp_accounting_date

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ACCOUNTING_DATE

DATE

EagleML/warehouseTransaction/warehouseGLBalances/accountingDate

accountStartDate

date

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ACCOUNT_START_DATE

DATE

EagleML/warehouseTransaction/warehouseGLBalances/accountStartDate

amountBase

decimal

8338

LEDGERDBO

GL_DETAIL_POSTING

GLDP_AMOUNT_BASE

NUMBER(15,2)

EagleML/warehouseTransaction/warehouseGLBalances/amountBase

amountLocal

decimal

8339

LEDGERDBO

GL_DETAIL_POSTING

GLDP_AMOUNT_LOCAL

NUMBER(15,2)

EagleML/warehouseTransaction/warehouseGLBalances/amountLocal

datePostedId

integer

8341

LEDGERDBO

GL_DETAIL_POSTING

GLDP_DATE_POSTED_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/datePostedId

datePosted

date

8342

LEDGERDBO

GL_DETAIL_POSTING

GLDP_DATE_POSTED

DATE

EagleML/warehouseTransaction/warehouseGLBalances/datePosted

debitOrCredit

string

8343

LEDGERDBO

GL_DETAIL_POSTING

GLDP_DEBIT_OR_CREDIT

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseGLBalances/debitOrCredit

postedToGl

string

8344

LEDGERDBO

GL_DETAIL_POSTING

GLDP_POSTED_TO_GL

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseGLBalances/postedToGl

postingSource

string

8345

LEDGERDBO

GL_DETAIL_POSTING

GLDP_POSTING_SOURCE

VARCHAR2(15)

EagleML/warehouseTransaction/warehouseGLBalances/postingSource

recurringTrans

string

8346

LEDGERDBO

GL_DETAIL_POSTING

GLDP_RECURRING_TRANS

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseGLBalances/recurringTrans

timePosted

string

8347

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TIME_POSTED

VARCHAR2(8)

EagleML/warehouseTransaction/warehouseGLBalances/timePosted

gldpType

string

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TYPE

VARCHAR2(100)

EagleML/warehouseTransaction/warehouseGLBalances/gldpType

userFlag

string

8348

LEDGERDBO

GL_DETAIL_POSTING

GLDP_USER_FLAG

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseGLBalances/userFlag

userId

string

8349

LEDGERDBO

GL_DETAIL_POSTING

GLDP_USER_ID

VARCHAR2(8)

EagleML/warehouseTransaction/warehouseGLBalances/userId

userText

string

LEDGERDBO

GL_DETAIL_POSTING

GLDP_USER_TEXT

VARCHAR2(20)

EagleML/warehouseTransaction/warehouseGLBalances/userText

tradeId

integer

8353

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TRADE_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/tradeId

cashInt

integer

8354

LEDGERDBO

GL_DETAIL_POSTING

GLDP_CASH_INT

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/cashInt

glgrId

integer

8350

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GLGR_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/glgrId

glacId

integer

8351

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GLAC_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/glacId

glprId

integer

8352

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GLPR_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/glprId

glagId

integer

8355

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GLAG_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/glagId

glabId

integer

8356

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GLAB_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/glabId

glcfId

integer

8357

LEDGERDBO

GL_DETAIL_POSTING

GLDP_GLCF_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/glcfId

transactionDateId

integer

8358

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TRANSACTION_DATE_ID

NUMBER

EagleML/warehouseTransaction/warehouseGLBalances/transactionDateId

transactionDate

date

8359

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TRANSACTION_DATE

DATE

EagleML/warehouseTransaction/warehouseGLBalances/transactionDate

allocationId

integer

8360

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ALLOCATION_ID

NUMBER(38)

EagleML/warehouseTransaction/warehouseGLBalances/allocationId

rollupGroup

string

8361

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ROLLUP_GROUP

VARCHAR2(50)

EagleML/warehouseTransaction/warehouseGLBalances/rollupGroup

rollupIndicator

string

8362

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ROLLUP_IND

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseGLBalances/rollupIndicator

userAmount

decimal

8363

LEDGERDBO

GL_DETAIL_POSTING

GLDP_USER_AMOUNT

NUMBER(15,2)

EagleML/warehouseTransaction/warehouseTransaction/warehouseGLBalances/userAmount

moneyManager

string

LEDGERDBO

GL_DETAIL_POSTING

GLDP_MONEY_MANAGER

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/moneyManager

custodian

string

LEDGERDBO

GL_DETAIL_POSTING

GLDP_CUSTODIAN

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/custodian

sectorId

string

LEDGERDBO

GL_DETAIL_POSTING

GLDP_SECTOR_ID

CHAR(8)

EagleML/warehouseTransaction/warehouseGLBalances/sectorId

coaName

string

LEDGERDBO

GL_DETAIL_POSTING

COA_NAME

VARCHAR2(30)

EagleML/warehouseTransaction/warehouseGLBalances/coaName

custCoaAccountNumber

string

LEDGERDBO

GL_DETAIL_POSTING

CUST_COA_ACCOUNT_NUMBER

CHAR(55)

EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountNumber

custCoaAccountDescription

string

LEDGERDBO

GL_DETAIL_POSTING

CUST_COA_ACCOUNT_DESC

VARCHAR2(100)

EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountDescription

adjustIndicator

string

LEDGERDBO

GL_DETAIL_POSTING

ADJUST_IND

CHAR(1)

EagleML/warehouseTransaction/warehouseGLBalances/adjustIndicator

adjustId

integer

LEDGERDBO

GL_DETAIL_POSTING

ADJUST_ID

NUMBER(38)

EagleML/warehouseTransaction/warehouseGLBalances/adjustId

masterId

integer

LEDGERDBO

GL_DETAIL_POSTING

MASTER_ID

NUMBER(38)

EagleML/warehouseTransaction/warehouseGLBalances/masterId

userAdjust

decimal

LEDGERDBO

GL_DETAIL_POSTING

USER_ADJUST

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseGLBalances/userAdjust

taxLineCode

string

8364

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TAX_LINE_CODE

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/taxLineCode

procSecType

string

LEDGERDBO

GL_DETAIL_POSTING

GLDP_PROC_SEC_TYPE

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/procSecType

aggrTaxCode

string

LEDGERDBO

GL_DETAIL_POSTING

AGGR_TAX_CODE

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/aggrTaxCode

beginningBalanceBase

integer

LEDGERDBO

GL_DETAIL_POSTING

GLDP_BEGINNING_BALANCE_BASE

NUMBER(38,9) default is 0

EagleML/warehouseTransaction/warehouseGLBalances/beginningBalanceBase

endingBalanceBase

integer

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ENDING_BALANCE_BASE

NUMBER(38,9) default is 0

EagleML/warehouseTransaction/warehouseGLBalances/endingBalanceBase

endingBalanceBaseTemp

integer

LEDGERDBO

GL_DETAIL_POSTING

GLDP_ENDING_BALANCE_BASE_TEMP

NUMBER(28,9)

EagleML/warehouseTransaction/warehouseGLBalances/endingBalanceBaseTemp

closeoutLedgerAccountOffset

string

946

in_closeout_ldgr_acct_offset

LEDGERDBO

GL_DETAIL_POSTING

CLOSEOUT_LEDGER_ACCT_OFFSET

VARCHAR2(55)

EagleML/warehouseTransaction/warehouseGLBalances/closeoutLedgerAccountOffset

closeoutLedgerAccountTarget

string

931

in_closeout_ldgr_acct_target

LEDGERDBO

GL_DETAIL_POSTING

CLOSEOUT_LEDGER_ACCT_TARGET

VARCHAR2(55)

EagleML/warehouseTransaction/warehouseGLBalances/closeoutLedgerAccountTarget

custLedgerSource

string

16420

EagleML/warehouseTransaction/warehouseGLBalances/custLedgerSource

drCrIndicator

string

EagleML/warehouseTransaction/warehouseGLBalances/drCrIndicator

absGldpBalance

decimal

EagleML/warehouseTransaction/warehouseGLBalances/absGldpBalance

updateInsertFlag

string

5733

in_update_insert_flag

not stored in DB

EagleML/warehouseTransaction/warehouseGLBalances/updateInsertFlag