DBA Data[Home] [Help] [Dependency Information]


TABLE: PA.PA_EVENTS

Object Details
Object Name: PA_EVENTS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_EVENTS
Subobject Name:
Status: VALID


PA_EVENTS stores events assigned to a task that
generate revenue and/or billing activities that are
not directly associated to the cost and revenue
generated by expenditure items.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_EVENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnEVENT_NUM
ColumnTASK_ID
PA_EVENTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
PA_EVENTS_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPM_PRODUCT_CODE
ColumnPM_EVENT_REFERENCE
PA_EVENTS_U4 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERABLE_ID
ColumnACTION_ID
PA_EVENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREVENUE_DISTRIBUTED_FLAG
ColumnPROJECT_ID
ColumnCOMPLETION_DATE
ColumnTASK_ID
PA_EVENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_TYPE
PA_EVENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnREVENUE_DISTRIBUTED_FLAG
PA_EVENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILLING_ASSIGNMENT_ID
Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER (15)
The identifier of the top level task to which the event is assigned
EVENT_NUM NUMBER (15) Yes The sequential number that identifies the event.
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
EVENT_TYPE VARCHAR2 (30) Yes The event type that classifies the event
DESCRIPTION VARCHAR2 (240) Yes The free text description of the event. For billing events, the description is displayed as the invoice line description.
BILL_AMOUNT NUMBER (22) Yes The amount to be billed for the event on an invoice upon the event's completion date
REVENUE_AMOUNT NUMBER (22) Yes The amount of revenue to accrue for the event upon the event's completion date
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1) Yes Flag that indicates whether the event's revenue has been distributed. (An event is either distributed or not. It cannot be partially accrued.)
BILL_HOLD_FLAG VARCHAR2 (1)
Flag that indicates that the event is held from invoicing
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
REV_DIST_REJECTION_CODE VARCHAR2 (30)
The reason why the event was rejected during revenue distribution
REQUEST_ID NUMBER (15)
Standard Who Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who Column
PROGRAM_ID NUMBER (15)
Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
PROJECT_ID NUMBER (15) Yes The identifier of the project to which event is assigned.
ORGANIZATION_ID NUMBER (15) Yes The unique identifier of the organization for the event. For example, this may be used to credit revenue to different organization.
BILLING_ASSIGNMENT_ID NUMBER (15)
The unique identifier of billing extention assignment that is basis for creating the automatic event.
EVENT_NUM_REVERSED NUMBER (15)
The event_num of the event that this automatic event is reversing when the invoice that the original event was on gets cancelled.
CALLING_PLACE VARCHAR2 (30)
The place in the program that called the Billing Extension which created this event
CALLING_PROCESS VARCHAR2 (30)
The process that called the Billing Extension that created this event
AUDIT_COST_BUDGET_TYPE_CODE VARCHAR2 (30)
Audit Cost budget type used for calculation of cost budget amounts
AUDIT_REV_BUDGET_TYPE_CODE VARCHAR2 (30)
Audit revenue budget type used for calculation of revenue budget amounts
AUDIT_AMOUNT1 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT2 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT3 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT4 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT5 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT6 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT7 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT8 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT9 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT10 NUMBER

Audit amount column to know the audit amounts for events with automatic event type classification
EVENT_ID NUMBER
Yes Primary key for table.
INVENTORY_ORG_ID NUMBER (15)
inventory orgnization ID
INVENTORY_ITEM_ID NUMBER (15)
inventory item ID
QUANTITY_BILLED NUMBER

Bill Quantity
UOM_CODE VARCHAR2 (3)
Unit of Measure
UNIT_PRICE NUMBER

Contract price
REFERENCE1 VARCHAR2 (240)
Generic Reference Column
REFERENCE2 VARCHAR2 (240)
Generic Reference Column
REFERENCE3 VARCHAR2 (240)
Generic Reference Column
REFERENCE4 VARCHAR2 (240)
Generic Reference Column
REFERENCE5 VARCHAR2 (240)
Generic Reference Column
REFERENCE6 VARCHAR2 (240)
Generic Reference Column
REFERENCE7 VARCHAR2 (240)
Generic Reference Column
REFERENCE8 VARCHAR2 (240)
Generic Reference Column
REFERENCE9 VARCHAR2 (240)
Generic Reference Column
REFERENCE10 VARCHAR2 (240)
Generic Reference Column
BILLED_FLAG VARCHAR2 (1)
Indicates if a particular event has been billed completely (Y) or not (N).
BILL_TRANS_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code of the event.
BILL_TRANS_BILL_AMOUNT NUMBER

Bill amount in the event transaction.
BILL_TRANS_REV_AMOUNT NUMBER

Revenue Amount in the Event Transaction.
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project currency code.
PROJECT_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency to project currency
PROJECT_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used for customer billing.
PROJECT_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency to project currency if User exchange rate type is used.
PROJECT_REV_RATE_DATE DATE

Rate date used during revenue generation
PROJECT_REV_EXCHANGE_RATE NUMBER

Exchange rate used during revenue generation.
PROJECT_REVENUE_AMOUNT NUMBER

Revenue Amount in Project Currency. This is calculated by applying the Project Currency setup conversion rules to the bill transaction base revenue amount during revenue generation.
PROJECT_INV_RATE_DATE DATE

Rate date used during invoice generation.
PROJECT_INV_EXCHANGE_RATE NUMBER

Exchange rate used during invoice generation.
PROJECT_BILL_AMOUNT NUMBER

Bill amount in Project Currency. This is calculated by applying the Project Currency setup conversion rules to the bill transaction base bill amount during invoice generation.
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project functional currency.
PROJFUNC_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency to project functional currency for customer billing.
PROJFUNC_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used for customer billing.
PROJFUNC_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency to project functional if User exchange rate type is used.
PROJFUNC_REV_RATE_DATE DATE

Rate date used during revenue generation.
PROJFUNC_REV_EXCHANGE_RATE NUMBER

Exchange rate used during revenue generation.
PROJFUNC_REVENUE_AMOUNT NUMBER

Revenue amount in the project functional currency. This is calculated by applying the project functional currency setup conversion rules to the bill ransaction base revenue amount during revenue generation.
PROJFUNC_INV_RATE_DATE DATE

Rate date used during invoice generation.
PROJFUNC_INV_EXCHANGE_RATE NUMBER

Exchange rate used during invoice generation.
PROJFUNC_BILL_AMOUNT NUMBER

Bill amount in the project functional currency. This is calculated by applying the Project functional currency setup conversion rules to the bill transaction base bill amount during invoice generation.
FUNDING_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency to funding currency for customer billing.
FUNDING_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used for customer billing.
FUNDING_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency to project or functional currency
REVPROC_CURRENCY_CODE VARCHAR2 (15)
Revenue Processing Currency.
REVPROC_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency to revenue processing currency for customer billing.Currently, the revenue processing currency is the project functional currency.
REVPROC_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency to revenue processing currency if Fixed Date rate date type is used for customer billing.
REVPROC_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency to the revenue processing currency .
INVPROC_CURRENCY_CODE VARCHAR2 (15)
Invoice Processing Currency.
INVPROC_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency to the invoice processing currency for customer billing.
INVPROC_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency to invoice processing currency if Fixed Date rate date type is used for customer billing.
INVPROC_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency to the invoice processing currency.
INV_GEN_REJECTION_CODE VARCHAR2 (30)
Invoice generation rejection code.
ADJUSTING_REVENUE_FLAG VARCHAR2 (1)
Indicate that the event is an adjusting revenue event
ZERO_REVENUE_AMOUNT_FLAG VARCHAR2 (1)
The identifier of the zero revenue amount.
NON_UPDATEABLE_FLAG VARCHAR2 (1)
This column indicates whether event is updateable or not.Valid values Y or N.
PROJECT_FUNDING_ID NUMBER (15)
The identifier of the project funding
REVENUE_HOLD_FLAG VARCHAR2 (1)
This column indicates whether this event is on hold for revenue processing or not.Valid values Y or N.
AUDIT_COST_PLAN_TYPE_ID NUMBER (15)
Audit cost Fin Plan id used for calculation of cost Fin plan amounts
AUDIT_REV_PLAN_TYPE_ID NUMBER (15)
Audit revenue fin plan id used for calculation of revenue Fin Plan amounts
PM_PRODUCT_CODE VARCHAR2 (30)
Unique identifier of the external system
PM_EVENT_REFERENCE VARCHAR2 (25)
Unique identifier of an event in external system
DELIVERABLE_ID NUMBER (15)
Unique identifier of deliverable
ACTION_ID NUMBER (15)
Unique Identifier of the the action
RECORD_VERSION_NUMBER NUMBER (15)
Record version number of the deliverable
AGREEMENT_ID VARCHAR2 (15)
The identifier of the project customers agreement for which event has to be billed.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TASK_ID
,      EVENT_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EVENT_TYPE
,      DESCRIPTION
,      BILL_AMOUNT
,      REVENUE_AMOUNT
,      REVENUE_DISTRIBUTED_FLAG
,      BILL_HOLD_FLAG
,      COMPLETION_DATE
,      REV_DIST_REJECTION_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PROJECT_ID
,      ORGANIZATION_ID
,      BILLING_ASSIGNMENT_ID
,      EVENT_NUM_REVERSED
,      CALLING_PLACE
,      CALLING_PROCESS
,      AUDIT_COST_BUDGET_TYPE_CODE
,      AUDIT_REV_BUDGET_TYPE_CODE
,      AUDIT_AMOUNT1
,      AUDIT_AMOUNT2
,      AUDIT_AMOUNT3
,      AUDIT_AMOUNT4
,      AUDIT_AMOUNT5
,      AUDIT_AMOUNT6
,      AUDIT_AMOUNT7
,      AUDIT_AMOUNT8
,      AUDIT_AMOUNT9
,      AUDIT_AMOUNT10
,      EVENT_ID
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      QUANTITY_BILLED
,      UOM_CODE
,      UNIT_PRICE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      BILLED_FLAG
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_BILL_AMOUNT
,      BILL_TRANS_REV_AMOUNT
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_REVENUE_AMOUNT
,      PROJECT_INV_RATE_DATE
,      PROJECT_INV_EXCHANGE_RATE
,      PROJECT_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_REVENUE_AMOUNT
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      PROJFUNC_BILL_AMOUNT
,      FUNDING_RATE_TYPE
,      FUNDING_RATE_DATE
,      FUNDING_EXCHANGE_RATE
,      REVPROC_CURRENCY_CODE
,      REVPROC_RATE_TYPE
,      REVPROC_RATE_DATE
,      REVPROC_EXCHANGE_RATE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      INV_GEN_REJECTION_CODE
,      ADJUSTING_REVENUE_FLAG
,      ZERO_REVENUE_AMOUNT_FLAG
,      NON_UPDATEABLE_FLAG
,      PROJECT_FUNDING_ID
,      REVENUE_HOLD_FLAG
,      AUDIT_COST_PLAN_TYPE_ID
,      AUDIT_REV_PLAN_TYPE_ID
,      PM_PRODUCT_CODE
,      PM_EVENT_REFERENCE
,      DELIVERABLE_ID
,      ACTION_ID
,      RECORD_VERSION_NUMBER
,      AGREEMENT_ID
FROM PA.PA_EVENTS;

Dependencies

[top of page]

PA.PA_EVENTS does not reference any database object

PA.PA_EVENTS is referenced by following:

SchemaAPPS
SynonymPA_EVENTS