CREATE TABLE "FLOWLOGIC"."WFP_PROJ_HDR_MIGRATE"
( "PP_WO" VARCHAR2(30),
"PROJECT_NO" VARCHAR2(100),
"EXCH_CODE" VARCHAR2(5),
"DONOR_EXCH_CODE" VARCHAR2(5),
"PROJ_TITLE" VARCHAR2(2000),
"PROJ_LOCATION" VARCHAR2(2000),
"SCHEME_TYP_CODE" VARCHAR2(100),
"SCHEME_CAT_CODE" VARCHAR2(100),
"SCHEME_OBJ_CODE" VARCHAR2(100),
"PROJECT_TYP_CODE" VARCHAR2(100),
"SERVICE_TYP_CODE" VARCHAR2(100),
"CUSTOMER_CODE" VARCHAR2(100),
"CONTRACTOR_CODE" VARCHAR2(100),
"EXTERNAL_PTY_CODE" VARCHAR2(100),
"PROJECT_CODE" VARCHAR2(20),
"JOB_NO" VARCHAR2(30),
"OLD_PP_WO" VARCHAR2(30),
"CHARGEABLE_FLG" VARCHAR2(2),
"TENDER_FLG" VARCHAR2(20),
"WAYLEAVE_FLG" VARCHAR2(2),
"WORK_FLG" VARCHAR2(2),
"PROGRESS" NUMBER(5,2),
"PLN_EST_AMT" NUMBER(20,2),
"PLN_ACT_AMT" NUMBER(20,2),
"FIN_ACT_COST" NUMBER(20,2),
"FIN_EXT_COST" NUMBER(20,2),
"DMG_CLM_NO" VARCHAR2(30),
"EST_SRT_DATE" DATE,
"EST_END_DATE" DATE,
"ACT_SRT_DATE" DATE,
"ACT_END_DATE" DATE,
"REMARKS" VARCHAR2(500),
"SP_INSTR" VARCHAR2(500),
"MANDAYS" NUMBER,
"SOURCE_CODE" VARCHAR2(20),
"SOURCE_NO" VARCHAR2(30),
"ISACTIVE" NUMBER(1,0),
"CREATE_DATE" DATE,
"CREATE_BY" VARCHAR2(100),
"LPT" VARCHAR2(20),
"FIN_YEAR" VARCHAR2(20),
"IND_PROJ" VARCHAR2(20),
"DMG_EST_AMT" NUMBER(10,2),
"ATTENTION_TO" VARCHAR2(100),
"TARGET_DATE" DATE,
"PHASE_BLOCK" VARCHAR2(50),
"DS_CAT" VARCHAR2(20),
"DUE_DATE" DATE,
"BLDG_COMP_DATE" DATE,
"ASSIGNED_BY" VARCHAR2(100),
"ASSIGNED_TO" VARCHAR2(100),
"COST_VALUE" NUMBER(20,2),
"PROJ_DEF_CODE" VARCHAR2(50),
"PROJ_NATURE_CODE" VARCHAR2(50),
"PROJ_TYPE_CODE" VARCHAR2(50),
"SUB_PROJ_CODE" VARCHAR2(20),
"APP_CODE" VARCHAR2(50),
"FIXED_CHG_TYPE" NUMBER(*,0),
"CERTIFIED_BY" VARCHAR2(100),
"CERTIFIED_DATE" DATE,
"FINALPOST_FLAG" NUMBER(1,0),
"CO_FLAG" NUMBER(1,0),
"CO_STATUS" VARCHAR2(20),
"CO_DATE" DATE,
"CONTRACT_CREATION_FLAG" NUMBER(1,0),
"IMPACT_FLG" NUMBER(1,0),
"CONTRACT_LOCK_FLAG" NUMBER(1,0),
"REV_FLG" NUMBER(20,0),
"AMD_FLG" NUMBER(20,0),
"ACCNO" VARCHAR2(50),
"DUMMY_PROJECT_FLAG" NUMBER(1,0),
"SUPERVISOR" VARCHAR2(500),
"PARENT_PPWONO" VARCHAR2(20),
"LOB" VARCHAR2(100),
"MANAGER" VARCHAR2(200),
"DIRECTOR" VARCHAR2(200),
"DESIGNER_DATE" DATE,
"MANAGER_DATE" DATE,
"PLANNER_DATE" DATE,
"DIRECTOR_DATE" DATE,
"FIXED_CHARGE_TYPE" NUMBER(1,0),
"PLANNER_FN" VARCHAR2(200),
"DESIGNER_FN" VARCHAR2(200),
"MANAGER_FN" VARCHAR2(200),
"DIRECTOR_FN" VARCHAR2(200),
"ASSIGNED_BY_FN" VARCHAR2(200),
"TQN" VARCHAR2(2),
"WAYLEAVE" VARCHAR2(100),
"INSTALL_DATE" DATE,
"PLANNED_DESIGN_END_DATE" DATE,
"WORKPRINT_MIGRATE" CHAR(1),
"COSTSHEET_MIGRATE" CHAR(1),
"FOLDER_CREATION" CHAR(1),
"COSTSHEET_MIGRATE_START" CHAR(1),
"ERRORMSG" VARCHAR2(200),
"SO_CREATION" CHAR(1),
"SHAREPOINT_MIGRATE" NUMBER,
"PDF_CREATED" CHAR(1)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "FLOWLOGIC"