Sage EasyPay Data Model

Shows the identity of the usage item. It also holds the primary key for the UsageItem table.
Example: HasCustomizedModule / CPFSubmitCount / EECountOrdWageProj etc

Entity Attribute Description of the Entity UsageItem

Card of Attribute Description of the Entity UsageItem

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

Description of Attribute Description of the Entity UsageItem

A description of the item.
Example: Has Customized Module / CPF Report Generation Count / Employee Count with Ordinary Wage Projection etc

Entity Attribute Item Key 1 Description of the Entity UsageItem

Card of Attribute Item Key 1 Description of the Entity UsageItem

Name	Item Key 1 Description
Code	ItemKey1Desc
Data Type	char(100)
Mandatory	No

Description of Attribute Item Key 1 Description of the Entity UsageItem

A description for the key 1 item.

Entity Attribute Item Key 2 Description of the Entity UsageItem

Card of Attribute Item Key 2 Description of the Entity UsageItem

Name	Item Key 2 Description
Code	ItemKey2Desc
Data Type	char(100)
Mandatory	No

Description of Attribute Item Key 2 Description of the Entity UsageItem

A description for key 2 description.

Entity Attribute Item Key 3 Description of the Entity UsageItem

Card of Attribute Item Key 3 Description of the Entity UsageItem

Name	Item Key 3 Description
Code	ItemKey3Desc
Data Type	char(100)
Mandatory	No

Description of Attribute Item Key 3 Description of the Entity UsageItem

A description of the key 3 item.

Entity Attribute Location of the Entity UsageItem

Card of Attribute Location of the Entity UsageItem

Name	Location
Code	FieldLoc
Data Type	char(50)
Mandatory	No

Description of Attribute Location of the Entity UsageItem

States the field location.
Example: String / Date / Integer

Entity Attribute Query of the Entity UsageItem

Card of Attribute Query of the Entity UsageItem

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

Description of Attribute Query of the Entity UsageItem

Stores the query to call a specific item.

Entity Attribute Query Condition of the Entity UsageItem

Card of Attribute Query Condition of the Entity UsageItem

Name	Query Condition
Code	QueryCond
Data Type	char(255)
Mandatory	No

Description of Attribute Query Condition of the Entity UsageItem

Shows the continued version of the query.

Home