SQLSERVER聚集索引与非聚集索引的再次研究（上）
时间：2022-03-10 17:03
原文:SQLSERVER聚集索引与非聚集索引的再次研究（上）
有很多问题不知道为什么，但是MSDN就是这样说的，既然说得这麽模糊不如自己做一下实验，验证一下MSDN的内容吧o(∩_∩)o
--------------------------------------------华丽的分割线---------------------------------------------
先来看一下索引的结构，文章里面的一些结构图都是自己画的一些草图，本人自认画得非常烂，希望各位看官谅解o(∩_∩)o
----------------------------------------------华丽的分割线---------------------------------------------------------
先创建一个表，保存DBCC IND的结果
第一个：IAM页不是只有堆表才有也不只是维护堆表中的数据页的连续，有索引的表都有，所以IAM页不只维护数据页，也维护索引页的连续，在下篇说到非聚集索引的时候
我会给出MSDN的解释和IAM页在聚集索引表，非聚集索引表中的情况
第二个：每个数据页的IndexID都是1，不是说数据页变成了索引页，而是说现在数据页已经属于聚集索引的一部分，不在堆里了
第三个：每个数据页的IndexLevel都是0，就是说数据页在聚集索引的最下层
第四个:索引页和数据页,前一页和后一页是首尾相连的,但是数据页和索引页不是首尾相连的，也就是说没有一个数据页的[PrevPagePID]指向14464页或3528页
那么在上面的聚集索引图片中为什麽会说索引页指向数据页呢？叶子节点就是数据页呢？
数据页的index level是0，那么就是说聚集索引的叶子节点就是数据页
上面索引页的结构
现在来看一下索引页里都有什么，运行下面的SQL语句
您们应该看到ChildPageId，所以上面我的图为什麽会这样画的原因，索引页连接着数据页，而且一个索引页指向多个数据页
DepartmentID是主键列，从1开始自增，那么从下图可以看出主键列数据是从最左边的索引节点（不是叶子节点）开始排序
这里有个问题：为什麽根节点只有两行？？？是不是根节点只作连接作用，所以只有两行 ，不过这个问题我也不清楚
聚集索引页里主键列DepartmentID上一行与下一行相差120条记录,一个数据页刚好容纳120条记录
KeyHashValue根据主键列的第一个字段而生成的，就算两个表完全一样，这个hash出来的KeyHashValue都不会一样
我创建了一个一模一样的表Department2，看到hash出来的值都不一样
而这个KeyHashValue我们就叫做键，也就是key-value中的key
------------------------------------------------------------华丽的分割线------------------------------------------------------
聚集索引怎麽找记录的？？？
这里要分两种情况：（1）聚集索引查找和（2）聚集索引扫描
（1）聚集索引查找
放大一下索引页
SQLSERVER首先把每个数据页的头一条记录里的DepartmentID的值加上一定范围值hash出一个key值，然后放在KeyHashValue列里
当我要找DepartmentID为110的那条记录里的GroupName和Company的值的时候，首先SQLSERVER根据where DepartmentID=110
将110加上一个范围值hash出一个值，这个值就是KeyHashValue的值，找到KeyHashValue=(f000ff86397c)的那条记录
然后到数据页13791里找出DepartmentID为110的那条记录里的GroupName和Company的值
其实这里的算法应该跟hash join是一样的，但是实际具体怎麽算的？本人就不清楚了，大家可以看一下hash join的原理
个人感觉在SQLSERVER里 key-value hash桶用途很广泛，执行计划、 hash join、 聚集索引都用到了
证明：这里我可以证明一下SQLSERVER聚集索引查找记录的流程
先到索引页里找到键值为KeyHashValue=XXX的那条记录，然后再到数据页里把实际数据读出来
运行下面的SQL语句，看一下SQLSERVER申请的锁就知道了
下面实验我在Department2表里做的，表数据和表结构和Department1一模一样
1 --只有聚集索引 2 CREATE TABLE Department2( 3 DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY, 4 Name NVARCHAR(200) NOT NULL, 5 GroupName NVARCHAR(200) NOT NULL, 6 Company NVARCHAR(300), 7 ModifiedDate datetime NOT NULL DEFAULT (getdate()) 8 ) 9 10 INSERT INTO Department2(name,[Company],groupname) VALUES(‘销售部‘,‘中国你好有限公司XX分公司‘,‘销售组‘) 11 GO 100000 12 13 14 SELECT * FROM Department2 15 16 --先清空[DBCCResult]表里的记录 17 --TRUNCATE TABLE [dbo].[DBCCResult] 18 INSERT INTO DBCCResult EXEC (‘DBCC IND(pratice,Department2,-1) ‘) 19 20 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 21 22 DBCC PAGE([pratice],1,14471,3) 23 GO 24 25 DBCC PAGE([pratice],1,4375,3) 26 GO 27 DBCC PAGE([pratice],1,4376,3) 28 GOView Code
下面这个证明代码在《SQLSERVER企业级平台管理实践》里找的
1 USE [pratice] 2 GO 3 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 4 GO 5 --以下查询使用了聚集索引查找 ctrl+l 6 BEGIN TRAN 7 SELECT GroupName FROM [dbo].[Department2] WHERE DepartmentID IN(32641,361,32281) 8 9 --COMMIT TRAN 10 11 USE [pratice] --要查询申请锁的数据库 12 GO 13 SELECT 14 [request_session_id], 15 c.[program_name], 16 DB_NAME(c.[dbid]) AS dbname, 17 [resource_type], 18 [request_status], 19 [request_mode], 20 [resource_description],OBJECT_NAME(p.[object_id]) AS objectname, 21 p.[index_id] 22 FROM sys.[dm_tran_locks] AS a LEFT JOIN sys.[partitions] AS p 23 ON a.[resource_associated_entity_id]=p.[hobt_id] 24 LEFT JOIN sys.[sysprocesses] AS c ON a.[request_session_id]=c.[spid] 25 WHERE c.[dbid]=DB_ID(‘pratice‘) AND a.[request_session_id]=@@SPID ----要查询申请锁的数据库 26 ORDER BY [request_session_id],[resource_type]View Code
（2）聚集索引扫描
先drop掉Department2表，然后重新创建Department2表
1 --只有聚集索引 2 CREATE TABLE Department2( 3 DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY, 4 Name NVARCHAR(200) NOT NULL, 5 GroupName NVARCHAR(200) NOT NULL, 6 Company NVARCHAR(300), 7 ModifiedDate datetime NOT NULL DEFAULT (getdate()) 8 ) 9 10 DECLARE @i INT 11 SET @i=1 12 WHILE @i < 100000 13 BEGIN 14 INSERT INTO Department3 ( name, [Company], groupname ) 15 VALUES ( ‘销售部‘, ‘中国你好有限公司XX分公司‘+CAST(@i AS VARCHAR(200)), ‘销售组‘+CAST(@i AS VARCHAR(200)) ) 16 SET @i = @i + 1 17 END 18 19 20 SELECT * FROM Department2View Code
证明：
1 USE [pratice] 2 GO 3 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 4 GO 5 --以下查询使用了聚集索引查找 ctrl+l 6 BEGIN TRAN 7 SELECT * FROM [dbo].[Department2] WHERE [GroupName] =‘销售组83421‘ 8 9 --COMMIT TRAN 10 11 USE [pratice] --要查询申请锁的数据库 12 GO 13 SELECT 14 [request_session_id], 15 c.[program_name], 16 DB_NAME(c.[dbid]) AS dbname, 17 [resource_type], 18 [request_status], 19 [request_mode], 20 [resource_description],OBJECT_NAME(p.[object_id]) AS objectname, 21 p.[index_id] 22 FROM sys.[dm_tran_locks] AS a LEFT JOIN sys.[partitions] AS p 23 ON a.[resource_associated_entity_id]=p.[hobt_id] 24 LEFT JOIN sys.[sysprocesses] AS c ON a.[request_session_id]=c.[spid] 25 WHERE c.[dbid]=DB_ID(‘pratice‘) AND a.[request_session_id]=@@SPID ----要查询申请锁的数据库 26 ORDER BY [request_session_id],[resource_type]View Code
上图“以下查询使用了聚集索引查找”，由于本人写SQL代码的时候没有修改上面注释，大家可以不用理会
为什麽会有一个键锁，那么多的页锁，在徐海蔚老师的《SQLSERVER企业级平台管理实践》的书本里第361页说到
因为在有聚集索引的表格上，数据是直接存放在索引的最底层（叶子节点），所以要扫描整个表格里的数据，就要把整个聚集索引
扫描一遍。在这里，聚集索引扫描就相当于一个表扫描。所要用的时间和资源与表扫描没有什么差别
再看一下聚集索引查找的流程
SQLSERVER首先把每个数据页的头一条记录里的DepartmentID的值加上一定范围值hash出一个key值，然后放在KeyHashValue列里
当我要找DepartmentID为110的那条记录里的GroupName和Company的值的时候，首先SQLSERVER根据where DepartmentID=110
将110加上一个范围值hash出一个值，这个值就是KeyHashValue的值，找到KeyHashValue=(f000ff86397c)的那条记录
然后到数据页13791里找出DepartmentID为110的那条记录里的GroupName和Company的值
因为[GroupName]列不是索引列，所以根本找不到KeyHashValue值，所以这里只能使用扫描所有数据页的方法来找出记录，除非找到那条记录
不然SQLSERVER不会停止扫描数据页，所以才看到上图有那么多的页面上加了页锁，SQLSERVER需要逐个数据页逐个数据页去扫描就像堆表的全表扫描那样。
那个键锁我估计是当SQLSERVER找到那条记录之后，需要在
记录的所在页面（即是索引页指向那个记录的数据页的那一行）加上一个键锁，以防止别人删除索引页的那一行记录
但是聚集索引扫描是不是一定比聚集索引查找要差呢？这个不一定，要看实际情况o(∩_∩)o
那么非聚集索引扫描是不是跟聚集索引扫描一样，所要用的时间和资源与表扫描没有什么差别呢？？？
大家可以看一下《SQLSERVER聚集索引与非聚集索引的再次研究（下）》本人做的一个小实验
实验证明了《SQLSERVER企业级平台管理实践》里第363页说到的内容
索引扫描表明SQLSERVER正在扫描一个非聚集索引。由于非聚集索引上一般只会有一小部分字段，所以这里虽然也是扫描，但是
代价会比整表扫描要小很多
------------------------------------------------华丽的分割线--------------------------------------------------------------------
这里有一个问题：没有主键但是有聚集索引，索引页的列数不一样，会多了一列，而这个列（uniquifier）的作用在下面会讲到
这里创建Department3表
1 --只有聚集索引 2 CREATE TABLE Department3( 3 DepartmentID int IDENTITY(1,1) NOT NULL , 4 Name NVARCHAR(200) NOT NULL, 5 GroupName NVARCHAR(200) NOT NULL, 6 Company NVARCHAR(300), 7 ModifiedDate datetime NOT NULL DEFAULT (getdate()) 8 ) 9 10 CREATE CLUSTERED INDEX CL_DepartmentID ON [dbo].[Department3]([DepartmentID]) 11 12 DECLARE @i INT 13 SET @i=1 14 WHILE @i < 100000 15 BEGIN 16 INSERT INTO Department3 ( name, [Company], groupname ) 17 VALUES ( ‘销售部‘, ‘中国你好有限公司XX分公司‘+CAST(@i AS VARCHAR(200)), ‘销售组‘+CAST(@i AS VARCHAR(200)) ) 18 SET @i = @i + 1 19 END 20 21 22 SELECT * FROM Department3 23 24 --TRUNCATE TABLE [dbo].[DBCCResult] 25 26 INSERT INTO DBCCResult EXEC (‘DBCC IND(pratice,Department3,-1) ‘) 27 28 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 29 30 DBCC PAGE([pratice],1,13861,3) 31 GOView Code
可以看到只有聚集索引没有主键的表会比主键表多了一列uniquifier列，这个列的作用会在创建Department5表的时候讲到
-----------------------------------------------华丽的分割线-------------------------------------------------------
下面说一下，复合主键或者聚集索引建立在多个字段上，KeyHashValue只会根据第一个字段生成hash key
当你查询的时候where 后面的字段不包含创建聚集索引时的第一个字段或者复合主键的第一个字段就会聚集索引扫描而不是聚集索引查找
创建Department4表
1 --只有聚集索引 2 CREATE TABLE Department4 --包含复合主键DepartmentID 和Name 3 ( 4 DepartmentID INT IDENTITY(1, 1) NOT NULL , 5 Name NVARCHAR(200) NOT NULL , 6 GroupName NVARCHAR(200) NOT NULL , 7 Company NVARCHAR(300) , 8 ModifiedDate DATETIME NOT NULL DEFAULT ( GETDATE() ) , 9 CONSTRAINT [PK_Department4_1] PRIMARY KEY CLUSTERED 10 ( DepartmentID ASC, 11 Name ASC ) 12 WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, 13 ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] 14 ) ON [PRIMARY] 15 16 17 DECLARE @i INT 18 SET @i=1 19 WHILE @i < 100000 20 BEGIN 21 INSERT INTO Department4 ( name, [Company], groupname ) 22 VALUES ( ‘销售部‘+CAST(@i AS VARCHAR(200)), ‘中国你好有限公司XX分公司‘, ‘销售组‘ ) 23 SET @i = @i + 1 24 END 25 26 27 SELECT * FROM [dbo].[Department4] 28 29 30 31 --TRUNCATE TABLE [dbo].[DBCCResult] 32 INSERT INTO DBCCResult EXEC (‘DBCC IND(pratice,Department4,-1) ‘) 33 34 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 35 36 DBCC PAGE([pratice],1,7102,3) 37 GOView Code
1 SELECT * FROM [dbo].[Department4] WHERE name=‘销售部6‘ --聚集索引扫描 因为name不是复合主键中的第一个字段 2 SELECT * FROM [dbo].[Department4] WHERE name=‘销售部241‘ AND [DepartmentID]=241 --聚集索引查找 3 SELECT * FROM [dbo].[Department4] WHERE [DepartmentID]=241 --聚集索引查找
在建立聚集索引的时候在多个字段上建立聚集索引是没有任何意义的
因为聚集索引查找是根据建立索引的第一个字段来查找，索引扫描的时候会到数据页里扫描 ，而聚集索引的每一行只是一个数据页的范围值从而不能直接定位到要找的那条记录
所以只需要在数据表的一个字段上建立聚集索引就可以了，而究竟要在哪一个字段上建立聚集索引大家一定好好斟酌，本人建议那一个字段在order by中经常要排序的
因为数据页都已经按照聚集索引的第一个字段排好序的了
而不像非聚集索引的索引页跟数据表的记录一一对应，扫描的时候扫描索引页的每一行
大家可以对比一下聚集索引和非聚集索引页的结构
聚集索引页的结构
非聚集索引页的结构
非聚集索引页面的结构会在SQLSERVER聚集索引与非聚集索引的再次研究（下）里讲到
---------------------------------------------------------华丽的分割线-----------------------------------------------------
由于主键不允许重复值，那么就在表上创建一个不唯一的聚集索引，有人说在重复值很多的列上建立聚集索引没有意义
创建Department5表 在Company字段上建立聚集索引，Company字段的值全部都是"中国你好有限公司XX分公司"
1 --只有聚集索引 2 USE [pratice] 3 GO 4 CREATE TABLE Department5 5 ( 6 DepartmentID INT IDENTITY(1, 1) NOT NULL , 7 Name NVARCHAR(200) NOT NULL , 8 GroupName NVARCHAR(200) NOT NULL , 9 Company NVARCHAR(300) , 10 ModifiedDate DATETIME NOT NULL DEFAULT ( GETDATE() ) 11 ) 12 13 CREATE CLUSTERED INDEX CL_Company ON [dbo].[Department5]([Company] ASC) 14 15 --DROP TABLE [dbo].[Department5] 16 17 DECLARE @i INT 18 SET @i=1 19 WHILE @i < 10000 20 BEGIN 21 INSERT INTO Department5 ( name, [Company], groupname ) 22 VALUES ( ‘销售部‘+CAST(@i AS VARCHAR(200)), ‘中国你好有限公司XX分公司‘, ‘销售组‘ ) 23 SET @i = @i + 1 24 ENDView Code
1 --TRUNCATE TABLE [dbo].[DBCCResult] 2 INSERT INTO DBCCResult EXEC (‘DBCC IND(pratice,Department5,-1) ‘) 3 4 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 5 6 DBCC PAGE([pratice],1,14516,3) 7 GOView Code
在Department3表的时候讲到列（uniquifier），为什麽有主键的表没有这个列，而聚集索引的表有这个列，原因在于
主键列不能有重复值，必须是唯一的，而聚集索引允许有重复值，所以聚集索引需要增加列（uniquifier）来区分重复值
而且可以看到这里uniquifier列是没有规律的，不像Department表每隔120行记录在索引页里标记一行
看一下执行计划和执行结果
1 SET STATISTICS TIME ON 2 SELECT * FROM [dbo].[Department5] WHERE name=‘销售部106‘ AND [DepartmentID]=106 --聚集索引扫描 3 SQL Server 执行时间: 4 CPU 时间 = 0 毫秒，占用时间 = 0 毫秒。
至于应不应该在重复值很多的列上建立聚集索引我这里也不敢妄下判断，因为实际环境和这里的测试环境不一样
在MSDN中的解释：http://msdn.microsoft.com/zh-cn/library/ms177484(v=SQL.105).aspx
如果聚集索引不是唯一的索引，SQL Server 将添加在内部生成的值（称为唯一值）以使所有重复键唯一。此四字节的值对于用户不可见
还有一个，看一下叶子节点中的数据页，在每个数据页的每行记录中都有
Slot 101 Column 0 Offset 0x1d Length 4
UNIQUIFIER = 206
因为需要标记索引列中的唯一，所以需要在每行记录中增加一列UNIQUIFIER ，但是这一列在select * 表中数据的时候是select不出来的
还有人说UNIQUIFIER 是一个可变长度的字段，但是Length 4已经说明了是一个占用4字节的字段
1 PAGE: (1:14517)
2
3
4 BUFFER:
5
6
7 BUF @0x03EC9D64
8
9 bpage = 0x1A096000 bhash = 0x00000000 bpageno = (1:14517)
10 bdbid = 5 breferences = 0 bUse1 = 4722
11 bstat = 0x3c00009 blog = 0x32159 bnext = 0x00000000
12
13 PAGE HEADER:
14
15
16 Page @0x1A096000
17
18 m_pageId = (1:14517) m_headerVersion = 1 m_type = 1
19 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x200
20 m_objId (AllocUnitId.idObj) = 317 m_indexId (AllocUnitId.idInd) = 256
21 Metadata: AllocUnitId = 72057594058702848
22 Metadata: PartitionId = 72057594049462272 Metadata: IndexId = 1
23 Metadata: ObjectId = 1022626686 m_prevPage = (1:14514) m_nextPage = (1:14518)
24 pminlen = 16 m_slotCnt = 102 m_freeCnt = 38
25 m_freeData = 7950 m_reservedCnt = 0 m_lsn = (2568:5252:8)
26 m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
27 m_tornBits = -1007571449
28
29 Allocation Status
30
31 GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
32 PFS (1:8088) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
33 ML (1:7) = NOT MIN_LOGGED
34
35 Slot 0 Offset 0x60 Length 77
36
37 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
38
39 Memory Dump @0x0A64C060
40
41 00000000: 30001000 6a000000 d42e7c01 fea10000 ?0...j.....|.....
42 00000010: 0600c004 0021003b 0047004d 00690000 ?.....!.;.G.M.i..
43 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
44 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
45 00000040: 90310030 00360000 952e55c4 7e????????.1.0.6....U.~
46
47 Slot 0 Column 0 Offset 0x1d Length 4
48
49 UNIQUIFIER = 105
50
51 Slot 0 Column 1 Offset 0x21 Length 26
52
53 Company = 中国你好有限公司XX分公司
54
55 Slot 0 Column 2 Offset 0x4 Length 4
56
57 DepartmentID = 106
58
59 Slot 0 Column 3 Offset 0x3b Length 12
60
61 Name = 销售部106
62
63 Slot 0 Column 4 Offset 0x47 Length 6
64
65 GroupName = 销售组
66
67 Slot 0 Column 5 Offset 0x8 Length 8
68
69 ModifiedDate = 07 17 2013 11:04PM
70
71 Slot 1 Offset 0xad Length 77
72
73 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
74
75 Memory Dump @0x0A64C0AD
76
77 00000000: 30001000 6b000000 d42e7c01 fea10000 ?0...k.....|.....
78 00000010: 0600c004 0021003b 0047004d 006a0000 ?.....!.;.G.M.j..
79 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
80 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
81 00000040: 90310030 00370000 952e55c4 7e????????.1.0.7....U.~
82
83 Slot 1 Column 0 Offset 0x1d Length 4
84
85 UNIQUIFIER = 106
86
87 Slot 1 Column 1 Offset 0x21 Length 26
88
89 Company = 中国你好有限公司XX分公司
90
91 Slot 1 Column 2 Offset 0x4 Length 4
92
93 DepartmentID = 107
94
95 Slot 1 Column 3 Offset 0x3b Length 12
96
97 Name = 销售部107
98
99 Slot 1 Column 4 Offset 0x47 Length 6
100
101 GroupName = 销售组
102
103 Slot 1 Column 5 Offset 0x8 Length 8
104
105 ModifiedDate = 07 17 2013 11:04PM
106
107 Slot 2 Offset 0xfa Length 77
108
109 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
110
111 Memory Dump @0x0A64C0FA
112
113 00000000: 30001000 6c000000 d42e7c01 fea10000 ?0...l.....|.....
114 00000010: 0600c004 0021003b 0047004d 006b0000 ?.....!.;.G.M.k..
115 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
116 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
117 00000040: 90310030 00380000 952e55c4 7e????????.1.0.8....U.~
118
119 Slot 2 Column 0 Offset 0x1d Length 4
120
121 UNIQUIFIER = 107
122
123 Slot 2 Column 1 Offset 0x21 Length 26
124
125 Company = 中国你好有限公司XX分公司
126
127 Slot 2 Column 2 Offset 0x4 Length 4
128
129 DepartmentID = 108
130
131 Slot 2 Column 3 Offset 0x3b Length 12
132
133 Name = 销售部108
134
135 Slot 2 Column 4 Offset 0x47 Length 6
136
137 GroupName = 销售组
138
139 Slot 2 Column 5 Offset 0x8 Length 8
140
141 ModifiedDate = 07 17 2013 11:04PM
142
143 Slot 3 Offset 0x147 Length 77
144
145 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
146
147 Memory Dump @0x0A64C147
148
149 00000000: 30001000 6d000000 d42e7c01 fea10000 ?0...m.....|.....
150 00000010: 0600c004 0021003b 0047004d 006c0000 ?.....!.;.G.M.l..
151 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
152 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
153 00000040: 90310030 00390000 952e55c4 7e????????.1.0.9....U.~
154
155 Slot 3 Column 0 Offset 0x1d Length 4
156
157 UNIQUIFIER = 108
158
159 Slot 3 Column 1 Offset 0x21 Length 26
160
161 Company = 中国你好有限公司XX分公司
162
163 Slot 3 Column 2 Offset 0x4 Length 4
164
165 DepartmentID = 109
166
167 Slot 3 Column 3 Offset 0x3b Length 12
168
169 Name = 销售部109
170
171 Slot 3 Column 4 Offset 0x47 Length 6
172
173 GroupName = 销售组
174
175 Slot 3 Column 5 Offset 0x8 Length 8
176
177 ModifiedDate = 07 17 2013 11:04PM
178
179 Slot 4 Offset 0x194 Length 77
180
181 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
182
183 Memory Dump @0x0A64C194
184
185 00000000: 30001000 6e000000 d42e7c01 fea10000 ?0...n.....|.....
186 00000010: 0600c004 0021003b 0047004d 006d0000 ?.....!.;.G.M.m..
187 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
188 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
189 00000040: 90310031 00300000 952e55c4 7e????????.1.1.0....U.~
190
191 Slot 4 Column 0 Offset 0x1d Length 4
192
193 UNIQUIFIER = 109
194
195 Slot 4 Column 1 Offset 0x21 Length 26
196
197 Company = 中国你好有限公司XX分公司
198
199 Slot 4 Column 2 Offset 0x4 Length 4
200
201 DepartmentID = 110
202
203 Slot 4 Column 3 Offset 0x3b Length 12
204
205 Name = 销售部110
206
207 Slot 4 Column 4 Offset 0x47 Length 6
208
209 GroupName = 销售组
210
211 Slot 4 Column 5 Offset 0x8 Length 8
212
213 ModifiedDate = 07 17 2013 11:04PM
214
215 Slot 5 Offset 0x1e1 Length 77
216
217 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
218
219 Memory Dump @0x0A64C1E1
220
221 00000000: 30001000 6f000000 d42e7c01 fea10000 ?0...o.....|.....
222 00000010: 0600c004 0021003b 0047004d 006e0000 ?.....!.;.G.M.n..
223 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
224 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
225 00000040: 90310031 00310000 952e55c4 7e????????.1.1.1....U.~
226
227 Slot 5 Column 0 Offset 0x1d Length 4
228
229 UNIQUIFIER = 110
230
231 Slot 5 Column 1 Offset 0x21 Length 26
232
233 Company = 中国你好有限公司XX分公司
234
235 Slot 5 Column 2 Offset 0x4 Length 4
236
237 DepartmentID = 111
238
239 Slot 5 Column 3 Offset 0x3b Length 12
240
241 Name = 销售部111
242
243 Slot 5 Column 4 Offset 0x47 Length 6
244
245 GroupName = 销售组
246
247 Slot 5 Column 5 Offset 0x8 Length 8
248
249 ModifiedDate = 07 17 2013 11:04PM
250
251 Slot 6 Offset 0x22e Length 77
252
253 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
254
255 Memory Dump @0x0A64C22E
256
257 00000000: 30001000 70000000 d42e7c01 fea10000 ?0...p.....|.....
258 00000010: 0600c004 0021003b 0047004d 006f0000 ?.....!.;.G.M.o..
259 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
260 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
261 00000040: 90310031 00320000 952e55c4 7e????????.1.1.2....U.~
262
263 Slot 6 Column 0 Offset 0x1d Length 4
264
265 UNIQUIFIER = 111
266
267 Slot 6 Column 1 Offset 0x21 Length 26
268
269 Company = 中国你好有限公司XX分公司
270
271 Slot 6 Column 2 Offset 0x4 Length 4
272
273 DepartmentID = 112
274
275 Slot 6 Column 3 Offset 0x3b Length 12
276
277 Name = 销售部112
278
279 Slot 6 Column 4 Offset 0x47 Length 6
280
281 GroupName = 销售组
282
283 Slot 6 Column 5 Offset 0x8 Length 8
284
285 ModifiedDate = 07 17 2013 11:04PM
286
287 Slot 7 Offset 0x27b Length 77
288
289 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
290
291 Memory Dump @0x0A64C27B
292
293 00000000: 30001000 71000000 d42e7c01 fea10000 ?0...q.....|.....
294 00000010: 0600c004 0021003b 0047004d 00700000 ?.....!.;.G.M.p..
295 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
296 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
297 00000040: 90310031 00330000 952e55c4 7e????????.1.1.3....U.~
298
299 Slot 7 Column 0 Offset 0x1d Length 4
300
301 UNIQUIFIER = 112
302
303 Slot 7 Column 1 Offset 0x21 Length 26
304
305 Company = 中国你好有限公司XX分公司
306
307 Slot 7 Column 2 Offset 0x4 Length 4
308
309 DepartmentID = 113
310
311 Slot 7 Column 3 Offset 0x3b Length 12
312
313 Name = 销售部113
314
315 Slot 7 Column 4 Offset 0x47 Length 6
316
317 GroupName = 销售组
318
319 Slot 7 Column 5 Offset 0x8 Length 8
320
321 ModifiedDate = 07 17 2013 11:04PM
322
323 Slot 8 Offset 0x2c8 Length 77
324
325 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
326
327 Memory Dump @0x0A64C2C8
328
329 00000000: 30001000 72000000 d42e7c01 fea10000 ?0...r.....|.....
330 00000010: 0600c004 0021003b 0047004d 00710000 ?.....!.;.G.M.q..
331 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
332 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
333 00000040: 90310031 00340000 952e55c4 7e????????.1.1.4....U.~
334
335 Slot 8 Column 0 Offset 0x1d Length 4
336
337 UNIQUIFIER = 113
338
339 Slot 8 Column 1 Offset 0x21 Length 26
340
341 Company = 中国你好有限公司XX分公司
342
343 Slot 8 Column 2 Offset 0x4 Length 4
344
345 DepartmentID = 114
346
347 Slot 8 Column 3 Offset 0x3b Length 12
348
349 Name = 销售部114
350
351 Slot 8 Column 4 Offset 0x47 Length 6
352
353 GroupName = 销售组
354
355 Slot 8 Column 5 Offset 0x8 Length 8
356
357 ModifiedDate = 07 17 2013 11:04PM
358
359 Slot 9 Offset 0x315 Length 77
360
361 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
362
363 Memory Dump @0x0A64C315
364
365 00000000: 30001000 73000000 d42e7c01 fea10000 ?0...s.....|.....
366 00000010: 0600c004 0021003b 0047004d 00720000 ?.....!.;.G.M.r..
367 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
368 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
369 00000040: 90310031 00350000 952e55c4 7e????????.1.1.5....U.~
370
371 Slot 9 Column 0 Offset 0x1d Length 4
372
373 UNIQUIFIER = 114
374
375 Slot 9 Column 1 Offset 0x21 Length 26
376
377 Company = 中国你好有限公司XX分公司
378
379 Slot 9 Column 2 Offset 0x4 Length 4
380
381 DepartmentID = 115
382
383 Slot 9 Column 3 Offset 0x3b Length 12
384
385 Name = 销售部115
386
387 Slot 9 Column 4 Offset 0x47 Length 6
388
389 GroupName = 销售组
390
391 Slot 9 Column 5 Offset 0x8 Length 8
392
393 ModifiedDate = 07 17 2013 11:04PM
394
395 Slot 10 Offset 0x362 Length 77
396
397 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
398
399 Memory Dump @0x0A64C362
400
401 00000000: 30001000 74000000 d52e7c01 fea10000 ?0...t.....|.....
402 00000010: 0600c004 0021003b 0047004d 00730000 ?.....!.;.G.M.s..
403 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
404 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
405 00000040: 90310031 00360000 952e55c4 7e????????.1.1.6....U.~
406
407 Slot 10 Column 0 Offset 0x1d Length 4
408
409 UNIQUIFIER = 115
410
411 Slot 10 Column 1 Offset 0x21 Length 26
412
413 Company = 中国你好有限公司XX分公司
414
415 Slot 10 Column 2 Offset 0x4 Length 4
416
417 DepartmentID = 116
418
419 Slot 10 Column 3 Offset 0x3b Length 12
420
421 Name = 销售部116
422
423 Slot 10 Column 4 Offset 0x47 Length 6
424
425 GroupName = 销售组
426
427 Slot 10 Column 5 Offset 0x8 Length 8
428
429 ModifiedDate = 07 17 2013 11:04PM
430
431 Slot 11 Offset 0x3af Length 77
432
433 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
434
435 Memory Dump @0x0A64C3AF
436
437 00000000: 30001000 75000000 d52e7c01 fea10000 ?0...u.....|.....
438 00000010: 0600c004 0021003b 0047004d 00740000 ?.....!.;.G.M.t..
439 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
440 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
441 00000040: 90310031 00370000 952e55c4 7e????????.1.1.7....U.~
442
443 Slot 11 Column 0 Offset 0x1d Length 4
444
445 UNIQUIFIER = 116
446
447 Slot 11 Column 1 Offset 0x21 Length 26
448
449 Company = 中国你好有限公司XX分公司
450
451 Slot 11 Column 2 Offset 0x4 Length 4
452
453 DepartmentID = 117
454
455 Slot 11 Column 3 Offset 0x3b Length 12
456
457 Name = 销售部117
458
459 Slot 11 Column 4 Offset 0x47 Length 6
460
461 GroupName = 销售组
462
463 Slot 11 Column 5 Offset 0x8 Length 8
464
465 ModifiedDate = 07 17 2013 11:04PM
466
467 Slot 12 Offset 0x3fc Length 77
468
469 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
470
471 Memory Dump @0x0A64C3FC
472
473 00000000: 30001000 76000000 d52e7c01 fea10000 ?0...v.....|.....
474 00000010: 0600c004 0021003b 0047004d 00750000 ?.....!.;.G.M.u..
475 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
476 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
477 00000040: 90310031 00380000 952e55c4 7e????????.1.1.8....U.~
478
479 Slot 12 Column 0 Offset 0x1d Length 4
480
481 UNIQUIFIER = 117
482
483 Slot 12 Column 1 Offset 0x21 Length 26
484
485 Company = 中国你好有限公司XX分公司
486
487 Slot 12 Column 2 Offset 0x4 Length 4
488
489 DepartmentID = 118
490
491 Slot 12 Column 3 Offset 0x3b Length 12
492
493 Name = 销售部118
494
495 Slot 12 Column 4 Offset 0x47 Length 6
496
497 GroupName = 销售组
498
499 Slot 12 Column 5 Offset 0x8 Length 8
500
501 ModifiedDate = 07 17 2013 11:04PM
502
503 Slot 13 Offset 0x449 Length 77
504
505 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
506
507 Memory Dump @0x0A64C449
508
509 00000000: 30001000 77000000 d52e7c01 fea10000 ?0...w.....|.....
510 00000010: 0600c004 0021003b 0047004d 00760000 ?.....!.;.G.M.v..
511 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
512 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
513 00000040: 90310031 00390000 952e55c4 7e????????.1.1.9....U.~
514
515 Slot 13 Column 0 Offset 0x1d Length 4
516
517 UNIQUIFIER = 118
518
519 Slot 13 Column 1 Offset 0x21 Length 26
520
521 Company = 中国你好有限公司XX分公司
522
523 Slot 13 Column 2 Offset 0x4 Length 4
524
525 DepartmentID = 119
526
527 Slot 13 Column 3 Offset 0x3b Length 12
528
529 Name = 销售部119
530
531 Slot 13 Column 4 Offset 0x47 Length 6
532
533 GroupName = 销售组
534
535 Slot 13 Column 5 Offset 0x8 Length 8
536
537 ModifiedDate = 07 17 2013 11:04PM
538
539 Slot 14 Offset 0x496 Length 77
540
541 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
542
543 Memory Dump @0x0A64C496
544
545 00000000: 30001000 78000000 d52e7c01 fea10000 ?0...x.....|.....
546 00000010: 0600c004 0021003b 0047004d 00770000 ?.....!.;.G.M.w..
547 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
548 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
549 00000040: 90310032 00300000 952e55c4 7e????????.1.2.0....U.~
550
551 Slot 14 Column 0 Offset 0x1d Length 4
552
553 UNIQUIFIER = 119
554
555 Slot 14 Column 1 Offset 0x21 Length 26
556
557 Company = 中国你好有限公司XX分公司
558
559 Slot 14 Column 2 Offset 0x4 Length 4
560
561 DepartmentID = 120
562
563 Slot 14 Column 3 Offset 0x3b Length 12
564
565 Name = 销售部120
566
567 Slot 14 Column 4 Offset 0x47 Length 6
568
569 GroupName = 销售组
570
571 Slot 14 Column 5 Offset 0x8 Length 8
572
573 ModifiedDate = 07 17 2013 11:04PM
574
575 Slot 15 Offset 0x4e3 Length 77
576
577 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
578
579 Memory Dump @0x0A64C4E3
580
581 00000000: 30001000 79000000 d52e7c01 fea10000 ?0...y.....|.....
582 00000010: 0600c004 0021003b 0047004d 00780000 ?.....!.;.G.M.x..
583 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
584 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
585 00000040: 90310032 00310000 952e55c4 7e????????.1.2.1....U.~
586
587 Slot 15 Column 0 Offset 0x1d Length 4
588
589 UNIQUIFIER = 120
590
591 Slot 15 Column 1 Offset 0x21 Length 26
592
593 Company = 中国你好有限公司XX分公司
594
595 Slot 15 Column 2 Offset 0x4 Length 4
596
597 DepartmentID = 121
598
599 Slot 15 Column 3 Offset 0x3b Length 12
600
601 Name = 销售部121
602
603 Slot 15 Column 4 Offset 0x47 Length 6
604
605 GroupName = 销售组
606
607 Slot 15 Column 5 Offset 0x8 Length 8
608
609 ModifiedDate = 07 17 2013 11:04PM
610
611 Slot 16 Offset 0x530 Length 77
612
613 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
614
615 Memory Dump @0x0A64C530
616
617 00000000: 30001000 7a000000 d52e7c01 fea10000 ?0...z.....|.....
618 00000010: 0600c004 0021003b 0047004d 00790000 ?.....!.;.G.M.y..
619 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
620 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
621 00000040: 90310032 00320000 952e55c4 7e????????.1.2.2....U.~
622
623 Slot 16 Column 0 Offset 0x1d Length 4
624
625 UNIQUIFIER = 121
626
627 Slot 16 Column 1 Offset 0x21 Length 26
628
629 Company = 中国你好有限公司XX分公司
630
631 Slot 16 Column 2 Offset 0x4 Length 4
632
633 DepartmentID = 122
634
635 Slot 16 Column 3 Offset 0x3b Length 12
636
637 Name = 销售部122
638
639 Slot 16 Column 4 Offset 0x47 Length 6
640
641 GroupName = 销售组
642
643 Slot 16 Column 5 Offset 0x8 Length 8
644
645 ModifiedDate = 07 17 2013 11:04PM
646
647 Slot 17 Offset 0x57d Length 77
648
649 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
650
651 Memory Dump @0x0A64C57D
652
653 00000000: 30001000 7b000000 d52e7c01 fea10000 ?0...{.....|.....
654 00000010: 0600c004 0021003b 0047004d 007a0000 ?.....!.;.G.M.z..
655 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
656 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
657 00000040: 90310032 00330000 952e55c4 7e????????.1.2.3....U.~
658
659 Slot 17 Column 0 Offset 0x1d Length 4
660
661 UNIQUIFIER = 122
662
663 Slot 17 Column 1 Offset 0x21 Length 26
664
665 Company = 中国你好有限公司XX分公司
666
667 Slot 17 Column 2 Offset 0x4 Length 4
668
669 DepartmentID = 123
670
671 Slot 17 Column 3 Offset 0x3b Length 12
672
673 Name = 销售部123
674
675 Slot 17 Column 4 Offset 0x47 Length 6
676
677 GroupName = 销售组
678
679 Slot 17 Column 5 Offset 0x8 Length 8
680
681 ModifiedDate = 07 17 2013 11:04PM
682
683 Slot 18 Offset 0x5ca Length 77
684
685 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
686
687 Memory Dump @0x0A64C5CA
688
689 00000000: 30001000 7c000000 d52e7c01 fea10000 ?0...|.....|.....
690 00000010: 0600c004 0021003b 0047004d 007b0000 ?.....!.;.G.M.{..
691 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
692 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
693 00000040: 90310032 00340000 952e55c4 7e????????.1.2.4....U.~
694
695 Slot 18 Column 0 Offset 0x1d Length 4
696
697 UNIQUIFIER = 123
698
699 Slot 18 Column 1 Offset 0x21 Length 26
700
701 Company = 中国你好有限公司XX分公司
702
703 Slot 18 Column 2 Offset 0x4 Length 4
704
705 DepartmentID = 124
706
707 Slot 18 Column 3 Offset 0x3b Length 12
708
709 Name = 销售部124
710
711 Slot 18 Column 4 Offset 0x47 Length 6
712
713 GroupName = 销售组
714
715 Slot 18 Column 5 Offset 0x8 Length 8
716
717 ModifiedDate = 07 17 2013 11:04PM
718
719 Slot 19 Offset 0x617 Length 77
720
721 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
722
723 Memory Dump @0x0A64C617
724
725 00000000: 30001000 7d000000 d52e7c01 fea10000 ?0...}.....|.....
726 00000010: 0600c004 0021003b 0047004d 007c0000 ?.....!.;.G.M.|..
727 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
728 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
729 00000040: 90310032 00350000 952e55c4 7e????????.1.2.5....U.~
730
731 Slot 19 Column 0 Offset 0x1d Length 4
732
733 UNIQUIFIER = 124
734
735 Slot 19 Column 1 Offset 0x21 Length 26
736
737 Company = 中国你好有限公司XX分公司
738
739 Slot 19 Column 2 Offset 0x4 Length 4
740
741 DepartmentID = 125
742
743 Slot 19 Column 3 Offset 0x3b Length 12
744
745 Name = 销售部125
746
747 Slot 19 Column 4 Offset 0x47 Length 6
748
749 GroupName = 销售组
750
751 Slot 19 Column 5 Offset 0x8 Length 8
752
753 ModifiedDate = 07 17 2013 11:04PM
754
755 Slot 20 Offset 0x664 Length 77
756
757 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
758
759 Memory Dump @0x0A64C664
760
761 00000000: 30001000 7e000000 d52e7c01 fea10000 ?0...~.....|.....
762 00000010: 0600c004 0021003b 0047004d 007d0000 ?.....!.;.G.M.}..
763 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
764 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
765 00000040: 90310032 00360000 952e55c4 7e????????.1.2.6....U.~
766
767 Slot 20 Column 0 Offset 0x1d Length 4
768
769 UNIQUIFIER = 125
770
771 Slot 20 Column 1 Offset 0x21 Length 26
772
773 Company = 中国你好有限公司XX分公司
774
775 Slot 20 Column 2 Offset 0x4 Length 4
776
777 DepartmentID = 126
778
779 Slot 20 Column 3 Offset 0x3b Length 12
780
781 Name = 销售部126
782
783 Slot 20 Column 4 Offset 0x47 Length 6
784
785 GroupName = 销售组
786
787 Slot 20 Column 5 Offset 0x8 Length 8
788
789 ModifiedDate = 07 17 2013 11:04PM
790
791 Slot 21 Offset 0x6b1 Length 77
792
793 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
794
795 Memory Dump @0x0A64C6B1
796
797 00000000: 30001000 7f000000 d52e7c01 fea10000 ?0.........|.....
798 00000010: 0600c004 0021003b 0047004d 007e0000 ?.....!.;.G.M.~..
799 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
800 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
801 00000040: 90310032 00370000 952e55c4 7e????????.1.2.7....U.~
802
803 Slot 21 Column 0 Offset 0x1d Length 4
804
805 UNIQUIFIER = 126
806
807 Slot 21 Column 1 Offset 0x21 Length 26
808
809 Company = 中国你好有限公司XX分公司
810
811 Slot 21 Column 2 Offset 0x4 Length 4
812
813 DepartmentID = 127
814
815 Slot 21 Column 3 Offset 0x3b Length 12
816
817 Name = 销售部127
818
819 Slot 21 Column 4 Offset 0x47 Length 6
820
821 GroupName = 销售组
822
823 Slot 21 Column 5 Offset 0x8 Length 8
824
825 ModifiedDate = 07 17 2013 11:04PM
826
827 Slot 22 Offset 0x6fe Length 77
828
829 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
830
831 Memory Dump @0x0A64C6FE
832
833 00000000: 30001000 80000000 d52e7c01 fea10000 ?0.........|.....
834 00000010: 0600c004 0021003b 0047004d 007f0000 ?.....!.;.G.M....
835 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
836 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
837 00000040: 90310032 00380000 952e55c4 7e????????.1.2.8....U.~
838
839 Slot 22 Column 0 Offset 0x1d Length 4
840
841 UNIQUIFIER = 127
842
843 Slot 22 Column 1 Offset 0x21 Length 26
844
845 Company = 中国你好有限公司XX分公司
846
847 Slot 22 Column 2 Offset 0x4 Length 4
848
849 DepartmentID = 128
850
851 Slot 22 Column 3 Offset 0x3b Length 12
852
853 Name = 销售部128
854
855 Slot 22 Column 4 Offset 0x47 Length 6
856
857 GroupName = 销售组
858
859 Slot 22 Column 5 Offset 0x8 Length 8
860
861 ModifiedDate = 07 17 2013 11:04PM
862
863 Slot 23 Offset 0x74b Length 77
864
865 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
866
867 Memory Dump @0x0A64C74B
868
869 00000000: 30001000 81000000 d52e7c01 fea10000 ?0.........|.....
870 00000010: 0600c004 0021003b 0047004d 00800000 ?.....!.;.G.M....
871 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
872 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
873 00000040: 90310032 00390000 952e55c4 7e????????.1.2.9....U.~
874
875 Slot 23 Column 0 Offset 0x1d Length 4
876
877 UNIQUIFIER = 128
878
879 Slot 23 Column 1 Offset 0x21 Length 26
880
881 Company = 中国你好有限公司XX分公司
882
883 Slot 23 Column 2 Offset 0x4 Length 4
884
885 DepartmentID = 129
886
887 Slot 23 Column 3 Offset 0x3b Length 12
888
889 Name = 销售部129
890
891 Slot 23 Column 4 Offset 0x47 Length 6
892
893 GroupName = 销售组
894
895 Slot 23 Column 5 Offset 0x8 Length 8
896
897 ModifiedDate = 07 17 2013 11:04PM
898
899 Slot 24 Offset 0x798 Length 77
900
901 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
902
903 Memory Dump @0x0A64C798
904
905 00000000: 30001000 82000000 d52e7c01 fea10000 ?0.........|.....
906 00000010: 0600c004 0021003b 0047004d 00810000 ?.....!.;.G.M....
907 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
908 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
909 00000040: 90310033 00300000 952e55c4 7e????????.1.3.0....U.~
910
911 Slot 24 Column 0 Offset 0x1d Length 4
912
913 UNIQUIFIER = 129
914
915 Slot 24 Column 1 Offset 0x21 Length 26
916
917 Company = 中国你好有限公司XX分公司
918
919 Slot 24 Column 2 Offset 0x4 Length 4
920
921 DepartmentID = 130
922
923 Slot 24 Column 3 Offset 0x3b Length 12
924
925 Name = 销售部130
926
927 Slot 24 Column 4 Offset 0x47 Length 6
928
929 GroupName = 销售组
930
931 Slot 24 Column 5 Offset 0x8 Length 8
932
933 ModifiedDate = 07 17 2013 11:04PM
934
935 Slot 25 Offset 0x7e5 Length 77
936
937 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
938
939 Memory Dump @0x0A64C7E5
940
941 00000000: 30001000 83000000 d52e7c01 fea10000 ?0.........|.....
942 00000010: 0600c004 0021003b 0047004d 00820000 ?.....!.;.G.M....
943 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
944 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
945 00000040: 90310033 00310000 952e55c4 7e????????.1.3.1....U.~
946
947 Slot 25 Column 0 Offset 0x1d Length 4
948
949 UNIQUIFIER = 130
950
951 Slot 25 Column 1 Offset 0x21 Length 26
952
953 Company = 中国你好有限公司XX分公司
954
955 Slot 25 Column 2 Offset 0x4 Length 4
956
957 DepartmentID = 131
958
959 Slot 25 Column 3 Offset 0x3b Length 12
960
961 Name = 销售部131
962
963 Slot 25 Column 4 Offset 0x47 Length 6
964
965 GroupName = 销售组
966
967 Slot 25 Column 5 Offset 0x8 Length 8
968
969 ModifiedDate = 07 17 2013 11:04PM
970
971 Slot 26 Offset 0x832 Length 77
972
973 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
974
975 Memory Dump @0x0A64C832
976
977 00000000: 30001000 84000000 d52e7c01 fea10000 ?0.........|.....
978 00000010: 0600c004 0021003b 0047004d 00830000 ?.....!.;.G.M....
979 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
980 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
981 00000040: 90310033 00320000 952e55c4 7e????????.1.3.2....U.~
982
983 Slot 26 Column 0 Offset 0x1d Length 4
984
985 UNIQUIFIER = 131
986
987 Slot 26 Column 1 Offset 0x21 Length 26
988
989 Company = 中国你好有限公司XX分公司
990
991 Slot 26 Column 2 Offset 0x4 Length 4
992
993 DepartmentID = 132
994
995 Slot 26 Column 3 Offset 0x3b Length 12
996
997 Name = 销售部132
998
999 Slot 26 Column 4 Offset 0x47 Length 6
1000
1001 GroupName = 销售组
1002
1003 Slot 26 Column 5 Offset 0x8 Length 8
1004
1005 ModifiedDate = 07 17 2013 11:04PM
1006
1007 Slot 27 Offset 0x87f Length 77
1008
1009 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1010
1011 Memory Dump @0x0A64C87F
1012
1013 00000000: 30001000 85000000 d52e7c01 fea10000 ?0.........|.....
1014 00000010: 0600c004 0021003b 0047004d 00840000 ?.....!.;.G.M....
1015 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
1016 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
1017 00000040: 90310033 00330000 952e55c4 7e????????.1.3.3....U.~
1018
1019 Slot 27 Column 0 Offset 0x1d Length 4
1020
1021 UNIQUIFIER = 132
1022
1023 Slot 27 Column 1 Offset 0x21 Length 26
1024
1025 Company = 中国你好有限公司XX分公司
1026
1027 Slot 27 Column 2 Offset 0x4 Length 4
1028
1029 DepartmentID = 133
1030
1031 Slot 27 Column 3 Offset 0x3b Length 12
1032
1033 Name = 销售部133
1034
1035 Slot 27 Column 4 Offset 0x47 Length 6
1036
1037 GroupName = 销售组
1038
1039 Slot 27 Column 5 Offset 0x8 Length 8
1040
1041 ModifiedDate = 07 17 2013 11:04PM
1042
1043 Slot 28 Offset 0x8cc Length 77
1044
1045 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1046
1047 Memory Dump @0x0A64C8CC
1048
1049 00000000: 30001000 86000000 d52e7c01 fea10000 ?0.........|.....
1050 00000010: 0600c004 0021003b 0047004d 00850000 ?.....!.;.G.M....
1051 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
1052 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
1053 00000040: 90310033 00340000 952e55c4 7e????????.1.3.4....U.~
1054
1055 Slot 28 Column 0 Offset 0x1d Length 4
1056
1057 UNIQUIFIER = 133
1058
1059 Slot 28 Column 1 Offset 0x21 Length 26
1060
1061 Company = 中国你好有限公司XX分公司
1062
1063 Slot 28 Column 2 Offset 0x4 Length 4
1064
1065 DepartmentID = 134
1066
1067 Slot 28 Column 3 Offset 0x3b Length 12
1068
1069 Name = 销售部134
1070
1071 Slot 28 Column 4 Offset 0x47 Length 6
1072
1073 GroupName = 销售组
1074
1075 Slot 28 Column 5 Offset 0x8 Length 8
1076
1077 ModifiedDate = 07 17 2013 11:04PM
1078
1079 Slot 29 Offset 0x919 Length 77
1080
1081 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1082
1083 Memory Dump @0x0A64C919
1084
1085 00000000: 30001000 87000000 d52e7c01 fea10000 ?0.........|.....
1086 00000010: 0600c004 0021003b 0047004d 00860000 ?.....!.;.G.M....
1087 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
1088 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
1089 00000040: 90310033 00350000 952e55c4 7e????????.1.3.5....U.~
1090
1091 Slot 29 Column 0 Offset 0x1d Length 4
1092
1093 UNIQUIFIER = 134
1094
1095 Slot 29 Column 1 Offset 0x21 Length 26
1096
1097 Company = 中国你好有限公司XX分公司
1098
1099 Slot 29 Column 2 Offset 0x4 Length 4
1100
1101 DepartmentID = 135
1102
1103 Slot 29 Column 3 Offset 0x3b Length 12
1104
1105 Name = 销售部135
1106
1107 Slot 29 Column 4 Offset 0x47 Length 6
1108
1109 GroupName = 销售组
1110
1111 Slot 29 Column 5 Offset 0x8 Length 8
1112
1113 ModifiedDate = 07 17 2013 11:04PM
1114
1115 Slot 30 Offset 0x966 Length 77
1116
1117 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1118
1119 Memory Dump @0x0A64C966
1120
1121 00000000: 30001000 88000000 d62e7c01 fea10000 ?0.........|.....
1122 00000010: 0600c004 0021003b 0047004d 00870000 ?.....!.;.G.M....
1123 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
1124 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
1125 00000040: 90310033 00360000 952e55c4 7e????????.1.3.6....U.~
1126
1127 Slot 30 Column 0 Offset 0x1d Length 4
1128
1129 UNIQUIFIER = 135
1130
1131 Slot 30 Column 1 Offset 0x21 Length 26
1132
1133 Company = 中国你好有限公司XX分公司
1134
1135 Slot 30 Column 2 Offset 0x4 Length 4
1136
1137 DepartmentID = 136
1138
1139 Slot 30 Column 3 Offset 0x3b Length 12
1140
1141 Name = 销售部136
1142
1143 Slot 30 Column 4 Offset 0x47 Length 6
1144
1145 GroupName = 销售组
1146
1147 Slot 30 Column 5 Offset 0x8 Length 8
1148
1149 ModifiedDate = 07 17 2013 11:04PM
1150
1151 Slot 31 Offset 0x9b3 Length 77
1152
1153 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1154
1155 Memory Dump @0x0A64C9B3
1156
1157 00000000: 30001000 89000000 d62e7c01 fea10000 ?0.........|.....
1158 00000010: 0600c004 0021003b 0047004d 00880000 ?.....!.;.G.M....
1159 00000020: 002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.
1160 00000030: 53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.
1161 00000040: 90310033 00370000 952e55c4 7e????????.1.3.7....U.~
1162
1163 Slot 31 Column 0 Offset 0x1d Length 4
1164
1165 UNIQUIFIER = 136
1166
1167 Slot 31 Column 1 Offset 0x21 Length 26
1168
1169 Company = 中国你好有限公司XX分公司
1170
1171 Slot 31 Column 2 Offset 0x4 Length 4
1172
1173 DepartmentID = 137
1174
1175 Slot 31 Column 3 Offset 0x3b Length 12
1176
1177 Name = 销售部137
1178
1179 Slot 31 Column 4 Offset 0x47 Length 6
1180
1181 GroupName = 销售组
1182
1183 Slot 31 Column 5 Offset 0x8 Length 8
1184
1185 ModifiedDate = 07 17 2013 11:04PM
1186
1187 Slot 32 Offset 0xa00 Length 77
1188
1189 Record Type = PRIMARY_RECORD Record At
