29CREATE TABLE &LIBREF..OWN_FUNDS_ACCOUNT (
30 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
31 ENTITY_ID VARCHAR(32) label =
'Entity Id',
32 OF_ACCOUNT_ID VARCHAR(32) label =
'Own Funds Account Id',
33 FORECAST_HORIZON NUMERIC label =
'Forecast Horizon',
34 GEOGRAPHY_CD VARCHAR(32) label =
'Geography Code',
35 CHART_OF_ACCOUNT_CD VARCHAR(32) label =
'Chart of Account Code',
36 OWN_FUNDS_CD VARCHAR(32) label =
'Own Funds Code',
37 SCENARIO_ID VARCHAR(32) label =
'Scenario Id',
38 MOVEMENT_TYPE_CD VARCHAR(32) label =
'Movement Type Code',
39 CURRENCY_CD VARCHAR(3) label =
'Currency Code',
40 BALANCE_SHEET_CD VARCHAR(32) label =
'Balance Sheet Code',
41 OF_ACCOUNT_VALUE_AMT NUMERIC(8) label =
'Own Funds Account Value Amount' FORMAT = NLNUM15.3,
42 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID, OF_ACCOUNT_ID, FORECAST_HORIZON, SCENARIO_ID, MOVEMENT_TYPE_CD)