Billing_rate_cards_prices

Columns

Name	Type	Length	Precision	Scale	References	In	Description
billing_class_id	NUMBER		39	0	billing_class_id	Billing_classes	Billing class ID
billing_rate_card_id	NUMBER		39	0	billing_rate_card_id billing_rate_card_id	Billing_rate_cards Billing_rate_cards_versions	Billing rate card ID
currency_id	NUMBER		39	0	currency_id	Currencies	Currency ID
sale_unit_id	NUMBER		39	0	uom_id	Uom	Sale unit ID
service_item_id	NUMBER		39	0	item_id	Items
unit_price	NUMBER		39	0			Unit price
units_type_id	NUMBER		39	0	units_type_id	Units_type	Units type ID
version_0	NUMBER		39	0	version_0	Billing_rate_cards_versions	Version 0

Primary key (Composite)

PK Column Name
billing_rate_card_id
billing_class_id
currency_id
version_0

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
billing_rate_cards_prices_billing_classes_fk	billing_class_id	Billing_classes	billing_class_id	1
billing_rate_cards_prices_billing_rate_cards_fk	billing_rate_card_id	Billing_rate_cards	billing_rate_card_id	1
billing_rate_cards_prices_billing_rate_cards_versions_fk	billing_rate_card_id	Billing_rate_cards_versions	billing_rate_card_id	1
billing_rate_cards_prices_billing_rate_cards_versions_fk	version_0	Billing_rate_cards_versions	version_0	2
billing_rate_cards_prices_currencies_fk	currency_id	Currencies	currency_id	1
billing_rate_cards_prices_items_fk	service_item_id	Items	item_id	1
billing_rate_cards_prices_units_type_fk	units_type_id	Units_type	units_type_id	1
billing_rate_cards_prices_uom_fk	sale_unit_id	Uom	uom_id	1