Accounting GL Activity Data Map Table

objectType

Optional

ObjectTypeEnum

-

not stored in DB

EagleML/accountingTransaction/generalLedgerActivity/objectType

objectId

Optional

ObjectId

-

not stored in DB

EagleML/accountingTransaction/generalLedgerActivity/objectId

objectDescription

Optional

FeedTypeEnum

-

not stored in DB

EagleML/accountingTransaction/generalLedgerActivity/objectDescription

updateTimestamp

Optional

dateTime

-

not stored in DB

EagleML/accountingTransaction/generalLedgerActivity/updateTimestamp

customElements

Not recommended

CustomElements

CustomElements - complex type

EagleML/accountingTransaction/generalLedgerActivity/customElements

updateSource

Required

string

944

ESTAR

ESTAR_LEDGER_ACCOUNT

UPDATE_SOURCE

CHAR(255)

EagleML/accountingTransaction/generalLedgerActivity/updateSource

portfolio

Optional

Portfolio - complex type (see extra table below)

EagleML/accountingTransaction/generalLedgerActivity/portfolio

Portfolio Data Map Table

Entity Common Id Model

EagleML/accountingTransaction/generalLedgerActivity/portfolio/

ledgerPost

Optional

LedgerPost - complex type (see extra table below)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost

Ledger Post Data Map Table

transactionId

Optional

string

25

ESTAR

ESTAR_LEDGER_POST

EVENT_ID

VARCHAR2(55)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/transactionId

postDate

Optional

date

30

ESTAR

ESTAR_LEDGER_POST

POST_DT

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/postDate

accountingDate

Optional

date

36

ESTAR

ESTAR_LEDGER_POST

ACCT_DT

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/accountingDate

effectiveDate

Optional

date

ESTAR

ESTAR_LEDGER_POST

EFFECTIVE_DT

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/effectiveDate

monthEndDate

Optional

date

4733

ESTAR

ESTAR_LEDGER_POST

MONTH_END_DATE

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/monthEndDate

quantity

Optional

decimal

40

ESTAR

ESTAR_LEDGER_POST

QTY

NUMBER(38,6)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/quantity

quantityType

Optional

string

12

ESTAR

ESTAR_LEDGER_POST

QTY_TYPE

VARCHAR2(25)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/quantityType

transactionType

Optional

string

55

ESTAR

ESTAR_LEDGER_POST

MESSAGE_TYPE

VARCHAR2(25)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/transactionType

accountingCategory

Optional

string

20

ESTAR

ESTAR_LEDGER_POST

ACCT_CATEGORY

CHAR(1)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/accountingCategory

noteId

Optional

integer

1307

ESTAR

ESTAR_LEDGER_POST

NOTE_ID

NUMBER(28)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/noteId

postId

Optional

integer

1306

ESTAR

ESTAR_LEDGER_POST

POST_ID

NUMBER(28)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/postId

accountingPeriodSequence

Optional

integer

3196

ESTAR

ESTAR_LEDGER_POST

ACCT_PERIOD_SEQ

NUMBER(28)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/accountingPeriodSequence

ledgerAccount

Optional

LedgerAccount - complex type (see extra table below)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/

ledgerNotes

Optional

LedgerNotesModel - complex type (see extra table below)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerNotes/

Ledger Account Data Map Table

accountId

Optional

string

1983

ESTAR

ESTAR_LEDGER_ACCOUNT

ACCOUNT_ID

NUMBER(28)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/accountId

accountingBasis

Optional

string

21

ESTAR

ESTAR_LEDGER_ACCOUNT

ACCT_BASIS

VARCHAR2(5)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/accountingBasis

baseCurrency

Optional

string

86

ESTAR

ESTAR_LEDGER_ACCOUNT

BASE_CURRENCY

VARCHAR2(3)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/baseCurrency

localCurrency

Optional

string

ESTAR

ESTAR_LEDGER_ACCOUNT

LOCAL_CURRENCY

VARCHAR2(3)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/localCurrency

class

Optional

string

34

ESTAR

ESTAR_LEDGER_ACCOUNT

CLASS

VARCHAR2(10)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/class

ledgerAccountNumber

Optional

string

51

ESTAR

ESTAR_LEDGER_ACCOUNT

LEDGER_ACCT

CHAR(55)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ledgerAccountNumber

longShortIndicator

Optional

string

151

ESTAR

ESTAR_LEDGER_ACCOUNT

OPEN_EVT_ID

VARCHAR2(25)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/longShortIndicator

originalOffsetAccountId

Optional

integer

ESTAR

ESTAR_LEDGER_ACCOUNT

ORIG_OFFSET_ACCOUNT_ID

NUMBER(38)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/originalOffsetAccountId

lastBalzeroDate

Optional

date

ESTAR

ESTAR_LEDGER_ACCOUNT

LAST_BALZERO_DATE

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/lastBalzeroDate

closeInd

Optional

string

182

ESTAR

ESTAR_LEDGER_ACCOUNT

CLS_EVT_ID

VARCHAR2(25)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/closeInd

customAccount

Optional

string

1623

ESTAR

ESTAR_LEDGER_ACCT_EXT

CUST_ACCOUNT

CHAR(55)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/customAccount

customAccountDescription

Optional

string

1624

ESTAR

ESTAR_LEDGER_ACCT_EXT

CUST_ACCOUNT_DESC

VARCHAR2(100)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/customAccountDescription

gLSubAccount

Optional

string

1289

ESTAR

ESTAR_LEDGER_ACCT_EXT

GL_SUB_ACCOUNT

CHAR(12)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/gLSubAccount

granEffectiveDate

Optional

date

ESTAR

ESTAR_LEDGER_ACCT_EXT

GRAN_EFFECTIVE_DATE

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/granEffectiveDate

inactiveDate

Optional

date

2816

ESTAR

ESTAR_LEDGER_ACCT_EXT

INACTIVE_DATE

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/inactiveDate

inactiveFlag

Optional

string

ESTAR

ESTAR_LEDGER_ACCT_EXT

INACTIVE_FLAG

VARCHAR2(1)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/inactiveFlag

ledgerGranRule

Optional

integer

8933

ESTAR

ESTAR_LEDGER_ACCT_EXT

LEDGER_GRAN_RULE

NUMBER(38)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ledgerGranRule

postInstance

Optional

integer

8942

ESTAR

ESTAR_LEDGER_ACCT_EXT

PST_INSTANCE

NUMBER(38)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/postInstance

securityGrouping

Optional

integer

9095

ESTAR

ESTAR_LEDGER_ACCT_EXT

SECURITY_GROUPING

NUMBER(38)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/securityGrouping

Asset Identifiers Model

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/

assetGroup

Optional

string

ESTAR

ESTAR_LEDGER_ACCOUNT

ASSET_GRP

VARCHAR2(20)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/assetGroup

ledgerLog

Optional

LedgerLog - complex type (see extra table below)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ledgerLog/

Ledger Log Data Map Table

logAcctDate

Optional

date

-

ESTAR

ESTAR_LEDGER_LOG

ACCT_DT

DATE

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ledgerLog/logAcctDate

amount

Optional

decimal

903

ESTAR

ESTAR_LEDGER_LOG

AMOUNT

NUMBER(38,6)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ledgerLog/amount

debitCredit

Optional

string

902

ESTAR

ESTAR_LEDGER_LOG

DEBIT_CREDIT

VARCHAR2(15)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ledgerLog/debitCredit

logId

Optional

integer

-

ESTAR

ESTAR_LEDGER_LOG

LOG_ID

NUMBER(28)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ledgerLog/logId

Ledger Notes Data Map Table

notes

Optional

string

1308

ESTAR

ESTAR_LEDGER_NOTES

NOTES

VARCHAR2(255)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerNotes/notes

notesAlloc

Optional

string

-

ESTAR

ESTAR_LEDGER_NOTES

NOTES_ALLOC

VARCHAR2(255)

EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerNotes/notesAlloc