uas-eis/sql/03_unit_code_dict.sql

-- ============================================================
-- 海关标准计量单位代码数据字典
-- 表名：GW_DATEBASE
-- 格式：insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','代码','名称');
--
-- 说明：海关计量单位代码为3位数字，以下为电子/机械/维修行业常用单位
-- 完整代码表请参考海关总署发布的《计量单位代码表》
-- ============================================================

-- ===== 数量类（常用） =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','001','台');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','002','座');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','003','辆');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','004','艘');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','005','架');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','006','个');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','007','套');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','008','对');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','009','双');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','010','张');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','011','件');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','012','把');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','013','支');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','014','根');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','015','条');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','016','块');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','017','卷');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','018','副');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','019','瓶');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','020','罐');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','021','包');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','022','桶');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','023','袋');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','024','盒');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','025','筐');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','026','箩');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','027','令');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','028','罗');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','029','粒');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','030','枚');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','031','盘');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','032','本');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','033','册');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','034','打');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','035','个');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','036','部');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','037','组');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','038','份');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','039','箱');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','040','批');

-- ===== 长度类 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','051','米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','052','厘米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','053','毫米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','054','千米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','055','英寸');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','056','英尺');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','057','码');

-- ===== 面积类 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','061','平方米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','062','平方厘米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','063','平方毫米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','064','公顷');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','065','亩');

-- ===== 体积类 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','071','立方米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','072','立方厘米');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','073','立方毫米');

-- ===== 容积类 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','081','升');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','082','毫升');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','083','加仑');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','084','蒲式耳');

-- ===== 重量类（常用） =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','091','千克');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','092','克');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','093','毫克');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','094','吨');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','095','公吨');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','096','磅');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','097','盎司');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','098','克拉');

-- ===== 电子/电气类 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','111','千瓦时');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','112','千瓦');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','113','瓦');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','114','伏特');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','115','安培');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','116','欧姆');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','117','赫兹');

-- ===== 数据存储类 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','121','字节');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','122','千字节');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','123','兆字节');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','124','吉字节');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','125','太字节');

-- ===== 动物/植物类 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','131','头');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','132','只');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','133','匹');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','134','峰');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','135','株');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','136','棵');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','137','枝');

-- ===== 其他常用 =====
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','141','套');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','142','组');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','143','批');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','144','项');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','145','次');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','146','人');
insert into GW_DATEBASE(DLC_ID, D_TYPE, DLC_FIELDNAME, D_CODE, V_VALUE) values(GW_DATEBASE_seq.nextval,'申报计量单位','147','户');

commit;

-- ============================================================
-- 说明：
-- 1. 以上为电子/机械/维修行业常用计量单位，共约100条
-- 2. 样例WO101中用到的：001(台)、035(个)
-- 3. 法定计量单位(LawfUnitcd)由HS编码决定，在单一窗口查询HS编码时可看到对应法定单位
-- 4. 申报计量单位(DclUnitcd)企业可自行选择，但需与实际业务一致
-- 5. 如需要完整代码表，请从海关总署官网下载《计量单位代码表》
-- ============================================================