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

INSERT INTO T_ICLEAR_API_APPINFO VALUES('BASF','iClearExport','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 T_ICLEAR_API_MAWB(
     ID int identity(1,1) primary key      --PK
    ,MSGID int
    ,APPID VARCHAR(20)                      --用户ID
    ,IEFlag varchar(1)
    ,TYPE	VARCHAR(6)
    ,AGENTCODE VARCHAR(18)
    ,AGENTNAME VARCHAR(70)
    ,BILLNO VARCHAR(32)
    ,CONTRNO VARCHAR(32)
    ,CUSTOMMASTER VARCHAR(4)
    ,CUTMODE VARCHAR(3)
    ,DECLTRNREL VARCHAR(1)
    ,DISTINATEPORT VARCHAR(6)
    ,EDIID VARCHAR(3)
    ,ENTRYID VARCHAR(18)
    ,FEECURR VARCHAR(3)
    ,FEEMARK VARCHAR(1)
    ,FEERATE NUMERIC(19,5)
    ,CROSSWET NUMERIC(19,5)
    ,IEPORT VARCHAR(4)
    ,INPUTERNAME VARCHAR(32)
    ,INSURCURR VARCHAR(3)
    ,INSURMARK VARCHAR(1)
    ,INSURRATE NUMERIC(19,5)
    ,MANUALNO VARCHAR(12)
    ,NETWT NUMERIC(19,5)
    ,OTHERCURR VARCHAR(3)
    ,OTHERRATE NUMERIC(19,5)
    ,OTHERMARK VARCHAR(1)
    ,OWNERCODE VARCHAR(18)
    ,OWNERNAME VARCHAR(70)
    ,PACKNO NUMERIC(9)
    ,PREENTRYID VARCHAR(9)
    ,TRADECOUNTRY VARCHAR(3)
    ,TRADEMODE VARCHAR(4)
    ,TRADECODE VARCHAR(18)
    ,TRAFMODE VARCHAR(1)
    ,TRADENAME VARCHAR(70)
    ,TRANSMODE VARCHAR(1)
    ,WRAPTYPE VARCHAR(2)
    ,TRADECODESCC VARCHAR(18)
    ,OWNERCODESCC VARCHAR(18)
    ,TRADEAREACODE VARCHAR(3)
    ,MARKNO VARCHAR(400)
    ,ENTYPORTCODE VARCHAR(8)
    ,GOODSPLACE VARCHAR(100)
    ,DECLARENAME VARCHAR(50)
    ,OVERSEASCONSIGNORCODE VARCHAR(50)
    ,OVERSEASCONSIGNEECODE VARCHAR(50)
    ,OVERSEASCONSIGNEEENAME VARCHAR(400)
)


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

CREATE TABLE T_ICLEAR_API_MAWBDETAIL(
     ID int identity(1,1) primary key      --PK
    ,MSGID int
    ,MAWBID int
    ,DETAILID VARCHAR(50)
    ,CLASSMARK VARCHAR(1)
    ,CODETS VARCHAR(10)
    ,DECLPRICE NUMERIC(19,5)
    ,DECLTOTAL NUMERIC(19,5)
    ,DUTYMODE VARCHAR(1)
    ,EXGNO VARCHAR(30)
    ,EXGVERSION VARCHAR(8)
    ,FIRSTUNIT VARCHAR(3)
    ,FIRSTQTY NUMERIC(19,5)
    ,GUNIT VARCHAR(3)
    ,GMODE VARCHAR(255)
    ,GNAME VARCHAR(255)
    ,GNO NUMERIC(19)
    ,GQTY NUMERIC(19,5)
    ,ORIGINCURRENTY VARCHAR(3)
    ,SECONDUNIT VARCHAR(3)
    ,SECONDQTY NUMERIC(19,5)
    ,TRADECURR VARCHAR(3)
    ,USETO VARCHAR(2)
    ,WORKUSD NUMERIC(19,4)
    ,DESTINATIONCOUNTRY VARCHAR(3)
    ,CIQCODE VARCHAR(20)
    ,DECLGOODSENAME VARCHAR(100)
    ,DESTCODE VARCHAR(8)
    ,DISTRICTCODE VARCHAR(5)
)

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

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