CST_PROJECT_COSTS
Documentation | Projects database |
Name | CST_PROJECT_COSTS |
Module | Costs |
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
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50