DBA Data[Home] [Help] [Dependency Information]

TABLE: CS.CS_BILLING_TYPE_CATEGORIES

Object Details
Object Name: CS_BILLING_TYPE_CATEGORIES
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_BILLING_TYPE_CATEGORIES
Subobject Name:
Status: VALID


This table defines the mapping between the extensible billing types and the parent billing category of 'M', 'L', and 'E'.
This table also defines the rollup item to be used for each billing type.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BILLING_TYPE VARCHAR2 (30) Yes Billing Type to be mapped.
BILLING_CATEGORY VARCHAR2 (30) Yes BIlling Category that billng type is being mapped to.
ROLLUP_ITEM_ID NUMBER

Inventory Item to be used when rolling up charge lines of this billing type.
START_DATE_ACTIVE DATE

Starting date for the period that this mapping is active.
END_DATE_ACTIVE DATE

Ending date for the period that this mapping is active.
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SEEDED_FLAG VARCHAR2 (1)
Seeded Flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BILLING_TYPE
,      BILLING_CATEGORY
,      ROLLUP_ITEM_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      SEEDED_FLAG
FROM CS.CS_BILLING_TYPE_CATEGORIES;

Dependencies

[top of page]

CS.CS_BILLING_TYPE_CATEGORIES does not reference any database object

CS.CS_BILLING_TYPE_CATEGORIES is referenced by following:

SchemaAPPS
SynonymCS_BILLING_TYPE_CATEGORIES