CREATE TABLE "PPM_DATA"."PPM_UPLOAD_1C" 
   (	"ROW_ID" NUMBER, 
	"LOAD_DATE" DATE DEFAULT sysdate, 
	"LOAD_STATUS" VARCHAR2(7 CHAR) DEFAULT 'LDST001', 
	"OPERATION_DATE" DATE, 
	"PROJECT_ID" VARCHAR2(20 CHAR), 
	"DESCRIPTION" VARCHAR2(2000 CHAR) NOT NULL ENABLE, 
	"OPERATION_AMOUNT" NUMBER(*,2) DEFAULT 0 NOT NULL ENABLE, 
	"OPERATION_CUR" VARCHAR2(3 CHAR) DEFAULT 'KZT'
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
 

   COMMENT ON COLUMN "PPM_DATA"."PPM_UPLOAD_1C"."ROW_ID" IS 'Рег.№ строки';
 
   COMMENT ON COLUMN "PPM_DATA"."PPM_UPLOAD_1C"."LOAD_DATE" IS 'Дата/время загрузки';
 
   COMMENT ON COLUMN "PPM_DATA"."PPM_UPLOAD_1C"."LOAD_STATUS" IS 'Статус загрузки';
 
   COMMENT ON COLUMN "PPM_DATA"."PPM_UPLOAD_1C"."OPERATION_DATE" IS 'Дата операции';
 
   COMMENT ON COLUMN "PPM_DATA"."PPM_UPLOAD_1C"."PROJECT_ID" IS 'Код проекта';
 
   COMMENT ON COLUMN "PPM_DATA"."PPM_UPLOAD_1C"."DESCRIPTION" IS 'Статья расходов';
 
   COMMENT ON COLUMN "PPM_DATA"."PPM_UPLOAD_1C"."OPERATION_AMOUNT" IS 'Сумма операции';
 

  CREATE OR REPLACE TRIGGER "PPM_DATA"."TRG_UPLOAD_1C_BIFER" BEFORE INSERT ON PPM_UPLOAD_1C 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ROW_ID IS NULL THEN
      SELECT PPM_UPLOAD_1C_SEQ.NEXTVAL INTO :NEW.ROW_ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "PPM_DATA"."TRG_UPLOAD_1C_BIFER" ENABLE;