SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
gl_account.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA
3*/
4
5/**
6 \file
7 \brief General Ledger account
8 \details
9
10 |PK |Variable |Type | Required? |Relationships |Label |Description | Required by models |
11 |--------------|--------------------------|----------------|-----------|------------------------------------------------|--------------------------|----------------------------------------------------------------|----------------------------------------------------------------------------------|
12 | ![ ](pk.jpg) | <b>REPORTING_DT</b> | NUMERIC(8) | Y | | Reporting Date | Date the GL entry was reported | ST - Financial Statement Projection |
13 | | <b>ENTITY_ID</b> | VARCHAR(32) | Y | \link entity.sas \endlink | Entity Id | Unique Entity identifier | ST - Financial Statement Projection |
14 | ![ ](pk.jpg) | <b>GL_ACCOUNT_ID</b> | VARCHAR(32) | Y | | GL Account Id | Identifier used to define the type of GL account | ST - Financial Statement Projection |
15 | ![ ](pk.jpg) | <b>FORECAST_HORIZON</b> | NUMERIC(8) | Y | | Forecast Horizon | Forecast horizon: <br> - FORECAST_HORIZON = 0 identifies actual values. <br> - FORECAST_HORIZON > 0 indicate forecasts. <br> Forecast values (if any) override any computed values | ST - Financial Statement Projection |
16 | | GEOGRAPHY_CD | VARCHAR(32) | N | \link map_geo_hierarchy.sas \endlink | Geography Code | Geography code | |
17 | | CHART_OF_ACCOUNT_CD | VARCHAR(32) | N | \link map_chart_of_account.sas \endlink | Chart of Account Code | Chart of Account Code | |
18 | ![ ](pk.jpg) | <b>BALANCE_SHEET_CD </b> | VARCHAR(32) | N | \link map_balance_sheet_hierarchy.sas \endlink | Balance Sheet Code | Balance Sheet Code | ST - Financial Statement Projection |
19 | ![ ](pk.jpg) | <b>SCENARIO_ID</b> | VARCHAR(32) | Y | | Scenario Id | Scenario Identifier | |
20 | ![ ](pk.jpg) | <b>MOVEMENT_TYPE_CD</b> | VARCHAR(32) | Y | \link map_movement_type.sas \endlink | Movement Type Code | Movement Type Code | |
21 | | CURRENCY_CD | VARCHAR(3) | N | | Currency Code | 3 character ISO code for nominal currency of GL account value | |
22 | | GL_ACCOUNT_VALUE_AMT | NUMERIC(8) | N | | GL Account Value Amount | Value amount of the GL account | ST - Financial Statement Projection |
23
24 \author SAS Institute Inc.
25 \date 2018
26
27*/
28CREATE TABLE &LIBREF..GL_ACCOUNT (
29 REPORTING_DT DATE label = 'Reporting Date' FORMAT = &DTFMT.,
30 ENTITY_ID VARCHAR(32) label = 'Entity Id',
31 GL_ACCOUNT_ID VARCHAR(32) label = 'GL Account Id',
32 FORECAST_HORIZON NUMERIC label = 'Forecast Horizon',
33 GEOGRAPHY_CD VARCHAR(32) label = 'Geography Code',
34 CHART_OF_ACCOUNT_CD VARCHAR(32) label = 'Chart of Account Code',
35 BALANCE_SHEET_CD VARCHAR(32) label = 'Balance Sheet Code',
36 SCENARIO_ID VARCHAR(32) label = 'Scenario Id',
37 MOVEMENT_TYPE_CD VARCHAR(32) label = 'Movement Type Code',
38 CURRENCY_CD VARCHAR(3) label = 'Currency Code',
39 GL_ACCOUNT_VALUE_AMT NUMERIC(8) label = 'GL Account Value Amount' FORMAT = NLNUM15.3,
40 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID, GL_ACCOUNT_ID, FORECAST_HORIZON, SCENARIO_ID, MOVEMENT_TYPE_CD)
41);