Sage EasyPay Data Model

Entity ExcelWSItemRptLayout

Description of Entity ExcelWSItemRptLayout

Shows the details of the layout for the worksheet item report.

List of all Dependencies of the Entity ExcelWSItemRptLayout

Reference

List of Attributes of the Entity ExcelWSItemRptLayout

WSRptLayoutSysId

WSRptLayoutSysId

WSRptLayoutOrder

WSRptLayoutOrder

WSRptLayoutYear

WSRptLayoutMthPeriod

WSRpt Layout Sub Period

WSRptLayoutSubPeriod

WSRpt Layout Pay Rec ID Type

WSRptLayoutPayRecIdType

Entity Attribute WSRptLayoutSysId of the Entity ExcelWSItemRptLayout

Card of Attribute WSRptLayoutSysId of the Entity ExcelWSItemRptLayout

Name	WSRptLayoutSysId
Code	WSRptLayoutSysId
Data Type	integer
Mandatory	Yes

Description of Attribute WSRptLayoutSysId of the Entity ExcelWSItemRptLayout

A system generated identity. It is blind to the user. This is also the primary key for the ExcelWsItemRptLayout table.

Entity Attribute WSRptLayoutOrder of the Entity ExcelWSItemRptLayout

Card of Attribute WSRptLayoutOrder of the Entity ExcelWSItemRptLayout

Name	WSRptLayoutOrder
Code	WSRptLayoutOrder
Data Type	integer
Mandatory	No

Description of Attribute WSRptLayoutOrder of the Entity ExcelWSItemRptLayout

Shows the worksheet report layout order.

Entity Attribute Year of the Entity ExcelWSItemRptLayout

Card of Attribute Year of the Entity ExcelWSItemRptLayout

Name	Year
Code	WSRptLayoutYear
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity ExcelWSItemRptLayout

Shows the year for the worksheet report layout.

Entity Attribute Period of the Entity ExcelWSItemRptLayout

Card of Attribute Period of the Entity ExcelWSItemRptLayout

Name	Period
Code	WSRptLayoutMthPeriod
Data Type	integer
Mandatory	No

Description of Attribute Period of the Entity ExcelWSItemRptLayout

Shows the month for the worksheet report layout.
Example: January = "1" / February = "2" / March = "3" etc

Entity Attribute WSRpt Layout Sub Period of the Entity ExcelWSItemRptLayout

Card of Attribute WSRpt Layout Sub Period of the Entity ExcelWSItemRptLayout

Name	WSRpt Layout Sub Period
Code	WSRptLayoutSubPeriod
Data Type	integer
Mandatory	No

Description of Attribute WSRpt Layout Sub Period of the Entity ExcelWSItemRptLayout

Shows the sub period for the worksheet report layout.

Entity Attribute WSRpt Layout Pay Rec ID Type of the Entity ExcelWSItemRptLayout

Card of Attribute WSRpt Layout Pay Rec ID Type of the Entity ExcelWSItemRptLayout

Name	WSRpt Layout Pay Rec ID Type
Code	WSRptLayoutPayRecIdType
Data Type	char(20)
Mandatory	No

Description of Attribute WSRpt Layout Pay Rec ID Type of the Entity ExcelWSItemRptLayout

Shows the identity of the pay record type for the worksheet report layout.
Example: Normal / Normal Time Sheet