DOC/3设计阶段/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_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
('订单逾期状态','ORDER_OVERDUE_STT','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_OVERDUE_STT','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_STT','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_STT','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_STT','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_STT','03','ZH_CN','审批中','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','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_STT','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_STT','06','ZH_CN','合同已签署','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','10','ZH_CN','预付款已支付 ','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','11','ZH_CN','已支付供应商订货款','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','12','ZH_CN','货品生产完成','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','13','ZH_CN','已支付供应商尾款','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','20','ZH_CN','运输中','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','21','ZH_CN','货品已入库','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','22','ZH_CN','业务已结束','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STT','99','ZH_CN','冻结','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业状态','COMPANY_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
('企业状态','COMPANY_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
('企业状态','COMPANY_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
('企业状态','COMPANY_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
('企业状态','COMPANY_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
('企业状态','COMPANY_STATE','06','ZH_CN','审批通过','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业状态','COMPANY_STATE','07','ZH_CN','审批未通过','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业评级','COMPANY_LEVEL','A','ZH_CN','A','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业评级','COMPANY_LEVEL','B','ZH_CN','B','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业评级','COMPANY_LEVEL','C','ZH_CN','C','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('企业评级','COMPANY_LEVEL','D','ZH_CN','D','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('物流状态','LOGISTICS_STT','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_STT','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_STT','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_STT','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_STT','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_STT','05','ZH_CN','国外已报关','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('物流状态','LOGISTICS_STT','06','ZH_CN','国外已开航','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('物流状态','LOGISTICS_STT','07','ZH_CN','国内已报关','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('物流状态','LOGISTICS_STT','08','ZH_CN','国内运输中','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('物流状态','LOGISTICS_STT','09','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','main.html','ZH_CN','经理主页','EBPP','2');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','customerManagerCenter/customerManagerCenter.html','ZH_CN','客户经理主页','EBPP','2');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','financeManage/financeManage.html','ZH_CN','财务主页','EBPP','2');



insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_SHOWMSG, APR_TYPE) 
values('消息状态','NEWS_STATUS','0','启用','EBPP');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_SHOWMSG, APR_TYPE) 
VALUES('消息状态','NEWS_STATUS','1','停用','EBPP');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_SHOWMSG, APR_TYPE) 
VALUES('消息状态','NEWS_STATUS','2','定时启用','EBPP');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_SHOWMSG, APR_TYPE) 
VALUES('消息所属模块','NEWS_MODULE_STATUS','01','合作企业','EBPP');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_SHOWMSG, APR_TYPE) 
VALUES('消息所属模块','NEWS_MODULE_STATUS','02','资讯','EBPP');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('风控审批状态','APPROVER_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
('风控审批状态','APPROVER_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
('风控审批状态','APPROVER_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
('科目类型','SUBJECTS_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
('科目类型','SUBJECTS_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
('科目类型','SUBJECTS_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
('科目类型','SUBJECTS_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
('科目类型','SUBJECTS_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
('科目类型','SUBJECTS_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
('科目类型','SUBJECTS_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
('科目类型','SUBJECTS_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
('收支类型','TRADE_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
('收支类型','TRADE_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('审批状态','APPROVE_AUTH_STT','00','ZH_CN','风控审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','01','ZH_CN','风控经理审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','02','ZH_CN','风控总监审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','03','ZH_CN','财务审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','04','ZH_CN','分管领导审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','05','ZH_CN','总经理审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','90','ZH_CN','客户经理审批','EBPP','0');


insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批结果','APPROVE_AUTH_RESULT','0','ZH_CN','通过','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批结果','APPROVE_AUTH_RESULT','1','ZH_CN','拒绝','EBPP','0');

insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('操作类型','OPERATION_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('操作类型','OPERATION_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_SUSTOMER_MANAGER','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_SUSTOMER_MANAGER','01','ZH_CN','是','EBPP','0');


INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','00','ZH_CN','申请已提交','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','01','ZH_CN','申请已受理','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','02','ZH_CN','估值不通过','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','03','ZH_CN','审批中','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','04','ZH_CN','审批通过','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','05','ZH_CN','审批拒绝','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','06','ZH_CN','合同已签署','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','10','ZH_CN','预付款已支付 ','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','11','ZH_CN','货品生产中','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','12','ZH_CN','货品生产完成','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','13','ZH_CN','已支付供应商尾款','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','20','ZH_CN','运输中','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','21','ZH_CN','货品已入库','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('订单状态','TP_ORDER_STT','22','ZH_CN','业务已结束','EBPP','0');



INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_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
('币种','CURRENCY_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
('币种','CURRENCY_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
('币种','CURRENCY_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
('币种','CURRENCY_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
('币种','CURRENCY_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
('币种','CURRENCY_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
('币种','CURRENCY_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
('币种','CURRENCY_TYPE','08','ZH_CN','人民币','EBPP','0');