GeneralLedger.BalanceSet

by

Purpose

General Ledger Balance Set

Use Case

Owner: Soon Tan
Typical Use Case: General Ledger Balance Set
Style: Fact

Source

FACT_GL_BAL_SET_ANALYS_OL

Key Parameters

Company
Ledger_ID (Created)
PRU
Project_ID
Account_ID

Sample Exec

EXEC get.myView @dataMart = 'GeneralLedger', @viewName = 'BalanceSet', @token = '<myToken>', @version = '<202404>'

Response

    COMPANY,
    LEDGER_ID,
    PRU,
    PROJECT_ID,

SEQ

    ACCOUNT_ID,
    POSTING_COMBINATION_ID,
    [ACCOUNTING_YEAR_KEY],
    [ACCOUNTING_PERIOD_KEY],

Dates

    cast(ACC_PERIOD_FROM as date) as ACC_PERIOD_FROM,

Measures

    cast([AMOUNT_BALANCE] as decimal (15,3)) as [AMOUNT_BALANCE],
    cast([DEBIT_BALANCE] as decimal (15,3)) as [DEBIT_BALANCE],
    cast([CREDIT_BALANCE] as decimal (15,3)) as [CREDIT_BALANCE],
    cast([QUANTITY] as decimal (15,3)) as [QUANTITY],
    cast([CURR_AMOUNT_BALANCE] as decimal (15,3)) as [CURR_AMOUNT_BALANCE],
    cast([CURR_DEBIT_BALANCE] as decimal (15,3)) as [CURR_DEBIT_BALANCE],
    cast([CURR_CREDIT_BALANCE] as decimal (15,3)) as [CURR_CREDIT_BALANCE],

Codes

    CODE_B,
    CODE_C,
    FA_OBJECT_ID,
    CURRENCY_CODE,
    CODE_H,
    [BALANCE_SET_ID]

SQL

BMT-DWH-DEV/GeneralLedger_BalanceSet.sql

Leave a Comment