GeneralLedger.Transaction

by

Purpose

General ledger Transaction

Use Case

Owner: Soon Tan
Typical Use Case: General ledger Transaction
Style: Fact

Source

FACT_GL_TRANSACTION_OL

Key Parameters

Company
Ledger_ID (Created)
PRU
Project_ID
Account_ID

Sample Exec

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

Response

    COMPANY,
    LEDGER_ID,
    PRU,
    PROJECT_ID,

SEQ

    ACCOUNT_ID,
    POSTING_COMBINATION_ID,
    [ACCOUNTING_YEAR_KEY],
    [ACCOUNTING_PERIOD_KEY],
    [VOUCHER_NO],
    [ROW_NO],

Dates

    cast(ACC_PERIOD_FROM as date) as ACC_PERIOD_FROM,
    cast(VOUCHER_DATE as date) as VOUCHER_DATE,

Measures

    cast([AMOUNT] as decimal (15,3)) as [AMOUNT],
    cast([DEBIT_AMOUNT] as decimal (15,3)) as [DEBIT_AMOUNT],
    cast([CREDIT_AMOUNT] as decimal (15,3)) as [CREDIT_AMOUNT],
    cast([QUANTITY] as decimal (15,3)) as [QUANTITY],
    cast([CURR_AMOUNT] as decimal (15,3)) as [CURR_AMOUNT],
    cast([CURR_DEBIT] as decimal (15,3)) as [CURR_DEBIT],
    cast([CURR_CREDIT] as decimal (15,3)) as [CURR_CREDIT],

Codes

    CODE_B,
    CODE_C,
    FA_OBJECT_ID,
    CURRENCY_CODE,
    CODE_H,
    [JOURNAL_NUMBER],
    VOUCHER_TEXT,
    [TRANSACTION_CODE],
    [VOUCHER_ROW_TEXT]

SQL

BMT-DWH-DEV/GeneralLedger_Transaction.sql

Leave a Comment