23CREATE TABLE &LIBREF..MAP_PROFIT_LOSS_HIERARCHY (
24 CHART_OF_ACCOUNT_CD VARCHAR(32) label =
'Chart of Account Code',
25 PROFIT_LOSS_CD VARCHAR(32) label =
'Profit Loss Code',
26 PROFIT_LOSS_LEV1 VARCHAR(200) label =
'Profit Loss Level 1',
27 PROFIT_LOSS_LEV2 VARCHAR(200) label =
'Profit Loss Level 2',
28 PROFIT_LOSS_LEV3 VARCHAR(200) label =
'Profit Loss Level 3',
29 PROFIT_LOSS_LEV4 VARCHAR(200) label =
'Profit Loss Level 4',
30 PROFIT_LOSS_LEV5 VARCHAR(200) label =
'Profit Loss Level 5',
31 ROLL_UP VARCHAR(10) label =
'Roll-Up',
32 CONSTRAINT PRIM_KEY PRIMARY KEY (CHART_OF_ACCOUNT_CD, PROFIT_LOSS_CD)