Entity CostGroup

Description of Entity CostGroup

When a cost record is created, you need to select a cost group. Each employee's cost group is stored on the Cost Details record. The cost group is set to the default and the default is set in the Costing Default window.
Example: Monthly Group / Project Group


List of all Dependencies of the Entity CostGroup

Name

Code

Class Name

Relation_336150

Relation_336150

Reference

Relation_336148

Relation_336148

Reference

Relation_1164219

Relation_1164219

Reference


List of Attributes of the Entity CostGroup

Name

Code

Costing Group

CostGroupId

Description

CostGroupDesc

No Of Sub Period

NoSubPeriod

Financial Year starts on

Period1StartMonth

Exchange Rate

CostExchangeRateId

SubPeriod1EndDate

SubPeriod1EndDate

SubPeriod2EndDate

SubPeriod2EndDate

SubPeriod3EndDate

SubPeriod3EndDate

Map Costing Period 1 to Pay Group Period

MapPayGroupPeriod

Map Costing Year to Pay Group Year

MapPayGroupYear


Entity Attribute Costing Group of the Entity CostGroup

Card of Attribute Costing Group of the Entity CostGroup

Name

Costing Group

Code

CostGroupId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Costing Group of the Entity CostGroup

Shows the identity of the cost group. It is the primary key for the CostGroup table.
Example: Monthly Group / Project Group


Entity Attribute Description of the Entity CostGroup

Card of Attribute Description of the Entity CostGroup

Name

Description

Code

CostGroupDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity CostGroup

Stores any description about the cost group.


Entity Attribute No Of Sub Period of the Entity CostGroup

Card of Attribute No Of Sub Period of the Entity CostGroup

Name

No Of Sub Period

Code

NoSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute No Of Sub Period of the Entity CostGroup

Holds the sub period.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)


Entity Attribute Financial Year starts on of the Entity CostGroup

Card of Attribute Financial Year starts on of the Entity CostGroup

Name

Financial Year starts on

Code

Period1StartMonth

Data Type

integer

Mandatory

No


Description of Attribute Financial Year starts on of the Entity CostGroup

Shows the option to choose when the company starts its financial year.
Example: January = "1' / February = "2" / March = "3" etc


Entity Attribute Exchange Rate of the Entity CostGroup

Card of Attribute Exchange Rate of the Entity CostGroup

Name

Exchange Rate

Code

CostExchangeRateId

Data Type

char(20)

Mandatory

No


Description of Attribute Exchange Rate of the Entity CostGroup

Shows the identity of the exchange rate.


Entity Attribute SubPeriod1EndDate of the Entity CostGroup

Card of Attribute SubPeriod1EndDate of the Entity CostGroup

Name

SubPeriod1EndDate

Code

SubPeriod1EndDate

Data Type

integer

Mandatory

No


Description of Attribute SubPeriod1EndDate of the Entity CostGroup

Shows the end date of the first sub period.
It is usually in the format: DD-MM-YYYY.


Entity Attribute SubPeriod2EndDate of the Entity CostGroup

Card of Attribute SubPeriod2EndDate of the Entity CostGroup

Name

SubPeriod2EndDate

Code

SubPeriod2EndDate

Data Type

integer

Mandatory

No


Description of Attribute SubPeriod2EndDate of the Entity CostGroup

Shows the end date of the second sub period.
It is usually in the format: DD-MM-YYYY.


Entity Attribute SubPeriod3EndDate of the Entity CostGroup

Card of Attribute SubPeriod3EndDate of the Entity CostGroup

Name

SubPeriod3EndDate

Code

SubPeriod3EndDate

Data Type

integer

Mandatory

No


Description of Attribute SubPeriod3EndDate of the Entity CostGroup

Shows the end date of the third sub period.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Map Costing Period 1 to Pay Group Period of the Entity CostGroup

Card of Attribute Map Costing Period 1 to Pay Group Period of the Entity CostGroup

Name

Map Costing Period 1 to Pay Group Period

Code

MapPayGroupPeriod

Data Type

integer

Mandatory

No


Description of Attribute Map Costing Period 1 to Pay Group Period of the Entity CostGroup

Shows the start of the map costing to the end of the pay group period.
Example: January = "1" / February = "2" / March = "3" etc


Entity Attribute Map Costing Year to Pay Group Year of the Entity CostGroup

Card of Attribute Map Costing Year to Pay Group Year of the Entity CostGroup

Name

Map Costing Year to Pay Group Year

Code

MapPayGroupYear

Data Type

char(20)

Mandatory

No


Description of Attribute Map Costing Year to Pay Group Year of the Entity CostGroup

Shows the start of the costing year to the end of the pay group year.
Example: Current / Previous