(local) Documentation
QK365_Remuneration
Server Author Created File Path
(local) Administrator 31 三月 2016 11:03
C:\Users\Administrator\Documents\My Database Documentation\薪资数据库表设计-2016-03-31T11-03-03.docx
Table of Contents
Table of Contents .............................................................................................................................................................. 2
(local) ...................................................................................................................................................................... 3
User databases . ................................................................................................................................................. 5
QK365_Remuneration Database .................................................................................................................. 6
Tables ..................................................................................................................................................... 9
[dbo].[HR_ConfigTax] . ...................................................................................................................... 10
[dbo].[HR_ConfigTaxRule] ............................................................................................................... 11
[dbo].[HR_ConfigType] . .................................................................................................................... 13
[dbo].[HR_CusEmpInfo] ................................................................................................................... 14
[dbo].[HR_CusSaleSlip ] . .................................................................................................................. 16
[dbo].[HR_EmpAttendanceStatistics] . ............................................................................................... 18
[dbo].[HR_FullRoomNumber] ........................................................................................................... 20
[dbo].[HR_SalaryCalc] . ..................................................................................................................... 22
[dbo].[HR_SalaryCalcConfig] . ........................................................................................................... 23
[dbo].[HR_SalaryStatistics] . .............................................................................................................. 24
Databases(1)
QK365_Remuneration
Server Properties
Server Settings
Advanced Server Settings
Author: Administrator
Copyright 2016 - All Rights Reserved Page 3 of 25
Author: Administrator
Copyright 2016 - All Rights Reserved Page 4 of 25
Project>(local)>User databases
Databases(1)
QK365_Remuneration
Author: Administrator
Copyright 2016 - All Rights Reserved
Page 5 of 25
Database Properties
Database Options
Author: Administrator
Copyright 2016 - All Rights Reserved
Page 6 of 25
Files
Page 7 of 25
Author: Administrator
Copyright 2016 - All Rights Reserved
Project>(local)>User databases>QK365_Remuneration
Author: Administrator
Copyright 2016 - All Rights Reserved Page 8 of 25
Project>(local)>User databases>QK365_Remuneration>Tables
Objects
Author: Administrator
Copyright 2016 - All Rights Reserved Page 9 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_ConfigTax
MS_Description
配置项表
Properties
Columns
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 10 of 25
MS_Description
配置项明细规则表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 11 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 12 of 25
MS_Description
配置设定类型表
Properties
Columns
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 13 of 25
MS_Description
员工信息表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 14 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 15 of 25
MS_Description
销售单数表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 16 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 17 of 25
MS_Description
员工月度考勤计算结果表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 18 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 19 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_FullRoomNumber
MS_Description
满房数表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 20 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_FullRoomNumber
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 21 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_SalaryCalc
MS_Description
薪资计算逻辑基表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 22 of 25
MS_Description
公司职位薪资计算逻辑关系表
Properties
Columns
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 23 of 25
MS_Description
员工月度薪资计算结果表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 24 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 25 of 25
(local) Documentation
QK365_Remuneration
Server Author Created File Path
(local) Administrator 31 三月 2016 11:03
C:\Users\Administrator\Documents\My Database Documentation\薪资数据库表设计-2016-03-31T11-03-03.docx
Table of Contents
Table of Contents .............................................................................................................................................................. 2
(local) ...................................................................................................................................................................... 3
User databases . ................................................................................................................................................. 5
QK365_Remuneration Database .................................................................................................................. 6
Tables ..................................................................................................................................................... 9
[dbo].[HR_ConfigTax] . ...................................................................................................................... 10
[dbo].[HR_ConfigTaxRule] ............................................................................................................... 11
[dbo].[HR_ConfigType] . .................................................................................................................... 13
[dbo].[HR_CusEmpInfo] ................................................................................................................... 14
[dbo].[HR_CusSaleSlip ] . .................................................................................................................. 16
[dbo].[HR_EmpAttendanceStatistics] . ............................................................................................... 18
[dbo].[HR_FullRoomNumber] ........................................................................................................... 20
[dbo].[HR_SalaryCalc] . ..................................................................................................................... 22
[dbo].[HR_SalaryCalcConfig] . ........................................................................................................... 23
[dbo].[HR_SalaryStatistics] . .............................................................................................................. 24
Databases(1)
QK365_Remuneration
Server Properties
Server Settings
Advanced Server Settings
Author: Administrator
Copyright 2016 - All Rights Reserved Page 3 of 25
Author: Administrator
Copyright 2016 - All Rights Reserved Page 4 of 25
Project>(local)>User databases
Databases(1)
QK365_Remuneration
Author: Administrator
Copyright 2016 - All Rights Reserved
Page 5 of 25
Database Properties
Database Options
Author: Administrator
Copyright 2016 - All Rights Reserved
Page 6 of 25
Files
Page 7 of 25
Author: Administrator
Copyright 2016 - All Rights Reserved
Project>(local)>User databases>QK365_Remuneration
Author: Administrator
Copyright 2016 - All Rights Reserved Page 8 of 25
Project>(local)>User databases>QK365_Remuneration>Tables
Objects
Author: Administrator
Copyright 2016 - All Rights Reserved Page 9 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_ConfigTax
MS_Description
配置项表
Properties
Columns
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 10 of 25
MS_Description
配置项明细规则表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 11 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 12 of 25
MS_Description
配置设定类型表
Properties
Columns
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 13 of 25
MS_Description
员工信息表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 14 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 15 of 25
MS_Description
销售单数表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 16 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 17 of 25
MS_Description
员工月度考勤计算结果表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 18 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 19 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_FullRoomNumber
MS_Description
满房数表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 20 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_FullRoomNumber
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 21 of 25
Project>(local)>User databases>QK365_Remuneration>Tables>dbo.HR_SalaryCalc
MS_Description
薪资计算逻辑基表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 22 of 25
MS_Description
公司职位薪资计算逻辑关系表
Properties
Columns
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 23 of 25
MS_Description
员工月度薪资计算结果表
Properties
Columns
Author: Administrator
Copyright 2016 - All Rights Reserved Page 24 of 25
Indexes
Author: Administrator
Copyright 2016 - All Rights Reserved Page 25 of 25