DW_EB_X_EBS_PROJECTS_W_PROJ_INVOICE_LINE_F
This fact table scores data at invoice line level from the OLTP. It is used to provide metrics like invoice amount, invoice write-off amount, approved invoice amount as well as retention metrics like current withheld amount, total retained amount, retention billed amount etc. Invoice Metrics can be analyzed by Project, Task, Agreement, Organization, Date, Customer etc. It contains both expenditure and event billing records.
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 |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| AGREEMENT_AMT | NUMBER | 38,10 | The amount of revenue authorized for the agreement in agreement currency | |||
| AGREEMENT_CURR_CODE | VARCHAR2 | 30 CHAR | Agreement Currency Code. | |||
| AGREEMENT_OPER_UNIT_WID | NUMBER | 38 | Key to Contract BU Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| AGREEMENT_ORGANIZATION_WID | NUMBER | 38 | Key to Agreement Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| AGREEMENT_WID | NUMBER | 38 | Key to Project Contract Dimension | DW_EB_X_EBS_AR_W_CONTRACT_HDR_D | ||
| ANALYSIS_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| APPROVED_BY_EMP_WID | NUMBER | 38 | Key to Approved by Employee Dimension | |||
| APPROVED_DT_WID | NUMBER | 38 | Approved Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| AR_INVOICE_NUMBER | VARCHAR2 | 30 CHAR | The Account Receivables invoice number that is determined upon release of the draft invoice and passed to Account Receivables upon transfer. This number can be user-entered or system-generated as defined in the implementation options. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AWARD_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_AWARD_D | |||
| BILL_THROUGH_DT_WID | NUMBER | 38 | Bill Through Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| BILL_TO_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | Key to Bill To Customer Account Dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| BILL_TO_CUSTOMER_WID | NUMBER | 38 | Key to Bill To Customer Dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| CANCELED_FLG | VARCHAR2 | 1 CHAR | Flag that indicates that the draft invoice was credited by another draft invoice, a credit memo | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CONCESSION_FLG | VARCHAR2 | 1 CHAR | Flag that indicates that the draft invoice gives a concession on another invoice | |||
| CONTRACT_LINE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CONTRACT_LINE_D | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CREDIT_INVOICE_NUM | VARCHAR2 | 30 CHAR | The draft invoice number that is credited by this draft invoice. The crediting invoice may be a credit memo or a write-off | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DOC_BILL_AMT | NUMBER | 38,10 | The amount to be billed in the invoicing currency code for the draft invoice item. | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | Transaction Currency Code | |||
| DRAFT_INVOICE_NUM | VARCHAR2 | 30 CHAR | The draft invoice number to which the invoice line belongs | |||
| ENTERPRISE_GL_DT_WID | NUMBER | 38 | Enterprise GL Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| EVENT_TASK_WID | NUMBER | 38 | Key to Event Task Dimension. Only populated for invoices based on events. | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| EVENT_WID | NUMBER | 38 | Key to Event Dimension | DW_EB_X_EBS_PROJECTS_W_EVENT_D | ||
| GLOBAL1_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction Currency to Global1 Currency | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction Currency to Global2 Currency | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction Currency to Global3 Currency | ||||
| GL_ACCOUNTING_DT_WID | NUMBER | 38 | GL Accounting Date Key | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| GL_ACCOUNT_WID | NUMBER | 38 | Key to GL Account Dimension | |||
| GL_MCAL_CAL_WID | NUMBER | 38 | GL Calendar Key | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| INVOICE_CLASS_WID | NUMBER | 38 | Key to Invoice Class Dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| INVOICE_DT_WID | NUMBER | 38 | Invoice Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| INVOICE_LINE_TYPE_WID | NUMBER | 38 | Key to Invoice Line Type Dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| INVOICE_TRANSFER_STATUS_WID | NUMBER | 38 | Key to Invoice Transfer Status Dimension | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| LINE_NUM | NUMBER | 15 | The sequential number that identifies and orders the draft invoice item for a draft invoice | |||
| LOC_BILL_AMT | NUMBER | 38,10 | Bill Amount in the local currency. This is calculated by applying the conversion rules set up for project functional currency during invoice generation. | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency Code | |||
| LOC_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction currency to local Currency | ||||
| LOC_TO_GLOBAL1_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from Local Currency to Global1 Currency | ||||
| LOC_TO_GLOBAL2_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from Local Currency to Global2 Currency | ||||
| LOC_TO_GLOBAL3_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from Local Currency to Global3 Currency | ||||
| LOC_UNBILLED_RECEIVABLE | NUMBER | 28,10 | Value of work done, which has not been billed yet, in local currency. | |||
| LOC_UNEARNED_REVENUE | NUMBER | 28,10 | Value of revenue recognized, for which the work has not been performed yet, in local currency. | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Key to Operating Unit Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PA_MCAL_CAL_WID | NUMBER | 38 | Project Calendar Key | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| PROJECT_BILLING_TYPE_CODE | VARCHAR2 | 50 CHAR | ||||
| PROJECT_WID | NUMBER | 38 | Key to Project Dimension | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROJ_ACCOUNTING_DT_WID | NUMBER | 38 | Project Accounting Date Key | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| PROJ_BILL_AMT | NUMBER | 38,10 | Bill Amount in the project currency. This is calculated by applying the conversion rules set up for project currency during invoice generation. | |||
| PROJ_CURR_CODE | VARCHAR2 | 30 CHAR | Project Currency Code | |||
| PROJ_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction currency to Project Currency | ||||
| PROJ_LOCATION_WID | NUMBER | 38 | Key to Project Location Dimension | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| PROJ_MANAGER_WID | NUMBER | 38 | Key to Project Manager Dimension | |||
| PROJ_OPERATING_UNIT_WID | NUMBER | 38 | Key to Project BU Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | Key to Project Organization Dimension. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_PR_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | Key to Project Primary Customer Account Dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | Key to Project Primary Customer Dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| RCVR_GL_ACCOUNTING_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| RCVR_GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| RCVR_LOC_BILL_AMT | NUMBER | 38,10 | ||||
| RCVR_LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| RCVR_PA_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| RCVR_PROJ_ACCOUNTING_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| RELEASED_BY_EMP_WID | NUMBER | 38 | Key to Released by Employee Dimension | |||
| RELEASED_DT_WID | NUMBER | 38 | Released Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| RETENTION_INVOICE_FLG | VARCHAR2 | 1 CHAR | This indicates whether the invoice is retention invoice or not. Valid values are Y or N | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record. | |||
| SERVICE_TYPE_WID | NUMBER | 38 | Key to Service Type Dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| TASK_ORGANIZATION_WID | NUMBER | 38 | Key to Task Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| TOP_TASK_WID | NUMBER | 38 | Key to Task Dimension. This foreign key points to the top task and is only populated for expenditure invoices. | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| WRITE_OFF_FLG | VARCHAR2 | 1 CHAR | Flag that indicates that a draft invoice writes off another draft invoice | |||
| W_PROJECT_BILLING_TYPE_CODE | VARCHAR2 | 50 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |