Billing_rate_cards

Columns

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

Primary key

PK Column Name
billing_rate_card_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
billing_rate_cards_customers_fk customer_id Customers customer_id 1

Foreign keys referencing this table

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