| 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 |