create table ACCOUNTING_POOL (
    "UUID" raw(16),
    "CONFIG_ID" raw(16),
    "AAE" varchar2(36 char),
    "SAP_PSP_ID" varchar2(18 char),
    "PR_ID" varchar2(18 char),
    "EFFORT_PLAN" number,
    "EFFORT_ACT" number,
    "EFFORT_REM" number,
    "COSTS_PLAN" number,
    "COSTS_ACT" number,
    "COSTS_REM" number,
    "EFFORT_PLAN_PLANTA" number,
    "EFFORT_ACT_PLANTA" number,
    "EFFORT_REM_PLANTA" number,
    "COSTS_PLAN_PLANTA" number,
    "COSTS_ACT_PLANTA" number,
    "COSTS_REM_PLANTA" number,
    "BUDGET" number,
    "OU_COST_CENTER" varchar2(8 char),
    "COST_TYPE" varchar2(8 char),
    "STATUS" number(5,0),
    "TRANSFERRED_ON" varchar2(80 char),
    "CREATED_ON" date,
    "MODIFIED_ON" date,
    "RWDU" number(5,0),
    "CREATED_BY" varchar2(20 char),
    "MODIFIED_BY" varchar2(20 char),
    "OWN_LIC" varchar2(4 char),
    "OPC" varchar2(8 char),
    "OWNER" number(5,0),
    "GROUP" number(5,0),
    "ANY" number(5,0)
) INITRANS 5 MAXTRANS 255;

alter table ACCOUNTING_POOL add constraint PID978DT978 primary key ("UUID");

alter table ACCOUNTING_POOL MODIFY ("UUID" DEFAULT SYS_GUID());

alter table ACCOUNTING_POOL
    add constraint DT978UUID_NOT_NULL check("UUID" is not null);

alter table ACCOUNTING_POOL MODIFY ("EFFORT_PLAN" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("EFFORT_ACT" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("EFFORT_REM" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("COSTS_PLAN" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("COSTS_ACT" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("COSTS_REM" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("EFFORT_PLAN_PLANTA" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("EFFORT_ACT_PLANTA" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("EFFORT_REM_PLANTA" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("COSTS_PLAN_PLANTA" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("COSTS_ACT_PLANTA" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("COSTS_REM_PLANTA" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("BUDGET" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("STATUS" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

alter table ACCOUNTING_POOL MODIFY ("MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

alter table ACCOUNTING_POOL MODIFY ("RWDU" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("OWNER" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("GROUP" DEFAULT 0);

alter table ACCOUNTING_POOL MODIFY ("ANY" DEFAULT 0);