| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| date_last_modified | TIMESTAMP | Date last modified (GMT) | |||||
| discount_percentage | NUMBER | 5 | 2 | Markup/discount % | |||
| isinactive | VARCHAR2 | 3 | Inactive | ||||
| isonline | VARCHAR2 | 3 | Is online | ||||
| name | VARCHAR2 | 60 | Name | ||||
| price_type_extid | VARCHAR2 | 255 | Price type external ID | ||||
| price_type_id | NUMBER | 39 | 0 | Price type ID |
| PK Column Name |
|---|
| price_type_id |
| FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
|---|---|---|---|---|
| Employee_time_price_types_fk | price_type_id | Employee_time | price_type_id | 1 |
| Item_billing_rates_price_types_fk | price_type_id | Item_billing_rates | item_price_id | 1 |
| Item_price_history_price_types_fk | price_type_id | Item_price_history | price_type_id | 1 |
| Opportunity_lines_price_types_fk | price_type_id | Opportunity_lines | price_type_id | 1 |