CST_PROJECT_COSTS - Projects database

Projects database documentation

- Projects database

Documentation	Projects database
Name	CST_PROJECT_COSTS
Module	Costs

Table holds project costs, excluding work of company employees. Costs include: purchases of materials, third party services and all other expenses.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		COST_ENTRY_ID	NUMBER
	2		COST_DATE	DATE
	3		PROJECT_ID	NUMBER
	4		DEPARTMENT_ID	NUMBER			DEPARTMENTS
References: DEPARTMENTS
	5		ACTIVITY_ID	NUMBER			ACTIVITIES
References: ACTIVITIES
	6		WBS_ID	NUMBER			WBS
References: WBS
	7		COST	NUMBER
	8		CURRENCY	NUMBER
	9		COST_USD	NUMBER
	10		STATUS	VARCHAR2(5 CHAR)
	11		SUPPLIER_ID	NUMBER			COMPANIES
References: COMPANIES
	12		DOCUMENT_NO	VARCHAR2(25 CHAR)
	13		DOCUMENT_DATE	DATE
	14		CREATED_DATE	DATE		Default: SYSDATE
Default: SYSDATE
	15		CREATED_BY	NUMBER
	16		MODIFIED_DATE	DATE		Default: SYSDATE
Default: SYSDATE
	17		MODIFIED_BY	NUMBER

Relations

Foreign table		Primary table	Join	Title / Name / Description
CST_PROJECT_COSTS		ACTIVITIES	CST_PROJECT_COSTS.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID	FK_CST_PROJECT_COSTS_ACT
CST_PROJECT_COSTS.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID Name: FK_CST_PROJECT_COSTS_ACT
CST_PROJECT_COSTS		COMPANIES	CST_PROJECT_COSTS.SUPPLIER_ID = COMPANIES.COMPANY_ID	FK_CST_PROJECT_COSTS_SUPPLIER
CST_PROJECT_COSTS.SUPPLIER_ID = COMPANIES.COMPANY_ID Name: FK_CST_PROJECT_COSTS_SUPPLIER
CST_PROJECT_COSTS		DEPARTMENTS	CST_PROJECT_COSTS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_CST_PROJECT_COSTS_DEPT
CST_PROJECT_COSTS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_CST_PROJECT_COSTS_DEPT
CST_PROJECT_COSTS		WBS	CST_PROJECT_COSTS.WBS_ID = WBS.WBS_ID	FK_CST_PROJECT_COSTS_WBS
CST_PROJECT_COSTS.WBS_ID = WBS.WBS_ID Name: FK_CST_PROJECT_COSTS_WBS

Unique keys

	Key name	Columns	Description
	PK_CST_PROJECT_COSTS	COST_ENTRY_ID

Uses

Name
CST_PROJECT_COSTS
ACTIVITIES
COMPANIES
DEPARTMENTS
WBS

Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50