SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_profit_loss_hierarchy.sas
Go to the documentation of this file.
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4 \file
5 \brief Profit and Loss Hierarchy
6 \details
7
8 |PK |Variable |Type | Required? |Relationships |Label |Description |
9 |--------------|----------------------|------------------|-----------|-----------------------------------------|----------------------------------------|------------------------|
10 | ![ ](pk.jpg) | CHART_OF_ACCOUNT_CD | VARCHAR(32) | Y | \link map_chart_of_account.sas \endlink | Chart of Account Code | Chart of Account Code |
11 | ![ ](pk.jpg) | PROFIT_LOSS_CD | VARCHAR(32) | Y | | Profit Loss Code | Profit Loss Code |
12 | | PROFIT_LOSS_LEV1 | VARCHAR(200) | N | | Level 1 of the profit loss hierarchy | Profit Loss Level 1 |
13 | | PROFIT_LOSS_LEV2 | VARCHAR(200) | N | | Level 2 of the profit loss hierarchy | Profit Loss Level 2 |
14 | | PROFIT_LOSS_LEV3 | VARCHAR(200) | N | | Level 3 of the profit loss hierarchy | Profit Loss Level 3 |
15 | | PROFIT_LOSS_LEV4 | VARCHAR(200) | N | | Level 4 of the profit loss hierarchy | Profit Loss Level 4 |
16 | | PROFIT_LOSS_LEV5 | VARCHAR(200) | N | | Level 5 of the profit loss hierarchy | Profit Loss Level 5 |
17 | | ROLL_UP | VARCHAR(10) | N | | Roll up flag | Flag (Y/N) that indicates if an account gets values by rolling-up other accounts |
18
19\author SAS Institute Inc.
20\date 2018
21
22*/
23CREATE TABLE &LIBREF..MAP_PROFIT_LOSS_HIERARCHY (
24 CHART_OF_ACCOUNT_CD VARCHAR(32) label = 'Chart of Account Code',
25 PROFIT_LOSS_CD VARCHAR(32) label = 'Profit Loss Code',
26 PROFIT_LOSS_LEV1 VARCHAR(200) label = 'Profit Loss Level 1',
27 PROFIT_LOSS_LEV2 VARCHAR(200) label = 'Profit Loss Level 2',
28 PROFIT_LOSS_LEV3 VARCHAR(200) label = 'Profit Loss Level 3',
29 PROFIT_LOSS_LEV4 VARCHAR(200) label = 'Profit Loss Level 4',
30 PROFIT_LOSS_LEV5 VARCHAR(200) label = 'Profit Loss Level 5',
31 ROLL_UP VARCHAR(10) label = 'Roll-Up',
32 CONSTRAINT PRIM_KEY PRIMARY KEY (CHART_OF_ACCOUNT_CD, PROFIT_LOSS_CD)
33);