Entity CostRecord

Description of Entity CostRecord

This feature can only be accessed from the Cost Record window. Various fields will be locked depending on whether you select Insert/Modify or Duplicate, however the overall concept is still the same, i.e. you can modify the cost item on a cost record.


List of all Dependencies of the Entity CostRecord

Name

Code

Class Name

Relation_1671023

Relation_1671023

Reference

Relation_324868

Relation_324868

Reference

Relation_324865

Relation_324865

Reference

Relation_512717

Relation_512717

Reference

Relation_541189

Relation_541189

Reference


List of Attributes of the Entity CostRecord

Name

Code

GL Code

GLCode

Cost Centre ID

CostCentreId

CostPeriodSysId

CostPeriodSysId

CostRecordSysId

CostRecordSysId

Cost Credit Amount

CostCreditAmt

Cost Debit Amount

CostDebitAmt

Cost Credit Adj

CostCreditAdj

Cost Debit Adj

CostDebitAdj

Cost Credit Foreign Amount

CostCreditForeignAmt

Cost Debit Foreign Amount

CostDebitForeignAmt

Allocation Type

CostAllocType

Allocation Value

CostAllocValue

Cost Credit Bf Avg

CostCreditBfAvg

Cost Debit Bf Avg

CostDebitBfAvg

Cost Credit Foreign Bf Avg

CostCreditForeignBfAvg

Cost Debit Foreign Bf Avg

CostDebitForeignBfAvg

Created By

CreatedBy


Entity Attribute GL Code of the Entity CostRecord

Card of Attribute GL Code of the Entity CostRecord

Name

GL Code

Code

GLCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute GL Code of the Entity CostRecord

Shows the code for the general ledger. This is the primary key for the GLCode table.


Entity Attribute Cost Centre ID of the Entity CostRecord

Card of Attribute Cost Centre ID of the Entity CostRecord

Name

Cost Centre ID

Code

CostCentreId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Cost Centre ID of the Entity CostRecord

Shows the identity of the cost centre. This is the primary key for the CostCentre table.
Example: 100 / 100-02 etc


Entity Attribute CostPeriodSysId of the Entity CostRecord

Card of Attribute CostPeriodSysId of the Entity CostRecord

Name

CostPeriodSysId

Code

CostPeriodSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CostPeriodSysId of the Entity CostRecord

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


Entity Attribute CostRecordSysId of the Entity CostRecord

Card of Attribute CostRecordSysId of the Entity CostRecord

Name

CostRecordSysId

Code

CostRecordSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CostRecordSysId of the Entity CostRecord

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


Entity Attribute Cost Credit Amount of the Entity CostRecord

Card of Attribute Cost Credit Amount of the Entity CostRecord

Name

Cost Credit Amount

Code

CostCreditAmt

Data Type

double

Mandatory

No


Description of Attribute Cost Credit Amount of the Entity CostRecord

Shows the credit amount for the cost.


Entity Attribute Cost Debit Amount of the Entity CostRecord

Card of Attribute Cost Debit Amount of the Entity CostRecord

Name

Cost Debit Amount

Code

CostDebitAmt

Data Type

double

Mandatory

No


Description of Attribute Cost Debit Amount of the Entity CostRecord

Shows the debit amount for the cost.


Entity Attribute Cost Credit Adj of the Entity CostRecord

Card of Attribute Cost Credit Adj of the Entity CostRecord

Name

Cost Credit Adj

Code

CostCreditAdj

Data Type

double

Mandatory

No


Description of Attribute Cost Credit Adj of the Entity CostRecord

Shows the credit adjustment for the cost.


Entity Attribute Cost Debit Adj of the Entity CostRecord

Card of Attribute Cost Debit Adj of the Entity CostRecord

Name

Cost Debit Adj

Code

CostDebitAdj

Data Type

double

Mandatory

No


Description of Attribute Cost Debit Adj of the Entity CostRecord

Shows the debit adjustment for the cost.


Entity Attribute Cost Credit Foreign Amount of the Entity CostRecord

Card of Attribute Cost Credit Foreign Amount of the Entity CostRecord

Name

Cost Credit Foreign Amount

Code

CostCreditForeignAmt

Data Type

double

Mandatory

No


Description of Attribute Cost Credit Foreign Amount of the Entity CostRecord

Shows the credit foreign amount for the cost.


Entity Attribute Cost Debit Foreign Amount of the Entity CostRecord

Card of Attribute Cost Debit Foreign Amount of the Entity CostRecord

Name

Cost Debit Foreign Amount

Code

CostDebitForeignAmt

Data Type

double

Mandatory

No


Description of Attribute Cost Debit Foreign Amount of the Entity CostRecord

Shows the debit foreign amount for the cost.


Entity Attribute Allocation Type of the Entity CostRecord

Card of Attribute Allocation Type of the Entity CostRecord

Name

Allocation Type

Code

CostAllocType

Data Type

char(20)

Mandatory

No


Description of Attribute Allocation Type of the Entity CostRecord

Shows the allocation type for the cost.
Example: Balance / Percentage / Fixed Amount


Entity Attribute Allocation Value of the Entity CostRecord

Card of Attribute Allocation Value of the Entity CostRecord

Name

Allocation Value

Code

CostAllocValue

Data Type

double

Mandatory

No


Description of Attribute Allocation Value of the Entity CostRecord

Shows the allocated value of the cost.


Entity Attribute Cost Credit Bf Avg of the Entity CostRecord

Card of Attribute Cost Credit Bf Avg of the Entity CostRecord

Name

Cost Credit Bf Avg

Code

CostCreditBfAvg

Data Type

double

Mandatory

No


Description of Attribute Cost Credit Bf Avg of the Entity CostRecord

Shows the average of the credit brought forward for the cost.


Entity Attribute Cost Debit Bf Avg of the Entity CostRecord

Card of Attribute Cost Debit Bf Avg of the Entity CostRecord

Name

Cost Debit Bf Avg

Code

CostDebitBfAvg

Data Type

double

Mandatory

No


Description of Attribute Cost Debit Bf Avg of the Entity CostRecord

Shows the average of the debit brought forward for the cost.


Entity Attribute Cost Credit Foreign Bf Avg of the Entity CostRecord

Card of Attribute Cost Credit Foreign Bf Avg of the Entity CostRecord

Name

Cost Credit Foreign Bf Avg

Code

CostCreditForeignBfAvg

Data Type

double

Mandatory

No


Description of Attribute Cost Credit Foreign Bf Avg of the Entity CostRecord

Shows the average of the foreign credit brought forward for the cost.


Entity Attribute Cost Debit Foreign Bf Avg of the Entity CostRecord

Card of Attribute Cost Debit Foreign Bf Avg of the Entity CostRecord

Name

Cost Debit Foreign Bf Avg

Code

CostDebitForeignBfAvg

Data Type

double

Mandatory

No


Description of Attribute Cost Debit Foreign Bf Avg of the Entity CostRecord

Shows the average of the foreign debit brought forward for the cost.


Entity Attribute Created By of the Entity CostRecord

Card of Attribute Created By of the Entity CostRecord

Name

Created By

Code

CreatedBy

Data Type

char(20)

Mandatory

No


Description of Attribute Created By of the Entity CostRecord

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