/*
 Navicat Premium Data Transfer

 Source Server         : 40.73.78.157
 Source Server Type    : SQL Server
 Source Server Version : 11002100
 Source Host           : 40.73.78.157:1433
 Source Catalog        : IClearDev
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11002100
 File Encoding         : 65001

 Date: 21/01/2022 16:38:26
*/


-- ----------------------------
-- Table structure for T_ICLEAR_API_APPINFO 身份认证表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[T_ICLEAR_API_APPINFO]') AND type IN ('U'))
	DROP TABLE [dbo].[T_ICLEAR_API_APPINFO]
GO

CREATE TABLE [dbo].[T_ICLEAR_API_APPINFO] (
  [ID] int  NOT NULL,
  [APPID] varchar(40) COLLATE Chinese_PRC_CI_AS  NULL,
  [APPKEY] varchar(40) COLLATE Chinese_PRC_CI_AS  NULL,
  [SECURITY] varchar(16) COLLATE Chinese_PRC_CI_AS  NULL,
  [CREATE_TIME] date  NULL,
  [IS_ENABLE] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[T_ICLEAR_API_APPINFO] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'PK',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_APPINFO',
'COLUMN', N'ID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_APPINFO',
'COLUMN', N'APPID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'功能权限',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_APPINFO',
'COLUMN', N'APPKEY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_APPINFO',
'COLUMN', N'SECURITY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_APPINFO',
'COLUMN', N'CREATE_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否有效    1 有效   0 无效',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_APPINFO',
'COLUMN', N'IS_ENABLE'
GO


-- ----------------------------
-- Primary Key structure for table T_ICLEAR_API_APPINFO
-- ----------------------------
ALTER TABLE [dbo].[T_ICLEAR_API_APPINFO] ADD CONSTRAINT [PK__T_ICLEAR__3214EC27D61E172D] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

-------------------------------------------------------------------
/*
 Navicat Premium Data Transfer

 Source Server         : 40.73.78.157
 Source Server Type    : SQL Server
 Source Server Version : 11002100
 Source Host           : 40.73.78.157:1433
 Source Catalog        : IClearDev
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11002100
 File Encoding         : 65001

 Date: 21/01/2022 16:41:25
*/


-- ----------------------------
-- Table structure for T_ICLEAR_API_LOG 请求接口数据日志
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[T_ICLEAR_API_LOG]') AND type IN ('U'))
	DROP TABLE [dbo].[T_ICLEAR_API_LOG]
GO

CREATE TABLE [dbo].[T_ICLEAR_API_LOG] (
  [MSGID] int  IDENTITY(1,1) NOT NULL,
  [MSG_TYPE] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [APPID] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [APPKEY] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [CREATE_TIME] datetime  NULL,
  [PUSH_TIME] datetime  NULL,
  [RECEIVE_RESULT] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [ERROR_CODE] varchar(10) COLLATE Chinese_PRC_CI_AS  NULL,
  [RESPONSE_TIME] datetime  NULL,
  [SPEND_TIME] numeric(5)  NULL,
  [SENDTIMES] int  NULL,
  [BILLNO] varchar(300) COLLATE Chinese_PRC_CI_AS  NULL,
  [CONTRNO] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[T_ICLEAR_API_LOG] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'PK',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'MSGID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'消息类型',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'MSG_TYPE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'APPID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'功能权限',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'APPKEY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间 ',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'CREATE_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'推送时间',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'PUSH_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接收数据的结果',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'RECEIVE_RESULT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'错误代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'ERROR_CODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'响应时间',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'RESPONSE_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接收数据用时 单位ms',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'SPEND_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'推送次数',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'SENDTIMES'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运单号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'BILLNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'合同号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_LOG',
'COLUMN', N'CONTRNO'
GO


-- ----------------------------
-- Primary Key structure for table T_ICLEAR_API_LOG
-- ----------------------------
ALTER TABLE [dbo].[T_ICLEAR_API_LOG] ADD CONSTRAINT [PK__T_ICLEAR__2091A51C0AAEF3B7] PRIMARY KEY CLUSTERED ([MSGID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
------------------------------------------------------------------------------------------------------------------------
/*
 Navicat Premium Data Transfer

 Source Server         : 40.73.78.157
 Source Server Type    : SQL Server
 Source Server Version : 11002100
 Source Host           : 40.73.78.157:1433
 Source Catalog        : IClearDev
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11002100
 File Encoding         : 65001

 Date: 21/01/2022 16:41:48
*/


-- ----------------------------
-- Table structure for T_ICLEAR_API_MAWB 运单表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[T_ICLEAR_API_MAWB]') AND type IN ('U'))
	DROP TABLE [dbo].[T_ICLEAR_API_MAWB]
GO

CREATE TABLE [dbo].[T_ICLEAR_API_MAWB] (
  [ID] int  IDENTITY(1,1) NOT NULL,
  [MSGID] int  NULL,
  [APPID] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [IEFlag] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [TYPE] varchar(6) COLLATE Chinese_PRC_CI_AS  NULL,
  [AGENTCODE] varchar(18) COLLATE Chinese_PRC_CI_AS  NULL,
  [AGENTNAME] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [BILLNO] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [CONTRNO] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [CUSTOMMASTER] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [CUTMODE] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [DECLTRNREL] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [DISTINATEPORT] varchar(6) COLLATE Chinese_PRC_CI_AS  NULL,
  [EDIID] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [ENTRYID] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [FEECURR] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [FEEMARK] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [FEERATE] numeric(29,10)  NULL,
  [CROSSWET] numeric(29,10)  NULL,
  [IEPORT] varchar(4) COLLATE Chinese_PRC_CI_AS  NULL,
  [INPUTERNAME] varchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [INSURCURR] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [INSURMARK] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [INSURRATE] numeric(29,10)  NULL,
  [MANUALNO] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [NETWT] numeric(29,10)  NULL,
  [OTHERCURR] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [OTHERRATE] numeric(29,10)  NULL,
  [OTHERMARK] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [OWNERCODE] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [OWNERNAME] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [PACKNO] numeric(8)  NULL,
  [PREENTRYID] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRADECOUNTRY] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRADEMODE] varchar(4) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRADECODE] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRAFMODE] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRADENAME] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRANSMODE] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [WRAPTYPE] varchar(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRADECODESCC] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [OWNERCODESCC] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [TRADEAREACODE] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [MARKNO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ENTYPORTCODE] varchar(8) COLLATE Chinese_PRC_CI_AS  NULL,
  [GOODSPLACE] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [DECLARENAME] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [OVERSEASCONSIGNORCODE] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [OVERSEASCONSIGNEECODE] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [OVERSEASCONSIGNEEENAME] varchar(150) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
  [CONSIGNMENTCODEID] bigint  NULL,
  [EANNO] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[T_ICLEAR_API_MAWB] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'PK',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'ID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'消息ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'MSGID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'APPID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'进出口标志',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'IEFlag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'报关类型',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TYPE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申报单位代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'AGENTCODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申报单位名称',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'AGENTNAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'提单号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'BILLNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'合同号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'CONTRNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'主管海关（申报地海关）',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'CUSTOMMASTER'
GO

EXEC sp_addextendedproperty
'MS_Description', N'征免性质',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'CUTMODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'报关/转关关系标志',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'DECLTRNREL'
GO

EXEC sp_addextendedproperty
'MS_Description', N'经停港/指运港',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'DISTINATEPORT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'报关标志',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'EDIID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'海关编号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'ENTRYID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运费币制',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'FEECURR'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运费标记',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'FEEMARK'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运费／率',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'FEERATE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'毛重',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'CROSSWET'
GO

EXEC sp_addextendedproperty
'MS_Description', N'出入境关闭',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'IEPORT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'录入人名称',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'INPUTERNAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'保险费币制',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'INSURCURR'
GO

EXEC sp_addextendedproperty
'MS_Description', N'保险费标记',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'INSURMARK'
GO

EXEC sp_addextendedproperty
'MS_Description', N'保险费／率',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'INSURRATE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备案号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'MANUALNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'净重',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'NETWT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'杂费币制',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OTHERCURR'
GO

EXEC sp_addextendedproperty
'MS_Description', N'杂费／率',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OTHERRATE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'杂费标志',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OTHERMARK'
GO

EXEC sp_addextendedproperty
'MS_Description', N'消费使用/生产销售单位代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OWNERCODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'消费使用/生产销售单位名称',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OWNERNAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'件数',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'PACKNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'预录入编号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'PREENTRYID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'启运国/运抵国',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRADECOUNTRY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'监管方式',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRADEMODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'境内收发货人编号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRADECODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运输方式代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRAFMODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'境内收发货人名称',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRADENAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'成交方式',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRANSMODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'包装种类',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'WRAPTYPE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产核销单位统一信用代码---报关形式类型',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRADECODESCC'
GO

EXEC sp_addextendedproperty
'MS_Description', N'消费使用/生产销售单位单位统一编码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OWNERCODESCC'
GO

EXEC sp_addextendedproperty
'MS_Description', N'贸易国别',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'TRADEAREACODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标记及号码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'MARKNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'入境口岸代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'ENTYPORTCODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'入境口岸代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'GOODSPLACE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申报人员姓名---报关员证号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'DECLARENAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'境外发货人代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OVERSEASCONSIGNORCODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'境外收货人编码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OVERSEASCONSIGNEECODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'境外收货人名称(外文)',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'OVERSEASCONSIGNEEENAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运单ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'CONSIGNMENTCODEID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'EANNo',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWB',
'COLUMN', N'EANNO'
GO


-- ----------------------------
-- Primary Key structure for table T_ICLEAR_API_MAWB
-- ----------------------------
ALTER TABLE [dbo].[T_ICLEAR_API_MAWB] ADD CONSTRAINT [PK__T_ICLEAR__3214EC27FAF18BF6] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

------------------------------------------------------------------------------------------------------------------------
/*
 Navicat Premium Data Transfer

 Source Server         : 40.73.78.157
 Source Server Type    : SQL Server
 Source Server Version : 11002100
 Source Host           : 40.73.78.157:1433
 Source Catalog        : IClearDev
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11002100
 File Encoding         : 65001

 Date: 21/01/2022 16:41:57
*/


-- ----------------------------
-- Table structure for T_ICLEAR_API_MAWBDETAIL 运单明细
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[T_ICLEAR_API_MAWBDETAIL]') AND type IN ('U'))
	DROP TABLE [dbo].[T_ICLEAR_API_MAWBDETAIL]
GO

