CREATE TABLE T_ICLEAR_API_APPINFO(
     ID int IDENTITY(1,1) NOT NULL PRIMARY KEY
    ,APPID VARCHAR(40)
    ,APPKEY VARCHAR(40)
    ,SECURITY VARCHAR(16)
    ,CREATE_TIME DATE
    ,IS_ENABLE VARCHAR(1)
)

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

INSERT INTO T_ICLEAR_API_APPINFO VALUES('IDE','iClearExport','b92131f03f19a348',GETDATE(),'1');

INSERT INTO T_ICLEAR_API_APPINFO VALUES('BASF','iClearExportC','6db193cb4165a71b',GETDATE(),'1');

CREATE TABLE T_ICLEAR_API_LOG(
     MSGID int identity(1,1) primary key      --PK
    ,MSG_TYPE VARCHAR(20)      --类型: C  D
    ,APPID VARCHAR(20)           --用户ID
    ,APPKEY VARCHAR(20)          --用户key
    ,CREATE_TIME datetime    --创建时间
    ,PUSH_TIME datetime         --消息推送时间
    ,RECEIVE_RESULT VARCHAR(100) --记录接收后是否验证通过的结果
    ,ERROR_CODE VARCHAR(10)         --错误代码
    ,RESPONSE_TIME datetime  -- 响应时间
    ,SPEND_TIME numeric(5, 0)             --消耗时间（ms）
    ,SENDTIMES int    --更新次数
    ,BILLNO VARCHAR(20)          --运单号
    ,CONTRNO VARCHAR(20)         --合同号
)
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


CREATE TABLE T_ICLEAR_API_HSCODE_LOG(
     ID int identity(1,1) primary key      --PK
    ,APPID VARCHAR(20)           --用户ID
    ,APPKEY VARCHAR(20)          --用户key
    ,CODE VARCHAR(2000)         --hscode编码
    ,CREATE_TIME datetime       --创建时间
    ,RECEIVE_RESULT VARCHAR(100) --记录接收后是否验证通过的结果
    ,ERROR_CODE VARCHAR(10)         --错误代码
    ,RESPONSE_TIME datetime         -- 响应时间
    ,SPEND_TIME numeric(5, 0)       --消耗时间（ms）
)
ALTER TABLE [dbo].[T_ICLEAR_API_HSCODE_LOG] SET (LOCK_ESCALATION = TABLE)
GO

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

EXEC sp_addextendedproperty
'MS_Description', N'用户key',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_HSCODE_LOG',
'COLUMN', N'APPKEY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'hscode编码',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_HSCODE_LOG',
'COLUMN', N'CODE'
GO

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

EXEC sp_addextendedproperty
'MS_Description', N'录接收后是否验证通过的结果',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_HSCODE_LOG',
'COLUMN', N'RECEIVE_RESULT'
GO

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

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

EXEC sp_addextendedproperty
'MS_Description', N'消耗时间（ms）',
'SCHEMA', N'dbo',
'TABLE', N'T_ICLEAR_API_HSCODE_LOG',
'COLUMN', N'SPEND_TIME'
GO


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

ALTER TABLE [dbo].[T_ICLEAR_API_MAWB] ADD  DEFAULT (NULL) FOR [OVERSEASCONSIGNEEENAME]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'ID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消息ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'MSGID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'APPID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'进出口标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'IEFlag'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报关类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TYPE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申报单位代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'AGENTCODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申报单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'AGENTNAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'BILLNO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'合同号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'CONTRNO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主管海关（申报地海关）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'CUSTOMMASTER'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'征免性质' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'CUTMODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报关/转关关系标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'DECLTRNREL'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经停港/指运港' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'DISTINATEPORT'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报关标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'EDIID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'海关编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'ENTRYID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运费币制' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'FEECURR'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运费标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'FEEMARK'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运费／率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'FEERATE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'毛重' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'CROSSWET'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出入境关闭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'IEPORT'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'录入人名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'INPUTERNAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保险费币制' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'INSURCURR'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保险费标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'INSURMARK'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保险费／率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'INSURRATE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备案号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'MANUALNO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'净重' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'NETWT'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'杂费币制' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OTHERCURR'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'杂费／率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OTHERRATE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'杂费标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OTHERMARK'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消费使用/生产销售单位代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OWNERCODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消费使用/生产销售单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OWNERNAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'件数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'PACKNO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预录入编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'PREENTRYID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'启运国/运抵国' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRADECOUNTRY'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'监管方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRADEMODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'境内收发货人编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRADECODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运输方式代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRAFMODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'境内收发货人名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRADENAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成交方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRANSMODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'包装种类' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'WRAPTYPE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产核销单位统一信用代码---报关形式类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRADECODESCC'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消费使用/生产销售单位单位统一编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OWNERCODESCC'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'贸易国别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'TRADEAREACODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标记及号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'MARKNO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入境口岸代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'ENTYPORTCODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入境口岸代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'GOODSPLACE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申报人员姓名---报关员证号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'DECLARENAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'境外发货人代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OVERSEASCONSIGNORCODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'境外收货人编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OVERSEASCONSIGNEECODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'境外收货人名称(外文)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'OVERSEASCONSIGNEEENAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'CONSIGNMENTCODEID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'EANNo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWB', @level2type=N'COLUMN',@level2name=N'EANNO'
GO


