58create table &libref..FS_PROJECTION (
59 ANALYSIS_RUN_ID NUMERIC label =
'Analysis Run Id',
60 ANALYSIS_RUN_NAME VARCHAR(150) label =
'Analysis Run Name',
61 LOAD_ID VARCHAR(32) label =
'Load Id',
62 REPORTING_DT DATE label =
'Reporting Date' FORMAT = yymmddd10.,
63 ENTITY_ID VARCHAR(32) label =
'Entity',
64 WORKGROUP VARCHAR(32) label =
'Workgroup',
65 PROJECT_NAME VARCHAR(64) label =
'Project Name',
66 SCENARIO_ID VARCHAR(32) label =
'Scenario Id',
67 SCENARIO_NAME VARCHAR(512) label =
'Scenario Name',
68 FS_LINEITEM VARCHAR(64) label =
'Financial Account Identifier',
69 FORECAST_PERIOD VARCHAR(32) label =
'Forecast Period',
70 FORECAST_TIME NUMERIC(8) label =
'Forecast Time',
71 GEOGRAPHY_CD VARCHAR(32) label =
'Geography Code',
72 GEOGRAPHY_LEV1 VARCHAR(100) label =
'Geography Level 1',
73 GEOGRAPHY_LEV2 VARCHAR(100) label =
'Geography Level 2',
74 GEOGRAPHY_LEV3 VARCHAR(100) label =
'Geography Level 3',
75 GEOGRAPHY_LEV4 VARCHAR(100) label =
'Geography Level 4',
76 CHART_OF_ACCOUNT_CD VARCHAR(32) label =
'Chart of Account Code',
77 CHART_OF_ACCOUNT_NAME VARCHAR(100) label =
'Chart of Account Name',
78 MOVEMENT_ID NUMERIC(8) label =
'Movement Id',
79 MOVEMENT_DESC VARCHAR(100) label =
'Movement Description',
80 MOVEMENT_TYPE_CD VARCHAR(32) label =
'Movement Type Code',
81 MOVEMENT_TYPE VARCHAR(100) label =
'Movement Type',
82 MOVEMENT_CATEGORY VARCHAR(100) label =
'Movement Category',
83 CURRENCY_CD VARCHAR(3) label =
'Currency Code',
84 ACCOUNT_VALUE_AMT NUMERIC(8) label =
'Account Value Amount' FORMAT = comma25.2,
85 FS_ACCOUNT_CD VARCHAR(32) label =
'Financial Account Code',
86 FS_ACCOUNT_LEV1 VARCHAR(100) label =
'FS Line Item Level 1',
87 FS_ACCOUNT_LEV2 VARCHAR(100) label =
'FS Line Item Level 2',
88 FS_ACCOUNT_LEV3 VARCHAR(100) label =
'FS Line Item Level 3',
89 FS_ACCOUNT_LEV4 VARCHAR(100) label =
'FS Line Item Level 4',
90 FS_ACCOUNT_LEV5 VARCHAR(100) label =
'FS Line Item Level 5',
91 FS_TYPE VARCHAR(10) label =
'Financial Statement Type',
92 TGT_CET1 NUMERIC(8) label =
'Target CET1 Ratio',
93 TGT_TIER1 NUMERIC(8) label =
'Target Tier1 Ratio',
94 TGT_TOT_CAP NUMERIC(8) label =
'Target Total Capital Ratio',
95 TGT_LEV NUMERIC(8) label =
'Target Leverage Ratio',
96 RULE_ID VARCHAR(32) label =
'Posting Id',
97 RULE_DESC VARCHAR(4096) label =
'Management Action Description',
98 ROLL_UP VARCHAR(10) label =
'Roll up'