Project_revenue_rules

Columns

Name	Type	Length	Precision	Scale	References	In	Description
billing_rate_card_id	NUMBER		39	0	billing_rate_card_id	Billing_rate_cards	Billing rate card ID
created_by	NUMBER		39	0	employee_id	Employees	Created by
date_created	TIMESTAMP						Date created
date_last_modified	TIMESTAMP						Date last modified
description	VARCHAR2	4000					Description
fixed_amount_type	VARCHAR2	20					Fixed amount type
fixed_schedule_type	VARCHAR2	10					Fixed schedule type
is_inactive	VARCHAR2	3					Is inactive
is_revenue_reconciled	VARCHAR2	3					Is revenue reconciled
last_modified_by	NUMBER		39	0	employee_id	Employees	Last modified by
project_id	NUMBER		39	0	customer_id	Customers	Project ID
project_revenue_rule_extid	VARCHAR2	255					Project revenue rule external ID
project_revenue_rule_id	NUMBER		39	0			Project revenue rule internal ID
rate_multiplier	NUMBER		12	3			Project billing rate multiplier
rate_source_type_id	VARCHAR2	10					Project billing rate source type ID
recurrence_end_date	TIMESTAMP						Project billing recurrence end date
recurrence_frequency	VARCHAR2	4000					Project billing recurrence frequency
recurrence_period	NUMBER		39	0			Project billing recurrence period
recurrence_start_date	TIMESTAMP						Project billing recurrence start date
rounding_type_id	VARCHAR2	10					Project billing rounding type ID
rule_name	VARCHAR2	200					Charge rule name
rule_type_id	VARCHAR2	20					Charge rule type ID
saved_search_id	NUMBER		39	0			Saved search ID
service_item_id	NUMBER		39	0	item_id	Service_items	Service item ID

Primary key

PK Column Name
project_revenue_rule_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
project_revenue_rules_billing_rate_cards_fk	billing_rate_card_id	Billing_rate_cards	billing_rate_card_id	1
project_revenue_rules_customers_fk	project_id	Customers	customer_id	1
project_revenue_rules_employees_fk_1	created_by	Employees	employee_id	1
project_revenue_rules_employees_fk_2	last_modified_by	Employees	employee_id	1
project_revenue_rules_service_items_fk	service_item_id	Service_items	item_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Project_revenue_rl_plans_project_revenue_rules_fk	project_revenue_rule_id	Project_revenue_rl_plans	project_revenue_rule_id	1
Project_revenue_rls_charge_rls_project_revenue_rules_fk	project_revenue_rule_id	Project_revenue_rls_charge_rls	project_revenue_rule_id	1