...
Element | Optional/ Required | ValueType | StarTag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|---|---|---|---|---|---|---|---|---|
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 |