39CREATE TABLE &LIBREF..SYNTHETIC_CASHFLOW (
40 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
41 ENTITY_ID VARCHAR(32) label =
'Entity Id',
42 INSTID VARCHAR(64) label =
'Instrument Identifier',
43 CASHFLOW_LEG VARCHAR(32) label =
'Cashflow Leg',
44 HORIZON NUMERIC(8) label =
'Horizon',
45 INTERVAL VARCHAR(32) label =
'Interval',
46 CASHFLOW_AMT NUMERIC(8) label =
'Cashflow Amount',
47 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID, INSTID, CASHFLOW_LEG, HORIZON)