# DW_PROJECT_EVENT_CF

This table stores events assigned to a task that generate revenue and billing activities.

## Details

Module: Project Billing

## Key Columns

EVENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
EVENT_ID | NUMBER | 38 | 0 | True | Unique identifier for a Billing Event |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System Unique Identifier |  |
EVENT_NUM | NUMBER | 38 | 0 |  | The sequential number that identifies the event. |  |
CONTRACT_HEADER_ID | NUMBER | 38 | 0 |  | The identifier of the contract to which event is assigned. | DW_PROJECT_AWARD_D | AWARD_ID
CONTRACT_LINE_ID | NUMBER | 38 | 0 |  | The identifier of the contract line to which event is assigned. | DW_CONTRACT_LINE_TL | CONTRACT_LINE_ID
MAJOR_VERSION | NUMBER | 38 | 0 |  | Major Version denotes version number of Contract/ Contract Line of Event for audit purpose. |  |
PROJECT_ID | NUMBER | 38 | 0 |  | The identifier of the project to which event is assigned. | DW_PROJECT_D | PROJECT_ID
TASK_ID | NUMBER | 38 | 0 |  | The identifier of the top level task to which the event is assigned | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
LINKED_TASK_ID | NUMBER | 38 | 0 |  | The identifier of the linked task when task level linkage is present on the created event | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
EVENT_TYPE_ID | NUMBER | 38 | 0 |  | dentifier of the event type | DW_PROJECT_EVENT_TYPE_D | EVENT_TYPE_ID
ORGANIZATION_ID | NUMBER | 38 | 0 |  | The unique identifier of the organization for the event. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Identifier of the inventory item. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier of the inventory item organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID
BILL_PLAN_ID | NUMBER | 38 | 0 |  | Bill plan identifier. Refers to BILL_PLAN_ID in PJB_BILL_PLANS_B. | DW_CONTRACT_BILL_PLAN_D | BILL_PLAN_ID
REVENUE_PLAN_ID | NUMBER | 38 | 0 |  | Revenue plan identifier. Refers to PJB_BILL_PLANS_B. | DW_CONTRACT_BILL_PLAN_D | BILL_PLAN_ID
CONTRACT_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the business unit associated to the row. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
CONTRACT_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier for Contract. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
CONTRACT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier of Contract | DW_LEDGER_D | LEDGER_ID
CONTRACT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifies the Business Unit that will be responsible for developing this contract. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Project business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROJECT_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Project legal entity identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Project organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project Unit Identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_TYPE_ID | NUMBER | 38 | 0 |  | The project type that classifies the project and defaults project information upon project entry. | DW_PROJECT_TYPE_D_TL | PROJECT_TYPE_ID
PROJECT_LEDGER_ID | NUMBER | 38 | 0 |  | Project ledger identifier | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The GL period in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | GL Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
PROJECT_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The GL period type of Project in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PROJECT_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | GL Calendar set name of Project. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
RBS_ELEMENT_ID | NUMBER | 38 | 0 |  | The identifier of resource billing element. | DW_RBS_ELEMENT_D | RBS_ELEMENT_ID
ADJUSTED_EVENT_ID | NUMBER | 38 | 0 |  | The identifier of the event from which it is adjusted |  |
BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Party identifier. | DW_PARTY_D | PARTY_ID
BILL_TO_CUST_ACCT_ID | NUMBER | 38 | 0 |  | Customer site that the invoices should be sent to and is responsible for the payment. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
BILL_TO_SITE_USE_ID | NUMBER | 38 | 0 |  | Customer site that the invoices should be sent to and is responsible for the payment. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID
BILL_TO_LOCATION | VARCHAR2 | 256 |  |  | Site use identifier |  |
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
BILL_TO_CONTACT_ID | NUMBER | 38 | 0 |  | Contact person from the Bill-To Customer Site | DW_PARTY_D | PARTY_ID
CONTRACT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency of Contract entered on the event. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
CONTRACT_CURR_RATE_TYPE | VARCHAR2 | 32 |  |  | Rate Type of the Contract Currency. | DW_CONVERSION_RATE_TYPE_D | CONVERSION_TYPE
CONTRACT_CURR_EXCHG_RATE | NUMBER |  |  |  | Exchange Rate of the Contract Currency. |  |
CONTRACT_CURR_EXCHG_DATE | DATE |  |  |  | Exchange Date of the Contract Currency. |  |
CONTRACT_RATE_DATE_TYPE | VARCHAR2 | 32 |  |  | Rate Date Type of the Contract Currency. |  |
CONTRACT_CURRENCY_AMT | NUMBER |  |  |  | Event amount in Contract Currency. |  |
BILL_TRNX_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Transaction currency code of the event. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
BILL_TRNX_AMOUNT | NUMBER |  |  |  | Event amount in Bill transaction currency |  |
INVOICED_PERCENTAGE | NUMBER |  |  |  | Invoiced Percentage |  |
REVENUE_RECOGNZD_PERCENTAGE | NUMBER |  |  |  | Revenue accrued percenatge |  |
QUANTITY | NUMBER |  |  |  | Quantity of the inventory item on the event. |  |
QUANTITY_REV_RECOGNZD | NUMBER |  |  |  | Quantity that has been revenue recognized. |  |
QUANTITY_BILLED | NUMBER |  |  |  | Quantity that has been invoiced. |  |
UNIT_PRICE | NUMBER |  |  |  | Unit price of the inventory item on the event. |  |
UOM_CODE | VARCHAR2 | 16 |  |  | Unit of measure of the inventory item on the event. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
COMPLETION_DATE | DATE |  |  |  | The date on which the event is complete and on or after which the event is processed for revenue accrual and/or invoicing |  |
SOURCE_NAME | VARCHAR2 | 128 |  |  | SOURCENAME represents the external source from where the event is created |  |
SOURCE_REF | VARCHAR2 | 128 |  |  | SOURCEREF is the event reference id in the external source. |  |
EVENT_DESCIPTION | VARCHAR2 | 256 |  |  | The free text description of the event. For billing events, the description is displayed as the invoice line description |  |
EVENT_NUM_REVERSED | NUMBER | 38 | 0 |  | The event_num of the event that this automatic event is reversing when the invoice that the original event was on gets cancelled. |  |
CALC_ELEMENT_CODE | VARCHAR2 | 32 |  |  | Indicates the code of Calculation Element whether event is created from Percent Spent ('PS') or Percent Complete ('PC'). |  |
BILL_CURR_OPT_CODE | VARCHAR2 | 32 |  |  | Indicates the code of Billing currency used for invoicing whether it should be Contract currency or transaction currency | DW_BILLING_CURRENCY_TYPE_LKP_TL | CODE
BILLING_TYPE_CODE | VARCHAR2 | 32 |  |  | Indicates the code of Billing Type of the event whether created for External, InterCompany or InterProject Contracts. | DW_PJB_BILLING_TYPE_LKP_TL | BILLING_TYPE_CODE
EVENT_TYPE_CODE | VARCHAR2 | 16 |  |  | The event type that classifies the event whether applicable for Revenue/ Invoice or both | DW_EVENT_TYPE_CODE_LKP_TL | CODE
REVENUE_CATEGORY_CODE | VARCHAR2 | 32 |  |  | The revenue category to which event type belongs. | DW_REVENUE_CATEGORY_LKP_TL | REVENUE_CATEGORY_CODE
AUTOMATIC_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates that the event created is automatic event | DW_Y_N_D_TL | CODE
ITEM_EVENT_FLAG | VARCHAR2 | 16 |  |  | Indicates if the event is item based or non-item based. | DW_Y_N_D_TL | CODE
BILL_HOLD_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates that the event is held from invoicing | DW_PROJ_BILL_HOLD_LKP_TL | CODE
REVENUE_HOLD_FLAG | VARCHAR2 | 16 |  |  | This column indicates whether this event is on hold for revenue processing or not.Valid values Y or N. | DW_PROJ_REVENUE_HOLD_LKP_TL | CODE
REVERSE_ACCRUAL_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates whether or not the event should automatically reverse in the next period | DW_Y_N_D_TL | CODE
INVOICED_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates revenue is generated on the event ('P'-Partial, 'U'-Uninvoiced, 'F'-Fully) | DW_EVT_INVOICED_FLAG_LKP_TL | CODE
REVENUE_RECOGNZD_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates revenue is generated on the event ('P'-Partial, 'U'-Unrecognized, 'F'-Fully) | DW_REVENUE_RECOGNIZED_LKP_TL | CODE
REVENUE_EXCEPTION_FLAG | VARCHAR2 | 16 |  |  | This column indicates whether exception occured on the event during revenue generation. | DW_PJB_EXCEPTION_LVL_LKP_TL | CODE
INVOICE_EXCEPTION_FLAG | VARCHAR2 | 16 |  |  | This column indicates whether exception occured on the event during invoice generation. | DW_PJB_EXCEPTION_LVL_LKP_TL | CODE
CREATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. | DW_USER_D | USERNAME
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.