This object contains the transactionId element which is not listed in the table below. Please refer to this page for more details on transactionId.
| Element | Optional/ Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||
| ||||||||||||||
Element | Optional/ Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
| Entity Common Id Model | EagleML/accountingTransaction/generalLedgerActivity/portfolio/ | |||||||||||||
| ledgerPost | Optional | LedgerPost - complex type (see extra table below) | EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost | |||||||||||
| ||||||||||||||
Element | Optional/ Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
| 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/ | |||||||||||
| ||||||||||||||
Element | Optional/ Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
| 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/ | |||||||||||
| ||||||||||||||
Element | Optional/ Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
| 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 | ||||||
| ||||||||||||||
Element | Optional/ Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
| 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 | ||||||
...