RCL_SERVICE_CHARGES

Details

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

Primary Key

Name	Columns
RCL_SERVICE_CHARGES_PK	SERVICE_CHARGE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SERVICE_CHARGE_ID	NUMBER		18	Yes	Unique identifier and primary key of the service charge business object
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.
CHARGE_DEFINITION_CODE	VARCHAR2	30		Yes	A charge definition is a combination of Price Type, Charge Type, Charge SubType. Combination of these three attributes is represented as a single code.
CHARGE_TYPE_CODE	VARCHAR2	30		Yes	Type of a given charge. Charge Types could include Goods Sale, Service Sale, Financing vs. Lease, Shipping-related Charges, Restocking Penalties, Special Charges.
CHARGE_SUBTYPE_CODE	VARCHAR2	30		Yes	Subtype of a given charge type. Examples may include the following: Within Shipping Related Charges - Freight Charge, Shipping Insurance. Within Special Charges - Suspend Charge, Resumption Charge.
PRICE_TYPE_CODE	VARCHAR2	30		Yes	Price type of a given charge. One-time, Recurring, Usage, Recurring usage.
CHARGE_CURRENCY_CODE	VARCHAR2	15		Yes	Indicates the currency used for the charge.
GSA_UNIT_PRICE	NUMBER				Unit price amount derived from a matching GSA price list on the strategy for the current transaction.
PARENT_ENTITY_CODE	VARCHAR2	30			Code of the parent entity of the charge.
PARENT_ENTITY_ID	NUMBER		18		Identifier of the parent entity of the charge.
PRICED_QUANTITY	NUMBER				The pricing quantity.
PRICED_QUANTITY_UOM_CODE	VARCHAR2	3			The pricing quantity Unit of Measure.
PRIMARY_FLAG	VARCHAR2	1		Yes	Indicates whether this charge is the primary charge.
SEQUENCE_NUMBER	NUMBER		18	Yes	Indicates the sequence for the charge.
CHARGE_APPLIES_TO	VARCHAR2	30		Yes	Indicates whether a charge is applied to product, shipping or return.
ROLLUP_FLAG	VARCHAR2	1		Yes	Marks a charge as a rollup/aggregate charge
PRICE_PERIODICITY_CODE	VARCHAR2	30			Indicates periodicity for both recurring and recurring usage price types such as Month, Year, Quarter.
SOURCE_CHARGE_ID	VARCHAR2	50			The unique internal identifier for the charge assigned by the system that captured the transaction.
AVG_UNIT_SELLING_PRICE	NUMBER				This reflects the weighted average selling price: total sales revenue divided by total units sold.
REFERENCE_ORDER_CHARGE_ID	NUMBER		18		Used by change mgmt to associate the change order's charge id with the original order's charge id.
DELTA_TYPE	NUMBER		18		Internal column used by change processing framework for tracking types of change such as update, cancel, etc.
MODIFIED_FLAG	VARCHAR2	1			Indicates that the row has been modified in the current submitted version.
CAN_ADJUST_FLAG	VARCHAR2	1		Yes	Defines if the charge is eligible for adjustment.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
RCL_SERVICE_CHARGES	rcl_debrief_lines	PARENT_ENTITY_ID
rcl_service_charge_components	rcl_service_charges	SERVICE_CHARGE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
RCL_SERVICE_CHARGES_FK1	Non Unique	Default	PARENT_ENTITY_ID
RCL_SERVICE_CHARGES_U1	Unique	Default	SERVICE_CHARGE_ID