[Home] [Help] [Dependency Information]
Object Name: | OKS_BSL_PR |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_BSL_PR |
Subobject Name: | |
Status: | VALID |
This table stores the billing information for the contract sub lines and is populated from 'Service Contracts Main Billing' concurrent program, when executed in preview mode. Each row includes start date of the billing period, end date of the billing period, amount charged. The information on this record is used to generate custom report.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_BSL_PR_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKS_BSL_PR_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLE_ID |
OKS_BSL_PR_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BCL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Bill Sub Line Identifier | |
BCL_ID | NUMBER | ID of contract line billing record. References OKS_BILL_CONT_LINES.ID | ||
CLE_ID | NUMBER | Yes | Contract line ID. References OKC_K_LINES_B.ID. | |
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. | |
AVERAGE | NUMBER | (15) | Not used. | |
AMOUNT | NUMBER | (17) | Stores the billing amount for that period associated with sub line. This column is populated from OKS_LEVEL_ELEMENTS.AMOUNT for all sub lines except for usage lines of type 'Fixed per period', 'Actual by quantity' and 'Actual per period', is derived from pricing engine. | |
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. | |
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. | ||
DATE_TO_INTERFACE | DATE | Not used | ||
MANUAL_CREDIT | NUMBER | Obsolete. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, BCL_ID
, CLE_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, AVERAGE
, AMOUNT
, DATE_BILLED_FROM
, DATE_BILLED_TO
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, DATE_TO_INTERFACE
, MANUAL_CREDIT
FROM OKS.OKS_BSL_PR;
OKS.OKS_BSL_PR does not reference any database object
OKS.OKS_BSL_PR is referenced by following:
|
|
|