DW_EB_X_EBS_PROJECTS_W_PROJ_COST_A
No table description is available in the supplied metadata.
Details
Module: Projects (EBS_PROJECTS)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | |||
| ACCT_BURDENED_COST | NUMBER | 28,10 | ||||
| ACCT_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| ACCT_RAW_COST | NUMBER | 28,10 | ||||
| BILLABLE_FLG | VARCHAR2 | 1 CHAR | ||||
| CAPITALIZABLE_FLG | VARCHAR2 | 1 CHAR | ||||
| CONTRACT_HDR_WID | NUMBER | 38 | DW_EB_X_EBS_AR_W_CONTRACT_HDR_D | |||
| CONTRACT_LINE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CONTRACT_LINE_D | |||
| COST_GL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| CROSS_CHARGE_FLG | VARCHAR2 | 1 CHAR | ||||
| CROSS_CHARGE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| ENT_PERIOD_END_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| ENT_PERIOD_START_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| ETL_PROC_WID | NUMBER | 38 | ||||
| EXPENDITURE_CLASS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| EXPENDITURE_OPER_UNIT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| EXPENDITURE_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| FINANCIAL_RESOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | |||
| GLOBAL1_BURDENED_COST | NUMBER | 28,10 | ||||
| GLOBAL1_RAW_COST | NUMBER | 28,10 | ||||
| GLOBAL2_BURDENED_COST | NUMBER | 28,10 | ||||
| GLOBAL2_RAW_COST | NUMBER | 28,10 | ||||
| GLOBAL3_BURDENED_COST | NUMBER | 28,10 | ||||
| GLOBAL3_RAW_COST | NUMBER | 28,10 | ||||
| GL_ACCT_PERIOD_END_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| GL_ACCT_PERIOD_START_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| INCURRED_BY_EMP_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| INTERCOMPANY_NONREC_TAX_FLG | VARCHAR2 | 1 CHAR | INTERCOMPANY_NONREC_TAX_FL G | |||
| LOC_BURDENED_COST | NUMBER | 28,10 | ||||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| LOC_RAW_COST | NUMBER | 28,10 | ||||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJECT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROJECT_D | |||
| PROJ_ACCT_PERIOD_END_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PROJ_ACCT_PERIOD_START_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PROJ_BILLABLE_FLG | VARCHAR2 | 1 CHAR | ||||
| PROJ_BURDENED_COST | NUMBER | 28,10 | ||||
| PROJ_CAPITALIZABLE_FLG | VARCHAR2 | 1 CHAR | ||||
| PROJ_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| PROJ_MANAGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| PROJ_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| PROJ_OPER_UNIT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJ_PR_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | |||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| PROJ_RAW_COST | NUMBER | 28,10 | ||||
| PRVDR_GL_ACCT_PRD_END_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PRVDR_GL_ACCT_PRD_STRT_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PRVDR_GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| PRVDR_PRJ_ACCT_PRD_END_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PRVDR_PRJ_ACCT_PRD_ST_DAY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PRVDR_PROJ_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| QUANTITY | NUMBER | 28,10 | ||||
| RESOURCE_CLASS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| UOM | VARCHAR2 | 200 CHAR | DW_EB_X_EBS_DOMAINS_W_DOMAIN_MEMBER_LKP_TL | |||
| VENDOR_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_VENDOR_D | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |