固定资产管理_分类.sql

INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (1, '1', '房屋及建筑物', 1, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (2, '101', '房屋及建筑物', 2, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (3, '2', '专用设备', 3, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (4, '201', '网络设备', 4, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (5, '202', '炊事设备', 5, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (6, '203', '教学仪器', 6, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (7, '204', '其他专用设备', 7, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (8, '3', '一般设备', 8, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (9, '301', '家具', 9, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (10, '302', '电子计算机及外围设备', 10, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (11, '303', '通讯设备', 11, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (12, '304', '广播电视设备', 12, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (13, '305', '文艺设备', 13, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (14, '306', '体育设备', 14, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (15, '307', '娱乐设备', 15, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (16, '308', '被服设备', 16, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (17, '309', '家用电器', 17, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (18, '310', '办公设备', 18, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (19, '311', '其他一般设备', 19, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (20, '4', '文物陈列品', 20, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (21, '401', '文物陈列品', 21, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (22, '5', '图书', 22, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (23, '501', '图书', 23, '1');
INSERT INTO ZICHANG (ID, DM, MC, SERIAL, ISLB)
             VALUES (24, '6', '其他', 24, '1');

COMMIT WORK;

原文地址:https://www.cnblogs.com/shiningrise/p/1424063.html