GeneralLedger.ProjectBalance

by

Purpose

General Ledger Project Balance

Use Case

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

Source

FACT_GL_PROJECT_BALANCE_OL

Key Parameters

Company
Ledger_ID (Created)
PRU
Project_ID
Account_ID

Sample Exec

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

Response

    COMPANY,
    LEDGER_ID,
    PRU,
    PROJECT_ID,

SEQ

    ACCOUNT_ID,
    POSTING_COMBINATION_ID_KEY,
    [ACCOUNTING_YEAR_KEY],
    [ACCOUNTING_PERIOD_KEY],

Dates

    cast(ACC_PERIOD_FROM as date) as ACC_PERIOD_FROM,

Measures

    cast([BALANCE] as decimal (15,3)) as [BALANCE],
    cast([DEBIT_BALANCE] as decimal (15,3)) as [DEBIT_BALANCE],
    cast([CREDIT_BALANCE] as decimal (15,3)) as [CREDIT_BALANCE],
    cast([QTY_BALANCE] as decimal (15,3)) as [QTY_BALANCE],
    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

SQL

BMT-DWH-DEV/GeneralLedger_ProjectBalance.sql

Leave a Comment