CREATE TABLE [dbo].[T_ICLEAR_API_MAWBDETAIL] (
  [ID] int  IDENTITY(1,1) NOT NULL,
  [MSGID] int  NULL,
  [MAWBID] int  NULL,
  [DETAILID] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [CLASSMARK] varchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [CODETS] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DECLPRICE] numeric(29,10)  NULL,
  [DECLTOTAL] numeric(29,10)  NULL,
  [DUTYMODE] varchar(4) COLLATE Chinese_PRC_CI_AS  NULL,
  [EXGNO] varchar(30) COLLATE Chinese_PRC_CI_AS  NULL,
  [EXGVERSION] varchar(8) COLLATE Chinese_PRC_CI_AS  NULL,
  [FIRSTUNIT] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [FIRSTQTY] numeric(19,5)  NULL,
  [GUNIT] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [GMODE] varchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [GNAME] varchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [GNO] numeric(19)  NULL,
  [GQTY] numeric(19,5)  NULL,
  [ORIGINCURRENTY] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [SECONDUNIT] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [SECONDQTY] numeric(19,5)  NULL,
  [TRADECURR] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [USETO] varchar(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [WORKUSD] numeric(19,4)  NULL,
  [DESTINATIONCOUNTRY] varchar(3) COLLATE Chinese_PRC_CI_AS  NULL,
  [CIQCODE] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [DECLGOODSENAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [DESTCODE] varchar(8) COLLATE Chinese_PRC_CI_AS  NULL,
  [DISTRICTCODE] varchar(5) COLLATE Chinese_PRC_CI_AS  NULL,
  [DECLAREDWEIGHT] numeric(19)  NULL
)
GO

ALTER TABLE [dbo].[T_ICLEAR_API_MAWBDETAIL] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'PK',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'ID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'消息ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'MSGID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'主单ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'MAWBID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'明细ID',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DETAILID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'归类标志',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'CLASSMARK'
GO

EXEC sp_addextendedproperty
'MS_Description', N'商品编号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'CODETS'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申报单价',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DECLPRICE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申报总价',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DECLTOTAL'
GO

EXEC sp_addextendedproperty
'MS_Description', N'征免方式',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DUTYMODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'货号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'EXGNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'版本号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'EXGVERSION'
GO

EXEC sp_addextendedproperty
'MS_Description', N'第一计量单位（法定单位）',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'FIRSTUNIT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'第一法定数量',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'FIRSTQTY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'成交计量单位',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'GUNIT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'商品规格、型号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'GMODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'商品名称',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'GNAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'商品序号',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'GNO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'成交数量',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'GQTY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'原产国',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'ORIGINCURRENTY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'第二计量单位',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'SECONDUNIT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'第二法定数量',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'SECONDQTY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'成交币制',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'TRADECURR'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用途/生产厂家',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'USETO'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工缴费',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'WORKUSD'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最终目的国（地区）',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DESTINATIONCOUNTRY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'检验检疫编',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'CIQCODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申报货物英文名称',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DECLGOODSENAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'目的地代码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DESTCODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'境内目的地/境内货源地',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DISTRICTCODE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申报重量',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_MAWBDETAIL',
'COLUMN', N'DECLAREDWEIGHT'
GO


-- ----------------------------
-- Primary Key structure for table T_ICLEAR_API_MAWBDETAIL
-- ----------------------------
ALTER TABLE [dbo].[T_ICLEAR_API_MAWBDETAIL] ADD CONSTRAINT [PK__T_ICLEAR__3214EC27295588F6] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

------------------------------------------------------------------------------------------------------------------------

INSERT INTO T_ICLEAR_API_APPINFO VALUES(1,'IDE','iClearExport','89b358b0cc07788c',GETDATE(),'1');
insert INTO T_ICLEAR_API_APPINFO VALUES(2,'BASF','iClearExportC','9496c3df094023ce',GETDATE(),'1');

alter table T_CHM_CONSIGNMENT ADD EANNO varchar(100);

alter table T_DECLEAR_TASK ADD DECELEAR_INFO_ID varchar(50);

---ALTER TABLE T_ICLEAR_API_MAWB ADD SOURCE_TYPE VARCHAR(10);
ALTER TABLE T_CHM_CONSIGNMENT_DETAIL ADD DETAILID VARCHAR(50);


------------------------------------------------------------------------------------------------------------------------
---海关编码
INSERT INTO T_BI_DICTIONARY(CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,PARENT_ID) VALUES('customsNo','海关编码','customsNo','海关编码',1,23)

--INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0101','PVG','PVG','PVG',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5001,'port_pvg','0101')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0101','PEK','PEK','PEK',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5002,'port_pek','0101')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0207','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5003,'port_tsn','0207')



INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0200','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5004,'port_tsn','0200')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0201','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5005,'port_tsn','0201')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0202','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5006,'port_tsn','0202')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0203','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5007,'port_tsn','0203')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0204','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5008,'port_tsn','0204')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0205','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5009,'port_tsn','0205')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0206','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5010,'port_tsn','0206')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0208','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5011,'port_tsn','0208')


INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0209','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5012,'port_tsn','0209')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0210','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5013,'port_tsn','0210')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0211','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5014,'port_tsn','0211')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0212','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5015,'port_tsn','0212')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0213','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5016,'port_tsn','0213')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0214','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5017,'port_tsn','0214')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0215','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5018,'port_tsn','0215')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0216','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5019,'port_tsn','0216')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0217','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5200,'port_tsn','0217')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0218','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5021,'port_tsn','0218')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0219','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5022,'port_tsn','0219')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0220','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5023,'port_tsn','0220')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0221','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5024,'port_tsn','0221')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0222','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5025,'port_tsn','0222')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0223','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5026,'port_tsn','0223')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0224','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5027,'port_tsn','0224')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0225','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5028,'port_tsn','0225')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0226','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5029,'port_tsn','0226')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0227','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5030,'port_tsn','0227')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0228','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5031,'port_tsn','0228')

INSERT INTO T_BI_DICTIONARY_ENTRIES (CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL,EXT2,EXT6) VALUES('0229','TSN','TSN','TSN',1,(SELECT ID FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),(SELECT CODE FROM T_BI_DICTIONARY WHERE CHINESE_NAME ='海关编码'),5032,'port_tsn','0229')