{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["Sheet1","X247_Table","YF_X247_TABLE","247tag数据","247所有信号点","质量数据配置","基础信号","工位信息","采集功能配置","采集功能配置明细表","WorkStepInfo","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":95,"n_cols":23,"rows_kept":95,"cut":false,"hidden":false,"merged":[[48,0,48,12],[32,0,32,13],[0,0,0,12],[16,0,16,12],[40,0,40,12],[24,0,24,13],[8,0,8,26],[88,0,88,7],[64,0,64,12],[72,0,72,7],[80,0,80,7],[56,0,56,12]]}
["基础信号（TagConfig）"]
[null,"UID(Id)","标签类别(TagClass)","标签名称(TagName)","标签数据类型(TagDataType)","数据来源（DataSource）","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","     (TagMarkCode)","标签描述(Description)","是否启用（Enabled）","是否启用事件（EventEnabled）"]
["是否为主键","是","否","否","否","否","否","否"]
["是否创建索引","否","否","否","是（非聚集）","是（非聚集）","是（非聚集）","是（非聚集）"]
["外键"]
["数据类型","Int","Int","Nvarchar（32）","Nvarchar（16）","int","int","int","int","int","nvarchar(64)","int","int"]
["描述",null,"10：信号                                               20：质量数据                                        ","标签名称","是bool还是byte等等","1:MES                                                                2:PLC","tag长度","标签Byte地址索引","标签位Id","Tag功能码",null,"1：启用，当前Tag有效，系统正常加载；      0：禁用，当前Tag无效，系统不加载当前Tag","1：启用，当前Tag值变化会产生事件                                     0：禁用，当前Tag值变化不会产生事件"]
[]
["工位信号表(StationTagInfo)（工位所有的实际信号）"]
[null,"标签Id(TagId)","标签名称(TagName)","工位号（StationCode）","工位Id（StationId）","工位标签序列号(TagStationSerialCode)","标签标志码(TagMarkCode)","标签数据类型(TagDataType)","数据来源（DataSource）","标签类别(TagClass)","PLC型号（PlcType）","PLC厂商（PLCModel）","Ip地址(IpAddress)","通道Id(ChannelId)","数据区Id(AreaId)","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","标签描述(Description)","是否启用（Enabled）","是否启用事件（EventEnabled）","TagAddr","TagDemoAddr"]
["是否为主键","否","否","否","否",null,null,"否","否","否","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否",null,null,"是（非聚集）","是（非聚集）","否","否","否","否","否","否","是（非聚集）","是（非聚集）"]
["外键",{"$nulls":10},"托盘绑定工件表",null,null,null,"托盘类别表","托盘类别表"]
["数据类型","Nvarchar（32）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Int","Int","Nvarchar（16）","int","Int","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","int","int","int","Nvarchar（64）","int","int","Nvarchar（128）","Nvarchar（128）"]
["描述","标签类别（2位）+工位唯一码+标签标志码（3位）+(4位序列号)","标签名称",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）","工位标签序列号  3位","标签标志码","是bool还是byte等等","1:MES                                                                2:PLC","10：信号                                                    20：质量数据                                                   30:   报警数据                                 ","PLC型号,例如新门子S7-1500:S1500","PLC厂商","以何种方式进行保养（目前为预留项）","通道Id","数据区Id(db230)","tag长度","标签Byte地址索引","标签位Id",{"$nulls":4},"模拟状态的Tag地址"]
[]
["工位信息表（StationInfo）"]
[null,"工位Id（StationId）","工位号（StationCode）","工位名称(StationName)","标签配置代码(TagConfigCode)","PLC型号（PlcType）","PLC厂商（PLCModel）","Ip地址(IpAddress)","通道Id(ChannelId)","数据区Id(AreaId)","数据byte偏移（ByteOffset)","PLCDLL文件名称（PlcComFileName）","PLCDLL连接实例类名称（PlcInstanceClassName）"]
["是否为主键","否","否","否","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否","否","否","否","否","否","否"]
["外键",{"$nulls":5},"托盘绑定工件表"]
["数据类型","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（32）","Int","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","Int","Nvarchar（128）","Nvarchar（64）"]
["描述","工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,null,"地区编号+工厂编号+车间编号+线体编号+PLC类型编号","PLC型号,例如新门子S7-1500:S1500","PLC厂商",null,"通道Id","数据区Id(db230)","数据字节偏移地址，多工位共用DB情况","DLL文件名称，不同类型的PLC要使用不同的适配器文件","适配器文件类名称"]
[]
["质量数据索引表（QualityDataInfoIndex）"]
[null,"UID（Id）","工位Id（StationId）","工位号(StationCode)","工位名称(StationName)","工件编号(WorkPieceCode)","产品型号(WorkPieceType)","关联工件编号(ParentPieceCode)","关联产品型号(ParentPieceType)","托盘号(PalletNum)","合格标志(QualifiedMark)","提交时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否","否","否","否","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","int","DateTime"]
["描述",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,null,"当变量结果值为当前指定的值时，才触发对应动作",null,"用于分线上总线数据转移绑定","用于分线上总线数据转移绑定"]
[]
["质量数据表（QualityDataInfo）"]
[null,"UID（Id）","ParentId（索引Id）","标签Id（TagId）","测量位置（MeasurePosition）","测量项目(MeasureItem)","测量结果(TagValue)","合格标志(QualifiedMark)","测量单位(MeasureUnit)","合格上限(UpperLimit)","合格下限(LowerLimit)","测量项目排序(ItemSerialNumber)","测量分组序号(GroupSerialNumber)","提交时间（CreateTime）"]
["是否为主键","是","否",{"$nulls":6},"否"]
["是否创建索引","否","否",{"$nulls":6},"否"]
["外键"]
["数据类型","BigInt","BigInt","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","int","int","Nvarchar（16）","Nvarchar（16）","Nvarchar（16）","int","int","DateTime"]
["描述",null,"索引表Id",{"$nulls":8},"指示每组质量数据组内排序","指示第几组质量数据"]
[]
["采集功能配置表（DataCollectConfig）"]
[null,"标签标志码(TagMarkCode)","工位配置序号(ConfigSerialId)","变量标志码（TagMarkCode）","标签描述（TagDiscription）","采集标记（CollectMark）","采集功能代码（CollectCode）","采集功能描述（CollectDescription）","标签配置代码(TagConfigCode)","采集数据索引代码（CollectIndexMarkCode）","采集数据明细代码（CollectDetailMarkCode）","索引表名称（CollectIndexTableName）","明细表名称（CollectTableName）"]
["是否为主键","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否","否","否","否"]
["外键"]
["数据类型","int","int","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（32）","int","int","nvarchar(32)","nvarchar(32)"]
["描述",null,"允许每个工位多个配置，当前序号表示工位配置的排序，目前无实际意义，（备用字段）","检测的变量地址",null,"当变量结果值为当前指定的值时，才触发对应动作","SaveData:保存质量数据             SaveMaterial：保存物料数据",null,"标签配置代码，用于工位绑定功能，绑定明细","表示需要采集索引对应的TagMarkCode,如果有索引需要采集，则保存对应TagMarkCode结果到索引表中(如总合格标志)，如果当前值为0，则表示不采集索引","表示需要采集数据明细对应的TagMarkCode,如果有数据明细需要采集，则保存对应TagMarkCode结果到明细表中（例如质量数据明细中的扭矩和转交），如果当前值为0，则表示不采集数据明细","索引表或采集数据主表名称","数据明细表名称"]
[]
["采集功能配置明细表（DataCollectConfigDetail）"]
[null,"标签配置代码(TagConfigCode)","序列(ConfigSerialId)","采集明细序列Id(DetailSerialId)","采集变量标志码（CollectIndexMarkCode）","采集变量序列号（CollectSerialId）","字段名称（TargetColName）","显示名称（ShowName）"]
["是否为主键","否","否"]
["是否创建索引","否","否"]
["外键"]
["数据类型","Nvarchar（32）","int","int","int","int","Nvarchar（32）","Nvarchar（64）"]
["描述","标签配置代码，用于工位绑定功能，绑定明细","允许每个工位多个配置，当前序号表示工位配置的排序，目前无实际意义，（备用字段）","采集明细序列,每个TagConfigCode会对应多个ConfigDatail数据，用于采集排序，","需要读取的数据Tag地址，PLC数据的直接取DB，内存中从字典读取,TagId为键","备用（用于采集TagMarkId相同的点，例如指定采集质量数据位时可以使用）","数据要保存的字段名称","数据显示名称（导出报表用）"]
[]
["工位质量明细表（StationQualityTagDetail）"]
[null,"工位Id（StationId）","产品型号(WorkPieceType)","标签Id(TagId)","标签显示名称（测量位置）(MeasurePosition)","测量项目（MeasureItem）","序列类型（SerialType）","测量项目排序(ItemSerialNumber)","测量分组序号(GroupSerialNumber)","显示标题(ShowTittle)","测量单位(MeasureUnit)","合格上限(UpperLimit)","合格下限(LowerLimit)","是否验证（IsValidate）","是否启用（Enabled）"]
["是否为主键","否","否","否","否",{"$nulls":6},"否"]
["是否创建索引","否","否","否","否",{"$nulls":6},"否"]
["外键"]
["数据类型","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","int","int","int","Nvarchar（16）","Nvarchar（8）","Nvarchar（16）","Nvarchar（16）","int","int"]
["描述","工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,"标签类别（2位）+工位唯一码+标签标志码（3位）+(4位序列号)","标签显示名称,用于前端或日志显示，或质量数据的测量位置","扭矩 转角    压力  位移","1：分组合格标志                 2：数据明细","指示每组质量数据组内排序","指示第几组质量数据","报表或界面显示的项目内容",null,null,null,"是否通过合格上下限验证质量数据合格标志"]
[]
["工位报警表（StationAlarmText）"]
[null,"标签Id(TagId)","报警文本(AlarmText)"]
["是否为主键","否","否"]
["是否创建索引","否","否"]
["外键"]
["数据类型","Nvarchar（32）","Nvarchar（64）"]
["描述","标签类别（2位）+工位唯一码+标签标志码（4位）+(4位序列号)"]
[]
["工位报警状态表（StationAlarmStatus）"]
[null,"工位Id（StationId）","标签Id(TagId)","报警文本（AlarmText）","报警状态（AlarmStatus）","开始时间（StartTime）","结束时间(EndTime)","持续时间(TimeDiff)"]
["是否为主键","否","否"]
["是否创建索引","否","否"]
["外键"]
["数据类型","Nvarchar（32）","Nvarchar（32）","Nvarchar（128）","int","int","int","int"]
["描述","工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）","标签类别（2位）+工位唯一码+标签标志码（3位）+(4位序列号)",null,"1:正在报警                                    2:报警解除","报警开始时间","报警结束时间","报警持续多长时间 单位S"]
[]
["工位报警记录表（StationAlarmRecord）"]
[null,"UID（Id）","工位Id（StationId）","标签Id(TagId)","报警文本（AlarmText）","报警状态（AlarmStatus）","开始时间（StartTime）","结束时间(EndTime)","持续时间(TimeDiff)"]
["是否为主键","是","否","否"]
["是否创建索引","否","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","Nvarchar（32）","Nvarchar（128）","int","Datetime","Datetime","int"]
["描述",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）","标签类别（2位）+工位唯一码+标签标志码（3位）+(4位序列号)",null,"1:正在报警                                    2:报警解除","报警开始时间","报警结束时间","报警持续多长时间 单位S"]
[]
["工位交互日志表（LogStationEventRecord）"]
[null,"UID（Id）","工位Id（StationId）","工位号（StationCode）","标签Id(TagId)","变量标志码（TagMarkCode）","变量结果（TagValue）","关联消息(Msg)","CreateTime"]
["是否为主键","是","否","否","否","否"]
["是否创建索引","否","否","否","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","int","Nvarchar（32）","Nvarchar（128）","Datetime"]
["描述",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,"标签类别（2位）+工位唯一码+标签标志码（3位）+(4位序列号)","变量标志代码","当前变量结果值","当前工位所有关联的变量的结果值","操作时间"]

{"sheet":"X247_Table","index":1,"n_rows":103,"n_cols":23,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,0,12],[8,0,8,12],[16,0,16,12],[24,0,24,13],[32,0,32,13],[80,0,80,7],[88,0,88,7],[96,0,96,7],[40,0,40,13],[48,0,48,13],[56,0,56,12],[64,0,64,26],[72,0,72,12]]}
["产品信息（OM_ProductInfo）"]
[null,"UID(Id)","产品型号(WorkPieceType)","产品型号代码(PieceTypeCode)","总成物料号(MaterialCode)","产品描述（WorkPieceDesc）","产品英文描述(PieceDescEN)","类型描述（TypeDesc）","是否启用（Enabled）","最后修改时间（LastModify）","最后操作者(LastUser)","创建时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否","否"]
["是否创建索引","否","否","否","是（非聚集）","是（非聚集）","是（非聚集）","是（非聚集）"]
["外键"]
["数据类型","Int","Nvarchar（16）","int","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","int","Int","Datetime","nvarchar(16)","Datetime"]
["描述",null,null,"产品型号代码","产品物料号",null,null,"1.左侧座椅 ；                2.右侧座椅；",null,"最后修改时间"]
[]
["订单记录（OM_ProductOrderRecord）"]
[null,"UID(Id)","订单号(OrderId)","产品型号(WorkPieceType)","产品型号代码(PieceTypeCode)","总成物料号(MaterialCode)","产品描述（WorkPieceDesc）","产品英文描述(PieceDescEN)","类型描述（TypeDesc）","批次数量（OrderNum）","订单状态（OrderStatus）","最后修改时间（LastModify）","最后操作者(LastUser)","创建时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否","是（非聚集）","是（非聚集）","是（非聚集）","是（非聚集）"]
["外键"]
["数据类型","Int","Nvarchar（32）","Nvarchar（16）","int","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","int","int","int","Datetime","nvarchar(16)","Datetime"]
["描述",null,"订单号",null,"产品型号代码","产品物料号",null,null,"1.左侧座椅 ；                2.右侧座椅；",null,"1:下达    2：结束   3：中断","最后修改时间"]
[]
["物料BOM（BomInfo）"]
[null,"UID(Id)","产品型号(WorkPieceType)","产品型号代码(PieceTypeCode)","工序号(ProcessCode)","物料号(MaterialCode)","批次号（BatchCode）","验证条码（VerifyCode）","是否验证（IsVerify）","物料描述（MaterialDesc）","数量（Number）","最后修改时间（LastModify）","最后操作者(LastUser)","创建时间（CreateTime）"]
["是否为主键","是","否","否","否","否",null,"否","否","否","否"]
["是否创建索引","否","否","否","是（非聚集）","是（非聚集）",null,"是（非聚集）","是（非聚集）","是（非聚集）","是（非聚集）"]
["外键"]
["数据类型","Int","Nvarchar（16）","int","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","int","Nvarchar（32）","int","Datetime","nvarchar(16)","Datetime"]
["描述",null,null,"产品型号代码","工序号","物料号",{"$nulls":5},"最后修改时间"]
[]
["质量数据索引表（Trace_QualityDataInfoIndex）"]
[null,"UID（Id）","工位Id（StationId）","工位号(StationCode)","工位名称(StationName)","工件编号(WorkPieceCode)","产品型号(WorkPieceType)","关联工件编号(ParentPieceCode)","关联产品型号(ParentPieceType)","托盘号(PalletNum)","合格标志(QualifiedMark)","提交时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否","否","否","否","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","int","DateTime"]
["描述",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,null,"当变量结果值为当前指定的值时，才触发对应动作",null,"用于分线上总线数据转移绑定","用于分线上总线数据转移绑定"]
[]
["质量数据表（Trace_QualityDataInfo）"]
[null,"UID（Id）","ParentId（索引Id）","标签Id（TagId）","测量位置（MeasurePosition）","测量项目(MeasureItem)","测量结果(TagValue)","合格标志(QualifiedMark)","测量单位(MeasureUnit)","合格上限(UpperLimit)","合格下限(LowerLimit)","测量项目排序(ItemSerialNumber)","测量分组序号(GroupSerialNumber)","提交时间（CreateTime）"]
["是否为主键","是","否",{"$nulls":6},"否"]
["是否创建索引","否","否",{"$nulls":6},"否"]
["外键"]
["数据类型","BigInt","BigInt","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","int","int","Nvarchar（16）","Nvarchar（16）","Nvarchar（16）","int","int","DateTime"]
["描述",null,"索引表Id",{"$nulls":8},"指示每组质量数据组内排序","指示第几组质量数据"]
[]
["物料数据索引表（Trace_MaterialDataInfoIndex）"]
[null,"UID（Id）","工位Id（StationId）","工位号(StationCode)","工位名称(StationName)","工件编号(WorkPieceCode)","产品型号(WorkPieceType)","关联工件编号(ParentPieceCode)","关联产品型号(ParentPieceType)","托盘号(PalletNum)","提交时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否","否","否","否","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","DateTime"]
["描述",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,null,"当变量结果值为当前指定的值时，才触发对应动作",null,"用于分线上总线数据转移绑定","用于分线上总线数据转移绑定"]
[]
["物料数据表（Trace_MaterialDataInfo）"]
[null,"UID（Id）","ParentId（索引Id）","物料号（MaterialCode）","物料条码（MaterialCodeId）","验证规则(VerifyCode)","批次号(BatchCode)","物料描述（MaterialDesc）","装配数量（Number）","提交时间（CreateTime）"]
["是否为主键","是","否",{"$nulls":4},"否"]
["是否创建索引","否","否",{"$nulls":4},"是（非聚集）"]
["外键"]
["数据类型","BigInt","BigInt","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","int","DateTime"]
["描述",null,"索引表Id"]
[]
["基础信号（TagConfig）"]
[null,"UID(Id)","标签类别(TagClass)","标签名称(TagName)","标签数据类型(TagDataType)","数据来源（DataSource）","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","     (TagMarkCode)","标签描述(Description)","是否启用（Enabled）","是否启用事件（EventEnabled）"]
["是否为主键","是","否","否","否","否","否","否"]
["是否创建索引","否","否","否","是（非聚集）","是（非聚集）","是（非聚集）","是（非聚集）"]
["外键"]
["数据类型","Int","Int","Nvarchar（32）","Nvarchar（16）","int","int","int","int","int","nvarchar(64)","int","int"]
["描述",null,"10：信号                                               20：质量数据                                        ","标签名称","是bool还是byte等等","1:MES                                                                2:PLC","tag长度","标签Byte地址索引","标签位Id","Tag功能码",null,"1：启用，当前Tag有效，系统正常加载；      0：禁用，当前Tag无效，系统不加载当前Tag","1：启用，当前Tag值变化会产生事件                                     0：禁用，当前Tag值变化不会产生事件"]
[]
["工位信号表(StationTagInfo)（工位所有的实际信号）"]
[null,"标签Id(TagId)","标签名称(TagName)","工位号（StationCode）","工位Id（StationId）","工位标签序列号(TagStationSerialCode)","标签标志码(TagMarkCode)","标签数据类型(TagDataType)","数据来源（DataSource）","标签类别(TagClass)","PLC型号（PlcType）","PLC厂商（PLCModel）","Ip地址(IpAddress)","通道Id(ChannelId)","数据区Id(AreaId)","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","标签描述(Description)","是否启用（Enabled）","是否启用事件（EventEnabled）","TagAddr","TagDemoAddr"]
["是否为主键","否","否","否","否",null,null,"否","否","否","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否",null,null,"是（非聚集）","是（非聚集）","否","否","否","否","否","否","是（非聚集）","是（非聚集）"]
["外键",{"$nulls":10},"托盘绑定工件表",null,null,null,"托盘类别表","托盘类别表"]
["数据类型","Nvarchar（32）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Int","Int","Nvarchar（16）","int","Int","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","int","int","int","Nvarchar（64）","int","int","Nvarchar（128）","Nvarchar（128）"]
["描述","标签类别（2位）+工位唯一码+标签标志码（3位）+(4位序列号)","标签名称",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）","工位标签序列号  3位","标签标志码","是bool还是byte等等","1:MES                                                                2:PLC","10：信号                                                    20：质量数据                                                   30:   报警数据                                 ","PLC型号,例如新门子S7-1500:S1500","PLC厂商","以何种方式进行保养（目前为预留项）","通道Id","数据区Id(db230)","tag长度","标签Byte地址索引","标签位Id",{"$nulls":4},"模拟状态的Tag地址"]
[]
["工位信息表（StationInfo）"]
[null,"工位Id（StationId）","工位号（StationCode）","工位名称(StationName)","标签配置代码(TagConfigCode)","PLC型号（PlcType）","PLC厂商（PLCModel）","Ip地址(IpAddress)","通道Id(ChannelId)","数据区Id(AreaId)","数据byte偏移（ByteOffset)","PLCDLL文件名称（PlcComFileName）","PLCDLL连接实例类名称（PlcInstanceClassName）"]
["是否为主键","否","否","否","否","否","否","否","否","否","否"]
["是否创建索引","否","否","否","否","否","否","否","否","否","否"]
["外键",{"$nulls":5},"托盘绑定工件表"]
["数据类型","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（32）","Int","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","Nvarchar（16）","Int","Nvarchar（128）","Nvarchar（64）"]
["描述","工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,null,"地区编号+工厂编号+车间编号+线体编号+PLC类型编号","PLC型号,例如新门子S7-1500:S1500","PLC厂商",null,"通道Id","数据区Id(db230)","数据字节偏移地址，多工位共用DB情况","DLL文件名称，不同类型的PLC要使用不同的适配器文件","适配器文件类名称"]
[]
["工位交互日志表（LogStationEventRecord）"]
[null,"UID（Id）","工位Id（StationId）","工位号（StationCode）","标签Id(TagId)","变量标志码（TagMarkCode）","变量结果（TagValue）","关联消息(Msg)"]
["是否为主键","是","否","否","否","否"]
["是否创建索引","否","否","否","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","Nvarchar（16）","Nvarchar（32）","int","Nvarchar（32）","Nvarchar（max）"]
["描述",null,"工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）",null,"标签类别（2位）+工位唯一码+标签标志码（3位）+(4位序列号)","变量标志代码","当前变量结果值","当前工位所有关联的变量的结果值(存储当前工位所有信号点结果的Json字符串，可以用于情景再现)"]
[]
["工位派工信息（StationDispatchInfo）"]
[null,"UID（Id）","订单号(OrderId)","总成物料号（MaterialCode）","工序号(ProcessCode)","工位Id（StationId）","工位号（StationCode）","开始时间（StartTime）","结束时间（EndTime）","目标开始时间（TargetStartTime）","目标结束时间（TargetEndTime）","提交时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否"]
["是否创建索引","否","否","否","是（非聚集）","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","Nvarchar（32）","Nvarchar（16）","DateTime","DateTime","DateTime","DateTime","DateTime"]
["描述",null,"订单号 ","变量标志代码","工序号","工位唯一码（地区编号（4位）+工厂编号（3位）+车间编号（3位）+线体编号（3位）+工位序号（3位）"]
[]
["工序工步信息（StepProcessInfo）"]
[null,"UID（Id）","工序号(ProcessCode)","工步号（StepNumber）","操作内容(OperationProcedure)","技术要求（TechRequirement）","工艺图片（CraftPicture）","工步值（StepValue）","最后修改时间（LastModify）","最后操作者(LastUser)","创建时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否","否"]
["是否创建索引","否","是（非聚集）","否","是（非聚集）","否","否","否"]
["外键"]
["数据类型","BigInt","Nvarchar（32）","int","Nvarchar（64）","Nvarchar（32）","Nvarchar（128）","int","Datetime","nvarchar(16)","Datetime"]
["描述",null,"工序号","工步序号","工序号",null,"工艺图片完整路径",null,"最后修改时间"]

{"sheet":"YF_X247_TABLE","index":2,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,12],[8,0,8,12],[17,0,17,12],[25,0,25,12],[33,0,33,12]]}
["工步信息（Ad_StepInfo）"]
[null,"UID(Id)","产品型号代码(ProductId)","(PositionId)","(StepNo)","（StepDetail）","工步值(StepValue)","最后修改时间（LastModify）","最后操作者(LastUser)","创建时间（CreateTime）"]
["是否为主键","是","否","否","否","否","否"]
["是否创建索引","否","否","否","是（非聚集）","是（非聚集）","是（非聚集）"]
["外键"]
["数据类型","Int","int","int","int","Nvarchar（64）","int","Datetime","nvarchar(16)","Datetime"]
["描述",null,null,"产品型号代码","工步序号","工步明细",null,"最后修改时间"]
[]
["过程数据（Ad_ProcessData）"]
[null,"UID(Id)","订单号(OrderId)","产品描述(ProductDesc)","托盘号(PalletId)","产品型号代码（PieceTypeCode）","工件编号(WorkPieceCode)","(LeaveTime_OP20)","Pressure_OP40","Shift_OP40","State_OP40","(LeaveTime_OP40)","SkeletonId","SkeletonTime","Pressure_OP50","Shift_OP50","State_OP50","(LeaveTime_OP50)"]
["是否为主键","是","否","否","否","否","否"]
["是否创建索引","否","否","否","是（非聚集）","是（非聚集）","是（非聚集）"]
["外键"]
["数据类型","Int","Nvarchar（64）","Nvarchar（64）","int","int","int","datetime","float","FLOAT","int","datetime","nvarchar(64)","datetime","float","FLOAT","int","datetime"]
["描述",null,null,"产品型号代码","工步序号","产品型号代码"]
[]
[]
["过程数据（StationTagInfo）"]
[null,"UID(Id)","TagId","标签名称(TagName)","工位号（StationCode）","标签标志码(TagMarkCode)","标签数据类型(TagDataType)","数据来源（DataSource）","标签类别(TagClass)","数据区Id(AreaId)","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","数据插入字段名称(ColumnName)","标签描述(Description)","是否启用（Enabled）"]
["是否为主键","是","否","否","否",null,"否","否","否","否","否","否"]
["是否创建索引","否","否","否","否",null,"是（非聚集）","是（非聚集）","否","否","是（非聚集）","是（非聚集）"]
["外键",{"$nulls":9},"托盘类别表","托盘类别表"]
["数据类型","Int","Nvarchar（64）","Nvarchar（32）","Nvarchar（16）","Int","Nvarchar（16）","int","Int","Nvarchar（16）","int","int","int","Nvarchar（64）","Nvarchar（64）","int"]
["描述",null,null,"标签名称",null,"标签标志码","是bool还是byte等等","1:MES                                                                2:PLC","10：信号                                                    20：质量数据                                                   30:   报警数据                                 ","数据区Id(db230)","tag长度","标签Byte地址索引","标签位Id"]
[]
["Plc信息（DeviceServerInfo）"]
[null,"UID(Id)","AreaId","StartByteIndex","ReadLength"]
["是否为主键","是","否","否","否"]
["是否创建索引","否","否","否","否"]
["外键"]
["数据类型","Int","Nvarchar（16）","int","int"]
["描述",null,null,"标签名称"]
[]
["Plc信息（DeviceServerInfo）"]
[null,"UID(Id)","AreaId","StartByteIndex","ReadLength"]
["是否为主键","是","否","否","否"]
["是否创建索引","否","否","否","否"]
["外键"]
["数据类型","Int","Nvarchar（16）","int","int"]
["描述",null,null,"标签名称"]

{"sheet":"247tag数据","index":3,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"UID(Id)","标签名称(TagName)","标签数据类型(TagDataType)","数据来源（DataSource）","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","标签标志码(TagMarkCode)","标签描述(Description)","是否启用（Enabled）","是否启用事件（EventEnabled）"]
[null,1,"PalletNum","byte",2,1,0,0,1010,"托盘号",1,0]
[null,2,"BarcodeOk","byte",1,1,0,0,1020,"扫描完成",0,0]
[null,3,"LH_Type","byte",1,1,0,0,1030,"OP20LH型号下发",0,0]
[null,4,"RH_Type","byte",1,1,0,0,1040,"OP20RH型号下发",0,0]
[null,5,"AllowReadDate","byte",2,1,0,0,1050,"PLC允许保存",0,0]
[null,6,"SaveDataDone","byte",1,1,0,0,1060,"保存完成",0,0]
[null,7,"WorkStatus","byte",1,1,0,0,1070,"工件合格标志",0,0]
[null,null,"QualityData",{"$nulls":5},3010,"质量数据",null,0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},1]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[]
[{"$nulls":8},5010,"报警"]
[{"$nulls":8},3010,"质量数据"]

{"sheet":"247所有信号点","index":4,"n_rows":86,"n_cols":15,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["TagId","TagName","StationCode","TagMarkCode","TagDataType","DataSource","标签类别(TagClass)","数据区Id(AreaId)","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","TagAddr","数据插入字段名称(ColumnName)","标签描述(Description)","是否启用（Enabled）"]
["1024710100020001","OP20托盘号","OP20","1010","byte","2","10","DB4000","1","0","0","DB4000.0","0","OP20托盘号","1"]
["1024710200020002","OP20扫描完成","OP20","1020","byte","1","10","DB5000","1","0","0","DB5000.0","0","OP20扫描完成","1"]
["1024710300020003","OP20LH型号下发","OP20","1030","byte","1","10","DB5000","1","10","0","DB5000.10","0","OP20LH型号下发","1"]
["1024710400020004","OP20RH型号下发","OP20","1040","byte","1","10","DB5000","1","11","0","DB5000.11","0","OP20RH型号下发","1"]
["1024710100040001","OP40托盘号","OP40","1010","byte","2","10","DB4000","1","2","0","DB4000.2","0","OP40托盘号","1"]
["1024710500040002","OP40允许保存","OP40","1050","byte","2","10","DB4000","1","19","0","DB4000.19",null,"OP40允许保存","1"]
["1024710600040003","OP40保存完成","OP40","1060","byte","1","10","DB5000","1","1","0","DB5000.1",null,"OP40保存完成","1"]
["3024730100040004","卡圈压力","OP40","3010","float","2","30","DB4000","4","10","0","DB4000.10",null,"卡圈压力","1"]
["3024730100040005","卡圈位移","OP40","3010","float","2","30","DB4000","4","14","0","DB4000.14",null,"卡圈位移","1"]
["3024730100040006","卡圈结果","OP40","3010","byte","2","30","DB4000","1","18","0","DB4000.18",null,"卡圈结果","1"]
["1024710100050001","OP50托盘号","OP50","1010","byte","2","10","DB4000","1","3","0","DB4000.3",null,"OP50托盘号","1"]
["1024710200050002","OP50扫描完成","OP50","1020","byte","1","10","DB5000","1","2","0","DB5000.2",null,"OP50扫描完成","1"]
["1024710500050003","OP50允许保存","OP50","1050","byte","2","10","DB4000","1","29","0","DB4000.29",null,"OP50允许保存","1"]
["1024710600050004","OP50保存完成","OP50","1060","byte","1","10","DB5000","1","3","0","DB5000.3",null,"OP50保存完成","1"]
["1024730100050005","卡圈压力","OP50","3010","float","2","10","DB4000","4","20","0","DB4000.20",null,"卡圈压力","1"]
["1024730100050006","卡圈位移","OP50","3010","float","2","10","DB4000","4","24","0","DB4000.24",null,"卡圈位移","1"]
["1024730100050007","卡圈结果","OP50","3010","byte","2","10","DB4000","1","28","0","DB4000.28",null,"卡圈结果","1"]
["1024710100060001","OP60托盘号","OP60","1010","byte","2","10","DB4000","1","4",null,"DB4000.4",null,"OP60托盘号","1"]
["1024710500060002","OP60允许保存","OP60","1050","byte","2","10","DB4000","1","174",null,"DB4000.174",null,"OP60允许保存","1"]
["1024710600060003","OP60保存完成","OP60","1060","byte","1","10","DB5000","1","4",null,"DB5000.4",null,"OP60保存完成","1"]
["3024730100060004","扭矩1第一次","OP60","3010","float","2","30","DB4000","4","30",null,"DB4000.30",null,"扭矩1第一次","1"]
["3024730100060005","角度1第一次","OP60","3010","float","2","30","DB4000","4","94",null,"DB4000.94",null,"角度1第一次","1"]
["3024730100060006","扭矩2第一次","OP60","3010","float","2","30","DB4000","4","46",null,"DB4000.46",null,"扭矩2第一次","1"]
["3024730100060007","角度2第一次","OP60","3010","float","2","30","DB4000","4","110",null,"DB4000.110",null,"角度2第一次","1"]
["3024730100060008","扭矩3第一次","OP60","3010","float","2","30","DB4000","4","62",null,"DB4000.62",null,"扭矩3第一次","1"]
["3024730100060009","角度3第一次","OP60","3010","float","2","30","DB4000","4","126",null,"DB4000.126",null,"角度3第一次","1"]
["3024730100060010","扭矩4第一次","OP60","3010","float","2","30","DB4000","4","78",null,"DB4000.78",null,"扭矩4第一次","1"]
["3024730100060011","角度4第一次","OP60","3010","float","2","30","DB4000","4","142",null,"DB4000.142",null,"角度4第一次","1"]
["3024730100060012","扭矩1第二次","OP60","3010","float","2","30","DB4000","4","34",null,"DB4000.34",null,"扭矩1第二次","1"]
["3024730100060013","角度1第二次","OP60","3010","float","2","30","DB4000","4","98",null,"DB4000.98",null,"角度1第二次","1"]
["3024730100060014","扭矩2第二次","OP60","3010","float","2","30","DB4000","4","50",null,"DB4000.50",null,"扭矩2第二次","1"]
["3024730100060015","角度2第二次","OP60","3010","float","2","30","DB4000","4","114",null,"DB4000.114",null,"角度2第二次","1"]
["3024730100060016","扭矩3第二次","OP60","3010","float","2","30","DB4000","4","66",null,"DB4000.66",null,"扭矩3第二次","1"]
["3024730100060017","角度3第二次","OP60","3010","float","2","30","DB4000","4","130",null,"DB4000.130",null,"角度3第二次","1"]
["3024730100060018","扭矩4第二次","OP60","3010","float","2","30","DB4000","4","82",null,"DB4000.82",null,"扭矩4第二次","1"]
["3024730100060019","角度4第二次","OP60","3010","float","2","30","DB4000","4","146",null,"DB4000.146",null,"角度4第二次","1"]
["3024730100060020","扭矩1第三次","OP60","3010","float","2","30","DB4000","4","38",null,"DB4000.38",null,"扭矩1第三次","1"]
["3024730100060021","角度1第三次","OP60","3010","float","2","30","DB4000","4","102",null,"DB4000.102",null,"角度1第三次","1"]
["3024730100060022","扭矩2第三次","OP60","3010","float","2","30","DB4000","4","54",null,"DB4000.54",null,"扭矩2第三次","1"]
["3024730100060023","角度2第三次","OP60","3010","float","2","30","DB4000","4","118",null,"DB4000.118",null,"角度2第三次","1"]
["3024730100060024","扭矩3第三次","OP60","3010","float","2","30","DB4000","4","70",null,"DB4000.70",null,"扭矩3第三次","1"]
["3024730100060025","角度3第三次","OP60","3010","float","2","30","DB4000","4","134",null,"DB4000.134",null,"角度3第三次","1"]
["3024730100060026","扭矩4第三次","OP60","3010","float","2","30","DB4000","4","86",null,"DB4000.86",null,"扭矩4第三次","1"]
["3024730100060027","角度4第三次","OP60","3010","float","2","30","DB4000","4","150",null,"DB4000.150",null,"角度4第三次","1"]
["3024730100060028","扭矩1第四次","OP60","3010","float","2","30","DB4000","4","42",null,"DB4000.42",null,"扭矩1第四次","1"]
["3024730100060029","角度1第四次","OP60","3010","float","2","30","DB4000","4","106",null,"DB4000.106",null,"角度1第四次","1"]
["3024730100060030","扭矩2第四次","OP60","3010","float","2","30","DB4000","4","58",null,"DB4000.58",null,"扭矩2第四次","1"]
["3024730100060031","角度2第四次","OP60","3010","float","2","30","DB4000","4","122",null,"DB4000.122",null,"角度2第四次","1"]
["3024730100060032","扭矩3第四次","OP60","3010","float","2","30","DB4000","4","74",null,"DB4000.74",null,"扭矩3第四次","1"]
["3024730100060033","角度3第四次","OP60","3010","float","2","30","DB4000","4","138",null,"DB4000.138",null,"角度3第四次","1"]
["3024730100060034","扭矩4第四次","OP60","3010","float","2","30","DB4000","4","90",null,"DB4000.90",null,"扭矩4第四次","1"]
["3024730100060035","角度4第四次","OP60","3010","float","2","30","DB4000","4","154",null,"DB4000.154",null,"角度4第四次","1"]
["3024730100060036","结果1第一次","OP60","3010","byte","2","30","DB4000","1","158",null,"DB4000.158",null,"结果1第一次","1"]
["3024730100060037","结果2第一次","OP60","3010","byte","2","30","DB4000","1","162",null,"DB4000.162",null,"结果2第一次","1"]
["3024730100060038","结果3第一次","OP60","3010","byte","2","30","DB4000","1","166",null,"DB4000.166",null,"结果3第一次","1"]
["3024730100060039","结果4第一次","OP60","3010","byte","2","30","DB4000","1","170",null,"DB4000.170",null,"结果4第一次","1"]
["3024730100060040","结果1第二次","OP60","3010","byte","2","30","DB4000","1","159",null,"DB4000.159",null,"结果1第二次","1"]
["3024730100060041","结果2第二次","OP60","3010","byte","2","30","DB4000","1","163",null,"DB4000.163",null,"结果2第二次","1"]
["3024730100060042","结果3第二次","OP60","3010","byte","2","30","DB4000","1","167",null,"DB4000.167",null,"结果3第二次","1"]
["3024730100060043","结果4第二次","OP60","3010","byte","2","30","DB4000","1","171",null,"DB4000.171",null,"结果4第二次","1"]
["3024730100060044","结果1第三次","OP60","3010","byte","2","30","DB4000","1","160",null,"DB4000.160",null,"结果1第三次","1"]
["3024730100060045","结果2第三次","OP60","3010","byte","2","30","DB4000","1","164",null,"DB4000.164",null,"结果2第三次","1"]
["3024730100060046","结果3第三次","OP60","3010","byte","2","30","DB4000","1","168",null,"DB4000.168",null,"结果3第三次","1"]
["3024730100060047","结果4第三次","OP60","3010","byte","2","30","DB4000","1","172",null,"DB4000.172",null,"结果4第三次","1"]
["3024730100060048","结果1第四次","OP60","3010","byte","2","30","DB4000","1","161",null,"DB4000.161",null,"结果1第四次","1"]
["3024730100060049","结果2第四次","OP60","3010","byte","2","30","DB4000","1","165",null,"DB4000.165",null,"结果2第四次","1"]
["3024730100060050","结果3第四次","OP60","3010","byte","2","30","DB4000","1","169",null,"DB4000.169",null,"结果3第四次","1"]
["3024730100060051","结果4第四次","OP60","3010","byte","2","30","DB4000","1","173",null,"DB4000.173",null,"结果4第四次","1"]
["1024710100080001","OP80托盘号","OP80","1010","byte","2","10","DB4000","1","6",null,"DB4000.6",null,"OP80托盘号","1"]
["1024710500080002","OP80允许保存","OP80","1050","byte","2","10","DB4000","1","194",null,"DB4000.194",null,"OP80允许保存","1"]
["1024710600080003","OP80保存完成","OP80","1060","byte","1","10","DB5000","1","5",null,"DB5000.5",null,"OP80保存完成","1"]
["3024730100080004","OP80解锁力MAX","OP80","3010","float","2","30","DB4000","4","178",null,"DB4000.178",null,"OP80解锁力MAX","1"]
["3024730100080005","OP80最后位置回复力","OP80","3010","float","2","30","DB4000","4","182",null,"DB4000.182",null,"OP80最后位置回复力","1"]
["3024730100080006","OP80最后位置抬起力","OP80","3010","float","2","30","DB4000","4","186",null,"DB4000.186",null,"OP80最后位置抬起力","1"]
["3024730100080007","OP80解锁里MAX结果","OP80","3010","byte","2","30","DB4000","1","190",null,"DB4000.190",null,"OP80解锁里MAX结果","1"]
["3024730100080008","OP80最后位置回复力结果","OP80","3010","byte","2","30","DB4000","1","191",null,"DB4000.191",null,"OP80最后位置回复力结果","1"]
["3024730100080009","OP80最后位置抬起力结果","OP80","3010","byte","2","30","DB4000","1","192",null,"DB4000.192",null,"OP80最后位置抬起力结果","1"]
["3024730100080010","OP80总结果","OP80","3010","byte","2","30","DB4000","1","193",null,"DB4000.193",null,"OP80总结果","1"]
["1024710100090001","OP90托盘号","OP90","1010","byte","2","10","DB4000","1","7",null,"DB4000.7",null,"OP90托盘号","1"]
["1024710500090002","OP90允许保存","OP90","1050","byte","2","10","DB4000","1","176",null,"DB4000.176",null,"OP90允许保存","1"]
["1024710700090003","OP90工件合格标志","OP90","1070","byte","2","10","DB4000","1","175",null,"DB4000.175",null,"OP90工件合格标志","1"]
["1024710200090004","OP90扫描完成","OP90","1020","byte","1","10","DB5000","1","7",null,"DB5000.7",null,"OP90扫描完成","1"]
["1024710600090005","OP90保存完成","OP90","1060","byte","1","10","DB5000","1","6",null,"DB5000.6",null,"OP90保存完成","1"]
[]
["10247101500020005","OP20LH型号下发","OP20","1015","short","2","10","DB4000","2","196","0","DB4000.196","0","OP20ODS步骤","1"]

{"sheet":"质量数据配置","index":5,"n_rows":5,"n_cols":22,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"标签Id(TagId)","标签名称(TagName)","工位号（StationCode）","工位Id（StationId）","标签标志码(TagMarkCode)","标签数据类型(TagDataType)","数据来源（DataSource）","标签类别(TagClass)","PLC型号（PlcType）","PLC厂商（PLCModel）","Ip地址(IpAddress)","通道Id(ChannelId)","数据区Id(AreaId)","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","标签描述(Description)","是否启用（Enabled）","是否启用事件（EventEnabled）","TagAddr","TagDemoAddr"]
[null,"20100130112700200131501001","合格标志","OP10","1001301127002001","3150","Short","2","20","S1500","SIEMENS","127.0.0.1","channel01","DB5000","2","150","0","合格标志","1","0","S1500:SIEMENS,127.0.0.1,channel01,DB5000,Short,150,0,2","S1500:SIEMENS,127.0.0.1,channel01,DB200,Short,150,0,2"]
[null,"20100130112700200131501002","扭矩","OP10","1001301127002001","3150","Float","2","20","S1500","SIEMENS","127.0.0.1","channel01","DB5000","4","152","0","扭矩","1","0","S1500:SIEMENS,127.0.0.1,channel01,DB5000,Float,152,0,4","S1500:SIEMENS,127.0.0.1,channel01,DB200,Float,152,0,4"]
[null,"20100130112700200131501003","转角","OP10","1001301127002001","3150","Float","2","20","S1500","SIEMENS","127.0.0.1","channel01","DB5000","4","156","0","转角","1","0","S1500:SIEMENS,127.0.0.1,channel01,DB5000,Float,156,0,4","S1500:SIEMENS,127.0.0.1,channel01,DB200,Float,156,0,4"]
[null,"50100130112700200150101001","设备报警","OP10","1001301127002001","5010","bool","2","50","S1500","SIEMENS","127.0.0.1","channel01","DB5000","1","190","0","设备报警","1","0","S1500:SIEMENS,127.0.0.1,channel01,DB5000,bool,190,0,1","S1500:SIEMENS,127.0.0.1,channel01,DB5000,bool,190,0,1"]

{"sheet":"基础信号","index":6,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"UID(Id)","标签名称(TagName)","标签数据类型(TagDataType)","数据来源（DataSource）","标签数据长度(TagDataLong)","标签ByteId(TagByteId)","标签BitId(TagBitId)","标签标志码(TagMarkCode)","标签描述(Description)","是否启用（Enabled）","是否启用事件（EventEnabled）"]
[null,1,"WatchDog","Bool",1,1,0,0,1010,"系统健康",1,0]
[null,2,"TransType","Bool",1,1,0,1,1020,"传递机型（MES）",0,0]
[null,3,"ReleaseEmptyPlt","Bool",1,1,0,2,1030,"空托盘放行（MES）",0,0]
[null,4,"DataSaved","Bool",1,1,0,3,1040,"工作完成（MES）",0,0]
[null,5,"ReleaseNokPlt","Bool",1,1,0,4,1050,"不合格放行（MES）",0,0]
[null,6,"ReleaseOkPlt","Bool",1,1,0,5,1060,"合格放行（MES）",0,0]
[null,7,"ResetPLC","Bool",1,1,0,6,1070,"复位设备",0,0]
[null,8,"AllowStationStart","Bool",1,1,0,7,1080,"允许PLC工作（MES）",0,0]
[null,9,"TighteningDoneCfm","Bool",1,1,1,0,1090,"拧紧结束确认（MES）",0,0]
[null,10,"ApplyForID_Mode","Bool",1,1,1,1,1100,"自动手动（MES）",0,0]
[null,11,"ClearRFID_Loading","Bool",1,1,1,2,1110,"上线清空MOBY（MES）",0,0]
[null,12,"MES_SaveDataDone","Bool",1,1,1,3,1120,"MES保存完数据（MES）",0,0]
[null,13,"StationMode","Byte",1,1,2,null,1130,"工位三种状态：在线、离线、屏蔽（0，1）（MES）",0,0]
[null,14,"TighteningNm","Short",1,2,4,null,1140,"拧紧序号",0,0]
[null,15,"SleeveNm","Short",1,2,6,null,1150,"套筒号（MES）",0,0]
[null,16,"RepairStatus","Short",1,2,8,null,1160,"0正常件，1返修件",0,0]
[null,17,"PartID","String",1,20,10,null,1170,"工件编号（MES）",0,0]
[null,18,"PartType","String",1,10,30,null,1180,"产品型号（MES）",0,0]
[null,19,"WatchDog","Bool",2,1,100,0,2010,"系统健康(PLC)",0,0]
[null,20,"PalletInPos","Bool",2,1,100,1,2020,"工件到位(PLC)",0,0]
[null,21,"ApplyForID","Bool",2,1,100,2,2030,"申请零件编号(MES)",0,0]
[null,22,"TransType","Bool",2,1,100,3,2040,"传递机型(PLC)",0,0]
[null,23,"ApplyForUnload","Bool",2,1,100,4,2050,"申请下线",0,0]
[null,24,"DataReady","Bool",2,1,100,5,2060,"拧紧结束(PLC)",0,0]
[null,25,"MaterialFittingOK","Bool",2,1,100,6,2070,"物料装配完成",0,0]
[null,26,"PartPalletGoOK","Bool",2,1,100,7,2080,"空托盘放行完成",0,0]
[null,27,"AllowReadDate","Bool",2,1,101,0,2090,"质量数据可以读数据（PLC）",1,1]
[null,28,"MachinaPowerOn","Bool",2,1,101,1,2100,"机床上电（PLC）",0,0]
[null,29,"CycleStarted","Bool",2,1,101,2,2110,"循环开始（PLC）",0,0]
[null,30,"MachinaAlarm","Bool",2,1,101,3,2120,"机床故障（PLC）",0,0]
[null,31,"NoPartLoading","Bool",2,1,101,4,2130,"上料无件（PLC）",0,0]
[null,32,"UnloadingBlocked","Bool",2,1,101,5,2140,"下料堵塞（PLC）",0,0]
[null,33,"PltInPosOrLeaving","Bool",2,1,101,6,2150,"托盘到位(1)托盘离开(0)",0,0]
[null,34,"PalletStatus","Byte",2,1,102,null,2160,"托盘状态；0空托盘，1合格件，2不合格件",0,0]
[null,35,"DataResult","Short",2,2,104,null,2170,"质量数据工位合格标志(PLC)",1,0]
[null,36,"PalletNm","Short",2,2,106,null,2180,"托盘编号（PLC）",1,0]
[null,37,"RepairStatusPLC","Short",2,2,108,null,2190,"0正常件，1返修件",0,0]
[null,38,"MachineTargetTime","Short",2,2,110,null,2200,"目标运行时间",0,0]
[null,39,"MachineActualTime","Short",2,2,112,null,2210,"实际运行时间",0,0]
[null,40,"PartID","String",2,20,114,null,2220,"工件编号（PLC）",1,0]
[null,41,"PartType","String",2,10,134,null,2230,"产品型号（PLC）",1,0]
[]
[{"$nulls":8},5010,"报警"]
[{"$nulls":8},3150,"质量数据"]

{"sheet":"工位信息","index":7,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"工位Id（StationId）","工位号（StationCode）","工位名称(StationName)","标签配置代码(TagConfigCode)","PLC型号（PlcType）","PLC厂商（PLCModel）","Ip地址(IpAddress)","通道Id(ChannelId)","数据区Id(AreaId)","数据byte偏移（ByteOffset)"]
[null,"1001301127002001","OP10","调角器拧紧","1001301127002","S1500","SIEMENS","127.0.0.1","channel01","DB5000",0]
[null,"1001301127002002","OP20","安装扭簧","1001301127002","S1500","SIEMENS","127.0.0.1","channel01","DB5000",1000]
[null,"1001301127002003","OP30","安装挂网","1001301127002","S1500","SIEMENS","127.0.0.1","channel01","DB4001",0]
[null,"1001301127002004","OP40","拼装","1001301127002","S1500","SIEMENS","127.0.0.1","channel01","DB4000",0]

{"sheet":"采集功能配置","index":8,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["UID（Id）","标签配置代码(TagConfigCode)","标签标志码(TagMarkCode)","标签描述（TagDiscription）","采集标记（CollectMark）","采集功能代码（CollectCode）","采集功能描述（CollectDescription）","采集数据索引代码（CollectIndexMarkCode）","采集数据明细代码（CollectDetailMarkCode）"]
[1,"1001301127002",2090,"允许保存质量数据",true,"SaveData","自动保存质量数据",2170,3150]

{"sheet":"采集功能配置明细表","index":9,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["标签配置代码(TagConfigCode)","序列(ConfigSerialId)","采集明细序列Id(DetailSerialId)","采集变量标志码（CollectIndexMarkCode）","采集变量序列号（CollectSerialId）","字段名称（TargetColName）","显示名称（ShowName）"]
["1001301127002","1","1","2220","0","WorkPieceCode","工件编号"]
["1001301127002","1","2","2180","0","PalletNum","托盘号"]
["1001301127002","1","3","2170","0","QualifiedMark","工位合格标志"]

{"sheet":"WorkStepInfo","index":10,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Id","StationCode","PalletType","PieceType","PieceTypeCode","SerialId","StepContent","TechRequirement","PictureName","GifPosition_X","GifPosition_Y","PlcStepId"]
[null,"OP20",0,3774028,10,1,"等待托盘顶起.","无",null,-10,-10,200]
[null,"OP20",0,3774028,10,2,"扫描坐盆条码.","无",null,-10,-10,300]
[null,"OP20",0,3774028,10,3,"坐盆上线.","无",null,-10,-10,301]
[null,"OP20",0,3774028,10,4,"双手启动,托盘放行.","无",null,-10,-10,400]
[null,"OP20",1,3774029,11,1,"等待托盘顶起.","无",null,-10,-10,200]
[null,"OP20",1,3774029,11,2,"扫描坐盆条码.","无",null,-10,-10,300]
[null,"OP20",1,3774029,11,3,"坐盆上线,位置到位.","无",null,-10,-10,301]
[null,"OP20",1,3774029,11,4,"双手启动,托盘放行.","无",null,-10,-10,400]

{"sheet":"Sheet3","index":11,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["StationCode","SerialId","PartName","PartCodeRule","PalletType","PieceType","PieceTypeCode"]
["OP20",1,"左侧座椅坐盆",3774028,0,3774028,10]
["OP20",1,"右侧座椅坐盆",3774029,1,3774029,11]