CREATE TABLE [dbo].[T_ICLEAR_API_MAWBDETAIL](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[MSGID] [int] NULL,
	[MAWBID] [int] NULL,
	[DETAILID] [varchar](50) NULL,
	[CLASSMARK] [varchar](1) NULL,
	[CODETS] [varchar](50) NULL,
	[DECLPRICE] [numeric](29, 10) NULL,
	[DECLTOTAL] [numeric](29, 10) NULL,
	[DUTYMODE] [varchar](4) NULL,
	[EXGNO] [varchar](30) NULL,
	[EXGVERSION] [varchar](8) NULL,
	[FIRSTUNIT] [varchar](3) NULL,
	[FIRSTQTY] [numeric](19, 5) NULL,
	[GUNIT] [varchar](3) NULL,
	[GMODE] [varchar](1000) NULL,
	[GNAME] [varchar](1000) NULL,
	[GNO] [numeric](19, 0) NULL,
	[GQTY] [numeric](19, 5) NULL,
	[ORIGINCURRENTY] [varchar](3) NULL,
	[SECONDUNIT] [varchar](3) NULL,
	[SECONDQTY] [numeric](19, 5) NULL,
	[TRADECURR] [varchar](3) NULL,
	[USETO] [varchar](2) NULL,
	[WORKUSD] [numeric](19, 4) NULL,
	[DESTINATIONCOUNTRY] [varchar](3) NULL,
	[CIQCODE] [varchar](20) NULL,
	[DECLGOODSENAME] [varchar](255) NULL,
	[DESTCODE] [varchar](8) NULL,
	[DISTRICTCODE] [varchar](5) NULL,
	[DECLAREDWEIGHT] [numeric](19, 0) NULL,
PRIMARY KEY CLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'ID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消息ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'MSGID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'MAWBID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DETAILID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'归类标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'CLASSMARK'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'CODETS'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申报单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DECLPRICE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申报总价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DECLTOTAL'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'征免方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DUTYMODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'EXGNO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'版本号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'EXGVERSION'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一计量单位（法定单位）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'FIRSTUNIT'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一法定数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'FIRSTQTY'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成交计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'GUNIT'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品规格、型号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'GMODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'GNAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品序号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'GNO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成交数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'GQTY'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'原产国' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'ORIGINCURRENTY'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第二计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'SECONDUNIT'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第二法定数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'SECONDQTY'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成交币制' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'TRADECURR'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用途/生产厂家' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'USETO'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工缴费' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'WORKUSD'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最终目的国（地区）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DESTINATIONCOUNTRY'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检验检疫编' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'CIQCODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申报货物英文名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DECLGOODSENAME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目的地代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DESTCODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'境内目的地/境内货源地' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DISTRICTCODE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申报重量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_ICLEAR_API_MAWBDETAIL', @level2type=N'COLUMN',@level2name=N'DECLAREDWEIGHT'
GO

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);

--添加tsn口岸
--INSERT into T_AU_ORGANIZATION(CODE,NAME,TYPE_ID,PARENT_ID,[LEVEL],CREATE_USER_ID,CREATE_TIME)VALUES('tsn','tsn口岸',84534,1,6,5503,GETDATE())

--添加tsn口岸操作员02
insert into T_AU_USER (LOGIN_NAME,USERNAME,PASSWORD,IS_VALID,VISIBLE,CREATE_TIME,VERSION,CHANGE_PASSWORD,ORG_ID,ORG_NAME,INIT_OWNER_NAME,TYPE_ID,TYPE_NAME)VALUES('tsnczy2','TSN操作员02','985111aed0bc0920dce9b362de2b1fa122a5ccdd6ac2a8e9b3ae5cfa58169f7725830de4566b7c43',1,1,GETDATE(),0,1,(select ID from T_AU_ORGANIZATION where code = 'tsn'),(select NAME from T_AU_ORGANIZATION where code = 'tsn'),1,(select ID from T_BI_DICTIONARY_ENTRIES where ID = 84534),(select CHINESE_NAME from T_BI_DICTIONARY_ENTRIES where ID = 84534))

--添加权限
insert into T_AU_USER_ROLES (USER_ID,ROLE_ID,VERSION)VALUES(53573,3910,0);
insert into T_AU_USER_ROLES (USER_ID,ROLE_ID,VERSION)VALUES(53574,3910,0);

--数据字段中添加天津口岸
--insert INTO T_BI_DICTIONARY_ENTRIES(CODE,CHINESE_NAME,ENGLISH_NAME,DESCRIPTION,STATUS,DICT_ID,DICT_CODE,ORDINAL)VALUES('port_tsn','TSN','TSN','TSN',1,'50161','port',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')