Element | Optional/ Required | ValueType | StarTag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|
objectType |
Optional | |
| EagleML/warehouseTransaction/warehouseGLBalances/objectType |
objectId |
Optional | | |
| EagleML/warehouseTransaction/warehouseGLBalances/objectId |
objectDescription |
Optional | |
| EagleML/warehouseTransaction/warehouseGLBalances/objectDescription |
updateTimestamp |
Optional | | |
| 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 |
Required |
| 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 |
OptionalsingleRowCommitFlag |
| YesNoOptionEnum |
| | not stored in DB | |
|
| 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/ |
batchCollectErrorsFlagsingleRowCommitFlag | Optional | YesNoOptionEnum | | | not stored in DB | singleRowCommitFlagmaturityDate |
effectiveDate |
Optional |
| 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 |
Optional |
| string | 15 | in_gldp_long_short_ind | LEDGERDBO | GL_DETAIL_POSTING | GLDP_LONG_SHORT_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseGLBalances/longShortIndicator |
Entity Common Id Model |
updateSwitch |
| normalizedString |
| in_switch |
|
|
|
| EagleML/warehouseTransaction/warehouseGLBalances/ |
Entity Properties Model (extract onlyupdateSwitch |
shareClass |
| string | 34 | in_gldp_share_class | LEDGERDBO | GL_DETAIL_POSTING | GLDP_SHARE_CLASS | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseGLBalances/ |
accountingBasis | OptionalshareClass |
ledgerAccount |
| string | 1288 | in_gldp_ledger_acct | LEDGERDBO | GL_DETAIL_POSTING | GLDP_LEDGER_ACCT | CHAR(55) | EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccount |
ledgerAccountDescription |
| string |
21basisdesc | LEDGERDBO | GL_DETAIL_POSTING | GLDP_ |
ACCTGBASISDESC | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccountDescription |
balance |
| decimal | 903 | in_gldp_balance | LEDGERDBO | GL_DETAIL_POSTING | GLDP_BALANCE | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseGLBalances/ |
accountingBasisAsset Identifiers Modelbalance |
assetLiabCode |
| string | 12057 | in_gldp_asset_liab_code | LEDGERDBO | GL_DETAIL_POSTING | GLDP_ASSET_LIAB_CODE | VARCHAR2(12) | EagleML/warehouseTransaction/warehouseGLBalances/ |
Extended Asset Properties Model (extract onlyassetLiabCode |
assetLiabDescription |
| string | 12058 | in_gldp_asset_liab_desc | LEDGERDBO | GL_DETAIL_POSTING | GLDP_ASSET_LIAB_DESC | VARCHAR2(10) | EagleML/warehouseTransaction/warehouseGLBalances/ |
maturityDate | Optional assetLiabDescription |
stmtCat |
| string | 1291 | in_gldp_stmt_cat | LEDGERDBO | GL_DETAIL_POSTING | GLDP_STMT_CAT | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseGLBalances/stmtCat |
fromFundClass |
| string |
| | not stored in DB | LEDGERDBO | GL_DETAIL_POSTING | GLDP_FROM_FUND_CLASS | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/ |
maturityDateOptionalbaseCurrency | 86 | gldpbasecurrencyid | LEDGERDBO | GL_DETAIL_POSTING | GLDP_ |
BASECURRENCY CLASS | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/ |
baseCurrencyOptional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_LOT_NUMBER | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseGLBalances/lotNumber |
transactionIdOptional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_TRANSACTION_ID | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseGLBalances/ |
transactionIdOptional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GROUP_ID | NUMBER(15) | EagleML/warehouseTransaction/warehouseGLBalances/groupId |
groupSequence |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GROUP_SEQUENCE | NUMBER(4) | EagleML/warehouseTransaction/warehouseGLBalances/groupSequence |
accountingDateId |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_ACCOUNTING_DATE_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/accountingDateId |
accountingDate |
Optional |
| date | 36 | in_gldp_accounting_date | LEDGERDBO | GL_DETAIL_POSTING | GLDP_ACCOUNTING_DATE | DATE | EagleML/warehouseTransaction/warehouseGLBalances/accountingDate |
accountStartDate |
Optional | | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_ACCOUNT_START_DATE | DATE | EagleML/warehouseTransaction/warehouseGLBalances/accountStartDate |
amountBase |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_AMOUNT_BASE | NUMBER(15,2) | EagleML/warehouseTransaction/warehouseGLBalances/amountBase |
amountLocal |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_AMOUNT_LOCAL | NUMBER(15,2) | EagleML/warehouseTransaction/warehouseGLBalances/amountLocal |
datePostedId |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_DATE_POSTED_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/datePostedId |
datePosted |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_DATE_POSTED | DATE | EagleML/warehouseTransaction/warehouseGLBalances/datePosted |
debitOrCredit |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_DEBIT_OR_CREDIT | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseGLBalances/debitOrCredit |
postedToGl |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_POSTED_TO_GL | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseGLBalances/postedToGl |
postingSource |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_POSTING_SOURCE | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseGLBalances/postingSource |
recurringTrans |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_RECURRING_TRANS | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseGLBalances/recurringTrans |
timePosted |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_TIME_POSTED | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseGLBalances/timePosted |
gldpType |
Optional | | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_TYPE | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseGLBalances/gldpType |
userFlag |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_USER_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseGLBalances/userFlag |
userId |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_USER_ID | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseGLBalances/userId |
userText |
Optional | | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_USER_TEXT | VARCHAR2(20) | EagleML/warehouseTransaction/warehouseGLBalances/userText |
tradeId |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_TRADE_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/tradeId |
cashInt |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_CASH_INT | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/cashInt |
glgrId |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GLGR_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/glgrId |
glacId |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GLAC_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/glacId |
glprId |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GLPR_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/glprId |
glagId |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GLAG_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/glagId |
glabId |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GLAB_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/glabId |
glcfId |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_GLCF_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/glcfId |
transactionDateId |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_TRANSACTION_DATE_ID | NUMBER | EagleML/warehouseTransaction/warehouseGLBalances/transactionDateId |
transactionDate |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_TRANSACTION_DATE | DATE | EagleML/warehouseTransaction/warehouseGLBalances/transactionDate |
shareClass | Optional | string | 34in_gldp_share_class | LEDGERDBO | GL_DETAIL_POSTING | GLDP_SHARE_CLASS | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseGLBalances/shareClass | Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_ALLOCATION_ID | NUMBER(38) | EagleML/warehouseTransaction/warehouseGLBalances/allocationId |
rollupGroup |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_ROLLUP_GROUP | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseGLBalances/rollupGroup |
rollupIndicator |
Optional |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_ROLLUP_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseGLBalances/rollupIndicator |
userAmount |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_USER_AMOUNT | NUMBER(15,2) | EagleML/warehouseTransaction/warehouseTransaction/warehouseGLBalances/userAmount |
moneyManager |
Optional | | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_MONEY_MANAGER | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/moneyManager |
custodian |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_CUSTODIAN | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/custodian |
sectorId |
Optional |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_SECTOR_ID | CHAR(8) | EagleML/warehouseTransaction/warehouseGLBalances/sectorId |
coaName |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | COA_NAME | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseGLBalances/coaName |
custCoaAccountNumber |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | CUST_COA_ACCOUNT_NUMBER | CHAR(55) | EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountNumber |
custCoaAccountDescription |
Optional | | |
|
| LEDGERDBO | GL_DETAIL_POSTING | CUST_COA_ACCOUNT_DESC | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountDescription |
adjustIndicator |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | ADJUST_IND | CHAR(1) | EagleML/warehouseTransaction/warehouseGLBalances/adjustIndicator |
adjustId |
Optional |
|
| LEDGERDBO | GL_DETAIL_POSTING | ADJUST_ID | NUMBER(38) | EagleML/warehouseTransaction/warehouseGLBalances/adjustId |
masterId |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | MASTER_ID | NUMBER(38) | EagleML/warehouseTransaction/warehouseGLBalances/masterId |
userAdjust |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | USER_ADJUST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseGLBalances/userAdjust |
taxLineCode |
Optional | |
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_TAX_LINE_CODE | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/taxLineCode |
procSecType |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_PROC_SEC_TYPE | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/procSecType |
aggrTaxCode |
Optional | | |
|
| LEDGERDBO | GL_DETAIL_POSTING | AGGR_TAX_CODE | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/aggrTaxCode |
ledgerAccount | Optional | string | 1288 | in_gldp_ledger_acct | LEDGERDBO | GL_DETAIL_POSTING | GLDP_LEDGER_ACCT | CHAR(55) | EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccount |
ledgerAccountDescription | Optional | string | 1290 | in_gldp_ledger_acct_desc | LEDGERDBO | GL_DETAIL_POSTING | GLDP_LEDGER_ACCT_DESC | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccountDescription |
balance | Optional | decimal | 903 | in_gldp_balance | LEDGERDBO | GL_DETAIL_POSTING | GLDP_BALANCEassetLiabCode | Optional | string | 12057 | in_gldp_asset_liab_code | LEDGERDBO | GL_DETAIL_POSTING | GLDP_ASSET_LIAB_CODE | VARCHAR2(12) | EagleML/warehouseTransaction/warehouseGLBalances/assetLiabCode |
assetLiabDescription | Optional | string | 12058 | in_gldp_asset_liab_desc | LEDGERDBO | GL_DETAIL_POSTING | GLDP_ASSET_LIAB_DESC | VARCHAR2(10) | EagleML/warehouseTransaction/warehouseGLBalances/assetLiabDescription |
stmtCat | Optional | string | 1291 | in_gldp_stmt_cat | LEDGERDBO | GL_DETAIL_POSTING | GLDP_STMT_CAT | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseGLBalances/stmtCat |
fromFundClass | Optional | string | | | LEDGERDBO | GL_DETAIL_POSTING | GLDP_FROM_FUND_CLASS | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/fromFundClass |
contraClass | Optional | string | | in_cls_evt_id | LEDGERDBO | GL_DETAIL_POSTING | GLDP_CONTRA_CLASS | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseGLBalances/contraClass |
NUMBER(38,6) | EagleML/warehouseTransaction/warehouseGLBalances/balance | Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_BEGINNING_BALANCE_BASE | NUMBER(38,9) default is 0 | EagleML/warehouseTransaction/warehouseGLBalances/beginningBalanceBase |
endingBalanceBase |
Optional | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_ENDING_BALANCE_BASE | NUMBER(38,9) default is 0 | EagleML/warehouseTransaction/warehouseGLBalances/endingBalanceBase |
endingBalanceBaseTemp |
Optional | | |
|
| LEDGERDBO | GL_DETAIL_POSTING | GLDP_ENDING_BALANCE_BASE_TEMP | NUMBER(28,9) | EagleML/warehouseTransaction/warehouseGLBalances/endingBalanceBaseTemp |
closeoutLedgerAccountOffset |
Optional |
| string | 946 | in_closeout_ldgr_acct_offset | LEDGERDBO | GL_DETAIL_POSTING | CLOSEOUT_LEDGER_ACCT_OFFSET | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseGLBalances/closeoutLedgerAccountOffset |
closeoutLedgerAccountTarget |
Optional |
| 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 |