Entity Accounting Periods Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Required by the XSD | Required by Eagle Rules | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
|---|---|---|---|---|---|---|---|---|---|---|---|
objectType |
|
| objectType |
|
|
| not stored in DB |
| EagleML/entityTransaction/entityAccountingPeriods/objectType | ||
objectId |
|
| objectId |
|
|
| not stored in DB |
| EagleML/entityTransaction/entityAccountingPeriods/objectId | ||
objectDescription |
|
| objectDescription |
|
|
| not stored in DB |
| EagleML/entityTransaction/entityAccountingPeriods/objectDescription | ||
updateTimestamp |
|
| dateTime |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | UPDATE_DATE | DATE | EagleML/entityTransaction/entityAccountingPeriods/updateTimestamp |
customElements | not recommended |
| CustomElements |
|
|
| reserved for customizations | EagleML/entityTransaction/entityAccountingPeriods/customElements | |||
updateSource |
|
| string | 944 | in_upd_user | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | UPDATE_SOURCE | VARCHAR2(32) | EagleML/entityTransaction/entityAccountingPeriods/updateSource |
entityId |
|
| string | 5 | in_entity_id | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | PORTFOLIO_ACCT | CHAR(8) | EagleML/entityTransaction/entityAccountingPeriods/entityId |
entityName |
|
| string |
|
|
| RULESDBO | ENTITY | ENTITY_NAME | CHAR(30) | EagleML/entityTransaction/entityAccountingPeriods/entityName |
entityType |
|
| string |
|
|
| RULESDBO | ENTITY | ENTITY_TYPE | CHAR(4) | EagleML/entityTransaction/entityAccountingPeriods/entityType |
xrefAccountId |
|
| string |
|
|
| not stored in DB |
| EagleML/entityTransaction/entityAccountingPeriods/xrefAccountId | ||
xrefAccountIdType |
|
| string |
|
|
| not stored in DB |
| EagleML/entityTransaction/entityAccountingPeriods/xrefAccountIdType | ||
xrefClassCode |
|
| string |
|
|
| not stored in DB |
| EagleML/entityTransaction/entityAccountingPeriods/xrefClassCode | ||
entityXrefs |
|
| EntityXrefIdentifiers |
|
|
|
| EagleML/entityTransaction/entityAccountingPeriods/entityXrefs/ | |||
entityResolutionOption |
|
| normalizedString |
|
|
| not stored in DB, used in resolution logic |
| EagleML/entityTransaction/entityAccountingPeriods/entityResolutionOption | ||
entityBattingOrder |
|
| normalizedString |
|
|
| not stored in DB, used in resolution logic |
| EagleML/entityTransaction/entityAccountingPeriods/entityBattingOrder | ||
autoAddBasis |
|
| YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/entityTransaction/entityAccountingPeriods/autoAddBasis | ||
initialFlag |
|
| YesNoOptionEnum | 4631 | in_initial_flag | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | INITIAL_FLAG | CHAR(1) | EagleML/entityTransaction/entityAccountingPeriods/initialFlag |
yearEndFlag |
|
| YesNoOptionEnum | 929 | in_year_end_flag | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | YEAR_END_FLAG | CHAR(1) | EagleML/entityTransaction/entityAccountingPeriods/yearEndFlag |
closeoutFlag |
|
| YesNoOptionEnum | 795 | in_closeout_flag | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | CLOSEOUT_FLAG | CHAR(1) | EagleML/entityTransaction/entityAccountingPeriods/closeoutFlag |
closedFlag |
|
| YesNoOptionEnum | 930 | in_closed_flag | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | CLOSED_FLAG | CHAR(1) | EagleML/entityTransaction/entityAccountingPeriods/closedFlag |
accountingBasis |
| Y | string | 21 | in_basis | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | ACCT_BASIS | VARCHAR2(5) | EagleML/entityTransaction/entityAccountingPeriods/accountingBasis |
startDate |
| Y | date | 920 | in_start_dt | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | START_DT | DATE | EagleML/entityTransaction/entityAccountingPeriods/startDate |
endDate |
| Y | date | 921 | in_end_dt | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | END_DT | DATE | EagleML/entityTransaction/entityAccountingPeriods/endDate |
closedDate |
|
| date | 933 | in_closed_date | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | CLOSED_DT | DATE | EagleML/entityTransaction/entityAccountingPeriods/closedDate |
reopenUserid |
|
| string | 935 | in_reopen_user | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | REOPEN_USER_ID | VARCHAR2(32) | EagleML/entityTransaction/entityAccountingPeriods/reopenUserid |
closeUserid |
|
| string | 934 | in_close_user_id | S | ESTAR | ESTAR_ACCOUNTING_PERIODS | CLOSE_USER_ID | VARCHAR2(32) | EagleML/entityTransaction/entityAccountingPeriods/closeUserid |
baseCurrency |
|
| CurrencyCode |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | BASE_CURRENCY | VARCHAR2(3) | EagleML/entityTransaction/entityAccountingPeriods/baseCurrency |
reopenedDate |
|
| date |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | REOPENED_DT | DATE | EagleML/entityTransaction/entityAccountingPeriods/reopenedDate |
transClosedFlag |
|
| YesNoOptionEnum |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | TRANS_CLOSED_FLAG | CHAR(1) | EagleML/entityTransaction/entityAccountingPeriods/transClosedFlag |
transClosedDate |
|
| date |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | TRANS_CLOSED_DT | DATE | EagleML/entityTransaction/entityAccountingPeriods/transClosedDate |
transReopenUserid |
|
| string |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | TRANS_REOPEN_USER_ID | VARCHAR2(32) | EagleML/entityTransaction/entityAccountingPeriods/transReopenUserid |
transCloseUserid |
|
| string |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | TRANS_CLOSE_USER_ID | VARCHAR2(32) | EagleML/entityTransaction/entityAccountingPeriods/transCloseUserid |
transReopenendDate |
|
| date |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | TRANS_REOPENED_DT | DATE | EagleML/entityTransaction/entityAccountingPeriods/transReopenendDate |
monthEndDate |
|
| date |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | MONTH_END_DATE | DATE | EagleML/entityTransaction/entityAccountingPeriods/monthEndDate |
monthEndStatus |
|
| YesNoOptionEnum |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | MONTH_END_STATUS | CHAR(1) | EagleML/entityTransaction/entityAccountingPeriods/monthEndStatus |
acctPeriodSeq |
|
| string |
|
|
| ESTAR | ESTAR_ACCOUNTING_PERIODS | ACCT_PERIOD_SEQ | NUMBER(28) | EagleML/entityTransaction/entityAccountingPeriods/acctPeriodSeq |