Custom Ledger Account Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 25, 2024 by Kinga Huszno
1 min read

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

objectType

 

ObjectTypeEnum

 

not stored in DB

 

EagleML/accountingTransaction/customLedgerAccount/objectType

objectId

 

objectId

 

not stored in DB

 

EagleML/accountingTransaction/customLedgerAccount/objectId

objectDescription

 

FeedTypeEnum

 

not stored in DB

 

EagleML/accountingTransaction/customLedgerAccount/objectDescription

updateTimestamp

 

dateTime

 

not stored in DB

 

EagleML/accountingTransaction/customLedgerAccount/updateTimestamp

customElements

Not recommended

CustomElements - reserved for customization

EagleML/accountingTransaction/customLedgerAccount/customElements

updateSource

 

string

944

RULESDBO

CUST_CHART

UPDATE_SOURCE

VARCHAR2(12)

EagleML/accountingTransaction/customLedgerAccount/updateSource

gLAccount

Requried

string

1827

RULESDBO

CUST_CHART

GL_ACCOUNT

CHAR(55)

EagleML/accountingTransaction/customLedgerAccount/gLAccount

customAccount

 

string

1623

RULESDBO

CUST_CHART

CUST_ACCOUNT

CHAR(55)

EagleML/accountingTransaction/customLedgerAccount/customAccount

customAccountDescription

 

string

1624

RULESDBO

CUST_CHART

CUST_ACCOUNT_DESC

VARCHAR2(100)

EagleML/accountingTransaction/customLedgerAccount/customAccountDescription

gLSubAccount

 

string

1289

RULESDBO

CUST_CHART

GL_SUB_ACCOUNT

CHAR(12)

EagleML/accountingTransaction/customLedgerAccount/gLSubAccount

systemName

 

string

1163

RULESDBO

CUST_CHART

ENTITY_ID

CHAR(8)

EagleML/accountingTransaction/customLedgerAccount/systemName

chartOfAccountName

 

string

1641

RULESDBO

CUST_CHART

CUST_COA_NAME

VARCHAR2(30)

EagleML/accountingTransaction/customLedgerAccount/chartOfAccountName

customSubAcct

 

string

1748

RULESDBO

CUST_CHART

CUST_ACCT_SUB_ACCT

VARCHAR2(12)

EagleML/accountingTransaction/customLedgerAccount/customSubAcct

customAcctSubAcct

 

string

1748

RULESDBO

CUST_CHART

CUST_ACCT_SUB_ACCT

VARCHAR2(12)

EagleML/accountingTransaction/customLedgerAccount/customAcctSubAcct

restricted

 

string

7100

RULESDBO

CUST_CHART

RESTRICTED

VARCHAR2(1)

EagleML/accountingTransaction/customLedgerAccount/restricted

gLAccountDescription

 

string

1290

RULESDBO

CHART_OF_ACCTS

GL_ACCOUNT_DESC

CHAR(100)

EagleML/accountingTransaction/customLedgerAccount/gLAccountDescription

gLSubAccountDescription

 

string

1291

RULESDBO

CHART_OF_ACCTS

GL_SUB_ACCOUNT_DESC

CHAR(100)

EagleML/accountingTransaction/customLedgerAccount/gLSubAccountDescription

gLPostType

 

string

1292

RULESDBO

CHART_OF_ACCTS

GL_POST_TYPE

CHAR(12)

EagleML/accountingTransaction/customLedgerAccount/gLPostType

gLPostTypeDescruption

 

string

1293

RULESDBO

CHART_OF_ACCTS

GL_POST_TYPE_DESC

CHAR(100)

EagleML/accountingTransaction/customLedgerAccount/gLPostTypeDescruption

Â