guomao/DOC/DB/01_data/pub_apppar_data.sql

#系统相关
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('机构状态','IM_BRANCH_STATE','0','ZH_CN','激活','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('机构状态','IM_BRANCH_STATE','1','ZH_CN','冻结','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('机构状态','IM_BRANCH_STATE','2','ZH_CN','删除','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','0','ZH_CN','激活','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','2','ZH_CN','暂时停用','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','3','ZH_CN','用户停用','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','4','ZH_CN','永久冻结','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','5','ZH_CN','注销','EBPP','0');
#客户相关
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('系统内外','CUSTOMER_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
('系统内外','CUSTOMER_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
('客户类型','CUSTOMER_BUY_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
('客户类型','CUSTOMER_BUY_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
('客户类型','CUSTOMER_BUY_TYPE','02','ZH_CN','采销客户','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('客户类型','CUSTOMER_BUY_TYPE','03','ZH_CN','仓储客户','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('客户类型','CUSTOMER_BUY_TYPE','04','ZH_CN','运输客户','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('客户类型','CUSTOMER_BUY_TYPE','05','ZH_CN','分公司','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('客户类型','CUSTOMER_BUY_TYPE','06','ZH_CN','保险公司','EBPP','0');
#价格相关
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格类型','PRICE_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
('价格类型','PRICE_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
('价格类型','PRICE_TYPE','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_TYPE','03','ZH_CN','期货价','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格类型','PRICE_TYPE','04','ZH_CN','百川资讯','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格类型','PRICE_TYPE','05','ZH_CN','中营网','EBPP','0');
#地区
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('地区','AREA_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
('地区','AREA_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
('地区','AREA_TYPE','02','ZH_CN','山西','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('地区','AREA_TYPE','03','ZH_CN','河南','EBPP','0');
#通用
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('状态','COMMON_STATE','00','ZH_CN','正常','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('状态','COMMON_STATE','01','ZH_CN','失效','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('状态','COMMON_TWO_STATE','0','ZH_CN','正常','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('状态','COMMON_TWO_STATE','1','ZH_CN','失效','EBPP','0');
#信息相关
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('信息状态','AII_STATE','00','ZH_CN','正常','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('信息状态','AII_STATE','01','ZH_CN','失效','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('信息状态','AII_STATE','02','ZH_CN','隐藏','EBPP','0');
#页面导航一级标题相关
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('一级标题状态','ANI_STATE','0','ZH_CN','正常','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('一级标题状态','ANI_STATE','1','ZH_CN','隐藏','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('一级标题状态','ANI_STATE','2','ZH_CN','失效','EBPP','0');
#页面导航二级标题相关
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('二级标题状态','AND_STATE','0','ZH_CN','正常','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('二级标题状态','AND_STATE','1','ZH_CN','隐藏','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('二级标题状态','AND_STATE','2','ZH_CN','失效','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作结果','HANDLE_RESULT','00000000','ZH_CN','成功','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作结果','HANDLE_RESULT','11111111','ZH_CN','失败','EBPP','0');

#信息相关
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('信息类型','AII_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
('信息类型','AII_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
('信息类型','AII_TYPE','02','ZH_CN','研究报告','EBPP','0');


insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('区域','PB_REGION','00','ZH_CN','华东','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('区域','PB_REGION','01','ZH_CN','华北','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('区域','PB_REGION','02','ZH_CN','华南','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('区域','PB_REGION','03','ZH_CN','华中','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('运输方式','AP_TRANSPORT','00','ZH_CN','敞车','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('运输方式','AP_TRANSPORT','01','ZH_CN','罐车','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('运输方式','AP_TRANSPORT','02','ZH_CN','公路','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('运输方式','AP_TRANSPORT','03','ZH_CN','海运','EBPP','0');


insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同总类型','ACI_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
('合同总类型','ACI_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
('合同类型','ACI_CONTRACT_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
('合同类型','ACI_CONTRACT_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
('合同类型','ACI_CONTRACT_TYPE','02','ZH_CN','期货','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同类型','ACI_CONTRACT_TYPE','03','ZH_CN','月结','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('定价方式','ACI_PRICING_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
('定价方式','ACI_PRICING_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
('定价方式','ACI_PRICING_TYPE','02','ZH_CN','跨月均价','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('定价方式','ACI_PRICING_TYPE','03','ZH_CN','期货月均价','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('定价方式','ACI_PRICING_TYPE','04','ZH_CN','点价','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('定价方式','ACI_PRICING_TYPE','05','ZH_CN','自定义周期','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('定价方式','ACI_PRICING_TYPE','06','ZH_CN','自定义价格','EBPP','0');


insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('价格走势','IS_PRICE','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_PRICE','01','ZH_CN','贴水','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('导航类别','ANI_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
('导航类别','ANI_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
('是否开启','IS_OPEN','1','ZH_CN','开启','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('是否开启','IS_OPEN','0','ZH_CN','关闭','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('库存类型','STOCK_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
('库存类型','STOCK_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
('库存类型','STOCK_TYPE','02','ZH_CN','仓单-期货','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('库存类型','STOCK_TYPE','03','ZH_CN','转库存-库存','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('库存类型','STOCK_TYPE','04','ZH_CN','过户-库存','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('库存类型','STOCK_TYPE','05','ZH_CN','配货库存','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('库存类型','STOCK_TYPE','06','ZH_CN','暂估入库','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('库存类型','STOCK_TYPE','99','ZH_CN','删除','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('收付款类型','AOP_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
('收付款类型','AOP_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
('收付款类型','AOP_TYPE','02','ZH_CN','预付款','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('费用类型','AOP_PRICE_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
('费用类型','AOP_PRICE_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
('费用类型','AOP_PRICE_TYPE','02','ZH_CN','税费','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('费用类型','AOP_PRICE_TYPE','03','ZH_CN','港口费','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('费用类型','AOP_PRICE_TYPE','04','ZH_CN','税金','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('费用类型','AOP_PRICE_TYPE','05','ZH_CN','价格','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('支付类型','AOP_PAY_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
('支付类型','AOP_PAY_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
('支付类型','AOP_PAY_TYPE','02','ZH_CN','微信','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('支付类型','AOP_PAY_TYPE','03','ZH_CN','支付宝','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓库费用类型','COST_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
('仓库费用类型','COST_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
('仓库费用类型','COST_TYPE','02','ZH_CN','现货仓储费','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓库费用类型','COST_TYPE','03','ZH_CN','期货仓储费','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓库费用类型','COST_TYPE','04','ZH_CN','期货入库','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓库费用类型','COST_TYPE','05','ZH_CN','其他费用','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('仓库费用类型','COST_TYPE','10','ZH_CN','期货过户费','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('结算状态','SETTLEMENT_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
('结算状态','SETTLEMENT_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
('运输方式','LOGISTICS_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
('运输方式','LOGISTICS_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
('运输方式','LOGISTICS_TYPE','02','ZH_CN','公路','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('运输方式','LOGISTICS_TYPE','03','ZH_CN','海运','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('运输方式','LOGISTICS_TYPE','04','ZH_CN','铁路集装箱','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓单状态','RECEIPT_STATE','00','ZH_CN','正常','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓单状态','RECEIPT_STATE','01','ZH_CN','退仓储','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓单状态','RECEIPT_STATE','02','ZH_CN','配货状态','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('仓单状态','RECEIPT_STATE','03','ZH_CN','出库','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('入库类型','ENTERING_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
('入库类型','ENTERING_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
('入库类型','ENTERING_TYPE','02','ZH_CN','暂估入库','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('物流状态','LOGISTICS_STATE','00','ZH_CN','出库','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('物流状态','LOGISTICS_STATE','01','ZH_CN','已发货','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('物流状态','LOGISTICS_STATE','02','ZH_CN','运输中','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('物流状态','LOGISTICS_STATE','03','ZH_CN','已到货','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('物流状态','LOGISTICS_STATE','04','ZH_CN','失效','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('物流状态','LOGISTICS_STATE','05','ZH_CN','到港','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('出入库类型','OUT_PUT_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
('出入库类型','OUT_PUT_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
('出入库类型','OUT_PUT_TYPE','02','ZH_CN','仓单','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('出入库类型','OUT_PUT_TYPE','05','ZH_CN','配货库存','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('出入库类型','OUT_PUT_TYPE','06','ZH_CN','暂估入库','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('出入库类型','OUT_PUT_TYPE','07','ZH_CN','更正','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('货物类型','STOCKS_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
('货物类型','STOCKS_TYPE','02','ZH_CN','期货','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('货物类型','STOCKS_TYPE','03','ZH_CN','现货','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('发票类型','INVOICE_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
('发票类型','INVOICE_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
('发票类型','INVOICE_TYPE','02','ZH_CN','其他','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('发票类型','INVOICE_TYPE','03','ZH_CN','税金','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('发票类型','INVOICE_TYPE','04','ZH_CN','仓储费','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业性质','ACI_ENTERPRISE','00','ZH_CN','央企','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业性质','ACI_ENTERPRISE','01','ZH_CN','国有','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业性质','ACI_ENTERPRISE','02','ZH_CN','三资','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业性质','ACI_ENTERPRISE','03','ZH_CN','私营排名前五','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业性质','ACI_ENTERPRISE','04','ZH_CN','集体','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业性质','ACI_ENTERPRISE','05','ZH_CN','私营','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合作年限','ACI_DURATION','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
('合作年限','ACI_DURATION','01','ZH_CN','1年~3年','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合作年限','ACI_DURATION','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
('注册资金','ACI_REGISTERED_CAPITAL','00','ZH_CN','500万~1000万','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('注册资金','ACI_REGISTERED_CAPITAL','01','ZH_CN','1000万以上~1亿','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('注册资金','ACI_REGISTERED_CAPITAL','02','ZH_CN','1亿以上~5亿','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('注册资金','ACI_REGISTERED_CAPITAL','03','ZH_CN','5亿以上','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('下年度预计交易量','ACI_EXPECTED_VOLUME','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
('下年度预计交易量','ACI_EXPECTED_VOLUME','01','ZH_CN','1亿~5亿','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('下年度预计交易量','ACI_EXPECTED_VOLUME','02','ZH_CN','5亿以上','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合作顺畅度','ACI_COOPERATION','00','ZH_CN','顺畅','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合作顺畅度','ACI_COOPERATION','01','ZH_CN','一般','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合作顺畅度','ACI_COOPERATION','02','ZH_CN','阻碍','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('行业内信誉度','ACI_REPUTATIOM','00','ZH_CN','优','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('行业内信誉度','ACI_REPUTATIOM','01','ZH_CN','良','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('行业内信誉度','ACI_REPUTATIOM','02','ZH_CN','较差','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('纳税信用等级','ACI_CREDIT_RATE','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
('纳税信用等级','ACI_CREDIT_RATE','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
('合同兑现率','ACI_CONTRACT_RATE','00','ZH_CN','50%以下','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同兑现率','ACI_CONTRACT_RATE','01','ZH_CN','50%~79%','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同兑现率','ACI_CONTRACT_RATE','02','ZH_CN','80%~99%','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同兑现率','ACI_CONTRACT_RATE','03','ZH_CN','100%','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('年度营业收入','ACI_INCOME','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
('年度营业收入','ACI_INCOME','01','ZH_CN','1亿~15亿','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('年度营业收入','ACI_INCOME','02','ZH_CN','15亿以上','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('净资产','ACI_NET','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
('净资产','ACI_NET','01','ZH_CN','1亿~15亿','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('净资产','ACI_NET','02','ZH_CN','15亿以上','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('利润率','ACI_PROFIT','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
('利润率','ACI_PROFIT','01','ZH_CN','1%~10%','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('利润率','ACI_PROFIT','02','ZH_CN','11%~19%','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('利润率','ACI_PROFIT','03','ZH_CN','20%以上','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('资产负债率','ACI_LIABILITIES_RATIO','00','ZH_CN','40%以下','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('资产负债率','ACI_LIABILITIES_RATIO','01','ZH_CN','40%~69%','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('资产负债率','ACI_LIABILITIES_RATIO','02','ZH_CN','70%以上','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('核定票版信息','ACI_INVOICE','00','ZH_CN','百万元版以下','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('核定票版信息','ACI_INVOICE','01','ZH_CN','百万元版及以上','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('银行信用等级','ACI_BANK_CREDIT','00','ZH_CN','AAA-A级','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('银行信用等级','ACI_BANK_CREDIT','01','ZH_CN','BBB-B级','EBPP','0');

# 消息状态：00 未读取/未处理， 99 已读取/已处理
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('消息状态','MSG_STT_ONE','00','ZH_CN','未读取','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('消息状态','MSG_STT_ONE','99','ZH_CN','已读取','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('消息状态','MSG_STT_TWO','00','ZH_CN','未处理','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('消息状态','MSG_STT_TWO','99','ZH_CN','已处理','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('消息状态','MSG_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
('消息状态','MSG_TYPE','10','ZH_CN','审核消息','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('收付款状态','AOP_STATE','00','ZH_CN','待审核','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('收付款状态','AOP_STATE','01','ZH_CN','正常','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('收付款状态','AOP_STATE','02','ZH_CN','拒绝','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('收付款状态','AOP_STATE','03','ZH_CN','失效','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('调整类型','EDIT_STOCK_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
('调整类型','EDIT_STOCK_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
('费用类型','AWC_TYPE','09','ZH_CN','港杂费','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('费用类型','AWC_TYPE','06','ZH_CN','港建费','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('费用类型','AWC_TYPE','07','ZH_CN','货代费','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('费用类型','AWC_TYPE','08','ZH_CN','堆存费','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','main.html','ZH_CN','空主页','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','home/bussinessManage.html','ZH_CN','业务员','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','home/leaderManage.html','ZH_CN','领导','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','home/homepageManageLv.html','ZH_CN','铝产品主页','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同状态','ACI_STATE','00','ZH_CN','待审核','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同状态','ACI_STATE','01','ZH_CN','已通过','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同状态','ACI_STATE','02','ZH_CN','审核拒绝','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同状态','ACI_STATE','03','ZH_CN','失效','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同状态','ACI_STATE','04','ZH_CN','关闭','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同状态','ACI_STATE','05','ZH_CN','已撤回','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','00','ZH_CN','待审核','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','01','ZH_CN','执行中','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','02','ZH_CN','审核拒绝','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','04','ZH_CN','失效','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','05','ZH_CN','已完成','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('仓库类型','WAREHOUSE_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
('仓库类型','WAREHOUSE_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
('文件资源类型','FILE_RESOURCE_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
('文件资源类型','FILE_RESOURCE_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
('文件资源类型','FILE_RESOURCE_TYPE','02','ZH_CN','订单','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('文件资源类型','FILE_RESOURCE_TYPE','03','ZH_CN','发票','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('文件资源类型','FILE_RESOURCE_TYPE','04','ZH_CN','质检报告','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('文件资源类型','FILE_RESOURCE_TYPE','05','ZH_CN','轮播图','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('文件资源类型','FILE_RESOURCE_TYPE','06','ZH_CN','广告图','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('文件类型','FILE_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
('文件类型','FILE_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
('文件类型','FILE_TYPE','02','ZH_CN','视频','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('文件类型','FILE_TYPE','03','ZH_CN','压缩包','EBPP','0');


insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('信息内容上传方式','AII_CONTENT_TYPE','00','ZH_CN','WORD上传','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('信息内容上传方式','AII_CONTENT_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
('合同模板业务类型','ACM_BUSINESS_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
('合同模板业务类型','ACM_BUSINESS_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
('合同模板类型','ACM_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
('合同模板类型','ACM_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
('合同模板类型','ACM_TYPE','02','ZH_CN','期货合同','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('是','SUMMARY_NUMBER','00','ZH_CN','是','EBPP','0');


insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同发运方式','TRANSPORT_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
('合同发运方式','TRANSPORT_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
('合同发运方式','TRANSPORT_TYPE','02','ZH_CN','汽车','EBPP','0');


#合同货物形式
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('合同货物形式','HW_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
('合同货物形式','HW_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
('是否到货','IS_ARRIVAL','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_ARRIVAL','01','ZH_CN','已到货','EBPP','0');

#是否确认
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('是否确认','IS_CONFIRM','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_CONFIRM','01','ZH_CN','已确认','EBPP','0');

#到货类型
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('到货类型','DH_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
('到货类型','DH_TYPE','02','ZH_CN','直发到厂','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('到货类型','DH_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
('支付类型','PAY_UNIT','00','ZH_CN','代付','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('支付类型','PAY_UNIT','01','ZH_CN','自付','EBPP','0');

#是否开票
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('是否开票','KAIPIAO_STATE','00','ZH_CN','未开票','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('是否开票','KAIPIAO_STATE','01','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','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, 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
('供应类型','SUPPLY_CHAIN_TYPE','00','ZH_CN','供应链','EBPP','0','00001');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG, APR_PROJECT_CODE) values
('供应类型','SUPPLY_CHAIN_TYPE','01','ZH_CN','仓单质押','EBPP','0','00001');