OSS_CHARGE_PER_ADJUSTMENTS

Details

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

Primary Key

Name	Columns
OSS_CHARGE_PER_ADJUSTMENTS_PK	CHARGE_PERIOD_ADJ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CHARGE_PERIOD_ADJ_ID	NUMBER		18	Yes	Unique identifier of the charge period adjustment,primary key
CHARGE_PERIOD_ADJ_PUID	VARCHAR2	120		Yes	Public unique Identifier of the charge period adjustment
CHARGE_PERIOD_ID	NUMBER		18		Charge period identifier,parent key to oss_charge_periods
CHARGE_ID	NUMBER		18		Charge identifier,foreign key to oss_charges
CHARGE_ADJUSTMENT_ID	NUMBER		18		Charge identifier,foreign key to oss_charges
ADJUSTMENT_NAME	VARCHAR2	120			Name of the charge adjustment
SEQUENCE_NUMBER	NUMBER		9		Sort order of adjusment for the charge period
SUBSCRIPTION_ID	NUMBER		18		Subscription Identifier,foreign key to oss_subscriptions
SUBSCRIPTION_PRODUCT_ID	NUMBER		18		Product Identifier,foreign key to oss_products
PRODUCT_ASSOCIATION_ID	NUMBER		18		Product Association identifier,foreign key to oss_product_association
CHARGE_PERIOD	NUMBER				Charge period sequence number
NET_PRICE_BASIS	NUMBER				Amount used for computing percentage adjustment when adjustment basis selected is Net price
ADJ_PERIOD_FACTOR	NUMBER				Multiplier used if adjustment is applied only for a portion of the charge period
ADJUSTMENT_AMOUNT	NUMBER				Adjustment amount computed for the charge period adjustment
NET_PRICE	NUMBER				Net price after applying current adjustment to the charge period
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.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
OSS_CHARGE_PER_ADJUSTMENTS_U1	Unique	Default	CHARGE_PERIOD_ADJ_ID
OSS_CHARGE_PER_ADJUSTMENTS_U2	Unique	Default	CHARGE_PERIOD_ADJ_PUID