[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:
|
|
|