PJB_BILLING_CONTROLS

Details

Schema: FUSION
Object owner: PJB
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
PJB_BILLING_CONTROLS_PK	BILLING_CONTROL_ID, MAJOR_VERSION

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BILLING_CONTROL_ID	NUMBER		18	Yes	BILLING_CONTROL_ID *****
RBS_ELEMENT_ID	NUMBER		18		RBS_ELEMENT_ID *****
CONTRACT_ID	NUMBER		18	Yes	CONTRACT_ID *****
CONTRACT_LINE_ID	NUMBER		18		CONTRACT_LINE_ID *****
MAJOR_VERSION	NUMBER		18	Yes	MAJOR_VERSION *****
VERSION_TYPE	VARCHAR2	1		Yes	VERSION_TYPE *****
START_DATE	DATE			Yes	START_DATE *****
END_DATE	DATE				END_DATE *****
SOFT_LIMIT_AMOUNT	NUMBER				SOFT_LIMIT_AMOUNT *****
HARD_LIMIT_AMOUNT	NUMBER				HARD_LIMIT_AMOUNT *****
ITD_INVOICE_AMOUNT	NUMBER				ITD_INVOICE_AMOUNT *****
ITD_REVENUE_AMOUNT	NUMBER				ITD_REVENUE_AMOUNT *****
DEFAULT_FLAG	VARCHAR2	1			DEFAULT_FLAG *****
ACTIVE_FLAG	VARCHAR2	1			ACTIVE_FLAG *****
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
EXTERNAL_KEY1	VARCHAR2	150			External key that uniquely identifies a record.
EXTERNAL_KEY2	VARCHAR2	150			Additional attribute to qualify external key.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJB_BILLING_CONTROLS	okc_k_headers_all_b	CONTRACT_ID, MAJOR_VERSION
PJB_BILLING_CONTROLS	okc_k_lines_b	CONTRACT_LINE_ID, MAJOR_VERSION
PJB_BILLING_CONTROLS	pjf_rbs_elements	RBS_ELEMENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJB_BILLING_CONTROLS_N2	Non Unique	Default	CONTRACT_ID
PJB_BILLING_CONTROLS_N3	Non Unique	Default	CONTRACT_LINE_ID
PJB_BILLING_CONTROLS_U1	Unique	Default	BILLING_CONTROL_ID, MAJOR_VERSION
PJB_BILLING_CONTROLS_U2	Unique	Default	EXTERNAL_KEY1, EXTERNAL_KEY2