Sage EasyPay Data Model

Entity ExcelWkSheet

Description of Entity ExcelWkSheet

Details about the worksheet, e.g. Basis, Header, Footer, Colour Scheme etc

List of all Dependencies of the Entity ExcelWkSheet

Relation_964

Reference

Relation_13

Reference

List of Attributes of the Entity ExcelWkSheet

Entity Attribute Excel Spreadsheet ID of the Entity ExcelWkSheet

Card of Attribute Excel Spreadsheet ID of the Entity ExcelWkSheet

Name	Excel Spreadsheet ID
Code	ExcelSpreadsheetId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Excel Spreadsheet ID of the Entity ExcelWkSheet

Shows the identity of the excel spreadsheet. This is also the primary key for the ExcelSpreadsheet table.
Example: Emp Accumulated Rpt / Coy Breakdown Rpt / Coy LveAsOfDate Rpt etc

Entity Attribute WkSheetSysId of the Entity ExcelWkSheet

Card of Attribute WkSheetSysId of the Entity ExcelWkSheet

Name	WkSheetSysId
Code	WkSheetSysId
Data Type	integer
Mandatory	Yes

Description of Attribute WkSheetSysId of the Entity ExcelWkSheet

A system generated identity. It is blind to the user. This is also the primary key for the ExcelWkSheet table.
Example: Emp Statistics Rpt / Coy Variance Rpt / Dept GenPayRecon Rpt etc

Entity Attribute WkSheet Name of the Entity ExcelWkSheet

Card of Attribute WkSheet Name of the Entity ExcelWkSheet

Name	WkSheet Name
Code	WkSheetName
Data Type	char(50)
Mandatory	No

Description of Attribute WkSheet Name of the Entity ExcelWkSheet

Shows the name of the worksheet.
Example: Statistics / Variance / Pay Reconciliation etc

Entity Attribute WkSheet Order of the Entity ExcelWkSheet

Card of Attribute WkSheet Order of the Entity ExcelWkSheet

Name	WkSheet Order
Code	WkSheetOrder
Data Type	integer
Mandatory	No

Description of Attribute WkSheet Order of the Entity ExcelWkSheet

Shows the order of the worksheet.

Entity Attribute Summary Level of the Entity ExcelWkSheet

Card of Attribute Summary Level of the Entity ExcelWkSheet

Name	Summary Level
Code	WkSheetRptSumLvl
Data Type	char(20)
Mandatory	No

Description of Attribute Summary Level of the Entity ExcelWkSheet

Shows the summary level of the worksheet report.
Example: SumLevelEmpee / SumLevelCompany / SumLevelBasis etc

Entity Attribute Basis 1 of the Entity ExcelWkSheet

Card of Attribute Basis 1 of the Entity ExcelWkSheet

Name	Basis 1
Code	WkSheetRptBasis1
Data Type	char(20)
Mandatory	No

Description of Attribute Basis 1 of the Entity ExcelWkSheet

Shows the basis for the worksheet report.

Entity Attribute Basis 2 of the Entity ExcelWkSheet

Card of Attribute Basis 2 of the Entity ExcelWkSheet

Name	Basis 2
Code	WkSheetRptBasis2
Data Type	char(20)
Mandatory	No

Description of Attribute Basis 2 of the Entity ExcelWkSheet

Shows the basis for the worksheet report.

Entity Attribute Basis 3 of the Entity ExcelWkSheet

Card of Attribute Basis 3 of the Entity ExcelWkSheet

Name	Basis 3
Code	WkSheetRptBasis3
Data Type	char(20)
Mandatory	No

Description of Attribute Basis 3 of the Entity ExcelWkSheet

Shows the basis for the worksheet report.

Entity Attribute Has Report Header of the Entity ExcelWkSheet

Card of Attribute Has Report Header of the Entity ExcelWkSheet

Name	Has Report Header
Code	WkSheetHasRptHeader
Data Type	smallint
Mandatory	No

Description of Attribute Has Report Header of the Entity ExcelWkSheet

Indicates that the worksheet has a report header, in a form of a checkbox.

Entity Attribute Has Report Footer of the Entity ExcelWkSheet

Card of Attribute Has Report Footer of the Entity ExcelWkSheet

Name	Has Report Footer
Code	WkSheetHasRptFooter
Data Type	smallint
Mandatory	No

Description of Attribute Has Report Footer of the Entity ExcelWkSheet

Indicates that the worksheet has a report footer, in a form of a checkbox.

Entity Attribute WkSheetRpt Header of the Entity ExcelWkSheet

Card of Attribute WkSheetRpt Header of the Entity ExcelWkSheet

Name	WkSheetRpt Header
Code	WkSheetRptHeader
Data Type	long binary
Mandatory	No

Description of Attribute WkSheetRpt Header of the Entity ExcelWkSheet

Shows the report header for the worksheet.

Entity Attribute WkSheetRpt Footer of the Entity ExcelWkSheet

Card of Attribute WkSheetRpt Footer of the Entity ExcelWkSheet

Name	WkSheetRpt Footer
Code	WkSheetRptFooter
Data Type	long binary
Mandatory	No

Description of Attribute WkSheetRpt Footer of the Entity ExcelWkSheet

Shows the report footer for the worksheet.

Entity Attribute Has Report Header > Colour Scheme ID of the Entity ExcelWkSheet

Card of Attribute Has Report Header > Colour Scheme ID of the Entity ExcelWkSheet

Name	Has Report Header > Colour Scheme ID
Code	WkSheetHeadColourSchemeId
Data Type	char(20)
Mandatory	No

Description of Attribute Has Report Header > Colour Scheme ID of the Entity ExcelWkSheet

Shows the identity of the header's colour scheme.

Entity Attribute Has Report Footer > Colour Scheme ID of the Entity ExcelWkSheet

Card of Attribute Has Report Footer > Colour Scheme ID of the Entity ExcelWkSheet

Name	Has Report Footer > Colour Scheme ID
Code	WkSheetFootColourSchemeId
Data Type	char(20)
Mandatory	No

Description of Attribute Has Report Footer > Colour Scheme ID of the Entity ExcelWkSheet

Shows the identity of the footer's colour scheme.

Entity Attribute Title's Colour Scheme ID of the Entity ExcelWkSheet

Card of Attribute Title's Colour Scheme ID of the Entity ExcelWkSheet

Name	Title's Colour Scheme ID
Code	WkSheetTitleColourSchemeId
Data Type	char(20)
Mandatory	No

Description of Attribute Title's Colour Scheme ID of the Entity ExcelWkSheet

Shows the identity of the title's colour scheme.

Home