Time_based_charge_rules

Columns

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

Foreign keys in this table

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