...
...
...
...
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 | EagleML/accountingTransaction/generalLedgerActivity/portfolio | ||||||||||||
| ||||||||||||||
Element | Optional/ Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
EagleML/accountingTransaction/generalLedgerActivity/portfolio/ | ||||||||||||||
ledgerPost | Optional | 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 | EagleML/accountingTransaction/generalLedgerActivity/portfolio/ledgerPost/ledgerAccount/ | ||||||||||||
ledgerNotes | Optional | 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 | ||||||
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 | 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 | ||||||