Purchase_charge_rules
This table contains data related to purchase charge rules, which is a type of rule used to generate billable charges from projects.
This table’s data is available only to accounts that use both Charge-Based Billing and Project Management.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| cap |
NUMBER |
|
12 |
3 |
|
|
Maximum Charge |
| charge_rule_id |
NUMBER |
|
39 |
0 |
|
|
Internal Purchase Charge Rule ID |
| charge_rule_type_id |
VARCHAR2 |
32 |
|
|
|
|
Rule Type |
| charge_stage_id |
VARCHAR2 |
32 |
|
|
|
|
Default Charge Stage |
| date_created |
TIMESTAMP |
|
|
|
|
|
Date Created |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date Last Modified |
| description |
VARCHAR2 |
4000 |
|
|
|
|
Description |
| mark_up_item_id |
NUMBER |
|
39 |
0 |
item_id
|
Items
|
Mark-up Item |
| project_id |
NUMBER |
|
39 |
0 |
customer_id
|
Customers
|
Project ID |
| purchase_charge_rule_extid |
VARCHAR2 |
255 |
|
|
|
|
Purchase Charge Rule ID |
| purchase_saved_search_id |
NUMBER |
|
39 |
0 |
|
|
Transaction Filter ID |
| rate_multiplier |
NUMBER |
|
12 |
3 |
|
|
Rate Multiplier |
| rule_name |
VARCHAR2 |
200 |
|
|
|
|
Rule Name |
| rule_order |
NUMBER |
|
39 |
0 |
|
|
Rule Order |
Primary key
| PK Column Name |
| charge_rule_id |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| purchase_charge_rules_customers_fk |
project_id |
Customers |
customer_id |
1 |
| purchase_charge_rules_items_fk |
mark_up_item_id |
Items |
item_id |
1 |