GeneralLedger.PeriodBudget

by

Purpose

General Ledger Period Budget

Use Case

Owner: Soon Tan
Typical Use Case: General Ledger Period Budget
Style: Fact

Source

FACT_GL_PERIOD_BUDGET_OL

Key Parameters

Company
Ledger_ID (Created)
PRU
Project_ID
Account_ID

Sample Exec

EXEC get.myView @dataMart = 'GeneralLedger', @viewName = 'PeriodBudget', @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([AMOUNT] as decimal (15,3)) as [AMOUNT],
    cast([CURRENCY_AMOUNT] as decimal (15,3)) as [CURRENCY_AMOUNT],
    cast([QUANTITY] as decimal (15,3)) as [QUANTITY],

Codes

    CODE_B,
    CODE_C,
    FA_OBJECT_ID,
    CURRENCY_CODE,
    CODE_H

SQL

BMT-DWH-DEV/GeneralLedger_PeriodBudget.sql

Leave a Comment