Accounting GL Activity Data Map Table
- Natalie Gesin (Deactivated)
- Alexey Trubitsyn
- Dmitry Donosiyan (Unlicensed)
Owned by Natalie Gesin (Deactivated)
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 | |||||
Portfolio Data Map Table | ||||||||
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 | |||||
Ledger Post Data Map Table | ||||||||
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/ | |||||
Ledger Account Data Map Table | ||||||||
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/ | |||||
Ledger Log Data Map Table | ||||||||
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 |
Ledger Notes Data Map Table | ||||||||
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 |