DW_EB_X_EBS_PROJECTS_W_PROJ_GL_RECNCLIATION_F
Project GL reconciliation Fact table stores details of all projects to gl journals unreconciled rows.
Details
Module: Projects (EBS_PROJECTS)
Business Name: Project Reconciliation Fact
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 | System generated row id | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 1 Changed on Date | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 2 Changed on Date | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 3 Changed on Date | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 4 Changed on Date | |||
| CHANGED_BY_WID | NUMBER | 38 | OLTP user who last updated the transaction | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | OLTP last update date of the transaction | |||
| CONTRACT_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| CONTRACT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| COST_CENTER_WID | NUMBER | 38 | Cost center wid | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| CREATED_BY_WID | NUMBER | 38 | OLTP user who created the transaction | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | OLTP creation date of the transaction | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | Datasource Num Id | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | Delete Flag | |||
| DISTRIBUTION_CATEGORY | VARCHAR2 | 80 CHAR | Distribution category | |||
| DISTRIBUTION_LINE_STATUS_WID | NUMBER | 38 | Distribution line status wid | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| DISTRIBUTION_SOURCE | VARCHAR2 | 30 CHAR | Distribution source | |||
| DOC_AMT | NUMBER | 38,10 | Amount in doc currency | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | Doc currency code | |||
| DR_CR_IND | VARCHAR2 | 10 CHAR | Dr/Cr flag | |||
| ETL_PROC_WID | NUMBER | 38 | ETL Proc Wid | |||
| EXPENDITURE_BU_WID | NUMBER | 38 | Exp bu wid | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| EXPENDITURE_ORG_WID | NUMBER | 38 | Business unit wid | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| GLOBAL1_EXCHANGE_RATE | NUMBER | Document to Global1 (for Global Reporting) Currency Exchange Rate | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | Document to Global2 (for Global Reporting) Currency Exchange Rate | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | Document to Global3 (for Global Reporting) Currency Exchange Rate | ||||
| GL_ACCOUNTING_DT_WID | NUMBER | 38 | GL date wid | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| GL_ACCOUNT_WID | NUMBER | 38 | GL acocunt wid | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| JE_BATCH_NAME | VARCHAR2 | 100 CHAR | Journal batch name | |||
| JE_HEADER_NAME | VARCHAR2 | 100 CHAR | Journal header name | |||
| JE_LINE_NUM | NUMBER | 15 | Journal line number | |||
| JE_STATUS | VARCHAR2 | 80 CHAR | Journal status | |||
| JOURNAL_LINE_INTEGRATION_ID | VARCHAR2 | 80 CHAR | Journal integration id | |||
| LEDGER_WID | NUMBER | 38 | Ledger wid | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_AMT | NUMBER | 38,10 | Amount in loc currency | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | loc currency code | |||
| PROJECT_WID | NUMBER | 38 | Project wid | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROJ_ACCOUNTING_DT_WID | NUMBER | 38 | Accountring date wid | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| PROJ_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJ_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| ROW_TYPE | VARCHAR2 | 80 CHAR | Denotes the reconcill use case | |||
| SOURCE_DISTRIBUTION_ID | VARCHAR2 | 80 CHAR | Source Distribution id | |||
| SOURCE_DISTRIBUTION_LINE_NUM | VARCHAR2 | 80 CHAR | Source Distribution number | |||
| SOURCE_INTEGRATION_ID | VARCHAR2 | 80 CHAR | Source integration id | |||
| TASK_WID | NUMBER | 38 | Task wid | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| TENANT_ID | VARCHAR2 | 80 CHAR | Tenant Id | |||
| WAREHOUSE_FACT_SOURCE | VARCHAR2 | 30 CHAR | project fact source | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Generic Extension Column | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |