SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_chart_of_account.sas
Go to the documentation of this file.
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4 \file
5 \brief Chart of Account
6 \details
7
8 |PK |Variable |Type | Required? |Relationships |Label |Description |
9 |--------------|----------------------------|------------------|-----------|---------------|-------------------------------|-------------------------------|
10 | ![ ](pk.jpg) | <b>CHART_OF_ACCOUNT_CD</b> | VARCHAR(32) | Y | | Chart of Account Code | Chart of Account Code |
11 | | CHART_OF_ACCOUNT_NAME | VARCHAR(100) | N | | Chart of Account Name | Chart of Account Name |
12 | | CHART_OF_ACCOUNT_DESC | VARCHAR(200) | N | | Chart of Account Description | Chart of Account Description |
13
14\author SAS Institute Inc.
15\date 2018
16
17*/
18CREATE TABLE &LIBREF..MAP_CHART_OF_ACCOUNT (
19 CHART_OF_ACCOUNT_CD VARCHAR(32) label = 'Chart of Account Code',
20 CHART_OF_ACCOUNT_NAME VARCHAR(100) label = 'Chart of Account Name',
21 CHART_OF_ACCOUNT_DESC VARCHAR(200) label = 'Chart of Account Description',
22 CONSTRAINT PRIM_KEY PRIMARY KEY (CHART_OF_ACCOUNT_CD)
23);