Global.Management_Accs

Purpose

Provides Management Account Structure

Use Case

Owner: Soon Tan
Typical Use Case: Financial Account Structure
Style: Detail

Source

DIM_ACC_STRUCT_NODE_ACCOUNT_OL DIM_ACC_STRUCT_LEAF_ACCOUNT_OL DIM_ACCOUNT_OL

Key Parameters

Company
Account Code

Sample Exec

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

Response

COMPANY,

Level 1

	LEVEL1_STRUCTURE_ID,
	LEVEL1_CODE,
	LEVEL1_NODE_ID,
	LEVEL1_NODE_ID_DESCRIPTION,
	LEVEL1_LEVEL_ID,

Heading

	HEADING_STRUCTURE_ID,
	HEADING_CODE,
	HEADING_NODE_ID,
	HEADING_NODE_ID_DESCRIPTION,
	HEADING_PARENT_NODE_ID,
	HEADING_LEVEL_ID,

Grouping 1

	GROUPING1_STRUCTURE_ID,
	GROUPING1_CODE,
	GROUPING1_NODE_ID,
	GROUPING1_NODE_ID_DESCRIPTION,
	GROUPING1_PARENT_NODE_ID,
	GROUPING1_LEVEL_ID,

Grouping 2

	GROUPING2_STRUCTURE_ID,
	GROUPING2_CODE,
	GROUPING2_NODE_ID,
	GROUPING2_NODE_ID_DESCRIPTION,
	GROUPING2_PARENT_NODE_ID,
	GROUPING2_LEVEL_ID,

Leaf

	LEAF_STRUCTURE_ID,
	LEAF_CODE,
	LEAF_NODE_ID,

Account

  ACCOUNT_CODE,
  ACCOUNT_DESCRIPTION,
  ACCOUNT_GROUP,
  ACCOUNT_GROUP_DESC,
  ACCOUNT_TYPE,
  ACCOUNT_TYPE_DESC,
  VALID_FROM,
  VALID_UNTIL,
  LOGICAL_ACCOUNT_TYPE,
  LOGICAL_ACCOUNT_TYPE_DESC,
  LEDGER_ACCOUNT,
  CURRENCY_BALANCE,
  BUDGET_ACCOUNT_ONLY,
  TAX_ACCOUNT,
  TAX_HANDLING,
  UPPER(EXCLUDE_FROM_CURR_TRANS) AS EXCLUDE_FROM_CURR_TRANS,
  UPPER(KEEP_REP_CURRENCY) AS KEEP_REP_CURRENCY,
  UPPER(KEEP_REPORTING_ENTITY) AS KEEP_REPORTING_ENTITY

SQL

BMT-DWH-DEV/Global_Management_Accs.sql