G/L Semantic Model (ADM)

Synonyms

This is also called:

• General Ledger
• GL
• Accounting
• Trial Balance

This is our standard G/L star schema.

Often, not all dimensions are used.

Also, you might need to add additional dimensions.

This works with most charts of account, for BE, CH, DE, and others.

It is flexible enough to add budgets, planning figures, profit center calculation, divisions, multiple companies/legal entities, and more.

erDiagram
    FactAmount {
        id TransactionNumber
        eur Amount "signed amount (+/-)"
    }

    DimCalendar {
        date Date
        etc etc
    }

    DimAccount {
        int AccountCode "3402"
        txt AccountName
        code AccountGroup "340"
        txt AccountGroupName
        code AccountMainGroup "34"
        txt AccountMainGroupName
        code AccountClassCode "3"
        txt AccountClassName
        code AccountCategory "I or B for IncomeStatement or BalanceSheet"
    }

    DimRealisationType {
        code RealisationTypeCode "R, P"
        txt RealisationTypeName "Realised, Planned"
    }

    DimAccountingType {
        code AccountingTypeCode "AC, AL"
        txt AccountingTypeName "Accounting, Allocation"
    }

    DimDivision {
        code DivisionCode
        txt Divisionname
    }

    DimCompany {
        code CompanyCode
        txt CompanyName
    }





    DimCalendar ||--o{ FactAmount: refs
    DimAccount ||--o{ FactAmount: refs
    DimRealisationType ||--o{ FactAmount: refs
    DimAccountingType ||--o{ FactAmount: ref
    DimDivision ||--o{ FactAmount: ref
    DimCompany ||--o{ FactAmount: ref

• DimAccountingType: this is needed for allocating costs of cost centers to profit centers. For an example, see #lb.

Clients using this

• #lb

• #tb

• #msl