Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
adjust_time_to_fit_under_cap | VARCHAR2 | 1 | Adjust time to fit under cap | ||||
billing_rate_card_id | NUMBER | 39 | 0 |
billing_rate_card_id |
Billing_rate_cards |
Billing rate card ID | |
cap_hours | NUMBER | 12 | 5 | Cap hours | |||
cap_money | NUMBER | 20 | 2 | Cap money | |||
cap_type | VARCHAR2 | 5 | Cap type | ||||
charge_rule_id | NUMBER | 39 | 0 | Charge rule ID | |||
charge_rule_type | VARCHAR2 | 32 | Charge rule type | ||||
charge_stage | VARCHAR2 | 32 | Charge stage | ||||
date_created | TIMESTAMP | Date created | |||||
date_last_modified | TIMESTAMP | Date last modified | |||||
description | VARCHAR2 | 4000 | Description | ||||
dont_bill_entry_exceeding_cap | VARCHAR2 | 1 | Don't bill entry exceeding cap | ||||
end_date | TIMESTAMP | End date | |||||
external_id | VARCHAR2 | 255 | External ID | ||||
form_template | NUMBER | 39 | 0 | Form template | |||
project_id | NUMBER | 39 | 0 | Project ID | |||
rate_multiplier | NUMBER | 12 | 3 | Rate multiplier | |||
rate_source | VARCHAR2 | 10 | Rate source | ||||
rounding | VARCHAR2 | 10 | Rounding | ||||
rule_name | VARCHAR2 | 200 | Rule name | ||||
rule_order | NUMBER | 39 | 0 | Rule order | |||
sale_unit_id | NUMBER | 39 | 0 | Sale unit ID | |||
saved_search | NUMBER | 39 | 0 | Saved search | |||
start_date | TIMESTAMP | Start date | |||||
time_based_charge_rule_id | NUMBER | 39 | 0 | Time based charge rule ID | |||
units_type_id | NUMBER | 39 | 0 | Units type ID |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
time_based_charge_rules_billing_rate_cards_fk | billing_rate_card_id | Billing_rate_cards | billing_rate_card_id | 1 |