Entity Accounting Structure Level

DescriptionAn accounting category that further groups accounts within a particular accounting structure. For example, Accounting Category #91207 ('Other Expenses') will be included in Accounting Structure #87453 ('Chart Of Accounts for Subsidiary Xyz').

Sample Chart of Account Hierarchy:
Corporate
--Total Assets
----Current Assets
------Cash and Equivalents
--------Cash
--------Payroll Cash Account
--------Short-Term Investments
------Accounts Receivable
------Inventory
----Fixed Assets
------Plant and Equipment
------Furniture
--Total Liabilities

Attributes
Accounting CategoryAccounting Category
Accounting Category DescrAccounting Category Descr
Accounting ClassAccounting Class

Relationship
Accounting Structure Item_Accounting Structure_FKAccounting Structure Item_Accounting Structure_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Accounting Category
DescriptionAccounting Category represents a standard category definition of accounting topics. 
The entire set of Accounting Categories (established by the organization) establishes the universe of topics about which accounting information will be monitored; 
for example, Ledger Accounting Category could have sub-categories such as Interest Income, Salary Expenses and Employee Benefit Expense. Managerial Accounting Categories could have sub-categories such as Hours Worked By Salaried Employees and Customer Accounting Categories could have sub-categories such as Demand Deposit or Saving Deposit.

Examples:
Managerial Accounting Categories could have Hours Worked By Salaried Employees.
Customer Accounting Categories could have Demand Deposit or Saving Deposit.
Ledger Accounting Category could have Interest Income, Salary Expenses and Employee Benefit Expense. 
Asset Accounting Category could have :
 Cash
 Loans
 Shares And Other Equity
 Non Share Securities
 Money Market Paper
 Fixed Assets
 Remaining Assets

Capital Accounting Category could have :
 Regulatory Capital
 Discretionary Capital
 -- Reserves
 ---- Loan Loss Reserve
 ---- Cash Reserve
 -- Other Discretionary Capital
Capital Accounting Category Type could have Accounting Categories that measure the difference between the Organization's assets and liabilities (this is also known as Owner's Equity or Net Worth ), according to the nature of the capital involved, for example: Common Stock, Preferred Stock, Capital Notes, Debentures, Loan Loss Reserves.

General Ledger Accounting Category Type represents a standard category definition of accounting topics as found in the General Ledger of the Organization i.e. the universe of topics about which accounting information will be monitored in the General Ledger.

Credit Risk Accounting Category Type could have Accounting Categories according to the accounting method for treating the product as on or off balance sheet, and whether the exposure position is an exchange traded position.
Examples (these examples are more towards the creation of financial instrument):
 Over The Counter Derivatives Exposure
 Securities Exposure
 Loan Credit Exposure
 Commitments Exposure
 -- Committed Exposure
 -- Uncommitted Exposure
 ---- Communicated Exposure
 ---- Uncommunicated Exposure
 Other Non-Derivative Off Balance Sheet Items
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Category Descr
DescriptionA free-form textual explanation or comment about the accounting category for an accounting structure level.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Class
DescriptionIndicates the accounting concept that defines the Financial Intelligence.

For example:
Asset
Liability
Income
Expense
Owner's Equity
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Accounting Structure Item_Accounting Structure_FK
Is Identifying Relationshipfalse
Child TableAccounting Structure Level
Child Role Namepertains to
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAccounting Structure
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypeHierarchy Level
SubtypeAccounting Structure Level
Transform AsTABLE