guomao/DOC/DB/bj/bj.sql

#汇率管理
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('340001','汇率管理','exchangeRateManage/exchangeRateManage.html','3','0',NULL,'1','2','0','#xe605;');

insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M37000','汇率管理','汇率查看--北京','F07000','0','2','12',NULL);

insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M37000','340001');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('34000101','编辑汇率','ExchangeRateManageAction/exchangerateUpdate','1','0',NULL,'1','2','0','#xe612;');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('34000102','删除汇率','ExchangeRateManageAction/exchangerateDelete','1','0',NULL,'1','2','0','#xe612;');

#国外合同
insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M39000','国外合同管理','北京公司国外合同的管理','F08000','0','2','11',NULL);

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('390001','国外合同管理','contractManage/foreignContractManage.html','1','0',NULL,'1','2','0','#xe605;');

insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M39000','390001');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('39000101','新增合同','ContractManageAction/addForeignContracts.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('39000102','删除合同','ContractManageAction/deleteContract','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('39000103','删除合同详情','ContractManageAction/deletConDetail','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('39000104','修改合同','ContractManageAction/updateContract.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('39000105','新增订单','OrderManageAction/addFreightOrder.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('39000106','撤回合同','ContractManageAction/recallContract','1','0',NULL,'1','2','0','#xe612;');
#国内采购
insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M40000','国内采购合同管理','北京公司国内采购合同的管理','F08000','0','2','13',NULL);
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('400001','国内采购合同管理','contractManage/domesticProcureContractManage.html','1','0',NULL,'1','2','0','#xe605;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('40000101','新增国内采购合同','DomesticContractManageAction/addDomesticPurContracts.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('40000102','修改国内采购合同','DomesticContractManageAction/updateDomesticPurContracts.pmss','1','0',NULL,'1','2','0','#xe612;');

#国内销售
insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M41000','410001');

insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M41000','国内销售合同管理','北京公司国内销售合同的管理','F08000','0','2','14',NULL);

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('410001','国内销售合同管理','contractManage/salesContractManage.html','1','0',NULL,'1','2','0','#xe605;');


insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('41000101','新增销售合同','DomesticContractManageAction/addSalesContracts.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('41000102','修改销售合同','DomesticContractManageAction/updateSalesContracts.pmss','1','0',NULL,'1','2','0','#xe612;');

#订单管理
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('420001','国外采购订单管理','orderManage/freightOrderManage.html?abroad=01','1','0',NULL,'1','2','0','#xe605;');

insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M42000','420001');

insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M42000','国外采购订单管理','北京公司的国外采购订单管理','F08000','0','2','15',NULL);

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('42000101','删除订单详情','OrderManageAction/deleteOrderDetail','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('42000102','编辑订单','OrderManageAction/editOrder.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('42000103','新增报关单','OrderManageAction/addDeclarationForm','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('42000104','新增报关单','CustomDeclaratManageAction/deleteCustomDeclarat','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('42000105','修改报关单','CustomDeclaratManageAction/saveCustomDeclarat','1','0',NULL,'1','2','0','#xe612;');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('450001','国内采购订单管理','orderManage/freightOrderManage.html?abroad=00','1','0',NULL,'1','2','0','#xe605;');

insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M45000','国内采购订单管理','北京公司的国内采购订单管理','F08000','0','2','18',NULL);

insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M45000','450001');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('45000101','新增国内采购订单','DomesticOrderManageAction/addDomesticOrder.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('45000102','编辑国内采购订单','DomesticOrderManageAction/editDomesticOrder.pmss','1','0',NULL,'1','2','0','#xe612;');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('460001','国内销售订单管理','orderManage/saleOrderManage.html','1','0',NULL,'1','2','0','#xe605;');

insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M46000','国内销售订单管理','北京公司的国内销售订单管理','F08000','0','2','19',NULL);

insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M46000','460001');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('46000101','新增国内销售订单','DomesticOrderManageAction/addSaleOrder.pmss','1','0',NULL,'1','2','0','#xe612;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('46000102','编辑国内销售订单','DomesticOrderManageAction/editSaleOrder.pmss','1','0',NULL,'1','2','0','#xe612;');


#财务管理
insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M44000','4400001');
insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M44000','财务管理','财务管理','F08000','0','2','17',NULL);
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('4400001','收付款管理','collectPayManage/collectPayManage.html','1','0',NULL,'1','2','0','#xe605;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('44000101','新增付款','collectPayManage/addCollectPayManage.pmss','1','0',NULL,'1','2','0','#xe612;');

#sequence
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS)
values('ORDER_DETAIL_ID','1000000000','1','1000000000','99999999999','订单详情编号');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS)
values('IMPORT_DETAIL_ID','1000000000','1','1000000000','99999999999','报关单编号');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS)
values('CONTRACT_RESOURCE_ID','1000000000','1','1000000000','99999999999','合同附件信息表编号');

#关税类型
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('关税类型','TARIFF_TYPE','00','ZH_CN','重量*关税税率','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('关税类型','TARIFF_TYPE','01','ZH_CN','重量*单价*关税税率','EBPP','0');

#所属国家
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('所属国家','COUNTRY_ORIGIN','00','ZH_CN','俄罗斯','EBPP','0');

#贸易方式
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('贸易方式','MODE_TRADE','00','ZH_CN','一般贸易','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('贸易方式','MODE_TRADE','01','ZH_CN','转口贸易','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('贸易方式','MODE_TRADE','02','ZH_CN','代理模式贸易','EBPP','0');

#价格条款
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格条款','PRICE_TERMS','00','ZH_CN','DAP','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格条款','PRICE_TERMS','01','ZH_CN','CIF','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格条款','PRICE_TERMS','02','ZH_CN','CFR','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格条款','PRICE_TERMS','03','ZH_CN','FOB','EBPP','0');

#运输方式
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('运输方式','TYPE_SHIPPING','00','ZH_CN','船运','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('运输方式','TYPE_SHIPPING','01','ZH_CN','铁路','EBPP','0');

#起运港
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('起运港','PORT_DEPARTURE','00','ZH_CN','港口1','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('起运港','PORT_DEPARTURE','01','ZH_CN','港口2','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('起运港','PORT_DEPARTURE','02','ZH_CN','港口3','EBPP','0');

#卸货港
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('卸货港','PORT_DISCHARGE','00','ZH_CN','港口A','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('卸货港','PORT_DISCHARGE','01','ZH_CN','港口B','EBPP','0');


#是否预付/是否赊销
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('是否预付/是否赊销','IS_PREPAID','00','ZH_CN','是','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('是否预付/是否赊销','IS_PREPAID','01','ZH_CN','否','EBPP','0');

#交货方式
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货方式','MODE_DELIVERY','00','ZH_CN','码头自提','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货方式','MODE_DELIVERY','01','ZH_CN','库内货转','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货方式','MODE_DELIVERY','02','ZH_CN','库内自提','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货方式','MODE_DELIVERY','03','ZH_CN','码头送柜','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货方式','MODE_DELIVERY','04','ZH_CN','铁路运输','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货方式','MODE_DELIVERY','05','ZH_CN','汽车运输','EBPP','0');

#交货地
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货地','DELIVERY_POINTS','00','ZH_CN','港口1','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货地','DELIVERY_POINTS','01','ZH_CN','港口2','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('交货地','DELIVERY_POINTS','02','ZH_CN','港口3','EBPP','0');


#仓储信息
insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('F09000','仓储信息','仓储管理-北京','M00000','0','1','3',NULL);
insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
values('M43000','仓储管理','北京公司创建仓库等操作','F09000','0','2','0',NULL);

#收付款详情主键
insert into `sequence` (`SEQ_NAME`, `CURRENT_VAL`, `INCREMENT_VAL`, `MIN_VAL`, `MAX_VAL`, `REMARKS`) values('ACE_ID','1000000000','1','1000000000','99999999999','收付款详情主键');

#报表信息
INSERT INTO `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
VALUES('F10000','报表信息','报表管理-北京','M00000','0','1','4',NULL);

INSERT INTO `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) 
VALUES('M47000','统计管理','统计管理','F10000','0','2','18',NULL);

INSERT INTO im_menu_item_rel (MIR_MENUID, MIR_ITEMID) VALUES('M47000','470001');

INSERT INTO im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) VALUES
('470001','进口统计表','reportManage/importStatistics.html','1','0',NULL,'1','2','0','#xe604;');

#审批
INSERT INTO im_menu_item_rel (MIR_MENUID, MIR_ITEMID) VALUES('M38000','350003');
INSERT INTO im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) VALUES
('350003','出入库单审批','approvalManage/approvalOfFinance.html','3','0',NULL,'1','2','0','#xe604;');
#是否已开入库单
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG, APR_PROJECT_CODE) values
('是否已开入库单','FINANCE_YESORNO','0','ZH_CN','否','EBPP','0','00002');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG, APR_PROJECT_CODE) values
('是否已开入库单','FINANCE_YESORNO','1','ZH_CN','是','EBPP','0','00002');

#付汇方式
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`, `APR_PROJECT_CODE`) values('付汇方式','PAYMENT_METHOD','00','ZH_CN','电汇','EBPP','0','00002');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`, `APR_PROJECT_CODE`) values('付汇方式','PAYMENT_METHOD','01','ZH_CN','电子承兑','EBPP','0','00002');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`, `APR_PROJECT_CODE`) values('付汇方式','PAYMENT_METHOD','02','ZH_CN','信用证','EBPP','0','00002');


/**入库单*/
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS)
values('ap_finance_id','1000000000','1','1000000000','99999999999','入库单');


#审批表状态
INSERT INTO `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`, `APR_PROJECT_CODE`) VALUES('审批表状态','APPROVAL_FORM_STATE','0','ZH_CN','审核中','EBPP','0','00002');
INSERT INTO `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`, `APR_PROJECT_CODE`) VALUES('审批表状态','APPROVAL_FORM_STATE','1','ZH_CN','未通过','EBPP','0','00002');
INSERT INTO `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`, `APR_PROJECT_CODE`) VALUES('审批表状态','APPROVAL_FORM_STATE','2','ZH_CN','已通过','EBPP','0','00002');


#入库操作指示
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG, APR_PROJECT_CODE) values
('入库操作指示','IN_OPERATION_INSTRUCTION','00','ZH_CN','入库','EBPP','0','00002');

#出库操作指示
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG, APR_PROJECT_CODE) values
('出库操作指示','OUT_OPERATION_INSTRUCTION','00','ZH_CN','码头送柜','EBPP','0','00002');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG, APR_PROJECT_CODE) values
('出库操作指示','OUT_OPERATION_INSTRUCTION','01','ZH_CN','库提','EBPP','0','00002');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG, APR_PROJECT_CODE) values
('出库操作指示','OUT_OPERATION_INSTRUCTION','02','ZH_CN','货权转移','EBPP','0','00002');