Page Comparison

Element	Optional/ Required	ValueType	StarTag	SP Parameter	Eagle DB	DB Table	DB Field	DB Field Type	Xpath
objectType

Optional

ObjectTypeEnum

-

not stored in DB

				EagleML/warehouseTransaction/warehouseGLBalances/objectType
objectId

Optional

ObjectId

-

not stored in DB

				EagleML/warehouseTransaction/warehouseGLBalances/objectId
objectDescription

Optional

FeedTypeEnum

-

not stored in DB

	EagleML/warehouseTransaction/warehouseGLBalances/objectDescription
updateTimestamp

Optional

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

Required

	string	944	in_update_source	LEDGERDBO	GL_DETAIL_POSTING	UPDATE_SOURCE	CHAR(255)	EagleML/warehouseTransaction/warehouseGLBalances/updateSource
batchCollectErrorsFlag

Optional

	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/

batchCollectErrorsFlagsingleRowCommitFlagOptionalYesNoOptionEnum not stored in DB

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/

singleRowCommitFlag

maturityDate

effectiveDate

Optional

date

1109

in_gldp_effective_date

LEDGERDBO

GL_DETAIL_POSTING

GLDP_EFFECTIVE_DATE

CHAR(255)

EagleML/warehouseTransaction/warehouseGLBalances/effectiveDate

longShortIndicatorOptional

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

Entity Common Id Model

updateSwitch

normalizedString

in_switch

EagleML/warehouseTransaction/warehouseGLBalances/

Entity Properties Model (extract only

updateSwitch
shareClass		string	34	in_gldp_share_class	LEDGERDBO	GL_DETAIL_POSTING	GLDP_SHARE_CLASS	VARCHAR2(50)	EagleML/warehouseTransaction/warehouseGLBalances/

accountingBasisOptional

shareClass
ledgerAccount	string	1288	in_gldp_ledger_acct	LEDGERDBO	GL_DETAIL_POSTING	GLDP_LEDGER_ACCT	CHAR(55)	EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccount
ledgerAccountDescription	string

21

1289	in_gldp_ledger_acct_

basis

desc

LEDGERDBO

GL_DETAIL_POSTING

GLDP_LEDGER_

ACCTG

ACCT_

BASIS

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/

accountingBasisAsset Identifiers Model

balance
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 only

assetLiabCode
assetLiabDescription		string	12058	in_gldp_asset_liab_desc	LEDGERDBO	GL_DETAIL_POSTING	GLDP_ASSET_LIAB_DESC	VARCHAR2(10)	EagleML/warehouseTransaction/warehouseGLBalances/

maturityDateOptional

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/

maturityDate

fromFundClass

baseCurrency

contraClass

Optional

string

86

in_

gldp

cls_

base

evt_

currency

id

LEDGERDBO

GL_DETAIL_POSTING

GLDP_

BASE

CONTRA_

CURRENCY

CLASS

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/

baseCurrency

contraClass

lotNumber

Optional

string

8333

Optional

LEDGERDBO

GL_DETAIL_POSTING

GLDP_LOT_NUMBER

VARCHAR2(8)

EagleML/warehouseTransaction/warehouseGLBalances/lotNumber

transactionId

gldpTransactionId

string

8334

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TRANSACTION_ID

VARCHAR2(15)

EagleML/warehouseTransaction/warehouseGLBalances/

transactionId

gldpTransactionId

groupId

Optional

integer

8335

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_GROUP_ID	NUMBER(15)	EagleML/warehouseTransaction/warehouseGLBalances/groupId
groupSequence

Optional

integer

8336

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_GROUP_SEQUENCE	NUMBER(4)	EagleML/warehouseTransaction/warehouseGLBalances/groupSequence
accountingDateId

Optional

integer

8337

		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

date

			LEDGERDBO	GL_DETAIL_POSTING	GLDP_ACCOUNT_START_DATE	DATE	EagleML/warehouseTransaction/warehouseGLBalances/accountStartDate
amountBase

Optional

decimal

8338

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_AMOUNT_BASE	NUMBER(15,2)	EagleML/warehouseTransaction/warehouseGLBalances/amountBase
amountLocal

Optional

decimal

8339

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_AMOUNT_LOCAL	NUMBER(15,2)	EagleML/warehouseTransaction/warehouseGLBalances/amountLocal
datePostedId

Optional

integer

8341

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_DATE_POSTED_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/datePostedId
datePosted

Optional

date

8342

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_DATE_POSTED	DATE	EagleML/warehouseTransaction/warehouseGLBalances/datePosted
debitOrCredit

Optional

string

8343

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_DEBIT_OR_CREDIT	VARCHAR2(1)	EagleML/warehouseTransaction/warehouseGLBalances/debitOrCredit
postedToGl

Optional

string

8344

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_POSTED_TO_GL	VARCHAR2(1)	EagleML/warehouseTransaction/warehouseGLBalances/postedToGl
postingSource

Optional

string

8345

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_POSTING_SOURCE	VARCHAR2(15)	EagleML/warehouseTransaction/warehouseGLBalances/postingSource
recurringTrans

Optional

string

8346

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_RECURRING_TRANS	VARCHAR2(1)	EagleML/warehouseTransaction/warehouseGLBalances/recurringTrans
timePosted

Optional

string

8347

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_TIME_POSTED	VARCHAR2(8)	EagleML/warehouseTransaction/warehouseGLBalances/timePosted
gldpType

Optional

string

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_TYPE	VARCHAR2(100)	EagleML/warehouseTransaction/warehouseGLBalances/gldpType
userFlag

Optional

string

8348

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_USER_FLAG	VARCHAR2(1)	EagleML/warehouseTransaction/warehouseGLBalances/userFlag
userId

Optional

string

8349

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_USER_ID	VARCHAR2(8)	EagleML/warehouseTransaction/warehouseGLBalances/userId
userText

Optional

string

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_USER_TEXT	VARCHAR2(20)	EagleML/warehouseTransaction/warehouseGLBalances/userText
tradeId

Optional

integer

8353

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_TRADE_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/tradeId
cashInt

Optional

integer

8354

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_CASH_INT	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/cashInt
glgrId

Optional

integer

8350

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_GLGR_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/glgrId
glacId

Optional

integer

8351

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_GLAC_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/glacId
glprId

Optional

integer

8352

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_GLPR_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/glprId
glagId

Optional

integer

8355

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_GLAG_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/glagId
glabId

Optional

integer

8356

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_GLAB_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/glabId
glcfId

Optional

integer

8357

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_GLCF_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/glcfId
transactionDateId

Optional

integer

8358

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_TRANSACTION_DATE_ID	NUMBER	EagleML/warehouseTransaction/warehouseGLBalances/transactionDateId
transactionDate

Optional

date

8359

LEDGERDBO

GL_DETAIL_POSTING

GLDP_TRANSACTION_DATE

DATE

EagleML/warehouseTransaction/warehouseGLBalances/transactionDate

shareClassOptionalstring34in_gldp_share_classLEDGERDBOGL_DETAIL_POSTINGGLDP_SHARE_CLASSVARCHAR2(50)EagleML/warehouseTransaction/warehouseGLBalances/shareClass

allocationId

Optional

integer

8360

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_ALLOCATION_ID	NUMBER(38)	EagleML/warehouseTransaction/warehouseGLBalances/allocationId
rollupGroup

Optional

string

8361

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_ROLLUP_GROUP	VARCHAR2(50)	EagleML/warehouseTransaction/warehouseGLBalances/rollupGroup
rollupIndicator

Optional

string

8362

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_ROLLUP_IND	VARCHAR2(1)	EagleML/warehouseTransaction/warehouseGLBalances/rollupIndicator
userAmount

Optional

decimal

8363

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_USER_AMOUNT	NUMBER(15,2)	EagleML/warehouseTransaction/warehouseTransaction/warehouseGLBalances/userAmount
moneyManager

Optional

string

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_MONEY_MANAGER	VARCHAR2(25)	EagleML/warehouseTransaction/warehouseGLBalances/moneyManager
custodian

Optional

string

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_CUSTODIAN	VARCHAR2(25)	EagleML/warehouseTransaction/warehouseGLBalances/custodian
sectorId

Optional

string

			LEDGERDBO	GL_DETAIL_POSTING	GLDP_SECTOR_ID	CHAR(8)	EagleML/warehouseTransaction/warehouseGLBalances/sectorId
coaName

Optional

string

		LEDGERDBO	GL_DETAIL_POSTING	COA_NAME	VARCHAR2(30)	EagleML/warehouseTransaction/warehouseGLBalances/coaName
custCoaAccountNumber

Optional

string

		LEDGERDBO	GL_DETAIL_POSTING	CUST_COA_ACCOUNT_NUMBER	CHAR(55)	EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountNumber
custCoaAccountDescription

Optional

string

			LEDGERDBO	GL_DETAIL_POSTING	CUST_COA_ACCOUNT_DESC	VARCHAR2(100)	EagleML/warehouseTransaction/warehouseGLBalances/custCoaAccountDescription
adjustIndicator

Optional

string

			LEDGERDBO	GL_DETAIL_POSTING	ADJUST_IND	CHAR(1)	EagleML/warehouseTransaction/warehouseGLBalances/adjustIndicator
adjustId

Optional

integer

			LEDGERDBO	GL_DETAIL_POSTING	ADJUST_ID	NUMBER(38)	EagleML/warehouseTransaction/warehouseGLBalances/adjustId
masterId

Optional

integer

		LEDGERDBO	GL_DETAIL_POSTING	MASTER_ID	NUMBER(38)	EagleML/warehouseTransaction/warehouseGLBalances/masterId
userAdjust

Optional

decimal

		LEDGERDBO	GL_DETAIL_POSTING	USER_ADJUST	NUMBER(28,12)	EagleML/warehouseTransaction/warehouseGLBalances/userAdjust
taxLineCode

Optional

string

8364

	LEDGERDBO	GL_DETAIL_POSTING	GLDP_TAX_LINE_CODE	VARCHAR2(25)	EagleML/warehouseTransaction/warehouseGLBalances/taxLineCode
procSecType

Optional

string

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_PROC_SEC_TYPE	VARCHAR2(25)	EagleML/warehouseTransaction/warehouseGLBalances/procSecType
aggrTaxCode

Optional

string

LEDGERDBO

GL_DETAIL_POSTING

AGGR_TAX_CODE

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseGLBalances/aggrTaxCode

ledgerAccountOptionalstring1288in_gldp_ledger_acctLEDGERDBOGL_DETAIL_POSTINGGLDP_LEDGER_ACCTCHAR(55)EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccountledgerAccountDescriptionOptionalstring1290in_gldp_ledger_acct_descLEDGERDBOGL_DETAIL_POSTINGGLDP_LEDGER_ACCT_DESCVARCHAR2(100)EagleML/warehouseTransaction/warehouseGLBalances/ledgerAccountDescriptionbalanceOptionaldecimal903in_gldp_balanceLEDGERDBOGL_DETAIL_POSTINGGLDP_BALANCENUMBER(38,6)EagleML/warehouseTransaction/warehouseGLBalances/balanceassetLiabCodeOptionalstring12057in_gldp_asset_liab_codeLEDGERDBOGL_DETAIL_POSTINGGLDP_ASSET_LIAB_CODEVARCHAR2(12)EagleML/warehouseTransaction/warehouseGLBalances/assetLiabCodeassetLiabDescriptionOptionalstring12058in_gldp_asset_liab_descLEDGERDBOGL_DETAIL_POSTINGGLDP_ASSET_LIAB_DESCVARCHAR2(10)EagleML/warehouseTransaction/warehouseGLBalances/assetLiabDescriptionstmtCatOptionalstring1291in_gldp_stmt_catLEDGERDBOGL_DETAIL_POSTINGGLDP_STMT_CATVARCHAR2(100)EagleML/warehouseTransaction/warehouseGLBalances/stmtCatfromFundClassOptionalstring LEDGERDBOGL_DETAIL_POSTINGGLDP_FROM_FUND_CLASSVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/fromFundClasscontraClassOptionalstring in_cls_evt_idLEDGERDBOGL_DETAIL_POSTINGGLDP_CONTRA_CLASSVARCHAR2(25)EagleML/warehouseTransaction/warehouseGLBalances/contraClass

beginningBalanceBase

Optional

integer

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_BEGINNING_BALANCE_BASE	NUMBER(38,9) default 0	EagleML/warehouseTransaction/warehouseGLBalances/beginningBalanceBase
endingBalanceBase

Optional

integer

		LEDGERDBO	GL_DETAIL_POSTING	GLDP_ENDING_BALANCE_BASE	NUMBER(38,9) default 0	EagleML/warehouseTransaction/warehouseGLBalances/endingBalanceBase
endingBalanceBaseTemp

Optional

integer

		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

Versions Compared

Old Version 4

New Version 5

Key