[Home] [Help] [Dependency Information]
Object Name: | OKE_K_BILLING_EVENTS |
---|---|
Object Type: | TABLE |
Owner: | OKE |
FND Design Data: | OKE.OKE_K_BILLING_EVENTS |
Subobject Name: | |
Status: | VALID |
Billing Events table stores the common information about the OKE billing events. It may also provide the reference information about the events in Oracle Projects if the billing event has been initiated from Oracle Projects.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKE_K_BILLING_EVENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BILLING_EVENT_ID |
OKE_K_BILLING_EVENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DELIVERABLE_ID |
OKE_K_BILLING_EVENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PA_EVENT_ID |
OKE_K_BILLING_EVENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | K_HEADER_ID |
OKE_K_BILLING_EVENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BILL_PROJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BILLING_EVENT_ID | NUMBER | Yes | Contract billing event unique identifier | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
K_HEADER_ID | NUMBER | Yes | Contract document unique identifier | |
K_LINE_ID | NUMBER | Yes | Contract document line item unique identifier | |
DELIVERABLE_ID | NUMBER | Yes | Contract deliverable unique identifier | |
BILL_EVENT_DATE | DATE | Billing event date | ||
BILL_EVENT_TYPE | VARCHAR2 | (30) | Billing event type | |
PA_EVENT_ID | NUMBER | Unique identifier of project billing event that corresponds to this contract billing event | ||
BILL_ITEM_ID | NUMBER | Item unique identifier related to this billing event | ||
BILL_LINE_ID | NUMBER | Contract line unique identifier related to billing event | ||
BILL_CHG_REQ_ID | NUMBER | Change request unique identifier related to billing event | ||
BILL_PROJECT_ID | NUMBER | Bill against project | ||
BILL_TASK_ID | NUMBER | Bill against task | ||
BILL_ORGANIZATION_ID | NUMBER | Billing organization unique identifier | ||
BILL_FUND_REF1 | VARCHAR2 | (80) | Funding reference related to billing event | |
BILL_FUND_REF2 | VARCHAR2 | (80) | Funding reference related to billing event | |
BILL_FUND_REF3 | VARCHAR2 | (80) | Funding reference related to billing event | |
BILL_BILL_OF_LADING | VARCHAR2 | (240) | Bill of lading number related to billing event | |
BILL_SERIAL_NUM | VARCHAR2 | (240) | Serial numbers related to billing event | |
BILL_CURRENCY_CODE | VARCHAR2 | (30) | Billing currency | |
BILL_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for conversion to functional currency | |
BILL_RATE_DATE | DATE | Date of Exchange rate date to functional currency | ||
BILL_EXCHANGE_RATE | NUMBER | Currency exchange rate to functional currency | ||
BILL_DESCRIPTION | VARCHAR2 | (240) | Billing description | |
BILL_QUANTITY | NUMBER | Billing quantity | ||
BILL_UNIT_PRICE | NUMBER | Billing unit price | ||
REVENUE_AMOUNT | NUMBER | Amount of revenue to accrue for the billing event upon event completion | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield attribute context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
INITIATED_FLAG | VARCHAR2 | (1) | Flag to indicate if the event has been initiated |
Cut, paste (and edit) the following text to query this object:
SELECT BILLING_EVENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, K_HEADER_ID
, K_LINE_ID
, DELIVERABLE_ID
, BILL_EVENT_DATE
, BILL_EVENT_TYPE
, PA_EVENT_ID
, BILL_ITEM_ID
, BILL_LINE_ID
, BILL_CHG_REQ_ID
, BILL_PROJECT_ID
, BILL_TASK_ID
, BILL_ORGANIZATION_ID
, BILL_FUND_REF1
, BILL_FUND_REF2
, BILL_FUND_REF3
, BILL_BILL_OF_LADING
, BILL_SERIAL_NUM
, BILL_CURRENCY_CODE
, BILL_RATE_TYPE
, BILL_RATE_DATE
, BILL_EXCHANGE_RATE
, BILL_DESCRIPTION
, BILL_QUANTITY
, BILL_UNIT_PRICE
, REVENUE_AMOUNT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INITIATED_FLAG
FROM OKE.OKE_K_BILLING_EVENTS;
OKE.OKE_K_BILLING_EVENTS does not reference any database object
OKE.OKE_K_BILLING_EVENTS is referenced by following:
|
|
|