Entity CostCreditDebit

Description of Entity CostCreditDebit

Whether this is a debit / credit action, it is advisable to match this with your GL code.


List of all Dependencies of the Entity CostCreditDebit

Name

Code

Class Name

Relation_512732

Relation_512732

Reference

Relation_512761

Relation_512761

Reference

Relation_512714

Relation_512714

Reference

Relation_512748

Relation_512748

Reference

Relation_1658750

Relation_1658750

Reference


List of Attributes of the Entity CostCreditDebit

Name

Code

CostCrDrSysId

CostCrDrSysId

Cost Centre ID

CostCentreId

GL Code

GLCode

Costing Rule

CostPostingOption

Cost Centre

CostCentreOption

Pay Record Type

CostPayRecType

Pay Record ID

CostPayRecId


Entity Attribute CostCrDrSysId of the Entity CostCreditDebit

Card of Attribute CostCrDrSysId of the Entity CostCreditDebit

Name

CostCrDrSysId

Code

CostCrDrSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CostCrDrSysId of the Entity CostCreditDebit

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


Entity Attribute Cost Centre ID of the Entity CostCreditDebit

Card of Attribute Cost Centre ID of the Entity CostCreditDebit

Name

Cost Centre ID

Code

CostCentreId

Data Type

char(20)

Mandatory

No


Description of Attribute Cost Centre ID of the Entity CostCreditDebit

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


Entity Attribute GL Code of the Entity CostCreditDebit

Card of Attribute GL Code of the Entity CostCreditDebit

Name

GL Code

Code

GLCode

Data Type

char(20)

Mandatory

No


Description of Attribute GL Code of the Entity CostCreditDebit

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


Entity Attribute Costing Rule of the Entity CostCreditDebit

Card of Attribute Costing Rule of the Entity CostCreditDebit

Name

Costing Rule

Code

CostPostingOption

Data Type

smallint

Mandatory

No


Description of Attribute Costing Rule of the Entity CostCreditDebit

Shows the costing rule for the cost in a form of radio buttons. Users either choose Debit or Credit. Debit will show "0" while Credit will show "1" in the database.


Entity Attribute Cost Centre of the Entity CostCreditDebit

Card of Attribute Cost Centre of the Entity CostCreditDebit

Name

Cost Centre

Code

CostCentreOption

Data Type

smallint

Mandatory

No


Description of Attribute Cost Centre of the Entity CostCreditDebit

Shows the cost centre in a form of radio buttons. Users either choose 'Employee's Cost Centres' or 'User Defined Cost Centres'. Employee's Cost Centres will show "0" while User Defined Cost Centres will show "1" in the database.


Entity Attribute Pay Record Type of the Entity CostCreditDebit

Card of Attribute Pay Record Type of the Entity CostCreditDebit

Name

Pay Record Type

Code

CostPayRecType

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Record Type of the Entity CostCreditDebit

Stores the pay record type.
Example: Advance Pay / Normal Pay / Bonus Pay / Other Pay


Entity Attribute Pay Record ID of the Entity CostCreditDebit

Card of Attribute Pay Record ID of the Entity CostCreditDebit

Name

Pay Record ID

Code

CostPayRecId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Record ID of the Entity CostCreditDebit

Stores the identity for the pay record