All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql.mysql.CA_ACCTG_CTGRY_T.sql Maven / Gradle / Ivy

There is a newer version: 1.6.2
Show newest version
TRUNCATE TABLE CA_ACCTG_CTGRY_T
/
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')
/




© 2015 - 2024 Weber Informatics LLC | Privacy Policy