3.6.2 Creating Custom Ledger Class Table

The following are the steps involved in creating a custom Ledger Class table:
  1. Create subtype relationship between the custom Ledger Class table and BASIC_LEDGER_CLASS_REQ super-class entity.

    Note:

    FINANCIAL_ELEM_ID, ORG_UNIT_ID, GL_ACCOUNT_ID, COMMON_COA_ID, and LEGAL_ENTITY must be present in any Management Ledger table. Create a new subject area within the ERwin model.
  2. Create the custom Ledger Class table in ERwin.
  3. Specify logical name, physical name and description for the table.
  4. Define any columns that do not come from any of the standard super-class tables as part of the custom Ledger Class table.
  5. Specify logical, physical names, domain and other column properties for each column.
  6. Move BASIC_LEDGER_CLASS_REQ into the new subject area.