• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• CA_ACCTG_CTGRY_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.oracle.CA_ACCTG_CTGRY_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE CA_ACCTG_CTGRY_T DROP STORAGE
/
INSERT INTO CA_ACCTG_CTGRY_T (ACCTG_CTGRY_CD,OBJ_ID,VER_NBR,ACCTG_CTGRY_DESC,ACCTG_CTGRY_SHRT_NM,FIN_REPORT_SORT_CD,ROW_ACTV_IND)
  VALUES ('AS','2ECB4157BE1060E4E043814FD88160E4',1.0,'ASSETS','ASSETS','01','Y')
/
INSERT INTO CA_ACCTG_CTGRY_T (ACCTG_CTGRY_CD,OBJ_ID,VER_NBR,ACCTG_CTGRY_DESC,ACCTG_CTGRY_SHRT_NM,FIN_REPORT_SORT_CD,ROW_ACTV_IND)
  VALUES ('EX','2ECB4157BE1460E4E043814FD88160E4',1.0,'EXPENSES','EXPENSES','05','Y')
/
INSERT INTO CA_ACCTG_CTGRY_T (ACCTG_CTGRY_CD,OBJ_ID,VER_NBR,ACCTG_CTGRY_DESC,ACCTG_CTGRY_SHRT_NM,FIN_REPORT_SORT_CD,ROW_ACTV_IND)
  VALUES ('FB','2ECB4157BE1260E4E043814FD88160E4',1.0,'FUND BALANCE','FUND BALANCE','03','Y')
/
INSERT INTO CA_ACCTG_CTGRY_T (ACCTG_CTGRY_CD,OBJ_ID,VER_NBR,ACCTG_CTGRY_DESC,ACCTG_CTGRY_SHRT_NM,FIN_REPORT_SORT_CD,ROW_ACTV_IND)
  VALUES ('IN','2ECB4157BE1360E4E043814FD88160E4',1.0,'INCOME','INCOME','04','Y')
/
INSERT INTO CA_ACCTG_CTGRY_T (ACCTG_CTGRY_CD,OBJ_ID,VER_NBR,ACCTG_CTGRY_DESC,ACCTG_CTGRY_SHRT_NM,FIN_REPORT_SORT_CD,ROW_ACTV_IND)
  VALUES ('LI','2ECB4157BE1160E4E043814FD88160E4',1.0,'LIABILITIES','LIABILITIES','02','Y')
/