Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
billing_rate_card_extid | VARCHAR2 | 255 | Billing rate card external ID | ||||
billing_rate_card_id | NUMBER | 39 | 0 | Billing rate card ID | |||
customer_id | NUMBER | 39 | 0 |
customer_id |
Customers |
||
date_created | TIMESTAMP | Date created | |||||
date_last_modified | TIMESTAMP | Date last modified | |||||
is_inactive | VARCHAR2 | 3 | Is inactive | ||||
name | VARCHAR2 | 100 | Name |
PK Column Name |
---|
billing_rate_card_id |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
billing_rate_cards_customers_fk | customer_id | Customers | customer_id | 1 |
FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
---|---|---|---|---|
Billing_rate_cards_prices_billing_rate_cards_fk | billing_rate_card_id | Billing_rate_cards_prices | billing_rate_card_id | 1 |
Customers_billing_rate_cards_fk | billing_rate_card_id | Customers | billing_rate_card_id | 1 |
Project_revenue_rules_billing_rate_cards_fk | billing_rate_card_id | Project_revenue_rules | billing_rate_card_id | 1 |
Project_templates_billing_rate_cards_fk | billing_rate_card_id | Project_templates | template_id | 1 |
Time_based_charge_rules_billing_rate_cards_fk | billing_rate_card_id | Time_based_charge_rules | billing_rate_card_id | 1 |