ERP/2.50/Developers Guide/Database Model/org.openbravo.model.common.hcm/C Salary Category Cost

Contents 1 C_Salary_Category_Cost 1.1 Other Info 1.1.1 Indexes 1.1.1.1 Unique 1.2 Columns 1.2.1 Salary Category Cost 1.2.2 Creation Date 1.2.3 Created By 1.2.4 Updated 1.2.5 Updated By 1.2.6 Client 1.2.7 Organization 1.2.8 Salary Category 1.2.9 Starting Date 1.2.10 Cost 1.2.11 Cost UOM 1.2.11.1 List values: Cost Uom

C_Salary_Category_Cost

Costs of a salary categories.

• Name:SalaryCategoryCost
• Classname:SalaryCategoryCost

This table contains the following columns:

Name	Nullable	Data Type	Description
C_Salary_Category_Cost_ID	N	VARCHAR2(32)	null
Created	N	DATE	The date that this record is completed.
Createdby	N	VARCHAR2(32)	User who created this records
Updated	N	DATE	x not implemented
Updatedby	N	VARCHAR2(32)	User who updated this records
AD_Client_ID	N	VARCHAR2(32)	Client for this installation.
AD_Org_ID	N	VARCHAR2(32)	Organizational entity within client
C_Salary_Category_ID	N	VARCHAR2(32)	A classification of salaries based on similar characteristics or attributes.
DateFrom	N	DATE	A parameter stating the starting time range related to a specified request.
Cost	N	NUMBER	A charge related to conducting business.
Costuom	N	VARCHAR2(60)	The unit of measure associated with the cost located adjacent to this field.

Other Info

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

• C_SALARY_CATEGORY_COST_KEY
  • C_Salary_Category_Cost_ID

top

Columns

Salary Category Cost

Identifies a cost of a salary category during a time period.

• Physical column name: C_Salary_Category_Cost_ID
• Property Name: id
• Reference: ID

top

Creation Date

The Created field indicates the date that this record was created.

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime
• Default value: SYSDATE

top

Created By

• Physical column name: Createdby
• Property Name: createdBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime
• Default value: SYSDATE

top

Updated By

• Physical column name: Updatedby
• Property Name: updatedBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir
• Default value: @AD_CLIENT_ID@

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir
• Default value: @AD_ORG_ID@

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Salary Category

• Physical column name: C_Salary_Category_ID
• Property Name: salaryCategory
• Reference: TableDir
• This column is part of the table's identifier
• This column is a child for a buisiness object (is Parent)

Foreign key column to C_Salary_Category table, (column: C_Salary_Category_ID)

top

Starting Date

The Date From indicates the starting date of a range.

• Physical column name: DateFrom
• Property Name: startingDate
• Reference: Date
• This column is part of the table's identifier

top

Cost

Cost amount.

• Physical column name: Cost
• Property Name: cost
• Reference: Number
• This column is part of the table's identifier

top

Cost UOM

Unit of Measure for cost

• Physical column name: Costuom
• Property Name: costUOM
• Reference: List
• This column is part of the table's identifier

List values: Cost Uom

The allowed values for this list are:

• H (per Hour)
• K (per Kilogram)
• P (Percentage)
• U (per Produced Units)

top