Sage EasyPay Data Model

Entity ImportWorkSheet

Description of Entity ImportWorkSheet

This entity shows the details of the worksheet. This is different from the worksheet name in the spreadsheet. You can have multiple IDs pointing to the same worksheet. As for the rows and columns, it allows you to state where your data begins and it depends on your data series type selection.

List of all Dependencies of the Entity ImportWorkSheet

Relation_772

Reference

Relation_558

Reference

List of Attributes of the Entity ImportWorkSheet

Entity Attribute WorkSheet ID of the Entity ImportWorkSheet

Card of Attribute WorkSheet ID of the Entity ImportWorkSheet

Name	WorkSheet ID
Code	WorkSheetID
Data Type	char(20)
Mandatory	Yes

Description of Attribute WorkSheet ID of the Entity ImportWorkSheet

Shows the identity of the worksheet. This acts as a primary key for the ImportWorkSheet table.

Entity Attribute WorkSheet Name of the Entity ImportWorkSheet

Card of Attribute WorkSheet Name of the Entity ImportWorkSheet

Name	WorkSheet Name
Code	WorkSheetName
Data Type	char(50)
Mandatory	No

Description of Attribute WorkSheet Name of the Entity ImportWorkSheet

Shows the name of the worksheet.

Entity Attribute Data Series Type of the Entity ImportWorkSheet

Card of Attribute Data Series Type of the Entity ImportWorkSheet

Name	Data Series Type
Code	WorkSheetType
Data Type	char(20)
Mandatory	No

Description of Attribute Data Series Type of the Entity ImportWorkSheet

Shows the type of the worksheet.
Example: Rows / Columns

Entity Attribute Physical Table Name of the Entity ImportWorkSheet

Card of Attribute Physical Table Name of the Entity ImportWorkSheet

Name	Physical Table Name
Code	PhysicalTableName
Data Type	char(50)
Mandatory	No

Description of Attribute Physical Table Name of the Entity ImportWorkSheet

Shows a physical name for the entity. It also holds the primary key for the InterfaceTableMapping entity.
Example: Branch / EmpCode1 / ColourScheme etc

Entity Attribute Ending Column of the Entity ImportWorkSheet

Card of Attribute Ending Column of the Entity ImportWorkSheet

Name	Ending Column
Code	EndingColumn
Data Type	char(2)
Mandatory	No

Description of Attribute Ending Column of the Entity ImportWorkSheet

Shows the ending column for the worksheet.

Entity Attribute Ending Row of the Entity ImportWorkSheet

Card of Attribute Ending Row of the Entity ImportWorkSheet

Name	Ending Row
Code	EndingRow
Data Type	integer
Mandatory	No

Description of Attribute Ending Row of the Entity ImportWorkSheet

Shows the ending row for the worksheet.

Entity Attribute Starting Column of the Entity ImportWorkSheet

Card of Attribute Starting Column of the Entity ImportWorkSheet

Name	Starting Column
Code	StartingColumn
Data Type	char(2)
Mandatory	No

Description of Attribute Starting Column of the Entity ImportWorkSheet

Shows the starting column for the worksheet.

Entity Attribute Starting Row of the Entity ImportWorkSheet

Card of Attribute Starting Row of the Entity ImportWorkSheet

Name	Starting Row
Code	StartingRow
Data Type	integer
Mandatory	No

Description of Attribute Starting Row of the Entity ImportWorkSheet

Shows the starting row for the worksheet.

Entity Attribute Log File Name of the Entity ImportWorkSheet

Card of Attribute Log File Name of the Entity ImportWorkSheet

Name	Log File Name
Code	LogFileName
Data Type	char(50)
Mandatory	No

Description of Attribute Log File Name of the Entity ImportWorkSheet

Shows the name of the log file.

Entity Attribute Log File Path of the Entity ImportWorkSheet

Card of Attribute Log File Path of the Entity ImportWorkSheet

Name	Log File Path
Code	LogFilePath
Data Type	char(200)
Mandatory	No

Description of Attribute Log File Path of the Entity ImportWorkSheet

Shows the path of the log file.

Home