Entity ExcelSpreadsheet

Description of Entity ExcelSpreadsheet

Stores information about the excel spreadsheet.


List of all Dependencies of the Entity ExcelSpreadsheet

Name

Code

Class Name

Relation_13

Relation_13

Reference

Relation_983587

Relation_983587

Reference


List of Attributes of the Entity ExcelSpreadsheet

Name

Code

Excel Spreadsheet ID

ExcelSpreadsheetId

Description

ExcelSpreadsheetDesc

Report File Name

ExcelRptFileName


Entity Attribute Excel Spreadsheet ID of the Entity ExcelSpreadsheet

Card of Attribute Excel Spreadsheet ID of the Entity ExcelSpreadsheet

Name

Excel Spreadsheet ID

Code

ExcelSpreadsheetId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Excel Spreadsheet ID of the Entity ExcelSpreadsheet

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 Description of the Entity ExcelSpreadsheet

Card of Attribute Description of the Entity ExcelSpreadsheet

Name

Description

Code

ExcelSpreadsheetDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity ExcelSpreadsheet

Stores the description for the excel spreadsheet.
Example:
Employee Accumulated Listing Report
Employee Accumulated Listing Report
Company Leave Summary As Of Date Listing Report
etc


Entity Attribute Report File Name of the Entity ExcelSpreadsheet

Card of Attribute Report File Name of the Entity ExcelSpreadsheet

Name

Report File Name

Code

ExcelRptFileName

Data Type

char(50)

Mandatory

No


Description of Attribute Report File Name of the Entity ExcelSpreadsheet

Shows the file name for the excel report.