Sage EasyPay Data Model

Entity RemSetup

Description of Entity RemSetup

Shows the setup for the reminder. When should the reminder pop up, who is the creator, when is the due date etc

List of all Dependencies of the Entity RemSetup

Relationship_766

Relationship_767

Reference

Relationship_762

Relationship_762

Reference

Relationship_763

Relationship_763

Reference

List of Attributes of the Entity RemSetup

Entity Attribute RemSetupSysID of the Entity RemSetup

Card of Attribute RemSetupSysID of the Entity RemSetup

Name	RemSetupSysID
Code	RemSetupSysID
Data Type	integer
Mandatory	Yes

Description of Attribute RemSetupSysID of the Entity RemSetup

A system generated identity. It is blind to the user. It also acts as a primary key for the RemSetup table.

Entity Attribute Message of the Entity RemSetup

Card of Attribute Message of the Entity RemSetup

Name	Message
Code	Message
Data Type	char(255)
Mandatory	No

Description of Attribute Message of the Entity RemSetup

Shows the message for the task / reminder.

Entity Attribute Details of the Entity RemSetup

Card of Attribute Details of the Entity RemSetup

Name	Details
Code	Details
Data Type	varchar(3000)
Mandatory	No

Description of Attribute Details of the Entity RemSetup

Stores any details about the task / reminder / product.

Entity Attribute Due Date of the Entity RemSetup

Card of Attribute Due Date of the Entity RemSetup

Name	Due Date
Code	DueDate
Data Type	date
Mandatory	No

Description of Attribute Due Date of the Entity RemSetup

Shows the date of when the task has to be done.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Occurrence of the Entity RemSetup

Card of Attribute Occurrence of the Entity RemSetup

Name	Occurrence
Code	Occurrence
Data Type	char(20)
Mandatory	No

Description of Attribute Occurrence of the Entity RemSetup

Shows the occurrence of the reminder.

Entity Attribute OccurrenceValue of the Entity RemSetup

Card of Attribute OccurrenceValue of the Entity RemSetup

Name	OccurrenceValue
Code	OccurrenceValue
Data Type	integer
Mandatory	No

Description of Attribute OccurrenceValue of the Entity RemSetup

Shows how many times for the reminder setup to occur.

Entity Attribute ParamValueU1 of the Entity RemSetup

Card of Attribute ParamValueU1 of the Entity RemSetup

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

Description of Attribute ParamValueU1 of the Entity RemSetup

Shows the user defined parameter value.

Entity Attribute ParamValueU2 of the Entity RemSetup

Card of Attribute ParamValueU2 of the Entity RemSetup

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

Description of Attribute ParamValueU2 of the Entity RemSetup

Shows the user defined parameter value.

Entity Attribute ParamValueU3 of the Entity RemSetup

Card of Attribute ParamValueU3 of the Entity RemSetup

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

Description of Attribute ParamValueU3 of the Entity RemSetup

Shows the user defined parameter value.

Entity Attribute ParamValueU4 of the Entity RemSetup

Card of Attribute ParamValueU4 of the Entity RemSetup

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

Description of Attribute ParamValueU4 of the Entity RemSetup

Shows the user defined parameter value.

Entity Attribute ParamValueU5 of the Entity RemSetup

Card of Attribute ParamValueU5 of the Entity RemSetup

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

Description of Attribute ParamValueU5 of the Entity RemSetup

Shows the user defined parameter value.

Entity Attribute Created By of the Entity RemSetup

Card of Attribute Created By of the Entity RemSetup

Name	Created By
Code	CreatedBy
Data Type	char(20)
Mandatory	No

Description of Attribute Created By of the Entity RemSetup

Shows who was the creator.
Example: "S" which stands for System, i.e. it was system generated.

Entity Attribute Created Date Time of the Entity RemSetup

Card of Attribute Created Date Time of the Entity RemSetup

Name	Created Date Time
Code	CreatedDateTime
Data Type	timestamp
Mandatory	No

Description of Attribute Created Date Time of the Entity RemSetup

Shows the date and time of when the task/reminder was created.

Entity Attribute ModifiedBy of the Entity RemSetup

Card of Attribute ModifiedBy of the Entity RemSetup

Name	ModifiedBy
Code	ModifiedBy
Data Type	char(20)
Mandatory	No

Description of Attribute ModifiedBy of the Entity RemSetup

Shows if any modifications were made and by who.

Entity Attribute Modified Date Time of the Entity RemSetup

Card of Attribute Modified Date Time of the Entity RemSetup

Name	Modified Date Time
Code	ModifiedDateTime
Data Type	timestamp
Mandatory	No

Description of Attribute Modified Date Time of the Entity RemSetup

Shows the date and time of the modifications.