Accounting Rejection Data Map Table

Element

Required/
Optional

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Required/
Optional

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

objectType

 

ObjectTypeEnum

 

not stored in DB

EagleML/accountingTransaction/accountingRejection/objectType

objectId

 

ObjectId

 

not stored in DB

EagleML/accountingTransaction/accountingRejection/objectId

objectDescription

 

FeedTypeEnum

 

not stored in DB

EagleML/accountingTransaction/accountingRejection/objectDescription

updateTimestamp

 

dateTime

 

 

 

 

 

EagleML/accountingTransaction/accountingRejection/updateTimestamp

updateSource

 

string

944

ESTAR

ESTAR_EVENT_REJECTION

SRC_INTFC_INST

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/updateSource

reportType

 

string

 

not stored in DB

EagleML/accountingTransaction/accountingRejection/reportType

sourceName

 

string

1102

PACE_MASTERDBO

INTERFACES

SHORT_DESC

 

EagleML/accountingTransaction/accountingRejection/sourceName

Entity Common Id Model

EagleML/accountingTransaction/accountingRejection/

Entity Properties Model

EagleML/accountingTransaction/accountingRejection/

Asset Identifiers Model

EagleML/accountingTransaction/accountingRejection/

Asset Properties Model

EagleML/accountingTransaction/accountingRejection/

effectiveDate

 

date

 

ESTAR

ESTAR_EVENT_REJECTION

EFFECTIVE_DATE

DATE

EagleML/accountingTransaction/accountingRejection/effectiveDate

accountingDate

 

date

36

ESTAR

ESTAR_EVENT_REJECTION

ACCOUNTING_DATE

DATE

EagleML/accountingTransaction/accountingRejection/accountingDate

accountingBasis

 

string

21

ESTAR

ESTAR_EVENT_REJECTION

ACCT_BASIS

VARCHAR2(5)

EagleML/accountingTransaction/accountingRejection/accountingBasis

businessGroupId

 

integer

 

ESTAR

ESTAR_EVENT_REJECTION

BUSINESS_GROUP_ID

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/businessGroupId

batchEventId

 

string

701

ESTAR

ESTAR_EVENT_REJECTION

BATCH_EVENT_ID

VARCHAR2(55)

EagleML/accountingTransaction/accountingRejection/batchEventId

eventId

 

string

25

ESTAR

ESTAR_EVENT_REJECTION

EVT_ID

VARCHAR2(55)

EagleML/accountingTransaction/accountingRejection/eventId

exceptionCode

 

string

607

ESTAR

ESTAR_EVENT_REJECTION

EXCEPTION_CODE

VARCHAR2(20)

EagleML/accountingTransaction/accountingRejection/exceptionCode

assignedGroupId

 

integer

673

ESTAR

ESTAR_EVENT_REJECTION

ASSIGNED_GROUP_ID

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/assignedGroupId

assignedShared

 

string

 

ESTAR

ESTAR_EVENT_REJECTION

ASSIGNED_SHARED

CHAR(1)

EagleML/accountingTransaction/accountingRejection/assignedShared

assignedUserId

 

string

 

ESTAR

ESTAR_EVENT_REJECTION

ASSIGNED_USER_ID

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/assignedUserId

autoAssignVersion

 

decimal

 

ESTAR

ESTAR_EVENT_REJECTION

AUTO_ASSIGN_VER

NUMBER

EagleML/accountingTransaction/accountingRejection/autoAssignVersion

assigningUserId

 

string

672

ESTAR

ESTAR_EVENT_REJECTION

ASSIGNING_USER

VARCHAR2(32)

EagleML/accountingTransaction/accountingRejection/assigningUserId

assigningDate

 

date

745

ESTAR

ESTAR_EVENT_REJECTION

ASSIGNING_DATE

DATE

EagleML/accountingTransaction/accountingRejection/assigningDate

messageType

 

string

1

ESTAR

ESTAR_EVENT_REJECTION

MESSAGE_TYPE

VARCHAR2(25)

EagleML/accountingTransaction/accountingRejection/messageType

messageSubType

 

string

55

ESTAR

ESTAR_EVENT_REJECTION

MESSAGE_SUBTYPE

VARCHAR2(55)

EagleML/accountingTransaction/accountingRejection/messageSubType

postingDate

 

date

 

ESTAR

ESTAR_EVENT_REJECTION

POSTING_DATE

DATE

EagleML/accountingTransaction/accountingRejection/postingDate

rejectionUserId

 

string

832

ESTAR

ESTAR_EVENT_REJECTION

REJECTION_USER

VARCHAR2(32)

EagleML/accountingTransaction/accountingRejection/rejectionUserId

rejectionDate

 

date

835

ESTAR

ESTAR_EVENT_REJECTION

REJECTION_DATE

DATE

EagleML/accountingTransaction/accountingRejection/rejectionDate

rejectionStatus

 

integer

833

ESTAR

ESTAR_EVENT_REJECTION

REJECTION_STATUS

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/rejectionStatus

rejectionSource

 

string

9403

ESTAR

ESTAR_EVENT_REJECTION

REJECTION_SOURCE

VARCHAR2(50)

EagleML/accountingTransaction/accountingRejection/rejectionSource

rejectionCategory

 

string

10754

ESTAR

ESTAR_EVENT_REJECTION

REJECTION_CATEGORY

VARCHAR2(15)

EagleML/accountingTransaction/accountingRejection/rejectionCategory

reprocessCount

 

integer

10086

ESTAR

ESTAR_EVENT_REJECTION

REPROC_COUNT

NUMBER

EagleML/accountingTransaction/accountingRejection/reprocessCount

reprocessDate

 

date

743

ESTAR

ESTAR_EVENT_REJECTION

REPROC_DATE

DATE

EagleML/accountingTransaction/accountingRejection/reprocessDate

reprocessingUserId

 

string

742

ESTAR

ESTAR_EVENT_REJECTION

REPROC_USER

VARCHAR2(32)

EagleML/accountingTransaction/accountingRejection/reprocessingUserId

shareClass

 

string

34

ESTAR

ESTAR_EVENT_REJECTION

CLASS

VARCHAR2(10)

EagleML/accountingTransaction/accountingRejection/shareClass

ccErrorCode

 

string

5290

ESTAR

ESTAR_EVENT_REJECTION

CC_ERROR_CODE

VARCHAR2(20)

EagleML/accountingTransaction/accountingRejection/ccErrorCode

emailStatus

 

string

5257

ESTAR

ESTAR_EVENT_REJECTION

EMAIL_STATUS

CHAR(1)

EagleML/accountingTransaction/accountingRejection/emailStatus

lockUserId

 

string

 

ESTAR

ESTAR_EVENT_REJECTION

LOCK_USER

VARCHAR2(255)

EagleML/accountingTransaction/accountingRejection/lockUserId

lockDate

 

date

 

ESTAR

ESTAR_EVENT_REJECTION

LOCK_DATETIME

DATE

EagleML/accountingTransaction/accountingRejection/lockDate

reopenDate

 

date

 

ESTAR

ESTAR_EVENT_REJECTION

REOPEN_DATE

DATE

EagleML/accountingTransaction/accountingRejection/reopenDate

reopenUserid

 

string

935

ESTAR

ESTAR_EVENT_REJECTION

REOPEN_USER

VARCHAR2(32)

EagleML/accountingTransaction/accountingRejection/reopenUserid

streamId

 

integer

 

ESTAR

ESTAR_EVENT_REJECTION

STREAM_ID

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/streamId

streamName

 

string

 

msgcenter_dbo

MSG_STREAMS

MSG_STREAM_TITLE

NVARCHAR2(255)

EagleML/accountingTransaction/accountingRejection/streamName

eagleDetailId

 

integer

 

ESTAR

ESTAR_EVENT_REJECTION

MSG_DETAIL_ID

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/eagleDetailId

eagleStatId

 

integer

 

ESTAR

ESTAR_EVENT_REJECTION

MSG_STAT_ID

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/eagleStatId

severityLevel

 

integer

 

ESTAR

ESTAR_EVENT_REJECTION

SEVERITY_LEVEL

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/severityLevel

errorCode

 

integer

998

ESTAR

ESTAR_EVENT_REJECTION

ERROR_CODE

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/errorCode

errorDescription

 

string

834

ESTAR

ESTAR_REJECTED_MESSAGE

ERROR_DESC

VARCHAR2(1024)

EagleML/accountingTransaction/accountingRejection/errorDescription

messageString

 

string

1618

ESTAR

ESTAR_REJECTED_MESSAGE

MESSAGE_STRING

VARCHAR2(4000)

EagleML/accountingTransaction/accountingRejection/messageString

messageComment

 

string

2848

ESTAR

ESTAR_REJECTED_MESSAGE

MSG_COMMENT

NVARCHAR2(2000)

EagleML/accountingTransaction/accountingRejection/messageComment

linkInstance

 

string

9129

ESTAR

ESTAR_EVENT_REJECTION

LINK_INSTANCE

VARCHAR2(255)

EagleML/accountingTransaction/accountingRejection/linkInstance

rejectionInstance

 

integer

 

ESTAR

ESTAR_EVENT_REJECTION

REJECTION_INSTANCE

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/rejectionInstance

loopbackInstance

 

integer

4267

ESTAR

ESTAR_EVENT_REJECTION

LOOPBACK_INSTANCE

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/loopbackInstance

distributionInstance

 

integer

754

ESTAR

ESTAR_EVENT_REJECTION

DISTRIBUTION_INSTANCE

NUMBER

EagleML/accountingTransaction/accountingRejection/distributionInstance

engineInstance

 

integer

10167

ESTAR

ESTAR_EVENT_REJECTION

ENGINE_INSTANCE

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/engineInstance

serviceInstance

 

integer

671

ESTAR

ESTAR_EVENT_REJECTION

SERVICE_INSTANCE

NUMBER(38,0)

EagleML/accountingTransaction/accountingRejection/serviceInstance

Â