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
| 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. |