[Home] [Help] [Dependency Information]
Object Name: | OKS_BCL_PR |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_BCL_PR |
Subobject Name: | |
Status: | VALID |
This stores the billing transactions for the contract lines. This table is populated from 'Service Contracts Main Billing' concurrent program, when executed in preview mode. Each record includes start date, end date, amount charged and billing type as 'RI' -invoice. The information in this record is used to generate custom report.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_BCL_PR_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKS_BCL_PR_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CLE_ID
DATE_BILLED_FROM BILL_ACTION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Surrogate key used for primary unique identifiers. | |
CLE_ID | NUMBER | Yes | Contract line ID. References OKC_K_LINES_B.ID. | |
BTN_ID | NUMBER | Bill Transaction line ID. References OKS_BTN_PR.ID. | ||
DATE_BILLED_FROM | DATE | Yes | Stores the start date of billing period. For regular invoice, main billing program populates the column from OKS_LEVEL_ELEMENTS.DATE_START. | |
DATE_BILLED_TO | DATE | Yes | Stores the end date of billing period. For regular invoice, main billing program populates the column from OKS_LEVEL_ELEMENTS.DATE_END. | |
SENT_YN | VARCHAR2 | (3) | Yes | Not used. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | ID of the user whom created the record. |
CREATION_DATE | DATE | Yes | Date the record was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | ID of the last user who updated the record. |
LAST_UPDATE_DATE | DATE | Yes | Date the record was last updated. | |
AMOUNT | NUMBER | (17) | Stores the billing amount for a period associated with the contract line. This is the total of all sub lines from OKS_BSL_PR table | |
BILL_ACTION | VARCHAR2 | (9) | Stores billing transaction type. Valid value is Regular Invoice -RI | |
DATE_NEXT_INVOICE | DATE | Not used. | ||
CURRENCY_CODE | VARCHAR2 | (15) | Contract Currency Code. References OKC_K_HEADERS_B.CURRENCY_CODE | |
LAST_UPDATE_LOGIN | NUMBER | (15) | OS ID of the user who last updated the record. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended). | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield | |
SECURITY_GROUP_ID | NUMBER | Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete. | ||
AVERAGED_YN | VARCHAR2 | (1) | Not Used | |
SETTLED_YN | VARCHAR2 | (1) | Not Used |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CLE_ID
, BTN_ID
, DATE_BILLED_FROM
, DATE_BILLED_TO
, SENT_YN
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, AMOUNT
, BILL_ACTION
, DATE_NEXT_INVOICE
, CURRENCY_CODE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, AVERAGED_YN
, SETTLED_YN
FROM OKS.OKS_BCL_PR;
OKS.OKS_BCL_PR does not reference any database object
OKS.OKS_BCL_PR is referenced by following:
|
|
|