[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_EVENTS_AR |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_EVENTS_AR
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_EVENTS_AR_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 PURGE_PROJECT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PURGE_BATCH_ID | NUMBER | (15) | Yes | Purge batch Id |
| PURGE_PROJECT_ID | NUMBER | (15) | Yes | Purge Project Id |
| PURGE_RELEASE | VARCHAR2 | (50) | Yes | Purge release version |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | 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 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context field | |
| AUDIT_AMOUNT1 | 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 | ||
| 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_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 | |
| BILL_AMOUNT | NUMBER | (22) | The amount to be billed for the event on an invoice upon the event's completion date | |
| BILL_HOLD_FLAG | VARCHAR2 | (1) | Flag that indicates that the event is held from invoicing | |
| BILLING_ASSIGNMENT_ID | NUMBER | (15) | The unique identifier of billing extention assignment that is basis for creating the automatic event. | |
| 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 | |
| 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 | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| DESCRIPTION | VARCHAR2 | (240) | The free text description of the event. For billing events, the description is displayed as the invoice line description. | |
| EVENT_ID | NUMBER | (15) | Primary key for table. | |
| EVENT_NUM | NUMBER | (15) | The sequential number that identifies the 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. | |
| EVENT_TYPE | VARCHAR2 | (30) | The event type that classifies the event | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| ORGANIZATION_ID | NUMBER | (15) | The unique identifier of the organization for the event. For example, this may be used to credit revenue to different organization. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent program Who column | |
| PROGRAM_ID | NUMBER | (15) | Concurrent program Who column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent program Who column | ||
| PROJECT_ID | NUMBER | (15) | The identifier of the project to which event is assigned. | |
| REQUEST_ID | NUMBER | (15) | Concurrent program Who column | |
| REV_DIST_REJECTION_CODE | VARCHAR2 | (30) | The reason why the event was rejected during revenue distribution | |
| REVENUE_AMOUNT | NUMBER | (22) | The amount of revenue to accrue for the event upon the event's completion date | |
| REVENUE_DISTRIBUTED_FLAG | VARCHAR2 | (1) | Flag that indicates whether the event's revenue has been distributed. (An event is either distributed or not. It cannot be partially accrued.) | |
| TASK_ID | NUMBER | (15) | The identifier of the top level task to which the event is assigned | |
| 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) | Bill Transaction currency code of the event | |
| BILL_TRANS_BILL_AMOUNT | NUMBER | Bill amount in bill transaction currency | ||
| BILL_TRANS_REV_AMOUNT | NUMBER | The amount of revenue to accrue for the event in bill transaction currency. | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Project Currency Code | |
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used for converting to project currency | |
| PROJECT_RATE_DATE | DATE | Exchange rate date used for converting to project currency | ||
| PROJECT_EXCHANGE_RATE | NUMBER | Exchange rate used for converting to project currency | ||
| PROJECT_REV_RATE_DATE | DATE | Exchange rate date to use for conversion between bill transaction currency to project currency if 'Fixed Date' rate date type used during revenue generation | ||
| PROJECT_REV_EXCHANGE_RATE | NUMBER | Exchange rate used for conversion between bill transaction currency to project currency during revenue generation | ||
| PROJECT_REVENUE_AMOUNT | NUMBER | Revenue Amount in Project Currency | ||
| PROJECT_INV_RATE_DATE | DATE | Exchange rate date to use for conversion between bill transaction currency to project currency if 'Fixed Date' rate date type used during invoice generation | ||
| PROJECT_INV_EXCHANGE_RATE | NUMBER | Exchange rate to be used for conversion between bill transaction currency to project currency during invoice generation | ||
| PROJECT_BILL_AMOUNT | NUMBER | Bill Amount in Project Currency. This will be calculated by applying the conversion rules setup for project currency during invoice generation | ||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency code | |
| PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used for converting to project functional currency | |
| PROJFUNC_RATE_DATE | DATE | Exchange rate date used for converting to project functional currency | ||
| PROJFUNC_EXCHANGE_RATE | NUMBER | Exchange rate used for converting to project functional currency | ||
| PROJFUNC_REV_RATE_DATE | DATE | Exchange rate date used for conversion between bill transaction currency to project functional currency during revenue generation | ||
| PROJFUNC_REV_EXCHANGE_RATE | NUMBER | Exchange rate used for conversion between bill transaction currency to project functional currency during revenue generation | ||
| PROJFUNC_REVENUE_AMOUNT | NUMBER | Revenue amount in project functional currency | ||
| PROJFUNC_INV_RATE_DATE | DATE | Exchange rate date to use for conversion between bill transaction currency to project functional currency if 'Fixed Date' rate date type used during invoice generation | ||
| PROJFUNC_INV_EXCHANGE_RATE | NUMBER | Exchange rate to be used for conversion between bill transaction currency to project functional currency during invoice generation | ||
| PROJFUNC_BILL_AMOUNT | NUMBER | Bill amount in project functional currency | ||
| FUNDING_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used for converting to funding currency | |
| FUNDING_RATE_DATE | DATE | Exchange rate date used for converting to funding currency | ||
| FUNDING_EXCHANGE_RATE | NUMBER | Exchange rate used for converting to funding currency | ||
| REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Revenue processing currency code | |
| REVPROC_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used for converting to revenue processing currency | |
| REVPROC_RATE_DATE | VARCHAR2 | (240) | Exchange rate date used for converting to revenue processing currency | |
| REVPROC_EXCHANGE_RATE | NUMBER | Exchange rate used for converting to revenue processing currency | ||
| INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Invoice processing currency code | |
| INVPROC_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used for converting to invoice currency | |
| INVPROC_RATE_DATE | VARCHAR2 | (240) | Exchange rate date used for converting to invoice currency | |
| INVPROC_EXCHANGE_RATE | NUMBER | Exchange rate used for converting to invoice 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) | The unique identifier for the element version | |
| ACTION_ID | NUMBER | (15) | The unique identifier for the element version | |
| RECORD_VERSION_NUMBER | NUMBER | (15) | Storing Locking sequence number. | |
| AGREEMENT_ID | VARCHAR2 | (15) | The identifier of the project customers agreement for which event has to be billed. |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_PROJECT_ID
, PURGE_RELEASE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, AUDIT_AMOUNT1
, AUDIT_AMOUNT10
, AUDIT_AMOUNT2
, AUDIT_AMOUNT3
, AUDIT_AMOUNT4
, AUDIT_AMOUNT5
, AUDIT_AMOUNT6
, AUDIT_AMOUNT7
, AUDIT_AMOUNT8
, AUDIT_AMOUNT9
, AUDIT_COST_BUDGET_TYPE_CODE
, AUDIT_REV_BUDGET_TYPE_CODE
, BILL_AMOUNT
, BILL_HOLD_FLAG
, BILLING_ASSIGNMENT_ID
, CALLING_PLACE
, CALLING_PROCESS
, COMPLETION_DATE
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, EVENT_ID
, EVENT_NUM
, EVENT_NUM_REVERSED
, EVENT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, ORGANIZATION_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, REQUEST_ID
, REV_DIST_REJECTION_CODE
, REVENUE_AMOUNT
, REVENUE_DISTRIBUTED_FLAG
, TASK_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_AR;
PA.PA_EVENTS_AR does not reference any database object
PA.PA_EVENTS_AR is referenced by following:
APPS
PA_EVENTS_AR
|
|
|
|