Cash Account Data Map Table

Element

Required  Inbound Acct Validation

Required Inbound Data
Mgt

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Required  Inbound Acct Validation

Required Inbound Data
Mgt

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

objectType

Required

Required

 

not stored in DB

EagleML/entityTransaction/cashAccount/objectType

objectId

 

 

 

not stored in DB

EagleML/entityTransaction/cashAccount/objectId

objectDescription

 

 

 

not stored in DB

EagleML/entityTransaction/cashAccount/objectDescription

customElements

not recommended 

CustomElements

 

 

 

reserved for customizations

EagleML/entityTransaction/cashAccount/customElements

updateSource

 

 

string

944

in_update_source

S

RULESDBO

CASH_ACCOUNT

UPDATE_SOURCE

VARCHAR2(255)

EagleML/entityTransaction/cashAccount/updateSource

Asset Identifiers Model

EagleML/entityTransaction/cashAccount/

cashAccountBankCode

Required

Required

string

1176

 

S

 

 

 

 

EagleML/entityTransaction/cashAccount/cashAccountBankCode

cashAccountBankName

Required

Required

string

1177

 

S

 

 

 

 

EagleML/entityTransaction/cashAccount/cashAccountBankName

cashAccountName

Required

Required

string

11696

in_cash_acct_name

S

RULESDBO

CASH_ACCOUNT

CASH_ACCT_NAME

VARCHAR2(50)

EagleML/entityTransaction/cashAccount/cashAccountName

cashAccountNumber

Required

Required

string

11697

in_cash_acct

S

RULESDBO

CASH_ACCOUNT

CASH_ACCT

VARCHAR2(20)

EagleML/entityTransaction/cashAccount/cashAccountNumber

settlementCurrency

Required

Required

string

63

in_settle_currency

S

RULESDBO

CASH_ACCOUNT

SETTLE_CURRENCY

VARCHAR2(3)

EagleML/entityTransaction/cashAccount/settlementCurrency

settleToleranceTrade

 

 

decimal

528

in_settle_tolerance_trade

N

RULESDBO

CASH_ACCOUNT

SETTLE_TOLERANCE_TRADE

NUMBER(38,12)

EagleML/entityTransaction/cashAccount/settleToleranceTrade

settleToleranceIncome

 

 

decimal

527

in_settle_tolerance_income

N

RULESDBO

CASH_ACCOUNT

SETTLE_TOLERANCE_INCOME

NUMBER(38,12)

EagleML/entityTransaction/cashAccount/settleToleranceIncome

settlePercentToleranceTrd

 

 

decimal

770

in_setl_prcnt_tolerance_trd

N

RULESDBO

CASH_ACCOUNT

SETL_PRCNT_TOLERANCE_TRD

NUMBER(38,12)

EagleML/entityTransaction/cashAccount/settlePercentToleranceTrd

settlePercentToleranceInc

 

 

decimal

769

in_setl_prcnt_tolerance_inc

N

RULESDBO

CASH_ACCOUNT

SETL_PRCNT_TOLERANCE_INC

NUMBER(38,12)

EagleML/entityTransaction/cashAccount/settlePercentToleranceInc

settleDateTolerance

 

 

decimal

9699

in_settle_date_tolerance

N

RULESDBO

CASH_ACCOUNT

SETTLE_DATE_TOLERANCE

NUMBER(38)

EagleML/entityTransaction/cashAccount/settleDateTolerance

restricted

 

 

string

12861

in_restricted

S

RULESDBO

CASH_ACCOUNT

RESTRICTED

VARCHAR2(1)

EagleML/entityTransaction/cashAccount/restricted

accrueInterest

 

 

YesNoOptionEnum

12862

in_accrue_interest

S

RULESDBO

CASH_ACCOUNT

ACCRUE_INTEREST

VARCHAR2(1)

EagleML/entityTransaction/cashAccount/accrueInterest

accrualStartDate

Required - if accrueInterest = Y

Required - if accrueInterest = Y

date

2857

in_accrual_start_date

S

RULESDBO

CASH_ACCOUNT

ACCRUAL_START_DATE

DATE

EagleML/entityTransaction/cashAccount/accrualStartDate

cashSweep

 

 

YesNoOptionEnum

4515

in_cash_sweep_flg

S

RULESDBO

CASH_ACCOUNT

CASH_SWEEP

VARCHAR2(1)

EagleML/entityTransaction/cashAccount/cashSweep

minimumBalance

 

 

decimal

16726

in_cash_sweep_min_bal

N

RULESDBO

CASH_ACCOUNT

CASH_SWEEP_MIN_BAL

NUMBER(38,12)

EagleML/entityTransaction/cashAccount/minimumBalance

Â