Please wait. This can take some minutes ...
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.mysql.CA_ACCTG_CTGRY_T.sql Maven / Gradle / Ivy
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')
/