Entity CostSubPeriod

Description of Entity CostSubPeriod

States the sub period for the costing module.


List of all Dependencies of the Entity CostSubPeriod

Name

Code

Class Name

Relation_324868

Relation_324868

Reference

Relation_1164221

Relation_1164221

Reference

Relation_516347

Relation_516347

Reference


List of Attributes of the Entity CostSubPeriod

Name

Code

CostPeriodSysId

CostPeriodSysId

Cost Sub Period

CostSubPeriod

Cost Error

CostError

Cost Local Foreign Rate

CostLocalForeignRate

Status

Status

Created By

CreatedBy

Last Processed

LastProcessed


Entity Attribute CostPeriodSysId of the Entity CostSubPeriod

Card of Attribute CostPeriodSysId of the Entity CostSubPeriod

Name

CostPeriodSysId

Code

CostPeriodSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CostPeriodSysId of the Entity CostSubPeriod

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


Entity Attribute Cost Sub Period of the Entity CostSubPeriod

Card of Attribute Cost Sub Period of the Entity CostSubPeriod

Name

Cost Sub Period

Code

CostSubPeriod

Data Type

integer

Mandatory

Yes


Description of Attribute Cost Sub Period of the Entity CostSubPeriod

Shows the sub period for the cost. This also acts as a primary key for the CostSubPeriod table.

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 Cost Error of the Entity CostSubPeriod

Card of Attribute Cost Error of the Entity CostSubPeriod

Name

Cost Error

Code

CostError

Data Type

smallint

Mandatory

No


Description of Attribute Cost Error of the Entity CostSubPeriod

Shows if there are any errors in the cost.


Entity Attribute Cost Local Foreign Rate of the Entity CostSubPeriod

Card of Attribute Cost Local Foreign Rate of the Entity CostSubPeriod

Name

Cost Local Foreign Rate

Code

CostLocalForeignRate

Data Type

double

Mandatory

No


Description of Attribute Cost Local Foreign Rate of the Entity CostSubPeriod

Shows the local foreign rate for the cost.


Entity Attribute Status of the Entity CostSubPeriod

Card of Attribute Status of the Entity CostSubPeriod

Name

Status

Code

Status

Data Type

char(20)

Mandatory

No


Description of Attribute Status of the Entity CostSubPeriod

Shows the status.
Example: Active (Unlocked) / Locked


Entity Attribute Created By of the Entity CostSubPeriod

Card of Attribute Created By of the Entity CostSubPeriod

Name

Created By

Code

CreatedBy

Data Type

char(20)

Mandatory

No


Description of Attribute Created By of the Entity CostSubPeriod

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


Entity Attribute Last Processed of the Entity CostSubPeriod

Card of Attribute Last Processed of the Entity CostSubPeriod

Name

Last Processed

Code

LastProcessed

Data Type

timestamp

Mandatory

No


Description of Attribute Last Processed of the Entity CostSubPeriod

Shows the date with time of when the record was last processed.
Example: 2013-02-19 14:33:45.115