gd.sql

一个用VB写的财务软件源码

VALUES (102,'TGD_DEPARTMENT2003','部门','部门级次','2','IDEPGRADE',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (20,'TGD_GDZCKP','固定资产卡片','已计提月份','2','YJTYF',5,0,-1,-1,0,'017');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (30,'TGD_GDZCKP','固定资产卡片','累计工作量','2','LJGZL',15,4,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (31,'TGD_GDZCKP','固定资产卡片','单位折旧','2','DWZJ',15,4,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (32,'TGD_GDZCKP','固定资产卡片','增加方式','1','ZJFS',20,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (33,'TGD_GDZCKP','固定资产卡片','减少方式','1','JSFS',20,NULL,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (34,'TGD_GDZCKP','固定资产卡片','注销日期','3','ZXRQ',NULL,NULL,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (29,'TGD_GDZCKP','固定资产卡片','工作总量','2','GZZL',15,4,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (36,'TGD_GDZCKP','固定资产卡片','录入日期','3','LRRQ',NULL,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (38,'TGD_GDZCKP','固定资产卡片','规格型号','1','GGXH',40,NULL,-1,0,-1,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (43,'TGD_GDZCKP','固定资产卡片','间座数','2','JZS',5,0,-1,0,-1,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (46,'TGD_GDZCKP','固定资产卡片','建筑面积','2','JZMJ',15,4,-1,0,-1,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (104,'TGD_DEPARTMENT2003','部门','部门负责人','1','CDEPPERSON',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (158,'TGD_ORIGINCHANGED','资金来源变动','变动原因','1','BDYY',50,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (159,'TGD_ORIGINCHANGED','资金来源变动','备注','1','BZ',50,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (151,'TGD_ORIGINCHANGED','资金来源变动','单据号','1','CDJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (109,'TGD_DEPARTMENT2003','部门','含工作量','2','ISHAVEID',4,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (22,'TGD_GDZCKP','固定资产卡片','使用状况','1','SYZK',20,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (25,'TGD_GDZCKP','固定资产卡片','固定资产科目','1','ZCKM',40,NULL,-1,-1,-1,'005');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (47,'TGD_GDZCKP','固定资产卡片','月预提修费率','2','YTXFL',15,4,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (44,'TGD_GDZCKP','固定资产卡片','电机功率','2','DJGL',15,4,-1,0,-1,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (80,'TGD_ASSETSORIGIN','资金来源','来源代码','1','CCODE',0,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (81,'TGD_ASSETSORIGIN','资金来源','来源名称','1','VCNAME',0,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (103,'TGD_DEPARTMENT2003','部门','结束','2','BDEPEND',4,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (107,'TGD_DEPARTMENT2003','部门','别称','2','BOTHERUSE',4,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (100,'TGD_DEPARTMENT2003','部门','部门编号','1','CDEPCODE',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (106,'TGD_DEPARTMENT2003','部门','备注','1','CDEPMEMO',30,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (101,'TGD_DEPARTMENT2003','部门','部门名称','1','CDEPNAME',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (156,'TGD_ORIGINCHANGED','资金来源变动','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (241,'TGD_ZCBMZY','资产部门转移','变动后部门编号','1','BDHBMBH',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (239,'TGD_ZCBMZY','资产部门转移','变动后地点','1','BDHDD',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (236,'TGD_ZCBMZY','资产部门转移','变动前部门','1','BDQBM',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (157,'TGD_ORIGINCHANGED','资金来源变动','经手人','1','JSR',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (110,'TGD_DEPARTMENT2003','部门','对应修费科目','1','XFDFKM',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (132,'TGD_GZL','工作量','工作量','2','GZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (130,'TGD_GZL','工作量','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (134,'TGD_GZL','工作量','录入人','1','LRR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (135,'TGD_GZL','工作量','录入日期','3','LRRQ',8,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (133,'TGD_GZL','工作量','起始工作量','2','SQGZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (131,'TGD_GZL','工作量','输入月份','1','SRYF',7,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (154,'TGD_ORIGINCHANGED','资金来源变动','变动后资金来源代码','1','BDHZJLYDM',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (155,'TGD_ORIGINCHANGED','资金来源变动','变动后资金来源名称','1','BDHZJLYMC',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (152,'TGD_ORIGINCHANGED','资金来源变动','变动前资金来源代码','1','BDQZJLYDM',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (153,'TGD_ORIGINCHANGED','资金来源变动','变动前资金来源名称','1','BDQZJLYMC',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (238,'TGD_ZCBMZY','资产部门转移','变动后部门','1','BDHBM',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (264,'TGD_ZCDXJL','资产大修记录','修理原因','1','XLYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (285,'TGD_ZCFL','资产分类','编码','1','DM',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (286,'TGD_ZCFL','资产分类','名称','1','MC',30,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (240,'TGD_ZCBMZY','资产部门转移','变动前部门编号','1','BDQBMBH',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (150,'TGD_ORIGINCHANGED','资金来源变动','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (180,'TGD_SYZK','使用状况','代码','1','DM',4,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (182,'TGD_SYZK','使用状况','是否计提折旧','2','SFJTZJ',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (181,'TGD_SYZK','使用状况','使用状况名称','1','SYZKMC',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (202,'TGD_YTXF','预提修费','备用预提额','2','BYYTE',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (200,'TGD_YTXF','预提修费','卡片编号','1','KPBH',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (203,'TGD_YTXF','预提修费','累计预提','2','LJYT',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (206,'TGD_YTXF','预提修费','停启用','2','TQY',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (201,'TGD_YTXF','预提修费','预提年月','1','YTNY',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (205,'TGD_YTXF','预提修费','预提原值','2','YTYZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (204,'TGD_YTXF','预提修费','总预提额','2','ZYTE',9,0,0,0,0,NULL);

INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (262,'TGD_ZCDXJL','资产大修记录','开始日期','1','KSRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (331,'TGD_ZCGZZLTZ','资产工作总量调整','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (333,'TGD_ZCGZZLTZ','资产工作总量调整','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (330,'TGD_ZCGZZLTZ','资产工作总量调整','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (307,'TGD_ZCFSSB','资产附属设备','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (237,'TGD_ZCBMZY','资产部门转移','变动前地点','1','BDQDD',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (232,'TGD_ZCBMZY','资产部门转移','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (234,'TGD_ZCBMZY','资产部门转移','变动原因','1','BDYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (235,'TGD_ZCBMZY','资产部门转移','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (231,'TGD_ZCBMZY','资产部门转移','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (233,'TGD_ZCBMZY','资产部门转移','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (230,'TGD_ZCBMZY','资产部门转移','卡片编号','1','KPBH',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (265,'TGD_ZCDXJL','资产大修记录','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (261,'TGD_ZCDXJL','资产大修记录','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (263,'TGD_ZCDXJL','资产大修记录','结束日期','1','JSRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (260,'TGD_ZCDXJL','资产大修记录','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (335,'TGD_ZCGZZLTZ','资产工作总量调整','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (390,'TGD_ZCJS','资产减少','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (394,'TGD_ZCJS','资产减少','清理费用','2','QLFY',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (393,'TGD_ZCJS','资产减少','清理收入','2','QLSR',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (366,'TGD_ZCJCZLBD','净残值率变动','变动后净残值','2','BDHJCZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (305,'TGD_ZCFSSB','资产附属设备','单位','1','DW',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (303,'TGD_ZCFSSB','资产附属设备','价值','2','JZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (300,'TGD_ZCFSSB','资产附属设备','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (301,'TGD_ZCFSSB','资产附属设备','设备名称','1','SBMC',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (304,'TGD_ZCFSSB','资产附属设备','数量','2','SL',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (306,'TGD_ZCFSSB','资产附属设备','使用日期','1','SYRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (302,'TGD_ZCFSSB','资产附属设备','型号','1','XH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (337,'TGD_ZCGZZLTZ','资产工作总量调整','变动后工作总量','2','BDHGZZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (336,'TGD_ZCGZZLTZ','资产工作总量调整','变动前工作总量','2','BDQGZZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (332,'TGD_ZCGZZLTZ','资产工作总量调整','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (334,'TGD_ZCGZZLTZ','资产工作总量调整','变动原因','1','BDYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (391,'TGD_ZCJS','资产减少','减少日期','1','JSRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (464,'TGD_ZCLB','资产类别','计提属性','1','JTSX',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (466,'TGD_ZCLB','资产类别','卡片样式','1','KPYS',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (461,'TGD_ZCLB','资产类别','名称','1','MC',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (395,'TGD_ZCJS','资产减少','清理原因','1','QLYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (368,'TGD_ZCJCZLBD','净残值率变动','变动后净残值率','2','BDHJCZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (365,'TGD_ZCJCZLBD','净残值率变动','变动前净残值','2','BDQJCZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (367,'TGD_ZCJCZLBD','净残值率变动','变动前净残值率','2','BDQJCZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (362,'TGD_ZCJCZLBD','净残值率变动','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (364,'TGD_ZCJCZLBD','净残值率变动','变动原因','1','BDYY',50,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (361,'TGD_ZCJCZLBD','净残值率变动','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (363,'TGD_ZCJCZLBD','净残值率变动','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (360,'TGD_ZCJCZLBD','净残值率变动','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (398,'TGD_ZCJS','资产减少','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (392,'TGD_ZCJS','资产减少','减少方式','1','JSFS',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (396,'TGD_ZCJS','资产减少','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (463,'TGD_ZCLB','资产类别','计量单位','1','JLDW',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (505,'TGD_ZCLBTZ','资产类别调整','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (501,'TGD_ZCLBTZ','资产类别调整','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (503,'TGD_ZCLBTZ','资产类别调整','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (462,'TGD_ZCLB','资产类别','使用年限','2','SYNX',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (397,'TGD_ZCJS','资产减少','注销日期','1','ZXRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (427,'TGD_ZCJZZB','资产减值准备','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (428,'TGD_ZCJZZB','资产减值准备','变动原因','1','BDYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (421,'TGD_ZCJZZB','资产减值准备','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (426,'TGD_ZCJZZB','资产减值准备','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (425,'TGD_ZCJZZB','资产减值准备','减值金额','2','JZJE',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (420,'TGD_ZCJZZB','资产减值准备','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (422,'TGD_ZCJZZB','资产减值准备','历史减值准备','2','LJJZZB',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (424,'TGD_ZCJZZB','资产减值准备','累积折旧','2','LJZJ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (423,'TGD_ZCJZZB','资产减值准备','原值','2','YZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (460,'TGD_ZCLB','资产类别','代码','1','DM',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (504,'TGD_ZCLBTZ','资产类别调整','变动原因','1','BDYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (570,'TGD_ZCPG','资产评估','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (582,'TGD_ZCPG','资产评估','评估后工作总量','2','PGHGZZL',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (578,'TGD_ZCPG','资产评估','评估后净残值率','2','PGHJCZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (500,'TGD_ZCLBTZ','资产类别调整','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (469,'TGD_ZCLB','资产类别','摊销期','2','TXQ',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (471,'TGD_ZCLB','资产类别','预提修费科目','1','XFKM',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (470,'TGD_ZCLB','资产类别','预提修费率','2','YTXFL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (467,'TGD_ZCLB','资产类别','固定资产科目','1','ZCKM',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (465,'TGD_ZCLB','资产类别','折旧方法','1','ZJFF',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (468,'TGD_ZCLB','资产类别','折旧科目','1','ZJKM',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (507,'TGD_ZCLBTZ','资产类别调整','变动后资产类别','1','BDHZCLB',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (509,'TGD_ZCLBTZ','资产类别调整','变动后资产类别编号','1','BDHZCLBBH',12,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (506,'TGD_ZCLBTZ','资产类别调整','变动前资产类别','1','BDQZCLB',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (508,'TGD_ZCLBTZ','资产类别调整','变动前资产类别编号','1','BDQZCLBBH',12,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (502,'TGD_ZCLBTZ','资产类别调整','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (584,'TGD_ZCPG','资产评估','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (612,'TGD_ZCSYNXTZ','资产使用年限调整','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (614,'TGD_ZCSYNXTZ','资产使用年限调整','变动原因','1','BDYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (615,'TGD_ZCSYNXTZ','资产使用年限调整','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (576,'TGD_ZCPG','资产评估','评估后净值','2','PGHJZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (510,'TGD_ZCLBTZ','资产类别调整','摊销期','2','TXQ',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (511,'TGD_ZCLBTZ','资产类别调整','预提费率','2','YTFL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (547,'TGD_ZCLJZJTZ','资产累计折旧调整','变动后累计折旧','2','BDHLJZJ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (546,'TGD_ZCLJZJTZ','资产累计折旧调整','变动前累计折旧','2','BDQLJZJ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (542,'TGD_ZCLJZJTZ','资产累计折旧调整','变动日期','1','BDRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (544,'TGD_ZCLJZJTZ','资产累计折旧调整','变动原因','1','BDYY',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (545,'TGD_ZCLJZJTZ','资产累计折旧调整','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (541,'TGD_ZCLJZJTZ','资产累计折旧调整','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (543,'TGD_ZCLJZJTZ','资产累计折旧调整','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (540,'TGD_ZCLJZJTZ','资产累计折旧调整','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (585,'TGD_ZCPG','资产评估','备注','1','BZ',40,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (616,'TGD_ZCSYNXTZ','资产使用年限调整','变动前使用年限','2','BDQSYNX',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (688,'TGD_ZCYZBD','资产原值变动','变动前净残值率','2','BDQJCZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (690,'TGD_ZCYZBD','资产原值变动','变动前原值','2','BDQYZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (683,'TGD_ZCYZBD','资产原值变动','变动日期','1','BDRQ',10,0,0,0,0,NULL);

INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (611,'TGD_ZCSYNXTZ','资产使用年限调整','单据号','1','DJH',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (574,'TGD_ZCPG','资产评估','评估后累计折旧','2','PGHLJZJ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (580,'TGD_ZCPG','资产评估','评估后使用年限','2','PGHSYNX',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (572,'TGD_ZCPG','资产评估','评估后原值','2','PGHYZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (581,'TGD_ZCPG','资产评估','评估前工作总量','2','PGQGZZL',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (577,'TGD_ZCPG','资产评估','评估净残值率','2','PGQJCZL',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (575,'TGD_ZCPG','资产评估','评估前净值','2','PGQJZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (573,'TGD_ZCPG','资产评估','评估前累计折旧','2','PGQLJZJ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (579,'TGD_ZCPG','资产评估','评估前使用年限','2','PGQSYNX',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (571,'TGD_ZCPG','资产评估','评估前原值','2','PGQYZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (583,'TGD_ZCPG','资产评估','评估日期','1','PGRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (617,'TGD_ZCSYNXTZ','资产使用年限调整','变动后使用年限','2','BDHSYNX',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (691,'TGD_ZCYZBD','资产原值变动','变动前净残值','2','BDQJCZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (40,'TGD_GDZCKP','固定资产卡片','本期减值准备','2','BQJZZB',15,2,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (41,'TGD_GDZCKP','固定资产卡片','累计减值准备','2','LJJZZB',15,2,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (42,'TGD_GDZCKP','固定资产卡片','减值准备科目','1','JZZBKM',40,NULL,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (799,'TGD_ZJJT','折旧计提','折旧日期','1','ZJRQ',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (720,'TGD_ZCZTBD','使用状况变动','卡片编号','1','KPBH',25,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (760,'TGD_ZJFS','增减方式','增减方式代码','1','DM',3,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (762,'TGD_ZJFS','增减方式','对应入帐科目','1','DYRZKM',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (761,'TGD_ZJFS','增减方式','增减方式名称','1','MC',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (794,'TGD_ZJJT','折旧计提','本月折旧','2','BYZJ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (796,'TGD_ZJJT','折旧计提','分配部门名称','1','FPBMMC',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (801,'TGD_ZJJT','折旧计提','核销标志','2','HXBZ',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (11,'TGD_GDZCKP','固定资产卡片','重估值','2','CGZ',15,2,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (800,'TGD_ZJJT','折旧计提','经手人','1','JSR',10,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (793,'TGD_ZJJT','折旧计提','计提使用年限','2','JTSYNX',2,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (792,'TGD_ZJJT','折旧计提','计提原值','2','JTYZ',9,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX