Sage EasyPay Data Model

Entity RptConfig

Description of Entity RptConfig

Stores information about the report configuration.

List of all Dependencies of the Entity RptConfig

Relation_1879241

Reference

Relation_1879240

Reference

Relation_1834511

Reference

List of Attributes of the Entity RptConfig

Entity Attribute Rpt Config ID of the Entity RptConfig

Card of Attribute Rpt Config ID of the Entity RptConfig

Name	Rpt Config ID
Code	RptConfigId
Data Type	char(40)
Mandatory	Yes

Description of Attribute Rpt Config ID of the Entity RptConfig

Shows the identity of the report configuration. This is the primary key for the RptConfig table.

Entity Attribute Description of the Entity RptConfig

Card of Attribute Description of the Entity RptConfig

Name	Description
Code	RptConfigDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity RptConfig

Stores a description about the report configuration.

Entity Attribute Is Default Config of the Entity RptConfig

Card of Attribute Is Default Config of the Entity RptConfig

Name	Is Default Config
Code	IsDefaultConfig
Data Type	smallint
Mandatory	No

Description of Attribute Is Default Config of the Entity RptConfig

Indicates if it is a default configuration, in a form of a checkbox.

Entity Attribute Rpt Query ID of the Entity RptConfig

Card of Attribute Rpt Query ID of the Entity RptConfig

Name	Rpt Query ID
Code	RptQueryId
Data Type	char(20)
Mandatory	No

Description of Attribute Rpt Query ID of the Entity RptConfig

Shows the identity of the report query.

Entity Attribute Rpt File Type of the Entity RptConfig

Card of Attribute Rpt File Type of the Entity RptConfig

Name	Rpt File Type
Code	RptFileType
Data Type	char(20)
Mandatory	No

Description of Attribute Rpt File Type of the Entity RptConfig

Shows the file type of the report.
Example: Txt / html / PDF / rtf etc

Entity Attribute DelBefIns of the Entity RptConfig

Card of Attribute DelBefIns of the Entity RptConfig

Name	DelBefIns
Code	DelBefIns
Data Type	smallint
Mandatory	No

Entity Attribute Rpt Summary Level of the Entity RptConfig

Card of Attribute Rpt Summary Level of the Entity RptConfig

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

Description of Attribute Rpt Summary Level of the Entity RptConfig

Shows the summary level for the report.
Example: RptSummEmployee etc

Entity Attribute Is Individual Rpt of the Entity RptConfig

Card of Attribute Is Individual Rpt of the Entity RptConfig

Name	Is Individual Rpt
Code	IsIndividualRpt
Data Type	smallint
Mandatory	No

Description of Attribute Is Individual Rpt of the Entity RptConfig

Indicates if it is an individual report, in a form of a checkbox.

Entity Attribute Rpt Output To of the Entity RptConfig

Card of Attribute Rpt Output To of the Entity RptConfig

Name	Rpt Output To
Code	RptOutputTo
Data Type	char(20)
Mandatory	No

Description of Attribute Rpt Output To of the Entity RptConfig

Shows the output of the file.
Example: RptOpToFile, i.e. the output of the report is to a file.

Entity Attribute RptFilePath of the Entity RptConfig

Card of Attribute RptFilePath of the Entity RptConfig

Name	RptFilePath
Code	RptFilePath
Data Type	char(100)
Mandatory	No

Description of Attribute RptFilePath of the Entity RptConfig

Shows the file path of the report.
Example ...\Doc\PayrollReport.pdf etc

Entity Attribute Compress File Ext of the Entity RptConfig

Card of Attribute Compress File Ext of the Entity RptConfig

Name	Compress File Ext
Code	CompressFileExt
Data Type	char(20)
Mandatory	No

Description of Attribute Compress File Ext of the Entity RptConfig

Shows the compressed file extension.

Home