/*==============================================================*/
/* Table: T_EB_ADJDETAIL      调整/调剂单增加自定义维度        */
/*==============================================================*/
  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM21') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM21 BIGINT DEFAULT 0 NOT NULL);

  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM22') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM22 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM23') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM23 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM24') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM24 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM25') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM25 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM26') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM26 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM27') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM27 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM28') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM28 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM29') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM29 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM30') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM30 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM31') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM31 BIGINT DEFAULT 0 NOT NULL);

   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM32')
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM32 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM33') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM33 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM34') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM34 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM35') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM35 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM36') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM36 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM37') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM37 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM38') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM38 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM39') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM39 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM40') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM40 BIGINT DEFAULT 0 NOT NULL);
 
    IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM41') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM41 BIGINT DEFAULT 0 NOT NULL);

  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM42') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM42 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM43') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM43 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM44') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM44 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM45') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM45 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM46') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM46 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM47') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM47 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM48') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM48 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM49') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM49 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJDETAIL' AND KSQL_COL_NAME ='FCUSTOMDIM50') 
 ALTER TABLE T_EB_ADJDETAIL ADD (FCUSTOMDIM50 BIGINT DEFAULT 0 NOT NULL);
