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)