28CREATE TABLE &LIBREF..PROFIT_LOSS_ACCOUNT (
29 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
30 ENTITY_ID VARCHAR(32) label =
'Entity Id',
31 PL_ACCOUNT_ID VARCHAR(32) label =
'Profit Loss 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 PROFIT_LOSS_CD VARCHAR(32) label =
'Profit Loss 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 PL_ACCOUNT_VALUE_AMT NUMERIC(8) label =
'Profit Loss Account Value Amount' FORMAT = NLNUM15.3,
40 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID, PL_ACCOUNT_ID, FORECAST_HORIZON, SCENARIO_ID, MOVEMENT_TYPE_CD)