GeneralLedger.Details

by

Purpose

Details

Use Case

Owner: Soon Tan
Typical Use Case: General Ledger
Style: Details

Source

FACT_GL_BALANCE_OL

Key Parameters

Company
Ledger_ID (Created)
Account_ID
PRU
PROJECT_ID

Sample Exec

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

Response

    COMPANY_KEY as COMPANY,
    concat_ws('|',ACCOUNT,POSTING_COMBINATION_ID_KEY) as LEDGER_ID,

SEQ

    ACCOUNT_ID, ACCOUNT_Desc,
    POSTING_COMBINATION_ID_KEY,

Dates

    cast(FIRST_ACC_PERIOD_FROM as DATE) as FIRST_ACC_PERIOD_FROM,
    cast(LAST_ACC_PERIOD_FROM as DATE) as LAST_ACC_PERIOD_FROM ,

Codes

    ACCOUNT_GROUP,
    ACCOUNT_TYPE,
    FA_SHEET,
    [LOGICAL_ACCOUNT_TYPE], [LOGICAL_ACCOUNT_TYPE_DESC],
    PRU, CODE_E_Desc,
    PROJECT_ID,
    CODE_B, CODE_B_Desc,
    CODE_C, CODE_C_Desc,
    FA_OBJECT_ID, CODE_F_Desc,
    CURRENCY_CODE,
    CODE_H, CODE_H_Desc

SQL

BMT-DWH-DEV/GeneralLedger_Details.sql

Leave a Comment